Demantra - Query to get user assigned series and worksheets

Query to get user assigned series and worksheets

SELECT ui.user_name ,
  q.query_name "Worksheet Name" ,
  gt.TABLE_LABEL "Level Name" ,
  cf.computed_title "Series Name"
FROM active_series a ,
  computed_fields cf ,
  queries q ,
  groups g ,
  group_tables gt ,
  queries_for_users qfu ,
  user_id ui
WHERE 1                =1
AND a.query_id         = q.query_id
AND a.forecast_type_id = cf.forecast_type_id
AND g.query_id         =q.query_id
AND g.group_table_id   = gt.group_table_id
AND q.query_id         = qfu.query_id
AND qfu.user_id        = ui.user_id
AND ui.user_name       =<USERNAME>;