select
ep.DESCRIPTOR_ID,
ep.DESCRIPTOR_NAME,
ep.ENTITY_OWNER,
ep.ENTITY_NAME,
ep.CHILD_ENTITY_NAME,
ep.SECONDARY_CHILD_ENTITY_NAME,
ep.PARAMETER_NAME,
ep.PARAMETER_VALUE
from olapsys.cwm2$mrall_entity_parameters ep,
olapsys.olap_session_objects oso
where oso.version_id = ep.version_id and
oso.id = ep.id
SELECT
EP.DESCRIPTOR_ID
,
EP.DESCRIPTOR_NAME
,
EP.ENTITY_OWNER
,
EP.ENTITY_NAME
,
EP.CHILD_ENTITY_NAME
,
EP.SECONDARY_CHILD_ENTITY_NAME
,
EP.PARAMETER_NAME
,
EP.PARAMETER_VALUE
FROM OLAPSYS.CWM2$MRALL_ENTITY_PARAMETERS EP
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = EP.VERSION_ID AND
OSO.ID = EP.ID
|
|
|