VIEW: DVSYS.DV$MAC_POLICY_FACTOR

Source

View Text - Preformatted

SELECT
      m.id#
    , m.factor_id#
    , d1.name
    , d3.id#
    , d3.policy_id#
    , d2.pol_name
    , m.version
    , m.created_by
    , m.create_date
    , m.updated_by
    , m.update_date
FROM dvsys.mac_policy_factor$ m
    , dvsys.dv$factor d1
    , lbacsys.ols$pol d2
    , dvsys.mac_policy$ d3
WHERE
    d1.id# = m.factor_id#
    AND d3.id# = m.mac_policy_id#
    AND d2.pol# = policy_id#

View Text - HTML Formatted

SELECT M.ID#
, M.FACTOR_ID#
, D1.NAME
, D3.ID#
, D3.POLICY_ID#
, D2.POL_NAME
, M.VERSION
, M.CREATED_BY
, M.CREATE_DATE
, M.UPDATED_BY
, M.UPDATE_DATE FROM DVSYS.MAC_POLICY_FACTOR$ M
, DVSYS.DV$FACTOR D1
, LBACSYS.OLS$POL D2
, DVSYS.MAC_POLICY$ D3 WHERE D1.ID# = M.FACTOR_ID#
AND D3.ID# = M.MAC_POLICY_ID#
AND D2.POL# = POLICY_ID#