select rt.refresh_template_name ias_template_name,
ro.schema_name,
ro.object_name,
ro.object_type object_type_id,
ot.object_type_name object_type,
ro.derived_from_sname,
ro.derived_from_oname
from system.repcat$_refresh_templates rt,
system.repcat$_template_objects ro,
system.repcat$_object_types ot,
system.repcat$_template_types tt
where rt.refresh_template_id = ro.refresh_template_id
and ro.object_type = ot.object_type_id
and rt.template_type_id = tt.template_type_id
and bitand(rawtohex(tt.flags),2) = 2
SELECT RT.REFRESH_TEMPLATE_NAME IAS_TEMPLATE_NAME
,
RO.SCHEMA_NAME
,
RO.OBJECT_NAME
,
RO.OBJECT_TYPE OBJECT_TYPE_ID
,
OT.OBJECT_TYPE_NAME OBJECT_TYPE
,
RO.DERIVED_FROM_SNAME
,
RO.DERIVED_FROM_ONAME
FROM SYSTEM.REPCAT$_REFRESH_TEMPLATES RT
,
SYSTEM.REPCAT$_TEMPLATE_OBJECTS RO
,
SYSTEM.REPCAT$_OBJECT_TYPES OT
,
SYSTEM.REPCAT$_TEMPLATE_TYPES TT
WHERE RT.REFRESH_TEMPLATE_ID = RO.REFRESH_TEMPLATE_ID
AND RO.OBJECT_TYPE = OT.OBJECT_TYPE_ID
AND RT.TEMPLATE_TYPE_ID = TT.TEMPLATE_TYPE_ID
AND BITAND(RAWTOHEX(TT.FLAGS)
, 2) = 2
|
|
|