[Home] [Help]
View: BIC_CONTACTS_V
Product: | BIC - Customer Intelligence (obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PA.PARTY_ID PARTY_ID
, PA.PERSON_LAST_NAME||' '||PA.PERSON_FIRST_NAME CONTACT_NAME
, CPP.PHONE_AREA_CODE||'-'||CPP.PHONE_NUMBER CONTACT_PHONE
, CPE.EMAIL_ADDRESS CONTACT_EMAIL
, AD.ADDRESS PRIMARY_ADDRESS
FROM HZ_PARTIES PA
, HZ_PARTY_SITES PS
, BIC_ADDRESS_V AD
, HZ_CONTACT_POINTS CPP
, HZ_CONTACT_POINTS CPE
WHERE PA.PARTY_TYPE = 'PERSON'
AND PA.PARTY_ID = PS.PARTY_ID (+)
AND PS.IDENTIFYING_ADDRESS_FLAG (+) = 'Y'
AND PS.LOCATION_ID = AD.LOCATION_ID (+)
AND CPP.OWNER_TABLE_ID (+) = PA.PARTY_ID
AND CPP.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
AND CPP.CONTACT_POINT_TYPE (+) = 'PHONE'
AND CPE.OWNER_TABLE_ID (+) = PA.PARTY_ID
AND CPE.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
AND CPE.CONTACT_POINT_TYPE (+) = 'EMAIL' WITH READ ONLY
Columns
Name |
PARTY_ID |
CONTACT_NAME |
CONTACT_PHONE |
CONTACT_EMAIL |
PRIMARY_ADDRESS |