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_ITEM_COMP_V

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';

Line 1640: From ahl_item_comp_v

1636: Select item_composition_id,
1637: approval_status_code,
1638: object_version_number,
1639: concatenated_segments
1640: From ahl_item_comp_v
1641: Where item_composition_id = c_item_comp_id;
1642:
1643:
1644: