select RWTYP || '-' || RWNAME as MOID,NVL(RWVALUE,RWNAME) as MOTEXT, NVL(RWDESC,'keine Beschreibung für '||RWNAME) as MODESC  from CCRW where RWNAME is not null and ((RWTYP='DQUERY' and RWPARENT='QUERIES') or (RWTYP='TYPE' and RWPARENT='TYPES')) union select 'MFILE-' || MFILEID as MOID, 'Managed File ' || MFILEID as MOTEXT, MFILETYPE || ' managed file, Originalname ' || MFILENAME as MODESC from CCMFILES