Description:
I have created a custom user-defined Lookup. What table are the display names in for each value in the Lookup?
Solution:
Here is a simple query that will provide you with the English translation of the Lookup Value Name for the static lookup ‘Investment Goal Lookup’.
SELECT L.LOOKUP_TYPE, L.LOOKUP_CODE, N.NAME, N.DESCRIPTION, L.IS_ACTIVE, L.PARTITION_CODE, L.PARTITION_MODE_CODE
FROM CMN_LOOKUPS L, CMN_CAPTIONS_NLS N
WHERE L.ID = N.PK_ID
AND N.LANGUAGE_CODE = ‘en’
AND N.TABLE_NAME = ‘CMN_LOOKUPS’
AND L.LOOKUP_TYPE = ‘INVESTMENT_GOAL_TYPE’
Note: Change L.LOOKUP_TYPE with the correct ID of your lookup.
If you need more assistance in developing custom queries or portlets, please contact your CA Clarity Division Technical Consulting Services Representative.