MSC_SNAPSHOT_LEVEL_MEMBERS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PK1_VALUE PK2_VALUE ANCESTOR_PK1_VALUE ANCESTOR_PK2_VALUE HIERARCHY_ID LAST_REFRESH_NUMBER ENTERPRISE_ID

Query

SQL_Statement
SELECT mlm.LEVEL_MEMBER_ID AS PK1_VALUE, mlm.LEVEL_ID AS PK2_VALUE, mlm.PARENT_LEVEL_MEMBER_ID AS ANCESTOR_PK1_VALUE, mlm.PARENT_LEVEL_ID AS ANCESTOR_PK2_VALUE, mlm.HIERARCHY_ID AS HIERARCHY_ID, mlm.LAST_REFRESH_NUMBER AS LAST_REFRESH_NUMBER, NVL(SYS_CONTEXT('FND_VPD_CTX', 'ENTERPRISE_ID'), 1) AS ENTERPRISE_ID FROM FUSION.msc_level_members mlm