[Home] [Help] [Dependency Information]
Object Name: | CN_DIM_EXPLOSION_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_DIM_EXPLOSION_ALL |
Subobject Name: | |
Status: | VALID |
CN_DIM_EXPLOSION contains denormalized information
about the ancestral relationships among nodes in the
dimension hierarchies. You need one row for each relationship
(whether direct or through multiple direct relationships) such
as parent, grandparent, etc. between any hierarchy nodes.
The table also includes a "self" link for each node in the
hierarchy which matches the node to itself. This table should
not be directly modified at any time: it is updated by triggers
on the CN_HIERARCHY_EDGES table.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_DIM_EXPLOSION_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
DIM_HIERARCHY_ID
ANCESTOR_ID VALUE_ID ORG_ID |
CN_DIM_EXPLOSION_N5 | NORMAL | NONUNIQUE | APPS_TS_SEED |
DIM_HIERARCHY_ID
VALUE_EXTERNAL_ID |
CN_DIM_EXPLOSION_N6 | NORMAL | NONUNIQUE | APPS_TS_SEED |
DIM_HIERARCHY_ID
ANCESTOR_EXTERNAL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VALUE_ID | NUMBER | (15) | Yes | Represents the "child" node in the relationship. |
ANCESTOR_ID | NUMBER | (15) | Yes | Represents the "parent" node in the relationship. |
DIM_HIERARCHY_ID | NUMBER | (15) | Yes | Which hierarchy the relationship is in. Foreign key to CN_DIM_HIERARCHIES |
HIERARCHY_LEVEL | NUMBER | (15) | Yes | The number of levels of indirection between the two nodes. |
VALUE_EXTERNAL_ID | NUMBER | (15) | The primary key (if any) of the value node in its base table. | |
ANCESTOR_EXTERNAL_ID | NUMBER | (15) | The primary key (if any) of the ancestor node in its base table. | |
ORG_ID | NUMBER | (15) | Organization identifier | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated 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_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 VALUE_ID
, ANCESTOR_ID
, DIM_HIERARCHY_ID
, HIERARCHY_LEVEL
, VALUE_EXTERNAL_ID
, ANCESTOR_EXTERNAL_ID
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM CN.CN_DIM_EXPLOSION_ALL;
CN.CN_DIM_EXPLOSION_ALL does not reference any database object
CN.CN_DIM_EXPLOSION_ALL is referenced by following:
|
|
|