SELECT VoLegalEntity.VO_LEGAL_ENTITY_ID,
       NVL2 (SHORT_CODE, short_code || ' ' || Name, name) AS VIEW_ATTR
FROM OF_OWNER.VO_LEGAL_ENTITY VoLegalEntity
WHERE vehicle_owner_id = ? // tekushtiq
ORDER BY short_code, name