[Home] [Help]
241: FROM xla_ae_headers aeh
242: ,xla_ae_lines ael
243: ,xla_lookups xlk1
244: ,xla_lookups xlk2
245: ,xla_events xle
246: ,xla_event_types_b xet
247: ,xla_event_classes_tl xect
248: ,xla_event_types_tl xett
249: ,xla_transaction_entities ent
384: FROM xla_ae_headers aeh
385: ,xla_ae_lines ael
386: ,xla_lookups xlk1
387: ,xla_lookups xlk2
388: ,xla_events xle
389: ,xla_event_types_b xet
390: ,xla_event_classes_tl xect
391: ,xla_event_types_tl xett
392: ,xla_transaction_entities ent
590: ,fun_inter_accounts_v fia
591: ,gl_periods glp
592: ,xla_ae_headers aeh
593: ,xla_ae_lines ael
594: ,xla_events xle
595: ,xla_event_types_b xet
596: ,xla_transaction_entities ent
597: ,gl_import_references gir
598: WHERE gjh.je_header_id = gjl.je_header_id
2097: sum(nvl(ael.entered_cr, 0) - nvl(ael.entered_dr, 0))
2098: INTO l_payables_net_cr
2099: FROM xla_ae_headers aeh
2100: ,xla_ae_lines ael
2101: ,xla_events xle
2102: ,xla_event_types_b xet
2103: ,xla_transaction_entities ent
2104: ,gl_import_references gir
2105: ,gl_je_lines gjl
2146: sum(nvl(ael.entered_dr, 0) - nvl(ael.entered_cr, 0))
2147: INTO l_receivables_net_dr
2148: FROM xla_ae_headers aeh
2149: ,xla_ae_lines ael
2150: ,xla_events xle
2151: ,xla_event_types_b xet
2152: ,xla_transaction_entities ent
2153: ,gl_import_references gir
2154: ,gl_je_lines gjl
2198: sum(nvl(ael.entered_cr, 0) - nvl(ael.entered_dr, 0))
2199: INTO l_payables_net_cr
2200: FROM xla_ae_headers aeh
2201: ,xla_ae_lines ael
2202: ,xla_events xle
2203: ,xla_event_types_b xet
2204: ,xla_transaction_entities ent
2205: ,gl_import_references gir
2206: ,gl_je_lines gjl
2246: sum(nvl(ael.entered_dr, 0) - nvl(ael.entered_cr, 0))
2247: INTO l_receivables_net_dr
2248: FROM xla_ae_headers aeh
2249: ,xla_ae_lines ael
2250: ,xla_events xle
2251: ,xla_event_types_b xet
2252: ,xla_transaction_entities ent
2253: ,gl_import_references gir
2254: ,gl_je_lines gjl