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_REP_RES_OVC_WK_V

Source

View Text - Preformatted


SELECT prd.resource_id res_id, prd.resource_name, prd.manager_id, prd.manager_name, prd.resource_organization_id, pfi.GLOBAL_EXP_PERIOD_END_DATE, to_number(to_char(pfi.GLOBAL_EXP_PERIOD_END_DATE,'MM')), to_number(to_char(pfi.GLOBAL_EXP_PERIOD_END_DATE,'YYYY')), prd.resource_effective_start_date + temp.seq_number, pfi.capacity_quantity, pfi.overcommitment_quantity, pfi.capacity_quantity + pfi.overcommitment_quantity, pj.name, prd.resource_job_level, prd.resource_person_type from pa_resources_denorm prd, pa_rep_seq_number temp, per_jobs pj, pa_forecast_items pfi, (select NVL(FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.value('PA_OVERCOMMITMENT_PERCENTAGE')),0)/100 value_percent from dual) profile WHERE prd.job_id = pj.job_id and prd.resource_effective_end_date >= sysdate and prd.schedulable_flag = 'Y' and temp.seq_number > 0 and pfi.resource_id = prd.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 = (prd.resource_effective_start_date + temp.seq_number) and overcommitment_quantity >= capacity_quantity * profile.value_percent

View Text - HTML Formatted

SELECT PRD.RESOURCE_ID RES_ID
, PRD.RESOURCE_NAME
, PRD.MANAGER_ID
, PRD.MANAGER_NAME
, PRD.RESOURCE_ORGANIZATION_ID
, PFI.GLOBAL_EXP_PERIOD_END_DATE
, TO_NUMBER(TO_CHAR(PFI.GLOBAL_EXP_PERIOD_END_DATE
, 'MM'))
, TO_NUMBER(TO_CHAR(PFI.GLOBAL_EXP_PERIOD_END_DATE
, 'YYYY'))
, PRD.RESOURCE_EFFECTIVE_START_DATE + TEMP.SEQ_NUMBER
, PFI.CAPACITY_QUANTITY
, PFI.OVERCOMMITMENT_QUANTITY
, PFI.CAPACITY_QUANTITY + PFI.OVERCOMMITMENT_QUANTITY
, PJ.NAME
, PRD.RESOURCE_JOB_LEVEL
, PRD.RESOURCE_PERSON_TYPE
FROM PA_RESOURCES_DENORM PRD
, PA_REP_SEQ_NUMBER TEMP
, PER_JOBS PJ
, PA_FORECAST_ITEMS PFI
, (SELECT NVL(FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))
, 0)/100 VALUE_PERCENT
FROM DUAL) PROFILE
WHERE PRD.JOB_ID = PJ.JOB_ID
AND PRD.RESOURCE_EFFECTIVE_END_DATE >= SYSDATE
AND PRD.SCHEDULABLE_FLAG = 'Y'
AND TEMP.SEQ_NUMBER > 0
AND PFI.RESOURCE_ID = PRD.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 = (PRD.RESOURCE_EFFECTIVE_START_DATE + TEMP.SEQ_NUMBER)
AND OVERCOMMITMENT_QUANTITY >= CAPACITY_QUANTITY * PROFILE.VALUE_PERCENT