oracle8.1.6
select a.attribute_id,
a.sort_order,
a.attribute_name,
a.pretty_name,
a.datatype,
'' as edit_url,
workflow_case.get_attribute_value(:case_id, a.attribute_name) as value,
'' as value_pretty
from acs_attributes a, wf_cases c
where c.case_id = :case_id
and a.object_type = c.workflow_key
order by a.sort_order