eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AR.HZ_HIERARCHY_NODES

Object Details

Object Name:	HZ_HIERARCHY_NODES
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_HIERARCHY_NODES
Subobject Name:
Status:	VALID

The HZ_HIERARCHY_NODES table stores data from the HZ_RELATIONSHIPS table in denormalized form. This denormalized data enables faster data retreival. When a relationship is created using a hierarchical relationship type, where the hierarchical_flag is set to Y, the data from the HZ_RELATIONSHIPS table is denormalized into this table. The denormalized data contains information about all of the parent-child relationships at all levels in a hierarchy along with the effective dates of the relationship.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_HIERARCHY_NODES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_ID PARENT_TABLE_NAME PARENT_OBJECT_TYPE HIERARCHY_TYPE TOP_PARENT_FLAG EFFECTIVE_START_DATE EFFECTIVE_END_DATE
HZ_HIERARCHY_NODES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHILD_ID CHILD_TABLE_NAME CHILD_OBJECT_TYPE HIERARCHY_TYPE
HZ_HIERARCHY_NODES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RELATIONSHIP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
HIERARCHY_TYPE	VARCHAR2	(30)	Yes	The hierarchy type name
PARENT_ID	NUMBER		Yes	Unique identifier of the parent in this hierarchical relationship
PARENT_TABLE_NAME	VARCHAR2	(30)	Yes	Name of the source table for the parent
PARENT_OBJECT_TYPE	VARCHAR2	(30)	Yes	Object type of the parent
CHILD_ID	NUMBER		Yes	Unique identifier of the child in this hierarchical relationship
CHILD_TABLE_NAME	VARCHAR2	(30)	Yes	Name of the source table for the child
CHILD_OBJECT_TYPE	VARCHAR2	(30)	Yes	Object type of the child
LEVEL_NUMBER	NUMBER		Yes	Number of relationship levels between the parent and the child
TOP_PARENT_FLAG	VARCHAR2	(1)		Indicates if the parent is a root node. Y if the parent in the relationship is at the root node, N if the parent is not at the root node
LEAF_CHILD_FLAG	VARCHAR2	(1)		Indicates if the child is leaf node. Y if the child in the relationship has no children, N if the child has children
EFFECTIVE_START_DATE	DATE		Yes	Date when the hierarchical relationship begins
EFFECTIVE_END_DATE	DATE		Yes	Date when the hierarchical relationship ends
STATUS	VARCHAR2	(1)		Indicates if this hierarchical relationship is active or inactive
RELATIONSHIP_ID	NUMBER			Unique identifier of a hierarchical relationship
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	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).
ACTUAL_CONTENT_SOURCE	VARCHAR2	(30)	Yes	Source of data content

Query Text

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


SELECT HIERARCHY_TYPE
,      PARENT_ID
,      PARENT_TABLE_NAME
,      PARENT_OBJECT_TYPE
,      CHILD_ID
,      CHILD_TABLE_NAME
,      CHILD_OBJECT_TYPE
,      LEVEL_NUMBER
,      TOP_PARENT_FLAG
,      LEAF_CHILD_FLAG
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      STATUS
,      RELATIONSHIP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ACTUAL_CONTENT_SOURCE
FROM AR.HZ_HIERARCHY_NODES;

Dependencies

[top of page]

AR.HZ_HIERARCHY_NODES does not reference any database object

AR.HZ_HIERARCHY_NODES is referenced by following:

AR: HZ_HIERARCHY_NODES#