VIEW: APPS.FPA_AW_SCE_NPVS_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))