[Home] [Help]
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
Name |
ROW_ID |
NAV_UNIT_ID |
DEFAULT_WORKFLOW_ID |
APPLICATION_ABBREV |
DEFAULT_LABEL |
FORM_NAME |
MAX_NUMBER_OF_NAV_BUTTONS |
BLOCK_NAME |
USER_FORM_NAME |
WORKFLOW_NAME |