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: CS.CS_SYSTEM_AUDIT#

Source

View Text - Preformatted


select SYSTEM_ID SYSTEM_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OLD_CUSTOMER_ID OLD_CUSTOMER_ID, CURRENT_CUSTOMER_ID CURRENT_CUSTOMER_ID, AUDIT_COMMENTS AUDIT_COMMENTS, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CONTEXT CONTEXT, OLD_SYSTEM_TYPE_CODE OLD_SYSTEM_TYPE_CODE, CURR_SYSTEM_TYPE_CODE CURR_SYSTEM_TYPE_CODE, OLD_SERIAL_NUMBER OLD_SERIAL_NUMBER, CURR_SERIAL_NUMBER CURR_SERIAL_NUMBER, OLD_PARENT_SYSTEM_ID OLD_PARENT_SYSTEM_ID, CURR_PARENT_SYSTEM_ID CURR_PARENT_SYSTEM_ID, OLD_TECHNICAL_CONTACT_ID OLD_TECHNICAL_CONTACT_ID, CURR_TECHNICAL_CONTACT_ID CURR_TECHNICAL_CONTACT_ID, OLD_SERVICE_ADMIN_CONTACT_ID OLD_SERVICE_ADMIN_CONTACT_ID, CURR_SERVICE_ADMIN_CONTACT_ID CURR_SERVICE_ADMIN_CONTACT_ID, OLD_INSTALL_SITE_USE_ID OLD_INSTALL_SITE_USE_ID, CURR_INSTALL_SITE_USE_ID CURR_INSTALL_SITE_USE_ID, OLD_BILL_TO_CONTACT_ID OLD_BILL_TO_CONTACT_ID, CURR_BILL_TO_CONTACT_ID CURR_BILL_TO_CONTACT_ID, OLD_BILL_TO_SITE_USE_ID OLD_BILL_TO_SITE_USE_ID, CURR_BILL_TO_SITE_USE_ID CURR_BILL_TO_SITE_USE_ID, OLD_SHIP_TO_SITE_USE_ID OLD_SHIP_TO_SITE_USE_ID, CURR_SHIP_TO_SITE_USE_ID CURR_SHIP_TO_SITE_USE_ID, OLD_SHIP_TO_CONTACT_ID OLD_SHIP_TO_CONTACT_ID, CURR_SHIP_TO_CONTACT_ID CURR_SHIP_TO_CONTACT_ID, OLD_COTERMINATE_DAY_MONTH OLD_COTERMINATE_DAY_MONTH, CURR_COTERMINATE_DAY_MONTH CURR_COTERMINATE_DAY_MONTH, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE, CURR_START_DATE_ACTIVE CURR_START_DATE_ACTIVE, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE, CURR_END_DATE_ACTIVE CURR_END_DATE_ACTIVE, OLD_CONFIG_SYSTEM_TYPE OLD_CONFIG_SYSTEM_TYPE, CURR_CONFIG_SYSTEM_TYPE CURR_CONFIG_SYSTEM_TYPE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CS_SYSTEM_AUDIT_ID CS_SYSTEM_AUDIT_ID, SYS_AUD_SYSTEM_ID SYS_AUD_SYSTEM_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, UPGRADED_STATUS_FLAG UPGRADED_STATUS_FLAG, VALID_FOR_CSI_MIGRATION VALID_FOR_CSI_MIGRATION, MIGRATED_STATUS_FLAG MIGRATED_STATUS_FLAG, OLD_BILL_TO_SITE_USE OLD_BILL_TO_SITE_USE, OLD_SHIP_TO_SITE_USE OLD_SHIP_TO_SITE_USE, CURRENT_BILL_TO_SITE_USE CURRENT_BILL_TO_SITE_USE, CURRENT_SHIP_TO_SITE_USE CURRENT_SHIP_TO_SITE_USE from "CS"."CS_SYSTEM_AUDIT"

View Text - HTML Formatted

SELECT SYSTEM_ID SYSTEM_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OLD_CUSTOMER_ID OLD_CUSTOMER_ID
, CURRENT_CUSTOMER_ID CURRENT_CUSTOMER_ID
, AUDIT_COMMENTS AUDIT_COMMENTS
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CONTEXT CONTEXT
, OLD_SYSTEM_TYPE_CODE OLD_SYSTEM_TYPE_CODE
, CURR_SYSTEM_TYPE_CODE CURR_SYSTEM_TYPE_CODE
, OLD_SERIAL_NUMBER OLD_SERIAL_NUMBER
, CURR_SERIAL_NUMBER CURR_SERIAL_NUMBER
, OLD_PARENT_SYSTEM_ID OLD_PARENT_SYSTEM_ID
, CURR_PARENT_SYSTEM_ID CURR_PARENT_SYSTEM_ID
, OLD_TECHNICAL_CONTACT_ID OLD_TECHNICAL_CONTACT_ID
, CURR_TECHNICAL_CONTACT_ID CURR_TECHNICAL_CONTACT_ID
, OLD_SERVICE_ADMIN_CONTACT_ID OLD_SERVICE_ADMIN_CONTACT_ID
, CURR_SERVICE_ADMIN_CONTACT_ID CURR_SERVICE_ADMIN_CONTACT_ID
, OLD_INSTALL_SITE_USE_ID OLD_INSTALL_SITE_USE_ID
, CURR_INSTALL_SITE_USE_ID CURR_INSTALL_SITE_USE_ID
, OLD_BILL_TO_CONTACT_ID OLD_BILL_TO_CONTACT_ID
, CURR_BILL_TO_CONTACT_ID CURR_BILL_TO_CONTACT_ID
, OLD_BILL_TO_SITE_USE_ID OLD_BILL_TO_SITE_USE_ID
, CURR_BILL_TO_SITE_USE_ID CURR_BILL_TO_SITE_USE_ID
, OLD_SHIP_TO_SITE_USE_ID OLD_SHIP_TO_SITE_USE_ID
, CURR_SHIP_TO_SITE_USE_ID CURR_SHIP_TO_SITE_USE_ID
, OLD_SHIP_TO_CONTACT_ID OLD_SHIP_TO_CONTACT_ID
, CURR_SHIP_TO_CONTACT_ID CURR_SHIP_TO_CONTACT_ID
, OLD_COTERMINATE_DAY_MONTH OLD_COTERMINATE_DAY_MONTH
, CURR_COTERMINATE_DAY_MONTH CURR_COTERMINATE_DAY_MONTH
, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE
, CURR_START_DATE_ACTIVE CURR_START_DATE_ACTIVE
, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE
, CURR_END_DATE_ACTIVE CURR_END_DATE_ACTIVE
, OLD_CONFIG_SYSTEM_TYPE OLD_CONFIG_SYSTEM_TYPE
, CURR_CONFIG_SYSTEM_TYPE CURR_CONFIG_SYSTEM_TYPE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CS_SYSTEM_AUDIT_ID CS_SYSTEM_AUDIT_ID
, SYS_AUD_SYSTEM_ID SYS_AUD_SYSTEM_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, UPGRADED_STATUS_FLAG UPGRADED_STATUS_FLAG
, VALID_FOR_CSI_MIGRATION VALID_FOR_CSI_MIGRATION
, MIGRATED_STATUS_FLAG MIGRATED_STATUS_FLAG
, OLD_BILL_TO_SITE_USE OLD_BILL_TO_SITE_USE
, OLD_SHIP_TO_SITE_USE OLD_SHIP_TO_SITE_USE
, CURRENT_BILL_TO_SITE_USE CURRENT_BILL_TO_SITE_USE
, CURRENT_SHIP_TO_SITE_USE CURRENT_SHIP_TO_SITE_USE
FROM "CS"."CS_SYSTEM_AUDIT"