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_APPROVAL_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 57: FROM AHL_ROUTES_APP_V A,AHL_MR_ROUTES B,AHL_VISIT_TASKS_B C,AHL_VISITS_VL D,AHL_ROUTE_OPERATIONS E

53:
54: CURSOR CurOper
55: is
56: SELECT C.*,D.VISIT_NUMBER
57: FROM AHL_ROUTES_APP_V A,AHL_MR_ROUTES B,AHL_VISIT_TASKS_B C,AHL_VISITS_VL D,AHL_ROUTE_OPERATIONS E
58: WHERE A.ROUTE_ID=B.ROUTE_ID
59: AND A.ROUTE_ID=E.ROUTE_ID
60: AND B.MR_ROUTE_ID=C.MR_ROUTE_ID
61: AND C.VISIT_ID=D.VISIT_ID

Line 305: ahl_route_operations arop,

301: CURSOR get_asso_active_routes(c_oper_id IN NUMBER, c_op_duration IN NUMBER)
302: IS
303: SELECT rou.route_id
304: FROM AHL_ROUTES_APP_V rou ,
305: ahl_route_operations arop,
306: ahl_operations_b oper
307: WHERE (
308: TRUNC(rou.start_date_active) >= TRUNC(oper.start_date_active)
309: AND