select 1 from wf_workflows where workflow_key = :workflow_key select pretty_name as workflow_name from acs_object_types where object_type = :workflow_key select transition_key, transition_name from wf_transitions where workflow_key = :workflow_key order by transition_name select place_key, place_name from wf_places where workflow_key = :workflow_key order by place_name