Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | LOV_INCLUSION |
| Short Name | LVI |
| View Name | CI_LOV_INCLUSIONS |
| Description | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: GENERAL_MODULE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
GENERAL_MODULE_REFERENCE LIST_OF_VALUES_REFERENCE USAGE_SEQUENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_LVI |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| GENERAL_MODULE_REFERENCE | N |
Prompt: Module
Transferable only if null |
Must be the usage in one and only one GENERAL_MODULE | |
| LIST_OF_VALUES_REFERENCE | N |
Prompt: List of Values
Transferable only if null |
Must be the usage of one and only one LIST_OF_VALUES | |
| ITEM_REFERENCE | Y | Prompt: Item | May be bound to one and only one ITEM | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| DISPLAY_TITLE_OVERRIDE | VARCHAR2(70) | Y | Display title to be used for this inclusion if required to be different to the display title of the LIST_OF_VALUES
Prompt: Title Override | ||
| LONG_LIST_FLAG | VARCHAR2(1) | N | Indicates to generators whether search dialog is to be displayed before querying the list
Prompt: Filter Before Display ? Uppercase | YESNO | N |
| REQ_VIEW_POSX | NUMBER(6, 0) | Y | X coordinate of top left corner of LOV relative to top left corner of underlying page or "content canvas"
Prompt: X Position | ||
| REQ_VIEW_POSY | NUMBER(6, 0) | Y | Y coordinate of top left corner of LOV relative to top left corner of underlying page or "content canvas"
Prompt: Y Position | ||
| RESTRICTION_CLAUSE | VARCHAR2(10) | N | Indicates where the ADDITIONAL_RESTRICTION is to be inserted
Prompt: Restriction Clause Uppercase | SQL_CLAUSE | DEFAULT |
| RETURN_LIST | VARCHAR2(2000) | Y | Comma separated list of mappings between items in the LOV and in the module component
Prompt: Return List | ||
| USAGE_SEQUENCE | NUMBER(6, 0) | N | The order in which the LOV inclusion is used within the module
Prompt: Usage Sequence System maintained: API provides a value only if left null by the user | ||
| USED_FOR | VARCHAR2(8) | N | Indicates if LOV used for querying, data entry or both. For querying, LOV's query is augmented by any 'QUERY_WHERE' clause on lookup DTU (and chained lookups) corresponding to base DTU of LOV. For data entry, 'VALIDATE_WHERE' clause used
Prompt: Used For Uppercase | LOV_USAGE | Q_AND_DE |
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed System maintained Updatable only if null Defined on SAC supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed System maintained Not updatable by user Defined on SAC supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| ADDITIONAL_RESTRICTION | LOVWCL | Additional Restriction |
| Other Properties |
|---|
| LOV_INCLUSION has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference LOV_INCLUSION:
Note: