259: ,fnd_application_tl fap
260: ,gl_je_categories_tl gjct
261: ,gl_je_sources_tl gjst
262: ,gl_daily_conversion_types gdct
263: ,gl_import_references gir
264: ,gl_je_lines gjl
265: ,gl_je_headers gjh
266: ,gl_je_batches gjb
267: ,gl_periods glp
411: ,fnd_application_tl fap
412: ,gl_je_categories_tl gjct
413: ,gl_je_sources_tl gjst
414: ,gl_daily_conversion_types gdct
415: ,gl_import_references gir
416: ,gl_je_lines gjl
417: ,gl_je_headers gjh
418: ,gl_je_batches gjb
419: ,gl_ledger_le_v glv
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
627: AND gjb.status = ''P''
628: AND gjct.je_category_name = gjh.je_category
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
2213: ,gl_je_batches gjb
2214: ,gl_ledger_le_v glv
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
2262: ,gl_je_batches gjb
2263: ,gl_ledger_le_v glv
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
2314: ,gl_je_batches gjb
2315: ,gl_ledger_le_v glv
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
2362: ,gl_je_batches gjb
2363: ,gl_ledger_le_v glv