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_TASKS_B

Line 207: FROM JTF_TASKS_B jt,

203:
204: CURSOR l_task_csr (b_user_id number)
205: IS --SELECT tasks which are open and are closed and within history days
206: SELECT jt.task_id
207: FROM JTF_TASKS_B jt,
208: jtf_task_statuses_b jts
209: WHERE jt.created_by = b_user_id
210: AND jts.task_status_id = jt.task_status_id
211: AND ( --task which are closed and within history days

Line 225: FROM JTF_TASKS_B jt

221: )
222: )
223: UNION --select tasks which are created by the user and their correspdg SR is open
224: SELECT jt.task_id
225: FROM JTF_TASKS_B jt
226: WHERE jt.created_by = b_user_id
227: AND jt.source_object_type_code ='SR'
228: AND EXISTS
229: (SELECT inc.incident_id

Line 341: FROM jtf_tasks_b jt,

337: OR NVL(jts_jta.completed_flag, 'N') = 'Y' OR NVL(jts_jta.rejected_flag,'N') = 'Y')
338: AND EXISTS (
339:
340: SELECT 1
341: FROM jtf_tasks_b jt,
342: jtf_task_statuses_b jts
343: WHERE jt.task_id = jtf_ta.task_id
344: AND jts.task_status_id = jt.task_status_id
345: AND jt.source_object_type_code ='TASK'

Line 354: JTF_TASKS_B jt

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
358: AND jt.source_object_type_code ='SR'