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.WSH_STND_CONTAINERS_V

Object Details

Object Name:	WSH_STND_CONTAINERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_STND_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

Name	Datatype	Length	Mandatory	Comments
CONTAINER_NAME	VARCHAR2	(30)		Container name
SEAL_CODE	VARCHAR2	(30)		Seal Code
CONTAINER_TYPE_CODE	VARCHAR2	(30)		Container type Code
ITEM_NUMBER	VARCHAR2	(40)		Item Number
ITEM_DESCRIPTION	VARCHAR2	(250)		Item Description
DELIVERY_DETAIL_ID	NUMBER		Yes	Delivery detail
PARENT_DELIVERY_DETAIL_ID	NUMBER			Parent Delivery Detail
DELIVERY_ID	NUMBER			Delivery Id
GROSS_WEIGHT	NUMBER			Gross Weight
NET_WEIGHT	NUMBER			Net Weight
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight UOM Code
VOLUME	NUMBER			Volume
VOLUME_UOM_CODE	VARCHAR2	(3)		Volume UOM Code
TRACKING_NUMBER	VARCHAR2	(30)		Tracking Number
DATE_SCHEDULED	DATE			Schedule Ship Date
SHIP_METHOD_CODE	VARCHAR2	(30)		Ship Method Code
FREIGHT_TERMS_CODE	VARCHAR2	(30)		Freight Terms Code
FOB_CODE	VARCHAR2	(30)		FOB Code
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)		Shipping Instructions
PACKING_INSTRUCTIONS	VARCHAR2	(2000)		Packing Instructions
UNIT_HEIGHT	NUMBER			Unit Height
UNIT_LENGTH	NUMBER			Unit Length
UNIT_WIDTH	NUMBER			Unit Width
DIMENSION_UOM_CODE	VARCHAR2	(3)		Dimension UOM Code
SHIP_FROM_LOCATION	VARCHAR2	(60)	Yes	Ship From Location
CATEGORY_SET_NAME	VARCHAR2	(30)		Category Set Name
HAZARD_CLASS	VARCHAR2	(40)		Hazard Class
CONTAINER_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Container Attribute Category
CONTAINER_ATTRIBUTE1	VARCHAR2	(150)		Container Atrribute1
CONTAINER_ATTRIBUTE2	VARCHAR2	(150)		Container Atrribute2
CONTAINER_ATTRIBUTE3	VARCHAR2	(150)		Container Atrribute3
CONTAINER_ATTRIBUTE4	VARCHAR2	(150)		Container Atrribute4
CONTAINER_ATTRIBUTE5	VARCHAR2	(150)		Container Atrribute5
CONTAINER_ATTRIBUTE6	VARCHAR2	(150)		Container Atrribute6
CONTAINER_ATTRIBUTE7	VARCHAR2	(150)		Container Atrribute7
CONTAINER_ATTRIBUTE8	VARCHAR2	(150)		Container Atrribute8
CONTAINER_ATTRIBUTE9	VARCHAR2	(150)		Container Atrribute9
CONTAINER_ATTRIBUTE10	VARCHAR2	(150)		Container Atrribute10
CONTAINER_ATTRIBUTE11	VARCHAR2	(150)		Container Atrribute11
CONTAINER_ATTRIBUTE12	VARCHAR2	(150)		Container Atrribute12
CONTAINER_ATTRIBUTE13	VARCHAR2	(150)		Container Atrribute13
CONTAINER_ATTRIBUTE14	VARCHAR2	(150)		Container Atrribute14
CONTAINER_ATTRIBUTE15	VARCHAR2	(150)		Container Atrribute15
FILL_PERCENT	NUMBER			Fill Percent
FILLED_VOLUME	NUMBER			Filled Volume
MANUAL_WV	VARCHAR2	(1)		Manual Weight Volume Flag
TARE_WEIGHT	NUMBER			Tare Weight

Query Text

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


SELECT CONTAINER_NAME
,      SEAL_CODE
,      CONTAINER_TYPE_CODE
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      DELIVERY_DETAIL_ID
,      PARENT_DELIVERY_DETAIL_ID
,      DELIVERY_ID
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_UOM_CODE
,      TRACKING_NUMBER
,      DATE_SCHEDULED
,      SHIP_METHOD_CODE
,      FREIGHT_TERMS_CODE
,      FOB_CODE
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      UNIT_HEIGHT
,      UNIT_LENGTH
,      UNIT_WIDTH
,      DIMENSION_UOM_CODE
,      SHIP_FROM_LOCATION
,      CATEGORY_SET_NAME
,      HAZARD_CLASS
,      CONTAINER_ATTRIBUTE_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
,      FILL_PERCENT
,      FILLED_VOLUME
,      MANUAL_WV
,      TARE_WEIGHT
FROM APPS.WSH_STND_CONTAINERS_V;

Dependencies

[top of page]

APPS.WSH_STND_CONTAINERS_V references the following:

APPS: FND_ID_FLEX_STRUCTURES_VL; HR_LOCATIONS_ALL_TL; MTL_CATEGORY_SETS_VL; MTL_SYSTEM_ITEMS_KFV; PO_HAZARD_CLASSES_VL; WSH_DELIVERY_ASSIGNMENTS_V; WSH_DELIVERY_DETAILS; WSH_LOCATIONS

APPS.WSH_STND_CONTAINERS_V is not referenced by any database object