DBA Data[Home] [Help] [Dependency Information]


TABLE: ENI.ENI_DENORM_HIERARCHIES

Object Details
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.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENI_DENORM_HIERARCHIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnOBJECT_TYPE
ColumnOBJECT_ID
ColumnPARENT_ID
ColumnCHILD_ID
ColumnIMM_CHILD_ID
ColumnDBI_FLAG
ENI_DENORM_HIERARCHIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTOP_NODE_FLAG
ColumnCHILD_ID
ColumnPARENT_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

ENI.ENI_DENORM_HIERARCHIES does not reference any database object

ENI.ENI_DENORM_HIERARCHIES is referenced by following:

SchemaAPPS
Materialized ViewASO_BI_QLIN_PC_MV
Materialized ViewAS_FORECAST_MV
Materialized ViewBIL_BI_FST_PG_MV
Materialized ViewBIM_I_LP_AGE_SG_MV
Materialized ViewBIM_I_ORD_INT_MV
Materialized ViewBIV_ACT_H_SUM_MV
Materialized ViewBIV_BAC_H_SUM_MV
Materialized ViewBIV_B_AGE_H_SUM_MV
Materialized ViewBIV_CLO_H_SUM_MV
Materialized ViewBIV_RES_H_SUM_MV
Materialized ViewENI_DBI_GL_BASE_SUM_C_MV
Materialized ViewENI_DBI_GL_BASE_SUM_MV
Materialized ViewENI_DBI_INV_SUM_MV
Materialized ViewENI_DBI_PRC_SUM2_MV
SynonymENI_DENORM_HIERARCHIES
Materialized ViewIBE_BI_CAT_MV
Materialized ViewISC_DBI_CFM_001_MV
Materialized ViewISC_DBI_CFM_009_MV
Materialized ViewISC_DBI_CFM_011_MV
Materialized ViewISC_DBI_CFM_012_MV
Materialized ViewISC_DBI_CFM_014_MV
Materialized ViewISC_DBI_CFM_015_MV
Materialized ViewISC_DBI_CFM_016_MV
Materialized ViewISC_DBI_CFM_017_MV
Materialized ViewISC_DBI_CPM_003_MV
Materialized ViewISC_DBI_CPM_004_MV
Materialized ViewISC_DBI_CPM_005_MV
Materialized ViewISC_DBI_PM_0003_MV
Materialized ViewISC_DBI_SCR_002_MV
Materialized ViewISC_DR_BKLG_02_MV
Materialized ViewISC_DR_CHARGES_02_MV
Materialized ViewISC_DR_COSTS_02_MV
Materialized ViewISC_DR_MTTR_02_MV
Materialized ViewISC_TRN_005_MV
Materialized ViewOPI_PGM_CAT_MV