eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on XLA_AE_LINES

Line 118: from xla_ae_lines ael,

114: and fnm.message_text = jl.description
115: and jl.je_header_id = gljl.je_header_id
116: and jl.je_line_num = gljl.je_line_num)
117: AND not exists (select 1 -- filtering for intercompany lines created in SLA
118: from xla_ae_lines ael,
119: gl_import_references gir
120: where gir.je_header_id = gljl.je_header_id
121: and gir.je_line_num = gljl.je_line_num
122: and gir.gl_sl_link_id = ael.gl_sl_link_id

Line 481: xla_ae_lines ael,

477: Select distinct ent.entity_code
478: Into l_entity_code
479: From xla_transaction_entities ent,
480: xla_ae_headers aeh,
481: xla_ae_lines ael,
482: gl_import_references imr
483: Where ent.application_id = 200
484: And ent.application_id =aeh.application_id
485: And aeh.application_id = ael.application_id

Line 699: xla_ae_lines AEL,

695: FROM
696: ap_invoices_all I,
697: xla_transaction_entities ent,
698: xla_ae_headers AEH,
699: xla_ae_lines AEL,
700: ap_invoice_distributions_all D,
701: xla_distribution_links LNK,
702: gl_import_references R
703: WHERE

Line 764: xla_ae_lines AEL,

760: FROM
761: ap_checks_all C,
762: xla_transaction_entities ent,
763: xla_ae_headers AEH,
764: xla_ae_lines AEL,
765: ap_payment_history_all D, -- bug 8673098
766: gl_import_references R
767: WHERE
768: ent.application_id = 200

Line 821: xla_ae_lines AEL,

817: FROM
818: ap_invoices_all I,
819: xla_transaction_entities ent,
820: xla_ae_headers AEH,
821: xla_ae_lines AEL,
822: ap_prepay_app_dists D,
823: xla_distribution_links LNK,
824: gl_import_references R
825: WHERE

Line 888: xla_ae_lines AEL,

884: FROM
885: ap_invoices_all I,
886: xla_transaction_entities ent,
887: xla_ae_headers AEH,
888: xla_ae_lines AEL,
889: gl_import_references R
890: WHERE
891: ent.application_id = 200
892: AND ent.application_id =aeh.application_id

Line 1318: xla_ae_lines AEL,

1314: aps.vendor_id
1315: FROM ap_suppliers aps,(select distinct person_id ,national_identifier from per_all_people_f
1316: WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
1317: WHERE nvl(aps.employee_id, -99) = papf.person_id (+)) povapf,
1318: xla_ae_lines AEL,
1319: gl_import_references R,
1320: RCV_RECEIVING_SUB_LEDGER RCVSD,
1321: xla_distribution_links LNK
1322: WHERE povapf.vendor_id = poha.vendor_id

Line 1350: xla_ae_lines AEL, gl_import_references gir,

1346: FROM jl_co_gl_nits jlcgn,
1347: po_headers_all poha,
1348: PO_DISTRIBUTIONS_ALL podis,
1349: cst_write_offs cwo,
1350: xla_ae_lines AEL, gl_import_references gir,
1351: xla_distribution_links LNK,(SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099, aps.vendor_name,
1352: aps.global_attribute10, aps.global_attribute12, aps.segment1, aps.vendor_id
1353: FROM ap_suppliers aps,(select distinct person_id , national_identifier
1354: from per_all_people_f

Line 1943: xla_ae_lines AEL,

1939: ael.party_id,
1940: et.event_class_code
1941: FROM xla_transaction_entities ent,
1942: xla_ae_headers AEH,
1943: xla_ae_lines AEL,
1944: gl_import_references R,
1945: xla_event_types_b et
1946: WHERE
1947: ent.application_id = 222

Line 3167: xla_ae_lines AEL,

3163: Cursor C_Upg_Batch_ID Is
3164: Select aeh.upg_batch_id upg_batch_id
3165: FROM xla_transaction_entities ent,
3166: xla_ae_headers AEH,
3167: xla_ae_lines AEL,
3168: gl_import_references R
3169: WHERE ent.application_id = 222
3170: AND ent.entity_id = aeh.entity_id
3171: AND aeh.ae_header_id = ael.ae_header_id