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 1072: l_incident_owner_id cs_incidents_all_b.INCIDENT_OWNER_ID%TYPE;

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

Line 1398: cs_incidents_all_b inc,

1394: cil.object_id,
1395: cil.link_type_id,
1396: cilt.name link_type_name
1397: FROM cs_incident_links cil,
1398: cs_incidents_all_b inc,
1399: CS_SR_LINK_TYPES_VL cilt
1400: WHERE cil.subject_id = l_request_id
1401: and cil.object_id = l_notify_subject_id
1402: and inc.incident_id = cil.object_id

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

1460:
1461:
1462: CURSOR l_get_resource_name_csr IS
1463: SELECT source_last_name,source_first_name
1464: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c
1465: WHERE c.last_updated_by = b.user_id and
1466: b.employee_id = a.source_id and
1467: c.incident_number = l_request_number;
1468:

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

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

Line 4432: cs_incidents_all_b inc

4428: cil.object_id,
4429: cil.link_id,
4430: inc.incident_owner_id
4431: FROM cs_incident_links cil,
4432: cs_incidents_all_b inc
4433: WHERE cil.subject_id = l_request_id
4434: and inc.incident_id = cil.object_id
4435: and cil.object_id > l_subject_id
4436: ORDER BY cil.object_id;

Line 4444: cs_incidents_all_b inc

4440: cil.object_id,
4441: cil.link_id,
4442: inc.incident_owner_id
4443: FROM cs_incident_links cil,
4444: cs_incidents_all_b inc
4445: WHERE cil.subject_id = l_request_id
4446: AND cil.link_type_id = l_relationship_type_id
4447: AND inc.incident_id = cil.object_id
4448: and cil.object_id > l_subject_id

Line 5336: cs_incidents_all_b inc

5332:
5333: CURSOR sel_related_sr_cur(lv_incident_id IN NUMBER) IS
5334: SELECT cil.link_id
5335: FROM cs_incident_links cil,
5336: cs_incidents_all_b inc
5337: WHERE cil.subject_id = lv_incident_id
5338: -- Hard coded values for 'CAUSED BY' (2) and 'DUPLICATE OF' (3).
5339: AND cil.link_type_id = 2
5340: AND cil.object_id = inc.incident_id

Line 5346: FROM cs_incident_statuses status, cs_incidents_all_b inc

5342:
5343: CURSOR sel_close_flag_csr(lv_incident_id IN NUMBER) IS
5344: SELECT nvl(status.close_flag,'N'),
5345: inc.incident_status_id
5346: FROM cs_incident_statuses status, cs_incidents_all_b inc
5347: WHERE inc.incident_id = lv_incident_id
5348: AND inc.incident_status_id = status.incident_status_id;
5349:
5350: BEGIN

Line 5537: FROM cs_incidents_all_b

5533: l_resp_id NUMBER;
5534:
5535: CURSOR sel_incident_from_number_csr IS
5536: SELECT object_version_number, incident_owner_id, incident_id
5537: FROM cs_incidents_all_b
5538: WHERE incident_number = l_request_number;
5539:
5540:
5541: CURSOR sel_incident_from_id_csr IS

Line 5543: FROM cs_incidents_all_b

5539:
5540:
5541: CURSOR sel_incident_from_id_csr IS
5542: SELECT object_version_number, incident_owner_id
5543: FROM cs_incidents_all_b
5544: WHERE incident_id = l_subject_id;
5545:
5546:
5547: BEGIN

Line 5761: cs_incidents_all_b inc

5757:
5758: CURSOR l_cs_sr_get_empid_csr IS
5759: SELECT inc.incident_number, emp.source_id
5760: FROM jtf_rs_resource_extns emp ,
5761: cs_incidents_all_b inc
5762: WHERE emp.resource_id = inc.incident_owner_id
5763: AND inc.incident_id = l_subject_id;
5764:
5765: BEGIN

Line 5796: FROM cs_incidents_all_b

5792:
5793: /*************
5794: SELECT incident_number, incident_owner_id
5795: INTO l_request_number, l_subject_owner_id
5796: FROM cs_incidents_all_b
5797: WHERE incident_id = l_subject_id;
5798:
5799: IF (l_subject_owner_id IS NULL)THEN
5800: l_owner_role := NULL;

Line 6832: FROM cs_incidents_all_b

6828: AND rownum < 2;
6829:
6830: CURSOR c_incident_number IS
6831: SELECT incident_number
6832: FROM cs_incidents_all_b
6833: WHERE incident_id = p_incident_id;
6834:
6835:
6836: CURSOR sel_contact_party_name_csr IS