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_SHIPITEMS_V

Object Details

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

View Type

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

View of delivery line details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_NUMBER	VARCHAR2	(40)		Concatenated Segments Item Number.
INVENTORY_ITEM_ID	NUMBER			Inventory Item ID.
CUSTOMER_ITEM_ID	NUMBER			Customer Item ID.
REQUESTED_QTY	NUMBER		Yes	Requested Quantity.
REQUESTED_QTY_UOM	VARCHAR2	(3)	Yes	Requested Quantity Unit Of Measure.
SRC_REQUESTED_QUANTITY	NUMBER			As Ordered by Customer Quantity.
DELIVERY_DETAILS_GROSS_WEIGHT	NUMBER			Gross Weight of the Line.
CONTAINER_TYPE_CODE	VARCHAR2	(30)		Container Type Code.
CONTAINER_NAME	VARCHAR2	(30)		Container Name.
COUNTRY_OF_ORIGIN	VARCHAR2	(50)		Country of Origin.
FREIGHT_CLASS_CAT	VARCHAR2	(30)		Freight Class Category.
HAZARD_CLASS	VARCHAR2	(40)		Hazardous material class.
HAZARD_CLASS_ID	NUMBER			Hazardous material Code.
ITEM_DESCRIPTION	VARCHAR2	(250)		Item Description.
REVISION	VARCHAR2	(3)		Item Revision.
CUSTOMER_ITEM_NUMBER	VARCHAR2	(50)		Customer Item Number.
PACKING_INSTRUCTIONS	VARCHAR2	(2000)		Packing Instructions.
OWNERSHIP_CODE	VARCHAR2	(30)		FOB Code.
PARTIAL_SHIPMENT	NUMBER			Is Partial Shipment.
BACKORDERED_QTY	NUMBER			Backordered Quantity.
ORDERED_QTY	NUMBER			Ordered Quantity.
ORDERED_QTY_UOM	VARCHAR2	(3)		Ordered Quantity Unit of Measure.
SHIPPED_QTY	NUMBER			Shipped Quantity.
VOLUME	NUMBER			Volume.
VOLUME_UOM_CODE	VARCHAR2	(3)		Volume Unit of Measure.
NET_WEIGHT	NUMBER			Net Weight.
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight Unit of Measure.
GROSS_WEIGHT	NUMBER			Gross Weight.
SHIP_NOTES	VARCHAR2	(2000)		Ship Notes.
DELIVERY_DETAIL_ID	NUMBER		Yes	Delivery Detail ID.
SOURCE_LINE_ID	NUMBER		Yes	Source Line ID.
PARENT_DELIVERY_DETAIL_ID	NUMBER			Parent Delivery Detail ID.
DELIVERY_ID	NUMBER			Delivery ID.
TOLERANCE_BELOW	NUMBER			Tolerance Lower Limit.
TOLERANCE_ABOVE	NUMBER			Tolerance Upper Limit.
LOAD_SEQUENCE_NUMBER	NUMBER			Load Sequence Number.
SHIP_SET_ID	NUMBER			Ship Set ID.
SUBINVENTORY	VARCHAR2	(10)		Subinventory.
TOP_MODEL_LINE_ID	NUMBER			Top Model Line ID.
SHIP_MODEL_COMPLETE_FLAG	VARCHAR2	(1)		Ship Model Complete Flag.
DELIVER_TO_LOCATION_ID	NUMBER			Deliver to Location ID.
ORG_ID	NUMBER			Oranization ID.
CUSTOMER_ID	NUMBER			Customer ID.
COMMODITY_CODE_CAT	VARCHAR2	(30)		Commodity Code Category.
SHIPMENT_PRIORITY_CODE	VARCHAR2	(2)		Shipment Priority Code.
LOT_NUMBER	VARCHAR2	(80)		Lot Number.
SUBLOT_NUMBER	VARCHAR2	(32)		Sublot Number.
FROM_SERIAL_NUMBER	VARCHAR2	(30)		From Serial Number.
TO_SERIAL_NUMBER	VARCHAR2	(30)		To Serial Number.
PREFERRED_GRADE	VARCHAR2	(150)		Preferred Grade.
CUST_PO_NUMBER	VARCHAR2	(50)		Customer PO Number.
WSN_ROWID	VARCHAR2	(18)		Shipment Notice Row ID.

Query Text

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


SELECT ITEM_NUMBER
,      INVENTORY_ITEM_ID
,      CUSTOMER_ITEM_ID
,      REQUESTED_QTY
,      REQUESTED_QTY_UOM
,      SRC_REQUESTED_QUANTITY
,      DELIVERY_DETAILS_GROSS_WEIGHT
,      CONTAINER_TYPE_CODE
,      CONTAINER_NAME
,      COUNTRY_OF_ORIGIN
,      FREIGHT_CLASS_CAT
,      HAZARD_CLASS
,      HAZARD_CLASS_ID
,      ITEM_DESCRIPTION
,      REVISION
,      CUSTOMER_ITEM_NUMBER
,      PACKING_INSTRUCTIONS
,      OWNERSHIP_CODE
,      PARTIAL_SHIPMENT
,      BACKORDERED_QTY
,      ORDERED_QTY
,      ORDERED_QTY_UOM
,      SHIPPED_QTY
,      VOLUME
,      VOLUME_UOM_CODE
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      GROSS_WEIGHT
,      SHIP_NOTES
,      DELIVERY_DETAIL_ID
,      SOURCE_LINE_ID
,      PARENT_DELIVERY_DETAIL_ID
,      DELIVERY_ID
,      TOLERANCE_BELOW
,      TOLERANCE_ABOVE
,      LOAD_SEQUENCE_NUMBER
,      SHIP_SET_ID
,      SUBINVENTORY
,      TOP_MODEL_LINE_ID
,      SHIP_MODEL_COMPLETE_FLAG
,      DELIVER_TO_LOCATION_ID
,      ORG_ID
,      CUSTOMER_ID
,      COMMODITY_CODE_CAT
,      SHIPMENT_PRIORITY_CODE
,      LOT_NUMBER
,      SUBLOT_NUMBER
,      FROM_SERIAL_NUMBER
,      TO_SERIAL_NUMBER
,      PREFERRED_GRADE
,      CUST_PO_NUMBER
,      WSN_ROWID
FROM APPS.CLN_WSH_SS_SHIPITEMS_V;

Dependencies

[top of page]

APPS.CLN_WSH_SS_SHIPITEMS_V references the following:

APPS: MTL_CATEGORY_SETS_VL; MTL_CUSTOMER_ITEMS; MTL_SYSTEM_ITEMS_KFV; PO_HAZARD_CLASSES_VL; WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS; WSH_NEW_DELIVERIES; WSH_SERIAL_NUMBERS

APPS.CLN_WSH_SS_SHIPITEMS_V is not referenced by any database object