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.MST_WSH_NEW_DELIVERIES_V

Object Details

Object Name:	MST_WSH_NEW_DELIVERIES_V
Object Type:	VIEW
Owner:	APPS
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		Yes
PLANNED_FLAG	VARCHAR2	(1)	Yes
PRESERVE_GROUPING_FLAG	VARCHAR2	(1)
VENDOR_ID	NUMBER
ORGANIZATION_ID	NUMBER
INITIAL_PICKUP_LOCATION_ID	NUMBER		Yes
DESTINATION_ORGANIZATION_ID	NUMBER
CUSTOMER_ID	NUMBER
ULTIMATE_DROPOFF_LOCATION_ID	NUMBER
INITIAL_PICKUP_DATE	DATE
ULTIMATE_DROPOFF_DATE	DATE
GROSS_WEIGHT	NUMBER
VOLUME	NUMBER
SHIPMENT_DIRECTION	VARCHAR2	(30)
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
MODE_OF_TRANSPORT	VARCHAR2	(30)
CARRIER_ID	NUMBER
SERVICE_LEVEL	VARCHAR2	(30)
NET_WEIGHT	NUMBER
WEIGHT_UOM_CODE	VARCHAR2	(3)
VOLUME_UOM_CODE	VARCHAR2	(3)
EARLIEST_AVAILABLE_TO_SHIP	DATE
LATEST_AVAILABLE_TO_SHIP	DATE
EARLIEST_DELIVERY_DATE	DATE
LATEST_DELIVERY_DATE	DATE
FREIGHT_TERMS_CODE	VARCHAR2	(30)
DIRECT_COST	NUMBER
STATUS_CODE	VARCHAR2	(2)	Yes

Query Text

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


SELECT DELIVERY_ID
,      PLANNED_FLAG
,      PRESERVE_GROUPING_FLAG
,      VENDOR_ID
,      ORGANIZATION_ID
,      INITIAL_PICKUP_LOCATION_ID
,      DESTINATION_ORGANIZATION_ID
,      CUSTOMER_ID
,      ULTIMATE_DROPOFF_LOCATION_ID
,      INITIAL_PICKUP_DATE
,      ULTIMATE_DROPOFF_DATE
,      GROSS_WEIGHT
,      VOLUME
,      SHIPMENT_DIRECTION
,      CREATED_BY
,      LAST_UPDATED_BY
,      MODE_OF_TRANSPORT
,      CARRIER_ID
,      SERVICE_LEVEL
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME_UOM_CODE
,      EARLIEST_AVAILABLE_TO_SHIP
,      LATEST_AVAILABLE_TO_SHIP
,      EARLIEST_DELIVERY_DATE
,      LATEST_DELIVERY_DATE
,      FREIGHT_TERMS_CODE
,      DIRECT_COST
,      STATUS_CODE
FROM APPS.MST_WSH_NEW_DELIVERIES_V;

Dependencies

[top of page]

APPS.MST_WSH_NEW_DELIVERIES_V references the following:

APPS: MST_PO_LOCATION_ASSO_V; WSH_NEW_DELIVERIES

APPS.MST_WSH_NEW_DELIVERIES_V is referenced by following:

APPS: MST_WSH_DEL_DET_NOTPACKED_V; MST_WSH_DEL_DET_WFIRMDEL_V