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

Query to fetch 'Amount Changed' against change order in PO

edited Aug 6, 2024 11:31AM in Purchasing 2 comments

Summary:

We have a requirement to create a Purchase Order summary report which will give details of change order against PO.

to calculate 'Amount Changed' value, we need active review changes lines against the change order.

We tried using PO_LINES_ARCHIVE_ALL table but it is giving both active and inactive lines and there is no flag to identify the active lines.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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