Key Flexfield Definition

I do not use key flexfields very often and whenever i use, i get confused and it takes some time. So today i decide to write a query to get details of key flexfield. This query can give me all segments of a key flexfield and the value set used by key flexfield segments.

SELECT flex.id_flex_code "Id_Flex_Code(Code)" , flex.id_flex_name "Id_flex_name(Title)" , flex.application_table_name , flex.concatenated_segs_view_name , struct.id_flex_num "Flex_Num(Chart Of account ID)" , struct.id_flex_structure_code "Id_Flex_Structure_Code(Code)" , segs.segment_num , segs.application_column_name , segs.segment_name , value.flex_value_set_name FROM apps.fnd_id_flexs flex , apps.fnd_id_flex_structures struct , apps.fnd_id_flex_segments segs , apps.fnd_flex_value_sets value WHERE flex.id_flex_code in ('GL#', 'CAT#', 'MSTK') AND flex.application_id = struct.application_id AND flex.id_flex_code = struct.id_flex_code AND struct.application_id = segs.application_id AND struct.id_flex_code = segs.id_flex_code AND struct.id_flex_num = segs.id_flex_num AND segs.flex_value_set_id = value.flex_value_set_id (+) ORDER BY flex.id_flex_code , struct.id_flex_num , segs.segment_num ;