VIEW: APPS.FPA_AW_SCE_SUM_PROJS_V

Source

View Text - Preformatted

SELECT scenario ,project ,planning_cycle ,pc_display_factor ,investment_criteria , sp_weighted_score_1 ,sp_weighted_score_2 ,sp_weighted_score_3 ,sp_weighted_score_4 ,sp_weighted_score_5 ,sp_weighted_score_6 ,sp_weighted_score_7 ,sce_project_valid FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_scen_sum_proj_vo_tbl','lmt strategic_obj_d to invest_criteria_level_r eq ''GROUP''', 'DIMENSION scenario from scenario_d WITH ATTRIBUTE planning_cycle from planning_cycle_scenario_r MEASURE pc_display_factor from AW_EXPR factor_pc_r(planning_cycle_d planning_cycle_scenario_r) DIMENSION project from project_d DIMENSION investment_criteria from strategic_obj_d MEASURE sp_weighted_score_1 from scenario_project_obj_wscore_m MEASURE sp_weighted_score_2 from AW_EXPR scenario_project_obj_wscore_m(strategic_obj_d 3) MEASURE sp_weighted_score_3 from AW_EXPR scenario_project_obj_wscore_m(strategic_obj_d 4) MEASURE sp_weighted_score_4 from AW_EXPR scenario_project_obj_wscore_m(strategic_obj_d 5) MEASURE sp_weighted_score_5 from AW_EXPR scenario_project_obj_wscore_m(strategic_obj_d 6) MEASURE sp_weighted_score_6 from AW_EXPR scenario_project_obj_wscore_m(strategic_obj_d 7) MEASURE sp_weighted_score_7 from AW_EXPR scenario_project_obj_wscore_m(strategic_obj_d 8) MEASURE sce_project_valid  from scenario_project_m')) WHERE sce_project_valid = 1

View Text - HTML Formatted

SELECT SCENARIO
, PROJECT
, PLANNING_CYCLE
, PC_DISPLAY_FACTOR
, INVESTMENT_CRITERIA
, SP_WEIGHTED_SCORE_1
, SP_WEIGHTED_SCORE_2
, SP_WEIGHTED_SCORE_3
, SP_WEIGHTED_SCORE_4
, SP_WEIGHTED_SCORE_5
, SP_WEIGHTED_SCORE_6
, SP_WEIGHTED_SCORE_7
, SCE_PROJECT_VALID
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_SCEN_SUM_PROJ_VO_TBL'
, 'LMT STRATEGIC_OBJ_D TO INVEST_CRITERIA_LEVEL_R EQ ''GROUP'''
, 'DIMENSION SCENARIO
FROM SCENARIO_D WITH ATTRIBUTE PLANNING_CYCLE
FROM PLANNING_CYCLE_SCENARIO_R MEASURE PC_DISPLAY_FACTOR
FROM AW_EXPR FACTOR_PC_R(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R) DIMENSION PROJECT
FROM PROJECT_D DIMENSION INVESTMENT_CRITERIA
FROM STRATEGIC_OBJ_D MEASURE SP_WEIGHTED_SCORE_1
FROM SCENARIO_PROJECT_OBJ_WSCORE_M MEASURE SP_WEIGHTED_SCORE_2
FROM AW_EXPR SCENARIO_PROJECT_OBJ_WSCORE_M(STRATEGIC_OBJ_D 3) MEASURE SP_WEIGHTED_SCORE_3
FROM AW_EXPR SCENARIO_PROJECT_OBJ_WSCORE_M(STRATEGIC_OBJ_D 4) MEASURE SP_WEIGHTED_SCORE_4
FROM AW_EXPR SCENARIO_PROJECT_OBJ_WSCORE_M(STRATEGIC_OBJ_D 5) MEASURE SP_WEIGHTED_SCORE_5
FROM AW_EXPR SCENARIO_PROJECT_OBJ_WSCORE_M(STRATEGIC_OBJ_D 6) MEASURE SP_WEIGHTED_SCORE_6
FROM AW_EXPR SCENARIO_PROJECT_OBJ_WSCORE_M(STRATEGIC_OBJ_D 7) MEASURE SP_WEIGHTED_SCORE_7
FROM AW_EXPR SCENARIO_PROJECT_OBJ_WSCORE_M(STRATEGIC_OBJ_D 8) MEASURE SCE_PROJECT_VALID
FROM SCENARIO_PROJECT_M'))
WHERE SCE_PROJECT_VALID = 1