Report to find which users of Expense module have a banking address

Summary

Report to find which users of Expense module have a banking address

Content

Hello,

I need to write a BI Publisher report that lists all users that have access to the Expense module and if they have a banking address set up. Does anyone know which database tables I would use for this? I have found per_roles_dn, per_user_roles, and per_users for the security side and iby_ext_bank_accounts for the bank address side but am missing the tables to link these, if possible.

many thanks,

Lana

Version

11.1.1.9