SELECT PAR.PARTY_NAME , PAR.PERSON_LAST_NAME , PAR.PARTY_ID , PAR.PARTY_TYPE , REL.STATUS , REL.PARTY_ID , REL.SUBJECT_ID , REL.OBJECT_ID , AR.MEANING FROM HZ_RELATIONSHIPS REL , HZ_PARTIES PAR , AR_LOOKUPS AR WHERE AR.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE' AND AR.LOOKUP_CODE = REL.RELATIONSHIP_CODE AND REL.OBJECT_ID = PAR.PARTY_ID AND REL.STATUS IN ('A' , 'I') AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND PAR.STATUS IN ('A' , 'I')