APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on AHL_VISIT_TASKS_VL

Line 852: FROM ahl_visit_tasks_vl vt,

848: vt.visit_task_id,
849: vt.object_version_number,
850: vt.visit_task_number,
851: vt.visit_task_name
852: FROM ahl_visit_tasks_vl vt,
853: cs_incidents_all_b ci
854: WHERE visit_task_id = c_visit_task_id
855: AND NVL(vt.status_code, 'Y') <> NVL ('DELETED', 'X');
856: l_visit_task_dtls_rec Get_visit_task_dtls_cur%ROWTYPE;

Line 1634: ahl_visit_tasks_vl vt,

1630: cs.customer_id,
1631: vt.start_date_time, --Post11510 cxcheng added
1632: vt.end_date_time
1633: FROM ahl_visits_vl vs,
1634: ahl_visit_tasks_vl vt,
1635: cs_incidents_all_b cs
1636: WHERE vs.visit_id = vt.visit_id
1637: AND vs.service_request_id = cs.incident_id(+)
1638: AND vt.visit_task_id = C_VISIT_TASK_ID

Line 2915: from ahl_visit_tasks_vl

2911: price_list_id,
2912: service_request_id,
2913: start_date_time,
2914: end_date_time
2915: from ahl_visit_tasks_vl
2916: where visit_task_id=c_visit_task_id;
2917:
2918: l_task_rec c_task_csr%rowtype;
2919:

Line 2959: from ahl_visit_tasks_vl tsk,

2955: select mrb.title mr_name,
2956: mrtl.description mr_description,
2957: visit_task_number task_number,
2958: visit_task_name task_name
2959: from ahl_visit_tasks_vl tsk,
2960: ahl_mr_headers_tl mrtl,
2961: ahl_mr_headers_b mrb,
2962: ahl_mr_routes mrr,
2963: ahl_visits_vl avts

Line 2978: from ahl_visit_tasks_vl tsk,

2974: select title mr_name,
2975: mrh.description mr_description,
2976: visit_task_number task_number,
2977: visit_task_name task_name
2978: from ahl_visit_tasks_vl tsk,
2979: ahl_mr_headers_vl mrh,
2980: AHL_VISITS_VL AVTS
2981: where MRH.MR_HEADER_ID = TSK.MR_ID
2982: AND NVL(TSK.STATUS_CODE,'X') <> 'DELETED'