¬ísrjava.util.VectorÙ—}[€;¯IcapacityIncrementI elementCount[ elementDatat[Ljava/lang/Object;xpur[Ljava.lang.Object;ÎXŸs)lxp(srInfoPurple.Qlet ඳ§cÙTL colDetailstLjava/util/Vector;L qletLocationtLjava/awt/Point;LqletSizetLjava/awt/Dimension;LqpValuesq~LqueryStrtLjava/lang/String;xppppsq~uq~(tGL Validation Month - Endpt100tManualt1440t 1-JAN-1990tYsrjava.awt.Color¥ƒ3uFfalphaIvalueLcstLjava/awt/color/ColorSpace;[ frgbvaluet[F[fvalueq~xpÿfpppsq~ÿÞÞ¸pppsq~ÿÿÿÿpppt1sr java.awt.FontÅ¡5æÌÞVsIfontSerializedDataVersionF pointSizeIsizeIstyleLfRequestedAttributestLjava/util/Hashtable;Lnameq~ xpA@ ptArialxsq~ÿpppt18q~sq~ÿùù×pppsq~A@ ptArialxsq~ÿ––lpppt dd-MMM-yyyyt ##########tq0q~sq~A@ pq~xq~tappst No_PatterntVLETsq~ÿÿÿÿpppq~t XXGL_FINANCEsrInfoPurple.DashboardSettings ඳ§cÛ¬I currPletIdxI currQletIdxxp;pppppppppxpsrInfoPurple.Plet ඳ§cÚäL pletLocationq~LpletSizeq~LppValuesq~LqueryStrq~ xpsrjava.awt.Point¶ÄŠr4~È&IxIyxpÄsrjava.awt.DimensionAŽÙ׬_DIheightIwidthxp2£sq~uq~t Set of BookssrdbUtil.dbInstance ඳ§cØðLdbDriverq~ L dbPasswordq~ LdbURLq~ LdbUserq~ xptoracle.jdbc.driver.OracleDrivertappst OCSUN209.us.oracle.com:1521:sboxtappstALLtnametgsob.set_of_books_idtgsob.chart_of_accounts_idtgsob.period_set_nametgsob.currency_codet+fav.application_column_name account_segmentsrInfoPurple.PletValue ඳ§cÛHL descriptionq~ L displayValueq~ Lid1q~ Lid2q~ Lid3q~ Lid4q~ Lid5q~ L internalValueq~ xpptVision Distribution (SNG)t21t50195t AccountingtSGDtSEGMENT3psq~ÿøú¬pppsq~ÿpppsq~A@ ptArialxtappstNONEtPLETtp0tNtNpxtÐfrom FND_SEGMENT_ATTRIBUTE_VALUES fav, gl_sets_of_books gsob where fav.id_flex_code='GL#' and fav.id_flex_num=gsob.chart_of_accounts_id and fav.attribute_value='Y' and fav.segment_attribute_type='GL_ACCOUNT' sq~/sq~1sq~32dsq~uq~tCurrencyq~9tALLt currency_codet'ID1't'ID2't'ID3't'ID4't'ID5'sq~EptUSDtID1tID2tID3tID4tID5psq~ÿÀæ³pppsq~ÿpppsq~A@ pq~PxtappstNONEtPLETtp7tNtNpxtXfrom gl_sets_of_books where set_of_books_id = G_PARAM/*gsob.set_of_books_id*/ sq~/sq~1gsq~32‰sq~uq~tChart of Accountsq~9t20t segment_nametapplication_column_namet segment_numtflex_value_set_idt'ID4't'ID5'sq~EptCompanytSEGMENT1t1t1002470tID4tID5psq~ÿܽçpppsq~ÿpppsq~A@ pq~PxtappstNONEtPLETtp2tNtNpxt†FROM fnd_id_flex_segments where id_flex_code='GL#' and enabled_flag='Y' and id_flex_num= G_PARAM/*chart_of_accounts_id*/ sq~/sq~1ñsq~32®sq~uq~t Segment Valueq~9tALLtflex_value||' - '||descriptiont flex_value_idt flex_valuet'NA't'ID4't'ID5'sq~Ept ALL Valuest%q~£q~£q~£tALLpsq~ÿüÉÉpppsq~ÿpppsq~A@ pq~PxtappstNONEtPLETtp4tYtNpxtYfrom fnd_flex_values_vl where flex_value_set_id = G_PARAM/*flex_value_set_id*/ sq~/sq~1Ÿsq~32dsq~uq~tPeriodq~9tALLt period_namet!to_char(start_Date,'DD-MON-YYYY')tto_char(end_date,'DD-MON-YYYY')t period_numt quarter_numt&to_char(year_start_date,'DD-MON-YYYY')sq~EptJan-03t 01-JAN-2003t 31-JAN-2003t1t1t 01-JAN-2003psq~ÿùÛšpppsq~ÿpppsq~A@ pq~PxtappstNONEtPLETtp3tNtNpxthFROM gl_periods where period_set_name = 'G_PARAM' /*period_set_name*/ order by period_num desc sq~sq~uq~ srInfoPurple.ColumnPropertyValues ඳ§cÙ¸L colPropValuesq~L drillValuesq~L parentQlettLInfoPurple/Qlet;xpsq~uq~tInfoCaptor Messaget450sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~Øsq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyytYsq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ísq~Ðsq~uq~tCCIDt75q~×q~Øq~Ùt1q~Øq~ÛtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxtCcid pppppxsq~uq~ srInfoPurple.DrillSettings ඳ§cÚL drillColumnsq~L drillNameq~ L drillQletIDq~ xpsq~uq~ q~êt%t%pppppppxtGet Journal Detailstq1pppppppppxq~Íppppppppxsq~10sq~3‹sq~uq~(tUnbalanced GL Linesq~9t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~Ûq~Øt18q~q~ q~!q~#t dd-MMM-yyyyt #########tq55q~Øsq~A@ pq~Üxq~tappst No_PatterntQLETsq~ÿÿÿÿpppq~ØtXXDBNAMEt pppppppppxt åselect b.code_combination_id ccid, b.period_name period, b.currency_code currency, nvl(b.period_net_cr, 0) balances_cr, nvl(b.period_net_dr, 0) balances_dr, sum(nvl(l.accounted_cr, 0)) lines_cr, sum(nvl(l.accounted_dr, 0)) lines_dr from gl.gl_je_headers h , gl.gl_je_lines l , gl.gl_balances b where b.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ and b.period_name = 'G_PARAM' /*period_name*/ and b.actual_flag = 'A' and b.currency_code != 'STAT' and b.currency_code = 'G_PARAM' /*currency_code*/ and l.set_of_books_id = b.set_of_books_id and l.period_name = b.period_name and l.code_combination_id = b.code_combination_id and (b.translated_flag <> 'Y' or b.translated_flag is null) and h.je_header_id = l.je_header_id and h.actual_flag = b.actual_flag and h.currency_code != 'STAT' and h.status = 'P' group by b.code_combination_id, b.period_name, b.currency_code, nvl(b.period_net_cr, 0), nvl(b.period_net_dr, 0) having nvl(b.period_net_cr,0) <> sum(nvl(accounted_cr,0)) or nvl(b.period_net_dr,0) <> sum(nvl(accounted_dr,0)) union --part for foreign currencies select b.code_combination_id ccid, b.period_name period, b.currency_code currency, nvl(b.period_net_cr, 0) balances_cr, nvl(b.period_net_dr, 0) balances_dr, sum(nvl(l.entered_cr, 0)) lines_cr, sum(nvl(l.entered_dr, 0)) lines_dr from gl.gl_je_headers h , gl.gl_je_lines l , gl.gl_balances b where b.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ and b.period_name = 'G_PARAM' /*period_name*/ and b.actual_flag = 'A' and b.currency_code != 'STAT' and b.currency_code != 'G_PARAM' /*currency_code*/ and l.set_of_books_id = b.set_of_books_id and l.period_name = b.period_name and l.code_combination_id = b.code_combination_id and (b.translated_flag <> 'Y' or b.translated_flag is null) and h.je_header_id = l.je_header_id and h.actual_flag = b.actual_flag and h.currency_code = b.currency_code and h.currency_code != 'STAT' and h.status = 'P' group by b.code_combination_id, b.period_name, b.currency_code, nvl(b.period_net_cr, 0), nvl(b.period_net_dr, 0) having nvl(b.period_net_cr,0) <> sum(nvl(entered_cr,0)) or nvl(b.period_net_dr,0) <> sum(nvl(entered_dr,0))sq~sq~uq~ sq~Ðsq~uq~t ACCOUNTED_DRt89sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~sq~A@ ptArialxtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~sq~Ðsq~uq~t ACCOUNTED_CRt94q~q~q~t1q~q~!tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~sq~Ðsq~uq~tGL_ACCOUNT_TYPEt99q~q~q~t1q~q~!tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~sq~Ðsq~uq~t PERIOD_NAMEt92q~q~q~t1q~q~!tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~sq~Ðsq~uq~tACCOUNTt75q~q~q~t1q~q~!tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~sq~Ðsq~uq~t JE_SOURCEt75q~q~q~t1q~q~!tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ sq~ösq~uq~ t%q~kt JE_CATEGORYpppppppxtJournal Detailsq~ýpppppppppxq~sq~Ðsq~uq~q~Õt450q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~pppxsq~1Wsq~3rŽsq~uq~(tJournal Summary by Accountq~9tALLtManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~ q~!q~#q~$q~%tq11q~q~'tNtappst No_PatterntQLETsq~ÿÿÿÿpppq~tXXDBNAMEt pppppppppxtpselect gcc.G_PARAM G_PARAM/*segment_name*/ , jeh.je_source , jeh.je_category , jel.period_name , jeh.currency_code currency , sum(jel.entered_dr) entered_Dr , sum(jel.entered_cr) entered_cr , sum(jel.accounted_dr) accounted_dr , sum(jel.accounted_cr) accounted_cr ,gcc.gl_account_type from gl_je_headers jeh , gl_je_lines jel , gl_code_combinations_kfv gcc where jeh.je_header_id=jel.je_header_id and jel.code_combination_id= gcc.code_combination_id and jel.status='P' and jel.set_of_books_id= G_PARAM/*gsob.set_of_books_id*/ and jel.period_name = 'G_PARAM' /*period_name*/ and jeh.currency_code = 'G_PARAM'/*distinctcurrency_code*/ and gcc.G_PARAM = 'G_PARAM'/*flex_value*/ group by jeh.je_source , jeh.je_category , jel.period_name , jeh.currency_code ,gcc.gl_account_type ,gcc.G_PARAMsq~sq~uq~ sq~Ðsq~uq~t JE_CATEGORYt133sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~§sq~A@ ptArialxtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~žsq~Ðsq~uq~t JE_SOURCEt93q~¦q~§q~¨t1q~§q~ªtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ sq~ösq~uq~ tGL_ACCOUNT_TYPEq~¸t JE_CATEGORYpppppppxtJournal Detailsq~ýpppppppppxq~žsq~Ðsq~uq~t ENTERED_DRt95q~¦q~§q~¨t1q~§q~ªtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~žsq~Ðsq~uq~t ENTERED_CRt96q~¦q~§q~¨t1q~§q~ªtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~žsq~Ðsq~uq~t ACCOUNTED_DRt96q~¦q~§q~¨t1q~§q~ªtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~žsq~Ðsq~uq~t ACCOUNTED_CRt116q~¦q~§q~¨t1q~§q~ªtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~žsq~Ðsq~uq~t PERIOD_NAMEt118q~¦q~§q~¨t1q~§q~ªtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~žpppxsq~1×sq~3Ésq~uq~(t!Journal Category Summary (Posted)q~9tALLtManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~ q~!q~#q~$q~%tq9q~q~'tNtappst No_PatterntQLETsq~ÿÿÿÿpppq~§tXXDBNAMEt pppppppppxtselect jeh.je_source , jeh.je_category , jel.period_name , jeh.currency_code currency , sum(jel.entered_dr) entered_Dr , sum(jel.entered_cr) entered_cr , sum(jel.accounted_dr) accounted_dr , sum(jel.accounted_cr) accounted_cr ,gcc.gl_account_type from gl_je_headers jeh , gl_je_lines jel , gl_code_combinations_kfv gcc where jeh.je_header_id=jel.je_header_id and jel.code_combination_id= gcc.code_combination_id and jel.status='P' and gcc.gl_account_type= 'param' and jel.set_of_books_id= G_PARAM/*gsob.set_of_books_id*/ and jel.period_name = 'G_PARAM' /*period_name*/ and jeh.currency_code = 'G_PARAM'/*distinctcurrency_code*/ group by jeh.je_source , jeh.je_category , jel.period_name , jeh.currency_code ,gcc.gl_account_typesq~sq~uq~sq~Ðsq~uq~tAPPLICATION_COLUMN_NAMEt103sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~1sq~A@ ptArialxtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~t SEGMENT_NAMEt112q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~tAPPLICATION_COLUMN_INDEX_FLAGt112q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~tFLEX_VALUE_SET_IDt119q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~t SEGMENT_NUMt123q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxpq~(sq~Ðsq~uq~tPERIOD_SET_NAMEt115q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~t PERIOD_NAMEt86q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Period Name pppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~t QUARTER_NUMt95q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxpq~(sq~Ðsq~uq~tCONTEXTt25q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~tYEAR_START_DATEt88q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxpq~(sq~Ðsq~uq~t PERIOD_NET_DRt112q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~t PERIOD_NET_CRt99q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~t DESCRIPTIONt131q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Description pppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~t LOOKUP_TYPEt166q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~t JE_CATEGORYt73q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Je Category pppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~tInfoCaptor Messaget489q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxtInfocaptor Message pppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~t JE_LINE_NUMt75q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Je Line Num pppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~tACCOUNTt86q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxtAccount pppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~tSL_VIEWt20q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxtSl View pppppxsq~uq~ ppppppppppxq~(sq~Ðsq~uq~tJOURNAL_HEADERt124q~0q~1q~2t1q~1q~4tNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxtJournal Header pppppxsq~uq~ sq~ösq~uq~ q~;t JE_HEADER_IDt JE_LINE_NUMpppppppxtSubledger Transactionstq10pppppppppxq~(xsq~1Ùsq~3¥§sq~uq~(tJournal Details (Posted)q~9tALLtManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~ q~!q~#q~$q~%q~ýq~q~'tNtappst No_PatterntQLETsq~ÿÿÿÿpppq~1tXXDBNAMEq~pppppppppxt 5select jeh.name journal_header , jeh.description , jeh.je_header_id , jel.je_line_num , jel.entered_dr , jel.entered_cr , jel.accounted_dr , jel.accounted_cr , jeh.je_source , jeh.je_category , jel.description line_desc , jel.period_name , jeh.currency_code currency , gcc.concatenated_segments account , (case when jeh.je_category in ('Sales Invoices', 'Credit Memos', 'Credit Memo Applications', 'Debit Memos', 'Chargebacks') then 'AR_AEL_GL_INV_V' when jeh.je_category in ('Misc Receipts', 'Trade Receipts', 'Rate Adjustments', 'Cross Currency') then 'AR_AEL_GL_REC_ALL_V' when jeh.je_category = 'Adjustment' then 'AR_AEL_GL_ADJ_V' when jeh.je_category in ('Remittance', 'Write-off', 'Conformation', 'Rejection', 'Bank Receipts', 'Banks Charges') then 'JL_BR_AR_BT_AEL_GL_V' when jeh.je_category in ('Purchase Invoices') then 'AP_AEL_GL_INV_V' when jeh.je_category in ('Payments', 'Cross Currency', 'Reconciled Payments' ) then 'AP_AEL_GL_PAY_V' when jeh.je_category in ('Labor Cost', 'Miscellaneous Transaction', 'Total Burdened Cost', 'Usage Cost' ) then 'PA_AEL_GL_EI_V' when jeh.je_category ='Revenue' then 'PA_AEL_GL_DR_V' when jeh.je_Category = 'MTL' then 'CST_AEL_GL_INV_V' when jeh.je_Category = 'WIP' then 'CST_AEL_GL_WIP_V' when jeh.je_Category in ('Purchasing', 'Periodic Inventory' ) then 'RCV_AEL_GL_V' when jeh.je_Category = 'Requisitions' then 'REQ_ENC_AEL_GL_V' when jeh.je_Category = 'Purchases' then 'PO_ENV_AEL_GL_V' when jeh.je_source = 'Periodic Inventory' and jeh.je_source in ('Receiving', 'Accrual') then 'CST_PAC_AEL_GL_INV_V' when jeh.je_source ='Assets' and jeh.je_Category = 'Globalization' then 'JL_CO_FA_AEL_GL_V' when jeh.je_source='Assets' and jeh.je_category <> 'Globalization' then 'FA_AEL_GL_V' when jeh.je_Category in ('Settlement', 'Claims', 'Deductions') then 'OZF_AEL_GL_CLA_V' when jeh.je_Category in ('Fixed Budgets', 'Accrual Budgets') then 'OZF_AEL_GL_UTL_V' when jeh.je_Category = 'Expense' then 'PN_AEL_PAY_GL_V' when jeh.je_Category = 'Revenue' then 'PN_AEL_BILL_GL_V' when jeh.je_Category = 'Termination' then 'OKL_AEL_GL_QTE_V' when jeh.je_Category = 'Asset Deposition' then 'OKL_AEL_GL_AST_V' when jeh.je_Category in ('Booking', 'Rebook', 'Renewal', 'Release', 'Reverse', 'Syndication') then 'OKL_AEL_GL_CTR_V' when jeh.je_Category in ('Loss Provision', 'Adjustment', 'Lease Accrual', 'Miscellaneous') then 'OKL_AEL_GL_TRX_V' when jeh.je_category in ('Oracle Loans') then 'LNS_AEL_GL_V' else 'gl_import_references' end) sl_view from gl_je_headers jeh , gl_je_lines jel , gl_code_combinations_kfv gcc where jeh.je_header_id=jel.je_header_id and jel.code_combination_id= gcc.code_combination_id and jel.code_combination_id= param and jel.status='P' and jel.set_of_books_id= G_PARAM/*gsob.set_of_books_id*/ and jel.period_name = 'G_PARAM' /*period_name*/ and jeh.je_source like 'param' and jeh.je_category like 'param' and jeh.currency_code = 'G_PARAM' /*distinctcurrency_code*/ sq~sq~uq~ sq~Ðsq~uq~q~Õt450sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~vsq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~nsq~Ðsq~uq~tSegment w/Overlapping Childrent85q~uq~vq~wt1q~vq~ytNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxtSegment W/overlapping Children pppppxsq~uq~ ppppppppppxq~nppppppppxsq~1sq~3Ýsq~uq~(tFind overlapping segment valuesq~9t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~yq~vt18q~œq~ q~!q~#t dd-MMM-yyyyt #########tq51q~vsq~A@ pq~zxq~œtappst No_PatterntQLETsq~ÿÿÿÿpppq~vtXXDBNAMEq~pppppppppxtÖSELECT DISTINCT flexset.segment_name, flexset.segment_num, fvh1.parent_flex_value "Segment w/Overlapping Children", SUBSTR(fvh1.child_flex_value_low,1,30) "Overlapping Child Low Value", SUBSTR(fvh1.child_flex_value_high,1,30) "Overlapping Child High Value", SUBSTR(fvh2.child_flex_value_low,1,30) "Overlapped By Child Low Value", SUBSTR(fvh2.child_flex_value_high,1,30) "Overlapped By Child High Value" FROM fnd_flex_value_hierarchies fvh1, fnd_flex_value_hierarchies fvh2, (SELECT idfs.segment_num, idfs.flex_value_set_id, idfs.application_column_name, idfs.segment_name FROM gl_sets_of_books glsob, fnd_id_flex_segments idfs, fnd_flex_value_sets fvs WHERE glsob.chart_of_accounts_id = idfs.id_flex_num AND fvs.flex_value_set_id = idfs.flex_value_set_id AND glsob.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ AND idfs.application_id = 101 AND idfs.id_flex_code = 'GL#') flexset WHERE fvh1.parent_flex_value = fvh2.parent_flex_value AND fvh1.flex_value_set_id = flexset.flex_value_set_id AND fvh1.rowid != fvh2.rowid AND fvh1.flex_value_set_id = fvh2.flex_value_set_id AND NVL(fvh2.CHILD_FLEX_VALUE_LOW,'X') <= NVL(fvh1.CHILD_FLEX_VALUE_HIGH,'X') AND NVL(fvh2.CHILD_FLEX_VALUE_HIGH,'X') >= NVL(fvh1.CHILD_FLEX_VALUE_LOW,'X') ORDER BY flexset.segment_numsq~sq~ uq~ sq~Ðsq~uq~tDEBITt117sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~²sq~A@ ptArialxtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxtDebit pppppxsq~uq~ ppppppppppxq~©sq~Ðsq~uq~tACCOUNTt103q~±q~²q~³t1q~²q~µtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Account.Typepppppxsq~uq~ ppppppppppxq~©sq~Ðsq~uq~tCREDITt104q~±q~²q~³t1q~²q~µtNAtNt9t DD-MON-YYYYq~ásq~A@ ptArialxtCredit pppppxsq~uq~ ppppppppppxq~©sq~Ðsq~uq~t PERIOD_NAMEt62q~±q~²q~³t1q~²q~µtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxtPeriodpppppxsq~uq~ ppppppppppxq~©sq~Ðsq~uq~t ACC_CREDITt46q~±q~²q~³t1q~²q~µtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Acc Credit pppppxsq~uq~ ppppppppppxq~©sq~Ðsq~uq~t CURRENCY_CODEt62q~±q~²q~³t1q~²q~µtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxtCurrencypppppxsq~uq~ ppppppppppxq~©sq~Ðsq~uq~tInfoCaptor Messaget450q~±q~²q~³t1q~²q~µtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxtInfocaptor Message pppppxsq~uq~ ppppppppppxq~©sq~Ðsq~uq~t ACC_DEBITt40sq~ÿûÄŸpppq~²q~t1q~²q~µtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxt Acc Debit pppppxsq~uq~ ppppppppppxq~©sq~Ðsq~uq~tACC_CODEt49q~q~²q~t1q~²q~µtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxt Acc Code pppppxsq~uq~ ppppppppppxq~©pxsq~1>sq~3¯ásq~uq~(tBalance by Account Typeq~9t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~ q~!q~#q~$q~%tq8q~q~'tYtappst No_PatterntQLETsq~ÿÿÿÿpppq~²tXXDBNAMEq~pppppppppxtÀSELECT glkp.description Account ,bal.currency_code ,bal.period_name , SUM(bal.begin_balance_dr + bal.period_net_dr) balance_debit, SUM(bal.begin_balance_cr + bal.period_net_cr) balance_credit, sum(bal.period_net_dr) period_debit, sum(bal.period_net_cr) period_credit , cck.gl_account_type acc_code FROM gl_balances bal, gl_code_combinations_kfv cck, gl_lookups glkp WHERE bal.code_combination_id = cck.code_combination_id AND bal.actual_flag = 'A' AND bal.set_of_books_id = G_PARAM/*gsob.set_of_books_id*/ AND bal.period_name = 'G_PARAM' /*period_name*/ AND bal.template_id IS NULL AND NVL(bal.translated_flag, 'R') = 'R' and bal.currency_code= 'G_PARAM'/*gsob.currency_code*/ and glkp.lookup_code=cck.gl_account_type and glkp.lookup_type='ACCOUNT TYPE' group by glkp.description , bal.currency_code ,bal.period_name , cck.gl_account_typesq~sq~uq~sq~Ðsq~uq~tPERIOD_SET_NAMEt114sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~Tsq~A@ ptArialxtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxpq~Ksq~Ðsq~uq~t TABLE_NAMEt279q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~tDEBITt112q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ sq~ösq~uq~ t No ParameterspppppppppxtJournal tq5pppppppppxq~Ksq~Ðsq~uq~tCREDITt108q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~t ACC_DEBITt97q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~t ACC_CREDITt93q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~t CURRENCY_CODEt42q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~tCOMPANYt75q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~tACCOUNTt65q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~t PERIOD_NAMEt48q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~tCURRt41q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxtCurr pppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~tPERIODt50q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxtPeriod pppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~tCREDIT_ACTIVITYt73q~Sq~Tq~Ut1q~Tq~WtNAtNt999999t DD-MON-YYYYq~ásq~A@ ptArialxtCredit Activity pppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~q~t450q~Sq~Tq~Ut1q~Tq~WtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxtInfocaptor Message pppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~t Cost Centert75q~Sq~Tq~Ut1q~Tq~WtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~t Sales Channelt75q~Sq~Tq~Ut1q~Tq~WtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~tCompanyt75q~Sq~Tq~Ut1q~Tq~WtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxtCompany pppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~t Departmentt75q~Sq~Tq~Ut1q~Tq~WtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxt Department pppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~tAccountt75q~Sq~Tq~Ut1q~Tq~WtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxtAccount pppppxsq~uq~ ppppppppppxq~Ksq~Ðsq~uq~t Sub-Accountt75sq~ÿÙ¹úpppq~Tq~Ut1q~Tq~WtNAtNt ##########t dd-MMM-yyyyq~ásq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Kxsq~1 Asq~3©™sq~uq~(tBalance by Segment Valueq~9t1000tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~ q~!q~#q~$q~%q~ƒq~q~'tNtappst No_PatterntQLETsq~ÿÿÿÿpppq~TtXXDBNAMEq~pppppppppxtSELECT cck.G_PARAM "G_PARAM"/*segment_name*/ /*application_column_name*/ ,bal.currency_code Curr ,bal.period_name Period , SUM(bal.begin_balance_dr + bal.period_net_dr) debit_bal, SUM(bal.begin_balance_cr + bal.period_net_cr) credit_bal, SUM( bal.period_net_dr) Debit_activity, SUM(bal.period_net_cr) Credit_activity , cck.gl_account_type FROM gl_balances bal, gl_code_combinations_kfv cck WHERE bal.code_combination_id = cck.code_combination_id AND bal.actual_flag = 'A' AND bal.set_of_books_id = G_PARAM/*gsob.set_of_books_id*/ AND bal.period_name = 'G_PARAM' /*period_name*/ AND bal.template_id IS NULL AND NVL(bal.translated_flag, 'R') = 'R' AND bal.currency_code = 'G_PARAM'/*distinctcurrency_code*/ and cck.G_PARAM like 'G_PARAM'/*flex_value*/ group by cck.G_PARAM /*application_column_name*/ , bal.currency_code ,bal.period_name , cck.gl_account_type srInfoPurple.Glet ඳ§cÜL GletLocationq~LGletSizeq~L colDetailsq~LgpValuesq~LqueryStrq~ xpsq~1 ùsq~3.špsq~uq~tBalance by Account Type Chartq~9t100tPietXtYtManualt1440sq~ÿÛÑÆpppsq~A@ ptArialxsq~ÿpppq~žtg46q~žtappst No_PatterntGletq~ppxt¸SELECT glkp.description Account ,abs(sum(bal.begin_balance_dr + bal.period_net_dr - bal.begin_balance_cr - bal.period_net_cr)) closing_net_bal FROM gl_balances bal, gl_code_combinations_kfv cck, gl_lookups glkp WHERE bal.code_combination_id = cck.code_combination_id AND bal.actual_flag = 'A' AND bal.set_of_books_id = G_PARAM/*gsob.set_of_books_id*/ AND bal.period_name = 'G_PARAM' /*period_name*/ AND bal.template_id IS NULL AND NVL(bal.translated_flag, 'R') = 'R' and bal.currency_code= 'G_PARAM'/*gsob.currency_code*/ and glkp.lookup_code=cck.gl_account_type and glkp.lookup_type='ACCOUNT TYPE' group by glkp.description ppppppppppppppppppppppppppx