SELECT REL.RELATIONSHIP_ID , OPARTY.PARTY_NAME , REL.OBJECT_ID , SPARTY.PARTY_NAME , REL.SUBJECT_ID , REL.PARTY_ID , REL.RELATIONSHIP_CODE , REL.START_DATE , REL.END_DATE , REL.LAST_UPDATE_DATE , PARTY.LAST_UPDATE_DATE FROM HZ_RELATIONSHIPS REL , HZ_PARTIES SPARTY , HZ_PARTIES OPARTY , HZ_PARTIES PARTY WHERE REL.SUBJECT_ID = SPARTY.PARTY_ID AND SPARTY.PARTY_TYPE = 'ORGANIZATION' AND REL.OBJECT_ID = OPARTY.PARTY_ID AND OPARTY.PARTY_TYPE = 'ORGANIZATION' AND REL.PARTY_ID = PARTY.PARTY_ID AND REL.STATUS = 'A' AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.DIRECTIONAL_FLAG = 'F' AND SPARTY.STATUS IN ('A' , 'I') AND OPARTY.STATUS IN ('A' , 'I') AND PARTY.STATUS IN ('A' , 'I')