APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_VISIT_TASKS_VL

Line 538: FROM ahl_visit_tasks_vl

534: END IF;
535:
536: --Check for visit task type
537: SELECT TASK_TYPE_CODE INTO l_task_type_code
538: FROM ahl_visit_tasks_vl
539: WHERE visit_task_id = p_visit_task_id;
540: --From unplanned and Unassociated
541: IF l_task_type_code IN ('UNPLANNED','UNASSOCIATED') THEN
542: l_material_request_type := 'UNPLANNED';

Line 1491: ahl_visit_tasks_vl vt,

1487: nvl(vt.start_date_time,vs.start_date_time) start_date_time,
1488: mr.route_id
1489:
1490: FROM ahl_visits_vl vs,
1491: ahl_visit_tasks_vl vt,
1492: ahl_mr_routes_app_v mr
1493: WHERE vs.visit_id = vt.visit_id
1494: AND vt.mr_route_id = mr.mr_route_id
1495: AND vs.visit_id = C_VISIT_ID

Line 1504: FROM ahl_visit_tasks_vl vt,

1500: IS
1501: SELECT mr.route_id,
1502: vt.instance_id,
1503: vt.start_date_time
1504: FROM ahl_visit_tasks_vl vt,
1505: ahl_mr_routes_app_v mr
1506: WHERE vt.mr_route_id = mr.mr_route_id
1507: AND mr.mr_route_id = C_MR_ROUTE_ID;
1508:

Line 2637: ahl_visit_tasks_vl vt

2633: SELECT vs.visit_id,
2634: vs.organization_id,
2635: vt.visit_task_id
2636: FROM ahl_visits_vl vs,
2637: ahl_visit_tasks_vl vt
2638: WHERE vs.visit_id = vt.visit_id
2639: AND vs.visit_id = c_visit_id
2640: AND vt.visit_task_id = c_visit_task_id;
2641: --To Retrieve visit task planned materials