VIEW: APPS.FPA_AW_PROJ_INV_CRITERIA_V

Source

View Text - Preformatted

SELECT planning_cycle, project, investment_criteria, weight_percent, weight_score, approved_score, new_score, criteria_level, is_valid_inv_criteria FROM table ( olap_table (fpa_utilities_pvt.aw_space_name||' duration query', 'fpa_proj_inv_criteria_tbl','lmt planning_cycle_d to pc_project_r', 'DIMENSION project from project_d 			 DIMENSION planning_cycle from planning_cycle_d              DIMENSION investment_criteria from strategic_obj_d              MEASURE   weight_percent from pc_strategic_obj_weights_m               MEASURE   weight_score from project_strategic_obj_weights_score_m              MEASURE   approved_score from project_approved_obj_score_m              MEASURE   new_score from project_entered_obj_score_m                    MEASURE   criteria_level from invest_criteria_level_r                                                     MEASURE   is_valid_inv_criteria from pc_obj_m                       ')) WHERE is_valid_inv_criteria = 1

View Text - HTML Formatted

SELECT PLANNING_CYCLE
, PROJECT
, INVESTMENT_CRITERIA
, WEIGHT_PERCENT
, WEIGHT_SCORE
, APPROVED_SCORE
, NEW_SCORE
, CRITERIA_LEVEL
, IS_VALID_INV_CRITERIA
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME||' DURATION QUERY'
, 'FPA_PROJ_INV_CRITERIA_TBL'
, 'LMT PLANNING_CYCLE_D TO PC_PROJECT_R'
, 'DIMENSION PROJECT
FROM PROJECT_D DIMENSION PLANNING_CYCLE
FROM PLANNING_CYCLE_D DIMENSION INVESTMENT_CRITERIA
FROM STRATEGIC_OBJ_D MEASURE WEIGHT_PERCENT
FROM PC_STRATEGIC_OBJ_WEIGHTS_M MEASURE WEIGHT_SCORE
FROM PROJECT_STRATEGIC_OBJ_WEIGHTS_SCORE_M MEASURE APPROVED_SCORE
FROM PROJECT_APPROVED_OBJ_SCORE_M MEASURE NEW_SCORE
FROM PROJECT_ENTERED_OBJ_SCORE_M MEASURE CRITERIA_LEVEL
FROM INVEST_CRITERIA_LEVEL_R MEASURE IS_VALID_INV_CRITERIA
FROM PC_OBJ_M '))
WHERE IS_VALID_INV_CRITERIA = 1