1. Tables and Views for SCM
  2. MSC_DIM_CSTMHYR_RESOURCE_V

MSC_DIM_CSTMHYR_RESOURCE_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ID

NAME

PARENT_ID

REFRESH_NUMBER

Query

SQL_Statement

SELECT SHTL.ID ID,

SHTL.NAME NAME,

LLMD.ID PARENT_ID,

-1 REFRESH_NUMBER

FROM MSC_DIM_CSTMHRCHY_LLMD LLMD,

MSC_DIM_CSTMHRCHY_SHTL SHTL

where

LLMD.hierarchy_id = SHTL.hierarchy_id

and SHTL.level_id = 48

and LLMD.LEVEL_ID = SHTL.PARENT_LEVEL_ID

and LLMD.ID = SHTL.PARENT_ID