DBA Data[Home] [Help]

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_INCIDENTS_ALL_VL

Line 1438: FROM cs_incidents_all_vl inc

1434: l_employee_id NUMBER;
1435:
1436: CURSOR l_sel_curr_sr_details_csr IS
1437: SELECT incident_type_id,incident_status_id,incident_urgency_id,incident_severity_id,summary
1438: FROM cs_incidents_all_vl inc
1439: WHERE inc.incident_number = l_request_number;
1440:
1441: l_sel_curr_sr_details_rec l_sel_curr_sr_details_csr%ROWTYPE;
1442:

Line 1501: FROM cs_incidents_all_vl a,

1497: -- 2. NTFY_LINKED_SR_SUMMARY
1498: -- 3. NTFY_LINK_TYPE
1499: CURSOR sel_linked_sr_details_csr IS
1500: SELECT a.summary, b.name
1501: FROM cs_incidents_all_vl a,
1502: cs_incident_statuses_vl b
1503: WHERE a.incident_status_id = b.incident_status_id AND
1504: a.incident_id = l_request_id;
1505:

Line 6307: FROM CS_INCIDENTS_ALL_VL INC,

6303: RA2.PARTY_NAME CUSTOMER_NAME,
6304: CSLKUP.DESCRIPTION PROBLEM_CODE_DESCRIPTION,
6305: MTL.DESCRIPTION PRODUCT_DESCRIPTION,
6306: INC.PROBLEM_CODE --5245018
6307: FROM CS_INCIDENTS_ALL_VL INC,
6308: --CS_INCIDENT_TYPES_VL TYPE,
6309: CS_INCIDENT_TYPES_TL TYPE,
6310: --CS_INCIDENT_SEVERITIES_VL SEVERITY,
6311: CS_INCIDENT_SEVERITIES_TL SEVERITY,