FND Design Data [Home] [Help]

View: FPA_AW_PROJECT_SETS_V

Product: FPA - Project Portfolio Analysis
Description:
Implementation/DBA Data: ViewAPPS.FPA_AW_PROJECT_SETS_V
View Text

SELECT PORTFOLIO
, INIT_PROJECT_SET_ID
, APPR_PROJECT_SET_ID
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PORTFOLIO_PSET_TBL'
, ''
, 'DIMENSION PORTFOLIO
FROM PORTFOLIO_D WITH ATTRIBUTE APPR_PROJECT_SET_ID
FROM PORTFOLIO_PROJECT_SET_APPROVED_R ATTRIBUTE INIT_PROJECT_SET_ID
FROM PORTFOLIO_PROJECT_SET_SUBMITTED_R'))

Columns

Name
PORTFOLIO
INIT_PROJECT_SET_ID
APPR_PROJECT_SET_ID