How to get the bank account assigned to a party site
Summary: We need to list all bank accounts being used by sa party site. Bank accounts that we can see when we navigate to Manage Suppliers page
We are trying to create a report with IBY_EXT_BANK_ACCOUNTS, IBY_ACCOUNT_OWNERS, HZ_PARTIES, and HZ_PARTY_USG_ASSIGNMENTS table. I also wanted to connect the HZ_PARTY_SITES table so we can filter by party sites the bank accounts. However there is no direct connection between HZ_PARTY_SITES and the IBY tables.
Is there another table that we can use to get the bank accounts of the party site?