SELECT A.USER_ID , A.RESOURCE_ID , A.CONTACT_ID , A.CATEGORY , C.RELATIONSHIP_CODE , D.PARTY_ID , D.PARTY_NAME , E.PARTY_ID , E.PARTY_NAME FROM JTF_RS_RESOURCE_EXTNS A , HZ_ORG_CONTACTS B , HZ_RELATIONSHIPS C , HZ_PARTIES D , HZ_PARTIES E WHERE A.CONTACT_ID IS NOT NULL AND B.ORG_CONTACT_ID = A.CONTACT_ID AND C.RELATIONSHIP_ID = B.PARTY_RELATIONSHIP_ID AND D.PARTY_ID = C.SUBJECT_ID AND E.PARTY_ID = C.OBJECT_ID AND C.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND C.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND C.DIRECTIONAL_FLAG = 'F'