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_EXCEPTIONS_B

Object Details

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

Stores exceptions created in Wave Planning

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
EXCEPTION_ID	NUMBER		Yes	exception id
EXCEPTION_ENTITY	VARCHAR2	(50)		exception entity
EXCEPTION_STAGE	VARCHAR2	(50)		exception stage
EXCEPTION_LEVEL	VARCHAR2	(30)		exception level
EXCEPTION_MSG	VARCHAR2	(400)		exception message
WAVE_HEADER_ID	NUMBER		Yes	wave header id
TRIP_ID	NUMBER			trip id
DELIVERY_ID	NUMBER			delivery id
ORDER_NUMBER	NUMBER			order number
ORDER_LINE_ID	NUMBER			order line id
STATUS	VARCHAR2	(50)		status
READY_TO_RELEASE	VARCHAR2	(10)		ready to release
BACKORDERED	VARCHAR2	(10)		backordered
CROSSDOCK_PLANNED	VARCHAR2	(10)		crossdock planned
REPLENISHMENT_PLANNED	VARCHAR2	(10)		replenishment planned
TASKED	VARCHAR2	(10)		tasked
PICKED	VARCHAR2	(10)		picked
PACKED	VARCHAR2	(10)		packed
STAGED	VARCHAR2	(10)		staged
LOADED_TO_DOCK	VARCHAR2	(10)		loaded to dock
SHIPPED	VARCHAR2	(10)		shipped
CONCURRENT_REQUEST_ID	NUMBER			concurrent request id
PROGRAM_ID	NUMBER			program id
CREATED_BY	NUMBER			created by
CREATION_DATE	DATE			creation date
LAST_UPDATE_DATE	DATE			last update date
LAST_UPDATED_BY	NUMBER			last updated by
LAST_UPDATE_LOGIN	NUMBER			last update login

Query Text

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


SELECT EXCEPTION_ID
,      EXCEPTION_ENTITY
,      EXCEPTION_STAGE
,      EXCEPTION_LEVEL
,      EXCEPTION_MSG
,      WAVE_HEADER_ID
,      TRIP_ID
,      DELIVERY_ID
,      ORDER_NUMBER
,      ORDER_LINE_ID
,      STATUS
,      READY_TO_RELEASE
,      BACKORDERED
,      CROSSDOCK_PLANNED
,      REPLENISHMENT_PLANNED
,      TASKED
,      PICKED
,      PACKED
,      STAGED
,      LOADED_TO_DOCK
,      SHIPPED
,      CONCURRENT_REQUEST_ID
,      PROGRAM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM WMS.WMS_WP_WAVE_EXCEPTIONS_B;

Dependencies

[top of page]

WMS.WMS_WP_WAVE_EXCEPTIONS_B does not reference any database object

WMS.WMS_WP_WAVE_EXCEPTIONS_B is referenced by following:

WMS: WMS_WP_WAVE_EXCEPTIONS_B#