APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on CS_INCIDENTS_ALL_B

Line 130: cs_incidents_all_b ci

126: ci.customer_id
127:
128: FROM ahl_visit_tasks_b vt,
129: ahl_visits_b vs,
130: cs_incidents_all_b ci
131:
132: WHERE vt.visit_task_id = C_VISIT_TASK_ID
133: AND vt.visit_id=vs.visit_id
134: AND vs.service_request_id = ci.incident_id(+)

Line 853: cs_incidents_all_b ci

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;
857:

Line 867: cs_incidents_all_b ci

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');
871: l_visit_dtls_rec Get_visit_dtls_cur%ROWTYPE;

Line 1635: cs_incidents_all_b cs

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
1639: AND NVL(vt.status_code, 'Y') <> NVL ('DELETED', 'X');

Line 2940: from CS_INCIDENTS_ALL_B

2936:
2937: Cursor c_customer_csr(c_sr_req_id in number)
2938: Is
2939: select Customer_id
2940: from CS_INCIDENTS_ALL_B
2941: where incident_id=c_sr_req_id;
2942:
2943:
2944: -- AnRaj: Query changed for fixing performance bug 4919475