VIEW: APPS.WSH_PURGE_SOURCE_TYPES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'