FND_LOOKUP_VALUES

FND_LOOKUP_VALUES stores Oracle Application Object Library QuickCode values. Each row includes the QuickCode lookup type, the QuickCode itself, its meaning, and additional description, as well as values that indicate whether this QuickCode is currently valid. Each row also includes a language code that indicates what language the information is in. You need one row for each QuickCode in each of the languages installed at your site. Oracle Application Object Library uses this information to display LOVs for Oracle Application Object Library forms and other forms.

Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes QuickCode lookup type
LANGUAGE VARCHAR2 (30) Yes Language
LOOKUP_CODE VARCHAR2 (30) Yes QuickCode code
MEANING VARCHAR2 (80) Yes QuickCode meaning
DESCRIPTION VARCHAR2 (240)
Description
ENABLED_FLAG VARCHAR2 (1) Yes Enabled flag
START_DATE_ACTIVE DATE

The date when the QuickCode becomes active
END_DATE_ACTIVE DATE

The date when the QuickCode becomes inactive
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
SOURCE_LANG VARCHAR2 (4) Yes The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
SECURITY_GROUP_ID NUMBER (15) Yes Security group identifier
VIEW_APPLICATION_ID NUMBER (15) Yes Identifies which application's view will include the lookup values
TERRITORY_CODE VARCHAR2 (2)
Territory code of territory using the language
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category
ATTRIBUTE1 VARCHAR2 (150)
Attribute
ATTRIBUTE2 VARCHAR2 (150)
Attribute
ATTRIBUTE3 VARCHAR2 (150)
Attribute
ATTRIBUTE4 VARCHAR2 (150)
Attribute
ATTRIBUTE5 VARCHAR2 (150)
Attribute
ATTRIBUTE6 VARCHAR2 (150)
Attribute
ATTRIBUTE7 VARCHAR2 (150)
Attribute
ATTRIBUTE8 VARCHAR2 (150)
Attribute
ATTRIBUTE9 VARCHAR2 (150)
Attribute
ATTRIBUTE10 VARCHAR2 (150)
Attribute
ATTRIBUTE11 VARCHAR2 (150)
Attribute
ATTRIBUTE12 VARCHAR2 (150)
Attribute
ATTRIBUTE13 VARCHAR2 (150)
Attribute
ATTRIBUTE14 VARCHAR2 (150)
Attribute
ATTRIBUTE15 VARCHAR2 (150)
Attribute
TAG VARCHAR2 (30)
Optional additional category for lookup values

Usage:


    cursor cur_lookup_values(c_lookup_type in varchar2
                           , c_lookup_code in varchar2) is
    select t.meaning 
    from fnd_lookup_values t
    ,    fnd_lookup_types l
    where l.lookup_type = c_lookup_type
    and   t.lookup_code = c_lookup_code
    and   l.lookup_type = t.lookup_type
    and   l.security_group_id = t.security_group_id
    and   l.view_application_id = t.view_application_id
    and t.language =  userenv('LANG');