1. Tables and Views for SCM
  2. MSC_DIM_CSTMHYR_ITEM_V

MSC_DIM_CSTMHYR_ITEM_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ID

NAME

DESCRIPTION

PARENT_ID

Query

SQL_Statement

SELECT SHTL.ID ID,

SHTL.NAME NAME,

IT.DESCRIPTION DESCRIPTION,

LLMD.ID PARENT_ID

FROM MSC_DIM_CSTMHRCHY_LLMD LLMD, MSC_DIM_CSTMHRCHY_SHTL SHTL, MSC_ITEMS IT

where

LLMD.hierarchy_id = SHTL.hierarchy_id

and SHTL.level_id = 1

and LLMD.LEVEL_ID = SHTL.PARENT_LEVEL_ID

and LLMD.ID = SHTL.PARENT_ID

AND SHTL.ID = IT.INVENTORY_ITEM_ID