VIEW: SYS.ALL_REPCAT_TEMPLATE_PARMS

Source

View Text - Preformatted

select rt.refresh_template_name,rt.owner,
rt.refresh_group_name,rt.template_comment,
nvl(rt.public_template,'N'),tp.parameter_name,
tp.default_parm_value, tp.prompt_string, tp.user_override
from system.repcat$_refresh_templates rt,
  system.repcat$_template_parms tp,
  system.repcat$_template_types tt
where tp.refresh_template_id = rt.refresh_template_id
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
  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')
  union
  select rt.refresh_template_id
  from system.repcat$_refresh_templates rt
  where nvl(rt.public_template,'N') = 'N'
  and exists
    (select 1 from v$enabledprivs
     where priv_number in (-174 /* alter any snapshot */))
  union
  select rt.refresh_template_id
  from system.repcat$_refresh_templates rt, sys.user$ u
  where  nvl(rt.public_template,'N') = 'N'
  and rt.owner = u.name
  and u.user#  = userenv('SCHEMAID') )

View Text - HTML Formatted

SELECT RT.REFRESH_TEMPLATE_NAME
, RT.OWNER
, RT.REFRESH_GROUP_NAME
, RT.TEMPLATE_COMMENT
, NVL(RT.PUBLIC_TEMPLATE
, 'N')
, TP.PARAMETER_NAME
, TP.DEFAULT_PARM_VALUE
, TP.PROMPT_STRING
, TP.USER_OVERRIDE FROM SYSTEM.REPCAT$_REFRESH_TEMPLATES RT
, SYSTEM.REPCAT$_TEMPLATE_PARMS TP
, SYSTEM.REPCAT$_TEMPLATE_TYPES TT WHERE TP.REFRESH_TEMPLATE_ID = RT.REFRESH_TEMPLATE_ID 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
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') UNION SELECT RT.REFRESH_TEMPLATE_ID
FROM SYSTEM.REPCAT$_REFRESH_TEMPLATES RT
WHERE NVL(RT.PUBLIC_TEMPLATE
, 'N') = 'N'
AND EXISTS (SELECT 1
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-174 /* ALTER ANY SNAPSHOT */)) UNION SELECT RT.REFRESH_TEMPLATE_ID
FROM SYSTEM.REPCAT$_REFRESH_TEMPLATES RT
, SYS.USER$ U
WHERE NVL(RT.PUBLIC_TEMPLATE
, 'N') = 'N'
AND RT.OWNER = U.NAME
AND U.USER# = USERENV('SCHEMAID') )