Product: | PA - Projects |
---|---|
Description: | The purpose of this view is to provide the time chart data for the resource schedule timeline |
Implementation/DBA Data: | APPS.PA_RES_SCH_TIME_CHART_V |
SELECT RSCH.START_DATE
, RSCH.END_DATE
, RSCH.SCALE_TYPE
, RSCH.COLOR_PATTERN
, RSCH.HELP_TEXT
, RSCH.RESOURCE_ID
, TRWLBL.ROW_LABEL_ID
, TRWLBL.ROW_LABEL_TYPE
, TRWLBL.RESOURCE_NAME
, TRWLBL.ORGANIZATION_ID
, TRWLBL.ORGANIZATION_NAME
, TRWLBL.MANAGER_ID
, TRWLBL.MANAGER_NAME
, TRWLBL.RESOURCE_ANALYST_ID
, TRWLBL.SCH_UPD_PENDING_FLAG
, TRWLBL.JOB_LEVEL
FROM PA_RES_SCH_TIME_CHART RSCH
, PA_RES_SCH_TIMELINE_ROWLBL_V TRWLBL
WHERE RSCH.ROW_LABEL_ID = TRWLBL.ROW_LABEL_ID