Customer Contact Information - Relationships

SELECT hzporg.PARTY_NUMBER,
       hzporg.PARTY_NAME,
       hzporg.PARTY_TYPE,
       hZp.Person_last_name,
       hZp.person_first_name,
       hZp.party_number,
       hZp.party_name,
       hZp.status,
       hZp.email_address
FROM fusion.HZ_RELATIONSHIPS HZR,
     fusion.hz_parties hzp,
     fusion.HZ_PARTIES hzpORG
WHERE HZR.OBJECT_id = hzp.party_id
  AND upper(hzp.party_name) LIKE upper('%&PARTY_NAME%')
  AND hzp.party_type = 'PERSON'
  AND hzr.relationship_code = 'CONTACT'
  AND hzr.subject_id = hzporg.party_id
ORDER BY hzporg.PARTY_NAME,
         hZp.Person_last_name,
         hZp.person_first_name;