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_VISITS_VL

Line 37: FROM AHL_ROUTES_APP_V A,AHL_MR_ROUTES B,AHL_VISIT_TASKS_B C,AHL_VISITS_VL D

33:
34: CURSOR CurRoute
35: is
36: SELECT C.*,D.VISIT_NUMBER
37: FROM AHL_ROUTES_APP_V A,AHL_MR_ROUTES B,AHL_VISIT_TASKS_B C,AHL_VISITS_VL D
38: WHERE A.ROUTE_ID=p_activity_id
39: AND A.ROUTE_ID=B.ROUTE_ID
40: AND B.MR_ROUTE_ID=C.MR_ROUTE_ID
41: AND C.VISIT_ID=D.VISIT_ID

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