DBA Data[Home] [Help]

APPS.JTF_CAL_WF_PVT dependencies on JTF_TASKS_TL

Line 1487: , jtf_tasks_tl jtl

1483: , jtb.task_priority_id PRIORITY_ID
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

Line 1734: , jtf_tasks_tl jtl

1730: , jtb.task_priority_id PRIORITY_ID
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

Line 2463: , jtf_tasks_tl jtl

2459: , 4)
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

Line 2696: , jtf_tasks_tl jtl

2692: , jtl.description TASK_DESCRIPTION
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