If you make changes to a Lookup, users must log out then log back on before your changes take effect.
Query the type of your Lookup. You can define a maximum of 250 Lookups for a single type.
Query the application associated with your Lookup type.
If you use windows specialized for a particular Lookup type, the window uses this description in the window title.
This option group provides functionality for a later release. The value System indicates that the Lookup type was seed data provided by an Oracle Application.
This field provides functionality for a later release.
You may have several Lookups with the same Code in different languages. For example, the code Y may have a meaning of Yes in American English and Oui in French. Oracle Applications displays the correct meaning depending on your Site Language.
Enter the code value for your Lookup. You can define a maximum of 250 Lookups for a single Lookup type. When you enter a valid Lookup meaning into a displayed window field, Lookups stores this code into a corresponding hidden field. For example, the Lookup "Y" displays the meaning "Yes" but stores the code value "Y" in a hidden field.
You cannot change the values in this field after committing them. To remove an obsolete Lookup you can either disable the code, enter an end date, or change the meaning and description to match a replacement code.
When you enter a valid Lookup meaning into a displayed window field, Lookups stores the corresponding code into a hidden field. Lookups automatically displays the meaning in your Lookups field whenever you query your window. For example, the Lookup "Y" displays the meaning "Yes" but stores the code value "Y" in a hidden field.
You can display the description along with the meaning to give more information about your Lookup.
Start Date / End Date
Enter the dates between which this Lookup becomes active. If you do not enter a start date, your Lookup is valid immediately.
Once a Lookup expires, users cannot insert additional records using the Lookup, but can query records that already use the Lookup. If you do not enter an end date, your Lookup is valid indefinitely.
Indicate whether applications can use your Lookup. If you enter No, users cannot insert additional records using your Lookup, but can query records that already use this Lookup.
The double brackets ([ ]) identify a descriptive flexfield that you can use to add data fields to this window without programming.