MSC_ATTRIBUTES_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ATTRIBUTE_ID DIMENSION_ID DIMENSION_NAME ATTRIBUTE_NAME DERIVE_VALUES ATTRIBUTE_NUMBER SUP_DEM_COL_MAPPED DATA_TYPE VAL_FROM_TRNX_DATA FUSION_VAL_SET_ATTR ATTRIBUTE_SET_ID PARENT_ATTRIBUTE_ID ACTIVE_STATUS ATTR_VAL_SET_ID_COL_TYPE BM_FLAG PLANNING_ATTRIBUTE_TYPE DEFAULT_VALUE ALLOW_USER_ATTR_VALUE OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.ATTRIBUTE_ID, b.DIMENSION_ID, t.DIMENSION_NAME, t.ATTRIBUTE_NAME, b.DERIVE_VALUES, b.ATTRIBUTE_NUMBER, b.SUP_DEM_COL_MAPPED, b.DATA_TYPE, b.VAL_FROM_TRNX_DATA, b.FUSION_VAL_SET_ATTR, b.ATTRIBUTE_SET_ID, b.PARENT_ATTRIBUTE_ID, b.ACTIVE_STATUS, b.ATTR_VAL_SET_ID_COL_TYPE, b.BM_FLAG, b.PLANNING_ATTRIBUTE_TYPE, t.DEFAULT_VALUE, b.ALLOW_USER_ATTR_VALUE, b.OBJECT_VERSION_NUMBER, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.CREATION_DATE, b.CREATED_BY, b.LAST_UPDATE_LOGIN FROM MSC_ATTRIBUTES_B b, MSC_ATTRIBUTES_TL t WHERE b.ATTRIBUTE_ID = t.ATTRIBUTE_ID AND t.LANGUAGE = USERENV('LANG')