Query to get DFF and SEGMENT values

SELECT ffv.descriptive_flexfield_name DFFName,
  ffv.application_table_name TableName,
  ffv.title Title,
  ap.application_name Application,
   att.column_seq_num SegmentNumber,
  att.form_left_prompt SegmentName,
  att.application_column_name ,
  fvs.flex_value_set_name ValueSet,
  att.required_flag
FROM apps.fnd_descriptive_flexs_vl ffv,
  apps.fnd_descr_flex_contexts_vl ffc,
  apps.fnd_descr_flex_col_usage_vl att,
  apps.fnd_flex_value_sets fvs,
  apps.fnd_application_vl ap
WHERE ffv.descriptive_flexfield_name = att.descriptive_flexfield_name
AND ap.application_id                =ffv.application_id
AND ffv.descriptive_flexfield_name   = ffc.descriptive_flexfield_name
AND ffv.application_id               = ffc.application_id
AND ffc.descriptive_flex_context_code=att.descriptive_flex_context_code
AND fvs.flex_value_set_id            =att.flex_value_set_id
AND ffv.title LIKE 'Additional Line Attribute Information';
--AND att.form_left_prompt LIKE '%VENDOR%';
ORDER BY att.column_seq_num;