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 JTF_TASKS_TL

Line 1094: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,

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
1098: AND b.TASK_ID=tsk.TASK_ID

Line 1122: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,

1118: 'HZ_LOCATION',
1119: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1120: ) location_id
1121: FROM ASG_USER AU, CSM_TASKS_ACC ACC,
1122: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,
1123: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1124: WHERE acc.TASK_ID=b_task_id
1125: AND acc.TASK_ID=tsk.TASK_ID
1126: AND au.USER_ID=acc.USER_ID

Line 1143: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr

1139: IS
1140: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, acc.TASK_ID,TASK_NAME,TASK_NUMBER,
1141: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id
1142: FROM ASG_USER AU, CSM_TASKS_ACC ACC,
1143: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr
1144: WHERE acc.TASK_ID=b_task_id
1145: AND acc.TASK_ID=tsk.TASK_ID
1146: AND au.USER_ID=acc.USER_ID
1147: AND tsk.TASK_ID=tsk_tl.TASK_ID

Line 1159: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr

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
1163: AND acc.TASK_ASSIGNMENT_ID=b.TASK_ASSIGNMENT_ID