<div>
do you want to get the result as bellow?<br />
<br />
1. Supplier 1 - Site 1 - Bank account AAA<br />
2. Supplier 1 - Site 2 - Bank account not available<br />
3. Supplier 2 - Site 1 - Bank account AAB<br />
4. Supplier 3 - Site 1 - Bank account AAC<br />
4. Supplier 3 - Site 2 - Bank account AAD<br />
5. Supplier 3 - Site not available<br />
<br />
Are all the tables in one database? how many tables are there having supplier, sites, and bank details? if you can give those information, we can help to write you a query to pull data as you wish
</div>


do you want to get the result as bellow?

1. Supplier 1 - Site 1 - Bank account AAA
2. Supplier 1 - Site 2 - Bank account not available
3. Supplier 2 - Site 1 - Bank account AAB
4. Supplier 3 - Site 1 - Bank account AAC
4. Supplier 3 - Site 2 - Bank account AAD
5. Supplier 3 - Site not available

Are all the tables in one database? how many tables are there having supplier, sites, and bank details? if you can give those information, we can help to write you a query to pull data as you wish

<div>
<div class="content wysiwyg-content">
I need to find Bank Accounts Association of Supplier and Supplier Sites in EBusiness Suite R12.<br />
<br />
For Example:<br />
<br />
Supplier01 has a Bank Account at Supplier Level and Each Site may have accounts linked.<br />
Supplier01, Site01, Site02 may have more than one Accounts linked.<br />
<br />
I need a query or API to pull all active Supplier and Active Sites with or without Accounts Association.
</div>
</div>


I need to find Bank Accounts Association of Supplier and Supplier Sites in EBusiness Suite R12.

For Example:

Supplier01 has a Bank Account at Supplier Level and Each Site may have accounts linked.
Supplier01, Site01, Site02 may have more than one Accounts linked.

I need a query or API to pull all active Supplier and Active Sites with or without Accounts Association.

Query to find Bank, Branch and Account Details associated with Supplier and Sites

apps

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.