DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on JTF_TASK_TYPES_B

Line 5215: , jtf_task_types_b tt

5211: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5212: ) res_info
5213: , jtf_task_assignments a
5214: , jtf_tasks_b t
5215: , jtf_task_types_b tt
5216: , jtf_task_statuses_b tsa
5217: , jtf_task_statuses_b tsb
5218: , cac_sr_object_capacity csr
5219: WHERE t.task_id = a.task_id

Line 5328: , jtf_task_types_b tt

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
5332: , jtf_task_statuses_b tsa

Line 5422: , jtf_task_types_b tt

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
5426: , jtf_task_statuses_b tsa

Line 5509: , jtf_task_types_b tt

5505: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5506: ) res_info
5507: , jtf_task_assignments a
5508: , jtf_tasks_b t
5509: , jtf_task_types_b tt
5510: , jtf_task_statuses_b tsb
5511: , jtf_task_statuses_b tsa
5512: , csf_access_hours_b ca
5513: , csp_requirement_headers cr

Line 5582: , jtf_task_types_b tt

5578: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5579: ) res_info
5580: , jtf_task_assignments a
5581: , jtf_tasks_b t
5582: , jtf_task_types_b tt
5583: , jtf_task_statuses_b tsb
5584: , jtf_task_statuses_b tsa
5585: , csf_access_hours_b ca
5586: , jtf_task_depends jd

Line 6779: , jtf_task_types_b tt

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
6783: , hz_party_sites ps

Line 6859: , jtf_task_types_b tt

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
6863: , hz_party_sites ps

Line 7097: , jtf_task_types_b tt

7093: AND rt.sched_request_id = p_req_id
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

Line 7197: , jtf_task_types_b tt

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
7201: , jtf_task_statuses_b tsa

Line 7290: , jtf_task_types_b tt

7286: AND rt.sched_request_id = p_req_id
7287: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
7288: , jtf_task_assignments a
7289: , jtf_tasks_b t
7290: , jtf_task_types_b tt
7291: , jtf_task_statuses_b tsb
7292: , jtf_task_statuses_b tsa
7293: , csf_access_hours_b ca
7294: , csp_requirement_headers cr

Line 7368: , jtf_task_types_b tt

7364: AND rt.sched_request_id = p_req_id
7365: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
7366: , jtf_task_assignments a
7367: , jtf_tasks_b t
7368: , jtf_task_types_b tt
7369: , jtf_task_statuses_b tsb
7370: , jtf_task_statuses_b tsa
7371: , csf_access_hours_b ca
7372: , jtf_task_depends jd