DBA Data[Home] [Help]

APPS.JE_IT_LISTING_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 798: ap_supplier_sites_all pvs ,

794: ap_invoice_distributions_all id ,
795: ap_invoice_lines_all ilitem ,
796: ap_invoice_distributions_all iditem ,
797: ap_suppliers pv ,
798: ap_supplier_sites_all pvs ,
799: jg_zz_vat_rep_entities repent ,
800: zx_rates_b zxrates ,
801: zx_taxes_b zxtaxes ,
802: zx_report_codes_assoc zxass ,

Line 1679: ap_supplier_sites_all pvs,

1675: NVL(papf.national_identifier,NVL(pv.individual_1099,pv.num_1099)), --Supplier Tax Payer ID
1676: NVL(pvs.vat_registration_num, pv.vat_registration_num) --Supplier Tax Registration Number
1677: FROM je_it_list_lines_all jit,
1678: ap_suppliers pv,
1679: ap_supplier_sites_all pvs,
1680: (SELECT distinct person_id
1681: ,national_identifier
1682: FROM per_all_people_f
1683: WHERE nvl(effective_end_date,sysdate) >= sysdate ) papf

Line 1778: ap_supplier_sites_all pvs,

1774: NVL(papf.national_identifier,NVL(pv.individual_1099,pv.num_1099)) tax_payer_id, --Supplier Tax Payer ID
1775: NVL(pvs.vat_registration_num, pv.vat_registration_num) vat_reg_num --Supplier Tax Registration Number
1776: FROM je_it_list_lines_all jit,
1777: ap_suppliers pv,
1778: ap_supplier_sites_all pvs,
1779: (SELECT distinct person_id
1780: ,national_identifier
1781: FROM per_all_people_f
1782: WHERE nvl(effective_end_date,sysdate) >= sysdate ) papf