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.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on CS_SR_TYPE_MAPPING

Line 1642: FROM CS_SR_TYPE_MAPPING

1638: DEFAULT_INCIDENT_STATUS_ID
1639: FROM
1640: --if the value is -1 then query1 ottherwisse get transition id nad stuff
1641: (select DECODE((select status_group_id
1642: FROM CS_SR_TYPE_MAPPING
1643: WHERE INCIDENT_TYPE_ID = P_INCIDENT_TYPE_ID
1644: and responsibility_id = P_RESP_ID
1645: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE, SYSDATE))
1646: AND TRUNC(NVL(END_DATE,SYSDATE))),

Line 1659: FROM CS_SR_TYPE_MAPPING

1655: and incident_subtype = 'INC'
1656: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE))
1657: AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))) ),
1658: (select status_group_id
1659: FROM CS_SR_TYPE_MAPPING
1660: WHERE INCIDENT_TYPE_ID = P_INCIDENT_TYPE_ID
1661: and responsibility_id =P_RESP_ID
1662: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE, SYSDATE))
1663: AND TRUNC(NVL(END_DATE,SYSDATE))) ) STATUS_GROUP_ID