[Home] [Help] [Dependency Information]
Object Name: | CN_DIMENSIONS_ALL_TL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_DIMENSIONS_ALL_TL |
Subobject Name: | |
Status: | VALID |
CN_DIMENSIONS_ALL_TL contains translated 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_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
DIMENSION_ID
ORG_ID LANGUAGE |
CN_DIMENSIONS_ALL_TL_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
NAME
ORG_ID LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_ID | NUMBER | (15) | Yes | Primary key |
ORG_ID | NUMBER | (15) | Organization identifier | |
NAME | VARCHAR2 | (80) | Yes | Name of the dimension |
LANGUAGE | VARCHAR2 | (4) | Yes | Indicate the defined language of the row's translated columns |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Indicate the actual language of the row's translated columns |
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_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). | |
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). | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT DIMENSION_ID
, ORG_ID
, NAME
, LANGUAGE
, SOURCE_LANG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM CN.CN_DIMENSIONS_ALL_TL;
CN.CN_DIMENSIONS_ALL_TL does not reference any database object
CN.CN_DIMENSIONS_ALL_TL is referenced by following:
|
|
|