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
View Text - HTML Formatted
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