Product: | PA - Projects |
---|---|
Description: | PA_REP_RES_SCHHRS_PAD_V is a view that shows the team role details for a pa period |
Implementation/DBA Data: | APPS.PA_REP_RES_SCHHRS_PAD_V |
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_PA_PERIOD_NAME
, PFI.PVDR_PERIOD_SET_NAME
, PFI.RESOURCE_ID
, PPF_RSC.FULL_NAME
, PAP.START_DATE
, PAP.ORG_ID
FROM PA_FORECAST_ITEMS PFI
, PA_PROJECTS_ALL PPA
, PA_PROJECT_ASSIGNMENTS PPAS
, PA_PROBABILITY_MEMBERS PPM
, PER_PEOPLE_X PPF_RSC
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_ROLE_TYPES PPRT
, PA_WORK_TYPES_VL WT
, PA_PERIODS PAP
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
AND PFI.PVDR_PA_PERIOD_NAME = PAP.PERIOD_NAME 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_PA_PERIOD_NAME
, PFI.PVDR_PERIOD_SET_NAME
, PFI.RESOURCE_ID
, PPF_RSC.FULL_NAME
, PAP.START_DATE
, PAP.ORG_ID