[Home] [Help] [Dependency Information]

TABLE: HR.HR_INCOMPATIBILITY_RULES

Object Details

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

HR_INCOMPATIBILITY_RULES holds details of units that are incompatible
for application reasons. These restrictions are defined by holding
FROM_NAV_UNIT_ID and TO_NAV_UNIT_ID of the restricted units.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Unique Key: HR_INCOMPATIBILITY_RULES_UK

1. FROM_NAV_UNIT_ID
2. TO_NAV_UNIT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_INCOMPATIBILITY_RULES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FROM_NAV_UNIT_ID TO_NAV_UNIT_ID
HR_INCOMPATIBILITY_RULES_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TO_NAV_UNIT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_INCOMPATIBILITY_RULES		HR_NAVIGATION_UNITS	HR_INCOMPATIBILITY_RULES TO_NAV_UNIT_ID
HR_INCOMPATIBILITY_RULES		HR_NAVIGATION_UNITS	HR_INCOMPATIBILITY_RULES FROM_NAV_UNIT_ID

Columns

Query Text

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

SELECT FROM_NAV_UNIT_ID
,      TO_NAV_UNIT_ID
FROM HR.HR_INCOMPATIBILITY_RULES;

Dependencies

[top of page]

HR.HR_INCOMPATIBILITY_RULES does not reference any database object

HR.HR_INCOMPATIBILITY_RULES is referenced by following:

APPS

HR_INCOMPATIBILITY_RULES

PUBLIC

HR_INCOMPATIBILITY_RULES