MSC_DIM_CTO_BASE_INV_ITEM_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID NAME REFRESH_NUMBER |
問合せ
| SQL_Statement |
|---|
|
SELECT DISTINCT BOM.ROOT_INV_ITEM_ID ID , ITEM.ITEM_NAME NAME , BOM.REFRESH_NUMBER REFRESH_NUMBER FROM MSC_DP_CTO_BOM_COMP BOM, MSC_SYSTEM_ITEMS ITEM WHERE ITEM.PLAN_ID = -1 AND BOM.ROOT_INV_ITEM_ID = ITEM.INVENTORY_ITEM_ID AND BOM.ORGANIZATION_ID = ITEM.ORGANIZATION_ID |