DBA Data[Home] [Help]

VIEW: APPS.WSH_PURGE_SOURCE_NUMBERS_V

Source

View Text - Preformatted

SELECT DISTINCT source_code source_system, source_header_number source_id, source_header_number source_number FROM wsh_delivery_details WHERE source_code IN ('OE','PO')
View Text - HTML Formatted

SELECT DISTINCT SOURCE_CODE SOURCE_SYSTEM
, SOURCE_HEADER_NUMBER SOURCE_ID
, SOURCE_HEADER_NUMBER SOURCE_NUMBER
FROM WSH_DELIVERY_DETAILS
WHERE SOURCE_CODE IN ('OE'
, 'PO')