Using Parameter Values for Default Value SQL (Dependent Parameters)

To define parameter dependencies in default values, you must use the syntax: :$flex$.parameter_or_lov_name.

The default value should start with ‘select’ if it is derived dynamically. An example using concatenation might be: select :$flex$.operating_unit||’ suppliers’ from dual.

The parameter name must be the name in the installed base language (usually US), prefixed with a colon, and with spaces or other non-word characters replaced with a single underscore (e.g., :$flex$.operating_unit).