DBA Data[Home] [Help]

APPS.AP_PO_UTILITIES_PKG dependencies on AP_INVOICES_ALL

Line 20: FROM AP_Invoices_All AI,

16: IF P_Shipment_Type = 'PREPAYMENT' THEN
17:
18: SELECT MAX(AI.invoice_date)
19: INTO P_Invoice_Date
20: FROM AP_Invoices_All AI,
21: AP_Invoice_Lines_All AIL
22: WHERE AI.invoice_id = AIL.invoice_id
23: AND AIL.po_line_location_id = P_Line_Location_ID
24: AND NVL(AIL.discarded_flag,'N') <> 'N'

Line 35: FROM AP_Invoices_All AI,

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,
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'