[Home] [Help]
View: AST_L_CONTACT_POINTS_V
View Text
SELECT CONT.PARTY_ID
, PHONE.CONTACT_POINT_ID
, CONT.PARTY_ID
, PHONE.CONTACT_POINT_ID
, PHONE.CONTACT_POINT_TYPE
, CONT.EMAIL_ADDRESS
, PHONE.PHONE_LINE_TYPE
, PHONE.PHONE_AREA_CODE
, PHONE.PHONE_NUMBER
, PHONE.PHONE_EXTENSION
FROM AS_PARTY_CONTACTS_V CONT
, HZ_CONTACT_POINTS PHONE
WHERE PHONE.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND PHONE.OWNER_TABLE_ID = CONT.PARTY_ID
Columns
Name |
CUSTOMER_ID |
PHONE_ID |
PARTY_ID |
CONTACT_POINT_ID |
CONTACT_POINT_TYPE |
EMAIL_ADDRESS |
PHONE_TYPE |
AREA_CODE |
PHONE_NUMBER |
EXTENSION |