MSC_DIM_CTO_OPTION_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.COMPONENT_TYPE = 3 AND cto.INVENTORY_ITEM_ID = items.INVENTORY_ITEM_ID |