APPS.AP_PO_UTILITIES_PKG dependencies on AP_INVOICE_LINES_ALL

Line 21: AP_Invoice_Lines_All AIL

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'
25: AND AI.invoice_type_lookup_code = 'PREPAYMENT';

Line 36: AP_Invoice_Lines_All AIL

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'
40: AND AI.invoice_type_lookup_code = 'STANDARD';