[Home] [Help]
View: FPA_AW_SCE_INFO_V
View Text
SELECT SCENARIO
, PLANNING_CYCLE
, RECOMMENDED_FLAG
, APPROVED_FLAG
, IS_INITIAL_SCENARIO
, IS_WORKING_SCENARIO
, DISCOUNT_RATE
, FUNDS_AVAILABLE
, FUNDS_REQUIRED
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_SCENARIO_TBL'
, ''
, 'DIMENSION SCENARIO
FROM SCENARIO_D WITH ATTRIBUTE PLANNING_CYCLE
FROM PLANNING_CYCLE_SCENARIO_R MEASURE IS_INITIAL_SCENARIO
FROM SCENARIO_INITIAL_M MEASURE IS_WORKING_SCENARIO
FROM SCENARIO_WORKING_M MEASURE RECOMMENDED_FLAG
FROM SCENARIO_RECOMMENDED_FLAG_M MEASURE APPROVED_FLAG
FROM SCENARIO_APPROVED_FLAG_M MEASURE DISCOUNT_RATE
FROM SCENARIO_DISCOUNT_RATE_M MEASURE FUNDS_AVAILABLE
FROM SCENARIO_FUNDING_M MEASURE FUNDS_REQUIRED
FROM SCENARIO_FUNDS_REQ_M'))
Columns
Name |
SCENARIO |
PLANNING_CYCLE |
RECOMMENDED_FLAG |
APPROVED_FLAG |
IS_INITIAL_SCENARIO |
IS_WORKING_SCENARIO |
DISCOUNT_RATE |
FUNDS_AVAILABLE |
FUNDS_REQUIRED |