[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_DELIVERY_LINE_STATUS_V

Object Details

Object Name:	WSH_DELIVERY_LINE_STATUS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_DELIVERY_LINE_STATUS_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 DELIVERY_DETAIL_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      SOURCE_HEADER_ID
,      HEADER_NUMBER
,      LINE_NUMBER
,      SHIP_METHOD_CODE
,      INVENTORY_ITEM_ID
,      REQUESTED_QUANTITY
,      SHIPPED_QUANTITY
,      SHIPPED_QUANTITY_UOM
,      REQUESTED_QUANTITY_UOM
,      REQUESTED_QUANTITY2
,      SHIPPED_QUANTITY2
,      SHIPPED_QUANTITY_UOM2
,      REQUESTED_QUANTITY_UOM2
,      SHIP_SET_ID
,      REVISION
,      LOT_NUMBER
,      SERIAL_NUMBER
,      PICK_STATUS
,      PICK_MEANING
,      DELIVERY_ID
,      DELIVERY_NAME
,      CURRENCY_CODE
,      DELIVERY_STATUS
,      DELIVERY_STATUS_MEANING
,      ORGANIZATION_ID
,      INITIAL_PICKUP_LOCATION_ID
,      INITIAL_PICKUP_LOCATION
,      ULTIMATE_DROPOFF_LOCATION_ID
,      ULTIMATE_DROPOFF_LOCATION
,      WEIGHT
,      WEIGHT_UOM_CODE
,      DATE_SHIPPED
,      DATE_RECEIVED
,      TRACKING_NUMBER
,      WAYBILL
,      TO_SERIAL_NUMBER
FROM APPS.WSH_DELIVERY_LINE_STATUS_V;

Dependencies

[top of page]

APPS

WSH_DELIVERY_ASSIGNMENTS_V

WSH_DELIVERY_DETAILS

WSH_LOCATIONS

WSH_LOOKUPS

WSH_NEW_DELIVERIES

WSH_SERIAL_NUMBERS

APPS

CSP_PICK_UTILS - show dependent code

OE_DUAL_UOM_UTIL - show dependent code

OE_LINE_STATUS_PUB - show dependent code

OE_SCHEDULE_UTIL - show dependent code

OE_SHIPPING_INTEGRATION_PVT - show dependent code