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 467: FROM po_vendor_sites_all

463: IF (l_income_tax_Region_flag = 'Y') THEN
464: BEGIN
465: SELECT SUBSTR(state, 1, 10)
466: INTO l_income_tax_region
467: FROM po_vendor_sites_all
468: WHERE vendor_site_id = rec_invoice.vendor_site_id
469: AND NVL(tax_reporting_site_flag, 'N') = 'Y';
470:
471: EXCEPTION

Line 1304: ta_terms_id po_vendor_sites.terms_id%TYPE;

1300: tax_authority_site_id ap_tax_codes.awt_vendor_site_id%TYPE;
1301: base_currency ap_system_parameters.base_currency_code%TYPE;
1302: new_invoice_base_descr ap_invoices.description%TYPE;
1303: inv_terms_date DATE;
1304: ta_terms_id po_vendor_sites.terms_id%TYPE;
1305: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
1306: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
1307: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
1308: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;

Line 1305: ta_payment_priority po_vendor_sites.payment_priority%TYPE;

1301: base_currency ap_system_parameters.base_currency_code%TYPE;
1302: new_invoice_base_descr ap_invoices.description%TYPE;
1303: inv_terms_date DATE;
1304: ta_terms_id po_vendor_sites.terms_id%TYPE;
1305: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
1306: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
1307: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
1308: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
1309: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;

Line 1306: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;

1302: new_invoice_base_descr ap_invoices.description%TYPE;
1303: inv_terms_date DATE;
1304: ta_terms_id po_vendor_sites.terms_id%TYPE;
1305: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
1306: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
1307: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
1308: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
1309: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
1310: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;

Line 1307: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;

1303: inv_terms_date DATE;
1304: ta_terms_id po_vendor_sites.terms_id%TYPE;
1305: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
1306: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
1307: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
1308: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
1309: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
1310: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
1311: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;

Line 1308: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;

1304: ta_terms_id po_vendor_sites.terms_id%TYPE;
1305: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
1306: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
1307: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
1308: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
1309: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
1310: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
1311: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1312: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 1309: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;

1305: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
1306: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
1307: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
1308: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
1309: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
1310: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
1311: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1312: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1313: l_legal_entity_id ap_invoices_all.legal_entity_id%type;

Line 1671: po_vendor_sites_all s,

1667: s.party_site_id,
1668: pv.party_id
1669: FROM ap_tax_codes_all t,
1670: ap_system_parameters_all p,
1671: po_vendor_sites_all s,
1672: po_vendors pv
1673: WHERE t.tax_id = TaxId
1674: AND pv.vendor_id = s.vendor_id /* Bug 4724120 */
1675: AND s.vendor_id = t.awt_vendor_id