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".
Think this is the join you are looking for;
SELECTclov.lookup_type_code , ca.column_nameFROM 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)
Have you checked the cmn_lookups table?
Yes, I have checked. It has only ENUM values for the corresponding lookups. I need to know which lookups are using ENUM values.
This is what I was looking for.
Retrieving data ...