View: EDW_SALES_CHANNEL_FKV

Product:	ISC - Supply Chain Intelligence
Description:	This view can be used by fact views to derive Sales Channel dimension foreign keys
Implementation/DBA Data:	APPS.EDW_SALES_CHANNEL_FKV

View Text

SELECT FND.LOOKUP_CODE||'-'||INST.INSTANCE_CODE
, FND.LOOKUP_CODE
FROM FND_LOOKUP_VALUES FND
, EDW_LOCAL_INSTANCE INST
WHERE FND.LOOKUP_TYPE='SALES_CHANNEL'
AND FND.LANGUAGE = USERENV('LANG')
AND FND.VIEW_APPLICATION_ID = 660
AND FND.SECURITY_GROUP_ID = 0

Columns