DBA Data[Home] [Help]

VIEW: OLAPSYS.MRV$MRALL_ENTITY_PARAMETERS

Source

View Text - Preformatted

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

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