APPS.AHL_MC_ITEM_COMP_PVT dependencies on AHL_ROUTE_EFFECTIVITIES

Line 970: -- FROM ahl_route_effectivities_v

966: CURSOR disposition_exist(p_item_composition_id IN NUMBER)
967: IS
968: -- Modified Cursor Below for Perf Fix - Bug 4913935
969: -- SELECT 'x'
970: -- FROM ahl_route_effectivities_v
971: -- WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
972: SELECT 'x'
973: FROM ahl_route_effectivities re, AHL_ITEM_COMP_V icd
974: WHERE icd.ITEM_COMPOSITION_ID = p_item_composition_id

Line 973: FROM ahl_route_effectivities re, AHL_ITEM_COMP_V icd

969: -- SELECT 'x'
970: -- FROM ahl_route_effectivities_v
971: -- WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
972: SELECT 'x'
973: FROM ahl_route_effectivities re, AHL_ITEM_COMP_V icd
974: WHERE icd.ITEM_COMPOSITION_ID = p_item_composition_id
975: AND re.inventory_item_id = ICD.inventory_item_id
976: AND re.INVENTORY_MASTER_ORG_ID = ICD.INVENTORY_MASTER_ORG_ID
977: AND ICD.APPROVAL_STATUS_CODE = 'COMPLETE';