Get the Query for Line Numbers from the Sales Order Form in Oracle EBS

Question

From the Front-end Application, we can see the line number like 1.1 , 2.1, 2.1.1 like this. I only have the value of the line_ids. I would like to get the query for the line numbers in Sales order Form with the use of their line_id values.

Answer 1

Try this:

select t.LINE_NUMBER || '.' || t.shipment_number line_number 
from oe_order_lines_all t 
WHERE T.HEADER_ID = &header_id;