eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_RES_AVL_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_avl_to_date( res.resource_id, pfi.item_date), '0', res.resource_country_code, res.resource_country, pa_candidate_utils.get_candidate_nominations( res.resource_id), pa_candidate_utils.get_candidate_qualifieds( res.resource_id), temp2.avl_profile, pfi.availability_quantity, capacity_quantity from pa_forecast_items pfi, per_jobs jobs, hr_all_organization_units org, pa_resources_denorm res, (select fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE') avl_profile from dual) temp2 WHERE pfi.resource_id = res.resource_id and pfi.forecast_item_type = 'U' and pfi.delete_flag = 'N' and pfi.availability_flag = 'Y' and pfi.overcommitment_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_AVL_TO_DATE( RES.RESOURCE_ID
, PFI.ITEM_DATE)
, '0'
, RES.RESOURCE_COUNTRY_CODE
, RES.RESOURCE_COUNTRY
, PA_CANDIDATE_UTILS.GET_CANDIDATE_NOMINATIONS( RES.RESOURCE_ID)
, PA_CANDIDATE_UTILS.GET_CANDIDATE_QUALIFIEDS( RES.RESOURCE_ID)
, TEMP2.AVL_PROFILE
, PFI.AVAILABILITY_QUANTITY
, CAPACITY_QUANTITY
FROM PA_FORECAST_ITEMS PFI
, PER_JOBS JOBS
, HR_ALL_ORGANIZATION_UNITS ORG
, PA_RESOURCES_DENORM RES
, (SELECT FND_PROFILE.VALUE('PA_RES_CAPACITY_PERCENTAGE') AVL_PROFILE
FROM DUAL) TEMP2
WHERE PFI.RESOURCE_ID = RES.RESOURCE_ID
AND PFI.FORECAST_ITEM_TYPE = 'U'
AND PFI.DELETE_FLAG = 'N'
AND PFI.AVAILABILITY_FLAG = 'Y'
AND PFI.OVERCOMMITMENT_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