DBA Data[Home] [Help]

APPS.AP_PO_UTILITIES_PKG dependencies on STANDARD

Line 31: IF P_Shipment_Type = 'STANDARD' THEN

27: RETURN;
28:
29: END IF;
30:
31: IF P_Shipment_Type = 'STANDARD' THEN
32:
33: SELECT MAX(AI.invoice_date)
34: INTO P_Invoice_Date
35: FROM AP_Invoices_All AI,

Line 40: AND AI.invoice_type_lookup_code = 'STANDARD';

36: AP_Invoice_Lines_All AIL
37: WHERE AI.invoice_id = AIL.invoice_id
38: AND AIL.po_line_location_id = P_Line_Location_ID
39: AND NVL(AIL.discarded_flag,'N') <> 'N'
40: AND AI.invoice_type_lookup_code = 'STANDARD';
41:
42: RETURN;
43:
44: END IF;