SELECT B.ROWID ROW_ID ,B.NAV_UNIT_ID ,B.DEFAULT_WORKFLOW_ID ,B.APPLICATION_ABBREV ,T.DEFAULT_LABEL ,B.FORM_NAME ,B.BLOCK_NAME ,B.MAX_NUMBER_OF_NAV_BUTTONS FROM HR_NAVIGATION_UNITS B, HR_NAVIGATION_UNITS_TL T WHERE B.NAV_UNIT_ID = T.NAV_UNIT_ID AND T.LANGUAGE = userenv('LANG')
SELECT B.ROWID ROW_ID
, B.NAV_UNIT_ID
, B.DEFAULT_WORKFLOW_ID
, B.APPLICATION_ABBREV
, T.DEFAULT_LABEL
, B.FORM_NAME
, B.BLOCK_NAME
, B.MAX_NUMBER_OF_NAV_BUTTONS
FROM HR_NAVIGATION_UNITS B
, HR_NAVIGATION_UNITS_TL T
WHERE B.NAV_UNIT_ID = T.NAV_UNIT_ID
AND T.LANGUAGE = USERENV('LANG')
|
|
|