[Home] [Help] [Dependency Information]

TABLE: HR.HR_NAVIGATION_NODES

Object Details

Object Name:	HR_NAVIGATION_NODES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_NAVIGATION_NODES
Subobject Name:
Status:	VALID

HR_NAVIGATION_NODES holds the definitions for the individual nodes
that can be linked together in a taskflow. There may be multiple
entries for the same window, for example, where the window is called
with a custom restriction specified in CUSTOMIZED_RESTRICTION_ID.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Primary Key: HR_NAVIGATION_NODES_PK

1. NAV_NODE_ID

Unique Key: HR_NAVIGATION_NODES_UK2

1. NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_NAVIGATION_NODES_PK	NORMAL	UNIQUE	APPS_TS_SEED	NAV_NODE_ID
HR_NAVIGATION_NODES_UK2	NORMAL	UNIQUE	APPS_TS_SEED	NAME
HR_NAVIGATION_NODES_FK1	NORMAL	NONUNIQUE	APPS_TS_SEED	NAV_UNIT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_NAVIGATION_NODES		HR_NAVIGATION_UNITS	HR_NAVIGATION_NODES NAV_UNIT_ID
HR_NAVIGATION_NODE_USAGES		HR_NAVIGATION_NODES	HR_NAVIGATION_NODE_USAGES NAV_NODE_ID

Columns

Query Text

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

SELECT NAV_NODE_ID
,      NAV_UNIT_ID
,      NAME
,      CUSTOMIZED_RESTRICTION_ID
FROM HR.HR_NAVIGATION_NODES;

Dependencies

[top of page]

HR.HR_NAVIGATION_NODES does not reference any database object

HR.HR_NAVIGATION_NODES is referenced by following:

APPS

HR_NAVIGATION_NODES

PUBLIC

HR_NAVIGATION_NODES