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_DELIVERABLES_V

Object Details

Object Name:	QA_ERES_WSH_DELIVERABLES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QA.QA_ERES_WSH_DELIVERABLES_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			delivery ID
DELIVERY_DETAIL_ID	NUMBER		Yes	delivery detail ID
DELIVERY_LINE_ID	NUMBER			delivery line ID
DELIVERY_LINE_NAME	VARCHAR2	(40)		delivery line
DELIVERY_LINE_STATUS	VARCHAR2	(4000)		delivery line status
ORGANIZATION_ID	NUMBER			org ID
ITEM_ID	NUMBER			item ID
ITEM	VARCHAR2	(40)		item
ITEM_DESCRIPTION	VARCHAR2	(250)		item description
ITEM_REVISION	VARCHAR2	(3)		item rev
TRACKING_NUMBER	VARCHAR2	(30)		tracking number
REQUESTED_QTY	NUMBER		Yes	requested qty
PICKED_QTY	NUMBER			picked qty
SHIPPED_QTY	NUMBER			shipped qty
UOM	VARCHAR2	(3)	Yes	uom
SECOND_REQUESTED_QTY	NUMBER			second requested qty
SECOND_SHIPPED_QTY	NUMBER			second shipped qty
SECOND_UOM	VARCHAR2	(3)		second uom
WEIGHT_MAX	NUMBER			max weight
WEIGHT_GROSS	NUMBER			gross weight
WEIGHT_TARE	NUMBER			tare weight
WEIGHT_NET	NUMBER			net weight
WEIGHT_UOM	VARCHAR2	(3)		weight uom
VOLUME_MAX	NUMBER			max volume
VOLUME	NUMBER			volume
VOLUME_UOM	VARCHAR2	(3)		volume uom
PARENT_LPN	VARCHAR2	(4000)		parent license plate num
MASTER_LPN	VARCHAR2	(4000)		master license plate num
MASTER_SERIAL	VARCHAR2	(30)		master serial num
SHIPPING_INST	VARCHAR2	(2000)		shipping instructions
PACKING_INST	VARCHAR2	(2000)		packing instructions
INV_ORG_CODE	VARCHAR2	(3)		inventory org code
ORG_NAME	VARCHAR2	(240)		org name
SUBINVENTORY	VARCHAR2	(10)		subinventory
LOCATOR	VARCHAR2	(4000)		locator
LOT	VARCHAR2	(80)		lot num
CUSTOMER_REQUESTED_LOT_FLAG	VARCHAR2	(1)		customer requested lot flag
SUBLOT	VARCHAR2	(0)		sublot
SERIAL_NUMBER_FROM	VARCHAR2	(30)		serial num range
SERIAL_NUMBER_TO	VARCHAR2	(30)		serial num range
GRADE	VARCHAR2	(150)		grade
INSPECTION_STATUS	VARCHAR2	(80)		inspection status
SEAL_CODE	VARCHAR2	(30)		seal code
SOURCE_SYSTEM	VARCHAR2	(80)	Yes	source system
ORDER_NUMBER	VARCHAR2	(150)		order num
ORDER_TYPE	VARCHAR2	(240)		order type
ORDER_LINE	VARCHAR2	(150)		order line num
SOURCE_REQ_QTY	NUMBER			source requested qty
SOURCE_REQ_QTY_UOM	VARCHAR2	(3)		uom for above
SOURCE_SEC_QTY	NUMBER			source requested secondary qty
SOURCE_SEC_QTY_UOM	VARCHAR2	(3)		uom for above
PROJECT_NUMBER	VARCHAR2	(30)		project
TASK_NUMBER	VARCHAR2	(25)		task
UNIT_NUMBER	VARCHAR2	(30)		unit
SOURCE_REQ_DATE	DATE			source requested date
SOURCE_SCHED_DATE	DATE			source scheduled date
CUSTOMER_PART_NUMBER	VARCHAR2	(50)		customer item num
CUSTOMER_PART_DESC	VARCHAR2	(240)		customer item description
CUSTOMER_PROD_SEQ	VARCHAR2	(50)		customer product seq
CUSTOMER_DOCK_CODE	VARCHAR2	(50)		customer dock code
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
,      DELIVERY_DETAIL_ID
,      DELIVERY_LINE_ID
,      DELIVERY_LINE_NAME
,      DELIVERY_LINE_STATUS
,      ORGANIZATION_ID
,      ITEM_ID
,      ITEM
,      ITEM_DESCRIPTION
,      ITEM_REVISION
,      TRACKING_NUMBER
,      REQUESTED_QTY
,      PICKED_QTY
,      SHIPPED_QTY
,      UOM
,      SECOND_REQUESTED_QTY
,      SECOND_SHIPPED_QTY
,      SECOND_UOM
,      WEIGHT_MAX
,      WEIGHT_GROSS
,      WEIGHT_TARE
,      WEIGHT_NET
,      WEIGHT_UOM
,      VOLUME_MAX
,      VOLUME
,      VOLUME_UOM
,      PARENT_LPN
,      MASTER_LPN
,      MASTER_SERIAL
,      SHIPPING_INST
,      PACKING_INST
,      INV_ORG_CODE
,      ORG_NAME
,      SUBINVENTORY
,      LOCATOR
,      LOT
,      CUSTOMER_REQUESTED_LOT_FLAG
,      SUBLOT
,      SERIAL_NUMBER_FROM
,      SERIAL_NUMBER_TO
,      GRADE
,      INSPECTION_STATUS
,      SEAL_CODE
,      SOURCE_SYSTEM
,      ORDER_NUMBER
,      ORDER_TYPE
,      ORDER_LINE
,      SOURCE_REQ_QTY
,      SOURCE_REQ_QTY_UOM
,      SOURCE_SEC_QTY
,      SOURCE_SEC_QTY_UOM
,      PROJECT_NUMBER
,      TASK_NUMBER
,      UNIT_NUMBER
,      SOURCE_REQ_DATE
,      SOURCE_SCHED_DATE
,      CUSTOMER_PART_NUMBER
,      CUSTOMER_PART_DESC
,      CUSTOMER_PROD_SEQ
,      CUSTOMER_DOCK_CODE
,      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_DELIVERABLES_V;

Dependencies

[top of page]

APPS.QA_ERES_WSH_DELIVERABLES_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; MTL_CUSTOMER_ITEMS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; PA_PROJECTS_ALL; PA_TASKS; QA_ERES_PKG - show dependent code; QA_FLEX_UTIL - show dependent code; WSH_CONTAINER_UTILITIES - show dependent code; WSH_DLVY_DELIVERABLES_V; WSH_LOOKUPS

APPS.QA_ERES_WSH_DELIVERABLES_V is not referenced by any database object