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_DELIVERY_DETAILS_OE_V

Object Details

Object Name:	WSH_DELIVERY_DETAILS_OE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_DELIVERY_DETAILS_OE_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
DELIVERY_ID	NUMBER			Foreign Key to WSH_NEW_DELIVERIES
DELIVERY_NAME	VARCHAR2	(30)	Yes	Unique Delivery Name
SOURCE_HEADER_ID	NUMBER			For example, it can be sale order header ID
SOURCE_LINE_ID	NUMBER		Yes	OE, WIP, or PO line identifier. For example, it can be sales order line ID
DELIVERY_DETAIL_ID	NUMBER		Yes	Primary Key to identify delivery line
SOURCE_CODE	VARCHAR2	(30)	Yes	OE/WIP/PO
ORGANIZATION_ID	NUMBER			Organization identifier
REQUESTED_QUANTITY	NUMBER		Yes	As shipping quantity for customer
OE_INTERFACED_FLAG	VARCHAR2	(1)		Indicates if line is interfaced to OM
INV_INTERFACED_FLAG	VARCHAR2	(1)		Indicates if line is interfaced to INV
MOVE_ORDER_LINE_ID	NUMBER			Move order line identifier
LINE_SHIP_METHOD	VARCHAR2	(30)		Ship method
DELIVERY_SHIP_METHOD	VARCHAR2	(30)		Shipping Method
TRACKING_NUMBER	VARCHAR2	(30)		Tracking number
WAYBILL	VARCHAR2	(30)		May be the tracking number
RELEASED_STATUS	VARCHAR2	(1)		Pick Release Status
ORIGINAL_LINE_STATUS	VARCHAR2	(80)	Yes
REQUESTED_QUANTITY2	NUMBER
DELIVERED_DATE	DATE
REPLENISHMENT_STATUS	VARCHAR2	(1)

Query Text

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


SELECT DELIVERY_ID
,      DELIVERY_NAME
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      DELIVERY_DETAIL_ID
,      SOURCE_CODE
,      ORGANIZATION_ID
,      REQUESTED_QUANTITY
,      OE_INTERFACED_FLAG
,      INV_INTERFACED_FLAG
,      MOVE_ORDER_LINE_ID
,      LINE_SHIP_METHOD
,      DELIVERY_SHIP_METHOD
,      TRACKING_NUMBER
,      WAYBILL
,      RELEASED_STATUS
,      ORIGINAL_LINE_STATUS
,      REQUESTED_QUANTITY2
,      DELIVERED_DATE
,      REPLENISHMENT_STATUS
FROM APPS.WSH_DELIVERY_DETAILS_OE_V;

Dependencies

[top of page]

APPS.WSH_DELIVERY_DETAILS_OE_V references the following:

APPS: OE_ORDER_LINES_ALL; WSH_DELIVERY_ASSIGNMENTS_V; WSH_DELIVERY_DETAILS; WSH_LOOKUPS; WSH_NEW_DELIVERIES

APPS.WSH_DELIVERY_DETAILS_OE_V is not referenced by any database object