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: WSH.WSH_EXCEPTIONS

Object Details

Object Name:	WSH_EXCEPTIONS
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_EXCEPTIONS
Subobject Name:
Status:	VALID

WSH_EXCEPTIONS records shipping exceptions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_EXCEPTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXCEPTION_ID
WSH_EXCEPTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXCEPTION_NAME
WSH_EXCEPTIONS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
WSH_EXCEPTIONS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOGGING_ENTITY
WSH_EXCEPTIONS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_DETAIL_ID
WSH_EXCEPTIONS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRIP_STOP_ID
WSH_EXCEPTIONS_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTAINER_NAME
WSH_EXCEPTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
WSH_EXCEPTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
WSH_EXCEPTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXCEPTION_LOCATION_ID
WSH_EXCEPTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOGGED_AT_LOCATION_ID
WSH_EXCEPTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID
WSH_EXCEPTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS
WSH_EXCEPTIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRIP_ID
WSH_EXCEPTIONS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXCEPTION_ID	NUMBER		Yes	Primary key for the table
LOGGED_AT_LOCATION_ID	NUMBER		Yes	The location where the exception is logged at
LOGGING_ENTITY	VARCHAR2	(30)	Yes	The party which logs this exception
LOGGING_ENTITY_ID	NUMBER		Yes	The id of the person who logs the exception
EXCEPTION_NAME	VARCHAR2	(30)		The exception definition
EXCEPTION_LOCATION_ID	NUMBER		Yes	The location id where the exception happened
MESSAGE	VARCHAR2	(2000)	Yes	Message associated with the exception
SEVERITY	VARCHAR2	(10)		Exception Severity if different than default
MANUALLY_LOGGED	VARCHAR2	(1)	Yes	Values allowed Y and N
STATUS	VARCHAR2	(30)	Yes	The status of the exception
TRIP_ID	NUMBER			The trip id associated with the exception
TRIP_NAME	VARCHAR2	(30)		The trip name associated with the exception
TRIP_STOP_ID	NUMBER			The trip id associated with the exception
DELIVERY_ID	NUMBER			The delivery id associated with the exception
DELIVERY_NAME	VARCHAR2	(30)		The delivery name associated with the exception
DELIVERY_DETAIL_ID	NUMBER			The delivery detail id associated with the exception
DELIVERY_ASSIGNMENT_ID	NUMBER			The delivery assignment id associated with the exception
CONTAINER_NAME	VARCHAR2	(50)		The container name associated with the exception
INVENTORY_ITEM_ID	NUMBER			The inventory item id associated with the exception
LOT_NUMBER	VARCHAR2	(80)		The lot number of the item
REVISION	VARCHAR2	(3)		The revision of the item
SERIAL_NUMBER	VARCHAR2	(30)		The serial number of the item
UNIT_OF_MEASURE	VARCHAR2	(5)		unit of measure
QUANTITY	NUMBER			quantity
SUBINVENTORY	VARCHAR2	(10)		subinventory
LOCATOR_ID	NUMBER			locator id for the item
ARRIVAL_DATE	DATE			The arrival date of the items associated with the exception
DEPARTURE_DATE	DATE			The departure date of the items associated with the exception
ERROR_MESSAGE	VARCHAR2	(500)		Error message field will be populated if an error is encountered while processing the Exception
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield category
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
SUBLOT_NUMBER	VARCHAR2	(32)		Obsoleted (The sublot number of the item)
UNIT_OF_MEASURE2	VARCHAR2	(3)		dual unit of measure
QUANTITY2	NUMBER			dual quantity
BATCH_ID	NUMBER			foreign key to WSH_PICKING_BATCHES

Query Text

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


SELECT EXCEPTION_ID
,      LOGGED_AT_LOCATION_ID
,      LOGGING_ENTITY
,      LOGGING_ENTITY_ID
,      EXCEPTION_NAME
,      EXCEPTION_LOCATION_ID
,      MESSAGE
,      SEVERITY
,      MANUALLY_LOGGED
,      STATUS
,      TRIP_ID
,      TRIP_NAME
,      TRIP_STOP_ID
,      DELIVERY_ID
,      DELIVERY_NAME
,      DELIVERY_DETAIL_ID
,      DELIVERY_ASSIGNMENT_ID
,      CONTAINER_NAME
,      INVENTORY_ITEM_ID
,      LOT_NUMBER
,      REVISION
,      SERIAL_NUMBER
,      UNIT_OF_MEASURE
,      QUANTITY
,      SUBINVENTORY
,      LOCATOR_ID
,      ARRIVAL_DATE
,      DEPARTURE_DATE
,      ERROR_MESSAGE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SUBLOT_NUMBER
,      UNIT_OF_MEASURE2
,      QUANTITY2
,      BATCH_ID
FROM WSH.WSH_EXCEPTIONS;

Dependencies

[top of page]

WSH.WSH_EXCEPTIONS does not reference any database object

WSH.WSH_EXCEPTIONS is referenced by following:

WSH: WSH_EXCEPTIONS#