APPS.ONT_ICP_PROCESS_PACKAGE SQL Statements

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

Line: 52

   SELECT item_id
   FROM  ic_item_mst
   WHERE delete_mark = 0
   AND   item_no in (SELECT segment1
	FROM mtl_system_items
	WHERE organization_id   = org_id
        AND   inventory_item_id = item_id);

Line: 91

	  SELECT iim.item_id INTO l_item_id
	  FROM   ic_item_mst iim,
	         mtl_system_items msi
	  WHERE  msi.inventory_item_id = p_inv_itemid
	  AND    msi.organization_id = p_orgid
	  AND    msi.segment1 = iim.item_no;

Line: 104

	    SELECT lot_id INTO l_lot_id
	    FROM   ic_lots_mst
	    WHERE  item_id = l_item_id
	    AND    lot_no = p_lot_number;

Line: 109

	    SELECT lot_id INTO l_lot_id
	    FROM   ic_lots_mst
	    WHERE  item_id = l_item_id
	    AND    lot_no = p_lot_number
	    AND    sublot_no = p_sublot_number;