SELECT
HP1.PARTY_NAME,
HP1.ADDRESS1,HP1.ADDRESS2,
HP1.CITY,
HP1.STATE,
HP1.COUNTRY,
HOC.JOB_TITLE,
HOC.JOB_TITLE_CODE
FROM FUSION.HZ_RELATIONSHIPS HR,
FUSION.HZ_PARTIES HP,
FUSION.HZ_CUST_ACCOUNTS HCA,
FUSION.HZ_PARTIES HP1,
FUSION.HZ_ORG_CONTACTS HOC
WHERE HR.SUBJECT_ID = HP.PARTY_ID
AND HP.PARTY_ID = HCA.PARTY_ID
AND HR.OBJECT_TYPE = 'PERSON'
AND HR.OBJECT_ID = HP1.PARTY_ID
AND HR.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
AND HCA.ACCOUNT_NUMBER = :ACCOUNT_NUMBER;