DBA Data[Home] [Help] [Dependency Information]


TABLE: APPLSYS.FND_LOOKUP_VALUES

Object Details
Object Name: FND_LOOKUP_VALUES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_LOOKUP_VALUES
Subobject Name:
Status: VALID


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.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_LOOKUP_VALUES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnLOOKUP_TYPE
ColumnVIEW_APPLICATION_ID
ColumnLOOKUP_CODE
ColumnSECURITY_GROUP_ID
ColumnLANGUAGE
ColumnZD_EDITION_NAME
FND_LOOKUP_VALUES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnLOOKUP_TYPE
ColumnVIEW_APPLICATION_ID
ColumnMEANING
ColumnSECURITY_GROUP_ID
ColumnLANGUAGE
ColumnZD_EDITION_NAME
Columns
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 (150)
Optional additional category for lookup values
LEAF_NODE VARCHAR2 (1)
Leaf Node Flag
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOOKUP_TYPE
,      LANGUAGE
,      LOOKUP_CODE
,      MEANING
,      DESCRIPTION
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      SOURCE_LANG
,      SECURITY_GROUP_ID
,      VIEW_APPLICATION_ID
,      TERRITORY_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TAG
,      LEAF_NODE
,      ZD_EDITION_NAME
FROM APPLSYS.FND_LOOKUP_VALUES;

Dependencies

[top of page]

APPLSYS.FND_LOOKUP_VALUES does not reference any database object

APPLSYS.FND_LOOKUP_VALUES is referenced by following:

SchemaAPPLSYS
ViewFND_LOOKUP_VALUES#
SchemaAPPS
Materialized ViewOE_ITEMS_MV
Materialized ViewOZF_EARNING_SUMMARY_MV