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

TABLE: HR.HR_NAVIGATION_UNITS

Object Details
Object Name: HR_NAVIGATION_UNITS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_NAVIGATION_UNITS
Subobject Name:
Status: VALID


HR_NAVIGATION_UNITS holds the predefined definitions of navigation
units that may be linked together in a taskflow. It identifies block
name where there are many navigable blocks within a form.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HR_NAVIGATION_UNITS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnNAV_UNIT_ID
ColumnZD_EDITION_NAME
HR_NAVIGATION_UNITS_UK2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnFORM_NAME
ColumnBLOCK_NAME
ColumnZD_EDITION_NAME
HR_NAVIGATION_UNITS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnDEFAULT_WORKFLOW_ID
Columns
Name Datatype Length Mandatory Comments
NAV_UNIT_ID NUMBER (9) Yes System-generated primary key column.
DEFAULT_WORKFLOW_ID NUMBER (9)
Foreign key to HR_WORKFLOWS.
APPLICATION_ABBREV VARCHAR2 (3) Yes Abbreviation of the application name.
DEFAULT_LABEL VARCHAR2 (40) Yes Default label given to the navigation unit.
FORM_NAME VARCHAR2 (480) Yes Shortened form name that the unit refers to.
MAX_NUMBER_OF_NAV_BUTTONS NUMBER (1) Yes Maximum number of buttons allowed on the form.
BLOCK_NAME VARCHAR2 (30)
Used if more than one block within a form appears as a navigation option.
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT NAV_UNIT_ID
,      DEFAULT_WORKFLOW_ID
,      APPLICATION_ABBREV
,      DEFAULT_LABEL
,      FORM_NAME
,      MAX_NUMBER_OF_NAV_BUTTONS
,      BLOCK_NAME
,      ZD_EDITION_NAME
FROM HR.HR_NAVIGATION_UNITS;

Dependencies

[top of page]

HR.HR_NAVIGATION_UNITS does not reference any database object

HR.HR_NAVIGATION_UNITS is referenced by following:

SchemaHR
ViewHR_NAVIGATION_UNITS#