1. Tables and Views for SCM
  2. MSC_DIM_CTO_OPTION_CLASS_V

MSC_DIM_CTO_OPTION_CLASS_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 FUSION.MSC_DP_CTO_BOM_COMP cto, MSC_ITEMS items

WHERE COMPONENT_TYPE = 2

and cto.INVENTORY_ITEM_ID = items.INVENTORY_ITEM_ID