DBA Data[Home] [Help]

VIEW: APPS.JTF_NAV_TABS_VL

Source

View Text - Preformatted

SELECT b.tab_id tab_id, b.tab_value tab_value, b.navigator_type navigator_type, b.application_id application_id, t.tab_label tab_label, b.icon_name icon_name, b.sequence_number sequence_number, b.created_by created_by, b.creation_date creation_date, b.last_update_login last_update_login, b.last_update_date last_update_date, b.last_updated_by last_updated_by FROM jtf_nav_tabs_b b, jtf_nav_tabs_tl t WHERE b.tab_id = t.tab_id AND t.language = userenv('LANG')
View Text - HTML Formatted

SELECT B.TAB_ID TAB_ID
, B.TAB_VALUE TAB_VALUE
, B.NAVIGATOR_TYPE NAVIGATOR_TYPE
, B.APPLICATION_ID APPLICATION_ID
, T.TAB_LABEL TAB_LABEL
, B.ICON_NAME ICON_NAME
, B.SEQUENCE_NUMBER SEQUENCE_NUMBER
, B.CREATED_BY CREATED_BY
, B.CREATION_DATE CREATION_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
FROM JTF_NAV_TABS_B B
, JTF_NAV_TABS_TL T
WHERE B.TAB_ID = T.TAB_ID
AND T.LANGUAGE = USERENV('LANG')