[Home] [Help] [Dependency Information]
Object Name: | EDW_MRP_DCDM_DM_LSTG |
---|---|
Object Type: | TABLE |
Owner: | ISC |
FND Design Data: | ISC.EDW_MRP_DCDM_DM_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Demand Class 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_MRP_DCDM_DM_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | DEMAND_CLASS_PK |
EDW_MRP_DCDM_DM_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEMAND_CLASS_PK | VARCHAR2 | (80) | Unique identifier | |
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the Demand Class dimension | |
ALL_FK_KEY | NUMBER | System generated foreign key to the top level of the Demand Class dimension | ||
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
DEMAND_CLASS | VARCHAR2 | (80) | Demand Class | |
DEMAND_CLASS_DP | VARCHAR2 | (240) | Unique Demand Class name | |
DESCRIPTION | VARCHAR2 | (240) | Demand Class description | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
INSTANCE_CODE | VARCHAR2 | (40) | Instance code referring to the source application | |
NAME | VARCHAR2 | (2000) | Alternate Demand Class name | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
REQUEST_ID | NUMBER | Identifier used by collection program | ||
ROW_ID | ROWID | (10) | Row Id | |
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 DEMAND_CLASS_PK
, ALL_FK
, ALL_FK_KEY
, COLLECTION_STATUS
, DEMAND_CLASS
, DEMAND_CLASS_DP
, DESCRIPTION
, ERROR_CODE
, INSTANCE_CODE
, NAME
, OPERATION_CODE
, REQUEST_ID
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM ISC.EDW_MRP_DCDM_DM_LSTG;
ISC.EDW_MRP_DCDM_DM_LSTG does not reference any database object
ISC.EDW_MRP_DCDM_DM_LSTG is referenced by following:
|
|
|