APPS.AHL_VWP_TIMES_PVT dependencies on AHL_ROUTES_APP_V

Line 403: ahl_routes_app_v routes, ahl_mr_routes_app_v mr,

399: max(NVL(vtsk.duration, NVL(Get_task_duration(vtsk.quantity, routes.route_id), 0))) duration,
400: max(vtsk.stage_id) stage_id,
401: max(vtsk.department_id) department_id
402: FROM AHL_VISIT_TASKS_B vtsk,
403: ahl_routes_app_v routes, ahl_mr_routes_app_v mr,
404: (SELECT visit_task_id, level+1 task_level
405: FROM ahl_task_links tl
406: WHERE visit_task_id in (
407: SELECT visit_task_id from ahl_visit_tasks_b vt

Line 818: ahl_routes_app_v routes, ahl_mr_routes_app_v mr

814: nvl(vt.duration, NVL(Get_task_duration(vt.quantity, routes.route_id), 0)) duration,
815: vt.stage_id,
816: nvl(vt.start_from_hour, 0)
817: FROM AHL_VISIT_TASKS_B vt, AHL_VISITS_B v,
818: ahl_routes_app_v routes, ahl_mr_routes_app_v mr
819: WHERE vt.visit_id = v.visit_id
820: AND routes.route_id (+) = mr.route_id
821: AND mr.mr_route_id (+)= vt.mr_route_id
822: AND vt.visit_task_id = p_task_id