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 2056: from ahl_routes_app_v

2052: IS
2053: cursor get_route_status (p_route_id in number)
2054: is
2055: select revision_status_code
2056: from ahl_routes_app_v
2057: where route_id = p_route_id;
2058: l_obj_status VARCHAR2(30);
2059: cursor get_oper_status (p_operation_id in number)
2060: is

Line 2067: FROM ahl_route_effectivities refct, AHL_ROUTES_APP_V RM

2063: where operation_id = p_operation_id;
2064: CURSOR get_efct_rec ( C_ROUTE_EFFECTIVITY_ID NUMBER )
2065: IS
2066: SELECT RM.ROUTE_ID
2067: FROM ahl_route_effectivities refct, AHL_ROUTES_APP_V RM
2068: WHERE refct.ROUTE_EFFECTIVITY_ID = C_ROUTE_EFFECTIVITY_ID
2069: AND RM.ROUTE_ID = refct.ROUTE_ID;
2070: l_api_version CONSTANT NUMBER := 1.0;
2071: l_return_status VARCHAR2(1);

Line 2658: from ahl_routes_app_v

2654: IS
2655: cursor get_route_status (p_route_id in number)
2656: is
2657: select revision_status_code
2658: from ahl_routes_app_v
2659: where route_id = p_route_id;
2660: l_obj_status VARCHAR2(30);
2661: l_api_version CONSTANT NUMBER := 1.0;
2662: l_return_status VARCHAR2(1);