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_CALC_WITHHOLDING_PKG dependencies on AP_INVOICES

Line 390: FROM AP_Invoices

386: IF g_org_id IS NULL THEN
387:
388: SELECT org_id
389: INTO g_org_id
390: FROM AP_Invoices
391: WHERE Invoice_ID = InvoiceId;
392:
393: END IF;
394:

Line 904: currency_code ap_invoices.invoice_currency_code%TYPE;

900: */
901:
902: -- PL/SQL Main Block Constants AND Variables:
903:
904: currency_code ap_invoices.invoice_currency_code%TYPE;
905: payment_currency_code ap_invoices.payment_currency_code%TYPE;
906: payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
907: FUNCTIONal_currency ap_system_parameters.base_currency_code%TYPE;
908: invoice_exchange_rate ap_invoices.exchange_rate%TYPE;

Line 905: payment_currency_code ap_invoices.payment_currency_code%TYPE;

901:
902: -- PL/SQL Main Block Constants AND Variables:
903:
904: currency_code ap_invoices.invoice_currency_code%TYPE;
905: payment_currency_code ap_invoices.payment_currency_code%TYPE;
906: payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
907: FUNCTIONal_currency ap_system_parameters.base_currency_code%TYPE;
908: invoice_exchange_rate ap_invoices.exchange_rate%TYPE;
909: invoice_number ap_invoices.invoice_num%TYPE;

Line 906: payment_cross_rate ap_invoices.payment_cross_rate%TYPE;

902: -- PL/SQL Main Block Constants AND Variables:
903:
904: currency_code ap_invoices.invoice_currency_code%TYPE;
905: payment_currency_code ap_invoices.payment_currency_code%TYPE;
906: payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
907: FUNCTIONal_currency ap_system_parameters.base_currency_code%TYPE;
908: invoice_exchange_rate ap_invoices.exchange_rate%TYPE;
909: invoice_number ap_invoices.invoice_num%TYPE;
910: supplier_id ap_invoices.vendor_id%TYPE;

Line 908: invoice_exchange_rate ap_invoices.exchange_rate%TYPE;

904: currency_code ap_invoices.invoice_currency_code%TYPE;
905: payment_currency_code ap_invoices.payment_currency_code%TYPE;
906: payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
907: FUNCTIONal_currency ap_system_parameters.base_currency_code%TYPE;
908: invoice_exchange_rate ap_invoices.exchange_rate%TYPE;
909: invoice_number ap_invoices.invoice_num%TYPE;
910: supplier_id ap_invoices.vendor_id%TYPE;
911: supplier_site_id ap_invoices.vendor_site_id%TYPE;
912: NUMBER_of_awt_groups integer := 0;

Line 909: invoice_number ap_invoices.invoice_num%TYPE;

905: payment_currency_code ap_invoices.payment_currency_code%TYPE;
906: payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
907: FUNCTIONal_currency ap_system_parameters.base_currency_code%TYPE;
908: invoice_exchange_rate ap_invoices.exchange_rate%TYPE;
909: invoice_number ap_invoices.invoice_num%TYPE;
910: supplier_id ap_invoices.vendor_id%TYPE;
911: supplier_site_id ap_invoices.vendor_site_id%TYPE;
912: NUMBER_of_awt_groups integer := 0;
913: gl_period_name ap_invoice_distributions.period_name%TYPE;

Line 910: supplier_id ap_invoices.vendor_id%TYPE;

906: payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
907: FUNCTIONal_currency ap_system_parameters.base_currency_code%TYPE;
908: invoice_exchange_rate ap_invoices.exchange_rate%TYPE;
909: invoice_number ap_invoices.invoice_num%TYPE;
910: supplier_id ap_invoices.vendor_id%TYPE;
911: supplier_site_id ap_invoices.vendor_site_id%TYPE;
912: NUMBER_of_awt_groups integer := 0;
913: gl_period_name ap_invoice_distributions.period_name%TYPE;
914: gl_awt_date DATE;

Line 911: supplier_site_id ap_invoices.vendor_site_id%TYPE;

907: FUNCTIONal_currency ap_system_parameters.base_currency_code%TYPE;
908: invoice_exchange_rate ap_invoices.exchange_rate%TYPE;
909: invoice_number ap_invoices.invoice_num%TYPE;
910: supplier_id ap_invoices.vendor_id%TYPE;
911: supplier_site_id ap_invoices.vendor_site_id%TYPE;
912: NUMBER_of_awt_groups integer := 0;
913: gl_period_name ap_invoice_distributions.period_name%TYPE;
914: gl_awt_date DATE;
915:

Line 1833: FROM ap_invoices

1829: invoice_number,
1830: supplier_id,
1831: supplier_site_id,
1832: g_org_id /* Bug 3700128. MOAC Project */
1833: FROM ap_invoices
1834: WHERE invoice_id = P_Invoice_Id;
1835:
1836: -- Get base currency code:
1837:

Line 1881: total_invoice_amount ap_invoices.invoice_amount%TYPE;

1877: rec_group_amounts c_group_amounts%ROWTYPE;
1878:
1879: DBG_Loc VARCHAR2(30) := 'Get_Groups';
1880: i binary_integer := 0;
1881: total_invoice_amount ap_invoices.invoice_amount%TYPE;
1882: total_vat_amount NUMBER := 0;
1883: gross_exempt_amount NUMBER := 0;
1884: gross_amount_on_all_awt_groups NUMBER := 0;
1885: gross_amount_allbutlast_group NUMBER := 0;