APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_MR_HEADERS_V

Line 1803: FROM ahl_mr_headers_v amh,ahl_visit_tasks_vl avt

1799: SELECT SUBSTR(NVL(amh.title,avt.visit_task_name),1,20) task_name, NVL(amh.title,avt.visit_task_name) description,
1800: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date, avt.visit_task_id,
1801: avt.end_date_time task_end_date, avt.task_type_code, avt.cost_parent_id, avt.service_type_code, avt.status_code -- PRAKKUM :: PIE :: 13-OCT-2010
1802: , avt.repair_batch_name --PRAKKUM :: 11/06/2012 :: Bug 14068468
1803: FROM ahl_mr_headers_v amh,ahl_visit_tasks_vl avt
1804: WHERE avt.visit_id = p_visit_id
1805: AND NVL(avt.status_code,'Y') = 'PLANNING'
1806: AND avt.task_type_code = 'SUMMARY'
1807: AND avt.summary_task_flag = 'N'

Line 2590: FROM ahl_mr_headers_v amh,ahl_visit_tasks_vl avt, pa_proj_element_versions ppev

2586: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date,
2587: avt.end_date_time task_end_date, avt.project_Task_id project_task_id, ppev.display_sequence,
2588: avt.task_type_code, avt.cost_parent_id, avt.service_type_code, avt.visit_task_id
2589: , avt.repair_batch_name --PRAKKUM :: 11/06/2012 :: Bug 14068468
2590: FROM ahl_mr_headers_v amh,ahl_visit_tasks_vl avt, pa_proj_element_versions ppev
2591: WHERE avt.visit_id = p_visit_id
2592: --VWPE: ER:12424063 :: SKPATHAK :: 07-JUN-2012 :: Tasks should not be in deleted status
2593: AND NVL(avt.status_code,'Y') <> 'DELETED'
2594: AND avt.task_type_code = 'SUMMARY'

Line 11868: FROM ahl_mr_headers_v amh, ahl_visit_tasks_vl avt

11864: AND mrr.route_id = ar.route_id (+)
11865: UNION ALL
11866: SELECT SUBSTR(NVL(amh.title, avt.visit_task_name), 1, 20) task_name,
11867: NVL(amh.title, avt.visit_task_name) description
11868: FROM ahl_mr_headers_v amh, ahl_visit_tasks_vl avt
11869: WHERE avt.visit_task_id = c_visit_task_id
11870: AND NVL(avt.status_code, 'X') = 'PLANNING'
11871: AND avt.task_type_code = 'SUMMARY'
11872: AND avt.summary_task_flag = 'N'