Here is a quick bit of code to see the basic listing in SQL so you don't have to go digging in the Arena menus. Keep in mind, you also have lookup qualifiers for each lookup that can be useful for all kinds of things, but this is the basics.
CLT.lookup_type_name + ' ('+CONVERT(VARCHAR(8),CLT.lookup_type_id)+')' AS [Lookup Type Name (ID)],
CL.lookup_value + ' (' + CONVERT(VARCHAR(8),CL.lookup_id) + ')' AS [Lookup Value (ID)]
LEFT OUTER JOIN core_lookup CL ON CL.lookup_type_id=CLT.lookup_type_id