DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.WSH_INV_DELIVERY_DETAILS_V

Object Details
Object Name: WSH_INV_DELIVERY_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_INV_DELIVERY_DETAILS_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 Mandatory Comments
OE_HEADER_ID NUMBER

TRIP_STOP_ID NUMBER

OE_LINE_ID NUMBER
Yes
SHIPPING_DELIVERY_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_NUMBER VARCHAR2 (30) Yes
SHIP_TO_LOCATION NUMBER

SHIP_FROM_LOCATION NUMBER

SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
SHIPMENT_NUMBER NUMBER
Yes
FREIGHT_CODE VARCHAR2 (30)
MOVE_ORDER_LINE_ID NUMBER

RELEASED_STATUS VARCHAR2 (1)
DELIVERY_DETAIL_ID NUMBER
Yes
Query Text

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


SELECT OE_HEADER_ID
,      TRIP_STOP_ID
,      OE_LINE_ID
,      SHIPPING_DELIVERY_ID
,      CUSTOMER_ID
,      CUSTOMER_NUMBER
,      SHIP_TO_LOCATION
,      SHIP_FROM_LOCATION
,      SHIPMENT_PRIORITY_CODE
,      SHIPMENT_NUMBER
,      FREIGHT_CODE
,      MOVE_ORDER_LINE_ID
,      RELEASED_STATUS
,      DELIVERY_DETAIL_ID
FROM APPS.WSH_INV_DELIVERY_DETAILS_V;

Dependencies

[top of page]

APPS.WSH_INV_DELIVERY_DETAILS_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymOE_ORDER_LINES_ALL
ViewWSH_DELIVERY_ASSIGNMENTS_V
SynonymWSH_DELIVERY_DETAILS
SynonymWSH_DELIVERY_LEGS
SynonymWSH_LOCATIONS
SynonymWSH_NEW_DELIVERIES
SynonymWSH_TRIP_STOPS
APPS.WSH_INV_DELIVERY_DETAILS_V is referenced by following:

SchemaAPPS
Package BodyGMI_PICK_RELEASE_PVT - show dependent code
Package BodyGMI_PICK_RELEASE_UTIL - show dependent code
PL/SQL PackageGMI_PICK_RELEASE_UTIL - show dependent code
Package BodyINV_MO_BACKORDER_PVT - show dependent code
Package BodyINV_PICK_RELEASE_PUB - show dependent code
PL/SQL PackageINV_PICK_RELEASE_PVT - show dependent code
Package BodyINV_PICK_RELEASE_PVT - show dependent code
Package BodyWMS_CROSS_DOCK_PVT - show dependent code
Package BodyWMS_POSTALLOC_PVT - show dependent code
Package BodyWMS_RULE_EXTN_PVT - show dependent code
Package BodyWMS_TASK_MGMT_PUB - show dependent code
Package BodyWMS_TXNRSN_ACTIONS_PUB - show dependent code
Package BodyWMS_UT_PKG - show dependent code
Package BodyWMS_WAVE_PLANNING_PVT - show dependent code
Package BodyWMS_WIP_XDOCK_PVT - show dependent code