Purchase Order Revision ‘Amount Changed’?

Summary

SQL Query

Content

 

SELECT

    poh.segment1 po_num,

    poh.revision_num,

    SUM(pol.unit_price * pol.quantity) price

FROM

    po_lines_all     pol,

    po_headers_all   poh

WHERE

    pol.po_header_id = poh.po_header_id

GROUP by

    poh.segment1,

    poh.revision_num

    

How do I get the  Latest Purchase Order Revision ‘Amount Changed’?

 

And  Previous Purchase Order Revision ‘Amount Change