[Home] [Help] [Dependency Information]
Object Name: | EDW_OE_SCHN_SCHN_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ISC.EDW_OE_SCHN_SCHN_LCV
ONT.EDW_OE_SCHN_SCHN_LCV |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used by the Sales Channel collection program to retrieve Sales Channel level information from the SALES_CHANNEL lookup type.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALES_CHANNEL_PK | VARCHAR2 | (61) | Unique identifier | |
ALL_FK | CHAR | (3) | Foreign key to the top level of the Sales Channel dimension | |
ACTIVE_FROM_DATE | DATE | Date from which that Sales Channel was active | ||
ACTIVE_TO_DATE | DATE | Date to which that Sales Channel was active | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if that Sales Channel was enabled in the source system |
INSTANCE_CODE | VARCHAR2 | (30) | Instance code referring to the source application | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
NAME | VARCHAR2 | (80) | Yes | Alternate Sales Channel name |
SALES_CHANNEL_CODE | VARCHAR2 | (30) | Yes | Sales Channel code |
SALES_CHANNEL_DP | VARCHAR2 | (111) | Unique Sales Channel name | |
SALES_CHANNEL_NAME | VARCHAR2 | (240) | Sales Channel name | |
USER_ATTRIBUTE1 | VARCHAR2 | (0) | User attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (0) | User attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (0) | User attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (0) | User attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (0) | User attribute |
Cut, paste (and edit) the following text to query this object:
SELECT SALES_CHANNEL_PK
, ALL_FK
, ACTIVE_FROM_DATE
, ACTIVE_TO_DATE
, CREATION_DATE
, ENABLED_FLAG
, INSTANCE_CODE
, LAST_UPDATE_DATE
, NAME
, SALES_CHANNEL_CODE
, SALES_CHANNEL_DP
, SALES_CHANNEL_NAME
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM APPS.EDW_OE_SCHN_SCHN_LCV;
|
|
|