[Home] [Help]
View: PA_REP_PROJ_REQHRS_PAD_V
Product: | PA - Projects |
Description: | PA_REP_PROJ_REQHRS_PAD_V is a view that shows team role details for a
pa period |
Implementation/DBA Data: |
APPS.PA_REP_PROJ_REQHRS_PAD_V
|
View Text
SELECT SUM(PFI.ITEM_QUANTITY)
, PROJ.NAME
, PFI.PROJECT_ID
, PLAY.PERSON_ID
, PPF.FULL_NAME
, PROJ.CARRYING_OUT_ORGANIZATION_ID
, PFI.PVDR_PA_PERIOD_NAME
, PAP.PA_START_DATE
, PAP.PERIOD_YEAR
, PAP.QUARTER_NUM
, ASGN.ASSIGNMENT_NAME
, ASGN.MIN_RESOURCE_JOB_LEVEL
, ASGN.MAX_RESOURCE_JOB_LEVEL
, ASGN.START_DATE
, ASGN.END_DATE
, NVL(PPM.PROBABILITY_PERCENTAGE
, 100)
FROM PA_FORECAST_ITEMS PFI
, PA_PERIODS_V PAP
, PA_IMPLEMENTATIONS PAI
, PA_PROJECTS_ALL PROJ
, PA_PROBABILITY_MEMBERS PPM
, PA_PROJECT_PLAYERS PLAY
, PA_PROJECT_ASSIGNMENTS ASGN
, PA_PROJECT_STATUSES PS
, PER_PEOPLE_X PPF
WHERE PFI.FORECAST_ITEM_TYPE = 'R'
AND PFI.DELETE_FLAG = 'N'
AND PAI.SET_OF_BOOKS_ID = PAP.SET_OF_BOOKS_ID
AND PFI.PVDR_PA_PERIOD_NAME = PAP.PERIOD_NAME
AND PFI.ASSIGNMENT_ID = ASGN.ASSIGNMENT_ID
AND PFI.PROJECT_ID = PROJ.PROJECT_ID
AND ASGN.ASSIGNMENT_TYPE = 'OPEN_ASSIGNMENT'
AND ASGN.STATUS_CODE (+) = PS.PROJECT_STATUS_CODE
AND PS.PROJECT_SYSTEM_STATUS_CODE (+) = 'OPEN_ASGMT'
AND ASGN.PROJECT_ID = PROJ.PROJECT_ID
AND PLAY.PROJECT_ID = PROJ.PROJECT_ID
AND PLAY.PROJECT_ROLE_TYPE = 'PROJECT MANAGER'
AND TRUNC(SYSDATE) BETWEEN TRUNC(PLAY.START_DATE_ACTIVE)
AND TRUNC(NVL(PLAY.END_DATE_ACTIVE
, SYSDATE))
AND PLAY.PERSON_ID = PPF.PERSON_ID
AND PPM.PROBABILITY_MEMBER_ID (+) = PROJ.PROBABILITY_MEMBER_ID GROUP BY PROJ.NAME
, PFI.PROJECT_ID
, PLAY.PERSON_ID
, PPF.FULL_NAME
, PROJ.CARRYING_OUT_ORGANIZATION_ID
, PFI.PVDR_PA_PERIOD_NAME
, PAP.PA_START_DATE
, PAP.PERIOD_YEAR
, PAP.QUARTER_NUM
, ASGN.ASSIGNMENT_NAME
, ASGN.MIN_RESOURCE_JOB_LEVEL
, ASGN.MAX_RESOURCE_JOB_LEVEL
, ASGN.START_DATE
, ASGN.END_DATE
, NVL(PPM.PROBABILITY_PERCENTAGE
, 100)
Columns
Name |
REQUIRED_HOURS |
PROJECT_NAME |
PROJECT_ID |
MANAGER_ID |
MANAGER_NAME |
ORGANIZATION_ID |
PA_PERIOD |
PA_PERIOD_START_DATE |
YEAR |
QUARTER |
TEAM_ROLE |
MIN_JOB_LEVEL |
MAX_JOB_LEVEL |
START_DATE |
END_DATE |
PROBABILITY |