Customer Contact Information - Org Contacts

SELECT hzo.CONTACT_NUMBER,
       hzporg.PARTY_NUMBER,
       hzporg.PARTY_NAME,
       hzporg.PARTY_TYPE,
       hzr.subject_id,
       hzo.ORG_CONTACT_ID,
       hZp.Person_last_name,
       hZp.person_first_name,
       hZp.party_number,
       hZp.party_name,
       hZp.status,
       hZp.email_address,
       hzp.party_id
FROM fusion.HZ_RELATIONSHIPS HZR,
     fusion.hz_parties hzp,
     fusion.hz_ORG_CONTACTS hzo,
     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
  AND hzo.PARTY_RELATIONSHIP_ID = HZR.Relationship_id
ORDER BY hzporg.PARTY_NAME,
         hZp.Person_last_name,
         hZp.person_first_name;