VIEW: AR.RA_CONTACT_PHONES_INT_ALL#

Source

View Text - Preformatted

select ORIG_SYSTEM_CONTACT_REF ORIG_SYSTEM_CONTACT_REF, ORIG_SYSTEM_TELEPHONE_REF ORIG_SYSTEM_TELEPHONE_REF, ORIG_SYSTEM_CUSTOMER_REF ORIG_SYSTEM_CUSTOMER_REF, ORIG_SYSTEM_ADDRESS_REF ORIG_SYSTEM_ADDRESS_REF, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG, CONTACT_FIRST_NAME CONTACT_FIRST_NAME, CONTACT_LAST_NAME CONTACT_LAST_NAME, CONTACT_TITLE CONTACT_TITLE, CONTACT_JOB_TITLE CONTACT_JOB_TITLE, TELEPHONE TELEPHONE, TELEPHONE_EXTENSION TELEPHONE_EXTENSION, TELEPHONE_TYPE TELEPHONE_TYPE, INTERFACE_STATUS INTERFACE_STATUS, REQUEST_ID REQUEST_ID, TELEPHONE_AREA_CODE TELEPHONE_AREA_CODE, VALIDATED_FLAG VALIDATED_FLAG, CONTACT_ATTRIBUTE1 CONTACT_ATTRIBUTE1, CONTACT_ATTRIBUTE10 CONTACT_ATTRIBUTE10, CONTACT_ATTRIBUTE2 CONTACT_ATTRIBUTE2, CONTACT_ATTRIBUTE3 CONTACT_ATTRIBUTE3, CONTACT_ATTRIBUTE4 CONTACT_ATTRIBUTE4, CONTACT_ATTRIBUTE5 CONTACT_ATTRIBUTE5, CONTACT_ATTRIBUTE6 CONTACT_ATTRIBUTE6, CONTACT_ATTRIBUTE7 CONTACT_ATTRIBUTE7, CONTACT_ATTRIBUTE8 CONTACT_ATTRIBUTE8, CONTACT_ATTRIBUTE9 CONTACT_ATTRIBUTE9, CONTACT_ATTRIBUTE_CATEGORY CONTACT_ATTRIBUTE_CATEGORY, PHONE_ATTRIBUTE1 PHONE_ATTRIBUTE1, PHONE_ATTRIBUTE10 PHONE_ATTRIBUTE10, PHONE_ATTRIBUTE2 PHONE_ATTRIBUTE2, PHONE_ATTRIBUTE3 PHONE_ATTRIBUTE3, PHONE_ATTRIBUTE4 PHONE_ATTRIBUTE4, PHONE_ATTRIBUTE5 PHONE_ATTRIBUTE5, PHONE_ATTRIBUTE6 PHONE_ATTRIBUTE6, PHONE_ATTRIBUTE7 PHONE_ATTRIBUTE7, PHONE_ATTRIBUTE8 PHONE_ATTRIBUTE8, PHONE_ATTRIBUTE9 PHONE_ATTRIBUTE9, PHONE_ATTRIBUTE_CATEGORY PHONE_ATTRIBUTE_CATEGORY, CONTACT_ATTRIBUTE11 CONTACT_ATTRIBUTE11, CONTACT_ATTRIBUTE12 CONTACT_ATTRIBUTE12, CONTACT_ATTRIBUTE13 CONTACT_ATTRIBUTE13, CONTACT_ATTRIBUTE14 CONTACT_ATTRIBUTE14, CONTACT_ATTRIBUTE15 CONTACT_ATTRIBUTE15, PHONE_ATTRIBUTE11 PHONE_ATTRIBUTE11, PHONE_ATTRIBUTE12 PHONE_ATTRIBUTE12, PHONE_ATTRIBUTE13 PHONE_ATTRIBUTE13, PHONE_ATTRIBUTE14 PHONE_ATTRIBUTE14, PHONE_ATTRIBUTE15 PHONE_ATTRIBUTE15, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, CONTACT_ATTRIBUTE16 CONTACT_ATTRIBUTE16, CONTACT_ATTRIBUTE17 CONTACT_ATTRIBUTE17, CONTACT_ATTRIBUTE18 CONTACT_ATTRIBUTE18, CONTACT_ATTRIBUTE19 CONTACT_ATTRIBUTE19, CONTACT_ATTRIBUTE20 CONTACT_ATTRIBUTE20, CONTACT_ATTRIBUTE21 CONTACT_ATTRIBUTE21, CONTACT_ATTRIBUTE22 CONTACT_ATTRIBUTE22, CONTACT_ATTRIBUTE23 CONTACT_ATTRIBUTE23, CONTACT_ATTRIBUTE24 CONTACT_ATTRIBUTE24, CONTACT_ATTRIBUTE25 CONTACT_ATTRIBUTE25, SEX_CODE SEX_CODE, SALUTATION SALUTATION, EMAIL_ADDRESS EMAIL_ADDRESS, MAIL_STOP MAIL_STOP, CONTACT_KEY CONTACT_KEY, ORG_ID ORG_ID, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE, CONTACT_JOB_TITLE_CODE CONTACT_JOB_TITLE_CODE, CONTACT_POINT_TYPE CONTACT_POINT_TYPE from "AR"."RA_CONTACT_PHONES_INT_ALL"

View Text - HTML Formatted

SELECT ORIG_SYSTEM_CONTACT_REF ORIG_SYSTEM_CONTACT_REF
, ORIG_SYSTEM_TELEPHONE_REF ORIG_SYSTEM_TELEPHONE_REF
, ORIG_SYSTEM_CUSTOMER_REF ORIG_SYSTEM_CUSTOMER_REF
, ORIG_SYSTEM_ADDRESS_REF ORIG_SYSTEM_ADDRESS_REF
, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG
, CONTACT_FIRST_NAME CONTACT_FIRST_NAME
, CONTACT_LAST_NAME CONTACT_LAST_NAME
, CONTACT_TITLE CONTACT_TITLE
, CONTACT_JOB_TITLE CONTACT_JOB_TITLE
, TELEPHONE TELEPHONE
, TELEPHONE_EXTENSION TELEPHONE_EXTENSION
, TELEPHONE_TYPE TELEPHONE_TYPE
, INTERFACE_STATUS INTERFACE_STATUS
, REQUEST_ID REQUEST_ID
, TELEPHONE_AREA_CODE TELEPHONE_AREA_CODE
, VALIDATED_FLAG VALIDATED_FLAG
, CONTACT_ATTRIBUTE1 CONTACT_ATTRIBUTE1
, CONTACT_ATTRIBUTE10 CONTACT_ATTRIBUTE10
, CONTACT_ATTRIBUTE2 CONTACT_ATTRIBUTE2
, CONTACT_ATTRIBUTE3 CONTACT_ATTRIBUTE3
, CONTACT_ATTRIBUTE4 CONTACT_ATTRIBUTE4
, CONTACT_ATTRIBUTE5 CONTACT_ATTRIBUTE5
, CONTACT_ATTRIBUTE6 CONTACT_ATTRIBUTE6
, CONTACT_ATTRIBUTE7 CONTACT_ATTRIBUTE7
, CONTACT_ATTRIBUTE8 CONTACT_ATTRIBUTE8
, CONTACT_ATTRIBUTE9 CONTACT_ATTRIBUTE9
, CONTACT_ATTRIBUTE_CATEGORY CONTACT_ATTRIBUTE_CATEGORY
, PHONE_ATTRIBUTE1 PHONE_ATTRIBUTE1
, PHONE_ATTRIBUTE10 PHONE_ATTRIBUTE10
, PHONE_ATTRIBUTE2 PHONE_ATTRIBUTE2
, PHONE_ATTRIBUTE3 PHONE_ATTRIBUTE3
, PHONE_ATTRIBUTE4 PHONE_ATTRIBUTE4
, PHONE_ATTRIBUTE5 PHONE_ATTRIBUTE5
, PHONE_ATTRIBUTE6 PHONE_ATTRIBUTE6
, PHONE_ATTRIBUTE7 PHONE_ATTRIBUTE7
, PHONE_ATTRIBUTE8 PHONE_ATTRIBUTE8
, PHONE_ATTRIBUTE9 PHONE_ATTRIBUTE9
, PHONE_ATTRIBUTE_CATEGORY PHONE_ATTRIBUTE_CATEGORY
, CONTACT_ATTRIBUTE11 CONTACT_ATTRIBUTE11
, CONTACT_ATTRIBUTE12 CONTACT_ATTRIBUTE12
, CONTACT_ATTRIBUTE13 CONTACT_ATTRIBUTE13
, CONTACT_ATTRIBUTE14 CONTACT_ATTRIBUTE14
, CONTACT_ATTRIBUTE15 CONTACT_ATTRIBUTE15
, PHONE_ATTRIBUTE11 PHONE_ATTRIBUTE11
, PHONE_ATTRIBUTE12 PHONE_ATTRIBUTE12
, PHONE_ATTRIBUTE13 PHONE_ATTRIBUTE13
, PHONE_ATTRIBUTE14 PHONE_ATTRIBUTE14
, PHONE_ATTRIBUTE15 PHONE_ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, CONTACT_ATTRIBUTE16 CONTACT_ATTRIBUTE16
, CONTACT_ATTRIBUTE17 CONTACT_ATTRIBUTE17
, CONTACT_ATTRIBUTE18 CONTACT_ATTRIBUTE18
, CONTACT_ATTRIBUTE19 CONTACT_ATTRIBUTE19
, CONTACT_ATTRIBUTE20 CONTACT_ATTRIBUTE20
, CONTACT_ATTRIBUTE21 CONTACT_ATTRIBUTE21
, CONTACT_ATTRIBUTE22 CONTACT_ATTRIBUTE22
, CONTACT_ATTRIBUTE23 CONTACT_ATTRIBUTE23
, CONTACT_ATTRIBUTE24 CONTACT_ATTRIBUTE24
, CONTACT_ATTRIBUTE25 CONTACT_ATTRIBUTE25
, SEX_CODE SEX_CODE
, SALUTATION SALUTATION
, EMAIL_ADDRESS EMAIL_ADDRESS
, MAIL_STOP MAIL_STOP
, CONTACT_KEY CONTACT_KEY
, ORG_ID ORG_ID
, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, CONTACT_JOB_TITLE_CODE CONTACT_JOB_TITLE_CODE
, CONTACT_POINT_TYPE CONTACT_POINT_TYPE
FROM "AR"."RA_CONTACT_PHONES_INT_ALL"