VIEW: SYS.ALL_REPPROP

Source

View Text - Preformatted

select r.sname, r.oname, r.type, r.dblink, r.how, r.propagate_comment
from repcat_repprop r, all_users u, all_repobject ro
where r.sname = u.username
  and r.sname = ro.sname
  and r.oname = ro.oname
  and r.type = ro.type
  and ro.type in ('PROCEDURE', 'PACKAGE', 'PACKAGE BODY', 'TABLE', 'SNAPSHOT')

View Text - HTML Formatted

SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.DBLINK
, R.HOW
, R.PROPAGATE_COMMENT FROM REPCAT_REPPROP R
, ALL_USERS U
, ALL_REPOBJECT RO WHERE R.SNAME = U.USERNAME
AND R.SNAME = RO.SNAME
AND R.ONAME = RO.ONAME
AND R.TYPE = RO.TYPE
AND RO.TYPE IN ('PROCEDURE'
, 'PACKAGE'
, 'PACKAGE BODY'
, 'TABLE'
, 'SNAPSHOT')