APPS.CSF_GANTT_DATA_PKG dependencies on JTF_TASKS_TL

Line 320: , jtf_tasks_tl tl

316: , tb.actual_effort ||' '|| tb.actual_effort_uom act_effort
317: FROM jtf_task_assignments a
318: , jtf_tasks_b tb
319: , jtf_task_types_tl tt
320: , jtf_tasks_tl tl
321: , jtf_task_statuses_b sb
322: , jtf_task_statuses_tl sl
323: , hz_party_sites ps
324: , hz_locations hl

Line 1460: , jtf_tasks_tl tl

1456: , tb.actual_effort ||' '|| tb.actual_effort_uom act_effort
1457: FROM jtf_task_assignments a
1458: , jtf_tasks_b tb
1459: , jtf_task_types_tl tt
1460: , jtf_tasks_tl tl
1461: , jtf_task_statuses_b sb
1462: , jtf_task_statuses_tl sl
1463: , hz_party_sites ps
1464: , hz_locations hl

Line 2430: , jtf_tasks_tl tl

2426: , tb.actual_effort ||' '|| tb.actual_effort_uom act_effort
2427: FROM jtf_task_assignments a
2428: , jtf_tasks_b tb
2429: , jtf_task_types_tl tt
2430: , jtf_tasks_tl tl
2431: , jtf_task_statuses_b sb
2432: , jtf_task_statuses_tl sl
2433: , hz_party_sites ps
2434: , hz_locations hl

Line 3157: , jtf_tasks_tl tl

3153: , tb.actual_effort ||' '|| tb.actual_effort_uom act_effort
3154: FROM jtf_task_assignments a
3155: , jtf_tasks_b tb
3156: , jtf_task_types_tl tt
3157: , jtf_tasks_tl tl
3158: , jtf_task_statuses_b sb
3159: , jtf_task_statuses_tl sl
3160: , hz_party_sites ps
3161: , hz_locations hl

Line 5327: , jtf_tasks_tl tl

5323: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5324: ) res_info
5325: , jtf_task_assignments a
5326: , jtf_tasks_B t
5327: , jtf_tasks_tl tl
5328: , jtf_task_types_b tt
5329: , jtf_task_priorities_B jtp
5330: , jtf_task_priorities_tl jtpl
5331: , jtf_task_statuses_b tsb

Line 5421: , jtf_tasks_tl tl

5417: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5418: ) res_info
5419: , jtf_task_assignments a
5420: , jtf_tasks_b t
5421: , jtf_tasks_tl tl
5422: , jtf_task_types_b tt
5423: , jtf_task_priorities_B jtp
5424: , jtf_task_priorities_tl jtpl
5425: , jtf_task_statuses_b tsb

Line 6778: , jtf_tasks_tl tl

6774: , NVL(child_position, 'N') child_task
6775: FROM csf_plan_options_v cpv
6776: , jtf_task_assignments a
6777: , jtf_tasks_b t
6778: , jtf_tasks_tl tl
6779: , jtf_task_types_b tt
6780: , jtf_task_priorities_B jtp
6781: , jtf_task_priorities_tl jtpl
6782: , hz_parties pi

Line 6858: , jtf_tasks_tl tl

6854: , nvl(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
6855: FROM csf_plan_options_v cpv
6856: , jtf_task_assignments a
6857: , jtf_tasks_b t
6858: , jtf_tasks_tl tl
6859: , jtf_task_types_b tt
6860: , jtf_task_priorities_B jtp
6861: , jtf_task_priorities_tl jtpl
6862: , hz_parties pi

Line 7098: , jtf_tasks_tl tl

7094: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
7095: , jtf_task_assignments a
7096: , jtf_tasks_b t
7097: , jtf_task_types_b tt
7098: , jtf_tasks_tl tl
7099: , jtf_task_priorities_B jtp
7100: , jtf_task_priorities_tl jtpl
7101: , jtf_task_statuses_b tsb
7102: , jtf_task_statuses_b tsa

Line 7196: , jtf_tasks_tl tl

7192: AND rt.sched_request_id = p_req_id
7193: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
7194: , jtf_task_assignments a
7195: , jtf_tasks_b t
7196: , jtf_tasks_tl tl
7197: , jtf_task_types_b tt
7198: , jtf_task_priorities_B jtp
7199: , jtf_task_priorities_tl jtpl
7200: , jtf_task_statuses_b tsb