SELECT DISTINCT wdd.source_code source_system, wdd.source_header_number source_id, wdd.source_header_number source_number, wl.meaning meaning FROM wsh_delivery_details wdd, wsh_lookups wl WHERE wl.lookup_type = 'SOURCE_SYSTEM' AND wl.enabled_flag = 'Y' AND wl.lookup_code NOT IN ('OKE','WSH') AND wdd.source_code = wl.lookup_code
SELECT DISTINCT WDD.SOURCE_CODE SOURCE_SYSTEM
, WDD.SOURCE_HEADER_NUMBER SOURCE_ID
, WDD.SOURCE_HEADER_NUMBER SOURCE_NUMBER
, WL.MEANING MEANING
FROM WSH_DELIVERY_DETAILS WDD
, WSH_LOOKUPS WL
WHERE WL.LOOKUP_TYPE = 'SOURCE_SYSTEM'
AND WL.ENABLED_FLAG = 'Y'
AND WL.LOOKUP_CODE NOT IN ('OKE'
, 'WSH')
AND WDD.SOURCE_CODE = WL.LOOKUP_CODE
|
|
|