VIEW: APPS.EDW_SEC_LVL_INFO_V

Source

View Text - Preformatted

SELECT dim_id, level_id, level_name, level_long_name, level_prefix||'_NAME' star_level_name_col_name FROM EDW_LEVELS_MD_V LVL,EDW_ALL_COLUMNS_MD_V COL WHERE lvl.level_id = col.entity_id and col.column_name = 'NAME'

View Text - HTML Formatted

SELECT DIM_ID
, LEVEL_ID
, LEVEL_NAME
, LEVEL_LONG_NAME
, LEVEL_PREFIX||'_NAME' STAR_LEVEL_NAME_COL_NAME
FROM EDW_LEVELS_MD_V LVL
, EDW_ALL_COLUMNS_MD_V COL
WHERE LVL.LEVEL_ID = COL.ENTITY_ID
AND COL.COLUMN_NAME = 'NAME'