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

VIEW: APPS.CNDIHY_ROOT_NODES

Object Details
Object Name: CNDIHY_ROOT_NODES
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Shows the various root nodes of a hierarchy (may be multiple)


[View Source]

Columns
Name Datatype Length Mandatory Comments
DIM_HIERARCHY_ID NUMBER (15) Yes Period effective dimension hierarchy in which this root exists.
VALUE_ID NUMBER (15) Yes Primary key
NAME VARCHAR2 (30)
Root name (denormalized from CN_HIERARCHY_NODES for the given value_id)
NODES NUMBER

Number of nodes in the subtree underneath this root node.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DIM_HIERARCHY_ID
,      VALUE_ID
,      NAME
,      NODES
FROM APPS.CNDIHY_ROOT_NODES;

Dependencies

[top of page]

APPS.CNDIHY_ROOT_NODES references the following:

SchemaAPPS
SynonymCN_DIM_EXPLOSION
SynonymCN_HIERARCHY_EDGES
SynonymCN_HIERARCHY_NODES

APPS.CNDIHY_ROOT_NODES is not referenced by any database object