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_SHIPITEMS_V

Object Details

Object Name:	WSH_STND_SHIPITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_STND_SHIPITEMS_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	Comments
ITEM_NUMBER	VARCHAR2	(40)	Item Number
REQUESTED_QTY	NUMBER		Requested Quantity
REQUESTED_QTY_UOM	VARCHAR2	(3)	Requested Quantity UOM
FREIGHT_CLASS_CAT	VARCHAR2	(30)	Freight Class category
HAZARD_CLASS	VARCHAR2	(40)	Hazard Class
ITEM_DESCRIPTION	VARCHAR2	(250)	Item Description
REVISION	VARCHAR2	(3)	Revision
CUSTOMER_ITEM_NUMBER	VARCHAR2	(50)	Customer Item Number
PACKING_INSTRUCTIONS	VARCHAR2	(2000)	Packign Instructions
OWNERSHIP_CODE	VARCHAR2	(30)	Ownership Code
ORDERED_QTY	NUMBER		Ordered Quantity
ORDERED_QTY_UOM	VARCHAR2	(3)	Ordered Quantity UOM
SHIPPED_QTY	NUMBER		Shipped Quantity
VOLUME	NUMBER		Volume
VOLUME_UOM_CODE	VARCHAR2	(3)	Volume UOM
NET_WEIGHT	NUMBER		Net Weight
WEIGHT_UOM_CODE	VARCHAR2	(3)	Weight UOM
SHIP_NOTES	VARCHAR2	(2000)	Ship Notes
DELIVERY_DETAIL_ID	NUMBER		Delivery detail
SOURCE_LINE_ID	NUMBER		Order Line Id
PARENT_DELIVERY_DETAIL_ID	NUMBER		Parent Delivery Detail
DELIVERY_ID	NUMBER		Delivery Id
TOLERANCE_BELOW	NUMBER		Shipment Tolerance Below
TOLERANCE_ABOVE	NUMBER		Shipment Tolerance Above
LOAD_SEQUENCE_NUMBER	NUMBER		Load Sequence Number
SUBINVENTORY	VARCHAR2	(10)	Subinventory
CUSTOMER_ID	NUMBER		Customer Id
COMMODITY_CODE_CAT	VARCHAR2	(30)	Commodity Code Category
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)	Shipment Priority
LOT_NUMBER	VARCHAR2	(80)	Lot Number
PREFERRED_GRADE	VARCHAR2	(150)	Preferred Grade
SERIAL_TYPE	VARCHAR2	(4)	Serial Type - WSN , MSNT
WSN_ROWID	VARCHAR2	(18)	RowId form MSNT or WSN
FROM_SERIAL_NUMBER	VARCHAR2	(30)	From Serial Number
TO_SERIAL_NUMBER	VARCHAR2	(30)	To Serial Number
SHIPITEM_ATTRIBUTE_CATEGORY	VARCHAR2	(150)	Shipitem Attribute Category
SHIPITEM_ATTRIBUTE1	VARCHAR2	(150)	Shipment Attribute1
SHIPITEM_ATTRIBUTE2	VARCHAR2	(150)	Shipment Attribute2
SHIPITEM_ATTRIBUTE3	VARCHAR2	(150)	Shipment Attribute3
SHIPITEM_ATTRIBUTE4	VARCHAR2	(150)	Shipment Attribute4
SHIPITEM_ATTRIBUTE5	VARCHAR2	(150)	Shipment Attribute5
SHIPITEM_ATTRIBUTE6	VARCHAR2	(150)	Shipment Attribute6
SHIPITEM_ATTRIBUTE7	VARCHAR2	(150)	Shipment Attribute7
SHIPITEM_ATTRIBUTE8	VARCHAR2	(150)	Shipment Attribute8
SHIPITEM_ATTRIBUTE9	VARCHAR2	(150)	Shipment Attribute9
SHIPITEM_ATTRIBUTE10	VARCHAR2	(150)	Shipment Attribute10
SHIPITEM_ATTRIBUTE11	VARCHAR2	(150)	Shipment Attribute11
SHIPITEM_ATTRIBUTE12	VARCHAR2	(150)	Shipment Attribute12
SHIPITEM_ATTRIBUTE13	VARCHAR2	(150)	Shipment Attribute13
SHIPITEM_ATTRIBUTE14	VARCHAR2	(150)	Shipment Attribute14
SHIPITEM_ATTRIBUTE15	VARCHAR2	(150)	Shipment Attribute15
CUST_PO_NUMBER	VARCHAR2	(50)	Customer PO Number
GROSS_WEIGHT	NUMBER		Gross Weight
MANUAL_WV	VARCHAR2	(1)	Manual Weight Volume Flag - Y or N
LINE_DIRECTION	VARCHAR2	(30)	Line Direction
EARLIEST_PICKUP_DATE	DATE		Earliest Pickup Date
LATEST_PICKUP_DATE	DATE		Latest Pickup Date
EARLIEST_DROPOFF_DATE	DATE		Earliest Dropoff date
LATEST_DROPOFF_DATE	DATE		Latest Dropoff Date
DATE_REQUESTED	DATE		Requested Date
DATE_SCHEDULED	DATE		Scedule Ship date
REQUESTED_QTY2	NUMBER		Secondary Requested Quantity
REQUESTED_QTY_UOM2	VARCHAR2	(3)	Secondary Requested Quantity UOM
ORDERED_QTY2	NUMBER		Secondary Ordered Quantity
ORDERED_QTY_UOM2	VARCHAR2	(3)	Secondary Ordered Quantity UOM
SHIPPED_QTY2	NUMBER		Secondary Shipped Quantity
SHIP_SET_NAME	VARCHAR2	(30)	Ship Set
LINE_NUMBER	VARCHAR2	(150)	Line Number
UNIT_PRICE	NUMBER		Unit Price
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
REFERENCE_NUMBER	VARCHAR2	(150)	Reference Order Number
REFERENCE_LINE_NUMBER	VARCHAR2	(150)	Reference Line Number
REFERENCE_LINE_QUANTITY	NUMBER		Reference Line Quantity
REFERENCE_LINE_QUANTITY_UOM	VARCHAR2	(3)	Reference Line Quantity UOM
DETAIL_SEQUENCE_NUMBER	NUMBER		Detail Sequence Number
LOCATOR_ID	NUMBER		Locator Id
INVENTORY_ITEM_ID	NUMBER		Inventory Item Id
CUSTOMER_ITEM_ID	NUMBER		Customer Item Id

Query Text

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


SELECT ITEM_NUMBER
,      REQUESTED_QTY
,      REQUESTED_QTY_UOM
,      FREIGHT_CLASS_CAT
,      HAZARD_CLASS
,      ITEM_DESCRIPTION
,      REVISION
,      CUSTOMER_ITEM_NUMBER
,      PACKING_INSTRUCTIONS
,      OWNERSHIP_CODE
,      ORDERED_QTY
,      ORDERED_QTY_UOM
,      SHIPPED_QTY
,      VOLUME
,      VOLUME_UOM_CODE
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      SHIP_NOTES
,      DELIVERY_DETAIL_ID
,      SOURCE_LINE_ID
,      PARENT_DELIVERY_DETAIL_ID
,      DELIVERY_ID
,      TOLERANCE_BELOW
,      TOLERANCE_ABOVE
,      LOAD_SEQUENCE_NUMBER
,      SUBINVENTORY
,      CUSTOMER_ID
,      COMMODITY_CODE_CAT
,      SHIPMENT_PRIORITY_CODE
,      LOT_NUMBER
,      PREFERRED_GRADE
,      SERIAL_TYPE
,      WSN_ROWID
,      FROM_SERIAL_NUMBER
,      TO_SERIAL_NUMBER
,      SHIPITEM_ATTRIBUTE_CATEGORY
,      SHIPITEM_ATTRIBUTE1
,      SHIPITEM_ATTRIBUTE2
,      SHIPITEM_ATTRIBUTE3
,      SHIPITEM_ATTRIBUTE4
,      SHIPITEM_ATTRIBUTE5
,      SHIPITEM_ATTRIBUTE6
,      SHIPITEM_ATTRIBUTE7
,      SHIPITEM_ATTRIBUTE8
,      SHIPITEM_ATTRIBUTE9
,      SHIPITEM_ATTRIBUTE10
,      SHIPITEM_ATTRIBUTE11
,      SHIPITEM_ATTRIBUTE12
,      SHIPITEM_ATTRIBUTE13
,      SHIPITEM_ATTRIBUTE14
,      SHIPITEM_ATTRIBUTE15
,      CUST_PO_NUMBER
,      GROSS_WEIGHT
,      MANUAL_WV
,      LINE_DIRECTION
,      EARLIEST_PICKUP_DATE
,      LATEST_PICKUP_DATE
,      EARLIEST_DROPOFF_DATE
,      LATEST_DROPOFF_DATE
,      DATE_REQUESTED
,      DATE_SCHEDULED
,      REQUESTED_QTY2
,      REQUESTED_QTY_UOM2
,      ORDERED_QTY2
,      ORDERED_QTY_UOM2
,      SHIPPED_QTY2
,      SHIP_SET_NAME
,      LINE_NUMBER
,      UNIT_PRICE
,      CURRENCY_CODE
,      REFERENCE_NUMBER
,      REFERENCE_LINE_NUMBER
,      REFERENCE_LINE_QUANTITY
,      REFERENCE_LINE_QUANTITY_UOM
,      DETAIL_SEQUENCE_NUMBER
,      LOCATOR_ID
,      INVENTORY_ITEM_ID
,      CUSTOMER_ITEM_ID
FROM APPS.WSH_STND_SHIPITEMS_V;

Dependencies

[top of page]

APPS.WSH_STND_SHIPITEMS_V references the following:

APPS: FND_ID_FLEX_STRUCTURES_VL; MTL_CATEGORY_SETS_VL; MTL_CUSTOMER_ITEMS; MTL_SERIAL_NUMBERS_TEMP; MTL_SYSTEM_ITEMS_KFV; OE_SETS; PO_HAZARD_CLASSES_VL; WSH_DELIVERY_ASSIGNMENTS_V; WSH_DELIVERY_DETAILS; WSH_NEW_DELIVERIES; WSH_SERIAL_NUMBERS

APPS.WSH_STND_SHIPITEMS_V is not referenced by any database object