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.

VIEW: CSI.CSI_TXN_ERRORS#

Source

View Text - Preformatted


select TRANSACTION_ERROR_ID TRANSACTION_ERROR_ID, TRANSACTION_ID TRANSACTION_ID, MESSAGE_ID MESSAGE_ID, ERROR_TEXT ERROR_TEXT, SOURCE_TYPE SOURCE_TYPE, SOURCE_ID SOURCE_ID, PROCESSED_FLAG PROCESSED_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, SOURCE_GROUP_REF SOURCE_GROUP_REF, SOURCE_GROUP_REF_ID SOURCE_GROUP_REF_ID, SOURCE_HEADER_REF SOURCE_HEADER_REF, SOURCE_HEADER_REF_ID SOURCE_HEADER_REF_ID, SOURCE_LINE_REF SOURCE_LINE_REF, SOURCE_LINE_REF_ID SOURCE_LINE_REF_ID, SOURCE_DIST_REF_ID1 SOURCE_DIST_REF_ID1, SOURCE_DIST_REF_ID2 SOURCE_DIST_REF_ID2, INV_MATERIAL_TRANSACTION_ID INV_MATERIAL_TRANSACTION_ID, ERROR_STAGE ERROR_STAGE, MESSAGE_STRING MESSAGE_STRING, TRANSACTION_ERROR_DATE TRANSACTION_ERROR_DATE, SERIAL_NUMBER SERIAL_NUMBER, LOT_NUMBER LOT_NUMBER, INSTANCE_ID INSTANCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SRC_SERIAL_NUM_CTRL_CODE SRC_SERIAL_NUM_CTRL_CODE, DST_SERIAL_NUM_CTRL_CODE DST_SERIAL_NUM_CTRL_CODE, SRC_LOT_CTRL_CODE SRC_LOT_CTRL_CODE, DST_LOT_CTRL_CODE DST_LOT_CTRL_CODE, SRC_LOCATION_CTRL_CODE SRC_LOCATION_CTRL_CODE, DST_LOCATION_CTRL_CODE DST_LOCATION_CTRL_CODE, SRC_REV_QTY_CTRL_CODE SRC_REV_QTY_CTRL_CODE, DST_REV_QTY_CTRL_CODE DST_REV_QTY_CTRL_CODE, COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG from "CSI"."CSI_TXN_ERRORS"

View Text - HTML Formatted

SELECT TRANSACTION_ERROR_ID TRANSACTION_ERROR_ID
, TRANSACTION_ID TRANSACTION_ID
, MESSAGE_ID MESSAGE_ID
, ERROR_TEXT ERROR_TEXT
, SOURCE_TYPE SOURCE_TYPE
, SOURCE_ID SOURCE_ID
, PROCESSED_FLAG PROCESSED_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, SOURCE_GROUP_REF SOURCE_GROUP_REF
, SOURCE_GROUP_REF_ID SOURCE_GROUP_REF_ID
, SOURCE_HEADER_REF SOURCE_HEADER_REF
, SOURCE_HEADER_REF_ID SOURCE_HEADER_REF_ID
, SOURCE_LINE_REF SOURCE_LINE_REF
, SOURCE_LINE_REF_ID SOURCE_LINE_REF_ID
, SOURCE_DIST_REF_ID1 SOURCE_DIST_REF_ID1
, SOURCE_DIST_REF_ID2 SOURCE_DIST_REF_ID2
, INV_MATERIAL_TRANSACTION_ID INV_MATERIAL_TRANSACTION_ID
, ERROR_STAGE ERROR_STAGE
, MESSAGE_STRING MESSAGE_STRING
, TRANSACTION_ERROR_DATE TRANSACTION_ERROR_DATE
, SERIAL_NUMBER SERIAL_NUMBER
, LOT_NUMBER LOT_NUMBER
, INSTANCE_ID INSTANCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SRC_SERIAL_NUM_CTRL_CODE SRC_SERIAL_NUM_CTRL_CODE
, DST_SERIAL_NUM_CTRL_CODE DST_SERIAL_NUM_CTRL_CODE
, SRC_LOT_CTRL_CODE SRC_LOT_CTRL_CODE
, DST_LOT_CTRL_CODE DST_LOT_CTRL_CODE
, SRC_LOCATION_CTRL_CODE SRC_LOCATION_CTRL_CODE
, DST_LOCATION_CTRL_CODE DST_LOCATION_CTRL_CODE
, SRC_REV_QTY_CTRL_CODE SRC_REV_QTY_CTRL_CODE
, DST_REV_QTY_CTRL_CODE DST_REV_QTY_CTRL_CODE
, COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG
FROM "CSI"."CSI_TXN_ERRORS"