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

VIEW: APPS.WMS_LPN_CONTENTS_V

Object Details
Object Name: WMS_LPN_CONTENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_LPN_CONTENTS_V
Subobject Name:
Status: VALID

View Type

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


Summary view of container contents ( includes summary of lot and serialized controlled items )


[View Source]

Columns
Name Datatype Length Mandatory Comments
PARENT_LPN_ID NUMBER

Identifier of LPN container
PARENT_LICENSE_PLATE_NUMBER VARCHAR2 (30)
License Plate Number of LPN container
LPN_ID NUMBER

LPN Identifier of content LPN
LICENSE_PLATE_NUMBER VARCHAR2 (30)
License Plate Number of content LPN
OUTERMOST_LPN_ID NUMBER

Identifier of the outermost nested LPN
OUTERMOST_LICENSE_PLATE_NUMBER VARCHAR2 (30)
License Plate Number of outermost nested LPN
ORGANIZATION_ID NUMBER

Organization Identifier
INVENTORY_ITEM_ID NUMBER

ID of item contained in LPN
CONTENT_TYPE NUMBER

Defines if contents is an item (1) or another container (2)
LPN_CONTEXT NUMBER

Context of LPN
ITEM_DESCRIPTION VARCHAR2 (240)
Description of content item
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
UOM_CODE VARCHAR2 (3)
Unit of measure of content item
QUANTITY NUMBER

Quantity of 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

souce line id of pack transaction
SOURCE_LINE_DETAIL_ID NUMBER

source line detail id of pack transaction
SOURCE_NAME VARCHAR2 (80)
source name of transaction
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory code where LPN is located
LOCATOR_ID NUMBER

Locator ID where LPN is located
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
,      INVENTORY_ITEM_ID
,      CONTENT_TYPE
,      LPN_CONTEXT
,      ITEM_DESCRIPTION
,      REVISION
,      LOT_NUMBER
,      SERIAL_NUMBER
,      UOM_CODE
,      QUANTITY
,      SOURCE_TYPE_ID
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      SOURCE_LINE_DETAIL_ID
,      SOURCE_NAME
,      SUBINVENTORY_CODE
,      LOCATOR_ID
FROM APPS.WMS_LPN_CONTENTS_V;

Dependencies

[top of page]

APPS.WMS_LPN_CONTENTS_V references the following:

SchemaAPPS
SynonymMTL_SERIAL_NUMBERS
SynonymWMS_LICENSE_PLATE_NUMBERS
SynonymWMS_LPN_CONTENTS
APPS.WMS_LPN_CONTENTS_V is referenced by following:

SchemaAPPS
Package BodyINV_RCV_STD_RCPT_APIS - show dependent code
Package BodyINV_UI_ITEM_LOVS - show dependent code