MSC_LEVEL_MEMBERS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
HIERARCHY_ID LEVEL_ID LEVEL_NAME LEVEL_MEMBER_ID PARENT_LEVEL_ID PARENT_LEVEL_MEMBER_ID ROOT_MEMBER_ID LEVEL_NUMBER IS_LEAF_LEVEL LAST_REFRESH_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT MLM.HIERARCHY_ID HIERARCHY_ID , MLM.LEVEL_ID LEVEL_ID , MLV.LEVEL_NAME LEVEL_NAME , MLM.LEVEL_MEMBER_ID LEVEL_MEMBER_ID , MLM.PARENT_LEVEL_ID PARENT_LEVEL_ID , MLM.PARENT_LEVEL_MEMBER_ID PARENT_LEVEL_MEMBER_ID, MLM.ROOT_MEMBER_ID ROOT_MEMBER_ID , MLM.LEVEL_NUMBER LEVEL_NUMBER , MLM.IS_LEAF_LEVEL IS_LEAF_LEVEL , MLM.LAST_REFRESH_NUMBER LAST_REFRESH_NUMBER , MLM.CREATED_BY CREATED_BY , MLM.CREATION_DATE CREATION_DATE , MLM.LAST_UPDATED_BY LAST_UPDATED_BY , MLM.LAST_UPDATE_DATE LAST_UPDATE_DATE , MLM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM MSC_LEVEL_MEMBERS MLM, MSC_LEVELS_V MLV WHERE MLV.LEVEL_ID = MLM.LEVEL_ID