VIEW: SYS.ALL_APPLY_HANDLE_COLLISIONS

Source

View Text - Preformatted

select hc."APPLY_NAME",hc."OBJECT_OWNER",hc."OBJECT_NAME",hc."SOURCE_OBJECT_OWNER",hc."SOURCE_OBJECT_NAME",hc."ENABLED",hc."SET_BY"
from DBA_APPLY_HANDLE_COLLISIONS hc, ALL_APPLY a, all_tables t
where hc.apply_name = a.apply_name and hc.object_owner = t.owner
      and hc.object_name = t.table_name

View Text - HTML Formatted

SELECT HC."APPLY_NAME"
, HC."OBJECT_OWNER"
, HC."OBJECT_NAME"
, HC."SOURCE_OBJECT_OWNER"
, HC."SOURCE_OBJECT_NAME"
, HC."ENABLED"
, HC."SET_BY" FROM DBA_APPLY_HANDLE_COLLISIONS HC
, ALL_APPLY A
, ALL_TABLES T WHERE HC.APPLY_NAME = A.APPLY_NAME
AND HC.OBJECT_OWNER = T.OWNER
AND HC.OBJECT_NAME = T.TABLE_NAME