VIEW: APPS.PA_RES_AVAILABILITY_V

Source

View Text - Preformatted

SELECT rt.resource_id, rt.start_date, rt.end_date FROM pa_res_asgn_time_chart rt, pa_timeline_row_label rl WHERE rt.row_label_id =rl.row_label_id AND rl.row_label_type ='AVAILABLE' AND rt.scale_type ='MONTH'

View Text - HTML Formatted

SELECT RT.RESOURCE_ID
, RT.START_DATE
, RT.END_DATE
FROM PA_RES_ASGN_TIME_CHART RT
, PA_TIMELINE_ROW_LABEL RL
WHERE RT.ROW_LABEL_ID =RL.ROW_LABEL_ID
AND RL.ROW_LABEL_TYPE ='AVAILABLE'
AND RT.SCALE_TYPE ='MONTH'