select
ceu.catalog_id catalog_id,
ceu.entity_owner entity_owner,
ceu.entity_name entity_name,
ceu.child_entity_name child_entity_name
from olapsys.cwm2$mrall_catalog_entity_uses ceu,
olapsys.olap_session_objects oso
where oso.version_id = ceu.version_id and
oso.id = ceu.id
SELECT
CEU.CATALOG_ID CATALOG_ID
,
CEU.ENTITY_OWNER ENTITY_OWNER
,
CEU.ENTITY_NAME ENTITY_NAME
,
CEU.CHILD_ENTITY_NAME CHILD_ENTITY_NAME
FROM OLAPSYS.CWM2$MRALL_CATALOG_ENTITY_USES CEU
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = CEU.VERSION_ID AND
OSO.ID = CEU.ID
|
|
|