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: CN.CN_NOT_TRX_ALL#

Source

View Text - Preformatted


select NOT_TRX_ID NOT_TRX_ID, ROW_ID ROW_ID, PROCESSED_DATE PROCESSED_DATE, NOTIFIED_DATE NOTIFIED_DATE, NOTIFICATION_RUN_ID NOTIFICATION_RUN_ID, BATCH_ID BATCH_ID, COLLECTED_FLAG COLLECTED_FLAG, SOURCE_TRX_ID SOURCE_TRX_ID, EVENT_ID EVENT_ID, SOURCE_TRX_LINE_ID SOURCE_TRX_LINE_ID, ADJUSTED_FLAG ADJUSTED_FLAG, NEGATED_FLAG NEGATED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ORG_ID ORG_ID, SOURCE_DOC_TYPE SOURCE_DOC_TYPE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_COLLECTED_DATE LAST_COLLECTED_DATE from "CN"."CN_NOT_TRX_ALL"

View Text - HTML Formatted

SELECT NOT_TRX_ID NOT_TRX_ID
, ROW_ID ROW_ID
, PROCESSED_DATE PROCESSED_DATE
, NOTIFIED_DATE NOTIFIED_DATE
, NOTIFICATION_RUN_ID NOTIFICATION_RUN_ID
, BATCH_ID BATCH_ID
, COLLECTED_FLAG COLLECTED_FLAG
, SOURCE_TRX_ID SOURCE_TRX_ID
, EVENT_ID EVENT_ID
, SOURCE_TRX_LINE_ID SOURCE_TRX_LINE_ID
, ADJUSTED_FLAG ADJUSTED_FLAG
, NEGATED_FLAG NEGATED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ORG_ID ORG_ID
, SOURCE_DOC_TYPE SOURCE_DOC_TYPE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_COLLECTED_DATE LAST_COLLECTED_DATE
FROM "CN"."CN_NOT_TRX_ALL"