[Home] [Help]
View: PA_PROJ_ASSIGNMENTS_ACTUALS_V
View Text
SELECT ASGN.ASSIGNMENT_ID
, ASGN.ASSIGNMENT_NAME
, ASGN.START_DATE
, ASGN.PROJECT_ID
, RES.PERSON_ID
, SCH.START_DATE
, SCH.END_DATE
FROM PA_PROJECT_ASSIGNMENTS ASGN
, PA_SCHEDULES SCH
, PA_RESOURCE_TXN_ATTRIBUTES RES
WHERE ASGN.ASSIGNMENT_TYPE = 'STAFFED_ASSIGNMENT'
AND ASGN.RESOURCE_ID = RES.RESOURCE_ID
AND ASGN.ASSIGNMENT_ID = SCH.ASSIGNMENT_ID
AND SCH.ASSIGNMENT_ID > -1
AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(SCH.STATUS_CODE
, 'STAFFED_ASGMT_NEW_TRANS') = 'Y'
Columns
Name |
ASSIGNMENT_ID |
ASSIGNMENT_NAME |
ASSIGNMENT_START_DATE |
PROJECT_ID |
PERSON_ID |
START_DATE |
END_DATE |