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]

VIEW: APPS.WMS_LPN_CONTENTS_DETAIL_V

Object Details

Object Name:	WMS_LPN_CONTENTS_DETAIL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WMS.WMS_LPN_CONTENTS_DETAIL_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View of container contents ( includes detail lot and serial controlled items)

[View Source]

Columns

Name	Datatype	Length	Comments
PARENT_LPN_ID	NUMBER		Container LPN Identifier
PARENT_LICENSE_PLATE_NUMBER	VARCHAR2	(30)	License Plate Number of container
LPN_ID	NUMBER		Content LPN Identifier
LICENSE_PLATE_NUMBER	VARCHAR2	(30)	License Plate Number of content LPN
OUTERMOST_LPN_ID	NUMBER		LPN identifier of outermost container in a nested LPN situation
OUTERMOST_LICENSE_PLATE_NUMBER	VARCHAR2	(30)	License Plate Number of outermost nested LPN
ORGANIZATION_ID	NUMBER		Organization Identifier
SUBINVENTORY_CODE	VARCHAR2	(10)	Subinventory code where container is located
LOCATOR_ID	NUMBER		Locator Identifier where container is located
CONTENT_TYPE	NUMBER		Defines if contents is an item (1) or another container (2)
INVENTORY_ITEM_ID	NUMBER		Content item identifier
INVENTORY_ITEM	VARCHAR2	(40)	Content item
ITEM_DESCRIPTION	VARCHAR2	(240)	Content item identifier
REVISION	VARCHAR2	(3)	Revision of content item
LOT_NUMBER	VARCHAR2	(80)	Lot number of content item
SERIAL_NUMBER	VARCHAR2	(30)	Serial number of content item
UNIT_NUMBER	VARCHAR2	(30)	Unit number
SERIAL_STATUS_ID	NUMBER		Serial number status identifier
LPN_STATUS_ID	NUMBER		LPN status identifier
LPN_CONTEXT	NUMBER		Context of LPN
COST_GROUP_ID	NUMBER		Content item cost group identifier
COST_GROUP_NAME	VARCHAR2	(10)	Content item cost group
PRIMARY_UOM_CODE	VARCHAR2	(3)	Primary unit of measure of content item
UOM_CODE	VARCHAR2	(3)	Unit of measure of content item
QUANTITY	NUMBER		Packed quantity of content item
LAST_UPDATE_DATE	DATE		Standard who column
LAST_UPDATED_BY	NUMBER		Standard who column
CREATION_DATE	DATE		Standard who column
CREATED_BY	NUMBER		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
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)	transaction error flag

Query Text

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


SELECT PARENT_LPN_ID
,      PARENT_LICENSE_PLATE_NUMBER
,      LPN_ID
,      LICENSE_PLATE_NUMBER
,      OUTERMOST_LPN_ID
,      OUTERMOST_LICENSE_PLATE_NUMBER
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      CONTENT_TYPE
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM
,      ITEM_DESCRIPTION
,      REVISION
,      LOT_NUMBER
,      SERIAL_NUMBER
,      UNIT_NUMBER
,      SERIAL_STATUS_ID
,      LPN_STATUS_ID
,      LPN_CONTEXT
,      COST_GROUP_ID
,      COST_GROUP_NAME
,      PRIMARY_UOM_CODE
,      UOM_CODE
,      QUANTITY
,      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
,      SOURCE_TYPE_ID
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      SOURCE_LINE_DETAIL_ID
,      SOURCE_NAME
,      TXN_ERROR_FLAG
FROM APPS.WMS_LPN_CONTENTS_DETAIL_V;

Dependencies

[top of page]

APPS.WMS_LPN_CONTENTS_DETAIL_V references the following:

APPS: CST_COST_GROUPS; MTL_SERIAL_NUMBERS; MTL_SYSTEM_ITEMS_KFV; WMS_LICENSE_PLATE_NUMBERS; WMS_LPN_CONTENTS

APPS.WMS_LPN_CONTENTS_DETAIL_V is not referenced by any database object