Table: MTL_SERIAL_NUMBERS

Product:	INV - Inventory
Description:	Serial number definitions
Implementation/DBA Data:	INV.MTL_SERIAL_NUMBERS

Primary Key: MTL_SERIAL_NUMBERS_PK

1. SERIAL_NUMBER
2. INVENTORY_ITEM_ID
3. CURRENT_ORGANIZATION_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
MTL_SERIAL_NUMBERS		WMS_LICENSE_PLATE_NUMBERS	MTL_SERIAL_NUMBERS.LPN_ID
MTL_SERIAL_NUMBERS		MTL_PARAMETERS	MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID
MTL_SERIAL_NUMBERS		MTL_LOT_NUMBERS	MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID MTL_SERIAL_NUMBERS.LOT_NUMBER
MTL_SERIAL_NUMBERS		AP_SUPPLIERS	MTL_SERIAL_NUMBERS.ORIGINAL_UNIT_VENDOR_ID
MTL_SERIAL_NUMBERS		PJM_UNIT_NUMBERS	MTL_SERIAL_NUMBERS.END_ITEM_UNIT_NUMBER
MTL_SERIAL_NUMBERS		MTL_MATERIAL_STATUSES_B	MTL_SERIAL_NUMBERS.STATUS_ID
MTL_SERIAL_NUMBERS		MTL_ITEM_LOCATIONS	MTL_SERIAL_NUMBERS.CURRENT_LOCATOR_ID MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID
MTL_SERIAL_NUMBERS		MTL_ITEM_REVISIONS_B	MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID MTL_SERIAL_NUMBERS.REVISION
MTL_SERIAL_NUMBERS		MTL_SECONDARY_INVENTORIES	MTL_SERIAL_NUMBERS.CURRENT_SUBINVENTORY_CODE MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID
MTL_SERIAL_NUMBERS		MTL_SYSTEM_ITEMS_B	MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID
MTL_SERIAL_NUMBERS		MTL_SERIAL_NUMBERS	MTL_SERIAL_NUMBERS.PARENT_SERIAL_NUMBER MTL_SERIAL_NUMBERS.PARENT_ITEM_ID MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID
MTL_SERIAL_NUMBERS		WIP_ENTITIES	MTL_SERIAL_NUMBERS.ORIGINAL_WIP_ENTITY_ID
MTL_SERIAL_NUMBERS		MTL_TXN_SOURCE_TYPES	MTL_SERIAL_NUMBERS.LAST_TXN_SOURCE_TYPE_ID
MTL_SERIAL_NUMBERS		MTL_MATERIAL_TRANSACTIONS	MTL_SERIAL_NUMBERS.LAST_TRANSACTION_ID
AHL_WORKORDER_MTL_TXNS		MTL_SERIAL_NUMBERS	AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID
CSI_ITEM_INSTANCES		MTL_SERIAL_NUMBERS	CSI_ITEM_INSTANCES.SERIAL_NUMBER CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID
CSP_PACKLIST_SERIAL_LOTS		MTL_SERIAL_NUMBERS	CSP_PACKLIST_SERIAL_LOTS.SERIAL_NUMBER CSP_PACKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID CSP_PACKLIST_SERIAL_LOTS.ORGANIZATION_ID
CSP_PICKLIST_SERIAL_LOTS		MTL_SERIAL_NUMBERS	CSP_PICKLIST_SERIAL_LOTS.SERIAL_NUMBER CSP_PICKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID CSP_PICKLIST_SERIAL_LOTS.ORGANIZATION_ID
CST_EAM_ASSET_PER_BALANCES		MTL_SERIAL_NUMBERS	CST_EAM_ASSET_PER_BALANCES.SERIAL_NUMBER CST_EAM_ASSET_PER_BALANCES.INVENTORY_ITEM_ID CST_EAM_ASSET_PER_BALANCES.ORGANIZATION_ID
EAM_ASSET_METERS		MTL_SERIAL_NUMBERS	EAM_ASSET_METERS.ASSET_NUMBER EAM_ASSET_METERS.ASSET_GROUP_ID EAM_ASSET_METERS.ORGANIZATION_ID
EAM_ASSET_STATUS_HISTORY		MTL_SERIAL_NUMBERS	EAM_ASSET_STATUS_HISTORY.ASSET_NUMBER EAM_ASSET_STATUS_HISTORY.ASSET_GROUP_ID EAM_ASSET_STATUS_HISTORY.ORGANIZATION_ID
EAM_JOB_COMPLETION_TXNS		MTL_SERIAL_NUMBERS	EAM_JOB_COMPLETION_TXNS.ASSET_NUMBER EAM_JOB_COMPLETION_TXNS.ASSET_GROUP_ID EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID
EAM_OP_COMPLETION_TXNS		MTL_SERIAL_NUMBERS	EAM_OP_COMPLETION_TXNS.ASSET_NUMBER EAM_OP_COMPLETION_TXNS.ASSET_GROUP_ID EAM_OP_COMPLETION_TXNS.ORGANIZATION_ID
MTL_EAM_ASSET_ACTIVITIES		MTL_SERIAL_NUMBERS	MTL_EAM_ASSET_ACTIVITIES.SERIAL_NUMBER MTL_EAM_ASSET_ACTIVITIES.INVENTORY_ITEM_ID MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID
MTL_EAM_ASSET_ATTR_VALUES		MTL_SERIAL_NUMBERS	MTL_EAM_ASSET_ATTR_VALUES.SERIAL_NUMBER MTL_EAM_ASSET_ATTR_VALUES.INVENTORY_ITEM_ID MTL_EAM_ASSET_ATTR_VALUES.ORGANIZATION_ID
MTL_EAM_NETWORK_ASSETS		MTL_SERIAL_NUMBERS	MTL_EAM_NETWORK_ASSETS.NETWORK_SERIAL_NUMBER MTL_EAM_NETWORK_ASSETS.NETWORK_ITEM_ID MTL_EAM_NETWORK_ASSETS.ORGANIZATION_ID
MTL_EAM_NETWORK_ASSETS		MTL_SERIAL_NUMBERS	MTL_EAM_NETWORK_ASSETS.SERIAL_NUMBER MTL_EAM_NETWORK_ASSETS.INVENTORY_ITEM_ID MTL_EAM_NETWORK_ASSETS.ORGANIZATION_ID
MTL_MATERIAL_STATUS_HISTORY		MTL_SERIAL_NUMBERS	MTL_MATERIAL_STATUS_HISTORY.SERIAL_NUMBER MTL_MATERIAL_STATUS_HISTORY.INVENTORY_ITEM_ID MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID
MTL_PHYSICAL_ADJUSTMENTS		MTL_SERIAL_NUMBERS	MTL_PHYSICAL_ADJUSTMENTS.SERIAL_NUMBER MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID
MTL_PHYSICAL_INVENTORY_TAGS		MTL_SERIAL_NUMBERS	MTL_PHYSICAL_INVENTORY_TAGS.SERIAL_NUM MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID
MTL_PHYSICAL_INVENTORY_TAGS		MTL_SERIAL_NUMBERS	MTL_PHYSICAL_INVENTORY_TAGS.SERIAL_NUM MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID
MTL_SERIAL_NUMBERS		MTL_SERIAL_NUMBERS	MTL_SERIAL_NUMBERS.PARENT_SERIAL_NUMBER MTL_SERIAL_NUMBERS.PARENT_ITEM_ID MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID
MTL_TXN_REQUEST_LINES		MTL_SERIAL_NUMBERS	MTL_TXN_REQUEST_LINES.SERIAL_NUMBER_START MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID MTL_TXN_REQUEST_LINES.ORGANIZATION_ID
MTL_TXN_REQUEST_LINES		MTL_SERIAL_NUMBERS	MTL_TXN_REQUEST_LINES.SERIAL_NUMBER_END MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID MTL_TXN_REQUEST_LINES.ORGANIZATION_ID
MTL_UNIT_TRANSACTIONS		MTL_SERIAL_NUMBERS	MTL_UNIT_TRANSACTIONS.SERIAL_NUMBER MTL_UNIT_TRANSACTIONS.INVENTORY_ITEM_ID MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID
PJM_UNIT_SERIAL_HISTORY		MTL_SERIAL_NUMBERS	PJM_UNIT_SERIAL_HISTORY.SERIAL_NUMBER PJM_UNIT_SERIAL_HISTORY.INVENTORY_ITEM_ID PJM_UNIT_SERIAL_HISTORY.ORGANIZATION_ID
WIP_EAM_WORK_REQUESTS		MTL_SERIAL_NUMBERS	WIP_EAM_WORK_REQUESTS.ASSET_NUMBER WIP_EAM_WORK_REQUESTS.ASSET_GROUP WIP_EAM_WORK_REQUESTS.ORGANIZATION_ID
WMS_DISPATCHED_TASKS_ARCH		MTL_SERIAL_NUMBERS	WMS_DISPATCHED_TASKS_ARCH.EQUIPMENT_INSTANCE WMS_DISPATCHED_TASKS_ARCH.EQUIPMENT_ID WMS_DISPATCHED_TASKS_ARCH.ORGANIZATION_ID
WMS_DISPATCHED_TASKS		MTL_SERIAL_NUMBERS	WMS_DISPATCHED_TASKS.EQUIPMENT_INSTANCE WMS_DISPATCHED_TASKS.EQUIPMENT_ID WMS_DISPATCHED_TASKS.ORGANIZATION_ID
WMS_DISPATCHED_TASKS_HISTORY		MTL_SERIAL_NUMBERS	WMS_DISPATCHED_TASKS_HISTORY.EQUIPMENT_INSTANCE WMS_DISPATCHED_TASKS_HISTORY.EQUIPMENT_ID WMS_DISPATCHED_TASKS_HISTORY.ORGANIZATION_ID
WMS_LICENSE_PLATE_NUMBERS		MTL_SERIAL_NUMBERS	WMS_LICENSE_PLATE_NUMBERS.SERIAL_NUMBER WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
WMS_LPN_HISTORIES		MTL_SERIAL_NUMBERS	WMS_LPN_HISTORIES.SERIAL_NUMBER WMS_LPN_HISTORIES.INVENTORY_ITEM_ID WMS_LPN_HISTORIES.ORGANIZATION_ID
WMS_LPN_INTERFACE		MTL_SERIAL_NUMBERS	WMS_LPN_INTERFACE.SERIAL_NUMBER WMS_LPN_INTERFACE.INVENTORY_ITEM_ID WMS_LPN_INTERFACE.ORGANIZATION_ID