VIEW: APPS.FPA_AW_PC_INV_CRITERIA_V

Source

View Text - Preformatted

SELECT planning_cycle, investment_criteria, is_valid_pc_inv_criteria, pc_inv_criteria_weight, pc_inv_crit_score_target_from, pc_inv_crit_score_target_to FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_pc_inv_criteria_tbl','', 'DIMENSION planning_cycle from planning_cycle_d              DIMENSION investment_criteria from strategic_obj_d              MEASURE pc_inv_criteria_weight from pc_strategic_obj_weights_m              MEASURE pc_inv_crit_score_target_from from pc_obj_wscore_targets_from_m  	     measure pc_inv_crit_score_target_to from pc_obj_wscore_targets_to_m              measure is_valid_pc_inv_criteria from pc_obj_m')) WHERE is_valid_pc_inv_criteria = 1

View Text - HTML Formatted

SELECT PLANNING_CYCLE
, INVESTMENT_CRITERIA
, IS_VALID_PC_INV_CRITERIA
, PC_INV_CRITERIA_WEIGHT
, PC_INV_CRIT_SCORE_TARGET_FROM
, PC_INV_CRIT_SCORE_TARGET_TO
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PC_INV_CRITERIA_TBL'
, ''
, 'DIMENSION PLANNING_CYCLE
FROM PLANNING_CYCLE_D DIMENSION INVESTMENT_CRITERIA
FROM STRATEGIC_OBJ_D MEASURE PC_INV_CRITERIA_WEIGHT
FROM PC_STRATEGIC_OBJ_WEIGHTS_M MEASURE PC_INV_CRIT_SCORE_TARGET_FROM
FROM PC_OBJ_WSCORE_TARGETS_FROM_M MEASURE PC_INV_CRIT_SCORE_TARGET_TO
FROM PC_OBJ_WSCORE_TARGETS_TO_M MEASURE IS_VALID_PC_INV_CRITERIA
FROM PC_OBJ_M'))
WHERE IS_VALID_PC_INV_CRITERIA = 1