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: HR.HR_NAVIGATION_CONTEXT_RULES

Object Details

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

HR_NAVIGATION_CONTEXT_RULES is referenced by
HR_NAV_UNIT_GLOBAL_USAGES. Some units can be accessed only under
certain conditions. For example, the path from PERSON to ASSIGNMENT
is only valid if the currently selected person is an employee. This
table holds the conditions to apply when a navigation option is
selected. The condition will be applied at the very last moment
before a call form or new form is issued. If the condition fails, the
navigation is not permitted and a message is displayed.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Primary Key: HR_NAVIGATION_CONTEXT_RULE_PK

NAV_CONTEXT_RULE_ID

Unique Key: HR_NAVIGATION_CONTEXT_RULE_UK1

GLOBAL_USAGE_ID
EVALUATION_TYPE_CODE
VALUE

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_NAVIGATION_CONTEXT_RULE_PK	NORMAL	UNIQUE	APPS_TS_SEED	NAV_CONTEXT_RULE_ID
HR_NAVIGATION_CONTEXT_RULE_UK1	NORMAL	UNIQUE	APPS_TS_SEED	GLOBAL_USAGE_ID EVALUATION_TYPE_CODE VALUE

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_NAVIGATION_CONTEXT_RULES		HR_NAV_UNIT_GLOBAL_USAGES	HR_NAVIGATION_CONTEXT_RULES GLOBAL_USAGE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
NAV_CONTEXT_RULE_ID	NUMBER	(9)	Yes	System-generated primary key column.
GLOBAL_USAGE_ID	NUMBER	(9)	Yes	Foreign key to HR_NAV_UNIT_GLOBAL_USAGES.
EVALUATION_TYPE_CODE	VARCHAR2	(30)	Yes	Evaluation type of the criteria, for example Not Null or Equals.
VALUE	VARCHAR2	(80)		Acceptable value for the criteria that is acceptable under the rule.

Query Text

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


SELECT NAV_CONTEXT_RULE_ID
,      GLOBAL_USAGE_ID
,      EVALUATION_TYPE_CODE
,      VALUE
FROM HR.HR_NAVIGATION_CONTEXT_RULES;

Dependencies

[top of page]

HR.HR_NAVIGATION_CONTEXT_RULES does not reference any database object

HR.HR_NAVIGATION_CONTEXT_RULES is referenced by following:

APPS: HR_NAVIGATION_CONTEXT_RULES
PUBLIC: HR_NAVIGATION_CONTEXT_RULES