Creating a Static View Object

A static LOV is based on a view object where transient attributes are created and populated at design time. You will define a view object, populate it with the static values needed for the LOV and associate it with the view object that will use it as an LOV.

The general steps are:

• Define a new view object ( StatusCodes) based on a static list of status codes and their descriptions.
• Add the valid status code and description values to the view object.
• Make the StatusCodes object available to the OrdersView view object by adding it through a view accessor.

To begin creating a view object, you will launch the Create View Object wizard. To launch the wizard, in the Application Navigator, right-click the project and choose New . In the New Gallery, select ADF Business Components in the Categories tree and View Object in the Items list and click OK.

In the wizard, you'll create transient attributes for the view object.

Transient attributes are calculated attributes, when their value is not retrieved as part of a SQL query. The other calculated attributes are SQL-calculated attributes, when their value is retrieved as an expression in the SQL query's SELECT list.