[Home] [Help]
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
250: ,fnd_application_tl fap
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
393: ,fnd_application_tl fap
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
599: AND gjb.je_batch_id = gjh.je_batch_id
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
2106: ,gl_je_headers gjh
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
2155: ,gl_je_headers gjh
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
2207: ,gl_je_headers gjh
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
2255: ,gl_je_headers gjh