VIEW: DVSYS.KU$_DV_RULE_SET_MEMBER_VIEW

Source

View Text - Preformatted

select '0','0', sys_guid(),
          rulst.name,
          rult.name,
          rsr.rule_order,
          rsr.enabled
  from    dvsys.rule_set_rule$          rsr,
          dvsys.rule_set$               ruls,
          dvsys.rule_set_t$             rulst,
          dvsys.rule$                   rul,
          dvsys.rule_t$                 rult
  where   ruls.id# = rsr.rule_set_id#
    and   ruls.id# = rulst.id#
    and    rul.id# = rsr.rule_id#
    and    rul.id# = rult.id#
    and   ruls.id# >= 5000
    and   (SYS_CONTEXT('USERENV','CURRENT_USERID') = 1279990
           or exists ( select 1
                         from sys.session_roles
                        where role='DV_OWNER' ))

View Text - HTML Formatted

SELECT '0'
, '0'
, SYS_GUID()
, RULST.NAME
, RULT.NAME
, RSR.RULE_ORDER
, RSR.ENABLED
FROM DVSYS.RULE_SET_RULE$ RSR
, DVSYS.RULE_SET$ RULS
, DVSYS.RULE_SET_T$ RULST
, DVSYS.RULE$ RUL
, DVSYS.RULE_T$ RULT
WHERE RULS.ID# = RSR.RULE_SET_ID#
AND RULS.ID# = RULST.ID#
AND RUL.ID# = RSR.RULE_ID#
AND RUL.ID# = RULT.ID#
AND RULS.ID# >= 5000
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS ( SELECT 1
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER' ))