SQL to retrieve Supplier, sites and Sites assignments BU

Summary:

Hi,

Can any one share the script for retrieving list of active suppliers and their sites and site assignement BUs.

Many thanks for your help

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):