I have an SQL query below for purchase Orders and need to get the deliver to person.

Thanks for the answers below which give me the Buyer. What I am after is the Destination field of the attachment "Ship to Desination" SEE ATTACHMENT

In my query below I use the table (po.rcv_shipment_lines rsl) to get the deliver_to_person id. How do I get the name of the deliver to person. ? Thanks

SELECT

rsh. receipt_source_code,

pov.vendor_name "VENDOR",

POL.ATTRIBUTE5 "CATEGORY",

pol.item_description,

fdu.description Receiver,

RCT.CREATION_DATE,

RCT.TRANSACTION_DATE,

RCT.TRANSACTION_TYPE,

ph.segment1 po_num,

POL.ATTRIBUTE4 "COSID",

rsh. receipt_num,

--ood.organization_name,

--pol.po_line_id,