APPS.CSF_GANTT_DATA_PKG dependencies on CSF_PLAN_OPTIONS_V

Line 1553: FROM csf_plan_options_v

1549: , TO_NUMBER(SUBSTR(travel_time, 1, INSTR(travel_time, ':', 1) - 1)) * 60
1550: + TO_NUMBER(SUBSTR(travel_time, INSTR(travel_time, ':', 1) + 1, 5)) travel_time
1551: , NVL(task_type_id, 0)
1552: , resource_id || '-' || resource_type || '-' || plan_option_id
1553: FROM csf_plan_options_v
1554: WHERE sched_request_id = TO_NUMBER(SUBSTR(p_request_id, 1, INSTR(p_request_id, '-', 1) - 1))
1555: AND (
1556: task_id = -1
1557: OR task_id =

Line 3735: FROM csf_plan_options_v

3731: resource_id
3732: , object_capacity_id
3733: , resource_id res_id
3734: , resource_type res_typ
3735: FROM csf_plan_options_v
3736: WHERE sched_request_id = p_req_id
3737: AND task_type_id IN(20, 21)
3738: ) cs
3739: WHERE ca.object_id = cs.res_id

Line 3777: FROM csf_plan_options_v cpv

3773: , NVL(task_confirmation_status, 'N')
3774: , 'N' task_dep
3775: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
3776: , NVL(child_position, 'N') child_task
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

Line 3834: FROM csf_plan_options_v cpv

3830: , DECODE(nvl(t.task_id,0),jd.task_id,'Y','N') task_dep
3831: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
3832: , NVL(child_position, 'N') child_task
3833: , nvl(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
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

Line 3894: FROM csf_plan_options_v cpv

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

Line 3949: FROM csf_plan_options_v cpv

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

Line 3988: FROM csf_plan_options_v

3984: + TO_NUMBER(SUBSTR(travel_time, INSTR(travel_time, ':', 1) + 1, 5))
3985: , 0
3986: ) travel_time
3987: , NVL(task_type_id, 0)
3988: FROM csf_plan_options_v
3989: WHERE sched_request_id = p_req_id
3990: AND NVL(task_type_id, 0) NOT IN(20, 21)
3991: AND start_time >= p_start_date
3992: AND end_time <= p_end_date