Query to Get PO Receipt Received and Shipment Quantity Details

SELECT c.po_header_id,

       a.location_id,

       a.location_code,

       c.po_line_id,

       b.receipt_num,

       c.quantity_shipped,

       c.quantity_received,

       c.shipment_line_status_code,

       c.shipment_line_status_code

  FROM hr_locations a,

       rcv_shipment_headers b,

       rcv_shipment_lines c,

       po_headers_all poh

 WHERE a.location_id = b.ship_to_location_id

   AND c.source_document_code = 'PO'

   AND a.location_code LIKE '%DEL%'

   AND c.shipment_line_status_code <> 'FULLY RECEIVED'

   AND c.quantity_shipped > c.quantity_received