APPS.GML_RELEASE_SHIPMENT_PKG SQL Statements

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

Line: 9

     SELECT Item_id as item_id,
            Whse_code as whse_code,
            Lot_id as lot_id,
            Location as location,
            SUM(-Trans_qty) as qty,
            0 as valid_flag
     FROM   ic_tran_pnd
     WHERE  doc_type = 'OPSO'
           AND delete_mark <> 1
           AND completed_ind <> 1
           AND trans_qty <> 0
           AND line_id in (SELECT line_id
                           FROM   op_ordr_dtl
                           WHERE bol_id = pbol_id)
     GROUP BY item_id,whse_code,lot_id,location
     ORDER BY item_id,whse_code,lot_id,location;

Line: 27

     SELECT Item_id as item_id,
            Whse_code as whse_code,
            Lot_id as lot_id,
            Location as location,
            loct_onhand as qty,
            0 as valid_flag
     FROM   ic_loct_inv
     WHERE (item_id, whse_code, lot_id, location) in
            ( SELECT distinct item_id,
                              whse_code,
                              lot_id,
                              location
              FROM  ic_tran_pnd
            WHERE   doc_type = 'OPSO'
                  AND  delete_mark <> 1
                  AND  completed_ind <> 1
                  AND   trans_qty <> 0
                  AND line_id in ( SELECT line_id
                                   FROM   op_ordr_dtl
                                   WHERE bol_id = pbol_id))
     ORDER BY item_id,whse_code,lot_id,location;

Line: 52

    SELECT noninv_ind
      FROM ic_item_mst
     WHERE item_id = pitem_id;