SELECT VoProfessionalGroup.VO_PROFESSIONAL_GROUP_ID,
       NVL2(short_code,  short_code || ' ' || name, name) AS VIEW_ATTR
FROM OF_OWNER.VO_PROFESSIONAL_GROUP VoProfessionalGroup
WHERE vehicle_owner_id = ? //tekushtiq
ORDER BY short_code, name