APPS.AP_PO_UTILITIES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

       SELECT MAX(AI.invoice_date)
       INTO   P_Invoice_Date
       FROM   AP_Invoices_All AI,
              AP_Invoice_Lines_All AIL
       WHERE  AI.invoice_id = AIL.invoice_id
         AND  AIL.po_line_location_id = P_Line_Location_ID
         AND  NVL(AIL.discarded_flag,'N') <> 'N'
         AND  AI.invoice_type_lookup_code = 'PREPAYMENT';

Line: 33

       SELECT MAX(AI.invoice_date)
       INTO   P_Invoice_Date
       FROM   AP_Invoices_All AI,
              AP_Invoice_Lines_All AIL
       WHERE  AI.invoice_id = AIL.invoice_id
         AND  AIL.po_line_location_id = P_Line_Location_ID
         AND  NVL(AIL.discarded_flag,'N') <> 'N'
         AND  AI.invoice_type_lookup_code = 'STANDARD';