Oracle Fusion/Supply Chain/Inventory

EGP_SYSTEM_ITEMS_B

Item master — one row per item per organization, with attributes like item type, status, and UOM.

Key Columns

INVENTORY_ITEM_IDORGANIZATION_IDSEGMENT1ITEM_TYPE

Child Tables

MTL_ONHAND_QUANTITIES_DETAIL

Current on-hand quantity for an item by subinventory/locator.

Common Joins

MTL_ONHAND_QUANTITIES_DETAILvia INVENTORY_ITEM_ID + ORGANIZATION_ID

Current on-hand quantity for this item in this organization, by subinventory/locator.

MTL_ITEM_CATEGORIESvia INVENTORY_ITEM_ID + ORGANIZATION_ID

The category assignment(s) for this item.

Used In

InventoryOrder ManagementPurchasingCostingManufacturing

Notes

Replaced MTL_SYSTEM_ITEMS_B as the item master under Oracle's Product Information Management (PIM) architecture — older references and some legacy reports may still cite MTL_SYSTEM_ITEMS_B.

Item and on-hand data model

EGP_SYSTEM_ITEMS_B is the item master (per item per org). MTL_ONHAND_QUANTITIES_DETAIL is the current snapshot of quantity by subinventory; MTL_MATERIAL_TRANSACTIONS is the full historical log of everything that moved that quantity.