Rem
Rem $Header: onevddsc.sql 26-apr-2000.16:23:21 dthompso Exp $
Rem
Rem onevddsc.sql
Rem
Rem  Copyright (c) Oracle Corporation 2000. All Rights Reserved.
Rem
Rem    NAME
Rem      onevddsc.sql - dba$olap_descriptors
Rem
Rem    DESCRIPTION
Rem      Descriptor types and values.
Rem
Rem    NOTES
Rem      
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    dthompso    04/26/00 - Initial Version
Rem    dthompso    01/00/00 - Created
Rem

CREATE OR REPLACE VIEW dba$olap_descriptors AS SELECT 
  c.irid descriptor_id
, c.name descriptor_value
, cty.name descriptor_type
, c.description description
FROM
  cwm$classification c
, cwm$classificationtype cty
WHERE cty.irid = c.classificationtype_irid
AND cty.name <> 'ORACLE_OLAP_CATALOG'
WITH READ ONLY
/