[Home] [Help]
View: BSC_TAB_VIEW_LABELS_VL
Product: | FND - Application Object Library |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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')