Hi, I want to get list of lookup with lookup name and lookup code. I could locate the look code but not the name in DB.
For example, i could locate CAL_ACTIONITEM_PRIORITY lookup code , but not the lookup name Action Item Priority.
Could any one help me with locating the lookup name?
SELECT c.name , l.lookup_typeFROM cmn_lookup_types lJOIN cmn_captions_nls c ON c.pk_id = l.idWHERE c.table_name = 'CMN_LOOKUP_TYPES'AND c.language_code = 'en' /* <---- change as required */AND l.lookup_type = 'CAL_ACTIONITEM_PRIORITY'
Thank you so much Dave_3.0