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: CSI.CSI_SYSTEMS_H#

Source

View Text - Preformatted


select SYSTEM_HISTORY_ID SYSTEM_HISTORY_ID, SYSTEM_ID SYSTEM_ID, TRANSACTION_ID TRANSACTION_ID, OLD_CUSTOMER_ID OLD_CUSTOMER_ID, NEW_CUSTOMER_ID NEW_CUSTOMER_ID, OLD_SYSTEM_TYPE_CODE OLD_SYSTEM_TYPE_CODE, NEW_SYSTEM_TYPE_CODE NEW_SYSTEM_TYPE_CODE, OLD_SYSTEM_NUMBER OLD_SYSTEM_NUMBER, NEW_SYSTEM_NUMBER NEW_SYSTEM_NUMBER, OLD_PARENT_SYSTEM_ID OLD_PARENT_SYSTEM_ID, NEW_PARENT_SYSTEM_ID NEW_PARENT_SYSTEM_ID, OLD_SHIP_TO_CONTACT_ID OLD_SHIP_TO_CONTACT_ID, NEW_SHIP_TO_CONTACT_ID NEW_SHIP_TO_CONTACT_ID, OLD_BILL_TO_CONTACT_ID OLD_BILL_TO_CONTACT_ID, NEW_BILL_TO_CONTACT_ID NEW_BILL_TO_CONTACT_ID, OLD_TECHNICAL_CONTACT_ID OLD_TECHNICAL_CONTACT_ID, NEW_TECHNICAL_CONTACT_ID NEW_TECHNICAL_CONTACT_ID, OLD_SERVICE_ADMIN_CONTACT_ID OLD_SERVICE_ADMIN_CONTACT_ID, NEW_SERVICE_ADMIN_CONTACT_ID NEW_SERVICE_ADMIN_CONTACT_ID, OLD_SHIP_TO_SITE_USE_ID OLD_SHIP_TO_SITE_USE_ID, NEW_SHIP_TO_SITE_USE_ID NEW_SHIP_TO_SITE_USE_ID, OLD_INSTALL_SITE_USE_ID OLD_INSTALL_SITE_USE_ID, NEW_INSTALL_SITE_USE_ID NEW_INSTALL_SITE_USE_ID, OLD_BILL_TO_SITE_USE_ID OLD_BILL_TO_SITE_USE_ID, NEW_BILL_TO_SITE_USE_ID NEW_BILL_TO_SITE_USE_ID, OLD_COTERMINATE_DAY_MONTH OLD_COTERMINATE_DAY_MONTH, NEW_COTERMINATE_DAY_MONTH NEW_COTERMINATE_DAY_MONTH, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE, NEW_START_DATE_ACTIVE NEW_START_DATE_ACTIVE, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE, NEW_END_DATE_ACTIVE NEW_END_DATE_ACTIVE, OLD_AUTOCREATED_FROM_SYSTEM OLD_AUTOCREATED_FROM_SYSTEM, NEW_AUTOCREATED_FROM_SYSTEM NEW_AUTOCREATED_FROM_SYSTEM, OLD_CONFIG_SYSTEM_TYPE OLD_CONFIG_SYSTEM_TYPE, NEW_CONFIG_SYSTEM_TYPE NEW_CONFIG_SYSTEM_TYPE, OLD_NAME OLD_NAME, NEW_NAME NEW_NAME, OLD_DESCRIPTION OLD_DESCRIPTION, NEW_DESCRIPTION NEW_DESCRIPTION, OLD_CONTEXT OLD_CONTEXT, NEW_CONTEXT NEW_CONTEXT, OLD_ATTRIBUTE1 OLD_ATTRIBUTE1, NEW_ATTRIBUTE1 NEW_ATTRIBUTE1, OLD_ATTRIBUTE2 OLD_ATTRIBUTE2, NEW_ATTRIBUTE2 NEW_ATTRIBUTE2, OLD_ATTRIBUTE3 OLD_ATTRIBUTE3, NEW_ATTRIBUTE3 NEW_ATTRIBUTE3, OLD_ATTRIBUTE4 OLD_ATTRIBUTE4, NEW_ATTRIBUTE4 NEW_ATTRIBUTE4, OLD_ATTRIBUTE5 OLD_ATTRIBUTE5, NEW_ATTRIBUTE5 NEW_ATTRIBUTE5, OLD_ATTRIBUTE6 OLD_ATTRIBUTE6, NEW_ATTRIBUTE6 NEW_ATTRIBUTE6, OLD_ATTRIBUTE7 OLD_ATTRIBUTE7, NEW_ATTRIBUTE7 NEW_ATTRIBUTE7, OLD_ATTRIBUTE8 OLD_ATTRIBUTE8, NEW_ATTRIBUTE8 NEW_ATTRIBUTE8, OLD_ATTRIBUTE9 OLD_ATTRIBUTE9, NEW_ATTRIBUTE9 NEW_ATTRIBUTE9, OLD_ATTRIBUTE10 OLD_ATTRIBUTE10, NEW_ATTRIBUTE10 NEW_ATTRIBUTE10, OLD_ATTRIBUTE11 OLD_ATTRIBUTE11, NEW_ATTRIBUTE11 NEW_ATTRIBUTE11, OLD_ATTRIBUTE12 OLD_ATTRIBUTE12, NEW_ATTRIBUTE12 NEW_ATTRIBUTE12, OLD_ATTRIBUTE13 OLD_ATTRIBUTE13, NEW_ATTRIBUTE13 NEW_ATTRIBUTE13, OLD_ATTRIBUTE14 OLD_ATTRIBUTE14, NEW_ATTRIBUTE14 NEW_ATTRIBUTE14, OLD_ATTRIBUTE15 OLD_ATTRIBUTE15, NEW_ATTRIBUTE15 NEW_ATTRIBUTE15, FULL_DUMP_FLAG FULL_DUMP_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, MIGRATED_FLAG MIGRATED_FLAG, OLD_OPERATING_UNIT_ID OLD_OPERATING_UNIT_ID, NEW_OPERATING_UNIT_ID NEW_OPERATING_UNIT_ID from "CSI"."CSI_SYSTEMS_H"

View Text - HTML Formatted

SELECT SYSTEM_HISTORY_ID SYSTEM_HISTORY_ID
, SYSTEM_ID SYSTEM_ID
, TRANSACTION_ID TRANSACTION_ID
, OLD_CUSTOMER_ID OLD_CUSTOMER_ID
, NEW_CUSTOMER_ID NEW_CUSTOMER_ID
, OLD_SYSTEM_TYPE_CODE OLD_SYSTEM_TYPE_CODE
, NEW_SYSTEM_TYPE_CODE NEW_SYSTEM_TYPE_CODE
, OLD_SYSTEM_NUMBER OLD_SYSTEM_NUMBER
, NEW_SYSTEM_NUMBER NEW_SYSTEM_NUMBER
, OLD_PARENT_SYSTEM_ID OLD_PARENT_SYSTEM_ID
, NEW_PARENT_SYSTEM_ID NEW_PARENT_SYSTEM_ID
, OLD_SHIP_TO_CONTACT_ID OLD_SHIP_TO_CONTACT_ID
, NEW_SHIP_TO_CONTACT_ID NEW_SHIP_TO_CONTACT_ID
, OLD_BILL_TO_CONTACT_ID OLD_BILL_TO_CONTACT_ID
, NEW_BILL_TO_CONTACT_ID NEW_BILL_TO_CONTACT_ID
, OLD_TECHNICAL_CONTACT_ID OLD_TECHNICAL_CONTACT_ID
, NEW_TECHNICAL_CONTACT_ID NEW_TECHNICAL_CONTACT_ID
, OLD_SERVICE_ADMIN_CONTACT_ID OLD_SERVICE_ADMIN_CONTACT_ID
, NEW_SERVICE_ADMIN_CONTACT_ID NEW_SERVICE_ADMIN_CONTACT_ID
, OLD_SHIP_TO_SITE_USE_ID OLD_SHIP_TO_SITE_USE_ID
, NEW_SHIP_TO_SITE_USE_ID NEW_SHIP_TO_SITE_USE_ID
, OLD_INSTALL_SITE_USE_ID OLD_INSTALL_SITE_USE_ID
, NEW_INSTALL_SITE_USE_ID NEW_INSTALL_SITE_USE_ID
, OLD_BILL_TO_SITE_USE_ID OLD_BILL_TO_SITE_USE_ID
, NEW_BILL_TO_SITE_USE_ID NEW_BILL_TO_SITE_USE_ID
, OLD_COTERMINATE_DAY_MONTH OLD_COTERMINATE_DAY_MONTH
, NEW_COTERMINATE_DAY_MONTH NEW_COTERMINATE_DAY_MONTH
, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE
, NEW_START_DATE_ACTIVE NEW_START_DATE_ACTIVE
, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE
, NEW_END_DATE_ACTIVE NEW_END_DATE_ACTIVE
, OLD_AUTOCREATED_FROM_SYSTEM OLD_AUTOCREATED_FROM_SYSTEM
, NEW_AUTOCREATED_FROM_SYSTEM NEW_AUTOCREATED_FROM_SYSTEM
, OLD_CONFIG_SYSTEM_TYPE OLD_CONFIG_SYSTEM_TYPE
, NEW_CONFIG_SYSTEM_TYPE NEW_CONFIG_SYSTEM_TYPE
, OLD_NAME OLD_NAME
, NEW_NAME NEW_NAME
, OLD_DESCRIPTION OLD_DESCRIPTION
, NEW_DESCRIPTION NEW_DESCRIPTION
, OLD_CONTEXT OLD_CONTEXT
, NEW_CONTEXT NEW_CONTEXT
, OLD_ATTRIBUTE1 OLD_ATTRIBUTE1
, NEW_ATTRIBUTE1 NEW_ATTRIBUTE1
, OLD_ATTRIBUTE2 OLD_ATTRIBUTE2
, NEW_ATTRIBUTE2 NEW_ATTRIBUTE2
, OLD_ATTRIBUTE3 OLD_ATTRIBUTE3
, NEW_ATTRIBUTE3 NEW_ATTRIBUTE3
, OLD_ATTRIBUTE4 OLD_ATTRIBUTE4
, NEW_ATTRIBUTE4 NEW_ATTRIBUTE4
, OLD_ATTRIBUTE5 OLD_ATTRIBUTE5
, NEW_ATTRIBUTE5 NEW_ATTRIBUTE5
, OLD_ATTRIBUTE6 OLD_ATTRIBUTE6
, NEW_ATTRIBUTE6 NEW_ATTRIBUTE6
, OLD_ATTRIBUTE7 OLD_ATTRIBUTE7
, NEW_ATTRIBUTE7 NEW_ATTRIBUTE7
, OLD_ATTRIBUTE8 OLD_ATTRIBUTE8
, NEW_ATTRIBUTE8 NEW_ATTRIBUTE8
, OLD_ATTRIBUTE9 OLD_ATTRIBUTE9
, NEW_ATTRIBUTE9 NEW_ATTRIBUTE9
, OLD_ATTRIBUTE10 OLD_ATTRIBUTE10
, NEW_ATTRIBUTE10 NEW_ATTRIBUTE10
, OLD_ATTRIBUTE11 OLD_ATTRIBUTE11
, NEW_ATTRIBUTE11 NEW_ATTRIBUTE11
, OLD_ATTRIBUTE12 OLD_ATTRIBUTE12
, NEW_ATTRIBUTE12 NEW_ATTRIBUTE12
, OLD_ATTRIBUTE13 OLD_ATTRIBUTE13
, NEW_ATTRIBUTE13 NEW_ATTRIBUTE13
, OLD_ATTRIBUTE14 OLD_ATTRIBUTE14
, NEW_ATTRIBUTE14 NEW_ATTRIBUTE14
, OLD_ATTRIBUTE15 OLD_ATTRIBUTE15
, NEW_ATTRIBUTE15 NEW_ATTRIBUTE15
, FULL_DUMP_FLAG FULL_DUMP_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
, MIGRATED_FLAG MIGRATED_FLAG
, OLD_OPERATING_UNIT_ID OLD_OPERATING_UNIT_ID
, NEW_OPERATING_UNIT_ID NEW_OPERATING_UNIT_ID
FROM "CSI"."CSI_SYSTEMS_H"