VIEW: APPS.BSC_SYS_DIM_LEVELS_VL

Source

View Text - Preformatted

SELECT B.DIM_LEVEL_ID, TL.NAME, TL.HELP, TL.TOTAL_DISP_NAME, TL.COMP_DISP_NAME, B.LEVEL_TABLE_NAME, B.TABLE_TYPE, B.LEVEL_PK_COL, B.ABBREVIATION, B.VALUE_ORDER_BY, B.COMP_ORDER_BY,B.CUSTOM_GROUP, B.USER_KEY_SIZE, B.DISP_KEY_SIZE, NVL(B.EDW_FLAG,0) AS EDW_FLAG, B.EDW_DIM_ID, B.EDW_DIM_LEVEL_ID, B.LEVEL_VIEW_NAME, B.SHORT_NAME, NVL(B.SOURCE,'BSC') AS SOURCE, B.CREATED_BY,B.CREATION_DATE,B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE,B.LAST_UPDATE_LOGIN FROM BSC_SYS_DIM_LEVELS_B B, BSC_SYS_DIM_LEVELS_TL TL WHERE B.DIM_LEVEL_ID = TL.DIM_LEVEL_ID AND TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.DIM_LEVEL_ID
, TL.NAME
, TL.HELP
, TL.TOTAL_DISP_NAME
, TL.COMP_DISP_NAME
, B.LEVEL_TABLE_NAME
, B.TABLE_TYPE
, B.LEVEL_PK_COL
, B.ABBREVIATION
, B.VALUE_ORDER_BY
, B.COMP_ORDER_BY
, B.CUSTOM_GROUP
, B.USER_KEY_SIZE
, B.DISP_KEY_SIZE
, NVL(B.EDW_FLAG
, 0) AS EDW_FLAG
, B.EDW_DIM_ID
, B.EDW_DIM_LEVEL_ID
, B.LEVEL_VIEW_NAME
, B.SHORT_NAME
, NVL(B.SOURCE
, 'BSC') AS SOURCE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM BSC_SYS_DIM_LEVELS_B B
, BSC_SYS_DIM_LEVELS_TL TL
WHERE B.DIM_LEVEL_ID = TL.DIM_LEVEL_ID
AND TL.LANGUAGE = USERENV('LANG')