Clarity

Hi,

I want to find out with which object the lookup is associated. So that, I can directly go to that page and check the lookup.

How can this be done?

Regards,

Uruj

Have you checked this (thanks to Dave)?

TIP : Documenting your Configuration (via SQL)

https://communities.ca.com/message/28007425#28007425

NJ

For custom attributes and just this answer specifically (identifying object/attribute where a particular lookup is used), this may suffice:

select object_name, internal_name as attr_code, lookup_type
from odf_custom_attributes
where extended_type = 'lookup'
and lookup_type = ?
order by object_name, internal_name

Replace ? in line 4 with your lookup's code in single quotes, e.g. 'SCH_BROWSE_RESOURCE'

Thanks, all inputs helped!