Oracle Fusion/Supply Chain/Inventory

MTL_ITEM_LOCATIONS

Locator definition — a specific row/rack/bin (or other physical subdivision) within a subinventory, used where locator control tracks inventory at that granularity.

Key Columns

LOCATOR_IDSUBINVENTORY_CODEORGANIZATION_IDSEGMENT1

Parent Table

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.

Common Joins

MTL_SECONDARY_INVENTORIESvia SUBINVENTORY_CODE + ORGANIZATION_ID

The subinventory this locator belongs to.

MTL_ONHAND_QUANTITIES_DETAILvia LOCATOR_ID

On-hand quantity currently sitting at this specific locator.

Used In

InventoryShipping

Notes

Only populated where locator control is enabled for the subinventory/organization — many orgs run subinventory-level tracking only.

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.