VIEW: APPS.PA_REP_RES_SCHHRS_GLD_V

Source

View Text - Preformatted

SELECT ppa.name, ppa.segment1, ppa.project_type, pfi.project_id, pa_project_parties_utils.get_project_manager_name(pfi.project_id), decode(pps.project_system_status_code,'UNAPPROVED', NVL(ppm.probability_percentage, 100), ppm.probability_percentage), pprt.meaning, wt.name, ppas.start_date, ppas.end_date, sum(decode(pfi.provisional_flag,'N',pfi.item_quantity,0)), sum(decode(pfi.provisional_flag,'Y',pfi.item_quantity,0)), pfi.pvdr_gl_period_name, pfi.pvdr_period_set_name, pfi.resource_id, ppf_rsc.full_name from pa_forecast_items pfi, pa_projects_all ppa, pa_project_assignments ppas, pa_probability_members ppm, per_people_x ppf_rsc, pa_project_role_types pprt, pa_project_statuses pps, pa_work_types_vl wt WHERE pfi.forecast_item_type = 'A' and pfi.delete_flag = 'N' and pfi.project_id = ppa.project_id and pfi.person_id = ppf_rsc.person_id and ppm.probability_member_id(+) = ppa.probability_member_id and ppas.assignment_id = pfi.assignment_id and ppas.project_id = pfi.project_id and ppas.project_role_id = pprt.project_role_id and ppa.project_status_code = pps.project_status_code and ppas.work_type_id = wt.work_type_id group by ppa.name, ppa.segment1, ppa.project_type, pfi.project_id, pa_project_parties_utils.get_project_manager_name(pfi.project_id), decode(pps.project_system_status_code,'UNAPPROVED', NVL(ppm.probability_percentage, 100), ppm.probability_percentage), pprt.meaning, wt.name, ppas.start_date, ppas.end_date, pfi.pvdr_gl_period_name, pfi.pvdr_period_set_name, pfi.resource_id, ppf_rsc.full_name

View Text - HTML Formatted

SELECT PPA.NAME
, PPA.SEGMENT1
, PPA.PROJECT_TYPE
, PFI.PROJECT_ID
, PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME(PFI.PROJECT_ID)
, DECODE(PPS.PROJECT_SYSTEM_STATUS_CODE
, 'UNAPPROVED'
, NVL(PPM.PROBABILITY_PERCENTAGE
, 100)
, PPM.PROBABILITY_PERCENTAGE)
, PPRT.MEANING
, WT.NAME
, PPAS.START_DATE
, PPAS.END_DATE
, SUM(DECODE(PFI.PROVISIONAL_FLAG
, 'N'
, PFI.ITEM_QUANTITY
, 0))
, SUM(DECODE(PFI.PROVISIONAL_FLAG
, 'Y'
, PFI.ITEM_QUANTITY
, 0))
, PFI.PVDR_GL_PERIOD_NAME
, PFI.PVDR_PERIOD_SET_NAME
, PFI.RESOURCE_ID
, PPF_RSC.FULL_NAME
FROM PA_FORECAST_ITEMS PFI
, PA_PROJECTS_ALL PPA
, PA_PROJECT_ASSIGNMENTS PPAS
, PA_PROBABILITY_MEMBERS PPM
, PER_PEOPLE_X PPF_RSC
, PA_PROJECT_ROLE_TYPES PPRT
, PA_PROJECT_STATUSES PPS
, PA_WORK_TYPES_VL WT
WHERE PFI.FORECAST_ITEM_TYPE = 'A'
AND PFI.DELETE_FLAG = 'N'
AND PFI.PROJECT_ID = PPA.PROJECT_ID
AND PFI.PERSON_ID = PPF_RSC.PERSON_ID
AND PPM.PROBABILITY_MEMBER_ID(+) = PPA.PROBABILITY_MEMBER_ID
AND PPAS.ASSIGNMENT_ID = PFI.ASSIGNMENT_ID
AND PPAS.PROJECT_ID = PFI.PROJECT_ID
AND PPAS.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
AND PPA.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPAS.WORK_TYPE_ID = WT.WORK_TYPE_ID GROUP BY PPA.NAME
, PPA.SEGMENT1
, PPA.PROJECT_TYPE
, PFI.PROJECT_ID
, PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME(PFI.PROJECT_ID)
, DECODE(PPS.PROJECT_SYSTEM_STATUS_CODE
, 'UNAPPROVED'
, NVL(PPM.PROBABILITY_PERCENTAGE
, 100)
, PPM.PROBABILITY_PERCENTAGE)
, PPRT.MEANING
, WT.NAME
, PPAS.START_DATE
, PPAS.END_DATE
, PFI.PVDR_GL_PERIOD_NAME
, PFI.PVDR_PERIOD_SET_NAME
, PFI.RESOURCE_ID
, PPF_RSC.FULL_NAME