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.CSF_ALERTS_PUB dependencies on JTF_TASK_TYPES_VL

Line 59: jtf_task_types_vl jtt_vl

55: jta.assignment_status_id
56: FROM jtf_tasks_b jtb,
57: jtf_task_assignments jta,
58: jtf_task_priorities_vl jp_vl,
59: jtf_task_types_vl jtt_vl
60: WHERE jta.task_assignment_id = v_task_assgn_id
61: and jta.task_id = jtb.task_id
62: and jtb.source_object_type_code = 'SR'
63: and nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate

Line 108: jtf_task_types_vl jtt_vl

104: jta.resource_type_code
105: FROM jtf_tasks_b jtb,
106: jtf_task_assignments jta,
107: jtf_task_priorities_vl jp_vl,
108: jtf_task_types_vl jtt_vl
109: WHERE jta.task_assignment_id = v_task_assgn_id
110: and jta.task_id = jtb.task_id
111: and jtb.source_object_type_code = 'SR'
112: and nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate

Line 163: jtf_task_types_vl jtt_vl

159: SELECT jtb.scheduled_start_date,
160: jtb.scheduled_end_date
161: FROM jtf_tasks_b jtb,
162: jtf_task_priorities_vl jp_vl,
163: jtf_task_types_vl jtt_vl
164: WHERE jtb.task_id = v_task_id
165: and nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate
166: and jtb.source_object_type_code = 'SR'
167: and jtb.task_type_id = jtt_vl.task_type_id

Line 917: jtf_task_types_vl jtt_vl

913: jta.assignment_status_id
914: FROM jtf_tasks_b jtb,
915: jtf_task_assignments jta,
916: jtf_task_priorities_vl jp_vl,
917: jtf_task_types_vl jtt_vl
918: WHERE jta.task_assignment_id = v_task_assgn_id
919: and jta.task_id = jtb.task_id
920: and nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate
921: and nvl(jtb.scheduled_end_date, sysdate - 1) > sysdate