Product: | AS - Sales Foundation |
---|---|
Description: | Contacts view |
Implementation/DBA Data: | Not implemented in this database |
SELECT CONT1.ROWID
, CONT1.CONTACT_ID
, CONT1.LAST_UPDATE_DATE
, CONT1.LAST_UPDATED_BY
, CONT1.CREATION_DATE
, CONT1.CREATED_BY
, CONT1.LAST_UPDATE_LOGIN
, CONT1.REQUEST_ID
, CONT1.PROGRAM_APPLICATION_ID
, CONT1.PROGRAM_ID
, CONT1.PROGRAM_UPDATE_DATE
, CONT1.CUSTOMER_ID
, CONT1.ADDRESS_ID
, CONT1.TITLE
, CONT1.CONTACT_NUMBER
, CONT1.FIRST_NAME
, CONT1.LAST_NAME
, CONT1.STATUS
, CONT1.SUFFIX
, CONT1.SALUTATION
, CONT1.SEX_CODE
, CONT1.JOB_TITLE
, CONT1.JOB_TITLE_CODE
, CONT1.EMAIL_ADDRESS
, CONT1.DO_NOT_MAIL_FLAG
, CONT1.MAIL_STOP
, CONT1.NATIVE_LANGUAGE
, CONT1.OTHER_LANGUAGE_1
, CONT1.OTHER_LANGUAGE_2
, CONT1.DECISION_MAKER_FLAG
, CONT1.MANAGED_BY
, CONT1.CONTACT_PERSONAL_INFORMATION
, CONT1.RANK
, CONT1.REFERENCE_USE_FLAG
, CONT1.ORIG_SYSTEM_REFERENCE
, CONT1.PRIMARY_ROLE
, CONT1.CONTACT_KEY
, CONT1.MATCH_GROUP_ID
, CONT1.MAILING_ADDRESS_ID
, ARLKP1.MEANING
, ARLKP3.MEANING
, ASLKP1.MEANING
, ASLKP2.MEANING
, ASLKP4.MEANING
, CONT2.FIRST_NAME
, CONT2.LAST_NAME
, ARLKP2.MEANING
, CONT1.DEPARTMENT_CODE
, CONT1.DEPARTMENT
, ARLKP5.MEANING
, CONT1.ATTRIBUTE_CATEGORY
, CONT1.ATTRIBUTE1
, CONT1.ATTRIBUTE2
, CONT1.ATTRIBUTE3
, CONT1.ATTRIBUTE4
, CONT1.ATTRIBUTE5
, CONT1.ATTRIBUTE6
, CONT1.ATTRIBUTE7
, CONT1.ATTRIBUTE8
, CONT1.ATTRIBUTE9
, CONT1.ATTRIBUTE10
, CONT1.ATTRIBUTE11
, CONT1.ATTRIBUTE12
, CONT1.ATTRIBUTE13
, CONT1.ATTRIBUTE14
, CONT1.ATTRIBUTE15
, CONT1.ATTRIBUTE16
, CONT1.ATTRIBUTE17
, CONT1.ATTRIBUTE18
, CONT1.ATTRIBUTE19
, CONT1.ATTRIBUTE20
, CONT1.ATTRIBUTE21
, CONT1.ATTRIBUTE22
, CONT1.ATTRIBUTE23
, CONT1.ATTRIBUTE24
, CONT1.ATTRIBUTE25
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, CONT1.ADDRESS_ID
FROM AS_LOOKUPS ASLKP1
, AS_LOOKUPS ASLKP2
, AS_LOOKUPS ASLKP4
, AR_LOOKUPS ARLKP1
, AR_LOOKUPS ARLKP2
, AR_LOOKUPS ARLKP3
, AR_LOOKUPS ARLKP5
, RA_CUSTOMERS CUST
, RA_CONTACTS CONT2
, RA_CONTACTS CONT1
WHERE (CONT1.TITLE = ARLKP1.LOOKUP_CODE(+)
AND ARLKP1.LOOKUP_TYPE(+) = 'CONTACT_TITLE')
AND ( CONT1.JOB_TITLE_CODE = ARLKP3.LOOKUP_CODE(+)
AND ARLKP3.LOOKUP_TYPE(+) = 'RESPONSIBILITY')
AND ( CONT1.NATIVE_LANGUAGE = ASLKP1.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) = 'LANGUAGE' )
AND ( CONT1.OTHER_LANGUAGE_1 = ASLKP2.LOOKUP_CODE(+)
AND ASLKP2.LOOKUP_TYPE(+) = 'LANGUAGE' )
AND ( CONT1.OTHER_LANGUAGE_2 = ASLKP4.LOOKUP_CODE(+)
AND ASLKP4.LOOKUP_TYPE(+) = 'LANGUAGE' )
AND ( CONT1.RANK = ARLKP2.LOOKUP_CODE(+)
AND ARLKP2.LOOKUP_TYPE(+) = 'RANK' )
AND ( CONT1.DEPARTMENT_CODE = ARLKP5.LOOKUP_CODE(+)
AND ARLKP5.LOOKUP_TYPE(+) = 'DEPARTMENT' )
AND CONT1.MANAGED_BY = CONT2.CONTACT_ID(+)
AND CONT1.CUSTOMER_ID = CUST.CUSTOMER_ID