DBA Data[Home] [Help]

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