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

Line 550: FROM jtf_task_all_assignments

546: (calendar_end_date - calendar_start_date)*24*60 duration
547: FROM jtf_tasks_vl
548: WHERE task_id IN
549: (SELECT task_id
550: FROM jtf_task_all_assignments
551: WHERE task_id IN (SELECT task_id
552: FROM jtf_task_all_assignments
553: WHERE task_assignment_id = p_task_assignment_id)
554: AND assignee_role = 'OWNER')

Line 552: FROM jtf_task_all_assignments

548: WHERE task_id IN
549: (SELECT task_id
550: FROM jtf_task_all_assignments
551: WHERE task_id IN (SELECT task_id
552: FROM jtf_task_all_assignments
553: WHERE task_assignment_id = p_task_assignment_id)
554: AND assignee_role = 'OWNER')
555: ;
556:

Line 1488: , jtf_task_all_assignments jta

1484: , (jtb.calendar_end_date - jtb.calendar_start_date)*24*60 DURATION
1485: , jtb.timezone_id TIMEZONE_ID
1486: FROM jtf_tasks_b jtb
1487: , jtf_tasks_tl jtl
1488: , jtf_task_all_assignments jta
1489: WHERE jtb.task_id = jtl.task_id
1490: AND jtl.language = userenv('LANG')
1491: AND jta.task_id = jtb.task_id
1492: AND jta.assignee_role = 'ASSIGNEE' -- don't sent one to the owner??

Line 1735: , jtf_task_all_assignments jta

1731: , (jtb.calendar_end_date - jtb.calendar_start_date)*24*60 DURATION
1732: , jtb.timezone_id TIMEZONE_ID
1733: FROM jtf_tasks_b jtb
1734: , jtf_tasks_tl jtl
1735: , jtf_task_all_assignments jta
1736: WHERE jtb.task_id = jtl.task_id
1737: AND jtl.language = userenv('LANG')
1738: AND jta.task_id = jtb.task_id
1739: AND jta.assignee_role = 'ASSIGNEE' -- don't sent one to the owner??

Line 2364: UPDATE jtf_task_all_assignments

2360: ** Save the workflow itemtype and item key so we can update the reminder WF
2361: ** if the start date or remind me settings change
2362: ***************************************************************************/
2363:
2364: UPDATE jtf_task_all_assignments
2365: SET reminder_wf_item_type = l_itemtype
2366: , reminder_wf_item_key = l_ItemKey
2367: WHERE task_id = p_TaskID;
2368:

Line 2464: , jtf_task_all_assignments jta

2460: )
2461: ) SourceTimezoneID
2462: FROM jtf_tasks_b jtb
2463: , jtf_tasks_tl jtl
2464: , jtf_task_all_assignments jta
2465: WHERE jtb.task_id = jtl.task_id
2466: AND jtl.language = userenv('LANG')
2467: AND jta.task_id = jtb.task_id
2468: AND jta.show_on_calendar = 'Y'

Line 2697: , jtf_task_all_assignments jta

2693: , jtb.calendar_start_date START_DATE
2694: , jtb.calendar_end_date END_DATE
2695: FROM jtf_tasks_b jtb
2696: , jtf_tasks_tl jtl
2697: , jtf_task_all_assignments jta
2698: WHERE jtb.task_id = jtl.task_id
2699: AND jtl.language = userenv('LANG')
2700: AND jta.task_id = jtb.task_id
2701: AND jta.show_on_calendar = 'Y'

Line 2795: UPDATE jtf_task_all_assignments

2791: ** Save the workflow itemtype and item key so we can update the reminder WF
2792: ** if the start date or remind me settings change
2793: ***************************************************************************/
2794:
2795: UPDATE jtf_task_all_assignments
2796: SET reminder_wf_item_type = r_Task.ReminderWFItemType
2797: , reminder_wf_item_key = r_Task.ReminderWFItemKey
2798: WHERE task_id = p_TaskID;
2799: