VIEW: APPS.PA_REP_RES_CAP_WKD_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, pa_resource_utils.get_provisional_hours (prd.resource_id, prd.resource_effective_start_date + temp.seq_number), DECODE(pfi.overcommitment_flag, 'Y', pfi.capacity_quantity + pfi.overcommitment_quantity, pfi.capacity_quantity-NVL(pfi.availability_quantity,0)), 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 WHERE prd.job_id = pj.job_id 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.item_date = (prd.resource_effective_start_date + temp.seq_number) and pfi.item_date between prd.resource_effective_start_date and prd.resource_effective_end_date

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
, PA_RESOURCE_UTILS.GET_PROVISIONAL_HOURS (PRD.RESOURCE_ID
, PRD.RESOURCE_EFFECTIVE_START_DATE + TEMP.SEQ_NUMBER)
, DECODE(PFI.OVERCOMMITMENT_FLAG
, 'Y'
, PFI.CAPACITY_QUANTITY + PFI.OVERCOMMITMENT_QUANTITY
, PFI.CAPACITY_QUANTITY-NVL(PFI.AVAILABILITY_QUANTITY
, 0))
, 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
WHERE PRD.JOB_ID = PJ.JOB_ID
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.ITEM_DATE = (PRD.RESOURCE_EFFECTIVE_START_DATE + TEMP.SEQ_NUMBER)
AND PFI.ITEM_DATE BETWEEN PRD.RESOURCE_EFFECTIVE_START_DATE
AND PRD.RESOURCE_EFFECTIVE_END_DATE