Dynamically Selecting DFF Columns using Utility

Yes, you should use the function **`XXEN_UTIL.DFF_COLUMNS`**. This function is designed to return a SQL text snippet suitable for `&lexical` replacement in your report’s extraction SQL.

Key parameters include `p_table_name` and `p_table_alias`. It can also take optional parameters like `p_descr_flex_context_code` to restrict to a specific context, or `p_column_name_prefix` to add a prefix like ‘Item: ‘ to the column name aliases.

Yes, the function automatically generates column text that uses the DFF’s form left prompt as the column alias, such as `msiv.attribute15 “Invoice UOM”`.