VIEW: APPS.PA_RES_OVC_HOURS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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