eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS._ALL_REPCONFLICT

Source

View Text - Preformatted


select rc.sname, rc.oname, rc.conflict_type, rc.reference_name,
  decode(rc.conflict_type,
         'UPDATE',1,
         'UNIQUENESS',2,
         'DELETE',3, -1)
from all_repconflict rc
where rc.conflict_type in ('UNIQUENESS', 'DELETE')
union
select rc.sname, rc.oname, rc.conflict_type, rc.reference_name,
  decode(rc.conflict_type,
         'UPDATE',1,
         'UNIQUENESS',2,
         'DELETE',3, -1)
from all_repconflict rc, all_represolution resol
where rc.sname = resol.sname and
       rc.oname = resol.oname and
       rc.conflict_type = resol.conflict_type and
       resol.method_name in ('OVERWRITE', 'DISCARD', 'USER FUNCTION',
                             'USER FLAVOR FUNCTION')
union
select /*+ ALL_ROWS */ rc.sname, rc.oname, rc.conflict_type, rc.reference_name,
  decode(rc.conflict_type,
         'UPDATE',1,
         'UNIQUENESS',2,
         'DELETE',3, -1)
from all_repconflict rc, "_ALL_REPPARAMETER_COLUMN" rpcol
where rc.reference_name = rpcol.reference_name
and rc.sname = rpcol.sname
and rc.oname = rpcol.oname

View Text - HTML Formatted

SELECT RC.SNAME
, RC.ONAME
, RC.CONFLICT_TYPE
, RC.REFERENCE_NAME
, DECODE(RC.CONFLICT_TYPE
, 'UPDATE'
, 1
, 'UNIQUENESS'
, 2
, 'DELETE'
, 3
, -1) FROM ALL_REPCONFLICT RC WHERE RC.CONFLICT_TYPE IN ('UNIQUENESS'
, 'DELETE') UNION SELECT RC.SNAME
, RC.ONAME
, RC.CONFLICT_TYPE
, RC.REFERENCE_NAME
, DECODE(RC.CONFLICT_TYPE
, 'UPDATE'
, 1
, 'UNIQUENESS'
, 2
, 'DELETE'
, 3
, -1) FROM ALL_REPCONFLICT RC
, ALL_REPRESOLUTION RESOL WHERE RC.SNAME = RESOL.SNAME AND RC.ONAME = RESOL.ONAME AND RC.CONFLICT_TYPE = RESOL.CONFLICT_TYPE AND RESOL.METHOD_NAME IN ('OVERWRITE'
, 'DISCARD'
, 'USER FUNCTION'
, 'USER FLAVOR FUNCTION') UNION SELECT /*+ ALL_ROWS */ RC.SNAME
, RC.ONAME
, RC.CONFLICT_TYPE
, RC.REFERENCE_NAME
, DECODE(RC.CONFLICT_TYPE
, 'UPDATE'
, 1
, 'UNIQUENESS'
, 2
, 'DELETE'
, 3
, -1) FROM ALL_REPCONFLICT RC
, "_ALL_REPPARAMETER_COLUMN" RPCOL WHERE RC.REFERENCE_NAME = RPCOL.REFERENCE_NAME AND RC.SNAME = RPCOL.SNAME AND RC.ONAME = RPCOL.ONAME