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.ALL_REPCATLOG

Source

View Text - Preformatted


select r.id, r.source, r.userid, r.timestamp, r.role, r.master, r.sname,
  r.request, r.oname, r.type, r.status, r.message, r.errnum, r.gname
from repcat_repcatlog r, all_objects o
where (r.sname = 'PUBLIC' or r.sname in (select u.username from all_users u))
  and r.sname = o.owner
  and r.oname = o.object_name
  and r.type = o.object_type
union
select r.id, r.source, r.userid, r.timestamp, r.role, r.master, r.sname,
  r.request, r.oname, r.type, r.status, r.message, r.errnum, r.gname
from user_repcatlog r

View Text - HTML Formatted

SELECT R.ID
, R.SOURCE
, R.USERID
, R.TIMESTAMP
, R.ROLE
, R.MASTER
, R.SNAME
, R.REQUEST
, R.ONAME
, R.TYPE
, R.STATUS
, R.MESSAGE
, R.ERRNUM
, R.GNAME FROM REPCAT_REPCATLOG R
, ALL_OBJECTS O WHERE (R.SNAME = 'PUBLIC' OR R.SNAME IN (SELECT U.USERNAME
FROM ALL_USERS U))
AND R.SNAME = O.OWNER
AND R.ONAME = O.OBJECT_NAME
AND R.TYPE = O.OBJECT_TYPE UNION SELECT R.ID
, R.SOURCE
, R.USERID
, R.TIMESTAMP
, R.ROLE
, R.MASTER
, R.SNAME
, R.REQUEST
, R.ONAME
, R.TYPE
, R.STATUS
, R.MESSAGE
, R.ERRNUM
, R.GNAME FROM USER_REPCATLOG R