Query to get the Concatenated Line Number on the Sales Order

SELECT   oh.org_id
       , order_number
       ,    ol.line_number
         || '.'
         || ol.shipment_number
         || '.'
         || ol.option_number
         || '.'
         || ol.component_number
         || '.'
         || ol.service_number line_number
    FROM oe_order_lines_all ol
       , oe_order_headers_all oh
   WHERE oh.header_id = ol.header_id
     AND oh.order_number = '&Order_number'
ORDER BY ol.line_number
       , ol.shipment_number
       , ol.option_number
       , ol.component_number
       , ol.service_number;

References:
http://oracleappssolutiions.blogspot.com/search/label/AOL%20And%20Generic%20SQLs?updated-max=2013-12-18T14:39:00-08:00&max-results=20&start=19&by-date=false