VIEW: APPS.EDW_SEC_DIM_INFO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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