Setting up cascading LOVs

Cascading LOVs refer to two or more LOVs where the possible values of one LOV depend on specific attribute values defined in another LOV. These controlling attributes are used in order to filter the result set produced by the controlled LOVs. The filtering is usually accomplished by adding named view criteria, based on bind variables, to the controlled LOV list data source (the view accessor). This allows you to filter the view object result set by adding query conditions that augment the view object query WHERE clause. Furthermore, the filtering can be done by directly modifying the controlled LOV view accessor query, adding the controlling attributes as bind variable placeholders in its query. This technique comes handy when you want to set up interrelated LOV components in your UI pages, where the contents of one LOV are filtered based on the value selected in the other LOV.

For this recipe, we will create two LOVs, one for the DEPARTMENTS table and another...