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: XTR.XTR_AUDIT_SUMMARY#

Source

View Text - Preformatted


select AUDIT_RECORDS_FROM AUDIT_RECORDS_FROM, AUDIT_RECORDS_TO AUDIT_RECORDS_TO, AUDIT_REQUESTED_BY AUDIT_REQUESTED_BY, AUDIT_REQUESTED_ON AUDIT_REQUESTED_ON, NAME_OF_COLUMN_CHANGED NAME_OF_COLUMN_CHANGED, NEW_VALUE NEW_VALUE, NON_TRANSACTION_REF NON_TRANSACTION_REF, OLD_VALUE OLD_VALUE, REFERENCE_CODE REFERENCE_CODE, TABLE_NAME TABLE_NAME, TRANSACTION_REF TRANSACTION_REF, UPDATED_BY_USER UPDATED_BY_USER, UPDATED_ON_DATE UPDATED_ON_DATE, ACTION_CODE ACTION_CODE, AUDIT_REQUEST_ID AUDIT_REQUEST_ID from "XTR"."XTR_AUDIT_SUMMARY"

View Text - HTML Formatted

SELECT AUDIT_RECORDS_FROM AUDIT_RECORDS_FROM
, AUDIT_RECORDS_TO AUDIT_RECORDS_TO
, AUDIT_REQUESTED_BY AUDIT_REQUESTED_BY
, AUDIT_REQUESTED_ON AUDIT_REQUESTED_ON
, NAME_OF_COLUMN_CHANGED NAME_OF_COLUMN_CHANGED
, NEW_VALUE NEW_VALUE
, NON_TRANSACTION_REF NON_TRANSACTION_REF
, OLD_VALUE OLD_VALUE
, REFERENCE_CODE REFERENCE_CODE
, TABLE_NAME TABLE_NAME
, TRANSACTION_REF TRANSACTION_REF
, UPDATED_BY_USER UPDATED_BY_USER
, UPDATED_ON_DATE UPDATED_ON_DATE
, ACTION_CODE ACTION_CODE
, AUDIT_REQUEST_ID AUDIT_REQUEST_ID
FROM "XTR"."XTR_AUDIT_SUMMARY"