[Home] [Help] [Dependency Information]
Object Name: | EDW_OE_SLCHNL_M |
---|---|
Object Type: | TABLE |
Owner: | ISC |
FND Design Data: | ISC.EDW_OE_SLCHNL_M |
Subobject Name: | |
Status: | VALID |
This is the denormalized star table for the Sales Channel dimension. It contains records for the lowest level of the Sales Channel dimension and their parentage up to the top level of the dimension, across all hierarchies.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_OE_SLCHNL_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
SCHN_SLSCHNL_PK
SCHN_SLSCHNL_PK_KEY |
EDW_OE_SLCHNL_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | SCHN_SLSCHNL_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
A_ALL_PK | VARCHAR2 | (40) | Unique identifier for All Sales Channels | |
A_ALL_PK_KEY | NUMBER | System generated unique identifier for All Sales Channels | ||
SCHN_SLSCHNL_PK | VARCHAR2 | (120) | Unique identifier for the Sales Channel | |
SCHN_SLSCHNL_PK_KEY | NUMBER | Yes | System generated unique identifier for the Sales Channel | |
A_NAME | VARCHAR2 | (80) | All Sales Channels name | |
SCHN_ACTIVE_FROM_DATE | DATE | Date from which that Sales Channel was active | ||
SCHN_ACTIVE_TO_DATE | DATE | Date to which that Sales Channel was active | ||
SCHN_ENABLED_FLAG | VARCHAR2 | (20) | Flag to indicate if that Sales Channel was enabled in the source system | |
SCHN_INSTANCE_CODE | VARCHAR2 | (40) | nstance code referring to the source application | |
SCHN_NAME | VARCHAR2 | (80) | Alternate Sales Channel name | |
SCHN_SALES_CHANNEL_CODE | VARCHAR2 | (80) | Sales Channel code | |
SCHN_SALES_CHANNEL_NAME | VARCHAR2 | (240) | Sales Channel name | |
SCHN_SLSCHNL_DP | VARCHAR2 | (240) | Unique Sales Channel name | |
SCHN_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User attribute | |
SCHN_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User attribute | |
SCHN_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User attribute | |
SCHN_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User attribute | |
SCHN_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User attribute | |
SCHN_LAST_UPDATE_DATE | DATE | Sales Channel Last Update Date | ||
SCHN_CREATION_DATE | DATE | Sales Channel Creation Date | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT A_ALL_PK
, A_ALL_PK_KEY
, SCHN_SLSCHNL_PK
, SCHN_SLSCHNL_PK_KEY
, A_NAME
, SCHN_ACTIVE_FROM_DATE
, SCHN_ACTIVE_TO_DATE
, SCHN_ENABLED_FLAG
, SCHN_INSTANCE_CODE
, SCHN_NAME
, SCHN_SALES_CHANNEL_CODE
, SCHN_SALES_CHANNEL_NAME
, SCHN_SLSCHNL_DP
, SCHN_USER_ATTRIBUTE1
, SCHN_USER_ATTRIBUTE2
, SCHN_USER_ATTRIBUTE3
, SCHN_USER_ATTRIBUTE4
, SCHN_USER_ATTRIBUTE5
, SCHN_LAST_UPDATE_DATE
, SCHN_CREATION_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
FROM ISC.EDW_OE_SLCHNL_M;
ISC.EDW_OE_SLCHNL_M does not reference any database object
ISC.EDW_OE_SLCHNL_M is referenced by following:
|
|
|