VIEW: APPS.CSR_WTP_DISPLAY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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