MSC_MEASURES_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

MEASURE_ID MEASURE_CODE DATA_TYPE EDITABLE EDIT_RANGE STORE_RESULT SHARED_FLAG AGGR_ORDER AGGR_METHOD_OTHER AGGR_METHOD_TIME WEIGHTED_BY DISAGGR_METHOD_OTHER DISAGGR_BASIS_OTHER DISAGGR_METHOD_TIME DISAGGR_BASIS_TIME SOURCE_TYPE SOURCE_LEVEL_ID SOURCE_ATTRIBUTE_NAME OWNER GRANULARITY_ID MAX_GRANULARITY_ID CREATED_BY CREATION_DATE SOURCE_ATTRIBUTE_ID IS_SEEDED DECIMAL_PLACES DATE_FORMAT LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN TABLE_ID IS_DISABLE ODS_DATA_VIEW SEC_BASIS OBJECT_VERSION_NUMBER NAME DESCRIPTION RELEVANT_PLAN_TYPE MEASURE_CALC_TYPE BASE_MEASURE_ID PROPAGATION_RULE_ID GOAL_VALUES MIN_LOW_RANGE MIN_HIGH_RANGE MAX_LOW_RANGE MAX_HIGH_RANGE BASE_UOM_CODE BASE_CURRENCY_CODE REL_BASE_MEASURE_ID REL_TYPE GRAPH_COLOR EXPRESSION EDIT_LOCK_EXPR LINKING_MEASURE_ID

Query

SQL_Statement

SELECT b.MEASURE_ID, b.MEASURE_CODE, b.DATA_TYPE, b.EDITABLE, b.EDIT_RANGE, b.STORE_RESULT, b.SHARED_FLAG, b.AGGR_ORDER, b.AGGR_METHOD_OTHER, b.AGGR_METHOD_TIME, b.WEIGHTED_BY, b.DISAGGR_METHOD_OTHER, b.DISAGGR_BASIS_OTHER, b.DISAGGR_METHOD_TIME, b.DISAGGR_BASIS_TIME, b.SOURCE_TYPE, b.SOURCE_LEVEL_ID, b.SOURCE_ATTRIBUTE_NAME, b.OWNER, b.GRANULARITY_ID, b.MAX_GRANULARITY_ID, b.CREATED_BY, b.CREATION_DATE, b.SOURCE_ATTRIBUTE_ID, b.IS_SEEDED, b.DECIMAL_PLACES, b.DATE_FORMAT, CASE WHEN b.LAST_UPDATE_DATE > addl.LAST_UPDATE_DATE THEN b.LAST_UPDATED_BY ELSE addl.LAST_UPDATED_BY END LAST_UPDATED_BY, CASE WHEN b.LAST_UPDATE_DATE > addl.LAST_UPDATE_DATE THEN b.LAST_UPDATE_DATE ELSE addl.LAST_UPDATE_DATE END LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN, b.TABLE_ID, b.IS_DISABLE, b.ODS_DATA_VIEW, b.SEC_BASIS, b.OBJECT_VERSION_NUMBER, t.NAME, t.DESCRIPTION, b.RELEVANT_PLAN_TYPE, b.MEASURE_CALC_TYPE, b.BASE_MEASURE_ID, b.PROPAGATION_RULE_ID, addl.GOAL_VALUES, addl.MIN_LOW_RANGE, addl.MIN_HIGH_RANGE, addl.MAX_LOW_RANGE, addl.MAX_HIGH_RANGE, addl.BASE_UOM_CODE, addl.BASE_CURRENCY_CODE, addl.REL_BASE_MEASURE_ID, addl.REL_TYPE, addl.GRAPH_COLOR, decode(addl.USR_EXPRESSION,'ExprIsDeleted',null,nvl(addl.USR_EXPRESSION,b.expression)) EXPRESSION, decode(addl.USR_EDIT_LOCK_EXPR,'EditLockExprIsDeleted',null,nvl(addl.USR_EDIT_LOCK_EXPR,b.EDIT_LOCK_EXPR)) EDIT_LOCK_EXPR, b.LINKING_MEASURE_ID FROM MSC_MEASURES_B b, MSC_MEASURES_TL t, MSC_MEASURES_ADDL_DEF addl WHERE b.MEASURE_ID = t.MEASURE_ID AND b.MEASURE_ID = addl.MEASURE_ID AND t.LANGUAGE = USERENV('LANG')