Query To Find the Key Flexfield Details

SELECT fifs.id_flex_code,fat.application_name "Application", fif.id_flex_name "Flexfield Title",
       fifs.id_flex_structure_code "Structure Code",
       fifst.id_flex_structure_name "Structure Title",
       fifst.description "Structure Description",
       fifs.STRUCTURE_VIEW_NAME "Structure View Name"
       ,decode(fifs.FREEZE_FLEX_DEFINITION_FLAG,'Y','Checked','N','Unchacked') "Freeze Felxfield Definition",
       decode(ENABLED_FLAG,'Y','Checked','N','Unchacked') "Enabled",
       CONCATENATED_SEGMENT_DELIMITER "Segment Separator",
       decode(CROSS_SEGMENT_VALIDATION_FLAG,'Y','Checked','N','Unchacked') "Cross-Validation Segment",
       decode(FREEZE_STRUCTURED_HIER_FLAG,'Y','Checked','N','Unchacked') "Freeze Rollup Group" ,
       decode(DYNAMIC_INSERTS_ALLOWED_FLAG,'Y','Checked','N','Unchacked') "Allow Dyanamic Insert" ,
       fuc.User_name "Created By",
       ful.user_name "Last Updated By"      
  FROM fnd_id_flex_structures fifs,
       fnd_id_flexs fif,
       fnd_application_tl fat,
       fnd_id_flex_structures_tl fifst,
       fnd_user fuc,
       fnd_user ful
 WHERE fif.application_id = fat.application_id
   AND fifs.id_flex_code = fif.id_flex_code
   AND fifst.id_flex_num = fifs.id_flex_num
   AND fifst.id_flex_code = fifs.id_flex_code
   and fuc.user_id(+)=fifs.created_by
   and ful.user_id(+)=fifs.last_updated_by
   AND fifs.id_flex_code = 'GL#'
--   and fat.application_name  like 'G%'
--   AND id_flex_structure_name LIKE :Flex_name
order by application_name ;