VIEW: SYS.USER_REPRESOLUTION

Source

View Text - Preformatted

select
    r.oname,
    decode(r.conflict_type_id,
           1, 'UPDATE',
           2, 'UNIQUENESS',
           3, 'DELETE',
           'UNDEFINED'),
    r.reference_name,
    r.sequence_no,
    r.method_name,
    r.function_name,
    r.priority_group,
    r.resolution_comment
from  system.repcat$_resolution r, sys.user$ u
where r.sname = u.name
and   u.user# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT R.ONAME
, DECODE(R.CONFLICT_TYPE_ID
, 1
, 'UPDATE'
, 2
, 'UNIQUENESS'
, 3
, 'DELETE'
, 'UNDEFINED')
, R.REFERENCE_NAME
, R.SEQUENCE_NO
, R.METHOD_NAME
, R.FUNCTION_NAME
, R.PRIORITY_GROUP
, R.RESOLUTION_COMMENT FROM SYSTEM.REPCAT$_RESOLUTION R
, SYS.USER$ U WHERE R.SNAME = U.NAME AND U.USER# = USERENV('SCHEMAID')