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_SHIPMENT_V

Object Details

Object Name:	WSH_STND_SHIPMENT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_STND_SHIPMENT_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
DELIVERY_ID	NUMBER		Yes	Delivery Id
ACTION_CODE	VARCHAR2	(30)	Yes	Action Code
DOCUMENT_NUMBER	VARCHAR2	(120)	Yes	Document Number
SHIP_FROM_LOCATION	VARCHAR2	(60)	Yes	Ship From location
SHIP_METHOD	VARCHAR2	(30)		Ship Method
CREATION_DATE	DATE		Yes	Creation Date
ULTIMATE_DROPOFF_DATE	DATE			Ultimate Dropoff date
INITIAL_PICKUP_DATE	DATE			Intial Pickup Date
DESCRIPTION	VARCHAR2	(30)		Description
DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Document Type
FREIGHT_TERMS	VARCHAR2	(30)		Freight Terms
GROSS_WEIGHT	NUMBER			Gross Weight
NET_WEIGHT	NUMBER			Net Weight
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight UOm
NUMBER_OF_LPN	NUMBER			Number of LPN
VOLUME	NUMBER			Volume
VOLUME_UOM_CODE	VARCHAR2	(3)		Volume UOM
SHIPPING_MARKS	VARCHAR2	(100)		Shipping Marks
FOB_CODE	VARCHAR2	(30)		FOB Code
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code
LOADING_SEQUENCE	NUMBER			Loading Sequence
SHIPMENT_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Shipment Attribute Category
SHIPMENT_ATTRIBUTE1	VARCHAR2	(150)		Shipment Attribute1
SHIPMENT_ATTRIBUTE2	VARCHAR2	(150)		Shipment Attribute2
SHIPMENT_ATTRIBUTE3	VARCHAR2	(150)		Shipment Attribute3
SHIPMENT_ATTRIBUTE4	VARCHAR2	(150)		Shipment Attribute4
SHIPMENT_ATTRIBUTE5	VARCHAR2	(150)		Shipment Attribute5
SHIPMENT_ATTRIBUTE6	VARCHAR2	(150)		Shipment Attribute6
SHIPMENT_ATTRIBUTE7	VARCHAR2	(150)		Shipment Attribute7
SHIPMENT_ATTRIBUTE8	VARCHAR2	(150)		Shipment Attribute8
SHIPMENT_ATTRIBUTE9	VARCHAR2	(150)		Shipment Attribute9
SHIPMENT_ATTRIBUTE10	VARCHAR2	(150)		Shipment Attribute10
SHIPMENT_ATTRIBUTE11	VARCHAR2	(150)		Shipment Attribute11
SHIPMENT_ATTRIBUTE12	VARCHAR2	(150)		Shipment Attribute12
SHIPMENT_ATTRIBUTE13	VARCHAR2	(150)		Shipment Attribute13
SHIPMENT_ATTRIBUTE14	VARCHAR2	(150)		Shipment Attribute14
SHIPMENT_ATTRIBUTE15	VARCHAR2	(150)		Shipment Attribute15
ORIG_DOCUMENT_NUMBER	VARCHAR2	(120)		Original Document Number
WAYBILL	VARCHAR2	(30)		Waybill
CARRIER	VARCHAR2	(360)		Carrier
SERVICE_LEVEL	VARCHAR2	(30)		Service level
TRANSPORTATION_METHOD	VARCHAR2	(30)		Transportation Method
MANUAL_WV	VARCHAR2	(1)		Manual Weight Volume Flag - Y or N
SHIPMENT_DIRECTION	VARCHAR2	(30)		Shipment Direction
DELIVERED_DATE	DATE			Delivered Date
TARE_WEIGHT	NUMBER			Tare Weight
DOCUMENT_REVISION	NUMBER			Document Revision
ORGANIZATION_ID	NUMBER			Organization Id

Query Text

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


SELECT DELIVERY_ID
,      ACTION_CODE
,      DOCUMENT_NUMBER
,      SHIP_FROM_LOCATION
,      SHIP_METHOD
,      CREATION_DATE
,      ULTIMATE_DROPOFF_DATE
,      INITIAL_PICKUP_DATE
,      DESCRIPTION
,      DOCUMENT_TYPE
,      FREIGHT_TERMS
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      NUMBER_OF_LPN
,      VOLUME
,      VOLUME_UOM_CODE
,      SHIPPING_MARKS
,      FOB_CODE
,      ORGANIZATION_CODE
,      LOADING_SEQUENCE
,      SHIPMENT_ATTRIBUTE_CATEGORY
,      SHIPMENT_ATTRIBUTE1
,      SHIPMENT_ATTRIBUTE2
,      SHIPMENT_ATTRIBUTE3
,      SHIPMENT_ATTRIBUTE4
,      SHIPMENT_ATTRIBUTE5
,      SHIPMENT_ATTRIBUTE6
,      SHIPMENT_ATTRIBUTE7
,      SHIPMENT_ATTRIBUTE8
,      SHIPMENT_ATTRIBUTE9
,      SHIPMENT_ATTRIBUTE10
,      SHIPMENT_ATTRIBUTE11
,      SHIPMENT_ATTRIBUTE12
,      SHIPMENT_ATTRIBUTE13
,      SHIPMENT_ATTRIBUTE14
,      SHIPMENT_ATTRIBUTE15
,      ORIG_DOCUMENT_NUMBER
,      WAYBILL
,      CARRIER
,      SERVICE_LEVEL
,      TRANSPORTATION_METHOD
,      MANUAL_WV
,      SHIPMENT_DIRECTION
,      DELIVERED_DATE
,      TARE_WEIGHT
,      DOCUMENT_REVISION
,      ORGANIZATION_ID
FROM APPS.WSH_STND_SHIPMENT_V;

Dependencies

[top of page]

APPS.WSH_STND_SHIPMENT_V references the following:

APPS: HR_GENERAL - show dependent code; HR_LOCATIONS_ALL_TL; HR_SECURITY - show dependent code; ORG_ORGANIZATION_DEFINITIONS; WSH_CARRIERS_V; WSH_LOCATIONS; WSH_NEW_DELIVERIES; WSH_TRANSACTIONS_HISTORY

APPS.WSH_STND_SHIPMENT_V is not referenced by any database object