select
edu.descriptor_id descriptor_id,
edu.entity_owner entity_owner,
edu.entity_name entity_name,
edu.child_entity_name child_entity_name,
edu.secondary_child_entity_name secondary_child_entity_name
from olapsys.cwm2$mrall_entity_desc_uses edu,
olapsys.olap_session_objects oso
where oso.version_id = edu.version_id and
oso.id = edu.id
SELECT
EDU.DESCRIPTOR_ID DESCRIPTOR_ID
,
EDU.ENTITY_OWNER ENTITY_OWNER
,
EDU.ENTITY_NAME ENTITY_NAME
,
EDU.CHILD_ENTITY_NAME CHILD_ENTITY_NAME
,
EDU.SECONDARY_CHILD_ENTITY_NAME SECONDARY_CHILD_ENTITY_NAME
FROM OLAPSYS.CWM2$MRALL_ENTITY_DESC_USES EDU
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = EDU.VERSION_ID AND
OSO.ID = EDU.ID
|
|
|