View: PA_REP_PROJ_RES_COMP_V

Product:	PA - Projects
Description:	PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by projects
Implementation/DBA Data:	APPS.PA_REP_PROJ_RES_COMP_V

View Text

SELECT ORG.ORGANIZATION_ID
, ORG.NAME
, PROJ.PROJECT_ID
, PROJ.NAME
, PROJ.SEGMENT1
, RES.RESOURCE_ID
, RES.RESOURCE_NAME
, PA_HR_COMPETENCE_UTILS.GET_RES_COMPETENCES(RES.PERSON_ID)
, PA_HR_COMPETENCE_UTILS.GET_RES_COMPETENCES_COUNT(RES.PERSON_ID)
, PA_HR_COMPETENCE_UTILS.GET_RES_COMP_LAST_UPDATED(RES.PERSON_ID)
, RES.MANAGER_ID
, RES.MANAGER_NAME
, PJ.JOB_ID
, PJ.NAME
, INFO.JEI_INFORMATION4
, INFO.JEI_INFORMATION5
, DECODE(RES.SCHEDULABLE_FLAG
, NULL
, 'N'
, RES.SCHEDULABLE_FLAG)
, RES.BILLABLE_FLAG
, RES.RESOURCE_PERSON_TYPE
FROM PA_RESOURCES_DENORM RES
, HR_ORGANIZATION_UNITS ORG
, PER_JOBS PJ
, PER_JOB_EXTRA_INFO INFO
, PA_PROJECTS_ALL PROJ
, (SELECT DISTINCT ASMT.RESOURCE_ID
, ASMT.PROJECT_ID
FROM PA_PROJECT_ASSIGNMENTS ASMT) PROJ_RES_INFO
WHERE RES.RESOURCE_EFFECTIVE_START_DATE = (SELECT MIN (RES1.RESOURCE_EFFECTIVE_START_DATE)
FROM PA_RESOURCES_DENORM RES1
WHERE RES1.RESOURCE_ID = RES.RESOURCE_ID
AND RES1.RESOURCE_EFFECTIVE_END_DATE >= SYSDATE)
AND RES.UTILIZATION_FLAG = 'Y'
AND RES.RESOURCE_ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND RES.RESOURCE_ID = PROJ_RES_INFO.RESOURCE_ID
AND PROJ_RES_INFO.PROJECT_ID = PROJ.PROJECT_ID
AND RES.JOB_ID = PJ.JOB_ID
AND PJ.JOB_ID = INFO.JOB_ID (+)
AND 'JOB CATEGORY' = INFO.JEI_INFORMATION_CATEGORY (+)

Columns