You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Query to get Purchase order Versions with Related Requisition

Summary:

I am trying to develop a BI Report where I can get each purchase order versions with related requisition , which means if a PO-1 Version 0 is created based on PR-1 and Change order for PO-1 is created with PR-2 , I would to prepare a report with PO-1 Version 0 PR-1 , and details such as creation date approval date etc. , another row will PO-1 Version 1 PR-2 and Details , I can get PO change order details from PO_HEADERS_ARCHIVE_ALL,PO_VERSIONS etc , but I am not able to link with PR Tables as it comes both PR linked ,

Help in this matter will be much appreciated

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!