Procurement - EBS (MOSC)

MOSC Banner

Query to get the revision history

edited Aug 31, 2016 5:01AM in Procurement - EBS (MOSC) 5 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center