[Home] [Help]
View: EDW_OE_SCHN_SCHN_LCV
| Product: | ONT - Order Management |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT FND.LOOKUP_CODE||'-'||INST.INSTANCE_CODE
, 'ALL'
, INST.INSTANCE_CODE
, FND.LOOKUP_CODE
, FND.DESCRIPTION
, FND.ENABLED_FLAG
, FND.START_DATE_ACTIVE
, FND.END_DATE_ACTIVE
, FND.LOOKUP_CODE||'-'||INST.INSTANCE_CODE
, FND.LOOKUP_CODE
, FND.CREATION_DATE
, FND.LAST_UPDATE_DATE
, 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
Columns
| Name |
| SALES_CHANNEL_PK |
| ALL_FK |
| INSTANCE_CODE |
| SALES_CHANNEL_CODE |
| SALES_CHANNEL_NAME |
| ENABLED_FLAG |
| ACTIVE_FROM_DATE |
| ACTIVE_TO_DATE |
| SALES_CHANNEL_DP |
| NAME |
| CREATION_DATE |
| LAST_UPDATE_DATE |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |