Product: | PA - Projects |
---|---|
Description: | The purpose of this view is to provide the time chart data for the resource assignments / requirements timeline |
Implementation/DBA Data: | APPS.PA_RES_ASGN_TIME_CHART_V |
SELECT RASGN.RESOURCE_ID
, RASGN.PROJECT_ID
, RASGN.ASSIGNMENT_ID
, RASGN.START_DATE
, RASGN.END_DATE
, RASGN.SCALE_TYPE
, RASGN.COLOR_PATTERN
, RASGN.HELP_TEXT
, TRWLBL.ROW_LABEL_ID
, TRWLBL.ROW_LABEL_TYPE
, TRWLBL.PROJECT_NUMBER
, TRWLBL.PROJECT_NAME
, TRWLBL.ASSIGNMENT_NAME
, TRWLBL.ASSIGNMENT_STATUS
, TRWLBL.ASSIGNMENT_START_DATE
, TRWLBL.ASSIGNMENT_END_DATE
, TRWLBL.RESOURCE_NAME
, TRWLBL.ORGANIZATION_NAME
, TRWLBL.RESOURCE_MGR_NAME
, TRWLBL.SCH_UPD_PENDING_FLAG
FROM PA_RES_ASGN_TIME_CHART RASGN
, PA_RES_ASGN_TIMELINE_ROWLBL_V TRWLBL
WHERE RASGN.ROW_LABEL_ID = TRWLBL.ROW_LABEL_ID