[Home] [Help] [Dependency Information]
Object Name: | FND_LOOKUPS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.FND_LOOKUPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
FND_LOOKUPS is a view of selected columns from the table
FND_LOOKUP_VALUES. This view contains information about the
available QuickCodes in the language under which Oracle Applications
is currently running at your site. Oracle Application Object Library uses
this view to display information for LOVs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Yes | QuickCode lookup type |
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 | ||
LEAF_NODE | VARCHAR2 | (1) | Leaf Node Flag |
Cut, paste (and edit) the following text to query this object:
SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LEAF_NODE
FROM APPS.FND_LOOKUPS;
|
|
|