VIEW: DVSYS.DV$RULE_SET

Source

View Text - Preformatted

SELECT
      m.id#
    , d.name
    , d.description
    , m.enabled
    , m.eval_options - DECODE(bitand(m.eval_options, 128) , 128, 128, 0)
    , deval.value
    , m.audit_options
    , m.fail_options
    , dfail.value
    , d.fail_message
    , m.fail_code
    , m.handler_options
    , m.handler
    , m.version
    , m.created_by
    , m.create_date
    , m.updated_by
    , m.update_date
    , DECODE(bitand(m.eval_options, 128) , 128, 'TRUE', 'FALSE')
FROM dvsys.rule_set$ m
    , dvsys.rule_set_t$ d
    , dvsys.dv$code deval
    , dvsys.dv$code dfail
WHERE
    m.id# = d.id#
    AND d.language = DVSYS.dvlang(d.id#, 5)
    AND deval.code = TO_CHAR(m.eval_options -
                             DECODE(bitand(m.eval_options,128) , 128, 128, 0))
    AND deval.code_group = 'RULESET_EVALUATE'
    AND dfail.code  = TO_CHAR(m.fail_options)
    AND dfail.code_group = 'RULESET_FAIL'

View Text - HTML Formatted

SELECT M.ID#
, D.NAME
, D.DESCRIPTION
, M.ENABLED
, M.EVAL_OPTIONS - DECODE(BITAND(M.EVAL_OPTIONS
, 128)
, 128
, 128
, 0)
, DEVAL.VALUE
, M.AUDIT_OPTIONS
, M.FAIL_OPTIONS
, DFAIL.VALUE
, D.FAIL_MESSAGE
, M.FAIL_CODE
, M.HANDLER_OPTIONS
, M.HANDLER
, M.VERSION
, M.CREATED_BY
, M.CREATE_DATE
, M.UPDATED_BY
, M.UPDATE_DATE
, DECODE(BITAND(M.EVAL_OPTIONS
, 128)
, 128
, 'TRUE'
, 'FALSE') FROM DVSYS.RULE_SET$ M
, DVSYS.RULE_SET_T$ D
, DVSYS.DV$CODE DEVAL
, DVSYS.DV$CODE DFAIL WHERE M.ID# = D.ID#
AND D.LANGUAGE = DVSYS.DVLANG(D.ID#
, 5)
AND DEVAL.CODE = TO_CHAR(M.EVAL_OPTIONS - DECODE(BITAND(M.EVAL_OPTIONS
, 128)
, 128
, 128
, 0))
AND DEVAL.CODE_GROUP = 'RULESET_EVALUATE'
AND DFAIL.CODE = TO_CHAR(M.FAIL_OPTIONS)
AND DFAIL.CODE_GROUP = 'RULESET_FAIL'