View Only
  • 1.  Lookup name in DB

    Posted Apr 11, 2017 03:00 AM

    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?



  • 2.  Re: Lookup name in DB
    Best Answer

    Posted Apr 11, 2017 03:57 AM

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

  • 3.  Re: Lookup name in DB

    Posted Apr 11, 2017 05:55 AM

    Thank you so much Dave_3.0