OA_INV Critical Tables

MTL_SYSTEM_ITEMS

Inventory master file (in version 11.03 only)

MTL_SYSTEM_ITEMS_B

Inventory master file (in version 11i or later only)

MTL_SO_RMA_INTERFACE

Order interface table

MTL_ITEM_SUB_INVENTORY

Stores subinventory information

MTL_SERIAL_NUMBERS

Stores definition and current status of all serial numbers associated with inventory items

MTL_ITEM_REVISIONS

Stores revision levels for an inventory item

MTL_LOT_NUMBERS

Stores definition and expiration date of all lot numbers in inventory

MTL_MATERIAL_TRANSACTIONS

Stores history of inventory transactions

MTL_MATERIAL_TRANSACTIONS_TEMP

Temporary processing holding place for item transactions

MTL_TRANSACTION_ACCOUNTS

Store accounting information about mtl transactions

MTL_CYCLE_COUNT_HEADERS

Cycle count general information

MTL_CYCLE_COUNT_ITEMS

Actual inventory items to be counted

MTL_CC_SCHEDULE_REQUESTS

Which items will show up on cc report

MTL_CYCLE_COUNT_ENTRIES

Actual counts

MTL_CC_SCHED_COUNT_XREFS

Cross reference for many to one

MTL_DEMAND

Stores demand and reservation information