VIEW: APPS.BSC_TAB_VIEWS_VL

Source

View Text - Preformatted

SELECT B.TAB_ID, B.TAB_VIEW_ID, DECODE(B.TAB_VIEW_ID, -1, LU.MEANING, -2, LU.MEANING, TL.NAME) NAME, DECODE(B.TAB_VIEW_ID, -1, LU.MEANING, -2, LU.MEANING, TL.HELP) HELP, B.ENABLED_FLAG, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM BSC_TAB_VIEWS_B B, BSC_TAB_VIEWS_TL TL, BSC_LOOKUPS LU WHERE B.TAB_ID = TL.TAB_ID AND B.TAB_VIEW_ID = TL.TAB_VIEW_ID AND TL.LANGUAGE = userenv('LANG') AND LU.APPLICATION_ID = 271 AND LU.LOOKUP_TYPE = 'BSC_UI_IVIEWER' AND LU.LOOKUP_CODE = DECODE(B.TAB_VIEW_ID, -1, 'DETAILED_VIEW', 'TREE_VIEW')

View Text - HTML Formatted

SELECT B.TAB_ID
, B.TAB_VIEW_ID
, DECODE(B.TAB_VIEW_ID
, -1
, LU.MEANING
, -2
, LU.MEANING
, TL.NAME) NAME
, DECODE(B.TAB_VIEW_ID
, -1
, LU.MEANING
, -2
, LU.MEANING
, TL.HELP) HELP
, B.ENABLED_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM BSC_TAB_VIEWS_B B
, BSC_TAB_VIEWS_TL TL
, BSC_LOOKUPS LU
WHERE B.TAB_ID = TL.TAB_ID
AND B.TAB_VIEW_ID = TL.TAB_VIEW_ID
AND TL.LANGUAGE = USERENV('LANG')
AND LU.APPLICATION_ID = 271
AND LU.LOOKUP_TYPE = 'BSC_UI_IVIEWER'
AND LU.LOOKUP_CODE = DECODE(B.TAB_VIEW_ID
, -1
, 'DETAILED_VIEW'
, 'TREE_VIEW')