Siebel CRM little blog

SELECT   lov.created, usr_crt.login created_login, lov.last_upd,
         usr_upd.login updated_login, lov.TYPE, lov.NAME, lov.val,
         lov.sub_type, lov.par_row_id, par_lov.TYPE par_lov_type,
         par_lov.NAME par_lov_name
    FROM siebel.s_lst_of_val lov,
         siebel.s_lst_of_val par_lov,
         siebel.s_user usr_crt,
         siebel.s_user usr_upd
   WHERE lov.created_by = usr_crt.row_id
     AND lov.last_upd_by = usr_upd.row_id
     AND par_lov.row_id(+) = lov.par_row_id
ORDER BY lov.last_upd DESC