View: CSF_PLAN_OPTIONS_V

Product:	CSF - Field Service
Description:	This view is used to display plan options in the Scheduler UI.
Implementation/DBA Data:	APPS.CSF_PLAN_OPTIONS_V

View Text

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/1400)
, '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(+)

Columns