APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on AHL_VISITS_VL

Line 866: FROM ahl_visits_vl vs,

862: vs.start_date_time,
863: vs.close_date_time,
864: vs.service_request_id,
865: ci.customer_id
866: FROM ahl_visits_vl vs,
867: cs_incidents_all_b ci
868: WHERE visit_id = c_visit_id
869: AND vs.service_request_id = ci.incident_id(+)
870: AND NVL(vs.status_code, 'Y') <> NVL ('DELETED', 'X');

Line 1633: FROM ahl_visits_vl vs,

1629: vt.service_request_id,
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(+)

Line 2930: from ahl_visits_vl

2926: outside_party_flag,
2927: service_request_id,
2928: organization_id,
2929: any_task_chg_flag
2930: from ahl_visits_vl
2931: where visit_id=c_visit_id;
2932:
2933: l_visit_rec c_visit_csr%rowtype;
2934:

Line 2963: ahl_visits_vl avts

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
2964: where tsk.mr_route_id = mrr.mr_route_id(+)
2965: and mrr.mr_header_id = mrb.mr_header_id(+)
2966: and mrb.mr_header_id = mrtl.mr_header_id (+)
2967: and mrtl.language(+) = USERENV('LANG')

Line 2980: AHL_VISITS_VL AVTS

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'
2983: AND AVTS.VISIT_ID = TSK.VISIT_ID
2984: AND AVTS.TEMPLATE_FLAG = 'N'