Object example;
select name
from CMN_CAPTIONS_NLS
where TABLE_NAME = 'ODF_OBJECTS'
and LANGUAGE_CODE = 'en'
and pk_id = 5000000
But you should provide the language_code ( not 'en' ) if its not English - pick that up from the @WHERE:PARAM:LANGUAGE@ if in a portlet
and you need to JOIN via the pk_id (being the object id from the audit table)
Attribute names are trickier ; I'd suggest just using the attribute code then (one reason that they are tricky is that an attribute can be labelled differently on the various views in the system so which label you would want to display is debatable)