oracle8.1.6 select case_id, acs_object.name(object_id) as object_name, state, workflow_key from wf_cases where case_id = :case_id select tok.token_id, tok.place_key, tok.locked_task_id, ta.transition_key from wf_tokens tok, wf_tasks ta where tok.case_id = :case_id and ta.task_id (+) = tok.locked_task_id and tok.state in ('free', 'locked')