SQL to find what all lines are created/updated for a given sales order revision

Apr 28, 2025 11:40PM

Summary:

Content (please ensure you mask any confidential information):

We have a requirement to identify the sales order lines which are added/updated/canceled against a given revision

For example

SO REV Line

100 1 order created 5 Lines

100 2 2 lines added

100 3 line # 1,6 were updated

For such a scenario, how do i identify what all lines were added/updated as a part of which revision using a SQL

Version (include the version you are using, if applicable):

25A