VIEW: APPS.BSC_TAB_VIEW_LABELS_VL

Source

View Text - Preformatted

SELECT B.TAB_ID, B.TAB_VIEW_ID, B.LABEL_ID, B.LABEL_TYPE, B.LINK_ID, 
DECODE(B.LABEL_TYPE, 0,TL.NAME, 1,
(SELECT NAME FROM BSC_TAB_VIEWS_VL TV WHERE TV.TAB_ID = B.TAB_ID AND TV.TAB_VIEW_ID=B.LINK_ID), 2,
(SELECT MENU.USER_MENU_NAME FROM FND_MENUS_VL MENU WHERE B.LINK_ID= MENU.MENU_ID) ) NAME, TL.NOTE,
TL.TEXT_FLAG, TL.LEFT_POSITION, TL.TOP_POSITION, TL.WIDTH, TL.HEIGHT, TL.FONT_SIZE, TL.FONT_STYLE, 
TL.FONT_COLOR, TL.URL,B.FUNCTION_ID, 
B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM BSC_TAB_VIEW_LABELS_B B
, BSC_TAB_VIEW_LABELS_TL TL WHERE B.TAB_ID = TL.TAB_ID AND B.TAB_VIEW_ID = TL.TAB_VIEW_ID AND 
B.LABEL_ID = TL.LABEL_ID AND TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.TAB_ID
, B.TAB_VIEW_ID
, B.LABEL_ID
, B.LABEL_TYPE
, B.LINK_ID
, DECODE(B.LABEL_TYPE
, 0
, TL.NAME
, 1
, (SELECT NAME
FROM BSC_TAB_VIEWS_VL TV
WHERE TV.TAB_ID = B.TAB_ID
AND TV.TAB_VIEW_ID=B.LINK_ID)
, 2
, (SELECT MENU.USER_MENU_NAME
FROM FND_MENUS_VL MENU
WHERE B.LINK_ID= MENU.MENU_ID) ) NAME
, TL.NOTE
, TL.TEXT_FLAG
, TL.LEFT_POSITION
, TL.TOP_POSITION
, TL.WIDTH
, TL.HEIGHT
, TL.FONT_SIZE
, TL.FONT_STYLE
, TL.FONT_COLOR
, TL.URL
, B.FUNCTION_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM BSC_TAB_VIEW_LABELS_B B
, BSC_TAB_VIEW_LABELS_TL TL
WHERE B.TAB_ID = TL.TAB_ID
AND B.TAB_VIEW_ID = TL.TAB_VIEW_ID
AND B.LABEL_ID = TL.LABEL_ID
AND TL.LANGUAGE = USERENV('LANG')