DBA Data[Home] [Help]

APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on XLA_DISTRIBUTION_LINKS

Line 701: xla_distribution_links LNK,

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
704: ent.application_id = 200
705: AND ent.application_id =aeh.application_id

Line 823: xla_distribution_links LNK,

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
826: ent.application_id = 200
827: AND ent.application_id =aeh.application_id

Line 1321: xla_distribution_links LNK

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(+)
1324: AND R.je_header_id = p_journal_rec.je_header_id
1325: AND R.je_line_num = p_journal_rec.je_line_num

Line 1351: xla_distribution_links LNK,(SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099, aps.vendor_name,

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
1355: WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf