[Home] [Help]
250: FROM xla_ae_headers aeh
251: ,xla_ae_lines ael
252: ,xla_lookups xlk1
253: ,xla_lookups xlk2
254: ,xla_events xle
255: ,xla_event_types_b xet
256: ,xla_event_classes_tl xect
257: ,xla_event_types_tl xett
258: ,xla_transaction_entities ent
402: FROM xla_ae_headers aeh
403: ,xla_ae_lines ael
404: ,xla_lookups xlk1
405: ,xla_lookups xlk2
406: ,xla_events xle
407: ,xla_event_types_b xet
408: ,xla_event_classes_tl xect
409: ,xla_event_types_tl xett
410: ,xla_transaction_entities ent
617: ,fun_inter_accounts_v fia
618: ,gl_periods glp
619: ,xla_ae_headers aeh
620: ,xla_ae_lines ael
621: ,xla_events xle
622: ,xla_event_types_b xet
623: ,xla_transaction_entities ent
624: ,gl_import_references gir
625: WHERE gjh.je_header_id = gjl.je_header_id
2203: sum(nvl(ael.entered_cr, 0) - nvl(ael.entered_dr, 0))
2204: INTO l_payables_net_cr
2205: FROM xla_ae_headers aeh
2206: ,xla_ae_lines ael
2207: ,xla_events xle
2208: ,xla_event_types_b xet
2209: ,xla_transaction_entities ent
2210: ,gl_import_references gir
2211: ,gl_je_lines gjl
2252: sum(nvl(ael.entered_dr, 0) - nvl(ael.entered_cr, 0))
2253: INTO l_receivables_net_dr
2254: FROM xla_ae_headers aeh
2255: ,xla_ae_lines ael
2256: ,xla_events xle
2257: ,xla_event_types_b xet
2258: ,xla_transaction_entities ent
2259: ,gl_import_references gir
2260: ,gl_je_lines gjl
2304: sum(nvl(ael.entered_cr, 0) - nvl(ael.entered_dr, 0))
2305: INTO l_payables_net_cr
2306: FROM xla_ae_headers aeh
2307: ,xla_ae_lines ael
2308: ,xla_events xle
2309: ,xla_event_types_b xet
2310: ,xla_transaction_entities ent
2311: ,gl_import_references gir
2312: ,gl_je_lines gjl
2352: sum(nvl(ael.entered_dr, 0) - nvl(ael.entered_cr, 0))
2353: INTO l_receivables_net_dr
2354: FROM xla_ae_headers aeh
2355: ,xla_ae_lines ael
2356: ,xla_events xle
2357: ,xla_event_types_b xet
2358: ,xla_transaction_entities ent
2359: ,gl_import_references gir
2360: ,gl_je_lines gjl