How to identify the BPA revision/approver for the applicable BPR.
For reporting (sql) I need to identify the BPA revision approver for the applicable BPR. The Releases form (POXPOERL) shows the BPA, BPA Revsion, Release, Release Revsion. This form is populated from the view PO_RELEASES_V. Unfortunately it appears this view does not retain data. It populates the form but when I query the view there are no records. I obtained the query that generates the view but that does not produce results either. How do I identify the BPA Revision for a specific BPR?