View: PA_PROJ_ASGN_TIME_CHART_V

Product:	PA - Projects
Description:	The purpose of this view is to provide the time chart data for the project assignments / requirements timeline
Implementation/DBA Data:	APPS.PA_PROJ_ASGN_TIME_CHART_V

View Text

SELECT PASGN.PROJECT_ID
, PASGN.ASSIGNMENT_ID
, PASGN.RESOURCE_ID
, PASGN.START_DATE
, PASGN.END_DATE
, PASGN.SCALE_TYPE
, PASGN.COLOR_PATTERN
, PASGN.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
, PSP.PROJECT_SUBTEAM_ID
, PST.NAME
FROM PA_PROJ_ASGN_TIME_CHART PASGN
, PA_PROJ_ASGN_TIMELINE_ROWLBL_V TRWLBL
, PA_PROJECT_SUBTEAMS PST
, PA_PROJECT_SUBTEAM_PARTIES PSP
WHERE PASGN.ROW_LABEL_ID = TRWLBL.ROW_LABEL_ID
AND PASGN.ASSIGNMENT_ID = PSP.OBJECT_ID (+)
AND PSP.OBJECT_TYPE (+) = 'PA_PROJECT_ASSIGNMENTS'
AND PSP.PRIMARY_SUBTEAM_FLAG (+) = 'Y'
AND PSP.PROJECT_SUBTEAM_ID = PST.PROJECT_SUBTEAM_ID (+)

Columns