Segments used in DFF Query

SELECT t.title, t2.descriptive_flex_context_code, t3.application_column_name

  FROM fnd_descriptive_flexs_tl t,

       fnd_descriptive_flexs b,

       fnd_descr_flex_contexts_tl t2,

       fnd_descr_flex_contexts b2,

       fnd_descr_flex_col_usage_tl t3,

       fnd_descr_flex_column_usages b3

 WHERE b.application_id = t.application_id

   AND b.descriptive_flexfield_name = t.descriptive_flexfield_name

   AND t.LANGUAGE = USERENV ('LANG')

 ---  AND t.title = 'Vendor Sites'

   AND b.descriptive_flexfield_name = b2.descriptive_flexfield_name

   AND b2.application_id = t2.application_id

   AND b2.descriptive_flexfield_name = t2.descriptive_flexfield_name

   AND b2.descriptive_flex_context_code = t2.descriptive_flex_context_code

   AND t2.LANGUAGE = USERENV ('LANG')

   AND b2.application_id = b3.application_id

   AND b2.descriptive_flexfield_name = b3.descriptive_flexfield_name

   AND b2.descriptive_flex_context_code = b3.descriptive_flex_context_code

   AND b3.application_id = t3.application_id

   AND b3.descriptive_flexfield_name = t3.descriptive_flexfield_name

   AND b3.descriptive_flex_context_code = t3.descriptive_flex_context_code

   AND b3.application_column_name = t3.application_column_name

   AND t3.LANGUAGE = USERENV ('LANG');