Database Reference
In-Depth Information
Figure 7-7.
Specifying a LOV for the ASSIGNED_TO column
13.
Edit the
CREATED_BY
column.
14.
In the
Column Attributes
region, set the
Display As
field to
Select List
(Named LOV)
.
15.
In the
List of Values
section, set
Named LOV
to
USERS
,
Display Extra
Values
to
No
, and
Display Null
to
Yes
, and enter
- Select a User
-
for
Null Display Value
, as shown in
Figure 7-8
.
Then click
Apply
Changes
.
Figure 7-8.
Specifying LOV attributes for the CREATED_BY column
16.
Edit the
STATUS_ID
column.
17.
In the
Tabular Form Attributes
region, set
Default Type
to
PL/SQL Ex-
pression or Function
and enter
get_status ('OPEN')
for
Default
,
and click
Apply Changes
.
Next, you need to create a button on page 200 that links to your new tabular form:
1.
Edit
Page 200
of the application.
2.
Create a new button by right-clicking the
Region Buttons
node and select-
ing
Create
.