BIP – Extract UDT data

Use below query to extract data related to User Defined Tables in Oracle HCM

select fut.base_user_table_name		"User Table"
      ,(select pldgt.name 
         from per_legislative_data_groups_tl pldgt 
        where pldgt.legislative_data_group_id=fucif.legislative_data_group_id
          and pldgt.language=userenv('LANG')) 	"Legsilative Data Group"
      ,fuc.base_user_column_name	"Column Name"
	  ,furf.row_low_range_or_name	"Row Name"
      ,to_char(fucif.effective_start_date,'YYYY/MM/DD') "Value Date Start"
	  ,to_char(fucif.effective_end_date,'YYYY/MM/DD')	"Value Date End"
      ,fucif.value
 from  ff_user_column_instances_f fucif,
       ff_user_columns fuc,
       ff_user_rows_f furf,
       ff_user_tables fut
 where fucif.user_column_id=fuc.user_column_id
   and furf.user_row_id=fucif.user_row_id
   and furf.user_table_id=fut.user_table_id
   and fuc.user_table_id=fut.user_table_id