Need a SQL query to find the names of the procurement & requisitioning business units on a PO.

Hi Team,
I need a SQL query to find the names of the procurement & requisitioning business units on a PO. The output of the query will have the following columns, something like what is mentioned below:

Procurement Business Unit Name
Requisitioning Business Unit Name
Purchase Order number
Supplier Name
Supplier site
Bill-to BU name
Sold-to BU name
Sold to legal entity name
Ship-to location name
Bill-to location name

I have tried writing queries but I can only find the ID & not the names. Any help will we much appreciated. Thanks in Advance.