DBA Data[Home] [Help]

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_INCIDENTS_ALL_VL

Line 1434: FROM cs_incidents_all_vl inc

1430: l_employee_id NUMBER;
1431:
1432: CURSOR l_sel_curr_sr_details_csr IS
1433: SELECT incident_type_id,incident_status_id,incident_urgency_id,incident_severity_id,summary
1434: FROM cs_incidents_all_vl inc
1435: WHERE inc.incident_number = l_request_number;
1436:
1437: l_sel_curr_sr_details_rec l_sel_curr_sr_details_csr%ROWTYPE;
1438:

Line 1497: FROM cs_incidents_all_vl a,

1493: -- 2. NTFY_LINKED_SR_SUMMARY
1494: -- 3. NTFY_LINK_TYPE
1495: CURSOR sel_linked_sr_details_csr IS
1496: SELECT a.summary, b.name
1497: FROM cs_incidents_all_vl a,
1498: cs_incident_statuses_vl b
1499: WHERE a.incident_status_id = b.incident_status_id AND
1500: a.incident_id = l_request_id;
1501:

Line 6243: FROM CS_INCIDENTS_ALL_VL INC,

6239: RA2.PARTY_NAME CUSTOMER_NAME,
6240: CSLKUP.DESCRIPTION PROBLEM_CODE_DESCRIPTION,
6241: MTL.DESCRIPTION PRODUCT_DESCRIPTION,
6242: INC.PROBLEM_CODE --5245018
6243: FROM CS_INCIDENTS_ALL_VL INC,
6244: --CS_INCIDENT_TYPES_VL TYPE,
6245: CS_INCIDENT_TYPES_TL TYPE,
6246: --CS_INCIDENT_SEVERITIES_VL SEVERITY,
6247: CS_INCIDENT_SEVERITIES_TL SEVERITY,