SQL query to extract UDT table

Hello,

We are trying to create a data model in which we can pull all the data of the UDT into a report. The sql I have been using is the following. Can anyone suggest a way to add the effective start date of each row of the columns that are generated in the report, so as to make the analysis easier to track?

SELECT /*+ MATERIALIZE */

r.row_low_range_or_name SSN,

MAX(CASE

WHEN c_tl.user_column_name = 'PARAMETER'

THEN v.value

ELSE ''

END) PARAMETER,

MAX(CASE WHEN c_tl.user_column_name = 'WEIGHT'

THEN v.value