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
Tagged:
0