MSC_SNAPSHOT_LEVEL_MEMBERS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PK1_VALUE PK2_VALUE ANCESTOR_PK1_VALUE ANCESTOR_PK2_VALUE HIERARCHY_ID LAST_REFRESH_NUMBER ENTERPRISE_ID |
問合せ
| 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 |