SELECT DISTINCT REFERENCE_SOURCE_TYPE,SOURCE_CODE, SOURCE_CODE||':'||SOURCE_HEADER_NUMBER order_number FROM MST_DELIVERY_DETAILS ORDER BY REFERENCE_SOURCE_TYPE, order_number
View Text - HTML Formatted
SELECT DISTINCT REFERENCE_SOURCE_TYPE , SOURCE_CODE , SOURCE_CODE||':'||SOURCE_HEADER_NUMBER ORDER_NUMBER FROM MST_DELIVERY_DETAILS ORDER BY REFERENCE_SOURCE_TYPE , ORDER_NUMBER