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_RM_MATERIAL_AS_PVT dependencies on AHL_ROUTE_EFFECTIVITIES_V

Line 336: SELECT item_composition_id FROM AHL_ROUTE_EFFECTIVITIES_V

332: /*SELECT item_comp_detail_id
333: FROM AHL_ITEM_COMP_DETAILS
334: WHERE item_group_id = p_item_group_id AND
335: item_composition_id = (
336: SELECT item_composition_id FROM AHL_ROUTE_EFFECTIVITIES_V
337: WHERE route_effectivity_id = p_route_effecitivity_id
338: ) AND
339: effective_end_date IS NULL;*/
340: l_return_status VARCHAR2(1);

Line 1156: from ahl_route_effectivities_v

1152: , attribute12
1153: , attribute13
1154: , attribute14
1155: , attribute15
1156: from ahl_route_effectivities_v
1157: WHERE ROUTE_EFFECTIVITY_ID = C_ROUTE_EFFECTIVITY_ID
1158: ;
1159: BEGIN
1160: -- Get the old record from AHL_RT_OPER_MATERIALS.

Line 1941: FROM AHL_ROUTE_EFFECTIVITIES_V

1937: inventory_item_id,
1938: inventory_master_org_id,
1939: CONCATENATED_SEGMENTS,
1940: item_description
1941: FROM AHL_ROUTE_EFFECTIVITIES_V
1942: WHERE ROUTE_ID = c_object_id
1943: GROUP BY
1944: mc_id,
1945: mc_name,