View: EDW_SEC_DIM_INFO_V

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

View Text

SELECT DIM.DIM_ID DIM_ID
, DIM.DIM_NAME
, DIM.DIM_LONG_NAME
, DIM.DIM_NAME TABLE_NAME
, COLS.COLUMN_NAME LOWEST_LEVEL_COL_NAME
, SUBSTR(DIM.DIM_NAME
, 5
, 30) CONTEXT_NAME
FROM EDW_DIMENSIONS_MD_V DIM
, EDW_UNIQUE_KEYS_MD_V KEYS
, EDW_UNIQUE_KEY_COLUMNS_MD_V COLS
WHERE DIM.DIM_ID = KEYS.ENTITY_ID
AND KEYS.KEY_ID = COLS.KEY_ID
AND KEYS.PRIMARYKEY = 1

Columns