VIEW: CS.CS_HZ_SR_CONTACT_POINTS#

Source

View Text - Preformatted

select SR_CONTACT_POINT_ID SR_CONTACT_POINT_ID, PARTY_ID PARTY_ID, INCIDENT_ID INCIDENT_ID, CONTACT_POINT_TYPE CONTACT_POINT_TYPE, CONTACT_POINT_ID CONTACT_POINT_ID, PRIMARY_FLAG PRIMARY_FLAG, CONTACT_TYPE CONTACT_TYPE, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PARTY_ROLE_CODE PARTY_ROLE_CODE, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE from "CS"."CS_HZ_SR_CONTACT_POINTS"

View Text - HTML Formatted

SELECT SR_CONTACT_POINT_ID SR_CONTACT_POINT_ID
, PARTY_ID PARTY_ID
, INCIDENT_ID INCIDENT_ID
, CONTACT_POINT_TYPE CONTACT_POINT_TYPE
, CONTACT_POINT_ID CONTACT_POINT_ID
, PRIMARY_FLAG PRIMARY_FLAG
, CONTACT_TYPE CONTACT_TYPE
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PARTY_ROLE_CODE PARTY_ROLE_CODE
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
FROM "CS"."CS_HZ_SR_CONTACT_POINTS"