MSC_HIERARCHIES_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
HIERARCHY_ID HIERARCHY_CODE DIMENSION_ID NAME USER_SPECIFIED_NAME DEFAULT_HIERARCHY NUMBER_OF_LEVELS CUSTOM STORED_IN_TREE IS_SEEDED IS_WTM_HIERARCHY IS_END_DMD_HIERARCHY LAST_REFRESH_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT HIERARCHY_ID AS HIERARCHY_ID , HIERARCHY_CODE AS HIERARCHY_CODE , DIMENSION_ID AS DIMENSION_ID , NAME AS NAME , USER_SPECIFIED_NAME AS USER_SPECIFIED_NAME , DEFAULT_HIERARCHY AS DEFAULT_HIERARCHY , NUMBER_OF_LEVELS AS NUMBER_OF_LEVELS , CUSTOM AS CUSTOM , STORED_IN_TREE AS STORED_IN_TREE , IS_SEEDED AS IS_SEEDED , IS_WTM_HIERARCHY AS IS_WTM_HIERARCHY , IS_END_DMD_HIERARCHY AS IS_END_DMD_HIERARCHY , LAST_REFRESH_NUMBER AS LAST_REFRESH_NUMBER , CREATED_BY AS CREATED_BY , CREATION_DATE AS CREATION_DATE , LAST_UPDATED_BY AS LAST_UPDATED_BY , LAST_UPDATE_DATE AS LAST_UPDATE_DATE , LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN , OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER FROM ( SELECT MH.HIERARCHY_ID HIERARCHY_ID , MH.HIERARCHY_CODE HIERARCHY_CODE , MH.DIMENSION_ID DIMENSION_ID , MHT.NAME NAME , MHT.USER_SPECIFIED_NAME USER_SPECIFIED_NAME , MH.DEFAULT_HIERARCHY DEFAULT_HIERARCHY , MH.NUMBER_OF_LEVELS NUMBER_OF_LEVELS , DECODE(MH.HIERARCHY_CODE,'CUSTOM',1,2) CUSTOM , MH.STORED_IN_TREE STORED_IN_TREE , MH.IS_SEEDED IS_SEEDED , MH.IS_WTM_HIERARCHY IS_WTM_HIERARCHY , MH.IS_END_DMD_HIERARCHY IS_END_DMD_HIERARCHY , MH.LAST_REFRESH_NUMBER LAST_REFRESH_NUMBER , MH.CREATED_BY CREATED_BY , MH.CREATION_DATE CREATION_DATE , MH.LAST_UPDATED_BY LAST_UPDATED_BY , MH.LAST_UPDATE_DATE LAST_UPDATE_DATE , MH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , MH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM MSC_HIERARCHIES_B MH, MSC_HIERARCHIES_TL MHT WHERE MHT.HIERARCHY_ID = MH.HIERARCHY_ID AND MHT.LANGUAGE = USERENV('LANG') )