VIEW: DVSYS.DV$FACTOR_TYPE

Source

View Text - Preformatted

SELECT
      m.ID#
    , d.NAME
    , d.DESCRIPTION
    , m.VERSION
    , m.CREATED_BY
    , m.CREATE_DATE
    , m.UPDATED_BY
    , m.UPDATE_DATE
FROM dvsys.factor_type$ m, dvsys.factor_type_t$ d
WHERE
    m.id# = d.id#
    AND d.language = DVSYS.dvlang(d.id#, 3)

View Text - HTML Formatted

SELECT M.ID#
, D.NAME
, D.DESCRIPTION
, M.VERSION
, M.CREATED_BY
, M.CREATE_DATE
, M.UPDATED_BY
, M.UPDATE_DATE FROM DVSYS.FACTOR_TYPE$ M
, DVSYS.FACTOR_TYPE_T$ D WHERE M.ID# = D.ID#
AND D.LANGUAGE = DVSYS.DVLANG(D.ID#
, 3)