MSC_DIM_CTO_BASE_MOD_ITEM_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME INVENTORY_ITEM_ID

Query

SQL_Statement
SELECT DISTINCT cto.ITEM_BOM_COMP_ID ID, items.ITEM_NAME NAME, cto.INVENTORY_ITEM_ID INVENTORY_ITEM_ID FROM MSC_DP_CTO_BOM_COMP cto , MSC_ITEMS items WHERE cto.DEPTH = 1 AND cto.PARENT_ITEM_BOM_COMP_ID IS NULL AND cto.INVENTORY_ITEM_ID = items.INVENTORY_ITEM_ID