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_PATH_POSITION_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 2747: FROM ahl_item_associations_b aia, mtl_system_items_b mtl

2743:
2744: -- for a given item group id, get the serial control code of the associated items
2745: CURSOR get_serial_cntrl_code_csr (p_item_group_id NUMBER) IS
2746: SELECT mtl.serial_number_control_code
2747: FROM ahl_item_associations_b aia, mtl_system_items_b mtl
2748: WHERE aia.item_group_id = p_item_group_id
2749: AND aia.inventory_item_id = mtl.inventory_item_id
2750: AND aia.inventory_org_id = mtl.organization_id
2751: AND aia.interchange_type_code IN ('1-WAY INTERCHANGEABLE', '2-WAY INTERCHANGEABLE')