FND Design Data [Home] [Help]

View: FPA_AW_INV_CRITERIA_V

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

SELECT STRATEGIC_OBJ
, STRATEGIC_OBJ_PARENT
FROM TABLE ( OLAP_TABLE(FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_INV_CRITERIA_TBL'
, ''
, 'DIMENSION STRATEGIC_OBJ
FROM STRATEGIC_OBJ_D WITH HIERARCHY STRATEGIC_OBJ_PARENT
FROM STRATEGIC_OBJ_H'))

Columns

Name
STRATEGIC_OBJ
STRATEGIC_OBJ_PARENT