Oracle JDeveloper 11gR2 Cookbook

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 ...