Query to get the revision history
Hello Experts
I have a requirement to get the PO value by revision. Our BI team are trying to write a query to get this but not successful. If there are multiple changes in the revision their query is not working. Can you please advise
SELECT PO_HEADERS_ARCHIVE_ALL.segment1 AS PURCH_ORDER_NUM,
PO_HEADERS_ARCHIVE_ALL.APPROVED_DATE,
PO_HEADERS_ARCHIVE_ALL.REVISED_DATE,
PO_HEADERS_ARCHIVE_ALL.REVISION_NUM,
--PO_LINE_LOCATIONS_ALL.LINE_NUM,
SUM(PO_LINES_ARCHIVE_ALL.QUANTITY*PO_LINES_ARCHIVE_ALL.UNIT_PRICE) amount
FROM PO_HEADERS_ARCHIVE_ALL PO_HEADERS_ARCHIVE_ALL,