APPS.CSF_GANTT_DATA_PKG dependencies on JTF_TASK_DEPENDS

Line 5431: , jtf_task_depends jd

5427: , hz_parties pi
5428: , hz_party_sites ps
5429: , hz_locations l
5430: , csf_access_hours_b ca
5431: , jtf_task_depends jd
5432: , jtf_task_depends jdd
5433: , csp_requirement_headers cr
5434: WHERE t.task_id = a.task_id
5435: AND t.source_object_type_code in( 'SR','TASK')

Line 5432: , jtf_task_depends jdd

5428: , hz_party_sites ps
5429: , hz_locations l
5430: , csf_access_hours_b ca
5431: , jtf_task_depends jd
5432: , jtf_task_depends jdd
5433: , csp_requirement_headers cr
5434: WHERE t.task_id = a.task_id
5435: AND t.source_object_type_code in( 'SR','TASK')
5436: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 5586: , jtf_task_depends jd

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
5587: , jtf_task_depends jdd
5588: , csp_requirement_headers cr
5589: WHERE t.task_id = a.task_id
5590: AND t.source_object_type_code in( 'SR','TASK')

Line 5587: , jtf_task_depends jdd

5583: , jtf_task_statuses_b tsb
5584: , jtf_task_statuses_b tsa
5585: , csf_access_hours_b ca
5586: , jtf_task_depends jd
5587: , jtf_task_depends jdd
5588: , csp_requirement_headers cr
5589: WHERE t.task_id = a.task_id
5590: AND t.source_object_type_code in( 'SR','TASK')
5591: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 6867: , jtf_task_depends jd

6863: , hz_party_sites ps
6864: , hz_locations l
6865: , csf_access_hours_b ca
6866: , csp_requirement_headers cr
6867: , jtf_task_depends jd
6868: , jtf_task_depends jdd
6869: , jtf_task_statuses_b tsa
6870: , jtf_task_statuses_b tsb
6871: WHERE cpv.sched_request_id = p_req_id

Line 6868: , jtf_task_depends jdd

6864: , hz_locations l
6865: , csf_access_hours_b ca
6866: , csp_requirement_headers cr
6867: , jtf_task_depends jd
6868: , jtf_task_depends jdd
6869: , jtf_task_statuses_b tsa
6870: , jtf_task_statuses_b tsb
6871: WHERE cpv.sched_request_id = p_req_id
6872: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)

Line 6994: , jtf_task_depends jd

6990: , jtf_task_assignments a
6991: , jtf_tasks_b t
6992: , csf_access_hours_b ca
6993: , csp_requirement_headers cr
6994: , jtf_task_depends jd
6995: , jtf_task_depends jdd
6996: , jtf_task_statuses_b tsa
6997: , jtf_task_statuses_b tsb
6998: WHERE cpv.sched_request_id = p_req_id

Line 6995: , jtf_task_depends jdd

6991: , jtf_tasks_b t
6992: , csf_access_hours_b ca
6993: , csp_requirement_headers cr
6994: , jtf_task_depends jd
6995: , jtf_task_depends jdd
6996: , jtf_task_statuses_b tsa
6997: , jtf_task_statuses_b tsb
6998: WHERE cpv.sched_request_id = p_req_id
6999: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)

Line 7206: , jtf_task_depends jd

7202: , hz_parties pi
7203: , hz_party_sites ps
7204: , hz_locations l
7205: , csf_access_hours_b ca
7206: , jtf_task_depends jd
7207: , jtf_task_depends jdd
7208: , csp_requirement_headers cr
7209: WHERE t.task_id = a.task_id
7210: AND t.source_object_type_code in( 'SR','TASK')

Line 7207: , jtf_task_depends jdd

7203: , hz_party_sites ps
7204: , hz_locations l
7205: , csf_access_hours_b ca
7206: , jtf_task_depends jd
7207: , jtf_task_depends jdd
7208: , csp_requirement_headers cr
7209: WHERE t.task_id = a.task_id
7210: AND t.source_object_type_code in( 'SR','TASK')
7211: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 7372: , jtf_task_depends jd

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
7373: , jtf_task_depends jdd
7374: , csp_requirement_headers cr
7375: WHERE t.task_id = a.task_id
7376: AND t.source_object_type_code in( 'SR','TASK')

Line 7373: , jtf_task_depends jdd

7369: , jtf_task_statuses_b tsb
7370: , jtf_task_statuses_b tsa
7371: , csf_access_hours_b ca
7372: , jtf_task_depends jd
7373: , jtf_task_depends jdd
7374: , csp_requirement_headers cr
7375: WHERE t.task_id = a.task_id
7376: AND t.source_object_type_code in( 'SR','TASK')
7377: AND NVL(t.deleted_flag, 'N') <> 'Y'