DBA Data[Home] [Help]

APPS.GMF_PO_AP_MATCH_DATA SQL Statements

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

Line: 4

        SELECT   po_l_l.quantity,
              po_l_l.quantity_received,
              po_l_l.quantity_billed,
              po_l_l.quantity_cancelled,
              po_l_l.quantity_accepted,
              ap_i_d.invoice_id
             FROM  po_line_locations_all po_l_l,
              po_distributions_all po_d,
            ap_invoice_distributions_all ap_i_d
          WHERE po_d.po_header_id = poheaderid    AND
              ap_i_d.po_distribution_id =
                po_d.po_distribution_id   AND
              po_d.line_location_id =
                po_l_l.line_location_id;