View: WSH_PURGE_SOURCE_TYPES_V

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

View Text

SELECT WL.LOOKUP_CODE SOURCE_SYSTEM
, DECODE(FL.LOOKUP_CODE
, 'STANDARD'
, 1
, 'BLANKET'
, 2
, 1) SOURCE_CODE
, FL.MEANING SOURCE_TYPE_MEANING
, FL.DESCRIPTION SOURCE_TYPE_DESC
, WL.MEANING SOURCE_SYSTEM_MEANING
FROM FND_LOOKUP_VALUES FL
, WSH_LOOKUPS WL
WHERE FL.LOOKUP_TYPE = 'PO TYPE'
AND FL.LANGUAGE = USERENV('LANG')
AND WL.LOOKUP_TYPE = 'SOURCE_SYSTEM'
AND WL.LOOKUP_CODE = 'PO'
AND WL.ENABLED_FLAG = 'Y'
AND FL.LOOKUP_CODE IN ('STANDARD'
, 'BLANKET') UNION SELECT WL.LOOKUP_CODE SOURCE_SYSTEM
, WO.ORDER_TYPE_ID SOURCE_CODE
, WO.ORDER_TYPE_NAME SOURCE_TYPE_MEANING
, WO.DESCRIPTION SOURCE_TYPE_DESC
, WL.MEANING SOURCE_SYSTEM_MEANING
FROM WSH_ORDER_TYPES_REGULAR_V WO
, WSH_LOOKUPS WL
WHERE WL.LOOKUP_TYPE = 'SOURCE_SYSTEM'
AND WL.LOOKUP_CODE = 'OE'
AND WL.ENABLED_FLAG = 'Y'

Columns