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_SERVICEREQUEST_PVT dependencies on CS_SR_STATUS_TRANSITIONS

Line 6507: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype

6503: --Check if status_group_id is defined in 'CS_SR_TYPE_MAPPING'
6504: --table first If it is not defined,then look in cs_incident_types
6505: BEGIN
6506: SELECT task_template_id into l_task_template_id
6507: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype
6508: WHERE srtype.incident_type_id = l_service_request_rec.type_id
6509: AND srtype.responsibility_id = p_resp_id
6510: AND trunc(sysdate) BETWEEN
6511: trunc(nvl(srtype.start_date, sysdate)) AND

Line 6525: FROM cs_sr_status_transitions cst,cs_incident_types_b cit

6521: IF l_task_template_id IS NULL THEN
6522: BEGIN
6523: --Get task template id
6524: select task_template_id into l_task_template_id
6525: FROM cs_sr_status_transitions cst,cs_incident_types_b cit
6526: WHERE cit.incident_type_id = l_service_request_rec.type_id
6527: AND cst.status_group_id=cit.status_group_id
6528: AND from_incident_status_id = l_old_servicerequest_rec.incident_status_id --refers to old status_id
6529: AND to_incident_status_id = l_service_request_rec.status_id; -- refers to new status_id

Line 7726: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype

7722: --Check if status_group_id is defined in 'CS_SR_TYPE_MAPPING'
7723: --table first If it is not defined,then look in cs_incident_types
7724: BEGIN
7725: SELECT task_template_id into l_task_template_id
7726: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype
7727: WHERE srtype.incident_type_id = l_servicerequest_rec.incident_type_id
7728: AND srtype.responsibility_id = p_resp_id
7729: AND trunc(sysdate) BETWEEN
7730: trunc(nvl(srtype.start_date, sysdate)) AND

Line 7744: FROM cs_sr_status_transitions cst,cs_incident_types_b cit

7740: IF l_task_template_id IS NULL THEN
7741: BEGIN
7742: --Get task template id
7743: select task_template_id into l_task_template_id
7744: FROM cs_sr_status_transitions cst,cs_incident_types_b cit
7745: WHERE cit.incident_type_id = l_servicerequest_rec.incident_type_id
7746: AND cst.status_group_id=cit.status_group_id
7747: AND from_incident_status_id = l_servicerequest_rec.incident_status_id --refers to old status_id
7748: AND to_incident_status_id = p_status_id; -- refers to new status_id