MSC_MEASURES_DEF_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 EXPRESSION EDIT_LOCK_EXPR SOURCE_TYPE SOURCE_LEVEL_ID SOURCE_ATTRIBUTE_NAME OWNER GRANULARITY_ID MAX_GRANULARITY_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SOURCE_ATTRIBUTE_ID IS_SEEDED DECIMAL_PLACES DATE_FORMAT TABLE_ID IS_DISABLE ODS_DATA_VIEW SEC_BASIS BASE_UOM_CODE BASE_CURRENCY_CODE OBJECT_VERSION_NUMBER RELEVANT_PLAN_TYPE MEASURE_CALC_TYPE NAME DESCRIPTION GOAL_VALUES MIN_LOW_RANGE MIN_HIGH_RANGE MAX_LOW_RANGE MAX_HIGH_RANGE BASE_MEASURE_ID PROPAGATION_RULE_ID 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.EXPRESSION, b.EDIT_LOCK_EXPR, 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.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN, b.SOURCE_ATTRIBUTE_ID, b.IS_SEEDED, b.DECIMAL_PLACES, b.DATE_FORMAT, b.TABLE_ID, b.IS_DISABLE, b.ODS_DATA_VIEW, b.SEC_BASIS, b.BASE_UOM_CODE, b.BASE_CURRENCY_CODE, b.OBJECT_VERSION_NUMBER, b.RELEVANT_PLAN_TYPE, b.MEASURE_CALC_TYPE, tl.NAME, tl.DESCRIPTION, b.GOAL_VALUES, b.MIN_LOW_RANGE, b.MIN_HIGH_RANGE, b.MAX_LOW_RANGE, b.MAX_HIGH_RANGE, b.BASE_MEASURE_ID, b.PROPAGATION_RULE_ID, b.LINKING_MEASURE_ID FROM MSC_MEASURES_B b, MSC_MEASURES_TL tl WHERE b.MEASURE_ID = tl.MEASURE_ID AND tl.LANGUAGE = USERENV('LANG')