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

Object Details

Object Name:	CLN_WSH_SS_SHIPMENT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CLN.CLN_WSH_SS_SHIPMENT_V
Subobject Name:
Status:	VALID

View Type

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

View of delivery header details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_ID	NUMBER		Yes	Delivery ID.
ACTION_CODE	VARCHAR2	(30)	Yes	Shipping Transaction History Action Code.
DOCUMENT_NUMBER	VARCHAR2	(120)	Yes	Shipping Transaction History Document Number.
DOCUMENT_CREATION_DATE	DATE		Yes	Delivery Creation Date.
SHIP_FROM_LOCATION	VARCHAR2	(60)	Yes	Delivery Ship From Location.
SHIP_METHOD	VARCHAR2	(30)		Delivery Shipment Method.
COUNTRY	VARCHAR2	(120)		Initial Pickup Location Country.
ULTIMATE_DROPOFF_DATE	DATE			Ultimate Dropoff Date.
INITIAL_PICKUP_DATE	DATE			Initial Pickup date.
DESCRIPTION	VARCHAR2	(30)		Delivery Description.
DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Shipping Transaction History Document Type.
FREIGHT_TERMS	VARCHAR2	(30)		Freight Terms.
GROSS_WEIGHT	NUMBER			Delivery Gross Weight.
NET_WEIGHT	NUMBER			Delivery Net Weight.
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight Unit Of Measure.
NUMBER_OF_LPN	NUMBER			Number of LPN.
VOLUME	NUMBER			Delivery Volume.
VOLUME_UOM_CODE	VARCHAR2	(3)		Volume Unit Of Measure.
SHIPPING_MARKS	VARCHAR2	(100)		Shipping Marks.
SHIP_TO_LOCATION	VARCHAR2	(40)	Yes	Ship To Location.
FOB_CODE	VARCHAR2	(30)		FOB Code.
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code.
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization Name.
LOADING_SEQUENCE	NUMBER			Loading Sequence.
ORIG_DOCUMENT_NUMBER	VARCHAR2	(120)		Shipping Transaction History Orig Document Number.
WAYBILL	VARCHAR2	(30)		Waybill.
CARRIER	VARCHAR2	(360)		Delivery Carrier.
SERVICE_LEVEL	VARCHAR2	(30)		Delivery Service Level.
TRANSPORTATION_METHOD	VARCHAR2	(30)		Delivery Transportation Method.
SHIP_FROM_EDI_LOCATION_CODE1	VARCHAR2	(35)		ShipFrom EDI Location Code.
SHIP_FROM_EDI_LOCATION_CODE2	VARCHAR2	(35)		ShipFrom EDI Location Code.
SHIP_FROM_ADDRESS1	VARCHAR2	(240)		ShipFrom Address1.
SHIP_FROM_ADDRESS2	VARCHAR2	(240)		ShipFrom Address2.
SHIP_FROM_ADDRESS3	VARCHAR2	(240)		ShipFrom Address3.
SHIP_FROM_CITY	VARCHAR2	(30)		ShipFrom City.
SHIP_FROM_COUNTRY_CODE	VARCHAR2	(60)		ShipFrom Country Code.
SHIP_FROM_POSTAL_CODE	VARCHAR2	(30)		ShipFrom Postal Code.
SHIP_FROM_REGION	VARCHAR2	(120)		ShipFrom Region.
SHIP_TO_EDI_LOCATION_CODE1	VARCHAR2	(40)		ShipTo EDI Location Code.
SHIP_TO_EDI_LOCATION_CODE2	VARCHAR2	(40)		ShipTo EDI Location Code.
SHIP_TO_ADDRESS1	VARCHAR2	(240)		ShipTo Address1.
SHIP_TO_ADDRESS2	VARCHAR2	(240)		ShipTo Address2.
SHIP_TO_ADDRESS3	VARCHAR2	(240)		ShipTo Address3.
SHIP_TO_CITY	VARCHAR2	(120)		ShipTo City.
SHIP_TO_COUNTRY_CODE	VARCHAR2	(120)		ShipTo Country.
SHIP_TO_POSTAL_CODE	VARCHAR2	(60)		ShipTo Postal Code.
SHIP_TO_REGION	VARCHAR2	(0)		ShipTo Region.

Query Text

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


SELECT DELIVERY_ID
,      ACTION_CODE
,      DOCUMENT_NUMBER
,      DOCUMENT_CREATION_DATE
,      SHIP_FROM_LOCATION
,      SHIP_METHOD
,      COUNTRY
,      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
,      SHIP_TO_LOCATION
,      FOB_CODE
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      LOADING_SEQUENCE
,      ORIG_DOCUMENT_NUMBER
,      WAYBILL
,      CARRIER
,      SERVICE_LEVEL
,      TRANSPORTATION_METHOD
,      SHIP_FROM_EDI_LOCATION_CODE1
,      SHIP_FROM_EDI_LOCATION_CODE2
,      SHIP_FROM_ADDRESS1
,      SHIP_FROM_ADDRESS2
,      SHIP_FROM_ADDRESS3
,      SHIP_FROM_CITY
,      SHIP_FROM_COUNTRY_CODE
,      SHIP_FROM_POSTAL_CODE
,      SHIP_FROM_REGION
,      SHIP_TO_EDI_LOCATION_CODE1
,      SHIP_TO_EDI_LOCATION_CODE2
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_CITY
,      SHIP_TO_COUNTRY_CODE
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_REGION
FROM APPS.CLN_WSH_SS_SHIPMENT_V;

Dependencies

[top of page]

APPS.CLN_WSH_SS_SHIPMENT_V references the following:

APPS: HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_LOCATIONS_ALL_TL; HR_SECURITY - show dependent code; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_PARTY_SITES; ORG_ORGANIZATION_DEFINITIONS; WSH_CARRIERS_V; WSH_LOCATIONS; WSH_NEW_DELIVERIES; WSH_TRANSACTIONS_HISTORY; WSH_UTIL_CORE - show dependent code

APPS.CLN_WSH_SS_SHIPMENT_V is not referenced by any database object