eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_LTP_MTL_REQ_PVT dependencies on CSI_ITEM_INSTANCES

Line 200: select INVENTORY_ITEM_ID from CSI_ITEM_INSTANCES

196: where UC.CSI_ITEM_INSTANCE_ID = c_instance_id AND
197: MC.MC_HEADER_ID = UC.MASTER_CONFIG_ID;
198:
199: CURSOR get_item_from_instance_csr(c_instance_id IN NUMBER) IS
200: select INVENTORY_ITEM_ID from CSI_ITEM_INSTANCES
201: where INSTANCE_ID = c_instance_id;
202:
203: CURSOR get_item_group_item_csr(c_item_group_id IN NUMBER) IS
204: SELECT inventory_item_id, inventory_org_id

Line 567: select 'x' from CSI_ITEM_INSTANCES

563: select 'x' from AHL_ROUTES_B
564: where route_id = c_route_id;
565:
566: CURSOR validate_instance_id_csr IS
567: select 'x' from CSI_ITEM_INSTANCES
568: where instance_id = p_item_instance_id
569: and nvl(active_end_date, sysdate + 1) > sysdate;
570:
571: -- Added by surrkuma for bug# 13998921 on 26-Apr-12