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]

TABLE: WMS.WMS_WP_WAVE_LINES

Object Details

Object Name:	WMS_WP_WAVE_LINES
Object Type:	TABLE
Owner:	WMS
Subobject Name:
Status:	VALID

Stores wave line information (link to wsh_delivery_details)

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_WP_WAVE_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WAVE_LINE_ID
WMS_WP_WAVE_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WAVE_HEADER_ID
WMS_WP_WAVE_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_DETAIL_ID
WMS_WP_WAVE_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WAVE_HEADER_ID	NUMBER		Yes	wave header id
WAVE_LINE_ID	NUMBER		Yes	wave line id
WAVE_LINE_SOURCE	VARCHAR2	(5)	Yes	wave line source
WAVE_LINE_STATUS	VARCHAR2	(25)	Yes	wave line status
CREATED_BY	NUMBER		Yes	created by
CREATION_DATE	DATE		Yes	creation date
LAST_UPDATED_BY	NUMBER		Yes	last updated by
LAST_UPDATE_DATE	DATE		Yes	last update date
LAST_UPDATE_LOGIN	NUMBER			last update login
SOURCE_CODE	VARCHAR2	(30)		source code
SOURCE_HEADER_ID	NUMBER			source header id
SOURCE_LINE_ID	NUMBER			source line id
SOURCE_HEADER_NUMBER	VARCHAR2	(150)		source header number
SOURCE_LINE_NUMBER	VARCHAR2	(150)		source line number
SOURCE_HEADER_TYPE_ID	NUMBER			source header type id
SOURCE_DOCUMENT_TYPE_ID	NUMBER			source document type id
DELIVERY_DETAIL_ID	NUMBER		Yes	delivery detail id
DELIVERY_ID	NUMBER			delivery id
ORGANIZATION_ID	NUMBER			organization id
INVENTORY_ITEM_ID	NUMBER			inventory item id
REQUESTED_QUANTITY	NUMBER			requested quantity
REQUESTED_QUANTITY_UOM	VARCHAR2	(3)		requested quantity uom
REQUESTED_QUANTITY2	NUMBER			secondary requested quantity
REQUESTED_QUANTITY_UOM2	VARCHAR2	(3)		secondary requested quantity uom
DEMAND_SOURCE_HEADER_ID	NUMBER			demand sourc header id
NET_WEIGHT	NUMBER			net weight
VOLUME	NUMBER			volume
NET_VALUE	NUMBER			net value
REMOVE_FROM_WAVE_FLAG	VARCHAR2	(1)		remove from wave flag
RE_RELEASE_FLAG	VARCHAR2	(1)		re-release flag
PLANNED_FILL_RATE	NUMBER			planned fill rate
RELEASE_FILL_RATE	NUMBER			release fill rate
PICK_FILL_RATE	NUMBER			pick fill rate
MESSAGE	VARCHAR2	(2000)		message
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		attribute category
ATTRIBUTE1	VARCHAR2	(150)		attribute1
ATTRIBUTE2	VARCHAR2	(150)		attribute2
ATTRIBUTE3	VARCHAR2	(150)		attribute3
ATTRIBUTE4	VARCHAR2	(150)		attribute4
ATTRIBUTE5	VARCHAR2	(150)		attribute5
ATTRIBUTE6	VARCHAR2	(150)		attribute6
ATTRIBUTE7	VARCHAR2	(150)		attribute7
ATTRIBUTE8	VARCHAR2	(150)		attribute8
ATTRIBUTE9	VARCHAR2	(150)		attribute9
ATTRIBUTE10	VARCHAR2	(150)		attribute10
ATTRIBUTE11	VARCHAR2	(150)		attribute11
ATTRIBUTE12	VARCHAR2	(150)		attribute12
ATTRIBUTE13	VARCHAR2	(150)		attribute13
ATTRIBUTE14	VARCHAR2	(150)		attribute14
ATTRIBUTE15	VARCHAR2	(150)		attribute15
CROSSDOCK_QUANTITY	NUMBER			crossdock quantity
CROSSDOCK_UOM	VARCHAR2	(3)		Crossdock Unit of Measure

Query Text

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


SELECT WAVE_HEADER_ID
,      WAVE_LINE_ID
,      WAVE_LINE_SOURCE
,      WAVE_LINE_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SOURCE_CODE
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      SOURCE_HEADER_NUMBER
,      SOURCE_LINE_NUMBER
,      SOURCE_HEADER_TYPE_ID
,      SOURCE_DOCUMENT_TYPE_ID
,      DELIVERY_DETAIL_ID
,      DELIVERY_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REQUESTED_QUANTITY
,      REQUESTED_QUANTITY_UOM
,      REQUESTED_QUANTITY2
,      REQUESTED_QUANTITY_UOM2
,      DEMAND_SOURCE_HEADER_ID
,      NET_WEIGHT
,      VOLUME
,      NET_VALUE
,      REMOVE_FROM_WAVE_FLAG
,      RE_RELEASE_FLAG
,      PLANNED_FILL_RATE
,      RELEASE_FILL_RATE
,      PICK_FILL_RATE
,      MESSAGE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CROSSDOCK_QUANTITY
,      CROSSDOCK_UOM
FROM WMS.WMS_WP_WAVE_LINES;

Dependencies

[top of page]

WMS.WMS_WP_WAVE_LINES does not reference any database object

WMS.WMS_WP_WAVE_LINES is referenced by following:

WMS: WMS_WP_WAVE_LINES#