[Home] [Help]
2558: , jtf_task_types_b tt
2559: , jtf_task_statuses_b tsb
2560: , jtf_task_statuses_b tsa
2561: , hz_parties pi
2562: , csf_access_hours_b ca
2563: , csp_requirement_headers cr
2564: WHERE t.task_id = a.task_id
2565: AND t.source_object_type_code in( 'SR','TASK')
2566: AND NVL(t.deleted_flag, 'N') <> 'Y'
2635: , jtf_task_types_b tt
2636: , jtf_task_statuses_b tsb
2637: , jtf_task_statuses_b tsa
2638: , hz_parties pi
2639: , csf_access_hours_b ca
2640: , jtf_task_depends jd
2641: , jtf_task_depends jdd
2642: , csp_requirement_headers cr
2643: WHERE t.task_id = a.task_id
2712: , jtf_tasks_b t
2713: , jtf_task_types_b tt
2714: , jtf_task_statuses_b tsb
2715: , jtf_task_statuses_b tsa
2716: , csf_access_hours_b ca
2717: , csp_requirement_headers cr
2718: WHERE t.task_id = a.task_id
2719: AND t.source_object_type_code in( 'SR','TASK')
2720: AND NVL(t.deleted_flag, 'N') <> 'Y'
2787: , jtf_tasks_b t
2788: , jtf_task_types_b tt
2789: , jtf_task_statuses_b tsb
2790: , jtf_task_statuses_b tsa
2791: , csf_access_hours_b ca
2792: , jtf_task_depends jd
2793: , jtf_task_depends jdd
2794: , csp_requirement_headers cr
2795: WHERE t.task_id = a.task_id
3777: FROM csf_plan_options_v cpv
3778: , jtf_task_assignments a
3779: , jtf_tasks_b t
3780: , hz_parties pi
3781: , csf_access_hours_b ca
3782: , csp_requirement_headers cr
3783: , jtf_task_statuses_b tsa
3784: , jtf_task_statuses_b tsb
3785: WHERE cpv.sched_request_id = p_req_id
3834: FROM csf_plan_options_v cpv
3835: , jtf_task_assignments a
3836: , jtf_tasks_b t
3837: , hz_parties pi
3838: , csf_access_hours_b ca
3839: , csp_requirement_headers cr
3840: , jtf_task_depends jd
3841: , jtf_task_depends jdd
3842: , jtf_task_statuses_b tsa
3893: , NVL(child_position, 'N') child_task
3894: FROM csf_plan_options_v cpv
3895: , jtf_task_assignments a
3896: , jtf_tasks_b t
3897: , csf_access_hours_b ca
3898: , csp_requirement_headers cr
3899: , jtf_task_statuses_b tsa
3900: , jtf_task_statuses_b tsb
3901: WHERE cpv.sched_request_id = p_req_id
3948: , NVL(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
3949: FROM csf_plan_options_v cpv
3950: , jtf_task_assignments a
3951: , jtf_tasks_b t
3952: , csf_access_hours_b ca
3953: , csp_requirement_headers cr
3954: , jtf_task_depends jd
3955: , jtf_task_depends jdd
3956: , jtf_task_statuses_b tsa
4050: , jtf_task_types_b tt
4051: , jtf_task_statuses_b tsb
4052: , jtf_task_statuses_b tsa
4053: , hz_parties pi
4054: , csf_access_hours_b ca
4055: , csp_requirement_headers cr
4056: WHERE t.task_id = a.task_id
4057: AND t.source_object_type_code in( 'SR','TASK')
4058: AND NVL(t.deleted_flag, 'N') <> 'Y'
4132: , jtf_task_types_b tt
4133: , jtf_task_statuses_b tsb
4134: , jtf_task_statuses_b tsa
4135: , hz_parties pi
4136: , csf_access_hours_b ca
4137: , jtf_task_depends jd
4138: , jtf_task_depends jdd
4139: , csp_requirement_headers cr
4140: WHERE t.task_id = a.task_id
4214: , jtf_tasks_b t
4215: , jtf_task_types_b tt
4216: , jtf_task_statuses_b tsb
4217: , jtf_task_statuses_b tsa
4218: , csf_access_hours_b ca
4219: , csp_requirement_headers cr
4220: WHERE t.task_id = a.task_id
4221: AND t.source_object_type_code in( 'SR','TASK')
4222: AND NVL(t.deleted_flag, 'N') <> 'Y'
4294: , jtf_tasks_b t
4295: , jtf_task_types_b tt
4296: , jtf_task_statuses_b tsb
4297: , jtf_task_statuses_b tsa
4298: , csf_access_hours_b ca
4299: , jtf_task_depends jd
4300: , jtf_task_depends jdd
4301: , csp_requirement_headers cr
4302: WHERE t.task_id = a.task_id