eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS.KU$_EDITION_PROC_EXISTS_VIEW

Source

View Text - Preformatted


select oo.obj#, o.owner_name, oo.type#
  from  sys.ku$_edition_schemaobj_view o, sys.ku$_edition_obj_view oo
  where (oo.type# = 7 or oo.type# = 8 or oo.type# = 9 or oo.type# = 11)
    and oo.obj#  = o.obj_num and oo.linkname is NULL
 and  (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (oo.owner#,0) OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT OO.OBJ#
, O.OWNER_NAME
, OO.TYPE#
FROM SYS.KU$_EDITION_SCHEMAOBJ_VIEW O
, SYS.KU$_EDITION_OBJ_VIEW OO
WHERE (OO.TYPE# = 7 OR OO.TYPE# = 8 OR OO.TYPE# = 9 OR OO.TYPE# = 11)
AND OO.OBJ# = O.OBJ_NUM
AND OO.LINKNAME IS NULL
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (OO.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))