Query to get DFF's Values based on context field values you will get Segment values

SELECT
       fdf.title                             DFF_Title,
       fdf.application_table_name            Application_Table,
       fdf.context_column_name               Context_Column_Name,
       --
       fdfcu.descriptive_flex_context_code   DFF_Context_Code,
       fdfcu.column_seq_num                  Sequence,
       fdfcu.end_user_column_name            Segment_Name,
       fdfcu.application_column_name         Column_Name,
       --
       ffv.flex_value_set_name               Value_Set_Name
  FROM
       fnd_descr_flex_col_usage_vl   fdfcu,
       fnd_descriptive_flexs_vl      fdf,
       fnd_flex_value_sets           ffv
 WHERE
       1 = 1
   --
   AND fdf.title like 'Additional Information for Agents%'       -- Change Title 
   AND fdfcu.descriptive_flex_context_code = 'Enter code'   -- Problem code (Give Context Flex Field Values)
   AND fdfcu.enabled_flag = 'Y'
   --
   AND fdfcu.flex_value_set_id = ffv.flex_value_set_id
   AND fdfcu.descriptive_flexfield_name = fdf.descriptive_flexfield_name
   AND fdfcu.application_id = fdf.application_id
      --
 ORDER BY
       fdfcu.descriptive_flexfield_name,
       fdfcu.descriptive_flex_context_code,

       fdfcu.column_seq_num;