DBA Data[Home] [Help]

APPS.JE_IT_LISTING_PKG dependencies on AP_SUPPLIERS

Line 797: ap_suppliers pv ,

793: ap_invoice_lines_all il ,
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 ,

Line 1678: ap_suppliers pv,

1674: SUM(jit.CM_TAXABLE_VAT_INV_AMT) tot_taxable_vat_inv_amt_cm, --TAXABLE_VAT_INV_AMT
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

Line 1777: ap_suppliers pv,

1773: SUM(jit.CM_TAXABLE_VAT_INV_AMT) tot_taxable_vat_inv_amt_cm, --TAXABLE_VAT_INV_AMT
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

Line 1797: ap_suppliers pv

1793: GROUP BY jit.APPLICATION_ID,
1794: NVL(papf.national_identifier,NVL(pv.individual_1099,pv.num_1099)),
1795: NVL(pvs.vat_registration_num, pv.vat_registration_num)
1796: ) COLLECTION,
1797: ap_suppliers pv
1798: WHERE
1799: COLLECTION.party_id = pv.vendor_id
1800: ) OUTERQ
1801: ORDER BY OUTERQ.application_id DESC,