Need SQL join to show bank assignment to supplier site

Summary

We assign bank accounts to supplier sites, I need the table joins to allow me to create a data model to show which bank account is assigned to each supplier site.

Content

I need to be able to join the poz_supplier_sites_all_m table to the bank account details tables.

We previously used HZ_party_sites but this table is not valid in Fusion.

I need supplier name, site code, bank details including date bank assigned to the supplier site.

Does anyone have sql for this?

Version

20B