FND Design Data [Home] [Help]

View: FPA_AW_SCE_CASHFLOWS_V

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

SELECT SCENARIO
, FUNDS_REQUIRED
, TOTAL_BENEFIT
, SUNK_COST
, TOTAL_COST
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_SCE_METRICS_TBL'
, ''
, 'DIMENSION SCENARIO
FROM SCENARIO_D MEASURE FUNDS_REQUIRED
FROM SCENARIO_FUNDS_REQ_M MEASURE TOTAL_BENEFIT
FROM SCENARIO_BENEFIT_M MEASURE SUNK_COST
FROM SCENARIO_SUNK_COST_M MEASURE TOTAL_COST
FROM SCENARIO_COST_M'))

Columns

Name
SCENARIO
FUNDS_REQUIRED
TOTAL_BENEFIT
SUNK_COST
TOTAL_COST