1. Tables and Views for SCM
  2. MSC_DIM_CSTM_LEVEL_DATA_V

MSC_DIM_CSTM_LEVEL_DATA_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

DIMENSION_ID

HIERARCHY_ID

LEVEL_ID

ID

NAME

PARENT_ID

REFRESH_NUMBER

Query

SQL_Statement

SELECT DISTINCT

DIMENSION_ID,

HIERARCHY_ID,

LEVEL_ID,

ID ID ,

NAME NAME ,

PARENT_ID PARENT_ID ,

-1 REFRESH_NUMBER

FROM MSC_DIM_CSTMHRCHY_LLMD