View: FPA_AW_INV_CRITERIA_INFO_V

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

View Text

SELECT STRATEGIC_OBJ
, STRATEGIC_OBJ_PARENT
, STRATEGIC_OBJ_LEVEL
, STRATEGIC_OBJ_STATUS
, STRATEGIC_OBJ_WEIGHT
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 ATTRIBUTE STRATEGIC_OBJ_STATUS
FROM STRATEGIC_OBJ_STATUS_R ATTRIBUTE STRATEGIC_OBJ_LEVEL
FROM INVEST_CRITERIA_LEVEL_R MEASURE STRATEGIC_OBJ_WEIGHT
FROM STRATEGIC_OBJ_WEIGHT_M'))

Columns