Clarity

Hello All,

Could anyone let me know from which table we can find out which static lookup is using LOOKUP_ENUM as the hidden key and which one is using "LOOKUP_CODE".

Thanks,

Pragya

Have you checked the cmn_lookups table?

NJ

Yes, I have checked. It has only ENUM values for the corresponding lookups. I need to know which lookups are using ENUM values.

Think this is the join you are looking for;

SELECT
clov.lookup_type_code ,
ca.column_name
FROM CMN_LOV_OBJECTS clov
JOIN CMN_ATTRIBUTES ca ON ca.id = clov.key_attribute_id

the records with a "column_name" of "LOOKUP_ENUM" will be what you are after (lookup_type_code being the lookup id)

Thanks Dave,

This is what I was looking for.