[Home] [Help] [Dependency Information]
Object Name: | ENI_DENORM_HIERARCHIES |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
This table stores the de-normalized Catalog hierarchies. It contains the immediate children and ultimate children of each node in the catalog. It also indicates whether a node is the top-most in a hierarchy, or a leaf-node.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENI_DENORM_HIERARCHIES_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
OBJECT_TYPE
OBJECT_ID PARENT_ID CHILD_ID IMM_CHILD_ID DBI_FLAG |
ENI_DENORM_HIERARCHIES_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TOP_NODE_FLAG
CHILD_ID PARENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_ID | NUMBER | Parent Catalog Category Identifier | ||
IMM_CHILD_ID | NUMBER | Current Catalog Category's Immediate Child Identifier | ||
CHILD_ID | NUMBER | Child Catalog Category Identifier | ||
OBJECT_TYPE | VARCHAR2 | (20) | Object Type of the Catalog Category | |
OBJECT_ID | NUMBER | Object Identifier for the Object Type | ||
TOP_NODE_FLAG | VARCHAR2 | (1) | Indicates whether the Catalog Category is the Top Node in the Hierarchy | |
LEAF_NODE_FLAG | VARCHAR2 | (1) | Indicates whether the Catalog Category is the Leaf Node in the Hierarchy | |
ITEM_ASSGN_FLAG | VARCHAR2 | (1) | Indicates whether an Item has been assigned to this Catalog Category | |
DBI_FLAG | VARCHAR2 | (1) | Thsi flag is used for DBI environments | |
OLTP_FLAG | VARCHAR2 | (1) | Thsi flag is used for OLTP or NON-DBI environments | |
CREATED_BY | NUMBER | Unique Identifier of the User from FND_USER who created the row. | ||
CREATION_DATE | DATE | The Creation Date | ||
LAST_UPDATED_BY | NUMBER | The Unique Identifier of the User from FND_USER who last updated the row | ||
LAST_UPDATE_DATE | DATE | The Date when the row was last Updated | ||
LAST_UPDATE_LOGIN | NUMBER | The Unique Identifier of the User who was Logged in when the row got updated | ||
REQUEST_ID | NUMBER | The Request Identifier of the Concurrent Program which generated the row | ||
PROGRAM_APPLICATION_ID | NUMBER | The Application Identifier | ||
PROGRAM_UPDATE_DATE | DATE | The Program Update Date | ||
PROGRAM_ID | NUMBER | The Program Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_ID
, IMM_CHILD_ID
, CHILD_ID
, OBJECT_TYPE
, OBJECT_ID
, TOP_NODE_FLAG
, LEAF_NODE_FLAG
, ITEM_ASSGN_FLAG
, DBI_FLAG
, OLTP_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, PROGRAM_ID
FROM ENI.ENI_DENORM_HIERARCHIES;
ENI.ENI_DENORM_HIERARCHIES does not reference any database object
ENI.ENI_DENORM_HIERARCHIES is referenced by following:
|
|
|