VIEW: SYS.DBA_REPPARAMETER_COLUMN

Source

View Text - Preformatted

select
    p.sname,
    p.oname,
    decode(p.conflict_type_id,
           1, 'UPDATE',
           2, 'UNIQUENESS',
           3, 'DELETE',
           'UNDEFINED'),
    p.reference_name,
    p.sequence_no,
    r.method_name,
    r.function_name,
    r.priority_group,
    p.parameter_table_name,
    decode(method_name, 'USER FUNCTION', NVL(rc.top, rc.lcname),
                        'USER FLAVOR FUNCTION', NVL(rc.top, rc.lcname),
           rc.lcname),
    p.parameter_sequence_no
from  system.repcat$_parameter_column p,
      system.repcat$_resolution r,
      system.repcat$_repcolumn rc
where p.sname = r.sname
and   p.oname = r.oname
and   p.conflict_type_id = r.conflict_type_id
and   p.reference_name = r.reference_name
and   p.sequence_no = r.sequence_no
and   p.oname = p.parameter_table_name
and   p.attribute_sequence_no = 1
and   p.sname = rc.sname
and   p.oname = rc.oname
and   p.column_pos = rc.pos

View Text - HTML Formatted

SELECT P.SNAME
, P.ONAME
, DECODE(P.CONFLICT_TYPE_ID
, 1
, 'UPDATE'
, 2
, 'UNIQUENESS'
, 3
, 'DELETE'
, 'UNDEFINED')
, P.REFERENCE_NAME
, P.SEQUENCE_NO
, R.METHOD_NAME
, R.FUNCTION_NAME
, R.PRIORITY_GROUP
, P.PARAMETER_TABLE_NAME
, DECODE(METHOD_NAME
, 'USER FUNCTION'
, NVL(RC.TOP
, RC.LCNAME)
, 'USER FLAVOR FUNCTION'
, NVL(RC.TOP
, RC.LCNAME)
, RC.LCNAME)
, P.PARAMETER_SEQUENCE_NO FROM SYSTEM.REPCAT$_PARAMETER_COLUMN P
, SYSTEM.REPCAT$_RESOLUTION R
, SYSTEM.REPCAT$_REPCOLUMN RC WHERE P.SNAME = R.SNAME AND P.ONAME = R.ONAME AND P.CONFLICT_TYPE_ID = R.CONFLICT_TYPE_ID AND P.REFERENCE_NAME = R.REFERENCE_NAME AND P.SEQUENCE_NO = R.SEQUENCE_NO AND P.ONAME = P.PARAMETER_TABLE_NAME AND P.ATTRIBUTE_SEQUENCE_NO = 1 AND P.SNAME = RC.SNAME AND P.ONAME = RC.ONAME AND P.COLUMN_POS = RC.POS