← All tables
Oracle Fusion/Supply Chain/Inventory
MTL_ITEM_CATEGORIES
Item ↔ category assignments — which category an item falls into within each category set.
Key Columns
INVENTORY_ITEM_IDORGANIZATION_IDCATEGORY_SET_IDCATEGORY_ID
Common Joins
MTL_CATEGORIES_Bvia CATEGORY_IDThe category definition.
MTL_CATEGORY_SETS_Bvia CATEGORY_SET_IDThe category set (e.g. Purchasing, Inventory, Planning).
Used In
InventoryPurchasingCost Management