[Home] [Help]
SELECT header_id, line_id, to_char(line_number) || '.' || to_char(shipment_number) line_number, ordered_quantity, flow_status_code from oe_order_lines_all order by line_number, shipment_number
SELECT HEADER_ID
, LINE_ID
, TO_CHAR(LINE_NUMBER) || '.' || TO_CHAR(SHIPMENT_NUMBER) LINE_NUMBER
, ORDERED_QUANTITY
, FLOW_STATUS_CODE
FROM OE_ORDER_LINES_ALL ORDER BY LINE_NUMBER
, SHIPMENT_NUMBER
|
|
|
|