VIEW: APPS.FPA_AW_SCE_EXCS_V

Source

View Text - Preformatted

SELECT scenario ,planning_cycle ,portfolio ,cost_weighted_score ,net_present_Value ,return_on_inv ,pc_cost_weighted_score_from ,pc_cost_weighted_score_to ,pc_npv_from ,pc_npv_to ,pc_roi_from ,pc_roi_to ,pc_display_factor ,recommended_flag ,approved_flag ,is_working_scenario ,discount_rate ,funds_available ,funds_required FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_sce_exc_tbl','lmt scenario_d to planning_cycle_scenario_r', ' DIMENSION scenario FROM scenario_d WITH ATTRIBUTE planning_cycle from planning_cycle_scenario_r MEASURE portfolio FROM AW_EXPR portfolio_pc_r(planning_cycle_d planning_cycle_scenario_r) MEASURE pc_display_factor FROM AW_EXPR factor_pc_r(planning_cycle_d planning_cycle_scenario_r) MEASURE cost_weighted_score from AW_EXPR scenario_obj_cwscore_m(strategic_obj_d 3) MEASURE net_present_Value from scenario_npv_m MEASURE return_on_inv FROM scenario_roi_m MEASURE pc_cost_weighted_score_from FROM AW_EXPR pc_obj_wscore_targets_from_m(planning_cycle_d planning_cycle_scenario_r strategic_obj_d 3)  MEASURE pc_cost_weighted_score_to FROM AW_EXPR pc_obj_wscore_targets_to_m(planning_cycle_d planning_cycle_scenario_r strategic_obj_d 3) MEASURE pc_npv_from FROM AW_EXPR pc_fintargets_range_from_m(planning_cycle_d planning_cycle_scenario_r financial_metrics_d ''NPV'') MEASURE pc_npv_to FROM AW_EXPR pc_fintargets_range_to_m(planning_cycle_d planning_cycle_scenario_r financial_metrics_d ''NPV'') MEASURE pc_roi_from FROM AW_EXPR pc_fintargets_range_from_m(planning_cycle_d planning_cycle_scenario_r financial_metrics_d ''ROI'') MEASURE pc_roi_to FROM AW_EXPR pc_fintargets_range_to_m(planning_cycle_d planning_cycle_scenario_r financial_metrics_d ''ROI'') MEASURE recommended_flag from scenario_recommended_flag_m MEASURE approved_flag from scenario_approved_flag_m MEASURE is_working_scenario from scenario_working_m MEASURE discount_rate from scenario_discount_rate_m MEASURE funds_available from scenario_funding_m MEASURE funds_required from scenario_funds_req_m '))

View Text - HTML Formatted

SELECT SCENARIO
, PLANNING_CYCLE
, PORTFOLIO
, COST_WEIGHTED_SCORE
, NET_PRESENT_VALUE
, RETURN_ON_INV
, PC_COST_WEIGHTED_SCORE_FROM
, PC_COST_WEIGHTED_SCORE_TO
, PC_NPV_FROM
, PC_NPV_TO
, PC_ROI_FROM
, PC_ROI_TO
, PC_DISPLAY_FACTOR
, RECOMMENDED_FLAG
, APPROVED_FLAG
, IS_WORKING_SCENARIO
, DISCOUNT_RATE
, FUNDS_AVAILABLE
, FUNDS_REQUIRED
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_SCE_EXC_TBL'
, 'LMT SCENARIO_D TO PLANNING_CYCLE_SCENARIO_R'
, ' DIMENSION SCENARIO
FROM SCENARIO_D WITH ATTRIBUTE PLANNING_CYCLE
FROM PLANNING_CYCLE_SCENARIO_R MEASURE PORTFOLIO
FROM AW_EXPR PORTFOLIO_PC_R(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R) MEASURE PC_DISPLAY_FACTOR
FROM AW_EXPR FACTOR_PC_R(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R) MEASURE COST_WEIGHTED_SCORE
FROM AW_EXPR SCENARIO_OBJ_CWSCORE_M(STRATEGIC_OBJ_D 3) MEASURE NET_PRESENT_VALUE
FROM SCENARIO_NPV_M MEASURE RETURN_ON_INV
FROM SCENARIO_ROI_M MEASURE PC_COST_WEIGHTED_SCORE_FROM
FROM AW_EXPR PC_OBJ_WSCORE_TARGETS_FROM_M(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R STRATEGIC_OBJ_D 3) MEASURE PC_COST_WEIGHTED_SCORE_TO
FROM AW_EXPR PC_OBJ_WSCORE_TARGETS_TO_M(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R STRATEGIC_OBJ_D 3) MEASURE PC_NPV_FROM
FROM AW_EXPR PC_FINTARGETS_RANGE_FROM_M(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R FINANCIAL_METRICS_D ''NPV'') MEASURE PC_NPV_TO
FROM AW_EXPR PC_FINTARGETS_RANGE_TO_M(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R FINANCIAL_METRICS_D ''NPV'') MEASURE PC_ROI_FROM
FROM AW_EXPR PC_FINTARGETS_RANGE_FROM_M(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R FINANCIAL_METRICS_D ''ROI'') MEASURE PC_ROI_TO
FROM AW_EXPR PC_FINTARGETS_RANGE_TO_M(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R FINANCIAL_METRICS_D ''ROI'') MEASURE RECOMMENDED_FLAG
FROM SCENARIO_RECOMMENDED_FLAG_M MEASURE APPROVED_FLAG
FROM SCENARIO_APPROVED_FLAG_M MEASURE IS_WORKING_SCENARIO
FROM SCENARIO_WORKING_M MEASURE DISCOUNT_RATE
FROM SCENARIO_DISCOUNT_RATE_M MEASURE FUNDS_AVAILABLE
FROM SCENARIO_FUNDING_M MEASURE FUNDS_REQUIRED
FROM SCENARIO_FUNDS_REQ_M '))