View: HR_NAVIGATION_UNITS_V

Product:	PER - Human Resources
Description:	The view is used in the "Define Navigation Units" form.
Implementation/DBA Data:	APPS.HR_NAVIGATION_UNITS_V

View Text

SELECT HNU.ROWID ROW_ID
, HNU.NAV_UNIT_ID
, HNU.DEFAULT_WORKFLOW_ID
, HNU.APPLICATION_ABBREV
, HNU.DEFAULT_LABEL
, HNU.FORM_NAME
, HNU.MAX_NUMBER_OF_NAV_BUTTONS
, HNU.BLOCK_NAME
, INITCAP(LTRIM(UPPER(FF.USER_FORM_NAME)
, 'F4 ')) USER_FORM_NAME
, WF.WORKFLOW_NAME
FROM HR_NAVIGATION_UNITS HNU
, FND_FORM_VL FF
, HR_WORKFLOWS WF
WHERE FF.FORM_NAME = HNU.FORM_NAME
AND HR_GENERAL.CHK_APPLICATION_ID( FF.APPLICATION_ID) = 'TRUE'
AND WF.WORKFLOW_ID (+) = HNU.DEFAULT_WORKFLOW_ID

Columns