1 Reply Latest reply: Feb 22, 2014 11:42 PM by user13424229 RSS

PO history revision details from po archive tables

user13424229 Explorer
Currently Being Moderated

Dear All,


I have a requirement of development of a report which will give details of po headers archive all and po lines.archive all and po lines archive all

I have to pass parameter revision number which is purchase order revision number.

 

When I try to get line details of previous revisions of PO the matches were not exact.

.

 

suppose currently in the system there is 10th revision of PO. User want to generate report for 8th version of PO.

The lines were not exactly matching when user select revision 8 from the report parameter.

 

Can someone help me in getting the logic of getting exact output.

 

As PO_LINES_ARCHIVE_ALL only stores those line_num that have been changed for the particular revision of PO.

I am getting only those line details that are changed in the 8th PO. But user want all the lines corresponding to 8th PO whether changed or not changed.


So please help me how i can get corrcet revision line details for po.


Thanks

Deb

Legend

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