View: WSH_PURGE_SOURCE_NUMBERS_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_PURGE_SOURCE_NUMBERS_V

View Text

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

Columns