VIEW: OLAPSYS.ALL$OLAP2_AWVIEWCOLS

Source

View Text - Preformatted

select
awv.view_owner view_owner,
awv.view_name view_name,
col.name column_name,
awvc.awobject awobject
from olapsys.cwm2$awviews awv,
     olapsys.cwm2$awviewcols awvc,
     sys.col$ col
where awvc.awviews_irid = awv.irid and
      awv.table_id = col.obj# and
      awvc.column_id = col.col#
with read only

View Text - HTML Formatted

SELECT AWV.VIEW_OWNER VIEW_OWNER
, AWV.VIEW_NAME VIEW_NAME
, COL.NAME COLUMN_NAME
, AWVC.AWOBJECT AWOBJECT FROM OLAPSYS.CWM2$AWVIEWS AWV
, OLAPSYS.CWM2$AWVIEWCOLS AWVC
, SYS.COL$ COL WHERE AWVC.AWVIEWS_IRID = AWV.IRID AND AWV.TABLE_ID = COL.OBJ# AND AWVC.COLUMN_ID = COL.COL# WITH READ ONLY