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.

[Home] [Help]

View: WMS_WP_WAVE_EXCEPTIONS_VL

Product:	WMS - Warehouse Management
Description:
Implementation/DBA Data:	APPS.WMS_WP_WAVE_EXCEPTIONS_VL

View Text

SELECT B.ROWID ROW_ID
, B.EXCEPTION_ID
, B.EXCEPTION_ENTITY
, B.EXCEPTION_STAGE
, B.EXCEPTION_LEVEL
, B.EXCEPTION_MSG
, B.WAVE_HEADER_ID
, B.TRIP_ID
, B.DELIVERY_ID
, B.ORDER_NUMBER
, B.ORDER_LINE_ID
, B.STATUS
, B.READY_TO_RELEASE
, B.BACKORDERED
, B.CROSSDOCK_PLANNED
, B.REPLENISHMENT_PLANNED
, B.TASKED
, B.PICKED
, B.PACKED
, B.STAGED
, B.LOADED_TO_DOCK
, B.SHIPPED
, B.CONCURRENT_REQUEST_ID
, B.PROGRAM_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, T.EXCEPTION_NAME
FROM WMS_WP_WAVE_EXCEPTIONS_TL T
, WMS_WP_WAVE_EXCEPTIONS_B B
WHERE B.EXCEPTION_ID = T.EXCEPTION_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
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
EXCEPTION_NAME