[Home] [Help]
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
4217: CURSOR PO_Required_Cur IS
4218: -- Perf bug 5058995
4219: -- Modify below SQL to go to base tables : AP_INVOICES_ALL,
4220: -- AP_INVOICE_DISTRIBUTIONS_ALL and
4221: -- AP_SUPPLIER_SITES(instead of po_vendor_sites)
4222: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
4223: SELECT 'PO REQUIRED'
4224: FROM ap_invoices_all api, ap_supplier_sites pov
4225: WHERE EXISTS (select /*+ index(apd AP_INVOICE_DISTRIBUTIONS_U1) */ 'X'
4220: -- AP_INVOICE_DISTRIBUTIONS_ALL and
4221: -- AP_SUPPLIER_SITES(instead of po_vendor_sites)
4222: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
4223: SELECT 'PO REQUIRED'
4224: FROM ap_invoices_all api, ap_supplier_sites pov
4225: WHERE EXISTS (select /*+ index(apd AP_INVOICE_DISTRIBUTIONS_U1) */ 'X'
4226: from ap_invoice_distributions_all apd
4227: where apd.invoice_id = api.invoice_id
4228: and apd.line_type_lookup_code in ( 'ITEM', 'ACCRUAL')
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:
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
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
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
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;