MSC_DIM_CSTMHYR_ITEM_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID NAME DESCRIPTION PARENT_ID |
問合せ
| 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 |