Product: | PA - Projects |
---|---|
Description: | PA_RES_OVC_HOURS_V is a view that shows available resource by weeks |
Implementation/DBA Data: | APPS.PA_RES_OVC_HOURS_V |
SELECT RES.RESOURCE_ID
, RES.PERSON_ID
, RES.RESOURCE_NAME
, RES.RESOURCE_JOB_LEVEL
, RES.MANAGER_ID
, RES.MANAGER_NAME
, RES.RESOURCE_ORGANIZATION_ID
, ORG.NAME
, JOBS.NAME
, PFI.ITEM_DATE
, PA_RESOURCE_PVT.GET_RESOURCE_OVC_TO_DATE( RES.RESOURCE_ID
, PFI.ITEM_DATE)
, '0'
, RES.RESOURCE_COUNTRY_CODE
, RES.RESOURCE_COUNTRY
FROM PA_FORECAST_ITEMS PFI
, PER_JOBS JOBS
, HR_ALL_ORGANIZATION_UNITS ORG
, PA_RESOURCES_DENORM RES
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.ITEM_DATE >= RESOURCE_EFFECTIVE_START_DATE
AND PFI.ITEM_DATE <= RESOURCE_EFFECTIVE_END_DATE
AND JOBS.JOB_ID = RES.JOB_ID
AND ORG.ORGANIZATION_ID = RES.RESOURCE_ORGANIZATION_ID
AND SYSDATE <= RES.RESOURCE_EFFECTIVE_END_DATE