Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Need SQL join to show bank assignment to supplier site — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need SQL join to show bank assignment to supplier site

Received Response
edited Jul 6, 2020 2:05PM in Reporting and Analytics for ERP 2 comments


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.


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?



Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!