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]

VIEW: APPS.HR_NAVIGATION_UNITS_VL

Object Details

Object Name:	HR_NAVIGATION_UNITS_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

Join of HR_NAVIGATION_UNITS and HR_NAVIGATION_UNITS_TL

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Column selected from base table hr_navigation_units
NAV_UNIT_ID	NUMBER	(9)	Yes	Column selected from base table hr_navigation_units
DEFAULT_WORKFLOW_ID	NUMBER	(9)		Column selected from base table hr_navigation_units
APPLICATION_ABBREV	VARCHAR2	(3)	Yes	Column selected from base table hr_navigation_units
DEFAULT_LABEL	VARCHAR2	(40)	Yes	Translated label selected from hr_navigation_units_tl
FORM_NAME	VARCHAR2	(480)	Yes	Column selected from base table hr_navigation_units
BLOCK_NAME	VARCHAR2	(30)		Column selected from base table hr_navigation_units
MAX_NUMBER_OF_NAV_BUTTONS	NUMBER	(1)	Yes	Column selected from base table hr_navigation_units

Query Text

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


SELECT ROW_ID
,      NAV_UNIT_ID
,      DEFAULT_WORKFLOW_ID
,      APPLICATION_ABBREV
,      DEFAULT_LABEL
,      FORM_NAME
,      BLOCK_NAME
,      MAX_NUMBER_OF_NAV_BUTTONS
FROM APPS.HR_NAVIGATION_UNITS_VL;

Dependencies

[top of page]

APPS.HR_NAVIGATION_UNITS_VL references the following:

APPS: HR_NAVIGATION_UNITS; HR_NAVIGATION_UNITS_TL

APPS.HR_NAVIGATION_UNITS_VL is referenced by following:

APPS: HR_NAVIGATION_UNITS_V