Need SQL join to show bank assignment to supplier site
SummaryWe 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.
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?