| 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 the 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 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.