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

Object Details

Object Name:	QA_ERES_WSH_NEW_DELIVERIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QA.QA_ERES_WSH_NEW_DELIVERIES_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		Yes	delivery ID
ORGANIZATION_ID	NUMBER			org ID
ORGANIZATION_CODE	VARCHAR2	(3)		org code
ORGANIZATION_NAME	VARCHAR2	(240)		org name
DELIVERY_NAME	VARCHAR2	(30)	Yes	delivery name
STATUS_CODE	VARCHAR2	(2)	Yes	status code
STATUS_NAME	VARCHAR2	(80)	Yes	status name
INITIAL_SHIP_FROM	VARCHAR2	(500)		initial ship from
ULTIMATE_SHIP_TO	VARCHAR2	(500)		ultimate ship to
INTERMEDIATE_SHIP_TO	VARCHAR2	(500)		intermediate ship to
POOLED_SHIP_TO	VARCHAR2	(500)		pooled ship to
CONSIGNEE_ID	NUMBER			consignee ID
CONSIGNEE	VARCHAR2	(360)		consignee
SHIP_METHOD_CODE	VARCHAR2	(30)		ship method code
SHIP_METHOD	VARCHAR2	(80)		ship method
SERVICE_LEVEL_CODE	VARCHAR2	(30)		service level code
SERVICE_LEVEL	VARCHAR2	(80)		service level
SHIP_FROM_DATE	DATE			ship from date
SHIP_TO_DATE	DATE			ship to date
NUMBER_OF_LPN	NUMBER			num of license plate numbers
WAYBILL	VARCHAR2	(30)		waybill
CARRIER_ID	NUMBER			carrier ID
CARRIER	VARCHAR2	(360)		carrier
MODE_OF_TRANSPORT	VARCHAR2	(30)		mode of transport
ADDITIONAL_INFORMATION	VARCHAR2	(500)		additional information
ATTRIBUTE1	VARCHAR2	(150)		standard flexfield
ATTRIBUTE2	VARCHAR2	(150)		standard flexfield
ATTRIBUTE3	VARCHAR2	(150)		standard flexfield
ATTRIBUTE4	VARCHAR2	(150)		standard flexfield
ATTRIBUTE5	VARCHAR2	(150)		standard flexfield
ATTRIBUTE6	VARCHAR2	(150)		standard flexfield
ATTRIBUTE7	VARCHAR2	(150)		standard flexfield
ATTRIBUTE8	VARCHAR2	(150)		standard flexfield
ATTRIBUTE9	VARCHAR2	(150)		standard flexfield
ATTRIBUTE10	VARCHAR2	(150)		standard flexfield
ATTRIBUTE11	VARCHAR2	(150)		standard flexfield
ATTRIBUTE12	VARCHAR2	(150)		standard flexfield
ATTRIBUTE13	VARCHAR2	(150)		standard flexfield
ATTRIBUTE14	VARCHAR2	(150)		standard flexfield
ATTRIBUTE15	VARCHAR2	(150)		standard flexfield
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		standard flexfield
LAST_UPDATE_DATE	DATE		Yes	standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	standard WHO column
LAST_UPDATE_LOGIN	NUMBER			standard WHO column
CREATION_DATE	DATE		Yes	standard WHO column
CREATED_BY	NUMBER		Yes	standard WHO column

Query Text

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


SELECT DELIVERY_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      DELIVERY_NAME
,      STATUS_CODE
,      STATUS_NAME
,      INITIAL_SHIP_FROM
,      ULTIMATE_SHIP_TO
,      INTERMEDIATE_SHIP_TO
,      POOLED_SHIP_TO
,      CONSIGNEE_ID
,      CONSIGNEE
,      SHIP_METHOD_CODE
,      SHIP_METHOD
,      SERVICE_LEVEL_CODE
,      SERVICE_LEVEL
,      SHIP_FROM_DATE
,      SHIP_TO_DATE
,      NUMBER_OF_LPN
,      WAYBILL
,      CARRIER_ID
,      CARRIER
,      MODE_OF_TRANSPORT
,      ADDITIONAL_INFORMATION
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM APPS.QA_ERES_WSH_NEW_DELIVERIES_V;

Dependencies

[top of page]

APPS.QA_ERES_WSH_NEW_DELIVERIES_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; MTL_PARAMETERS; QA_CUSTOMERS_LOV_V; WSH_CARRIERS_V; WSH_CARRIER_SHIP_METHODS_V; WSH_LOCATIONS; WSH_LOOKUPS; WSH_NEW_DELIVERIES_V

APPS.QA_ERES_WSH_NEW_DELIVERIES_V is not referenced by any database object