← All tables
Oracle Fusion/Supply Chain/Inventory
MTL_SECONDARY_INVENTORIES
Subinventory definition — a named storage area within an inventory organization (e.g. Stores, Staging, Damaged, Finished Goods) that on-hand quantity and transactions are tracked against.
Key Columns
SECONDARY_INVENTORY_NAMEORGANIZATION_IDASSET_INVENTORYLOCATOR_TYPE
Used In
InventoryShippingManufacturing
Related
Warehouse structure: subinventories and locators
A warehouse's physical structure in Fusion Inventory is two levels: subinventories (MTL_SECONDARY_INVENTORIES) are named storage areas within an organization — Stores, Staging, Damaged — and, where locator control is enabled, each subinventory is further divided into locators (MTL_ITEM_LOCATIONS) representing a specific row/rack/bin. On-hand quantity (MTL_ONHAND_QUANTITIES_DETAIL) is tracked at whichever granularity is enabled — subinventory alone, or subinventory plus locator.