View: PA_RES_AVAILABILITY_V

Product:	PA - Projects
Description:	PA_RES_AVAILABILITY_V is a view that shows weekly available records for the resource .
Implementation/DBA Data:	APPS.PA_RES_AVAILABILITY_V

View Text

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'

Columns