APPS.POS_VIEW_RECEIPTS_GRP SQL Statements

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

Line: 50

     SELECT
       transaction_id,
       primary_quantity,
       primary_unit_of_measure,
       unit_of_measure,
       source_doc_unit_of_measure,
       transaction_type,
       shipment_line_id,
       po_line_location_id,
       parent_transaction_id
     FROM
       rcv_transactions
     START WITH transaction_id = c_transaction_id
     CONNECT BY parent_transaction_id = PRIOR transaction_id;

Line: 93

           SELECT item_id INTO X_item_id
           FROM rcv_shipment_lines
           WHERE shipment_line_id = v_shipment_line_id;

Line: 104

           SELECT transaction_type INTO v_parent_type
           FROM rcv_transactions
           WHERE transaction_id = v_parent_id;

Line: 122

           SELECT transaction_type INTO v_parent_type
           FROM rcv_transactions
           WHERE transaction_id = v_parent_id;

Line: 136

           SELECT transaction_type INTO v_parent_type
           FROM rcv_transactions
           WHERE transaction_id = v_parent_id;

Line: 154

           SELECT  transaction_type,parent_transaction_id
           INTO v_parent_type,grand_parent_id
           FROM  rcv_transactions
           WHERE transaction_id = v_parent_id;

Line: 160

             SELECT transaction_type INTO grand_parent_type
             FROM rcv_transactions
             WHERE transaction_id = grand_parent_id;

Line: 256

   SELECT lpn_id into isLPN
   FROM rcv_transactions rt
   WHERE shipment_line_id = p_rcv_shipment_line_id
   AND transaction_type = 'RECEIVE';

Line: 268

   SELECT lot_control_code, serial_number_control_code into isLot, isSerial
   FROM mtl_system_items msi, rcv_shipment_lines rsl
   WHERE msi.organization_id   = rsl.to_organization_id
   AND  msi.inventory_item_id = rsl.item_id
   AND rsl.shipment_line_id = p_rcv_shipment_line_id;

Line: 301

         SELECT DISTINCT(ph.segment1||'-'||pr.release_num), ph.po_header_id, pr.po_release_id
         FROM rcv_shipment_lines rsl, po_headers_all ph,  po_releases_all pr
          WHERE rsl.shipment_header_id= l_shipment_header_id
            AND rsl.po_header_id = ph.po_header_id
            AND rsl.po_release_id = pr.po_release_id
            AND ph.type_lookup_code = 'BLANKET'
          UNION ALL
         SELECT DISTINCT ph.segment1, ph.po_header_id, null
           FROM rcv_shipment_lines rsl, po_headers_all ph
          WHERE rsl.shipment_header_id= l_shipment_header_id
            AND rsl.po_header_id    = ph.po_header_id
            AND ph.type_lookup_code = 'STANDARD';

Line: 352

      SELECT DISTINCT ap.invoice_num,ap.invoice_id
      FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt
      WHERE ap.invoice_id = al.invoice_id
      AND al.rcv_transaction_id = rt.transaction_id
      AND rt.shipment_header_id = l_shipment_header_id;

Line: 397

       SELECT DISTINCT ap.invoice_num,ap.invoice_id
       FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt
       WHERE ap.invoice_id = al.invoice_id
       AND al.rcv_transaction_id = rt.transaction_id
       AND rt.shipment_line_id = l_shipment_line_id;