eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_INCIDENTS_ALL_B

Line 216: FROM cs_incidents_all_b

212:
213: -- Fix similar to 11.5.9 bug 3106572. rmanabat 10/13/03.
214: CURSOR sel_incident_id_csr IS
215: SELECT INCIDENT_ID
216: FROM cs_incidents_all_b
217: WHERE INCIDENT_NUMBER = l_request_number;
218:
219: CURSOR sel_incident_number_csr IS
220: SELECT INCIDENT_NUMBER

Line 221: FROM cs_incidents_all_b

217: WHERE INCIDENT_NUMBER = l_request_number;
218:
219: CURSOR sel_incident_number_csr IS
220: SELECT INCIDENT_NUMBER
221: FROM cs_incidents_all_b
222: WHERE INCIDENT_ID = l_request_id;
223:
224:
225: /* RHUNGUND - 04/05/04

Line 650: cs_incidents_all_b inc

646: cil.object_id,
647: cil.link_id,
648: inc.incident_owner_id
649: FROM cs_incident_links cil,
650: cs_incidents_all_b inc
651: WHERE cil.subject_id = l_request_id
652: and inc.incident_id = cil.object_id
653: ORDER BY cil.object_id;
654:

Line 663: cs_incidents_all_b inc

659: cil.object_id,
660: cil.link_id,
661: inc.incident_owner_id
662: FROM cs_incident_links cil,
663: cs_incidents_all_b inc
664: WHERE cil.subject_id = l_request_id
665: AND cil.link_type_id = l_relationship_type_id
666: AND inc.incident_id = cil.object_id
667: ORDER BY cil.object_id;

Line 686: SELECT incident_owner_id FROM cs_incidents_all_b WHERE

682: l_user_id NUMBER;
683: l_prev_owner_id NUMBER;
684:
685: CURSOR sel_inc_owner_id IS
686: SELECT incident_owner_id FROM cs_incidents_all_b WHERE
687: incident_id = l_request_id;
688:
689: CURSOR sel_resource_id IS
690: SELECT resource_id FROM jtf_rs_resource_extns emp, fnd_user users WHERE

Line 743: FROM cs_incidents_all_b

739: /***********
740:
741: SELECT INCIDENT_ID
742: INTO l_request_id
743: FROM cs_incidents_all_b
744: WHERE INCIDENT_NUMBER = l_request_number;
745: *************/
746:
747: l_request_id := WF_ENGINE.GetItemAttrNumber(

Line 1071: l_incident_owner_id cs_incidents_all_b.INCIDENT_OWNER_ID%TYPE;

1067: l_notify_recipient VARCHAR2(100);
1068: l_notification_template_id VARCHAR2(30);
1069: l_linked_subject_list VARCHAR2(4000);
1070: l_element VARCHAR2(100);
1071: l_incident_owner_id cs_incidents_all_b.INCIDENT_OWNER_ID%TYPE;
1072: l_request_id NUMBER;
1073: l_contact_email VARCHAR2(2000);
1074: l_contact_email_list VARCHAR2(2000);
1075: l_contact_point_id NUMBER;

Line 1394: cs_incidents_all_b inc,

1390: cil.object_id,
1391: cil.link_type_id,
1392: cilt.name link_type_name
1393: FROM cs_incident_links cil,
1394: cs_incidents_all_b inc,
1395: CS_SR_LINK_TYPES_VL cilt
1396: WHERE cil.subject_id = l_request_id
1397: and cil.object_id = l_notify_subject_id
1398: and inc.incident_id = cil.object_id

Line 1460: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c

1456:
1457:
1458: CURSOR l_get_resource_name_csr IS
1459: SELECT source_last_name,source_first_name
1460: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c
1461: WHERE c.last_updated_by = b.user_id and
1462: b.employee_id = a.source_id and
1463: c.incident_number = l_request_number;
1464:

Line 1469: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c

1465: l_get_resource_name_rec l_get_resource_name_csr%ROWTYPE;
1466:
1467: CURSOR l_get_create_rsrc_csr IS
1468: SELECT source_last_name,source_first_name
1469: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c
1470: WHERE c.created_by = b.user_id and
1471: b.employee_id = a.source_id and
1472: c.incident_number = l_request_number;
1473:

Line 4370: cs_incidents_all_b inc

4366: cil.object_id,
4367: cil.link_id,
4368: inc.incident_owner_id
4369: FROM cs_incident_links cil,
4370: cs_incidents_all_b inc
4371: WHERE cil.subject_id = l_request_id
4372: and inc.incident_id = cil.object_id
4373: and cil.object_id > l_subject_id
4374: ORDER BY cil.object_id;

Line 4382: cs_incidents_all_b inc

4378: cil.object_id,
4379: cil.link_id,
4380: inc.incident_owner_id
4381: FROM cs_incident_links cil,
4382: cs_incidents_all_b inc
4383: WHERE cil.subject_id = l_request_id
4384: AND cil.link_type_id = l_relationship_type_id
4385: AND inc.incident_id = cil.object_id
4386: and cil.object_id > l_subject_id

Line 5272: cs_incidents_all_b inc

5268:
5269: CURSOR sel_related_sr_cur(lv_incident_id IN NUMBER) IS
5270: SELECT cil.link_id
5271: FROM cs_incident_links cil,
5272: cs_incidents_all_b inc
5273: WHERE cil.subject_id = lv_incident_id
5274: -- Hard coded values for 'CAUSED BY' (2) and 'DUPLICATE OF' (3).
5275: AND cil.link_type_id = 2
5276: AND cil.object_id = inc.incident_id

Line 5282: FROM cs_incident_statuses status, cs_incidents_all_b inc

5278:
5279: CURSOR sel_close_flag_csr(lv_incident_id IN NUMBER) IS
5280: SELECT nvl(status.close_flag,'N'),
5281: inc.incident_status_id
5282: FROM cs_incident_statuses status, cs_incidents_all_b inc
5283: WHERE inc.incident_id = lv_incident_id
5284: AND inc.incident_status_id = status.incident_status_id;
5285:
5286: BEGIN

Line 5473: FROM cs_incidents_all_b

5469: l_resp_id NUMBER;
5470:
5471: CURSOR sel_incident_from_number_csr IS
5472: SELECT object_version_number, incident_owner_id, incident_id
5473: FROM cs_incidents_all_b
5474: WHERE incident_number = l_request_number;
5475:
5476:
5477: CURSOR sel_incident_from_id_csr IS

Line 5479: FROM cs_incidents_all_b

5475:
5476:
5477: CURSOR sel_incident_from_id_csr IS
5478: SELECT object_version_number, incident_owner_id
5479: FROM cs_incidents_all_b
5480: WHERE incident_id = l_subject_id;
5481:
5482:
5483: BEGIN

Line 5697: cs_incidents_all_b inc

5693:
5694: CURSOR l_cs_sr_get_empid_csr IS
5695: SELECT inc.incident_number, emp.source_id
5696: FROM jtf_rs_resource_extns emp ,
5697: cs_incidents_all_b inc
5698: WHERE emp.resource_id = inc.incident_owner_id
5699: AND inc.incident_id = l_subject_id;
5700:
5701: BEGIN

Line 5732: FROM cs_incidents_all_b

5728:
5729: /*************
5730: SELECT incident_number, incident_owner_id
5731: INTO l_request_number, l_subject_owner_id
5732: FROM cs_incidents_all_b
5733: WHERE incident_id = l_subject_id;
5734:
5735: IF (l_subject_owner_id IS NULL)THEN
5736: l_owner_role := NULL;

Line 6768: FROM cs_incidents_all_b

6764: AND rownum < 2;
6765:
6766: CURSOR c_incident_number IS
6767: SELECT incident_number
6768: FROM cs_incidents_all_b
6769: WHERE incident_id = p_incident_id;
6770:
6771:
6772: CURSOR sel_contact_party_name_csr IS