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