View: BIM_DIMV_SALES_CHANNELS

Product:	BIM - Marketing Intelligence(Obsolete)
Description:	Shows all sales channels.
Implementation/DBA Data:	APPS.BIM_DIMV_SALES_CHANNELS

View Text

SELECT OEL.LOOKUP_CODE SALES_CHANNEL_CODE
, OEL.ENABLED_FLAG ENABLED_FLAG
, OEL.START_DATE_ACTIVE START_DATE_ACTIVE
, OEL.END_DATE_ACTIVE END_DATE_ACTIVE
, OEL.MEANING SALES_CHANNEL_NAME
, OEL.DESCRIPTION DESCRIPTION
FROM OE_LOOKUPS OEL
WHERE LOOKUP_TYPE = 'SALES_CHANNEL' UNION ALL SELECT '-999'
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, MEANING
, NULL
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY

Columns