View: PA_RES_OVC_HOURS_STAFF_V

Product:	PA - Projects
Description:	PA_RES_OVC_HOURS_STAFF_V is a view that shows available resource by weeks
Implementation/DBA Data:	APPS.PA_RES_OVC_HOURS_STAFF_V

View Text

SELECT RES.RESOURCE_ID
, RES.PERSON_ID
, RES.RESOURCE_NAME
, RES.RESOURCE_JOB_LEVEL
, RES.MANAGER_ID
, RES.MANAGER_NAME
, PFI.EXPENDITURE_ORGANIZATION_ID
, ORG.NAME
, JOBS.NAME
, PFI.ITEM_DATE
, PA_RESOURCE_PVT.GET_RESOURCE_OVC_TO_DATE( RES.RESOURCE_ID
, PFI.ITEM_DATE)
, FG.GRANTEE_KEY
, RES.RESOURCE_COUNTRY_CODE
, RES.RESOURCE_COUNTRY
FROM PA_FORECAST_ITEMS PFI
, PER_JOBS JOBS
, HR_ALL_ORGANIZATION_UNITS ORG
, FND_GRANTS FG
, FND_OBJECTS FOB
, PA_RESOURCES_DENORM RES
, (SELECT PA_SECURITY_PVT.GET_MENU_ID('PA_PRM_RES_AUTH') MENU_ID
FROM DUAL) TEMP
WHERE PFI.RESOURCE_ID = RES.RESOURCE_ID
AND PFI.FORECAST_ITEM_TYPE = 'U'
AND PFI.DELETE_FLAG = 'N'
AND PFI.OVERCOMMITMENT_FLAG = 'Y'
AND PFI.AVAILABILITY_FLAG = 'N'
AND PFI.ERROR_FLAG IN ('Y'
, 'N')
AND PFI.ITEM_DATE >= RESOURCE_EFFECTIVE_START_DATE
AND PFI.ITEM_DATE <= RESOURCE_EFFECTIVE_END_DATE
AND JOBS.JOB_ID = RES.JOB_ID
AND FG.INSTANCE_PK1_VALUE = PFI.EXPENDITURE_ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = PFI.EXPENDITURE_ORGANIZATION_ID
AND SYSDATE <= RES.RESOURCE_EFFECTIVE_END_DATE
AND FG.INSTANCE_TYPE = 'INSTANCE'
AND FG.OBJECT_ID = FOB.OBJECT_ID
AND FOB.OBJ_NAME = 'ORGANIZATION'
AND FG.MENU_ID = TEMP.MENU_ID
AND FG.GRANTEE_TYPE = 'USER'
AND TRUNC(SYSDATE) BETWEEN TRUNC(FG.START_DATE)
AND TRUNC(NVL(FG.END_DATE
, SYSDATE+1))

Columns