[Home] [Help]
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');