Shipment billed amount <> Distribution billed amount for the same PO/same line
We have a PO and in 2nd line shipment billed amount is not equal to distribution billed amount. Other lines are fine. Here is the result:
select h.segment1
, l.quantity line_ordered
, ll.quantity shipment_ordered
, ll.quantity_billed shipment_billed
, d.quantity_ordered dist_ordered
, d.quantity_billed dist_billed
from po.po_headers_all h
, po.po_lines_all l
, po.po_line_locations_all ll
, po.po_distributions_all d
where d.set_of_books_id = 23
and h.po_header_id = l.po_header_id
and l.po_line_id = d.po_line_id