VIEW: DVSYS.DBA_DV_FACTOR

Source

View Text - Preformatted

SELECT
      m.name
    , d.description
    , dft.name
    , drs.name
    , m.get_expr
    , m.validate_expr
    , m.identified_by
    , did.value
    , m.namespace
    , m.namespace_attribute
    , m.labeled_by
    , dlabel.value
    , m.eval_options
    , deval.value
    , m.audit_options
    , m.fail_options
    , dfail.value
FROM dvsys.factor$ m
    , dvsys.factor_t$ d
    , dvsys.dv$factor_type dft
    , dvsys.dv$rule_set drs
    , dvsys.dv$code did
    , dvsys.dv$code dlabel
    , dvsys.dv$code deval
    , dvsys.dv$code dfail
WHERE
    m.id# = d.id#
    AND d.language = DVSYS.dvlang(d.id#, 2)
    AND dft.id# = m.factor_type_id#
    AND did.code    = TO_CHAR(m.identified_by)  and did.code_group = 'FACTOR_IDENTIFY'
    AND dlabel.code = TO_CHAR(m.labeled_by)  and dlabel.code_group = 'FACTOR_LABEL'
    AND deval.code  = TO_CHAR(m.eval_options) and deval.code_group = 'FACTOR_EVALUATE'
    AND dfail.code  = TO_CHAR(m.fail_options) and dfail.code_group = 'FACTOR_FAIL'
    AND drs.id#  (+)= m.assign_rule_set_id#

View Text - HTML Formatted

SELECT M.NAME
, D.DESCRIPTION
, DFT.NAME
, DRS.NAME
, M.GET_EXPR
, M.VALIDATE_EXPR
, M.IDENTIFIED_BY
, DID.VALUE
, M.NAMESPACE
, M.NAMESPACE_ATTRIBUTE
, M.LABELED_BY
, DLABEL.VALUE
, M.EVAL_OPTIONS
, DEVAL.VALUE
, M.AUDIT_OPTIONS
, M.FAIL_OPTIONS
, DFAIL.VALUE FROM DVSYS.FACTOR$ M
, DVSYS.FACTOR_T$ D
, DVSYS.DV$FACTOR_TYPE DFT
, DVSYS.DV$RULE_SET DRS
, DVSYS.DV$CODE DID
, DVSYS.DV$CODE DLABEL
, DVSYS.DV$CODE DEVAL
, DVSYS.DV$CODE DFAIL WHERE M.ID# = D.ID#
AND D.LANGUAGE = DVSYS.DVLANG(D.ID#
, 2)
AND DFT.ID# = M.FACTOR_TYPE_ID#
AND DID.CODE = TO_CHAR(M.IDENTIFIED_BY)
AND DID.CODE_GROUP = 'FACTOR_IDENTIFY'
AND DLABEL.CODE = TO_CHAR(M.LABELED_BY)
AND DLABEL.CODE_GROUP = 'FACTOR_LABEL'
AND DEVAL.CODE = TO_CHAR(M.EVAL_OPTIONS)
AND DEVAL.CODE_GROUP = 'FACTOR_EVALUATE'
AND DFAIL.CODE = TO_CHAR(M.FAIL_OPTIONS)
AND DFAIL.CODE_GROUP = 'FACTOR_FAIL'
AND DRS.ID# (+)= M.ASSIGN_RULE_SET_ID#