Descriptive Flex Field

select

  fdf.application_id,

  fdf.descriptive_flexfield_name,

  fdf.application_table_name,

  fdft.title,

  fdft.description

from fnd_descriptive_flexs fdf

left join (

  select *

  from fnd_descriptive_flexs_tl

) fdft on fdf.application_id=fdft.application_id

      and fdf.descriptive_flexfield_name=fdft.descriptive_flexfield_name

where 1=1

and fdf.application_id=222

and application_table_name like '%INT%';