DBA Data[Home] [Help]

VIEW: APPS.MST_ORDER_NUMBERS_V

Source

View Text - Preformatted

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