VIEW: APPS.CSF_PLAN_OPTIONS_V

Source

View Text - Preformatted

SELECT rt.sched_request_id ,po.plan_option_id ,po.cost ,rr.resource_id ,rr.resource_type ,csf_resource_pub.get_resource_name(rr.resource_id, rr.resource_type) resource_name ,pt.scheduled_start_date start_time ,pt.scheduled_end_date end_time ,to_char(trunc(sysdate) + (pt.travel_time/1440), 'hh24:mi') travel_time ,decode(so.cost, -1, to_date(null), so.availability_date) spares_date ,decode(so.cost, -1, to_number(null), so.cost) spares_cost ,t.task_type_id ,pt.object_capacity_id ,pt.task_id ,pt.task_assignment_id from csf_r_request_tasks rt ,csf_r_resource_results rr ,csf_r_spares_options so ,csf_r_plan_options po ,csf_r_plan_option_tasks pt ,jtf_tasks_b t WHERE rt.request_task_id = rr.request_task_id and rr.resource_result_id = po.resource_result_id and po.spares_option_id = so.spares_option_id and po.plan_option_id = pt.plan_option_id and pt.task_id = t.task_id(+)

View Text - HTML Formatted

SELECT RT.SCHED_REQUEST_ID
, PO.PLAN_OPTION_ID
, PO.COST
, RR.RESOURCE_ID
, RR.RESOURCE_TYPE
, CSF_RESOURCE_PUB.GET_RESOURCE_NAME(RR.RESOURCE_ID
, RR.RESOURCE_TYPE) RESOURCE_NAME
, PT.SCHEDULED_START_DATE START_TIME
, PT.SCHEDULED_END_DATE END_TIME
, TO_CHAR(TRUNC(SYSDATE) + (PT.TRAVEL_TIME/1440)
, 'HH24:MI') TRAVEL_TIME
, DECODE(SO.COST
, -1
, TO_DATE(NULL)
, SO.AVAILABILITY_DATE) SPARES_DATE
, DECODE(SO.COST
, -1
, TO_NUMBER(NULL)
, SO.COST) SPARES_COST
, T.TASK_TYPE_ID
, PT.OBJECT_CAPACITY_ID
, PT.TASK_ID
, PT.TASK_ASSIGNMENT_ID
FROM CSF_R_REQUEST_TASKS RT
, CSF_R_RESOURCE_RESULTS RR
, CSF_R_SPARES_OPTIONS SO
, CSF_R_PLAN_OPTIONS PO
, CSF_R_PLAN_OPTION_TASKS PT
, JTF_TASKS_B T
WHERE RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID
AND RR.RESOURCE_RESULT_ID = PO.RESOURCE_RESULT_ID
AND PO.SPARES_OPTION_ID = SO.SPARES_OPTION_ID
AND PO.PLAN_OPTION_ID = PT.PLAN_OPTION_ID
AND PT.TASK_ID = T.TASK_ID(+)