View: PA_REP_RES_CAP_PA_V

Product:	PA - Projects
Description:	PA_REP_RES_CAP_PA_V is a view that shows resource capacity hours for a pa period
Implementation/DBA Data:	APPS.PA_REP_RES_CAP_PA_V

View Text

SELECT PRD.RESOURCE_ID
, PRD.RESOURCE_NAME
, PRD.MANAGER_ID
, PRD.MANAGER_NAME
, PRD.RESOURCE_ORGANIZATION_ID
, PAP.PERIOD_YEAR
, PAP.QUARTER_NUM
, PAP.PERIOD_NAME
, PAP.PA_START_DATE
, PA_RESOURCE_UTILS.GET_RES_CAPACITY(PRD.RESOURCE_ID
, PAP.PA_START_DATE
, PAP.PA_END_DATE)
, PJ.NAME
, PRD.RESOURCE_JOB_LEVEL
, PRD.RESOURCE_PERSON_TYPE
, PAI.ORG_ID
FROM PA_RESOURCES_DENORM PRD
, PA_PERIODS_V PAP
, PA_IMPLEMENTATIONS PAI
, PER_JOBS PJ
WHERE PAP.PA_START_DATE BETWEEN PRD.RESOURCE_EFFECTIVE_START_DATE
AND PRD.RESOURCE_EFFECTIVE_END_DATE
AND PRD.JOB_ID = PJ.JOB_ID
AND PRD.SCHEDULABLE_FLAG = 'Y'
AND PAI.SET_OF_BOOKS_ID = PAP.SET_OF_BOOKS_ID

Columns