252: ,gl_je_sources_tl gjst
253: ,gl_daily_conversion_types gdct
254: ,gl_import_references gir
255: ,gl_je_lines gjl
256: ,gl_je_headers gjh
257: ,gl_je_batches gjb
258: ,gl_periods glp
259: ,xla_subledgers xsrc
260: , ($get_accounts_query$) fun_act
395: ,gl_je_sources_tl gjst
396: ,gl_daily_conversion_types gdct
397: ,gl_import_references gir
398: ,gl_je_lines gjl
399: ,gl_je_headers gjh
400: ,gl_je_batches gjb
401: ,gl_ledger_le_v glv
402: ,fun_inter_accounts_v fia
403: ,gl_periods glp
473: ,NVL(sum(decode(fun_act.acct_type,''P'',(Nvl(gjl.accounted_cr,0)), 0)),0) AP_ACCOUNTED_CR
474: FROM gl_je_categories_tl gjct
475: ,gl_je_sources_tl gjst
476: ,gl_je_lines gjl
477: ,gl_je_headers gjh
478: ,gl_je_batches gjb
479: ,gl_periods glp
480: , ($get_accounts_query$) fun_act
481: WHERE gjh.je_header_id = gjl.je_header_id
532: ,glp.end_date END_DATE
533: FROM gl_je_categories_tl gjct
534: ,gl_je_sources_tl gjst
535: ,gl_je_lines gjl
536: ,gl_je_headers gjh
537: ,gl_je_batches gjb
538: ,gl_ledger_le_v glv
539: ,fun_inter_accounts_v fia
540: ,gl_periods glp
583: ,glp.end_date END_DATE
584: FROM gl_je_categories_tl gjct
585: ,gl_je_sources_tl gjst
586: ,gl_je_lines gjl
587: ,gl_je_headers gjh
588: ,gl_je_batches gjb
589: ,gl_ledger_le_v glv
590: ,fun_inter_accounts_v fia
591: ,gl_periods glp
693: ,gl_je_categories_tl gjct
694: ,gl_je_sources_tl gjst
695: ,gl_daily_conversion_types gdct
696: ,gl_je_lines gjl
697: ,gl_je_headers gjh
698: ,gl_je_batches gjb
699: ,gl_periods glp
700: , ($get_accounts_query$) fun_act
701: WHERE gjh.je_header_id = gjl.je_header_id
785: ,gl_je_categories_tl gjct
786: ,gl_je_sources_tl gjst
787: ,gl_daily_conversion_types gdct
788: ,gl_je_lines gjl
789: ,gl_je_headers gjh
790: ,gl_je_batches gjb
791: ,gl_ledger_le_v glv
792: ,fun_inter_accounts_v fia
793: ,gl_periods glp
2102: ,xla_event_types_b xet
2103: ,xla_transaction_entities ent
2104: ,gl_import_references gir
2105: ,gl_je_lines gjl
2106: ,gl_je_headers gjh
2107: ,gl_je_batches gjb
2108: ,gl_ledger_le_v glv
2109: ,fun_inter_accounts_v fia
2110: ,gl_periods glp
2151: ,xla_event_types_b xet
2152: ,xla_transaction_entities ent
2153: ,gl_import_references gir
2154: ,gl_je_lines gjl
2155: ,gl_je_headers gjh
2156: ,gl_je_batches gjb
2157: ,gl_ledger_le_v glv
2158: ,fun_inter_accounts_v fia
2159: ,gl_periods glp
2203: ,xla_event_types_b xet
2204: ,xla_transaction_entities ent
2205: ,gl_import_references gir
2206: ,gl_je_lines gjl
2207: ,gl_je_headers gjh
2208: ,gl_je_batches gjb
2209: ,gl_ledger_le_v glv
2210: ,fun_inter_accounts_v fia
2211: ,gl_periods glp
2251: ,xla_event_types_b xet
2252: ,xla_transaction_entities ent
2253: ,gl_import_references gir
2254: ,gl_je_lines gjl
2255: ,gl_je_headers gjh
2256: ,gl_je_batches gjb
2257: ,gl_ledger_le_v glv
2258: ,fun_inter_accounts_v fia
2259: ,gl_periods glp