APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_MR_HEADERS_V

Line 1121: FROM ahl_mr_headers_v amh,ahl_visit_tasks_vl avt

1117: UNION ALL
1118: SELECT SUBSTR(NVL(amh.title,avt.visit_task_name),1,20) task_name, NVL(amh.title,avt.visit_task_name) description,
1119: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date,
1120: avt.end_date_time task_end_date
1121: FROM ahl_mr_headers_v amh,ahl_visit_tasks_vl avt
1122: WHERE avt.visit_id = p_visit_id
1123: AND NVL(avt.status_code,'Y') = 'PLANNING'
1124: AND avt.task_type_code = 'SUMMARY'
1125: AND avt.summary_task_flag = 'N'

Line 1649: FROM ahl_mr_headers_v amh,ahl_visit_tasks_vl avt

1645: UNION ALL
1646: SELECT SUBSTR(NVL(amh.title,avt.visit_task_name),1,20) task_name, NVL(amh.title,avt.visit_task_name) description,
1647: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date,
1648: avt.end_date_time task_end_date, avt.project_Task_id project_task_id
1649: FROM ahl_mr_headers_v amh,ahl_visit_tasks_vl avt
1650: WHERE avt.visit_id = p_visit_id
1651: AND NVL(avt.status_code,'Y') = 'PLANNING'
1652: AND avt.task_type_code = 'SUMMARY'
1653: AND avt.summary_task_flag = 'N'

Line 8237: FROM ahl_mr_headers_v amh, ahl_visit_tasks_vl avt

8233: AND mrr.route_id = ar.route_id (+)
8234: UNION ALL
8235: SELECT SUBSTR(NVL(amh.title, avt.visit_task_name), 1, 20) task_name,
8236: NVL(amh.title, avt.visit_task_name) description
8237: FROM ahl_mr_headers_v amh, ahl_visit_tasks_vl avt
8238: WHERE avt.visit_task_id = c_visit_task_id
8239: AND NVL(avt.status_code, 'X') = 'PLANNING'
8240: AND avt.task_type_code = 'SUMMARY'
8241: AND avt.summary_task_flag = 'N'