Query To Find the Felxfield Segment details

SELECT   fa.application_name, fifst.id_flex_structure_name,
         segment_num "Number", segment_name "Name",
         form_left_prompt "Window Prompt",
         fifs.application_column_name "Column",
         ffvs.flex_value_set_name "Value Set Name",
         ffvs.description "Value Set Description",
         default_type "Default Type", DEFAULT_VALUE "Default Value",
         DECODE (fifs.required_flag,
                 'Y', 'Checked',
                 'N', 'Unchacked'
                ) "Required",
         DECODE (fifs.security_enabled_flag,
                 'Y', 'Checked',
                 'N', 'Unchacked'
                ) "Security Enabled",
         range_code "Range",
         DECODE (display_flag, 'Y', 'Checked', 'N', 'Unchacked') "Display",
         DECODE (enabled_flag, 'Y', 'Checked', 'N', 'Unchacked') "Enabled",
         DECODE (application_column_index_flag,
                 'Y', 'Checked',
                 'N', 'Unchacked'
                ) "Indexed",
         display_size "Display Size",
         maximum_description_len "Descirption Size",
         concatenation_description_len "Concatenated Description Size",
         form_above_prompt "List Of Value Prompt"
    FROM fnd_id_flex_segments fifs,
         fnd_id_flex_segments_tl fifsgt,
         fnd_id_flex_structures_tl fifst,
         fnd_flex_value_sets ffvs,
         fnd_application_tl fa
   WHERE fa.application_id = fifs.application_id
     AND fifs.id_flex_num = fifst.id_flex_num
     AND fifsgt.id_flex_num = fifs.id_flex_num
     AND fifsgt.id_flex_code = fifs.id_flex_code
     AND fifsgt.application_column_name = fifs.application_column_name
     AND fifst.id_flex_code = fifs.id_flex_code
     AND ffvs.flex_value_set_id = fifs.flex_value_set_id
   --AND fifst.id_flex_structure_name LIKE :flex_name
   --and fifst.id_flex_num = 53558
   --AND fifs.id_flex_code = 'GL#'
ORDER BY application_name,id_flex_structure_name;