View: PA_REP_PROJ_REQHRS_WK_V

Product:	PA - Projects
Description:	PA_REP_PROJ_REQHRS_WK_V is a view that shows required project hours for global expenditure week
Implementation/DBA Data:	APPS.PA_REP_PROJ_REQHRS_WK_V

View Text

SELECT PFI.ITEM_QUANTITY
, PROJ.NAME
, PFI.PROJECT_ID
, PLAY.PERSON_ID
, PPF.FULL_NAME
, PROJ.CARRYING_OUT_ORGANIZATION_ID
, TO_NUMBER(TO_CHAR(PFI.GLOBAL_EXP_PERIOD_END_DATE
, 'YYYY'))
, TO_NUMBER(TO_CHAR(PFI.GLOBAL_EXP_PERIOD_END_DATE
, 'MM'))
, PFI.GLOBAL_EXP_PERIOD_END_DATE
, PFI.ITEM_DATE
, ASGN.ASSIGNMENT_NAME
FROM PA_FORECAST_ITEMS PFI
, PA_PROJECTS_ALL PROJ
, 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 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 PLAY.PERSON_ID = PPF.PERSON_ID
AND SYSDATE BETWEEN PLAY.START_DATE_ACTIVE
AND NVL(PLAY.END_DATE_ACTIVE
, SYSDATE)

Columns