VIEW: OLAPSYS.ALL$OLAP2_AWVIEWS

Source

View Text - Preformatted

select
awv.view_owner view_owner,
awv.view_name view_name,
col.name rowtocellcol_name,
awv.aw_owner aw_owner,
awv.aw_name aw_name
from olapsys.cwm2$awviews awv,
     sys.col$ col
where awv.table_id = col.obj# (+) and
      awv.rowtocellcol_id = col.col# (+)
with read only

View Text - HTML Formatted

SELECT AWV.VIEW_OWNER VIEW_OWNER
, AWV.VIEW_NAME VIEW_NAME
, COL.NAME ROWTOCELLCOL_NAME
, AWV.AW_OWNER AW_OWNER
, AWV.AW_NAME AW_NAME FROM OLAPSYS.CWM2$AWVIEWS AWV
, SYS.COL$ COL WHERE AWV.TABLE_ID = COL.OBJ# (+) AND AWV.ROWTOCELLCOL_ID = COL.COL# (+) WITH READ ONLY