APPS.AP_APPROVAL_PKG dependencies on AP_SUPPLIER_SITES

Line 608: ap_supplier_sites_all PVS

604: pvs.tolerance_id,
605: pvs.services_tolerance_id
606: FROM ap_invoices_all AI,
607: ap_suppliers PV,
608: ap_supplier_sites_all PVS
609: WHERE AI.invoice_id = p_invoice_id
610: AND AI.vendor_id = PV.vendor_id
611: AND AI.vendor_site_id = PVS.vendor_site_id;
612:

Line 3118: -- AP_SUPPLIER_SITES(instead of po_vendor_sites)

3114: CURSOR PO_Required_Cur IS
3115: -- Perf bug 5058995
3116: -- Modify below SQL to go to base tables : AP_INVOICES_ALL,
3117: -- AP_INVOICE_DISTRIBUTIONS_ALL and
3118: -- AP_SUPPLIER_SITES(instead of po_vendor_sites)
3119: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
3120: SELECT 'PO REQUIRED'
3121: FROM ap_invoices_all api, ap_supplier_sites pov
3122: WHERE EXISTS (select /*+ index(apd AP_INVOICE_DISTRIBUTIONS_U1) */ 'X'

Line 3121: FROM ap_invoices_all api, ap_supplier_sites pov

3117: -- AP_INVOICE_DISTRIBUTIONS_ALL and
3118: -- AP_SUPPLIER_SITES(instead of po_vendor_sites)
3119: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
3120: SELECT 'PO REQUIRED'
3121: FROM ap_invoices_all api, ap_supplier_sites pov
3122: WHERE EXISTS (select /*+ index(apd AP_INVOICE_DISTRIBUTIONS_U1) */ 'X'
3123: from ap_invoice_distributions_all apd
3124: where apd.invoice_id = api.invoice_id
3125: and apd.line_type_lookup_code in ( 'ITEM', 'ACCRUAL')

Line 7143: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;

7139: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
7140: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
7141: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
7142: l_exchange_date AP_INVOICES.exchange_date%TYPE;
7143: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;
7144: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;
7145:
7146: Tax_Exception EXCEPTION;
7147:

Line 7144: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;

7140: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
7141: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
7142: l_exchange_date AP_INVOICES.exchange_date%TYPE;
7143: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;
7144: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;
7145:
7146: Tax_Exception EXCEPTION;
7147:
7148: CURSOR SELECTED_INVOICES_CURSOR IS

Line 7169: ap_supplier_sites_all S

7165: nvl(I.exclude_freight_from_discount,'N') exclude_freight_from_discount,
7166: S.tolerance_id,
7167: s.services_tolerance_id
7168: FROM ap_invoices_all I,
7169: ap_supplier_sites_all S
7170: WHERE I.vendor_site_id = S.vendor_site_id (+)
7171: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7172: ORDER BY I.org_id;
7173:

Line 7180: ap_supplier_sites_all S

7176: -- Start for bug 6511249
7177: CURSOR SELC_INV_CURSOR_BULK_ERROR IS
7178: SELECT I.invoice_id, i.invoice_num, i.org_id
7179: FROM ap_invoices_all I,
7180: ap_supplier_sites_all S
7181: WHERE I.vendor_site_id = S.vendor_site_id (+)
7182: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7183: ORDER BY I.org_id;
7184:

Line 7281: ap_supplier_sites_all s

7277: l_invoice_id, l_invoice_date, l_invoice_currency_code, l_exchange_rate,
7278: l_exchange_rate_type, l_exchange_date, l_vendor_id, l_org_id, l_tolerance_id,
7279: l_services_tolerance_id
7280: FROM ap_invoices_all ai,
7281: ap_supplier_sites_all s
7282: WHERE ai.invoice_id = l_invoice_id
7283: AND ai.vendor_site_id = s.vendor_site_id(+);
7284: EXCEPTION
7285: WHEN OTHERS THEN

Line 7630: ap_supplier_sites_all s

7626: l_exchange_rate_type, l_exchange_date, l_vendor_id, l_org_id, l_tolerance_id,
7627: l_services_tolerance_id
7628: FROM
7629: ap_invoices_all ai,
7630: ap_supplier_sites_all s
7631: WHERE
7632: ai.invoice_id = l_selc_inv_cursor_blk_err(i).invoice_id
7633: AND
7634: ai.vendor_site_id = s.vendor_site_id(+);