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_MC_ITEM_COMP_PVT dependencies on AHL_ROUTE_EFFECTIVITIES

Line 986: -- FROM ahl_route_effectivities_v

982: CURSOR disposition_exist(p_item_composition_id IN NUMBER)
983: IS
984: -- Modified Cursor Below for Perf Fix - Bug 4913935
985: -- SELECT 'x'
986: -- FROM ahl_route_effectivities_v
987: -- WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
988: SELECT 'x'
989: FROM ahl_route_effectivities re, AHL_ITEM_COMP_V icd
990: WHERE icd.ITEM_COMPOSITION_ID = p_item_composition_id

Line 989: FROM ahl_route_effectivities re, AHL_ITEM_COMP_V icd

985: -- SELECT 'x'
986: -- FROM ahl_route_effectivities_v
987: -- WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
988: SELECT 'x'
989: FROM ahl_route_effectivities re, AHL_ITEM_COMP_V icd
990: WHERE icd.ITEM_COMPOSITION_ID = p_item_composition_id
991: AND re.inventory_item_id = ICD.inventory_item_id
992: AND re.INVENTORY_MASTER_ORG_ID = ICD.INVENTORY_MASTER_ORG_ID
993: AND ICD.APPROVAL_STATUS_CODE = 'COMPLETE';