1 Reply Latest reply: Feb 11, 2014 8:18 AM by JFr -Oracle RSS

Need help in query to get po revision history details

user13424229 Explorer
Currently Being Moderated

Dear All,

My requirement is to get all po change history details based on po number and revision number , in purchasing module we have po change history page to get the history details, but i need the sql query behind this , i tried by joining po_headers_archive_all, po_lines_archive_all,po_line_locations_archive all tables but not getting proper output for specific po and revision number, can some one help me in providing the sql query to get po revision history details.

 

 

Thanks

Deb

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points