[Home] [Help]
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
259: ,fnd_application_tl fap
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
411: ,fnd_application_tl fap
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
626: AND gjb.je_batch_id = gjh.je_batch_id
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
2212: ,gl_je_headers gjh
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
2261: ,gl_je_headers gjh
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
2313: ,gl_je_headers gjh
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
2361: ,gl_je_headers gjh