[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_DSNO_CONTAINERS_V

Object Details

Object Name:	WSH_DSNO_CONTAINERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_DSNO_CONTAINERS_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

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

SELECT CONTAINER_INSTANCE_ID
,      LPN
,      CONTAINER_ITEM_ID
,      MASTER_SERIAL_NUMBER
,      CONTAINER_SERIAL_NUMBER
,      LOT_NUMBER
,      PARENT_CONTAINER_INSTANCE_ID
,      PARENT_LPN
,      CONTAINER_QUANTITY
,      CONTAINER_TYPE_INT
,      CONTAINER_GROSS_WEIGHT
,      CONTAINER_GROSS_WEIGHT_UOM_INT
,      CONTAINER_TP_CATEGORY
,      CONTAINER_TP_ATTRIBUTE1
,      CONTAINER_TP_ATTRIBUTE2
,      CONTAINER_TP_ATTRIBUTE3
,      CONTAINER_TP_ATTRIBUTE4
,      CONTAINER_TP_ATTRIBUTE5
,      CONTAINER_TP_ATTRIBUTE6
,      CONTAINER_TP_ATTRIBUTE7
,      CONTAINER_TP_ATTRIBUTE8
,      CONTAINER_TP_ATTRIBUTE9
,      CONTAINER_TP_ATTRIBUTE10
,      CONTAINER_TP_ATTRIBUTE11
,      CONTAINER_TP_ATTRIBUTE12
,      CONTAINER_TP_ATTRIBUTE13
,      CONTAINER_TP_ATTRIBUTE14
,      CONTAINER_TP_ATTRIBUTE15
,      CONTAINER_CATEGORY
,      CONTAINER_ATTRIBUTE1
,      CONTAINER_ATTRIBUTE2
,      CONTAINER_ATTRIBUTE3
,      CONTAINER_ATTRIBUTE4
,      CONTAINER_ATTRIBUTE5
,      CONTAINER_ATTRIBUTE6
,      CONTAINER_ATTRIBUTE7
,      CONTAINER_ATTRIBUTE8
,      CONTAINER_ATTRIBUTE9
,      CONTAINER_ATTRIBUTE10
,      CONTAINER_ATTRIBUTE11
,      CONTAINER_ATTRIBUTE12
,      CONTAINER_ATTRIBUTE13
,      CONTAINER_ATTRIBUTE14
,      CONTAINER_ATTRIBUTE15
,      CONTAINER_VOLUME
,      CONTAINER_VOLUME_UOM_CODE_INT
,      CONTAINER_NET_WEIGHT
,      CONTAINER_FILL_PERCENT
,      CONTAINER_MAXIMUM_VOLUME
,      CONTAINER_MAXIMUM_LOAD_WEIGHT
,      CONTAINER_MINIMUM_FILL_PERCENT
,      CONTAINER_TARE_WEIGHT
,      CONTAINER_ITEM_NAME
,      CONTAINER_ITEM_TYPE_INT
,      CONTAINER_SEAL_CODE
,      CONTAINER_TRACKING_NUMBER
,      CONTAINER_EPC
FROM APPS.WSH_DSNO_CONTAINERS_V;

Dependencies

[top of page]

APPS

MTL_SYSTEM_ITEMS

WMS_EPC

WSH_DELIVERY_ASSIGNMENTS_V

WSH_DELIVERY_DETAILS

APPS.WSH_DSNO_CONTAINERS_V is not referenced by any database object