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_LPN_CONTENTS

Object Details

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

Used to store all of the information related to the contents of a container

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_LPN_CONTENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LPN_CONTENT_ID
WMS_LPN_CONTENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_LPN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LPN_CONTENT_ID	NUMBER		Yes	Unique Identifier for the each row
PARENT_LPN_ID	NUMBER		Yes	LPN Identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Item that is added to the parent container ( Parent LPN). Not required in case of one time item
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description ( in case of one time item )
REVISION	VARCHAR2	(3)		Revision of the item, if it is under revision control
LOT_NUMBER	VARCHAR2	(80)		The lot number if item under lot control
SERIAL_NUMBER	VARCHAR2	(30)		The serial number if item under serial control
QUANTITY	NUMBER			Quantity of the content item ( inventory item) added or removed.
UOM_CODE	VARCHAR2	(3)		Unit of measurement code
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
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
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
COST_GROUP_ID	NUMBER			Cost group Identifier of the container content item
SOURCE_TYPE_ID	NUMBER			Source Type ID of pack transaction
SOURCE_HEADER_ID	NUMBER			Source Header ID of pack transaction
SOURCE_LINE_ID	NUMBER			Source Line ID of pack transaction
SOURCE_LINE_DETAIL_ID	NUMBER			Source Line Detail ID of pack transaction
SOURCE_NAME	VARCHAR2	(30)		Source Name of pack transaction
TXN_ERROR_FLAG	VARCHAR2	(1)		Error flag used to indicate an error occurred in subsequent transaction related to this lpn
SERIAL_SUMMARY_ENTRY	NUMBER			Serial summary entry flag signifying yes or no if it is a serial summary entry
SECONDARY_QUANTITY	NUMBER			Quantity in Secondary UOM
SECONDARY_UOM_CODE	VARCHAR2	(3)		Secondary UOM Code
PRIMARY_QUANTITY	NUMBER			Quantity in primary UOM

Query Text

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


SELECT LPN_CONTENT_ID
,      PARENT_LPN_ID
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      REVISION
,      LOT_NUMBER
,      SERIAL_NUMBER
,      QUANTITY
,      UOM_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORGANIZATION_ID
,      COST_GROUP_ID
,      SOURCE_TYPE_ID
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      SOURCE_LINE_DETAIL_ID
,      SOURCE_NAME
,      TXN_ERROR_FLAG
,      SERIAL_SUMMARY_ENTRY
,      SECONDARY_QUANTITY
,      SECONDARY_UOM_CODE
,      PRIMARY_QUANTITY
FROM WMS.WMS_LPN_CONTENTS;

Dependencies

[top of page]

WMS.WMS_LPN_CONTENTS does not reference any database object

WMS.WMS_LPN_CONTENTS is referenced by following:

WMS: WMS_LPN_CONTENTS#