Wednesday, August 31, 2016

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

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect