Receiving Transactions Report - SQL Script

Does anyone have an SQL script that I could use to replicate this report in Discoverer. We have Oracle 11.5.10.2. I have started a script below but would like to be able to get the name of the Receiver as per the attachment. Any help would be appreciated

Select ph.segment1 po_num,

.organization_name,

.po_line_id,pll.quantity,

.item_description,

.TRANSACTION_DATE,

.TRANSACTION_TYPE,

. receipt_source_code,

. vendor_id,

. vendor_site_id,

. organization_id,

. shipment_num,

. receipt_num,

. ship_to_location_id,

. bill_of_lading,

.shipment_line_id,

.deliver_to_person_id,

.QUANTITY_SHIPPED,

.QUANTITY_RECEIVED ,

.transaction_type,

.transaction_id