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

TABLE: HR.HR_NAVIGATION_PATHS

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


HR_NAVIGATION_PATHS holds the navigation paths and sequence links for
a specific taskflow. A path is the route defined between two nodes.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HR_NAVIGATION_PATHS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnNAV_PATH_ID
ColumnZD_EDITION_NAME
HR_NAVIGATION_PATHS_UK1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnFROM_NAV_NODE_USAGE_ID
ColumnTO_NAV_NODE_USAGE_ID
ColumnZD_EDITION_NAME
HR_NAVIGATION_PATHS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnFROM_NAV_NODE_USAGE_ID
HR_NAVIGATION_PATHS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnTO_NAV_NODE_USAGE_ID
Columns
Name Datatype Length Mandatory Comments
NAV_PATH_ID NUMBER (9) Yes System-generated primary key column.
FROM_NAV_NODE_USAGE_ID NUMBER (9) Yes Foreign key to HR_NAVIGATION_NODE_USAGES.
TO_NAV_NODE_USAGE_ID NUMBER (9) Yes Foreign key to HR_NAVIGATION_NODE_USAGES.
NAV_BUTTON_REQUIRED VARCHAR2 (30) Yes Indicates whether a user button is displayed.
SEQUENCE NUMBER (9) Yes Sequence of user buttons, and the order of other options in the Others list.
OVERRIDE_LABEL VARCHAR2 (40)
User defined label for a button.
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT NAV_PATH_ID
,      FROM_NAV_NODE_USAGE_ID
,      TO_NAV_NODE_USAGE_ID
,      NAV_BUTTON_REQUIRED
,      SEQUENCE
,      OVERRIDE_LABEL
,      ZD_EDITION_NAME
FROM HR.HR_NAVIGATION_PATHS;

Dependencies

[top of page]

HR.HR_NAVIGATION_PATHS does not reference any database object

HR.HR_NAVIGATION_PATHS is referenced by following:

SchemaHR
ViewHR_NAVIGATION_PATHS#