select r_object_id, r_creation_date, r_performer_name, r_runtime_state, r_workflow_id from dmi_workitem

where r_workflow_id in

(select r_workflow_id from dmi_package where any r_component_id in ('<id поручения>'))