VIEW: SYS._ALL_REPRESOLUTION

Source

View Text - Preformatted

select  sname,
        oname,
        conflict_type,
        reference_name,
        sequence_no,
        method_name,
        function_name,
        priority_group,
        resolution_comment,
        decode(conflict_type,
               'UPDATE',1,
               'UNIQUENESS',2,
               'DELETE',3,
               -1)
  from all_represolution
 where conflict_type in ('UNIQUENESS', 'DELETE', 'UNDEFINED')
union
select  /*+ ALL_ROWS */ resol.sname,
        resol.oname,
        resol.conflict_type,
        resol.reference_name,
        resol.sequence_no,
        resol.method_name,
        resol.function_name,
        resol.priority_group,
        resol.resolution_comment,
        decode(resol.conflict_type,
               'UPDATE',1,
               'UNIQUENESS',2,
               'DELETE',3,
               -1)
  from all_represolution resol, "_ALL_REPCOLUMN_GROUP" rg
 where conflict_type = 'UPDATE'
   and resol.reference_name = rg.group_name
   and resol.sname = rg.sname
   and resol.oname = rg.oname

View Text - HTML Formatted

SELECT SNAME
, ONAME
, CONFLICT_TYPE
, REFERENCE_NAME
, SEQUENCE_NO
, METHOD_NAME
, FUNCTION_NAME
, PRIORITY_GROUP
, RESOLUTION_COMMENT
, DECODE(CONFLICT_TYPE
, 'UPDATE'
, 1
, 'UNIQUENESS'
, 2
, 'DELETE'
, 3
, -1)
FROM ALL_REPRESOLUTION
WHERE CONFLICT_TYPE IN ('UNIQUENESS'
, 'DELETE'
, 'UNDEFINED') UNION SELECT /*+ ALL_ROWS */ RESOL.SNAME
, RESOL.ONAME
, RESOL.CONFLICT_TYPE
, RESOL.REFERENCE_NAME
, RESOL.SEQUENCE_NO
, RESOL.METHOD_NAME
, RESOL.FUNCTION_NAME
, RESOL.PRIORITY_GROUP
, RESOL.RESOLUTION_COMMENT
, DECODE(RESOL.CONFLICT_TYPE
, 'UPDATE'
, 1
, 'UNIQUENESS'
, 2
, 'DELETE'
, 3
, -1)
FROM ALL_REPRESOLUTION RESOL
, "_ALL_REPCOLUMN_GROUP" RG
WHERE CONFLICT_TYPE = 'UPDATE'
AND RESOL.REFERENCE_NAME = RG.GROUP_NAME
AND RESOL.SNAME = RG.SNAME
AND RESOL.ONAME = RG.ONAME