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_LOAD_TENDER_CARGO_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
CARGO_PK	VARCHAR2	(80)
DELIVERY_ID	NUMBER		Yes
CONTAINER_INSTANCE_ID	NUMBER		Yes
CONTAINER_NUMBER	VARCHAR2	(30)
SEAL_NUMBER	VARCHAR2	(30)
SERIAL_NUMBER	VARCHAR2	(30)
CONTAINER_TYPE	VARCHAR2	(30)
CONTAINER_DESCRIPTION	VARCHAR2	(250)
CONTAINER_QUANTITY	NUMBER		Yes
CONTAINER_QUANTITY_UOM	VARCHAR2	(3)	Yes
CONTAINER_GROSS_WEIGHT	NUMBER
CONTAINER_NET_WEIGHT	NUMBER
CONTAINER_UOM_WEIGHT_CODE	VARCHAR2	(3)
CONTAINER_VOLUME	NUMBER
CONTAINER_UOM_VOLUME_CODE	VARCHAR2	(3)
ITEM_DETAIL_ID	NUMBER		Yes
ITEM_DESCRIPTION	VARCHAR2	(250)
ITEM_HAZARD_CODE	NUMBER
ITEM_COUNTRY_OF_ORIGIN	VARCHAR2	(50)
ITEM_CLASSIFICATION	VARCHAR2	(30)
ITEM_SHIP_TOLERANCE_ABOVE	NUMBER
ITEM_SHIP_TOLERANCE_BELOW	NUMBER
ITEM_SHIPPED_QUANTITY	NUMBER		Yes
ITEM_SHIP_QUANTITY_UOM	VARCHAR2	(3)	Yes
ITEM_DELIVERED_QUANTITY	NUMBER
ITEM_SERIAL_NUMBER	VARCHAR2	(30)
ITEM_CONTAINER_ID	NUMBER
ITEM_NET_WEIGHT	NUMBER
ITEM_WEIGHT_UOM_CODE	VARCHAR2	(3)
ITEM_VOLUME	NUMBER
ITEM_VOLUME_UOM	VARCHAR2	(3)
ITEM_CUST_PO_NUMBER	VARCHAR2	(50)

Query Text

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


SELECT CARGO_PK
,      DELIVERY_ID
,      CONTAINER_INSTANCE_ID
,      CONTAINER_NUMBER
,      SEAL_NUMBER
,      SERIAL_NUMBER
,      CONTAINER_TYPE
,      CONTAINER_DESCRIPTION
,      CONTAINER_QUANTITY
,      CONTAINER_QUANTITY_UOM
,      CONTAINER_GROSS_WEIGHT
,      CONTAINER_NET_WEIGHT
,      CONTAINER_UOM_WEIGHT_CODE
,      CONTAINER_VOLUME
,      CONTAINER_UOM_VOLUME_CODE
,      ITEM_DETAIL_ID
,      ITEM_DESCRIPTION
,      ITEM_HAZARD_CODE
,      ITEM_COUNTRY_OF_ORIGIN
,      ITEM_CLASSIFICATION
,      ITEM_SHIP_TOLERANCE_ABOVE
,      ITEM_SHIP_TOLERANCE_BELOW
,      ITEM_SHIPPED_QUANTITY
,      ITEM_SHIP_QUANTITY_UOM
,      ITEM_DELIVERED_QUANTITY
,      ITEM_SERIAL_NUMBER
,      ITEM_CONTAINER_ID
,      ITEM_NET_WEIGHT
,      ITEM_WEIGHT_UOM_CODE
,      ITEM_VOLUME
,      ITEM_VOLUME_UOM
,      ITEM_CUST_PO_NUMBER
FROM APPS.WSH_LOAD_TENDER_CARGO_V;

Dependencies

[top of page]

APPS.WSH_LOAD_TENDER_CARGO_V references the following:

APPS: WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS; WSH_NEW_DELIVERIES

APPS.WSH_LOAD_TENDER_CARGO_V is not referenced by any database object