MSC_HIERARCHIES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
HIERARCHY_ID HIERARCHY_CODE HIERARCHY_NAME DIMENSION_ID DIMENSION_CODE DIMENSION_NAME NUMBER_OF_LEVELS DEFAULT_HIERARCHY CUSTOM STORED_IN_TREE IS_SEEDED HIERARCHY_TYPE 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 , HIERARCHY_NAME AS HIERARCHY_NAME , DIMENSION_ID AS DIMENSION_ID , DIMENSION_CODE AS DIMENSION_CODE , DIMENSION_NAME AS DIMENSION_NAME , NUMBER_OF_LEVELS AS NUMBER_OF_LEVELS , DEFAULT_HIERARCHY AS DEFAULT_HIERARCHY , CUSTOM AS CUSTOM , STORED_IN_TREE AS STORED_IN_TREE , IS_SEEDED AS IS_SEEDED , HIERARCHY_TYPE AS HIERARCHY_TYPE , 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 , NVL(MHT.USER_SPECIFIED_NAME, MHT.NAME) HIERARCHY_NAME , DIM.DIMENSION_ID DIMENSION_ID , DIM.DIMENSION_CODE DIMENSION_CODE , NVL(DIM.USER_SPECIFIED_NAME, DIM.NAME) DIMENSION_NAME , MH.NUMBER_OF_LEVELS NUMBER_OF_LEVELS , MH.DEFAULT_HIERARCHY DEFAULT_HIERARCHY , DECODE(MH.HIERARCHY_CODE,'CUSTOM',1,2) CUSTOM , MH.STORED_IN_TREE STORED_IN_TREE , MH.IS_SEEDED IS_SEEDED , DECODE(MH.IS_SEEDED,1,'Custom Hierarchy', 2,'Seeded Hierarchy', 3,'Dynamic Hierarchy', 4,'Fictive Hierarchy', IS_SEEDED) HIERARCHY_TYPE , 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, MSC_DIMENSIONS_VL DIM WHERE MH.DIMENSION_ID = DIM.DIMENSION_ID AND MHT.HIERARCHY_ID = MH.HIERARCHY_ID AND MHT.LANGUAGE = USERENV('LANG') )