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_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 2367: UPDATE jtf_task_all_assignments

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

Line 2467: , jtf_task_all_assignments jta

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

Line 2700: , jtf_task_all_assignments jta

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

Line 2798: UPDATE jtf_task_all_assignments

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

Line 2895: jtf_task_all_assignments tsk_asg

2891: (p_task_id NUMBER)
2892: IS
2893: SELECT tsk_vl.task_id, owner_id,owner_type_code
2894: FROM jtf_tasks_vl tsk_vl,
2895: jtf_task_all_assignments tsk_asg
2896: WHERE tsk_vl.task_id = p_task_id
2897: and tsk_vl.task_id = tsk_asg.task_id
2898: AND assignee_role = 'OWNER' ;
2899:

Line 2919: , jtf_task_all_assignments jta

2915: , (jtb.calendar_end_date - jtb.calendar_start_date)*24*60 DURATION
2916: , jtb.timezone_id TIMEZONE_ID
2917: FROM jtf_tasks_b jtb
2918: , jtf_tasks_tl jtl
2919: , jtf_task_all_assignments jta
2920: WHERE jtb.task_id = jtl.task_id
2921: AND jtl.language = userenv('LANG')
2922: AND jta.task_id = jtb.task_id
2923: AND jta.show_on_calendar = 'Y'

Line 3354: jtf_task_all_assignments tsk_asg

3350: (p_task_id NUMBER)
3351: IS
3352: SELECT tsk_vl.task_id, owner_id,owner_type_code
3353: FROM jtf_tasks_vl tsk_vl,
3354: jtf_task_all_assignments tsk_asg
3355: WHERE tsk_vl.task_id = p_task_id
3356: and tsk_vl.task_id = tsk_asg.task_id
3357: AND assignee_role = 'OWNER' ;
3358:

Line 3378: , jtf_task_all_assignments jta

3374: , (jtb.calendar_end_date - jtb.calendar_start_date)*24*60 DURATION
3375: , jtb.timezone_id TIMEZONE_ID
3376: FROM jtf_tasks_b jtb
3377: , jtf_tasks_tl jtl
3378: , jtf_task_all_assignments jta
3379: WHERE jtb.task_id = jtl.task_id
3380: AND jtl.language = userenv('LANG')
3381: AND jta.task_id = jtb.task_id
3382: AND jta.show_on_calendar = 'Y'