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.CSM_USER_EVENT_PKG dependencies on CS_INCIDENTS_ALL_B

Line 230: FROM cs_incidents_all_b inc,

226: WHERE jt.created_by = b_user_id
227: AND jt.source_object_type_code ='SR'
228: AND EXISTS
229: (SELECT inc.incident_id
230: FROM cs_incidents_all_b inc,
231: cs_incident_statuses_b ists
232: WHERE inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
233: AND NVL(ists.CLOSE_FLAG,'N')= 'N'
234: AND inc.incident_id = jt.source_object_id

Line 271: FROM cs_incidents_all_b inc,

267: -- get all open incident_ids owned/created by mobile user
268: CURSOR l_incident_csr (b_grp_id NUMBER,b_user_id NUMBER)
269: IS
270: SELECT incident_id
271: FROM cs_incidents_all_b inc,
272: cs_incident_statuses_b ists
273: WHERE (
274: inc.owner_group_id = b_grp_id
275: OR

Line 361: FROM cs_incidents_all_b inc,

357: AND jtf_ta.resource_id = jtf_rs.resource_id
358: AND jt.source_object_type_code ='SR'
359: AND EXISTS
360: (SELECT 'X'
361: FROM cs_incidents_all_b inc,
362: cs_incident_statuses_b ists
363: WHERE inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
364: AND NVL(ists.CLOSE_FLAG,'N')= 'N'
365: AND inc.incident_id = jt.source_object_id