select a.r_object_id as workflow_id, a.object_name as workflow_name, b.name as
performer,b.task_state , b.message as task_instruction
from dm_workflow a, dmi_queue_item b
where a.r_object_id = b.router_id and b.name =USER and b.task_state = 'acquired' and
b.delete_flag =0