[Home] [Help] [Dependency Information]
Object Name: | EDW_OE_SCHN_SCHN_LSTG |
---|---|
Object Type: | TABLE |
Owner: | ISC |
FND Design Data: | ISC.EDW_OE_SCHN_SCHN_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Sales Channel level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_OE_SCHN_SCHN_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | SALES_CHANNEL_PK |
EDW_OE_SCHN_SCHN_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALES_CHANNEL_PK | VARCHAR2 | (120) | Unique identifier | |
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the Sales Channel dimension | |
ALL_FK_KEY | NUMBER | System generated 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 | ||
COLLECTION_STATUS | VARCHAR2 | (40) | Collection status code for the record | |
CREATION_DATE | DATE | Standard Who column | ||
ENABLED_FLAG | VARCHAR2 | (20) | Flag to indicate if that Sales Channel was enabled in the source system | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
INSTANCE_CODE | VARCHAR2 | (40) | Instance code referring to the source application | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
NAME | VARCHAR2 | (80) | Alternate Sales Channel name | |
OPERATION_CODE | VARCHAR2 | (40) | Code used by the collection program to determine whether to insert/update/delete this record | |
REQUEST_ID | NUMBER | Identifier used by the collection program | ||
ROW_ID | ROWID | (10) | Row Id | |
SALES_CHANNEL_CODE | VARCHAR2 | (80) | Sales Channel code | |
SALES_CHANNEL_DP | VARCHAR2 | (240) | Unique Sales Channel name | |
SALES_CHANNEL_NAME | VARCHAR2 | (240) | Sales Channel name | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User attribute |
Cut, paste (and edit) the following text to query this object:
SELECT SALES_CHANNEL_PK
, ALL_FK
, ALL_FK_KEY
, ACTIVE_FROM_DATE
, ACTIVE_TO_DATE
, COLLECTION_STATUS
, CREATION_DATE
, ENABLED_FLAG
, ERROR_CODE
, INSTANCE_CODE
, LAST_UPDATE_DATE
, NAME
, OPERATION_CODE
, REQUEST_ID
, ROW_ID
, SALES_CHANNEL_CODE
, SALES_CHANNEL_DP
, SALES_CHANNEL_NAME
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM ISC.EDW_OE_SCHN_SCHN_LSTG;
ISC.EDW_OE_SCHN_SCHN_LSTG does not reference any database object
ISC.EDW_OE_SCHN_SCHN_LSTG is referenced by following:
|
|
|