SELECT FND.LOOKUP_CODE , FND.LOOKUP_CODE||'-'||INST.INSTANCE_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