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.AP_WITHHOLDING_PKG dependencies on PO_VENDOR_SITES

Line 182: FROM po_vendor_sites_all

178: IF (l_income_tax_Region_flag = 'Y') THEN
179: BEGIN
180: SELECT SUBSTR(state, 1, 10)
181: INTO l_income_tax_region
182: FROM po_vendor_sites_all
183: WHERE vendor_site_id = rec_invoice.vendor_site_id
184: AND NVL(tax_reporting_site_flag, 'N') = 'Y';
185:
186: EXCEPTION

Line 717: ta_terms_id po_vendor_sites.terms_id%TYPE;

713: tax_authority_site_id ap_tax_codes.awt_vendor_site_id%TYPE;
714: base_currency ap_system_parameters.base_currency_code%TYPE;
715: new_invoice_base_descr ap_invoices.description%TYPE;
716: inv_terms_date DATE;
717: ta_terms_id po_vendor_sites.terms_id%TYPE;
718: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
719: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
720: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
721: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;

Line 718: ta_payment_priority po_vendor_sites.payment_priority%TYPE;

714: base_currency ap_system_parameters.base_currency_code%TYPE;
715: new_invoice_base_descr ap_invoices.description%TYPE;
716: inv_terms_date DATE;
717: ta_terms_id po_vendor_sites.terms_id%TYPE;
718: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
719: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
720: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
721: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
722: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;

Line 719: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;

715: new_invoice_base_descr ap_invoices.description%TYPE;
716: inv_terms_date DATE;
717: ta_terms_id po_vendor_sites.terms_id%TYPE;
718: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
719: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
720: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
721: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
722: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
723: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;

Line 720: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;

716: inv_terms_date DATE;
717: ta_terms_id po_vendor_sites.terms_id%TYPE;
718: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
719: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
720: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
721: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
722: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
723: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
724: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;

Line 721: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;

717: ta_terms_id po_vendor_sites.terms_id%TYPE;
718: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
719: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
720: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
721: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
722: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
723: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
724: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
725: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 722: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;

718: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
719: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
720: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
721: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
722: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
723: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
724: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
725: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
726: l_legal_entity_id ap_invoices_all.legal_entity_id%type;

Line 872: po_vendor_sites_all s,

868: s.party_site_id,
869: pv.party_id
870: FROM ap_tax_codes_all t,
871: ap_system_parameters_all p,
872: po_vendor_sites_all s,
873: po_vendors pv
874: WHERE t.tax_id = TaxId
875: AND pv.vendor_id = s.vendor_id /* Bug 4724120 */
876: AND s.vendor_id = t.awt_vendor_id