Print      Open PDF Version of Online Help


Previous Topic

Next Topic

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:


Published October 2016 Copyright © 2005, 2016, Oracle. All rights reserved. Legal Notices.