VIEW: APPS.BSC_BIS_DIM_LEVELS_V

Source

View Text - Preformatted

SELECT SL.DIM_LEVEL_ID, IL.NAME NAME, IL.SHORT_NAME, IL.DIMENSION_ID, DECODE(IL.SOURCE, 'EDW', IL.SHORT_NAME || '_LTC', IL.LEVEL_VALUES_VIEW_NAME ) LEVEL_VIEW_NAME, SL.LEVEL_VIEW_NAME BSC_LEVEL_VIEW_NAME, NVL(SL.SOURCE, 'PMF') BSC_SOURCE, IL.SOURCE SOURCE, DECODE(SL.SOURCE, 'PMF', 1, 0) IMPORTED_FLAG FROM BIS_LEVELS_VL IL, BSC_SYS_DIM_LEVELS_B SL WHERE IL.SHORT_NAME = SL.SHORT_NAME
   

View Text - HTML Formatted

SELECT SL.DIM_LEVEL_ID
, IL.NAME NAME
, IL.SHORT_NAME
, IL.DIMENSION_ID
, DECODE(IL.SOURCE
, 'EDW'
, IL.SHORT_NAME || '_LTC'
, IL.LEVEL_VALUES_VIEW_NAME ) LEVEL_VIEW_NAME
, SL.LEVEL_VIEW_NAME BSC_LEVEL_VIEW_NAME
, NVL(SL.SOURCE
, 'PMF') BSC_SOURCE
, IL.SOURCE SOURCE
, DECODE(SL.SOURCE
, 'PMF'
, 1
, 0) IMPORTED_FLAG
FROM BIS_LEVELS_VL IL
, BSC_SYS_DIM_LEVELS_B SL
WHERE IL.SHORT_NAME = SL.SHORT_NAME