We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
29
Views
2
Comments
edited Jul 6, 2020 2:05PM in Reporting and Analytics for ERP 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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