VIEW: AR.RA_CONTACTS#

Source

View Text - Preformatted

select CONTACT_ID CONTACT_ID, DEPARTMENT_CODE DEPARTMENT_CODE, DEPARTMENT DEPARTMENT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, CUSTOMER_ID CUSTOMER_ID, STATUS STATUS, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, LAST_NAME LAST_NAME, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TITLE TITLE, FIRST_NAME FIRST_NAME, JOB_TITLE JOB_TITLE, MAIL_STOP MAIL_STOP, ADDRESS_ID ADDRESS_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CONTACT_KEY CONTACT_KEY, CONTACT_PERSONAL_INFORMATION CONTACT_PERSONAL_INFORMATION, DECISION_MAKER_FLAG DECISION_MAKER_FLAG, JOB_TITLE_CODE JOB_TITLE_CODE, MANAGED_BY MANAGED_BY, NATIVE_LANGUAGE NATIVE_LANGUAGE, REFERENCE_USE_FLAG REFERENCE_USE_FLAG, CONTACT_NUMBER CONTACT_NUMBER, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE25 ATTRIBUTE25, OTHER_LANGUAGE_1 OTHER_LANGUAGE_1, OTHER_LANGUAGE_2 OTHER_LANGUAGE_2, RANK RANK, PRIMARY_ROLE PRIMARY_ROLE, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, DO_NOT_MAIL_FLAG DO_NOT_MAIL_FLAG, SUFFIX SUFFIX, EMAIL_ADDRESS EMAIL_ADDRESS, MAILING_ADDRESS_ID MAILING_ADDRESS_ID, MATCH_GROUP_ID MATCH_GROUP_ID, SEX_CODE SEX_CODE, SALUTATION SALUTATION, LAST_NAME_ALT LAST_NAME_ALT, FIRST_NAME_ALT FIRST_NAME_ALT, DO_NOT_EMAIL_FLAG DO_NOT_EMAIL_FLAG from "AR"."RA_CONTACTS"

View Text - HTML Formatted

SELECT CONTACT_ID CONTACT_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, DEPARTMENT DEPARTMENT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, CUSTOMER_ID CUSTOMER_ID
, STATUS STATUS
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, LAST_NAME LAST_NAME
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TITLE TITLE
, FIRST_NAME FIRST_NAME
, JOB_TITLE JOB_TITLE
, MAIL_STOP MAIL_STOP
, ADDRESS_ID ADDRESS_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CONTACT_KEY CONTACT_KEY
, CONTACT_PERSONAL_INFORMATION CONTACT_PERSONAL_INFORMATION
, DECISION_MAKER_FLAG DECISION_MAKER_FLAG
, JOB_TITLE_CODE JOB_TITLE_CODE
, MANAGED_BY MANAGED_BY
, NATIVE_LANGUAGE NATIVE_LANGUAGE
, REFERENCE_USE_FLAG REFERENCE_USE_FLAG
, CONTACT_NUMBER CONTACT_NUMBER
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE25 ATTRIBUTE25
, OTHER_LANGUAGE_1 OTHER_LANGUAGE_1
, OTHER_LANGUAGE_2 OTHER_LANGUAGE_2
, RANK RANK
, PRIMARY_ROLE PRIMARY_ROLE
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, DO_NOT_MAIL_FLAG DO_NOT_MAIL_FLAG
, SUFFIX SUFFIX
, EMAIL_ADDRESS EMAIL_ADDRESS
, MAILING_ADDRESS_ID MAILING_ADDRESS_ID
, MATCH_GROUP_ID MATCH_GROUP_ID
, SEX_CODE SEX_CODE
, SALUTATION SALUTATION
, LAST_NAME_ALT LAST_NAME_ALT
, FIRST_NAME_ALT FIRST_NAME_ALT
, DO_NOT_EMAIL_FLAG DO_NOT_EMAIL_FLAG
FROM "AR"."RA_CONTACTS"