| Print Open PDF Version of Online Help

#### LookupName The LookupName function in Expression Builder finds a row in the List of Values table where all of the following are true: The TYPE field matches the type argument. The CODE field matches the lang_ind_code argument. The LANG_ID field matches the language code of the currently active language. This function returns the untranslated value (the language-independent code) of the display value in the specified List of Values. TIP: When specifying the parameters for the LookupName function, click Show Acceptable Values to display the acceptable values for the field that you selected in the Fields list. (If a field is a picklist field, Show Acceptable Values displays all the options configured for that picklist. If a field is not a picklist field, Show Acceptable Values opens a window that describes the acceptable values for a variety of data that the field can hold.) ### Syntax LookupName (type, lang_ind_code) ### Result Type String ### Arguments The following table describes the arguments for the function.
Argument | Description
--- | ---
type | The type of row to be searched for.
lang_ind_code | The display value.
### Example If CALIFORNIA is the display value and CALIF is the language independent code, both of the following examples return the value CALIF: LookupName('STATE_ABBREV', 'CALIFORNIA') LookupName('STATE_ABBREV', 'CALIF') #### Related Topics See the following topics for related Expression Builder information: About Expression Builder Using Expression Builder Expression Builder Functions

Published August 2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.