oracle-databaseoracleapplicationsoracle-ebs

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


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.


Solution

  • Try this:

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