select
user_id,
first_names ||' '|| last_name as fullname
from
cc_users
order by
last_name asc
select
item_id as project_item_id
from
cr_items
where
content_type = 'pm_project'
select
cct.*,
cr.title,
cr.description
from
contact_complaint_tracking cct,
cr_revisions cr
where
complaint_id = :complaint_id
and revision_id = :complaint_id