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.