[Home] [Help]
305: WHERE uom_code = p_code;
306:
307: CURSOR c_parts(b_task_id NUMBER) IS
308: SELECT 'Y' required
309: FROM csp_requirement_headers
310: WHERE task_id = b_task_id;
311:
312: CURSOR c_ib(b_customer_product_id NUMBER) IS
313: SELECT serial_number
890: WHERE uom_code = p_code;
891:
892: CURSOR c_parts(b_task_id NUMBER) IS
893: SELECT 'Y' required
894: FROM csp_requirement_headers
895: WHERE task_id = b_task_id;
896:
897: CURSOR c_ib(b_customer_product_id NUMBER) IS
898: SELECT serial_number
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'
2567: AND t.task_type_id NOT IN (20,21)
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
2644: AND t.source_object_type_code in( 'SR','TASK')
2645: AND NVL(t.deleted_flag, 'N') <> 'Y'
2646: AND t.task_type_id NOT IN (20,21)
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'
2721: AND t.task_type_id NOT IN (20,21)
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
2796: AND t.source_object_type_code in( 'SR','TASK')
2797: AND NVL(t.deleted_flag, 'N') <> 'Y'
2798: AND t.task_type_id NOT IN (20,21)
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
3786: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
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
3843: , jtf_task_statuses_b tsb
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
3902: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
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
3957: , jtf_task_statuses_b tsb
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'
4059: AND t.task_type_id NOT IN (20,21)
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
4141: AND t.source_object_type_code in( 'SR','TASK')
4142: AND NVL(t.deleted_flag, 'N') <> 'Y'
4143: AND t.task_type_id NOT IN (20,21)
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'
4223: AND t.task_type_id NOT IN (20,21)
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
4303: AND t.source_object_type_code in( 'SR','TASK')
4304: AND NVL(t.deleted_flag, 'N') <> 'Y'
4305: AND t.task_type_id NOT IN (20,21)