DBA Data[Home] [Help]

VIEW: APPS.BIS_SALES_CHANNELS_V

Source

View Text - Preformatted

SELECT distinct SL.lookup_code ID , sl.meaning VALUE FROM so_lookups SL WHERE SL.lookup_type = 'SALES_CHANNEL'
View Text - HTML Formatted

SELECT DISTINCT SL.LOOKUP_CODE ID
, SL.MEANING VALUE
FROM SO_LOOKUPS SL
WHERE SL.LOOKUP_TYPE = 'SALES_CHANNEL'