VIEW: APPS.FPA_AW_PROJ_INV_RANK_MAPS_V

Source

View Text - Preformatted

SELECT scenario ,planning_cycle ,project ,investment_criteria ,current_funding_status ,class_code ,recommended_funding_status ,pc_display_factor ,weighted_score ,user_rank ,investment_index ,risk_percentile, fin_percentile ,str_percentile ,net_present_value ,funds_required ,scenario_project_valid FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_proj_inv_rank_map_tbl','', 'DIMENSION scenario FROM scenario_d WITH ATTRIBUTE planning_cycle FROM planning_cycle_scenario_r DIMENSION project FROM project_d WITH ATTRIBUTE current_funding_status FROM funding_status_curr_project_r ATTRIBUTE class_code FROM class_code_project_r ATTRIBUTE recommended_funding_status FROM funding_status_rec_scenario_project_r DIMENSION investment_criteria FROM strategic_obj_d MEASURE pc_display_factor FROM AW_EXPR factor_pc_r(planning_cycle_d planning_cycle_scenario_r) MEASURE weighted_Score from scenario_project_obj_wscore_m MEASURE user_rank FROM scenario_project_user_rank_m MEASURE investment_index FROM scenario_project_inv_index_m MEASURE risk_percentile FROM scenario_project_rsk_percent_m MEASURE fin_percentile FROM scenario_project_fin_percent_m MEASURE str_percentile FROM scenario_project_str_percent_m MEASURE net_present_value FROM scenario_project_npv_m MEASURE funds_required FROM scenario_project_funds_req_m MEASURE scenario_project_valid from scenario_project_m')) WHERE scenario_project_valid = 1

View Text - HTML Formatted

SELECT SCENARIO
, PLANNING_CYCLE
, PROJECT
, INVESTMENT_CRITERIA
, CURRENT_FUNDING_STATUS
, CLASS_CODE
, RECOMMENDED_FUNDING_STATUS
, PC_DISPLAY_FACTOR
, WEIGHTED_SCORE
, USER_RANK
, INVESTMENT_INDEX
, RISK_PERCENTILE
, FIN_PERCENTILE
, STR_PERCENTILE
, NET_PRESENT_VALUE
, FUNDS_REQUIRED
, SCENARIO_PROJECT_VALID
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PROJ_INV_RANK_MAP_TBL'
, ''
, 'DIMENSION SCENARIO
FROM SCENARIO_D WITH ATTRIBUTE PLANNING_CYCLE
FROM PLANNING_CYCLE_SCENARIO_R DIMENSION PROJECT
FROM PROJECT_D WITH ATTRIBUTE CURRENT_FUNDING_STATUS
FROM FUNDING_STATUS_CURR_PROJECT_R ATTRIBUTE CLASS_CODE
FROM CLASS_CODE_PROJECT_R ATTRIBUTE RECOMMENDED_FUNDING_STATUS
FROM FUNDING_STATUS_REC_SCENARIO_PROJECT_R DIMENSION INVESTMENT_CRITERIA
FROM STRATEGIC_OBJ_D MEASURE PC_DISPLAY_FACTOR
FROM AW_EXPR FACTOR_PC_R(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R) MEASURE WEIGHTED_SCORE
FROM SCENARIO_PROJECT_OBJ_WSCORE_M MEASURE USER_RANK
FROM SCENARIO_PROJECT_USER_RANK_M MEASURE INVESTMENT_INDEX
FROM SCENARIO_PROJECT_INV_INDEX_M MEASURE RISK_PERCENTILE
FROM SCENARIO_PROJECT_RSK_PERCENT_M MEASURE FIN_PERCENTILE
FROM SCENARIO_PROJECT_FIN_PERCENT_M MEASURE STR_PERCENTILE
FROM SCENARIO_PROJECT_STR_PERCENT_M MEASURE NET_PRESENT_VALUE
FROM SCENARIO_PROJECT_NPV_M MEASURE FUNDS_REQUIRED
FROM SCENARIO_PROJECT_FUNDS_REQ_M MEASURE SCENARIO_PROJECT_VALID
FROM SCENARIO_PROJECT_M'))
WHERE SCENARIO_PROJECT_VALID = 1