Thanks, your reply helped. To expand on what you have, to take schema/owner into account and to use object_id instead of name, this is what I used

SELECT o.object_id, s.name AS...