VIEW: APPS.CSR_WTP_DISPLAY_V

Source

View Text - Preformatted

SELECT rw.window_name window_type , TRUNC( po.scheduled_start_date ) + (to_date(rw.start_time_hours || ':' || rw.start_time_minutes, 'HH24:MI') - trunc(to_date(rw.start_time_hours || ':' || rw.start_time_minutes, 'HH24:MI'))) start_time , TRUNC( po.scheduled_start_date ) + (to_date(rw.end_time_hours || ':' || rw.end_time_minutes, 'HH24:MI') - trunc(to_date(rw.end_time_hours || ':' || rw.end_time_minutes, 'HH24:MI'))) 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 , rw.window_id win_promis_id FROM csf_r_request_tasks rt , csf_r_resource_results rr , csr_rule_windows_v rw , csf_r_plan_options po WHERE rt.request_task_id = rr.request_task_id AND rr.resource_result_id = po.resource_result_id AND rw.window_id = po.win_to_promis_id

View Text - HTML Formatted

SELECT RW.WINDOW_NAME WINDOW_TYPE
, TRUNC( PO.SCHEDULED_START_DATE ) + (TO_DATE(RW.START_TIME_HOURS || ':' || RW.START_TIME_MINUTES
, 'HH24:MI') - TRUNC(TO_DATE(RW.START_TIME_HOURS || ':' || RW.START_TIME_MINUTES
, 'HH24:MI'))) START_TIME
, TRUNC( PO.SCHEDULED_START_DATE ) + (TO_DATE(RW.END_TIME_HOURS || ':' || RW.END_TIME_MINUTES
, 'HH24:MI') - TRUNC(TO_DATE(RW.END_TIME_HOURS || ':' || RW.END_TIME_MINUTES
, 'HH24:MI'))) 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
, RW.WINDOW_ID WIN_PROMIS_ID
FROM CSF_R_REQUEST_TASKS RT
, CSF_R_RESOURCE_RESULTS RR
, CSR_RULE_WINDOWS_V RW
, CSF_R_PLAN_OPTIONS PO
WHERE RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID
AND RR.RESOURCE_RESULT_ID = PO.RESOURCE_RESULT_ID
AND RW.WINDOW_ID = PO.WIN_TO_PROMIS_ID