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.CAC_VIEW_AVAIL_PVT dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 228: FROM jtf_task_all_assignments jta

224: , jtb.source_object_type_code ItemSourceCode
225: , jtb.calendar_start_date StartDate
226: , jtb.calendar_end_date EndDate
227: , jtb.timezone_id TimezoneID
228: FROM jtf_task_all_assignments jta
229: , jtf_tasks_b jtb
230: , jtf_task_statuses_b jtsb
231: WHERE jta.resource_id = b_ResourceID -- 101272224
232: AND jta.resource_type_code = b_ResourceType -- 'RS_EMPLOYEE'

Line 487: FROM jtf_task_all_assignments jta

483: , jtb.calendar_start_date StartDate
484: , jtb.calendar_end_date EndDate
485: , jtb.timezone_id TimezoneID
486: , NVL(jta.free_busy_type,'BUSY') FreeBusyType
487: FROM jtf_task_all_assignments jta
488: , jtf_tasks_b jtb
489: , jtf_task_statuses_b jtsb
490: WHERE jta.resource_id = b_ResourceID -- 101272224
491: AND jta.resource_type_code = b_ResourceType -- 'RS_EMPLOYEE'

Line 730: FROM jtf_task_all_assignments jta

726: CURSOR c_resources (b_task_id NUMBER) IS
727: SELECT jta.resource_id
728: , jta.resource_type_code
729: , jtf_task_utl.get_owner(jta.resource_type_code, jta.resource_id) resource_name
730: FROM jtf_task_all_assignments jta
731: WHERE jta.task_id = b_task_id
732: AND jta.show_on_calendar = 'Y'
733: AND jta.assignment_status_id <> 4 -- using status rejected for declined
734: AND jta.resource_type_code IN ('PN_LOCATIONS', 'RS_EMPLOYEE', 'RS_GROUP');