select
eep.DESCRIPTOR_ID,
eep.DESCRIPTOR_NAME,
eep.ENTITY_OWNER,
eep.ENTITY_NAME,
eep.CHILD_ENTITY_NAME,
eep.SECONDARY_CHILD_ENTITY_NAME,
eep.PARAMETER_NAME,
eep.PARAMETER_VALUE,
eep.PARAMETER_VALUE2,
eep.PARAMETER_VALUE3,
eep.PARAMETER_VALUE4,
eep.POSITION
from olapsys.cwm2$mrall_entity_ext_parms eep,
olapsys.olap_session_objects oso
where oso.version_id = eep.version_id and
oso.id = eep.id
SELECT
EEP.DESCRIPTOR_ID
,
EEP.DESCRIPTOR_NAME
,
EEP.ENTITY_OWNER
,
EEP.ENTITY_NAME
,
EEP.CHILD_ENTITY_NAME
,
EEP.SECONDARY_CHILD_ENTITY_NAME
,
EEP.PARAMETER_NAME
,
EEP.PARAMETER_VALUE
,
EEP.PARAMETER_VALUE2
,
EEP.PARAMETER_VALUE3
,
EEP.PARAMETER_VALUE4
,
EEP.POSITION
FROM OLAPSYS.CWM2$MRALL_ENTITY_EXT_PARMS EEP
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = EEP.VERSION_ID AND
OSO.ID = EEP.ID
|
|
|