Product: | ISC - Supply Chain Intelligence (Obsolete) |
---|---|
Description: | This is the collection view for the Sales Channel level of the Sales Channel dimension |
Implementation/DBA Data: | Not implemented in this database |
SELECT FND.LOOKUP_CODE||'-'||INST.INSTANCE_CODE
, 'ALL'
, FND.START_DATE_ACTIVE
, FND.END_DATE_ACTIVE
, FND.CREATION_DATE
, FND.ENABLED_FLAG
, INST.INSTANCE_CODE
, FND.LAST_UPDATE_DATE
, FND.MEANING
, FND.LOOKUP_CODE
, FND.MEANING||'-'||INST.INSTANCE_CODE
, FND.DESCRIPTION
, NULL
, NULL
, NULL
, NULL
, NULL
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