1. Tables and Views for SCM
  2. MSC_DIM_CTO_PARENT_INV_ITEM_V

MSC_DIM_CTO_PARENT_INV_ITEM_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ID

NAME

REFRESH_NUMBER

Query

SQL_Statement

SELECT DISTINCT

BOM.PARENT_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.PARENT_INV_ITEM_ID = ITEM.INVENTORY_ITEM_ID

AND BOM.ORGANIZATION_ID = ITEM.ORGANIZATION_ID