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_NOTIFICATION_EVENT_PKG dependencies on CSM_TASK_ASSIGNMENTS_ACC

Line 1093: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,

1089: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1090: 'HZ_LOCATION',
1091: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1092: ) location_id
1093: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,
1094: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,
1095: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1096: WHERE au.RESOURCE_ID=b.RESOURCE_ID
1097: AND b.TASK_ASSIGNMENT_ID=b_task_ass_id

Line 1158: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,

1154: CURSOR c_user_task_assigned2(b_task_ass_id NUMBER)
1155: IS
1156: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, b.TASK_ID,TASK_NAME,TASK_NUMBER,
1157: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id
1158: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,
1159: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr
1160: WHERE au.RESOURCE_ID=b.RESOURCE_ID
1161: AND b.TASK_ASSIGNMENT_ID=b_task_ass_id
1162: AND b.TASK_ID=tsk.TASK_ID