SELECT DISTINCT FU.USER_NAME AS USER_NAME , FU.USER_ID AS USER_ID , ASA.VENDOR_ID AS VENDOR_ID FROM FND_USER FU , AP_SUPPLIER_CONTACTS AC , AP_SUPPLIERS ASA , HZ_RELATIONSHIPS HR WHERE FU.PERSON_PARTY_ID = AC.PER_PARTY_ID AND HR.RELATIONSHIP_ID = AC.RELATIONSHIP_ID AND HR.OBJECT_ID = ASA.PARTY_ID