eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: WMS_LICENSE_PLATE_NUMBERS

Product:	WMS - Warehouse Management
Description:	Used to store the information related to a container instance (LPN)
Implementation/DBA Data:	WMS.WMS_LICENSE_PLATE_NUMBERS

Primary Key: WMS_LICENSE_PLATE_NUMBERS_PK

LPN_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
WMS_LICENSE_PLATE_NUMBERS	MTL_PARAMETERS	WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
WMS_LICENSE_PLATE_NUMBERS	MTL_ITEM_LOCATIONS	WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
WMS_LICENSE_PLATE_NUMBERS	MTL_ITEM_REVISIONS_B	WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID WMS_LICENSE_PLATE_NUMBERS.REVISION
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_LICENSE_PLATE_NUMBERS	MTL_SECONDARY_INVENTORIES	WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
WMS_LICENSE_PLATE_NUMBERS	MTL_SYSTEM_ITEMS_B	WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID WMS_LICENSE_PLATE_NUMBERS.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
MTL_CYCLE_COUNT_ENTRIES	WMS_LICENSE_PLATE_NUMBERS	MTL_CYCLE_COUNT_ENTRIES.PARENT_LPN_ID
MTL_CYCLE_COUNT_ENTRIES	WMS_LICENSE_PLATE_NUMBERS	MTL_CYCLE_COUNT_ENTRIES.OUTERMOST_LPN_ID
MTL_PHYSICAL_ADJUSTMENTS	WMS_LICENSE_PLATE_NUMBERS	MTL_PHYSICAL_ADJUSTMENTS.OUTERMOST_LPN_ID
MTL_PHYSICAL_ADJUSTMENTS	WMS_LICENSE_PLATE_NUMBERS	MTL_PHYSICAL_ADJUSTMENTS.PARENT_LPN_ID
MTL_PHYSICAL_INVENTORY_TAGS	WMS_LICENSE_PLATE_NUMBERS	MTL_PHYSICAL_INVENTORY_TAGS.PARENT_LPN_ID
MTL_PHYSICAL_INVENTORY_TAGS	WMS_LICENSE_PLATE_NUMBERS	MTL_PHYSICAL_INVENTORY_TAGS.OUTERMOST_LPN_ID
MTL_SERIAL_NUMBERS	WMS_LICENSE_PLATE_NUMBERS	MTL_SERIAL_NUMBERS.LPN_ID
WMS_LPN_CONTENTS	WMS_LICENSE_PLATE_NUMBERS	WMS_LPN_CONTENTS.PARENT_LPN_ID
WMS_LPN_HISTORIES	WMS_LICENSE_PLATE_NUMBERS	WMS_LPN_HISTORIES.PARENT_LPN_ID
WMS_LPN_HISTORIES	WMS_LICENSE_PLATE_NUMBERS	WMS_LPN_HISTORIES.LPN_ID
WMS_LPN_HISTORIES	WMS_LICENSE_PLATE_NUMBERS	WMS_LPN_HISTORIES.OUTERMOST_LPN_ID
WMS_LPN_PROCESS_TEMP	WMS_LICENSE_PLATE_NUMBERS	WMS_LPN_PROCESS_TEMP.LPN_ID
WMS_SHIPPING_TRANSACTION_TEMP	WMS_LICENSE_PLATE_NUMBERS	WMS_SHIPPING_TRANSACTION_TEMP.PARENT_LPN_ID
WMS_SHIPPING_TRANSACTION_TEMP	WMS_LICENSE_PLATE_NUMBERS	WMS_SHIPPING_TRANSACTION_TEMP.OUTERMOST_LPN_ID