View: PA_RES_ASGN_TIMELINE_ROWLBL_V

Product:	PA - Projects
Description:	The purpose of this view is to provide row labels for the resource assignments / requirements timeline
Implementation/DBA Data:	APPS.PA_RES_ASGN_TIMELINE_ROWLBL_V

View Text

SELECT ROW_LABEL_ID
, ROW_LABEL_TYPE
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, ASSIGNMENT_ID
, ASSIGNMENT_NAME
, ASSIGNMENT_STATUS
, ASSIGNMENT_START_DATE
, ASSIGNMENT_END_DATE
, RESOURCE_ID
, RESOURCE_NAME
, ORGANIZATION_NAME
, RESOURCE_MGR_NAME
, SCH_UPD_PENDING_FLAG
FROM PA_TIMELINE_ROW_LABEL
WHERE ROW_LABEL_TYPE IN ('PROJECT'
, 'ADMIN'
, 'AVAILABLE')

Columns