View: CSR_WTP_DISPLAY_V

Product:	CSR - Scheduler
Description:
Implementation/DBA Data:	APPS.CSR_WTP_DISPLAY_V

View Text

SELECT WP.NAME WINDOW_TYPE
, TRUNC(PO.SCHEDULED_START_DATE) + (WP.START_TIME - TRUNC(WP.START_TIME)) START_TIME
, TRUNC(PO.SCHEDULED_START_DATE) + (WP.END_TIME - TRUNC(WP.END_TIME)) END_TIME
, PO.SCHEDULED_START_DATE WTP_DATE
, PO.COST
, PO.PLAN_OPTION_ID
, CSF_RESOURCE_PUB.GET_RESOURCE_NAME(RR.RESOURCE_ID
, RR.RESOURCE_TYPE) RESOURCE_NAME
, RR.RESOURCE_ID
, RR.RESOURCE_TYPE
, RT.SCHED_REQUEST_ID
, WP.WIN_PROMIS_ID
FROM CSF_R_REQUEST_TASKS RT
, CSF_R_RESOURCE_RESULTS RR
, CSR_WIN_PROMIS_VL WP
, CSF_R_PLAN_OPTIONS PO
WHERE RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID
AND RR.RESOURCE_RESULT_ID = PO.RESOURCE_RESULT_ID
AND WP.WIN_PROMIS_ID = PO.WIN_TO_PROMIS_ID

Columns