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_HZ_SR_CONTACT_PNTS_AUDIT#

Source

View Text - Preformatted


select SR_CONTACT_POINT_AUDIT_ID SR_CONTACT_POINT_AUDIT_ID, SR_CONTACT_POINT_ID SR_CONTACT_POINT_ID, INCIDENT_ID INCIDENT_ID, PARTY_ID PARTY_ID, OLD_PARTY_ID OLD_PARTY_ID, PRIMARY_FLAG PRIMARY_FLAG, OLD_PRIMARY_FLAG OLD_PRIMARY_FLAG, CONTACT_TYPE CONTACT_TYPE, OLD_CONTACT_TYPE OLD_CONTACT_TYPE, CONTACT_POINT_TYPE CONTACT_POINT_TYPE, OLD_CONTACT_POINT_TYPE OLD_CONTACT_POINT_TYPE, CONTACT_POINT_ID CONTACT_POINT_ID, OLD_CONTACT_POINT_ID OLD_CONTACT_POINT_ID, CONTACT_POINT_MODIFIED_BY CONTACT_POINT_MODIFIED_BY, CONTACT_POINT_MODIFIED_ON CONTACT_POINT_MODIFIED_ON, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PARTY_ROLE_CODE PARTY_ROLE_CODE, OLD_PARTY_ROLE_CODE OLD_PARTY_ROLE_CODE, START_DATE_ACTIVE START_DATE_ACTIVE, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "CS"."CS_HZ_SR_CONTACT_PNTS_AUDIT"

View Text - HTML Formatted

SELECT SR_CONTACT_POINT_AUDIT_ID SR_CONTACT_POINT_AUDIT_ID
, SR_CONTACT_POINT_ID SR_CONTACT_POINT_ID
, INCIDENT_ID INCIDENT_ID
, PARTY_ID PARTY_ID
, OLD_PARTY_ID OLD_PARTY_ID
, PRIMARY_FLAG PRIMARY_FLAG
, OLD_PRIMARY_FLAG OLD_PRIMARY_FLAG
, CONTACT_TYPE CONTACT_TYPE
, OLD_CONTACT_TYPE OLD_CONTACT_TYPE
, CONTACT_POINT_TYPE CONTACT_POINT_TYPE
, OLD_CONTACT_POINT_TYPE OLD_CONTACT_POINT_TYPE
, CONTACT_POINT_ID CONTACT_POINT_ID
, OLD_CONTACT_POINT_ID OLD_CONTACT_POINT_ID
, CONTACT_POINT_MODIFIED_BY CONTACT_POINT_MODIFIED_BY
, CONTACT_POINT_MODIFIED_ON CONTACT_POINT_MODIFIED_ON
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PARTY_ROLE_CODE PARTY_ROLE_CODE
, OLD_PARTY_ROLE_CODE OLD_PARTY_ROLE_CODE
, START_DATE_ACTIVE START_DATE_ACTIVE
, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "CS"."CS_HZ_SR_CONTACT_PNTS_AUDIT"