[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_ITM_SHIPITEMS_V

Object Details

Object Name:	WSH_ITM_SHIPITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_ITM_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

Query Text

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

SELECT ITEM_NUMBER
,      REQUESTED_QTY
,      REQUESTED_QTY_UOM
,      COUNTRY_OF_ORIGIN
,      FREIGHT_CLASS_CAT
,      HAZARD_CLASS
,      INVENTORY_ITEM_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
,      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
,      LINE_NUMBER
,      SOURCE_HEADER_NUMBER
,      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
,      SHIPITEM_ATTRIBUTE1
,      SHIPITEM_ATTRIBUTE2
,      SHIPITEM_ATTRIBUTE3
,      SHIPITEM_ATTRIBUTE4
,      SHIPITEM_ATTRIBUTE_CATEGORY
,      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
,      WSN_ROWID
FROM APPS.WSH_ITM_SHIPITEMS_V;

Dependencies

[top of page]

APPS

MTL_CATEGORY_SETS_VL

MTL_CUSTOMER_ITEMS

MTL_SYSTEM_ITEMS_KFV

PO_HAZARD_CLASSES_VL

WSH_DELIVERY_ASSIGNMENTS_V

WSH_DELIVERY_DETAILS

WSH_NEW_DELIVERIES

WSH_SERIAL_NUMBERS

APPS.WSH_ITM_SHIPITEMS_V is not referenced by any database object