oracle8.1.6
select response_id, case when initial_response_id is NULL then 'T' else 'F' e\
nd as original_p, nvl(initial_response_id,response_id) as initial_response, creatio\
n_date
from survey_responses, acs_objects
where response_id = object_id
and survey_response.initial_user_id(response_id) = :user_id
and survey_id=:survey_id
order by nvl(initial_response_id,response_id) desc, creation_date desc