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.
Try this:
select t.LINE_NUMBER || '.' || t.shipment_number line_number
from oe_order_lines_all t
WHERE T.HEADER_ID = &header_id;