select sort_order
from contact_views
where contact_object_type = :contact_object_type
order by sort_order desc limit 1
select contact__view_create(
null,
:src,
:privilege_required,
:privilege_object_id,
:contact_object_type,
:package_id,
:sort_order,
now(),
:creation_user,
:creation_ip,
:context_id) as view_id
select contact__view_name_save(
:view_id,
:locale,
:name
)
select '1' from contact_views limit 1
select package_id from apm_packages where package_key = 'contacts'
select 1 from contact_views where view_id = :view_id and contact_object_type = :object_type
select *
from contact_views
where view_id = :view_id
select name from contact_view_names where view_id = :view_id and locale = :locale
select view_id from contact_views where contact_object_type = :object_type order by sort_order limit 1