VIEW: SYS.USER_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,
      user_tab_columns tc,
      sys.user$ u
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
and   p.sname = u.name
and   u.user# = userenv('SCHEMAID')
and   p.oname = tc.table_name
and   ((rc.top is null and rc.lcname = tc.column_name) or
       (rc.top is not null and rc.top = tc.column_name))
union
  select p.sname, p.oname, p.conflict_type, p.reference_name, p.sequence_no,
         p.method_name, p.function_name, p.priority_group,
         p.parameter_table_name, p.parameter_column_name,
         p.parameter_sequence_no
from  "_USER_REPL_NESTED_TABLE_NAMES" nt, dba_repparameter_column p,
      sys.user$ u
where p.sname = u.name
  and u.user# = userenv('SCHEMAID')
  and p.parameter_table_name = nt.table_name
  and p.oname = p.parameter_table_name

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
, USER_TAB_COLUMNS TC
, SYS.USER$ U 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 AND P.SNAME = U.NAME AND U.USER# = USERENV('SCHEMAID') AND P.ONAME = TC.TABLE_NAME AND ((RC.TOP IS NULL
AND RC.LCNAME = TC.COLUMN_NAME) OR (RC.TOP IS NOT NULL
AND RC.TOP = TC.COLUMN_NAME)) UNION SELECT P.SNAME
, P.ONAME
, P.CONFLICT_TYPE
, P.REFERENCE_NAME
, P.SEQUENCE_NO
, P.METHOD_NAME
, P.FUNCTION_NAME
, P.PRIORITY_GROUP
, P.PARAMETER_TABLE_NAME
, P.PARAMETER_COLUMN_NAME
, P.PARAMETER_SEQUENCE_NO FROM "_USER_REPL_NESTED_TABLE_NAMES" NT
, DBA_REPPARAMETER_COLUMN P
, SYS.USER$ U WHERE P.SNAME = U.NAME
AND U.USER# = USERENV('SCHEMAID')
AND P.PARAMETER_TABLE_NAME = NT.TABLE_NAME
AND P.ONAME = P.PARAMETER_TABLE_NAME