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
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
|
|
|