Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

To get the document status for different revisions

edited Jun 24, 2020 5:43PM in Purchasing 4 comments

Summary

How to get the document status for different revisions of a PO

Content

Hi all,

I need to display the document status based on the revision number.

For a PO if there are 2 revisions(0 with Approved and 1 with Cancelled). I need to display both the revision details  as below:

Line1 .PO#1 revision 1 and status as Approved

Line2.PO#1 revision 2 and status as Cancelled.

But here when I am fetching the document status from po_headers_all it fetches the same status for all the revisions.

I need to show the different statuses based on the revisions.

Thanks for your help in advance.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!