[Home] [Help]
View: PA_PROJECT_ASSIGNMENTS_RES_V
View Text
SELECT ASGN.RESOURCE_ID
, RES.RESOURCE_NAME
, ASGN.PROJECT_ID
, PROJ.NAME
, ASGN.ASSIGNMENT_NAME
, ASGN.START_DATE
, ASGN.END_DATE
, PS.PROJECT_STATUS_NAME
FROM PA_PROJECT_ASSIGNMENTS ASGN
, PA_C_ELIG_RESOURCE_V RES
, PA_PROJECTS_ALL PROJ
, PA_PROJECT_STATUSES PS
WHERE ASGN.RESOURCE_ID = RES.RESOURCE_ID
AND ASGN.PROJECT_ID = PROJ.PROJECT_ID
AND ASGN.STATUS_CODE = PS.PROJECT_STATUS_CODE
Columns
| Name |
| RESOURCE_ID |
| RESOURCE_NAME |
| PROJECT_ID |
| PROJECT_NAME |
| ASSIGNMENT_NAME |
| START_DATE |
| END_DATE |
| STATUS_NAME |
APPS.PA_PROJECT_ASSIGNMENTS_RES_V