Query to find iSupplier Users list

Query to find iSupplier Users list


SELECT WEB_USER_ID, USR.USER_NAME, USR.EMAIL_ADDRESS, AP_SUPP.VENDOR_NAME
  FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_SUPPLIERS AP_SUPP, FND_USER USR
 WHERE ATTRIBUTE_CODE = 'ICX_SUPPLIER_ORG_ID'
   AND ATTRIBUTE_APPLICATION_ID = 177
   AND NUMBER_VALUE = AP_SUPP.VENDOR_ID
   AND USR.USER_ID = A.WEB_USER_ID;