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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: WMS.WMS_LICENSE_PLATE_NUMBERS

Object Details

Object Name:	WMS_LICENSE_PLATE_NUMBERS
Object Type:	TABLE
Owner:	WMS
FND Design Data:	WMS.WMS_LICENSE_PLATE_NUMBERS
Subobject Name:
Status:	VALID

Used to store the information related to a container instance (LPN)

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_LICENSE_PLATE_NUMBERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LPN_ID
WMS_LICENSE_PLATE_NUMBERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LICENSE_PLATE_NUMBER
WMS_LICENSE_PLATE_NUMBERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_LPN_ID
WMS_LICENSE_PLATE_NUMBERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OUTERMOST_LPN_ID
WMS_LICENSE_PLATE_NUMBERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID SUBINVENTORY_CODE LOCATOR_ID
WMS_LICENSE_PLATE_NUMBERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_NAME
WMS_LICENSE_PLATE_NUMBERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_HEADER_ID
WMS_LICENSE_PLATE_NUMBERS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LPN_CONTEXT ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LPN_ID	NUMBER		Yes	LPN is a unique identifier for each row in this table.
LICENSE_PLATE_NUMBER	VARCHAR2	(30)	Yes	License Plate Number
INVENTORY_ITEM_ID	NUMBER			Unique id of an inventory item associated with lpn. i.e. Container Item
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REVISION	VARCHAR2	(3)		Revision of the container item, if it is under revision control
LOT_NUMBER	VARCHAR2	(80)		The lot number if container item is under lot control
SERIAL_NUMBER	VARCHAR2	(30)		The serial number if container item is under serial control
ORGANIZATION_ID	NUMBER		Yes	Current Organization identifier
SUBINVENTORY_CODE	VARCHAR2	(10)		Current subinventory code
LOCATOR_ID	NUMBER			Current locator, if container item is under locator control
PARENT_LPN_ID	NUMBER			LPN ID of the container in which the current lpn is in, If the LPN being created already has a parent
GROSS_WEIGHT_UOM_CODE	VARCHAR2	(3)		Unit of Measurement Code of the Weight of the Container body and its contents
GROSS_WEIGHT	NUMBER			Weight of the container body and its contents.
CONTENT_VOLUME_UOM_CODE	VARCHAR2	(3)		Unit of Measurement Code of the container content volume.
CONTENT_VOLUME	NUMBER			Total volume of the container contents
TARE_WEIGHT_UOM_CODE	VARCHAR2	(3)		Unit of measure code for the tare weight of the container
TARE_WEIGHT	NUMBER			Tare weight of the container and its contents
STATUS_ID	NUMBER			Current status of the container instance (LPN)
LPN_STATE	NUMBER
SEALED_STATUS	NUMBER			Sealed Status - ( Sealed Container or Not )
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column
COST_GROUP_ID	NUMBER			Cost Group Identifier
LPN_CONTEXT	NUMBER		Yes	LPN Context
LPN_REUSABILITY	NUMBER			LPN Reusability (1. Permanent, 2. Disposable )
OUTERMOST_LPN_ID	NUMBER			Outermost LPN Id
HOMOGENEOUS_CONTAINER	NUMBER			Flag indicating whether mixed items are allowed within the lpn. default null indicates allowed
SOURCE_TYPE_ID	NUMBER			Source Type of LPN
SOURCE_HEADER_ID	NUMBER			Source Header ID of LPN
SOURCE_LINE_ID	NUMBER			Source Line ID of LPN
SOURCE_LINE_DETAIL_ID	NUMBER			Source Line Detail ID of LPN
SOURCE_NAME	VARCHAR2	(30)		Source Name of LPN
CONTAINER_VOLUME	NUMBER			Container Volume
CONTAINER_VOLUME_UOM	VARCHAR2	(3)		Unit of Measure of Container Volume
CATCH_WEIGHT_FLAG	VARCHAR2	(1)		Catch Weight Flag - 'Y' if Catch Weight entered

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LPN_ID
,      LICENSE_PLATE_NUMBER
,      INVENTORY_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REVISION
,      LOT_NUMBER
,      SERIAL_NUMBER
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      PARENT_LPN_ID
,      GROSS_WEIGHT_UOM_CODE
,      GROSS_WEIGHT
,      CONTENT_VOLUME_UOM_CODE
,      CONTENT_VOLUME
,      TARE_WEIGHT_UOM_CODE
,      TARE_WEIGHT
,      STATUS_ID
,      LPN_STATE
,      SEALED_STATUS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      COST_GROUP_ID
,      LPN_CONTEXT
,      LPN_REUSABILITY
,      OUTERMOST_LPN_ID
,      HOMOGENEOUS_CONTAINER
,      SOURCE_TYPE_ID
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      SOURCE_LINE_DETAIL_ID
,      SOURCE_NAME
,      CONTAINER_VOLUME
,      CONTAINER_VOLUME_UOM
,      CATCH_WEIGHT_FLAG
FROM WMS.WMS_LICENSE_PLATE_NUMBERS;

Dependencies

[top of page]

WMS.WMS_LICENSE_PLATE_NUMBERS does not reference any database object

WMS.WMS_LICENSE_PLATE_NUMBERS is referenced by following:

WMS: WMS_LICENSE_PLATE_NUMBERS#