User-define column does not return values

Summary:

Content (required):

Hello everyone,

We are currently trying to create a data model using the following sql:

SELECT /*+ MATERIALIZE */

   r.row_low_range_or_name SSN, r.effective_start_date,

   MAX(CASE WHEN c_tl.user_column_name = 'PERFORMANCE_THRESHOLD_AMOUNT'

            THEN v.value

         ELSE ''

         END) PERFORMANCE_THRESHOLD_AMOUNT

FROM ff_user_tables t

INNER JOIN ff_user_rows_f r ON t.user_table_id = r.user_table_id

INNER JOIN ff_user_columns c

INNER JOIN ff_user_columns_tl c_tl ON c.user_column_id = c_tl.user_column_id ON t.user_table_id = c.user_table_id INNER JOIN ff_user_column_instances_f v ON c.user_column_id = v.user_column_id