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
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.