[Home] [Help]
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
Name |
RESOURCE_ID |
START_DATE |
END_DATE |