APPS.GML_MLT_CNTR_RCPT SQL Statements

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

Line: 60

    SELECT lot_id
    FROM ic_lots_mst
    WHERE item_id = p_f_item_id AND
          lot_no = p_f_lot_no AND
          sublot_no = p_f_sublot_no;

Line: 67

    SELECT lot_id
    FROM ic_lots_mst
    WHERE item_id = p_f_item_id AND
          lot_no = p_f_lot_no;

Line: 180

Select 	item_no, qc_grade
From 	ic_item_mst
Where   item_id = p_item_id;

Line: 203

      SELECT vendor_no INTO l_shipvendor_no
      FROM   po_vend_mst
       where  vendor_id = p_shipvend_id;