Skip to main content
OracleOps AI
← All tables
Oracle EBS/Supply Chain/Inventory

MTL_SYSTEM_ITEMS_B

Item master (EBS) — one row per item per inventory organization, with primary UOM, item type and control flags.

Key Columns

INVENTORY_ITEM_IDORGANIZATION_IDSEGMENT1DESCRIPTIONPRIMARY_UOM_CODEITEM_TYPEINVENTORY_ITEM_STATUS_CODE

Common Joins

MTL_ITEM_CATEGORIESvia INVENTORY_ITEM_ID + ORGANIZATION_ID

The category the item is assigned to in each category set.

MTL_MATERIAL_TRANSACTIONSvia INVENTORY_ITEM_ID + ORGANIZATION_ID

Stock movements for the item.

Used In

InventoryPurchasingOrder ManagementManufacturing

Notes

SEGMENT1 is normally the item number. The Fusion equivalent is EGP_SYSTEM_ITEMS_B.

Ask Oracle AI about MTL_SYSTEM_ITEMS_B