Demantra - Query to get user assigned series

Query to get user assigned series

select uss.user_id
      ,ui.user_name
      ,cf.COMPUTED_TITLE
      ,cf.computed_name
      ,cf.dbname
from computed_fields cf
    ,user_security_series uss
    ,user_id ui
where 1=1
and cf.forecast_type_id =uss.series_id
and uss.user_id=ui.user_id
and ui.user_name =<USERNAME>;