VIEW: SYS.USER_REPRESOLUTION_STATISTICS

Source

View Text - Preformatted

select
    r.oname,
    decode(r.conflict_type_id,
           1, 'UPDATE',
           2, 'UNIQUENESS',
           3, 'DELETE',
           'UNDEFINED'),
    r.reference_name,
    r.method_name,
    decode(r.method_name,
           'USER FUNCTION', r.function_name,
           'USER FLAVOR FUNCTION', r.function_name,
           NULL),
    r.priority_group,
    r.resolved_date,
    r.primary_key_value
from  system.repcat$_resolution_statistics 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.METHOD_NAME
, DECODE(R.METHOD_NAME
, 'USER FUNCTION'
, R.FUNCTION_NAME
, 'USER FLAVOR FUNCTION'
, R.FUNCTION_NAME
, NULL)
, R.PRIORITY_GROUP
, R.RESOLVED_DATE
, R.PRIMARY_KEY_VALUE FROM SYSTEM.REPCAT$_RESOLUTION_STATISTICS R
, SYS.USER$ U WHERE R.SNAME = U.NAME AND U.USER# = USERENV('SCHEMAID')