[Home] [Help]
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
123: and ael.accounting_class_code in ('INTER','INTRA')) --End of bug10084267 fix
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
486: And ent.entity_id = aeh.entity_id
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
704: ent.application_id = 200
705: AND ent.application_id =aeh.application_id
706: AND aeh.application_id = ael.application_id
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
769: --bug8680825
770: /*and (ent.ledger_id = g_parameter_rec.set_of_books_id
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
826: ent.application_id = 200
827: AND ent.application_id =aeh.application_id
828: AND aeh.application_id = ael.application_id
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
893: AND aeh.application_id = ael.application_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
1323: AND REPLACE(povapf.num_1099,'-') = jlcgn.nit(+)
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
1692: reference_7,
1693: reference_8,
1694: reference_9,
1695: reference_10
1696: FROM gl_import_references glir
1697: WHERE glir.je_header_id = p_journal_rec.je_header_id
1698: AND glir.je_line_num = p_journal_rec.je_line_num;
1699:
1700: l_acc_dr gl_je_lines.accounted_dr%TYPE;
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
1948: --bug8680825
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
3172: AND (aeh.ledger_id = g_parameter_rec.set_of_books_id --bug8680825