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 JTF_TASK_ASSIGNMENTS

Line 331: jtf_task_assignments jtf_ta,

327: CURSOR l_task_assign_csr (p_user_id NUMBER)
328: IS
329: SELECT jtf_ta.task_assignment_id --get all the task assignments which are open and of type TASK
330: FROM jtf_rs_resource_extns jtf_rs,
331: jtf_task_assignments jtf_ta,
332: jtf_task_statuses_b jts_jta
333: WHERE jtf_rs.user_id = p_user_id
334: AND jtf_ta.resource_id = jtf_rs.resource_id
335: AND jts_jta.task_Status_id = jtf_ta.assignment_status_id

Line 353: jtf_task_assignments jtf_ta,

349: )
350: UNION ALL--Select task assignments which are for open SRs
351: SELECT jtf_ta.task_assignment_id
352: FROM jtf_rs_resource_extns jtf_rs,
353: jtf_task_assignments jtf_ta,
354: JTF_TASKS_B jt
355: WHERE jtf_rs.user_id = p_user_id
356: AND jt.task_id = jtf_ta.task_id
357: AND jtf_ta.resource_id = jtf_rs.resource_id