ORB Business Object and Assignments

select 
distinct omo.obj_key bo_obj_key,
olf_bo_name.property_value business_object_name,
olf_bo_description.property_value business_object_description,
olf_parent_name.property_value bo_logical_model_name,
omo_domain_name.property_value domain_name,
case when omos.role_id is not null then 'ROLE' when omos.user_id is not null then 'USER' end bo_assignment_type,
case when omos.user_id is not null then xxen_orb_util.orb_user(omos.user_id) end bo_assigned_user_name,
case when omos.role_id is not null then 
(select name from xxorb.orb_role orole where id=omos.role_id) 
end bo_assigned_role_name
from 
xxorb.orb_business_object obo,
xxorb.orb_meta_object_security omos,
xxorb.orb_meta_object omo,
xxorb.orb_meta_object omo_parent,
xxorb.orb_meta_object omo_domain,
xxorb.orb_localizedstring_flat omo_domain_name,
xxorb.orb_localizedstring_flat olf_parent_name,
xxorb.orb_localizedstring_flat olf_bo_name,
xxorb.orb_localizedstring_flat olf_bo_description
where 1=1 and
obo.id=omo.id and
omo.obj_type=10 and
omo_parent.id=omo.parent_id and
omos.meta_object_id(+)=obo.id and
olf_parent_name.meta_object_id=omo.parent_id and
olf_parent_name.property_key = 'name' and
olf_bo_name.property_key = 'name' and
olf_bo_name.meta_object_id=omo.id and
olf_bo_description.meta_object_id(+)=omo.id and
olf_bo_description.property_key(+) = 'description' and
omo_parent.parent_id=omo_domain.id and
omo_domain.obj_type=1 and
omo_domain_name.meta_object_id=omo_domain.id and
omo_domain_name.property_key = 'name' 
order by omo_domain_name.property_value

select distinct omo.obj_key bo_obj_key, olf_bo_name.property_value business_object_name, olf_bo_description.property_value business_object_description, olf_parent_name.property_value bo_logical_model_name, omo_domain_name.property_value domain_name, case when omos.role_id is not null then 'ROLE' when omos.user_id is not null then 'USER' end bo_assignment_type, case when omos.user_id is not null then xxen_orb_util.orb_user(omos.user_id) end bo_assigned_user_name, case when omos.role_id is not null then (select name from xxorb.orb_role orole where id=omos.role_id) end bo_assigned_role_name from xxorb.orb_business_object obo, xxorb.orb_meta_object_security omos, xxorb.orb_meta_object omo, xxorb.orb_meta_object omo_parent, xxorb.orb_meta_object omo_domain, xxorb.orb_localizedstring_flat omo_domain_name, xxorb.orb_localizedstring_flat olf_parent_name, xxorb.orb_localizedstring_flat olf_bo_name, xxorb.orb_localizedstring_flat olf_bo_description where 1=1 and obo.id=omo.id and omo.obj_type=10 and omo_parent.id=omo.parent_id and omos.meta_object_id(+)=obo.id and olf_parent_name.meta_object_id=omo.parent_id and olf_parent_name.property_key = 'name' and olf_bo_name.property_key = 'name' and olf_bo_name.meta_object_id=omo.id and olf_bo_description.meta_object_id(+)=omo.id and olf_bo_description.property_key(+) = 'description' and omo_parent.parent_id=omo_domain.id and omo_domain.obj_type=1 and omo_domain_name.meta_object_id=omo_domain.id and omo_domain_name.property_key = 'name' order by omo_domain_name.property_value