APPS.AHL_LTP_MTL_REQ_PVT dependencies on CSI_ITEM_INSTANCES

Line 174: select INVENTORY_ITEM_ID from CSI_ITEM_INSTANCES

170: where UC.CSI_ITEM_INSTANCE_ID = c_instance_id AND
171: MC.MC_HEADER_ID = UC.MASTER_CONFIG_ID;
172:
173: CURSOR get_item_from_instance_csr(c_instance_id IN NUMBER) IS
174: select INVENTORY_ITEM_ID from CSI_ITEM_INSTANCES
175: where INSTANCE_ID = c_instance_id;
176:
177: CURSOR get_item_group_item_csr(c_item_group_id IN NUMBER) IS
178: SELECT inventory_item_id, inventory_org_id

Line 527: select 'x' from CSI_ITEM_INSTANCES

523: select 'x' from AHL_ROUTES_B
524: where route_id = c_route_id;
525:
526: CURSOR validate_instance_id_csr IS
527: select 'x' from CSI_ITEM_INSTANCES
528: where instance_id = p_item_instance_id
529: and nvl(active_end_date, sysdate + 1) > sysdate;
530:
531: l_dummy VARCHAR2(1);