I like that query that NJ linked better, but if you're just looking to see if based on your other thread ( BPM-0522: Internal Process Engine Error. Contact your site administrator (Error executing action) ) whether or not you have any process definitions where you might be locking attributes directly with SQL, you could start with something simpler like what I replied with there:
select id, script_text from cmn_custom_scripts where script_text like '%ODF_LOCKED_ATTRIBUTES%' or script_text like '%odf_locked_attributes%'
There are still caveats to this.. for example, locked attribute inserts could also be buried away in procedures and/or triggers on the database that the GEL calls but without having the name of the table present, but this is going to be rather uncommon. If you suspect that as well though or want to rule it out to be sure, and you are using Oracle, you could connect to the database as your Clarity/PPM schema user and issue this query - but note that it will pull out some stock or out of the box results too, not just any custom ones:
select distinct * from user_source us1 where exists
(
select null from user_source us2
where us2.name = us1.name
and us2.type = us2.type
and upper(us2.text) like '%ODF_LOCKED_ATTRIBUTES%'
)
order by name, type, line
Hope that helps, and if you raised a support ticket for that other thread in the end, please can you let me know what it is if you don't mind.