VIEW: APPS.FPA_AW_SCE_SUM_SCES_V

Source

View Text - Preformatted

SELECT scenario ,planning_cycle ,pc_category ,pc_display_factor ,investment_criteria ,s_funds_available ,s_funds_required ,s_funding_variance ,s_planned_benefit ,s_net_present_value ,s_internal_rate_return ,s_payback_period ,s_return_on_inv ,s_weighted_score ,s_cost_weighted_score FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_scen_sum_sce_vo_tbl','limit planning_cycle_d to scenario_d', 'DIMENSION scenario FROM scenario_d WITH ATTRIBUTE planning_cycle from planning_cycle_scenario_r ATTRIBUTE pc_display_factor from factor_pc_r DIMENSION investment_criteria from strategic_obj_d MEASURE pc_category FROM AW_EXPR pc_category_m(planning_cycle_d planning_cycle_scenario_r) MEASURE s_funds_available from scenario_funding_m 	      MEASURE s_funds_required from scenario_funds_req_m 	      MEASURE s_funding_variance from scenario_fund_var_m 	      MEASURE s_planned_benefit from scenario_benefit_m 	      MEASURE s_net_present_value from scenario_npv_m 		  MEASURE s_internal_rate_return from scenario_irr_m 		  MEASURE s_payback_period from scenario_payback_m 		 MEASURE s_return_on_inv  from scenario_roi_m   MEASURE s_weighted_Score from scenario_obj_wscore_m               MEASURE s_cost_weighted_score from scenario_obj_cwscore_m'))

View Text - HTML Formatted

SELECT SCENARIO
, PLANNING_CYCLE
, PC_CATEGORY
, PC_DISPLAY_FACTOR
, INVESTMENT_CRITERIA
, S_FUNDS_AVAILABLE
, S_FUNDS_REQUIRED
, S_FUNDING_VARIANCE
, S_PLANNED_BENEFIT
, S_NET_PRESENT_VALUE
, S_INTERNAL_RATE_RETURN
, S_PAYBACK_PERIOD
, S_RETURN_ON_INV
, S_WEIGHTED_SCORE
, S_COST_WEIGHTED_SCORE
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_SCEN_SUM_SCE_VO_TBL'
, 'LIMIT PLANNING_CYCLE_D TO SCENARIO_D'
, 'DIMENSION SCENARIO
FROM SCENARIO_D WITH ATTRIBUTE PLANNING_CYCLE
FROM PLANNING_CYCLE_SCENARIO_R ATTRIBUTE PC_DISPLAY_FACTOR
FROM FACTOR_PC_R DIMENSION INVESTMENT_CRITERIA
FROM STRATEGIC_OBJ_D MEASURE PC_CATEGORY
FROM AW_EXPR PC_CATEGORY_M(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R) MEASURE S_FUNDS_AVAILABLE
FROM SCENARIO_FUNDING_M MEASURE S_FUNDS_REQUIRED
FROM SCENARIO_FUNDS_REQ_M MEASURE S_FUNDING_VARIANCE
FROM SCENARIO_FUND_VAR_M MEASURE S_PLANNED_BENEFIT
FROM SCENARIO_BENEFIT_M MEASURE S_NET_PRESENT_VALUE
FROM SCENARIO_NPV_M MEASURE S_INTERNAL_RATE_RETURN
FROM SCENARIO_IRR_M MEASURE S_PAYBACK_PERIOD
FROM SCENARIO_PAYBACK_M MEASURE S_RETURN_ON_INV
FROM SCENARIO_ROI_M MEASURE S_WEIGHTED_SCORE
FROM SCENARIO_OBJ_WSCORE_M MEASURE S_COST_WEIGHTED_SCORE
FROM SCENARIO_OBJ_CWSCORE_M'))