Product: | ICX - Oracle iProcurement |
---|---|
Description: | Customer Contacts View |
Implementation/DBA Data: | Not implemented in this database |
SELECT "CONTACT_ID"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "CREATION_DATE"
, "CREATED_BY"
, "CUSTOMER_ID"
, "STATUS"
, "ORIG_SYSTEM_REFERENCE"
, "LAST_NAME"
, "LAST_UPDATE_LOGIN"
, "TITLE"
, "FIRST_NAME"
, "JOB_TITLE"
, "MAIL_STOP"
, "ADDRESS_ID"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "CONTACT_KEY"
, "CONTACT_PERSONAL_INFORMATION"
, "DECISION_MAKER_FLAG"
, "JOB_TITLE_CODE"
, "MANAGED_BY"
, "NATIVE_LANGUAGE"
, "REFERENCE_USE_FLAG"
, "CONTACT_NUMBER"
, "ATTRIBUTE11"
, "ATTRIBUTE25"
, "OTHER_LANGUAGE_1"
, "OTHER_LANGUAGE_2"
, "RANK"
, "PRIMARY_ROLE"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "ATTRIBUTE16"
, "ATTRIBUTE17"
, "ATTRIBUTE18"
, "ATTRIBUTE19"
, "ATTRIBUTE20"
, "ATTRIBUTE21"
, "ATTRIBUTE22"
, "ATTRIBUTE23"
, "ATTRIBUTE24"
, "DO_NOT_MAIL_FLAG"
, "SUFFIX"
, "EMAIL_ADDRESS"
, "MAILING_ADDRESS_ID"
, "MATCH_GROUP_ID"
FROM RA_CONTACTS