[Home] [Help] [Dependency Information]
Object Name: | EDW_MRP_DM_CLS_M |
---|---|
Object Type: | TABLE |
Owner: | ISC |
FND Design Data: | ISC.EDW_MRP_DM_CLS_M |
Subobject Name: | |
Status: | VALID |
This is the denormalized star table for the Demand Class dimension. It contains records for the lowest level of the Demand Class 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_MRP_DM_CLS_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
DCLS_DEMAND_CLASS_PK
DCLS_DEMAND_CLASS_PK_KEY |
EDW_MRP_DM_CLS_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | DCLS_DEMAND_CLASS_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DCLS_DEMAND_CLASS_PK | VARCHAR2 | (80) | Unique Identifier | |
DCLS_DEMAND_CLASS_PK_KEY | NUMBER | Yes | System generated unique Identifier | |
L0_ALL_PK | VARCHAR2 | (40) | Unique identifier for the top level of the Demand Class dimension | |
L0_ALL_PK_KEY | NUMBER | System generated unique identifier for the top level of the Demand Class dimension | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
DCLS_DEMAND_CLASS | VARCHAR2 | (80) | Demand Class | |
DCLS_DEMAND_CLASS_DP | VARCHAR2 | (240) | Unique Demand Class name | |
DCLS_DESCRIPTION | VARCHAR2 | (240) | Demand Class description | |
DCLS_INSTANCE_CODE | VARCHAR2 | (40) | Instance code refering to the source application | |
DCLS_NAME | VARCHAR2 | (80) | Demand Class name | |
DCLS_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User attribute | |
DCLS_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User attribute | |
DCLS_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User attribute | |
DCLS_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User attribute | |
DCLS_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User attribute | |
L0_NAME | VARCHAR2 | (240) | Top level name | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT DCLS_DEMAND_CLASS_PK
, DCLS_DEMAND_CLASS_PK_KEY
, L0_ALL_PK
, L0_ALL_PK_KEY
, CREATION_DATE
, DCLS_DEMAND_CLASS
, DCLS_DEMAND_CLASS_DP
, DCLS_DESCRIPTION
, DCLS_INSTANCE_CODE
, DCLS_NAME
, DCLS_USER_ATTRIBUTE1
, DCLS_USER_ATTRIBUTE2
, DCLS_USER_ATTRIBUTE3
, DCLS_USER_ATTRIBUTE4
, DCLS_USER_ATTRIBUTE5
, L0_NAME
, LAST_UPDATE_DATE
FROM ISC.EDW_MRP_DM_CLS_M;
ISC.EDW_MRP_DM_CLS_M does not reference any database object
ISC.EDW_MRP_DM_CLS_M is referenced by following:
|
|
|