View: EDW_SEC_LVL_INFO_V

Product:	BIS - Applications BIS
Description:	EDW_SEC_LVL_INFO_V
Implementation/DBA Data:	APPS.EDW_SEC_LVL_INFO_V

View Text

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'

Columns