Lookup name in DB

[Monica_Rampradeep_Raj]

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?

 

Monica

[David Morton]

SELECT c.name , l.lookup_type
FROM cmn_lookup_types l
JOIN cmn_captions_nls c ON c.pk_id = l.id
WHERE c.table_name = 'CMN_LOOKUP_TYPES'
AND c.language_code = 'en'                                 /*   <---- change as required */
AND l.lookup_type = 'CAL_ACTIONITEM_PRIORITY'

[Monica_Rampradeep_Raj]

Thank you so much Dave_3.0