FND_LOOKUP_VALUES (Lookup values)
Documentation | Oracle EBS Data Dictionary |
Name | FND_LOOKUP_VALUES |
Title | Lookup values |
Module | EBS Data Dictionary Diagram |
QuickCode values.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | LOOKUP_TYPE | VARCHAR2(30 BYTE) | FND_LOOKUP_TYPES (Lookup types) | QuickCode lookup type. | ||||
QuickCode lookup type. References: FND_LOOKUP_TYPES (Lookup types) |
||||||||
2 | LANGUAGE | VARCHAR2(30 BYTE) | Language. | |||||
Language. |
||||||||
3 | LOOKUP_CODE | VARCHAR2(30 BYTE) | QuickCode code. | |||||
QuickCode code. |
||||||||
4 | MEANING | VARCHAR2(80 BYTE) | QuickCode meaning. | |||||
QuickCode meaning. |
||||||||
5 | DESCRIPTION | VARCHAR2(240 BYTE) | Description. | |||||
Description. |
||||||||
6 | ENABLED_FLAG | VARCHAR2(1 BYTE) | Enabled flag. | |||||
Enabled flag. |
||||||||
7 | START_DATE_ACTIVE | DATE | The date when the QuickCode becomes active. | |||||
The date when the QuickCode becomes active. |
||||||||
8 | END_DATE_ACTIVE | DATE | The date when the QuickCode becomes inactive. | |||||
The date when the QuickCode becomes inactive. |
||||||||
9 | CREATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
10 | CREATION_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
11 | LAST_UPDATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
12 | LAST_UPDATE_LOGIN | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
13 | LAST_UPDATE_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
14 | SOURCE_LANG | VARCHAR2(4 BYTE) | 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. | |||||
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. |
||||||||
15 | SECURITY_GROUP_ID | NUMBER(15, 0) | Default: 0 | FND_LOOKUP_TYPES (Lookup types) | Security group identifier. | |||
Security group identifier. Default: 0 References: FND_LOOKUP_TYPES (Lookup types) |
||||||||
16 | VIEW_APPLICATION_ID | NUMBER(15, 0) | FND_LOOKUP_TYPES (Lookup types) | Identifies which application's view will include the lookup values. | ||||
Identifies which application's view will include the lookup values. References: FND_LOOKUP_TYPES (Lookup types) |
||||||||
17 | TERRITORY_CODE | VARCHAR2(2 BYTE) | Territory code of territory using the language. | |||||
Territory code of territory using the language. |
||||||||
18 | ATTRIBUTE_CATEGORY | VARCHAR2(30 BYTE) | Attribute category. | |||||
Attribute category. |
||||||||
19 | ATTRIBUTE1 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
20 | ATTRIBUTE2 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
21 | ATTRIBUTE3 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
22 | ATTRIBUTE4 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
23 | ATTRIBUTE5 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
24 | ATTRIBUTE6 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
25 | ATTRIBUTE7 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
26 | ATTRIBUTE8 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
27 | ATTRIBUTE9 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
28 | ATTRIBUTE10 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
29 | ATTRIBUTE11 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
30 | ATTRIBUTE12 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
31 | ATTRIBUTE13 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
32 | ATTRIBUTE14 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
33 | ATTRIBUTE15 | VARCHAR2(150 BYTE) | Attribute. | |||||
Attribute. |
||||||||
34 | TAG | VARCHAR2(150 BYTE) | Optional additional category for lookup values. | |||||
Optional additional category for lookup values. |
||||||||
35 | LEAF_NODE | VARCHAR2(1 BYTE) | Leaf Node Flag. | |||||
Leaf Node Flag. |
||||||||
36 | ZD_EDITION_NAME | VARCHAR2(30 BYTE) | Default: 'ORA$BASE' | |||||
Default:
'ORA$BASE' |
||||||||
37 | ZD_SYNC | VARCHAR2(30 BYTE) | Default: 'SYNCED' | |||||
Default:
'SYNCED' |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
FND_LOOKUP_VALUES (Lookup values) | FND_LOOKUP_TYPES (Lookup types) | FND_LOOKUP_VALUES.LOOKUP_TYPE = FND_LOOKUP_TYPES.LOOKUP_TYPE FND_LOOKUP_VALUES.SECURITY_GROUP_ID = FND_LOOKUP_TYPES.SECURITY_GROUP_ID FND_LOOKUP_VALUES.VIEW_APPLICATION_ID = FND_LOOKUP_TYPES.VIEW_APPLICATION_ID |
fk_FND_LOOKUP_VALUES_FND_LOOKUP_TYPES | |
FND_LOOKUP_VALUES.LOOKUP_TYPE = FND_LOOKUP_TYPES.LOOKUP_TYPE Name: fk_FND_LOOKUP_VALUES_FND_LOOKUP_TYPESFND_LOOKUP_VALUES.SECURITY_GROUP_ID = FND_LOOKUP_TYPES.SECURITY_GROUP_ID FND_LOOKUP_VALUES.VIEW_APPLICATION_ID = FND_LOOKUP_TYPES.VIEW_APPLICATION_ID |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
FND_LOOKUP_VALUES_U1 | LOOKUP_TYPE, ZD_EDITION_NAME, LANGUAGE, SECURITY_GROUP_ID, LOOKUP_CODE, VIEW_APPLICATION_ID | ||
FND_LOOKUP_VALUES_U2 | LOOKUP_TYPE, ZD_EDITION_NAME, LANGUAGE, SECURITY_GROUP_ID, MEANING, VIEW_APPLICATION_ID |
Uses
Name |
---|
FND_LOOKUP_VALUES (Lookup values)
|
Used by
Name |
---|
FND_LOOKUP_VALUES (Lookup values)
|
FND_LOOKUP_VALUES#
|
Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17