[Home] [Help]
261: ,gl_je_sources_tl gjst
262: ,gl_daily_conversion_types gdct
263: ,gl_import_references gir
264: ,gl_je_lines gjl
265: ,gl_je_headers gjh
266: ,gl_je_batches gjb
267: ,gl_periods glp
268: ,xla_subledgers xsrc
269: ,gl_ledgers gl
413: ,gl_je_sources_tl gjst
414: ,gl_daily_conversion_types gdct
415: ,gl_import_references gir
416: ,gl_je_lines gjl
417: ,gl_je_headers gjh
418: ,gl_je_batches gjb
419: ,gl_ledger_le_v glv
420: ,fun_inter_accounts_v fia
421: ,gl_periods glp
500: ,LTRIM(TO_CHAR(NVL(sum(decode(fun_act.acct_type,''P'',(Nvl(gjl.accounted_cr,0)), 0)),0),''999999999999999999999.999999999999'')) AP_ACCOUNTED_CR
501: FROM gl_je_categories_tl gjct
502: ,gl_je_sources_tl gjst
503: ,gl_je_lines gjl
504: ,gl_je_headers gjh
505: ,gl_je_batches gjb
506: ,gl_periods glp
507: , ($get_accounts_query$) fun_act
508: WHERE gjh.je_header_id = gjl.je_header_id
559: ,glp.end_date END_DATE
560: FROM gl_je_categories_tl gjct
561: ,gl_je_sources_tl gjst
562: ,gl_je_lines gjl
563: ,gl_je_headers gjh
564: ,gl_je_batches gjb
565: ,gl_ledger_le_v glv
566: ,fun_inter_accounts_v fia
567: ,gl_periods glp
610: ,glp.end_date END_DATE
611: FROM gl_je_categories_tl gjct
612: ,gl_je_sources_tl gjst
613: ,gl_je_lines gjl
614: ,gl_je_headers gjh
615: ,gl_je_batches gjb
616: ,gl_ledger_le_v glv
617: ,fun_inter_accounts_v fia
618: ,gl_periods glp
720: ,gl_je_categories_tl gjct
721: ,gl_je_sources_tl gjst
722: ,gl_daily_conversion_types gdct
723: ,gl_je_lines gjl
724: ,gl_je_headers gjh
725: ,gl_je_batches gjb
726: ,gl_periods glp
727: , ($get_accounts_query$) fun_act
728: WHERE gjh.je_header_id = gjl.je_header_id
812: ,gl_je_categories_tl gjct
813: ,gl_je_sources_tl gjst
814: ,gl_daily_conversion_types gdct
815: ,gl_je_lines gjl
816: ,gl_je_headers gjh
817: ,gl_je_batches gjb
818: ,gl_ledger_le_v glv
819: ,fun_inter_accounts_v fia
820: ,gl_periods glp
2208: ,xla_event_types_b xet
2209: ,xla_transaction_entities ent
2210: ,gl_import_references gir
2211: ,gl_je_lines gjl
2212: ,gl_je_headers gjh
2213: ,gl_je_batches gjb
2214: ,gl_ledger_le_v glv
2215: ,fun_inter_accounts_v fia
2216: ,gl_periods glp
2257: ,xla_event_types_b xet
2258: ,xla_transaction_entities ent
2259: ,gl_import_references gir
2260: ,gl_je_lines gjl
2261: ,gl_je_headers gjh
2262: ,gl_je_batches gjb
2263: ,gl_ledger_le_v glv
2264: ,fun_inter_accounts_v fia
2265: ,gl_periods glp
2309: ,xla_event_types_b xet
2310: ,xla_transaction_entities ent
2311: ,gl_import_references gir
2312: ,gl_je_lines gjl
2313: ,gl_je_headers gjh
2314: ,gl_je_batches gjb
2315: ,gl_ledger_le_v glv
2316: ,fun_inter_accounts_v fia
2317: ,gl_periods glp
2357: ,xla_event_types_b xet
2358: ,xla_transaction_entities ent
2359: ,gl_import_references gir
2360: ,gl_je_lines gjl
2361: ,gl_je_headers gjh
2362: ,gl_je_batches gjb
2363: ,gl_ledger_le_v glv
2364: ,fun_inter_accounts_v fia
2365: ,gl_periods glp