APPS.GMI_VALIDATE_ALLOCATION_PVT SQL Statements

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

Line: 47

SELECT *
FROM
  ic_item_mst
WHERE
    item_no     = p_allocation_rec.item_no;

Line: 55

SELECT *
FROM
  ic_whse_mst
WHERE
    whse_code   = p_allocation_rec.whse_code and delete_mark=0;

Line: 158

        (x_ic_item_mst_rec.delete_mark = 1)
  THEN
    FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');