My Oracle Support Banner

How To Query To Get the Last Line Of a Sales Order? (Doc ID 2909474.1)

Last updated on NOVEMBER 21, 2022

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

How can one obtain the last line of an order that is created or booked?

Attempted to use below SQL yet it did not locate the last line.


Review sales order analyzer for the order created and find that the max(line_id) is not assigned to line 11.1

Line   Line ID
 1.1   4990136
10.1   4990137
11.1   4990138
 2.1   4990139
 3.1   4990140
 4.1   4990141
 5.1   4990142
 6.1   4990143
 7.1   4990144
 8.1   4990145
 9.1   4990146





 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.