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.CS_ERES_INT_PKG dependencies on JTF_TASKS_B

Line 827: FROM JTF_TASKS_TL jtf1T, JTF_TASKS_B jtf1B

823: , DECODE(jtf1B.scheduled_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_start_date
824: , DECODE(jtf1B.scheduled_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_end_date
825: , DECODE(jtf1B.actual_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_START_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_start_date
826: , DECODE(jtf1B.actual_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_END_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_end_date
827: FROM JTF_TASKS_TL jtf1T, JTF_TASKS_B jtf1B
828: , jtf_tasks_b jtf2
829: , jtf_task_types_tl type
830: , jtf_task_priorities_tl priority
831: , JTF_TASK_STATUSES_TL statusT, JTF_TASK_STATUSES_B statusB

Line 828: , jtf_tasks_b jtf2

824: , DECODE(jtf1B.scheduled_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_end_date
825: , DECODE(jtf1B.actual_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_START_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_start_date
826: , DECODE(jtf1B.actual_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_END_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_end_date
827: FROM JTF_TASKS_TL jtf1T, JTF_TASKS_B jtf1B
828: , jtf_tasks_b jtf2
829: , jtf_task_types_tl type
830: , jtf_task_priorities_tl priority
831: , JTF_TASK_STATUSES_TL statusT, JTF_TASK_STATUSES_B statusB
832: , jtf_objects_tl obj_vl

Line 1453: jtf_tasks_b t

1449: CURSOR Get_Escalation (v_incident_id NUMBER) IS
1450: SELECT fnd1.meaning escalation_level
1451: FROM fnd_lookups fnd1,
1452: jtf_task_references_b r,
1453: jtf_tasks_b t
1454: WHERE fnd1.lookup_type = 'JTF_EC_ESC_LEVEL'and
1455: fnd1.lookup_code = t.escalation_level and
1456: v_incident_id = r.OBJECT_ID and
1457: r.object_type_code = 'SR' and