[Home] [Help] [Dependency Information]
Object Name: | ENI_DENORM_HRCHY_STG |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
This is a Staging table that contains certain changes made to catalog categories and catalog hierarchies through the user interface. The records are then picked up and de-normalized into the ENI_DENORM_HIERARCHIES and ENI_DENORM_HRCHY_PARENTS tables through a concurrent program.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENI_DENORM_HRCHY_STG_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
OBJECT_TYPE
OBJECT_ID CHILD_ID TOP_NODE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_TYPE | VARCHAR2 | (20) | The Object Type | |
OBJECT_ID | NUMBER | The Object Identifier of the Object Type | ||
PARENT_ID | NUMBER | The Catalog Category Identifier of the Parent Catalog Category | ||
CHILD_ID | NUMBER | The Catalog Category Identifier of the Child Catalog Category | ||
TOP_NODE_ID | NUMBER | Indicates whether the Catalog Category is the Top Node in the Hierarchy | ||
MODE_FLAG | VARCHAR2 | (1) | Indicates the Mode of the Operation performed on the row. | |
CHILD_LEVEL | NUMBER | Level of child relative to the Root Node | ||
BATCH_FLAG | VARCHAR2 | (40) | 'CURRENT_BATCH' - Entry belongs in current batch of rows being processed 'NEXT_BATCH' - Entry belongs in next batch 'DONE' - Has the row in current batch been processed | |
LANGUAGE_CODE | VARCHAR2 | (4) | The Language Code Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_TYPE
, OBJECT_ID
, PARENT_ID
, CHILD_ID
, TOP_NODE_ID
, MODE_FLAG
, CHILD_LEVEL
, BATCH_FLAG
, LANGUAGE_CODE
FROM ENI.ENI_DENORM_HRCHY_STG;
ENI.ENI_DENORM_HRCHY_STG does not reference any database object
ENI.ENI_DENORM_HRCHY_STG is referenced by following:
|
|
|