APPS.GMICOMN SQL Statements

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

Line: 57

   SELECT item_no
     INTO x_item_no
     FROM ic_item_mst
    WHERE item_id = v_item_id;

Line: 89

   SELECT Lot_no
     INTO x_lot_no
     FROM ic_lots_mst
    WHERE Item_id = v_Item_Id
    AND  Lot_id = v_lot_id;