VIEW: SYS.USER_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,
  system.repcat$_refresh_templates rt,
  system.repcat$_template_types tt
where ts.repapi_site_id = ss.site_id (+)
and rt.refresh_template_name = ts.refresh_template_name
and rt.template_type_id = tt.template_type_id
and bitand(rawtohex(tt.flags),1) = 1
and rt.refresh_template_id in
  (select rt.refresh_template_id
   from system.repcat$_refresh_templates rt
   where public_template = 'Y'
   union
   select rt.refresh_template_id
   from system.repcat$_refresh_templates rt,
   system.repcat$_user_authorizations at,
   sys.all_users au
   where at.refresh_template_id = rt.refresh_template_id
   and au.user_id = at.user_id
   and nvl(rt.public_template,'N') = 'N'
   and au.user_id = userenv('SCHEMAID'))

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
, SYSTEM.REPCAT$_REFRESH_TEMPLATES RT
, SYSTEM.REPCAT$_TEMPLATE_TYPES TT WHERE TS.REPAPI_SITE_ID = SS.SITE_ID (+) AND RT.REFRESH_TEMPLATE_NAME = TS.REFRESH_TEMPLATE_NAME AND RT.TEMPLATE_TYPE_ID = TT.TEMPLATE_TYPE_ID AND BITAND(RAWTOHEX(TT.FLAGS)
, 1) = 1 AND RT.REFRESH_TEMPLATE_ID IN (SELECT RT.REFRESH_TEMPLATE_ID
FROM SYSTEM.REPCAT$_REFRESH_TEMPLATES RT
WHERE PUBLIC_TEMPLATE = 'Y' UNION SELECT RT.REFRESH_TEMPLATE_ID
FROM SYSTEM.REPCAT$_REFRESH_TEMPLATES RT
, SYSTEM.REPCAT$_USER_AUTHORIZATIONS AT
, SYS.ALL_USERS AU
WHERE AT.REFRESH_TEMPLATE_ID = RT.REFRESH_TEMPLATE_ID
AND AU.USER_ID = AT.USER_ID
AND NVL(RT.PUBLIC_TEMPLATE
, 'N') = 'N'
AND AU.USER_ID = USERENV('SCHEMAID'))