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_APPROVAL_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 786: ap_supplier_sites_all PVS,

782: nvl(pvs.tolerance_id,ASP.tolerance_id), --added nvl for bug 8425996
783: nvl(pvs.services_tolerance_id,ASP.services_tolerance_id) --added nvl for bug 8425996
784: FROM ap_invoices_all AI,
785: ap_suppliers PV,
786: ap_supplier_sites_all PVS,
787: ap_system_parameters_all ASP --added table for bug 8425996
788: WHERE AI.invoice_id = p_invoice_id
789: AND AI.vendor_id = PV.vendor_id
790: AND AI.vendor_site_id = PVS.vendor_site_id

Line 9251: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;

9247: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
9248: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
9249: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
9250: l_exchange_date AP_INVOICES.exchange_date%TYPE;
9251: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;
9252: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;
9253:
9254: Tax_Exception EXCEPTION;
9255:

Line 9252: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;

9248: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
9249: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
9250: l_exchange_date AP_INVOICES.exchange_date%TYPE;
9251: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;
9252: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;
9253:
9254: Tax_Exception EXCEPTION;
9255:
9256: CURSOR SELECTED_INVOICES_CURSOR IS

Line 9277: ap_supplier_sites_all S,

9273: nvl(I.exclude_freight_from_discount,'N') exclude_freight_from_discount,
9274: nvl(S.tolerance_id,ASP.tolerance_id), --Bug8524767
9275: nvl(S.services_tolerance_id,ASP.services_tolerance_id) --Bug8524767
9276: FROM ap_invoices_all I,
9277: ap_supplier_sites_all S,
9278: ap_system_parameters_all ASP --Bug8524767
9279: WHERE I.vendor_site_id = S.vendor_site_id (+)
9280: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
9281: AND ASP.org_id = I.org_id

Line 9292: --bug7902867 cusror modified removed ap_supplier_sites_all in join

9288:
9289: l_api_name CONSTANT VARCHAR2(200) := 'Batch_Approval';
9290:
9291: -- Start for bug 6511249
9292: --bug7902867 cusror modified removed ap_supplier_sites_all in join
9293: CURSOR SELC_INV_CURSOR_BULK_ERROR IS
9294: SELECT I.invoice_id, i.invoice_num, i.org_id
9295: FROM ap_invoices_all I
9296: WHERE I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID

Line 9522: ap_supplier_sites_all s,

9518: l_invoice_id, l_invoice_date, l_invoice_currency_code, l_exchange_rate,
9519: l_exchange_rate_type, l_exchange_date, l_vendor_id, l_org_id, l_tolerance_id,
9520: l_services_tolerance_id
9521: FROM ap_invoices_all ai,
9522: ap_supplier_sites_all s,
9523: ap_system_parameters_all asp
9524: WHERE ai.invoice_id = l_invoice_id
9525: AND ai.vendor_site_id = s.vendor_site_id(+)
9526: AND ai.org_id = asp.org_id;