VIEW: APPS.FPA_AW_INV_CRITERIA_INFO_V

Source

View Text - Preformatted

SELECT strategic_obj ,strategic_obj_parent ,strategic_obj_level ,strategic_obj_status ,strategic_obj_weight from table ( olap_table(fpa_utilities_pvt.aw_space_name || ' duration query','fpa_inv_criteria_tbl','', 'DIMENSION strategic_obj from strategic_obj_d                                         WITH HIERARCHY strategic_obj_parent from strategic_obj_h                          ATTRIBUTE strategic_obj_status from strategic_obj_status_r                          ATTRIBUTE strategic_obj_level from invest_criteria_level_r                          MEASURE strategic_obj_weight from strategic_obj_weight_m'))

View Text - HTML Formatted

SELECT STRATEGIC_OBJ
, STRATEGIC_OBJ_PARENT
, STRATEGIC_OBJ_LEVEL
, STRATEGIC_OBJ_STATUS
, STRATEGIC_OBJ_WEIGHT
FROM TABLE ( OLAP_TABLE(FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_INV_CRITERIA_TBL'
, ''
, 'DIMENSION STRATEGIC_OBJ
FROM STRATEGIC_OBJ_D WITH HIERARCHY STRATEGIC_OBJ_PARENT
FROM STRATEGIC_OBJ_H ATTRIBUTE STRATEGIC_OBJ_STATUS
FROM STRATEGIC_OBJ_STATUS_R ATTRIBUTE STRATEGIC_OBJ_LEVEL
FROM INVEST_CRITERIA_LEVEL_R MEASURE STRATEGIC_OBJ_WEIGHT
FROM STRATEGIC_OBJ_WEIGHT_M'))