FND_LOOKUP_TYPES

FND_LOOKUP_TYPES stores Oracle Application Object Library QuickCode types. Each row includes the QuickCode lookup type and the application the lookup type belongs to. Each row also includes the customization level for the lookup type, the security group the lookup type belongs to, and the application view through with the lookup type will be exposed. You need one row for each QuickCode lookup type. Oracle Application Object Library uses this information to display LOVs for Oracle Application Object Library forms and other forms.

Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application identifier
LOOKUP_TYPE VARCHAR2 (30) Yes QuickCode lookup type
CUSTOMIZATION_LEVEL VARCHAR2 (1) Yes Customization level
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_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SECURITY_GROUP_ID NUMBER (15) Yes Security group identifier
VIEW_APPLICATION_ID NUMBER (15) Yes Application identifier of view (_LOOKUPS) through which the lookup type will be exposed

Usage


  cursor cur_lookup(c_name   in dba_objects.object_name%type := '%'
                 , n_appid  in number) is
  select v.lookup_type   id
  ,      v.lookup_type name
  from fnd_lookup_types v
  where v.application_id = n_appid
  and   v.lookup_type like c_name ESCAPE '\'
  order by lookup_type;

FND_LOOKUP_TYPES_TL

FND_LOOKUP_TYPES_TL stores translated information about the lookup types in FND_LOOKUP_TYPES

Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes QuickCode lookup type (FK to fnd_lookup_types.lookup_type)
SECURITY_GROUP_ID NUMBER (15) Yes Security group identifier
VIEW_APPLICATION_ID NUMBER (15) Yes Application identifier of view (_LOOKUPS) through which the lookup type will be exposed
LANGUAGE VARCHAR2 (4) Yes Language
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.
MEANING VARCHAR2 (80) Yes Lookup type user meaning
DESCRIPTION VARCHAR2 (240)
Description of the lookup type
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_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column