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, sp.parm_value,
u.username
from system.repcat$_refresh_templates rt,
system.repcat$_template_parms tp,
system.repcat$_user_parm_values sp,
dba_users u,
system.repcat$_template_types tt
where tp.refresh_template_id = rt.refresh_template_id
and tp.template_parameter_id = sp.template_parameter_id
and sp.user_id = u.user_id
and rt.template_type_id = tt.template_type_id
and bitand(rawtohex(tt.flags),1) = 1
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
, SP.PARM_VALUE
,
U.USERNAME
FROM SYSTEM.REPCAT$_REFRESH_TEMPLATES RT
,
SYSTEM.REPCAT$_TEMPLATE_PARMS TP
,
SYSTEM.REPCAT$_USER_PARM_VALUES SP
,
DBA_USERS U
,
SYSTEM.REPCAT$_TEMPLATE_TYPES TT
WHERE TP.REFRESH_TEMPLATE_ID = RT.REFRESH_TEMPLATE_ID
AND TP.TEMPLATE_PARAMETER_ID = SP.TEMPLATE_PARAMETER_ID
AND SP.USER_ID = U.USER_ID
AND RT.TEMPLATE_TYPE_ID = TT.TEMPLATE_TYPE_ID
AND BITAND(RAWTOHEX(TT.FLAGS)
, 1) = 1
|
|
|