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 nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate
63: and nvl(jtb.scheduled_end_date, sysdate - 1) > sysdate

Line 107: jtf_task_types_vl jtt_vl

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

Line 161: jtf_task_types_vl jtt_vl

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

Line 907: jtf_task_types_vl jtt_vl

903: jta.assignment_status_id
904: FROM jtf_tasks_b jtb,
905: jtf_task_assignments jta,
906: jtf_task_priorities_vl jp_vl,
907: jtf_task_types_vl jtt_vl
908: WHERE jta.task_assignment_id = v_task_assgn_id
909: and jta.task_id = jtb.task_id
910: and nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate
911: and nvl(jtb.scheduled_end_date, sysdate - 1) > sysdate