APPS.CSF_GANTT_DATA_PKG dependencies on CSF_PLAN_OPTIONS_V

Line 4062: FROM csf_plan_options_v

4058: , TO_NUMBER(SUBSTR(travel_time, 1, INSTR(travel_time, ':', 1) - 1)) * 60
4059: + TO_NUMBER(SUBSTR(travel_time, INSTR(travel_time, ':', 1) + 1, 5)) travel_time
4060: , NVL(task_type_id, 0)
4061: , resource_id || '-' || resource_type || '-' || plan_option_id
4062: FROM csf_plan_options_v
4063: WHERE sched_request_id = TO_NUMBER(SUBSTR(p_request_id, 1, INSTR(p_request_id, '-', 1) - 1))
4064: AND (
4065: task_id = -1
4066: OR task_id =

Line 6725: FROM csf_plan_options_v

6721: resource_id
6722: , object_capacity_id
6723: , resource_id res_id
6724: , resource_type res_typ
6725: FROM csf_plan_options_v
6726: WHERE sched_request_id = p_req_id
6727: AND task_type_id IN(20, 21)
6728: ) cs
6729: WHERE ca.object_id = cs.res_id

Line 6775: FROM csf_plan_options_v cpv

6771: , NVL(task_confirmation_status, 'N')
6772: , 'N' task_dep
6773: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
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

Line 6855: FROM csf_plan_options_v cpv

6851: , DECODE(nvl(t.task_id,0),jd.task_id,'Y','N') task_dep
6852: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
6853: , NVL(child_position, 'N') child_task
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

Line 6934: FROM csf_plan_options_v cpv

6930: , NVL(task_confirmation_status, 'N')
6931: , 'N' task_dep
6932: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
6933: , NVL(child_position, 'N') child_task
6934: FROM csf_plan_options_v cpv
6935: , jtf_task_assignments a
6936: , jtf_tasks_b t
6937: , csf_access_hours_b ca
6938: , csp_requirement_headers cr

Line 6989: FROM csf_plan_options_v cpv

6985: , DECODE(nvl(t.task_id,0),jd.task_id,'Y','N') task_dep
6986: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
6987: , NVL(child_position, 'N') child_task
6988: , NVL(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
6989: FROM csf_plan_options_v cpv
6990: , jtf_task_assignments a
6991: , jtf_tasks_b t
6992: , csf_access_hours_b ca
6993: , csp_requirement_headers cr

Line 7028: FROM csf_plan_options_v

7024: + TO_NUMBER(SUBSTR(travel_time, INSTR(travel_time, ':', 1) + 1, 5))
7025: , 0
7026: ) travel_time
7027: , NVL(task_type_id, 0)
7028: FROM csf_plan_options_v
7029: WHERE sched_request_id = p_req_id
7030: AND NVL(task_type_id, 0) NOT IN(20, 21)
7031: AND start_time >= p_start_date
7032: AND end_time <= p_end_date