SELECT
    mst.row_id,
    mst.obs_type_id,
    ot.standard_name AS obs_type_name,
    ot.definition AS obs_type_def,
    mst.uom_type_id,
    ut.standard_name AS uom_type_name,
    ut.definition AS uom_type_def,
    ut.display AS uom_type_disp
FROM m_scalar_type mst,
    obs_type ot,
    uom_type ut
WHERE mst.obs_type_id = ot.row_id
        AND mst.uom_type_id = ut.row_id
ORDER BY mst.row_id