VIEW: APPS.CN_DIMENSION_TABLES_V

Source

View Text - Preformatted

SELECT dim.dimension_id, tab.table_id, col.column_id, tab.name, col.name FROM CN_DIMENSIONS DIM,CN_OBJ_TABLES_V TAB,CN_OBJ_COLUMNS_V COL WHERE col.table_id = tab.table_id and col.primary_key = 'Y' and col.dimension_id = dim.dimension_id

View Text - HTML Formatted

SELECT DIM.DIMENSION_ID
, TAB.TABLE_ID
, COL.COLUMN_ID
, TAB.NAME
, COL.NAME
FROM CN_DIMENSIONS DIM
, CN_OBJ_TABLES_V TAB
, CN_OBJ_COLUMNS_V COL
WHERE COL.TABLE_ID = TAB.TABLE_ID
AND COL.PRIMARY_KEY = 'Y'
AND COL.DIMENSION_ID = DIM.DIMENSION_ID