FND_LOOKUP_TYPES (Lookup types)
Documentation | Oracle EBS Data Dictionary |
Name | FND_LOOKUP_TYPES |
Title | Lookup types |
Module | EBS Data Dictionary Diagram |
Oracle Application Object Library QuickCodes.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | APPLICATION_ID | NUMBER(15, 0) | FND_APPLICATION (Applications) | Application identifier. | ||||
Application identifier. References: FND_APPLICATION (Applications) |
||||||||
2 | LOOKUP_TYPE | VARCHAR2(30 BYTE) | QuickCode lookup type. | |||||
QuickCode lookup type. |
||||||||
3 | CUSTOMIZATION_LEVEL | VARCHAR2(1 BYTE) | Customization level. | |||||
Customization level. |
||||||||
4 | CREATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
5 | CREATION_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
6 | LAST_UPDATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
7 | LAST_UPDATE_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
8 | LAST_UPDATE_LOGIN | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
9 | SECURITY_GROUP_ID | NUMBER(15, 0) | Default: 0 | Security group identifier. | ||||
Security group identifier. Default: 0 |
||||||||
10 | VIEW_APPLICATION_ID | NUMBER(15, 0) | Default: 0 | Application identifier of view (<PROD>_LOOKUPS) through which the lookup type will be exposed. | ||||
Application identifier of view (<PROD>_LOOKUPS) through which the lookup type will be exposed. Default: 0 |
||||||||
11 | ASSIGN_LEAF_ONLY | VARCHAR2(1 BYTE) | Assign Leaf Only Flag. | |||||
Assign Leaf Only Flag. |
||||||||
12 | ZD_EDITION_NAME | VARCHAR2(30 BYTE) | Default: 'ORA$BASE' | |||||
Default:
'ORA$BASE' |
||||||||
13 | ZD_SYNC | VARCHAR2(30 BYTE) | Default: 'SYNCED' | |||||
Default:
'SYNCED' |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
FND_LOOKUP_TYPES (Lookup types) | FND_APPLICATION (Applications) | FND_LOOKUP_TYPES.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID | fk_FND_LOOKUP_TYPES_FND_APPLICATION | |
FND_LOOKUP_TYPES.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID Name: fk_FND_LOOKUP_TYPES_FND_APPLICATION |
||||
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_TYPES_U1 | LOOKUP_TYPE, ZD_EDITION_NAME, SECURITY_GROUP_ID, VIEW_APPLICATION_ID |
Uses
Name |
---|
FND_LOOKUP_TYPES (Lookup types)
|
Used by
Name |
---|
FND_LOOKUP_TYPES (Lookup types)
|
FND_LOOKUP_TYPES#
|
Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17