Query to get the Serial Number of Shipment number for PO in Cloud

Need to find the serial number used in shipment for purchase order when we pass shipment number.

select 

rsl.line_num,

rsh.shipment_num,

poh.segment1 as po_number,

pol.item_description,

esi.item_number,

isn.serial_number,

isn.attribute_category

from 

rcv_shipment_headers rsh,

rcv_shipment_lines rsl,

po_headers_all poh,

po_lines_all pol,

egp_system_items esi,

inv_serial_numbers isn

where 

rsh.shipment_header_id = rsl.shipment_header_id

and rsl.po_header_id = poh.po_header_id

and poh.po_header_id = pol.po_header_id 

and rsl.po_line_id = pol.po_line_id