VIEW: APPS.HR_NAVIGATION_UNITS_V

Source

View Text - Preformatted

SELECT HNU.ROW_ID 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_VL 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 UNION SELECT HNU.ROW_ID 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 , FUN.USER_FUNCTION_NAME user_form_Name, WF.WORKFLOW_NAME FROM HR_NAVIGATION_UNITS_VL HNU, FND_FORM_FUNCTIONS_VL FUN, HR_WORKFLOWS WF WHERE FUN.function_name = HNU.FORM_NAME AND length(HNU.FORM_NAME) > 8 AND WF.WORKFLOW_ID (+) = HNU.DEFAULT_WORKFLOW_ID

View Text - HTML Formatted

SELECT HNU.ROW_ID 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_VL 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 UNION SELECT HNU.ROW_ID 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
, FUN.USER_FUNCTION_NAME USER_FORM_NAME
, WF.WORKFLOW_NAME
FROM HR_NAVIGATION_UNITS_VL HNU
, FND_FORM_FUNCTIONS_VL FUN
, HR_WORKFLOWS WF
WHERE FUN.FUNCTION_NAME = HNU.FORM_NAME
AND LENGTH(HNU.FORM_NAME) > 8
AND WF.WORKFLOW_ID (+) = HNU.DEFAULT_WORKFLOW_ID