SQL to get the UDT values

                                              SQL to get the UDT value

select

fuci.value

from

ff_user_tables fut

,ff_user_column_instances_f fuci

,ff_user_columns fuc

,ff_user_columns_tl fuct

,ff_user_rows_f furf

where 1=1

and fut.user_table_id = fuc.user_table_id

and fuc.user_column_id = fuct.user_column_id

and fut.user_table_id = furf.user_table_id

and fuci.user_row_id = furf.user_row_id

and fuci.user_column_id = fuct.user_column_id

and fut.BASE_USER_TABLE_NAME ='TABLE_NAME'

and fuct.USER_COLUMN_NAME IN ('COLUMN_NAME')

and furf.ROW_LOW_RANGE_OR_NAME IN ('ROW_NAMES')

--and to_number(:{PARAMETER.value})  between (cast(furf.ROW_LOW_RANGE_OR_NAME as float))  and furf.ROW_HIGH_RANGE

--and to_number(:{PARAMETER.value})  between furf.ROW_LOW_RANGE_OR_NAME and furf.ROW_HIGH_RANGE

order by furf.DISPLAY_SEQUENCE

It may helpful for you. please visit the blog for more information and share your ideas.

Thanks

Sainath