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 780: FROM JTF_TASKS_TL jtf1T, JTF_TASKS_B jtf1B

776: , DECODE(jtf1B.scheduled_start_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,jtf1B.scheduled_start_date),l_date_format)) task_scheduled_start_date
777: , DECODE(jtf1B.scheduled_end_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,jtf1B.scheduled_end_date),l_date_format)) task_scheduled_end_date
778: , DECODE(jtf1B.actual_start_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,jtf1B.ACTUAL_START_DATE),l_date_format)) task_actual_start_date
779: , DECODE(jtf1B.actual_end_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,jtf1B.ACTUAL_END_DATE),l_date_format)) task_actual_end_date
780: FROM JTF_TASKS_TL jtf1T, JTF_TASKS_B jtf1B
781: , jtf_tasks_b jtf2
782: , jtf_task_types_tl type
783: , jtf_task_priorities_tl priority
784: , JTF_TASK_STATUSES_TL statusT, JTF_TASK_STATUSES_B statusB

Line 781: , jtf_tasks_b jtf2

777: , DECODE(jtf1B.scheduled_end_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,jtf1B.scheduled_end_date),l_date_format)) task_scheduled_end_date
778: , DECODE(jtf1B.actual_start_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,jtf1B.ACTUAL_START_DATE),l_date_format)) task_actual_start_date
779: , DECODE(jtf1B.actual_end_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,jtf1B.ACTUAL_END_DATE),l_date_format)) task_actual_end_date
780: FROM JTF_TASKS_TL jtf1T, JTF_TASKS_B jtf1B
781: , jtf_tasks_b jtf2
782: , jtf_task_types_tl type
783: , jtf_task_priorities_tl priority
784: , JTF_TASK_STATUSES_TL statusT, JTF_TASK_STATUSES_B statusB
785: , jtf_objects_tl obj_vl

Line 1382: jtf_tasks_b t

1378: CURSOR Get_Escalation (v_incident_id NUMBER) IS
1379: SELECT fnd1.meaning escalation_level
1380: FROM fnd_lookups fnd1,
1381: jtf_task_references_b r,
1382: jtf_tasks_b t
1383: WHERE fnd1.lookup_type = 'JTF_EC_ESC_LEVEL'and
1384: fnd1.lookup_code = t.escalation_level and
1385: v_incident_id = r.OBJECT_ID and
1386: r.object_type_code = 'SR' and