Table: MTL_LOT_NUMBERS

Product:	INV - Inventory
Description:	Lot number definitions
Implementation/DBA Data:	INV.MTL_LOT_NUMBERS

Primary Key: MTL_LOT_NUMBER_PK

1. INVENTORY_ITEM_ID
2. ORGANIZATION_ID
3. LOT_NUMBER

Foreign Keys

Table		Foreign Table	Foreign Key Column
MTL_LOT_NUMBERS		MTL_SYSTEM_ITEMS_B	MTL_LOT_NUMBERS.INVENTORY_ITEM_ID MTL_LOT_NUMBERS.ORGANIZATION_ID
MTL_LOT_NUMBERS		MTL_PARAMETERS	MTL_LOT_NUMBERS.ORGANIZATION_ID
MTL_LOT_NUMBERS		MTL_MATERIAL_STATUSES_B	MTL_LOT_NUMBERS.STATUS_ID
AHL_WORKORDER_MTL_TXNS		MTL_LOT_NUMBERS	AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID AHL_WORKORDER_MTL_TXNS.LOT_NUMBER
CSI_ITEM_INSTANCES		MTL_LOT_NUMBERS	CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID CSI_ITEM_INSTANCES.LOT_NUMBER
CSP_PACKLIST_SERIAL_LOTS		MTL_LOT_NUMBERS	CSP_PACKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID CSP_PACKLIST_SERIAL_LOTS.ORGANIZATION_ID CSP_PACKLIST_SERIAL_LOTS.LOT_NUMBER
CSP_PICKLIST_SERIAL_LOTS		MTL_LOT_NUMBERS	CSP_PICKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID CSP_PICKLIST_SERIAL_LOTS.ORGANIZATION_ID CSP_PICKLIST_SERIAL_LOTS.LOT_NUMBER
MRP_INVENTORY_LOTS		MTL_LOT_NUMBERS	MRP_INVENTORY_LOTS.INVENTORY_ITEM_ID MRP_INVENTORY_LOTS.ORGANIZATION_ID MRP_INVENTORY_LOTS.INVENTORY_LOT_NUMBER
MTL_CC_ENTRIES_INTERFACE		MTL_LOT_NUMBERS	MTL_CC_ENTRIES_INTERFACE.INVENTORY_ITEM_ID MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID MTL_CC_ENTRIES_INTERFACE.LOT_NUMBER
MTL_CYCLE_COUNT_ENTRIES		MTL_LOT_NUMBERS	MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID MTL_CYCLE_COUNT_ENTRIES.LOT_NUMBER
MTL_DEMAND		MTL_LOT_NUMBERS	MTL_DEMAND.INVENTORY_ITEM_ID MTL_DEMAND.ORGANIZATION_ID MTL_DEMAND.LOT_NUMBER
MTL_DEMAND_INTERFACE		MTL_LOT_NUMBERS	MTL_DEMAND_INTERFACE.INVENTORY_ITEM_ID MTL_DEMAND_INTERFACE.ORGANIZATION_ID MTL_DEMAND_INTERFACE.LOT_NUMBER
MTL_MATERIAL_STATUS_HISTORY		MTL_LOT_NUMBERS	MTL_MATERIAL_STATUS_HISTORY.INVENTORY_ITEM_ID MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID MTL_MATERIAL_STATUS_HISTORY.LOT_NUMBER
MTL_ONHAND_QUANTITIES		MTL_LOT_NUMBERS	MTL_ONHAND_QUANTITIES.INVENTORY_ITEM_ID MTL_ONHAND_QUANTITIES.ORGANIZATION_ID MTL_ONHAND_QUANTITIES.LOT_NUMBER
MTL_PHYSICAL_ADJUSTMENTS		MTL_LOT_NUMBERS	MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID MTL_PHYSICAL_ADJUSTMENTS.LOT_NUMBER
MTL_PHYSICAL_INVENTORY_TAGS		MTL_LOT_NUMBERS	MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID MTL_PHYSICAL_INVENTORY_TAGS.LOT_NUMBER
MTL_PHYSICAL_INVENTORY_TAGS		MTL_LOT_NUMBERS	MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID MTL_PHYSICAL_INVENTORY_TAGS.LOT_NUMBER
MTL_RESERVATIONS		MTL_LOT_NUMBERS	MTL_RESERVATIONS.INVENTORY_ITEM_ID MTL_RESERVATIONS.ORGANIZATION_ID MTL_RESERVATIONS.LOT_NUMBER
MTL_RESERVATIONS_INTERFACE		MTL_LOT_NUMBERS	MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.LOT_NUMBER
MTL_RESERVATIONS_INTERFACE		MTL_LOT_NUMBERS	MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.TO_LOT_NUMBER
MTL_SERIAL_NUMBERS		MTL_LOT_NUMBERS	MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID MTL_SERIAL_NUMBERS.LOT_NUMBER
MTL_TRANSACTION_LOT_NUMBERS		MTL_LOT_NUMBERS	MTL_TRANSACTION_LOT_NUMBERS.INVENTORY_ITEM_ID MTL_TRANSACTION_LOT_NUMBERS.ORGANIZATION_ID MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER
MTL_TXN_REQUEST_LINES		MTL_LOT_NUMBERS	MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID MTL_TXN_REQUEST_LINES.ORGANIZATION_ID MTL_TXN_REQUEST_LINES.LOT_NUMBER
WMS_EXCEPTIONS		MTL_LOT_NUMBERS	WMS_EXCEPTIONS.INVENTORY_ITEM_ID WMS_EXCEPTIONS.ORGANIZATION_ID WMS_EXCEPTIONS.LOT_NUMBER
WMS_LICENSE_PLATE_NUMBERS		MTL_LOT_NUMBERS	WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID WMS_LICENSE_PLATE_NUMBERS.LOT_NUMBER
WMS_LPN_CONTENTS		MTL_LOT_NUMBERS	WMS_LPN_CONTENTS.INVENTORY_ITEM_ID WMS_LPN_CONTENTS.ORGANIZATION_ID WMS_LPN_CONTENTS.LOT_NUMBER
WMS_LPN_HISTORIES		MTL_LOT_NUMBERS	WMS_LPN_HISTORIES.INVENTORY_ITEM_ID WMS_LPN_HISTORIES.ORGANIZATION_ID WMS_LPN_HISTORIES.LOT_NUMBER
WMS_LPN_INTERFACE		MTL_LOT_NUMBERS	WMS_LPN_INTERFACE.INVENTORY_ITEM_ID WMS_LPN_INTERFACE.ORGANIZATION_ID WMS_LPN_INTERFACE.LOT_NUMBER
WMS_SKIP_TASK_EXCEPTIONS		MTL_LOT_NUMBERS	WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_ITEM_ID WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID WMS_SKIP_TASK_EXCEPTIONS.LOT_NUMBER