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 379: SELECT item_composition_id FROM AHL_ROUTE_EFFECTIVITIES_V

375: /*SELECT item_comp_detail_id
376: FROM AHL_ITEM_COMP_DETAILS
377: WHERE item_group_id = p_item_group_id AND
378: item_composition_id = (
379: SELECT item_composition_id FROM AHL_ROUTE_EFFECTIVITIES_V
380: WHERE route_effectivity_id = p_route_effecitivity_id
381: ) AND
382: effective_end_date IS NULL;*/
383:

Line 1258: from ahl_route_effectivities_v

1254: , attribute12
1255: , attribute13
1256: , attribute14
1257: , attribute15
1258: from ahl_route_effectivities_v
1259: WHERE ROUTE_EFFECTIVITY_ID = C_ROUTE_EFFECTIVITY_ID
1260: ;
1261:
1262: BEGIN

Line 1994: FROM AHL_ROUTE_EFFECTIVITIES_V

1990: inventory_item_id,
1991: inventory_master_org_id,
1992: CONCATENATED_SEGMENTS,
1993: item_description
1994: FROM AHL_ROUTE_EFFECTIVITIES_V
1995: WHERE ROUTE_ID = c_object_id
1996: GROUP BY
1997: mc_id,
1998: mc_name,