Identify Parties which are both Suppliers and Customers

Hi Experts,

We are carrying out supplier merge to remove duplicates from Master Data. Since, Oracle maintains data in TC Architecture, there might be potential cases where a supplier is also a customer. Is there any possibility to run a query to determine the suppliers who are customers also? The Tables, may be:

1) HZ_PARTIES

2) HZ_PARTY_USG_ASSIGNMENTS, or any other Table as deem fit.

This would help us a lot in identifying the common parties before proceeding for merge operation.

Thank you for your valuable time.