Rem
Rem $Header: onevadet.sql 27-feb-01.16:34:55 dthompso Exp $
Rem
Rem onevadet.sql
Rem
Rem  Copyright (c) Oracle Corporation 2000, 2001. All Rights Reserved.
Rem
Rem    NAME
Rem      onevadet.sql - all$olap_descriptor_types
Rem
Rem    DESCRIPTION
Rem      Metadata types that descriptor can be applied to.
Rem
Rem    NOTES
Rem      
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    dthompso    02/27/01 - change security implementation
Rem    dthompso    04/26/00 - Initial Version
Rem    dthompso    01/00/00 - Created
Rem

CREATE OR REPLACE VIEW all$olap_descriptor_types AS SELECT 
  cty.name descriptor_type
, ot.name entity_type
FROM
  cwm$classificationtype cty
, cwm$objecttype ot 
WHERE cty.name <> 'ORACLE_OLAP_CATALOG'
AND cty.irid = ot.classificationtype_irid
WITH READ ONLY
/