DQL to list workitems of a document

select i.r_object_id, a.object_name, i.r_performer_name, wf.object_name as work_flow_name, wf.r_object_id as workflow_id
from dmi_workitem i, dm_activity a, dm_workflow wf
where i.r_act_def_id = a.r_object_id
and i.r_workflow_id = wf.r_object_id
and wf.r_object_id in
(select r_workflow_id from dmi_package
where any r_component_id in
(select r_object_id from dm_sysobject (all)
where i_chronicle_id in
(select i_chronicle_id
from dm_sysobject where r_object_id in (SELECT r_object_id FROM dm_document
WHERE object_name LIKE 'N0050675%'
)
)
)
)
order by wf.r_object_id