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: OE.WSH_PACKED_CONTAINER_INTERFACE

Object Details

Object Name:	WSH_PACKED_CONTAINER_INTERFACE
Object Type:	TABLE
Owner:	OE
FND Design Data:	OE.WSH_PACKED_CONTAINER_INTERFACE
Subobject Name:
Status:	VALID

WSH_PACKED_CONTAINER_INTERFACE is used by the Ship Confirm
Open Interface to create packed containers for a delivery.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_PACKED_CONT_INT_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Foreign key to WSH_DELIVERIES_INTERFACE
CONTAINER_ID	NUMBER			Container identifier (internal)
SEQUENCE_NUMBER	NUMBER			User-friendly identifier
CONTAINER_INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
CONTAINER_INVENTORY_ITEM_NAME	VARCHAR2	(30)		Inventory item concatenated segments
QUANTITY	NUMBER		Yes	Quantity of containers
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who column
PARENT_SEQUENCE_NUMBER	NUMBER			Sequence number of container this is packed into
GROSS_WEIGHT	NUMBER			Gross weight of container
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight unit of measure
WEIGHT_UNIT_OF_MEASURE	VARCHAR2	(30)		Description for weight UOM
MASTER_SERIAL_NUMBER	VARCHAR2	(30)		Master serial number of container
INVENTORY_STATUS	VARCHAR2	(30)		Inventory status
ORGANIZATION_ID	NUMBER			Organization ID of container
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code of container
REVISION	VARCHAR2	(3)		Revision of container
LOT_NUMBER	VARCHAR2	(30)		Lot number of container
SUBINVENTORY	VARCHAR2	(10)		Subinventory of container
ERROR_EXPLANATION	VARCHAR2	(240)		Explanatory text of ERROR_CODE
ERROR_CODE	VARCHAR2	(240)		Application error code
INVENTORY_LOCATION_ID	NUMBER			Locator identifier for container
INVENTORY_LOCATION_NAME	VARCHAR2	(30)		Locator concatenated segments for container
SERIAL_NUMBER	VARCHAR2	(30)		Container serial number
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
VOLUME	NUMBER
VOLUME_UOM_CODE	VARCHAR2	(3)
NET_WEIGHT	NUMBER
FILL_PERCENT	NUMBER
PARENT_CONTAINER_ID	NUMBER
MASTER_CONTAINER_ID	NUMBER

Query Text

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


SELECT TRANSACTION_ID
,      CONTAINER_ID
,      SEQUENCE_NUMBER
,      CONTAINER_INVENTORY_ITEM_ID
,      CONTAINER_INVENTORY_ITEM_NAME
,      QUANTITY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PARENT_SEQUENCE_NUMBER
,      GROSS_WEIGHT
,      WEIGHT_UOM_CODE
,      WEIGHT_UNIT_OF_MEASURE
,      MASTER_SERIAL_NUMBER
,      INVENTORY_STATUS
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      REVISION
,      LOT_NUMBER
,      SUBINVENTORY
,      ERROR_EXPLANATION
,      ERROR_CODE
,      INVENTORY_LOCATION_ID
,      INVENTORY_LOCATION_NAME
,      SERIAL_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VOLUME
,      VOLUME_UOM_CODE
,      NET_WEIGHT
,      FILL_PERCENT
,      PARENT_CONTAINER_ID
,      MASTER_CONTAINER_ID
FROM OE.WSH_PACKED_CONTAINER_INTERFACE;

Dependencies

[top of page]

OE.WSH_PACKED_CONTAINER_INTERFACE does not reference any database object

OE.WSH_PACKED_CONTAINER_INTERFACE is referenced by following:

APPS: WSH_PACKED_CONTAINER_INTERFACE