VIEW: SYS.DBA_REPCAT_TEMPLATE_SITES

Source

View Text - Preformatted

select ts.refresh_template_name, ts.refresh_group_name, ts.template_owner,
  ts.user_name,ts.site_name,ss.site_name,
  decode(status,-1,'DELETED',0,'INSTALLING',1,'INSTALLED','UNDEFINED'),
  instantiation_date
from system.repcat$_template_sites ts,
  sys.snap_site$ ss
where ts.status != -100
and ts.repapi_site_id = ss.site_id (+)

View Text - HTML Formatted

SELECT TS.REFRESH_TEMPLATE_NAME
, TS.REFRESH_GROUP_NAME
, TS.TEMPLATE_OWNER
, TS.USER_NAME
, TS.SITE_NAME
, SS.SITE_NAME
, DECODE(STATUS
, -1
, 'DELETED'
, 0
, 'INSTALLING'
, 1
, 'INSTALLED'
, 'UNDEFINED')
, INSTANTIATION_DATE FROM SYSTEM.REPCAT$_TEMPLATE_SITES TS
, SYS.SNAP_SITE$ SS WHERE TS.STATUS != -100 AND TS.REPAPI_SITE_ID = SS.SITE_ID (+)