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_ROUTES_APP_V

Line 2129: from ahl_routes_app_v

2125: IS
2126: cursor get_route_status (p_route_id in number)
2127: is
2128: select revision_status_code
2129: from ahl_routes_app_v
2130: where route_id = p_route_id;
2131:
2132: l_obj_status VARCHAR2(30);
2133:

Line 2143: FROM ahl_route_effectivities refct, AHL_ROUTES_APP_V RM

2139:
2140: CURSOR get_efct_rec ( C_ROUTE_EFFECTIVITY_ID NUMBER )
2141: IS
2142: SELECT RM.ROUTE_ID
2143: FROM ahl_route_effectivities refct, AHL_ROUTES_APP_V RM
2144: WHERE refct.ROUTE_EFFECTIVITY_ID = C_ROUTE_EFFECTIVITY_ID
2145: AND RM.ROUTE_ID = refct.ROUTE_ID;
2146:
2147: l_api_version CONSTANT NUMBER := 1.0;

Line 2789: from ahl_routes_app_v

2785:
2786: cursor get_route_status (p_route_id in number)
2787: is
2788: select revision_status_code
2789: from ahl_routes_app_v
2790: where route_id = p_route_id;
2791:
2792: l_obj_status VARCHAR2(30);
2793: