[Home] [Help] [Dependency Information]
Object Name: | CN_DIMENSIONS_ALL_B |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_DIMENSIONS_ALL_B |
Subobject Name: | |
Status: | VALID |
CN_DIMENSIONS contains information about the dimensions
on which the system can roll up data for calculation or
reporting. Each row corresponds to one dimension, and its
associated base TABLE in the schema.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_DIMENSIONS_ALL_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
DIMENSION_ID
ORG_ID ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_ID | NUMBER | (15) | Yes | Primary key |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
DESCRIPTION | VARCHAR2 | (1900) | Dimension description | |
SOURCE_TABLE_ID | NUMBER | (15) | Unique identifier of the table which holds the explicit elements of this dimension | |
ORG_ID | NUMBER | (15) | Organization identifier | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | This column is used for locking purposes | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT DIMENSION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DESCRIPTION
, SOURCE_TABLE_ID
, ORG_ID
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, ZD_EDITION_NAME
FROM CN.CN_DIMENSIONS_ALL_B;
CN.CN_DIMENSIONS_ALL_B does not reference any database object
CN.CN_DIMENSIONS_ALL_B is referenced by following:
|
|
|