View: PA_CREATE_TEAM_ROLES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_CREATE_TEAM_ROLES_V

View Text

SELECT RLM.ALIAS PLANNING_RESOURCE_NAME
, RA.RESOURCE_LIST_MEMBER_ID
, FIRSTROW.PERSON_ID
, RLM.RESOURCE_ID
, PA_RESOURCE_UTILS.GET_PERSON_NAME_NO_DATE(FIRSTROW.PERSON_ID)
, RA.PROJECT_ID
, RA.BUDGET_VERSION_ID
, DECODE (RA.ROLE_COUNT
, 1
, FIRSTROW.NAMED_ROLE
, NULL) NAMED_ROLE
, DECODE (RA.ROLE_COUNT
, 1
, FIRSTROW.PROJECT_ROLE_ID
, NULL) PROJECT_ROLE_ID
, DECODE (RA.ROLE_COUNT
, 1
, RO.MEANING
, NULL) PROJECT_ROLE
, RA.MIN_DATE TASK_ASSIGN_START_DATE
, RA.MAX_DATE TASK_ASSIGN_END_DATE
, FIRSTROW.RESOURCE_ASSIGNMENT_ID
, FIRSTROW.RES_TYPE_CODE
FROM PA_RESOURCE_ASSIGNMENTS FIRSTROW
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_PROJECT_ROLE_TYPES_TL RO
, (SELECT PROJECT_ID
, BUDGET_VERSION_ID
, RESOURCE_LIST_MEMBER_ID
, COUNT(1) ROLE_COUNT
, MAX(MAX_ID) MAX_ID
, MIN(MIN_DATE) MIN_DATE
, MAX(MAX_DATE) MAX_DATE
FROM (SELECT PROJECT_ID
, BUDGET_VERSION_ID
, RESOURCE_LIST_MEMBER_ID
, PROJECT_ROLE_ID
, MAX(RESOURCE_ASSIGNMENT_ID) MAX_ID
, MIN(SCHEDULE_START_DATE) MIN_DATE
, MAX(SCHEDULE_END_DATE) MAX_DATE
FROM PA_RESOURCE_ASSIGNMENTS
WHERE TA_DISPLAY_FLAG = 'Y'
AND NVL(PROJECT_ASSIGNMENT_ID
, -1) = -1
AND RESOURCE_CLASS_CODE = 'PEOPLE' GROUP BY PROJECT_ID
, BUDGET_VERSION_ID
, RESOURCE_LIST_MEMBER_ID
, PROJECT_ROLE_ID) RES_ROLES GROUP BY PROJECT_ID
, BUDGET_VERSION_ID
, RESOURCE_LIST_MEMBER_ID) RA
WHERE RA.RESOURCE_LIST_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID
AND FIRSTROW.RESOURCE_ASSIGNMENT_ID = RA.MAX_ID
AND FIRSTROW.PROJECT_ROLE_ID = RO.PROJECT_ROLE_ID (+)
AND RO.LANGUAGE (+) = USERENV('LANG')

Columns