INV — Inventory
272 documented tables · 469 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
MTL_PARAMETERS |
Inventory control options and defaults | hub-leaning |
MTL_SYSTEM_ITEMS_B |
Inventory item definitions | hub-leaning |
MTL_SECONDARY_INVENTORIES |
Subinventory definitions | hub-leaning |
MTL_CATEGORIES_B |
Code combinations table for Item Category | hub |
MTL_ITEM_LOCATIONS |
Definitions for stock locators | hub-leaning |
MTL_MATERIAL_STATUSES_B |
Base table for inventory status definitions - Used by WMS only | hub |
MTL_ATP_RULES |
ATP computation rules | hub-leaning |
MTL_PICKING_RULES |
Picking Rule Definitions | hub-leaning |
MTL_ITEM_CATALOG_GROUPS_B |
Item Catalog Groups | hub |
MTL_MATERIAL_TRANSACTIONS |
Material transaction table | hub |
MTL_CATEGORY_SETS_B |
Category Sets | hub |
MTL_ITEM_REVISIONS_B |
Item revisions | hub |
MTL_SERIAL_NUMBERS |
Serial number definitions | hub |
MTL_TXN_SOURCE_TYPES |
Valid transaction source types | hub |
MTL_ABC_ASSIGNMENT_GROUPS |
Defines abc groups | hub |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
INV_TRX_UTIL_PUB |
PUB | 9 | 88 packages |
INV_QUANTITY_TREE_PUB |
PUB | 6 | 71 packages |
INV_MATERIAL_STATUS_GRP |
GRP | 20 | 59 packages |
INV_MOVE_ORDER_PUB |
PUB | 7 | 57 packages |
INV_LE_TIMEZONE_PUB |
PUB | 8 | 55 packages |
INV_RESERVATION_PUB |
PUB | 10 | 55 packages |
INV_DECIMALS_PUB |
PUB | 7 | 42 packages |
INV_SERIAL_NUMBER_PUB |
PUB | 27 | 33 packages |
INV_LOT_API_PUB |
PUB | 26 | 27 packages |
INV_LPN_TRX_PUB |
PUB | 3 | 25 packages |