DBA Data[Home] [Help]

VIEW: APPS.HR_NAVIGATION_PATHS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID ,B.NAV_PATH_ID ,B.FROM_NAV_NODE_USAGE_ID ,B.TO_NAV_NODE_USAGE_ID ,B.NAV_BUTTON_REQUIRED ,B.SEQUENCE ,T.OVERRIDE_LABEL FROM HR_NAVIGATION_PATHS B, HR_NAVIGATION_PATHS_TL T WHERE B.NAV_PATH_ID = T.NAV_PATH_ID AND T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.NAV_PATH_ID
, B.FROM_NAV_NODE_USAGE_ID
, B.TO_NAV_NODE_USAGE_ID
, B.NAV_BUTTON_REQUIRED
, B.SEQUENCE
, T.OVERRIDE_LABEL
FROM HR_NAVIGATION_PATHS B
, HR_NAVIGATION_PATHS_TL T
WHERE B.NAV_PATH_ID = T.NAV_PATH_ID
AND T.LANGUAGE = USERENV('LANG')