[Home] [Help]
View: MSC_PRODUCT_FAMILIES_TREE_V
View Text
SELECT PLAN_ID
, SR_INSTANCE_ID
, INVENTORY_ITEM_ID
, ITEM_NAME
, DESCRIPTION
, ORGANIZATION_ID
, ORGANIZATION_CODE
FROM MSC_SYSTEM_ITEMS
WHERE BOM_ITEM_TYPE IN (1
, 2
, 5)
Columns
Name |
PLAN_ID |
SR_INSTANCE_ID |
PRODUCT_FAMILY_ID |
PF_NUMBER |
PF_DESCRIPTION |
ORGANIZATION_ID |
ORGANIZATION_CODE |