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: BOM.CST_DIAG_ERRORED_TXNS#

Source

View Text - Preformatted


select ORGANIZATION_ID ORGANIZATION_ID, BOTTLE_NECK_TXN_ID BOTTLE_NECK_TXN_ID, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_ORGANIZATION_ID TRANSACTION_ORGANIZATION_ID, TRANSFER_ORGANIZATION_ID TRANSFER_ORGANIZATION_ID, TRANSFER_TRANSACTION_ID TRANSFER_TRANSACTION_ID, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_COST TRANSACTION_COST, SHIPMENT_COSTED SHIPMENT_COSTED, MOVE_TRANSACTION_ID MOVE_TRANSACTION_ID, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID, COSTED_FLAG COSTED_FLAG, WAITING_ORGANIZATION_ID WAITING_ORGANIZATION_ID, LOGICAL_TXN_CREATED LOGICAL_TXN_CREATED from "BOM"."CST_DIAG_ERRORED_TXNS"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, BOTTLE_NECK_TXN_ID BOTTLE_NECK_TXN_ID
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_ORGANIZATION_ID TRANSACTION_ORGANIZATION_ID
, TRANSFER_ORGANIZATION_ID TRANSFER_ORGANIZATION_ID
, TRANSFER_TRANSACTION_ID TRANSFER_TRANSACTION_ID
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_COST TRANSACTION_COST
, SHIPMENT_COSTED SHIPMENT_COSTED
, MOVE_TRANSACTION_ID MOVE_TRANSACTION_ID
, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID
, COSTED_FLAG COSTED_FLAG
, WAITING_ORGANIZATION_ID WAITING_ORGANIZATION_ID
, LOGICAL_TXN_CREATED LOGICAL_TXN_CREATED
FROM "BOM"."CST_DIAG_ERRORED_TXNS"