VIEW: SYS.DBA_REPGENERATED

Source

View Text - Preformatted

select r.sname, r.oname, r.type, r.base_sname, r.base_oname, r.base_type,
  r.package_prefix, r.procedure_prefix, r.distributed, r.reason
from repcat_generated r
where ((r.reason  = 'PROCEDURAL REPLICATION WRAPPER' and r.type != 'SYNONYM')
     or r.reason != 'PROCEDURAL REPLICATION WRAPPER')

View Text - HTML Formatted

SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.BASE_SNAME
, R.BASE_ONAME
, R.BASE_TYPE
, R.PACKAGE_PREFIX
, R.PROCEDURE_PREFIX
, R.DISTRIBUTED
, R.REASON FROM REPCAT_GENERATED R WHERE ((R.REASON = 'PROCEDURAL REPLICATION WRAPPER'
AND R.TYPE != 'SYNONYM') OR R.REASON != 'PROCEDURAL REPLICATION WRAPPER')