View: FPA_AW_SCE_NPVS_V

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

View Text

SELECT SCENARIO
, DISCOUNT_RATE
, NET_PRESENT_VALUE
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_SCENARIO_TBL'
, 'LMT DAY_D TO LIMIT( LIMIT(DAY_D TO DAY_D GT TODAY) KEEP ANY(SCENARIO_CASHFLOW_DAY_M NE NA
, DAY_D)) TODAY'
, 'DIMENSION SCENARIO
FROM SCENARIO_D MEASURE DISCOUNT_RATE
FROM SCENARIO_DISCOUNT_RATE_M MEASURE NET_PRESENT_VALUE
FROM SCENARIO_NPV_M'))

Columns