SELECT BSC_LEV.SHORT_NAME , BIS_LEV.LEVEL_ID , BSC_LEV.DIM_LEVEL_ID ,
BIS_LEV.APPLICATION_ID ,
DECODE(BSC_LEV.SOURCE, 'PMF', BIS_LEV.LEVEL_VALUES_VIEW_NAME,
BSC_LEV.LEVEL_VIEW_NAME) ,
BIS_LEV.WHERE_CLAUSE , BSC_LEV.NAME , BSC_LEV.HELP , BIS_LEV.SOURCE ,
NVL (BSC_LEV.SOURCE, 'BSC') DATA_SOURCE ,
BIS_LEV.COMPARISON_LABEL_CODE ,
BSC_LEV.TOTAL_DISP_NAME , BSC_LEV.COMP_DISP_NAME ,
BSC_LEV.LEVEL_TABLE_NAME , BSC_LEV.TABLE_TYPE , BSC_LEV.LEVEL_PK_COL ,
BSC_LEV.ABBREVIATION , BSC_LEV.VALUE_ORDER_BY , BSC_LEV.COMP_ORDER_BY ,
NVL (BSC_LEV.EDW_FLAG, 0) AS EDW_FLAG ,
BSC_LEV.CUSTOM_GROUP , BSC_LEV.USER_KEY_SIZE , BSC_LEV.DISP_KEY_SIZE ,
BSC_LEV.EDW_DIM_ID , BSC_LEV.EDW_DIM_LEVEL_ID , BSC_LEV.CREATION_DATE ,
BSC_LEV.CREATED_BY ,BSC_LEV.LAST_UPDATE_DATE ,BSC_LEV.LAST_UPDATED_BY ,
BSC_LEV.LAST_UPDATE_LOGIN ,BIS_LEV.MASTER_LEVEL ,BIS_LEV.LONG_LOV ,
BIS_LEV.DEFAULT_SEARCH ,BIS_LEV.ENABLED, BIS_LEV.DRILL_TO_FORM_FUNCTION,BIS_LEV.HIDE_IN_DESIGN
FROM
BIS_LEVELS_VL BIS_LEV , BSC_SYS_DIM_LEVELS_VL BSC_LEV WHERE
BIS_LEV.SHORT_NAME = BSC_LEV.SHORT_NAME
SELECT BSC_LEV.SHORT_NAME
, BIS_LEV.LEVEL_ID
, BSC_LEV.DIM_LEVEL_ID
,
BIS_LEV.APPLICATION_ID
,
DECODE(BSC_LEV.SOURCE
, 'PMF'
, BIS_LEV.LEVEL_VALUES_VIEW_NAME
,
BSC_LEV.LEVEL_VIEW_NAME)
,
BIS_LEV.WHERE_CLAUSE
, BSC_LEV.NAME
, BSC_LEV.HELP
, BIS_LEV.SOURCE
,
NVL (BSC_LEV.SOURCE
, 'BSC') DATA_SOURCE
,
BIS_LEV.COMPARISON_LABEL_CODE
,
BSC_LEV.TOTAL_DISP_NAME
, BSC_LEV.COMP_DISP_NAME
,
BSC_LEV.LEVEL_TABLE_NAME
, BSC_LEV.TABLE_TYPE
, BSC_LEV.LEVEL_PK_COL
,
BSC_LEV.ABBREVIATION
, BSC_LEV.VALUE_ORDER_BY
, BSC_LEV.COMP_ORDER_BY
,
NVL (BSC_LEV.EDW_FLAG
, 0) AS EDW_FLAG
,
BSC_LEV.CUSTOM_GROUP
, BSC_LEV.USER_KEY_SIZE
, BSC_LEV.DISP_KEY_SIZE
,
BSC_LEV.EDW_DIM_ID
, BSC_LEV.EDW_DIM_LEVEL_ID
, BSC_LEV.CREATION_DATE
,
BSC_LEV.CREATED_BY
, BSC_LEV.LAST_UPDATE_DATE
, BSC_LEV.LAST_UPDATED_BY
,
BSC_LEV.LAST_UPDATE_LOGIN
, BIS_LEV.MASTER_LEVEL
, BIS_LEV.LONG_LOV
,
BIS_LEV.DEFAULT_SEARCH
, BIS_LEV.ENABLED
, BIS_LEV.DRILL_TO_FORM_FUNCTION
, BIS_LEV.HIDE_IN_DESIGN
FROM
BIS_LEVELS_VL BIS_LEV
, BSC_SYS_DIM_LEVELS_VL BSC_LEV WHERE
BIS_LEV.SHORT_NAME = BSC_LEV.SHORT_NAME
|
|
|