VIEW: APPS.CSF_PLAN_OPTIONS_V

Source

View Text - Preformatted

SELECT rt.sched_request_id , po.plan_option_id , ROUND(po.cost) cost , rr.resource_id , rr.resource_type, (select name from jtf_objects_vl WHERE object_code =rr.resource_type) resource_type_name , 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 , lpad(floor(round(pt.travel_time)/60),decode(length(floor(round(pt.travel_time)/60)),1,2,length(floor(round(pt.travel_time)/60))),0)||':'||lpad(mod(round(pt.travel_time),60),2,0) 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 , po.shift_type, (select meaning from fnd_lookups where lookup_type = 'CSF_RESOURCE_IDENTIFIER' and lookup_code =rr.resource_source) resource_source, replace(so.warehouse,',',';') warehouse, replace(so.shipment_method,',',';') shipment_method, replace(so.distance,'$',';') distance 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
, ROUND(PO.COST) COST
, RR.RESOURCE_ID
, RR.RESOURCE_TYPE
, (SELECT NAME
FROM JTF_OBJECTS_VL
WHERE OBJECT_CODE =RR.RESOURCE_TYPE) RESOURCE_TYPE_NAME
, 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
, LPAD(FLOOR(ROUND(PT.TRAVEL_TIME)/60)
, DECODE(LENGTH(FLOOR(ROUND(PT.TRAVEL_TIME)/60))
, 1
, 2
, LENGTH(FLOOR(ROUND(PT.TRAVEL_TIME)/60)))
, 0)||':'||LPAD(MOD(ROUND(PT.TRAVEL_TIME)
, 60)
, 2
, 0) 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
, PO.SHIFT_TYPE
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'CSF_RESOURCE_IDENTIFIER'
AND LOOKUP_CODE =RR.RESOURCE_SOURCE) RESOURCE_SOURCE
, REPLACE(SO.WAREHOUSE
, '
, '
, ';') WAREHOUSE
, REPLACE(SO.SHIPMENT_METHOD
, '
, '
, ';') SHIPMENT_METHOD
, REPLACE(SO.DISTANCE
, '$'
, ';') DISTANCE
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(+)