View: FPA_AW_PROJS_V

Product:	FPA - Project Portfolio Analysis
Description:
Implementation/DBA Data:	APPS.FPA_AW_PROJS_V

View Text

SELECT PROJECT
, CLASS_CODE
, PORTFOLIO
, PLANNING_CYCLE
FROM TABLE (OLAP_TABLE(FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PROJ_TBL'
, ''
, 'DIMENSION PROJECT
FROM PROJECT_D WITH ATTRIBUTE CLASS_CODE
FROM CLASS_CODE_PROJECT_R ATTRIBUTE PORTFOLIO
FROM PORTFOLIO_PROJECT_R ATTRIBUTE PLANNING_CYCLE
FROM PC_PROJECT_R'))

Columns