PO: Query: Fetch the item price based on Serial Number

select rsh.receipt_num, ph.segment1, pl.unit_price, rsh.receipt_num 
from   rcv_serial_transactions rst, rcv_transactions rt,
       rcv_shipment_headers rsh, rcv_shipment_lines rsl,
       po_headers_all ph, po_lines_all pl
where  serial_num      = 'HFYX59G8B8019576'
and    rt.transaction_type    = 'RECEIVE'
and    rst.transaction_id     = rt.transaction_id
and    rsh.SHIPMENT_HEADER_ID = rsl.shipment_header_id
and    rst.shipment_line_id   = rsl.shipment_line_id
and    rsl.po_header_id       = ph.po_header_id
and    rsl.po_line_id         = pl.po_line_id
and    ph.po_header_id        = pl.po_header_id