Oracle Apps queries for finding out the attribute and segment column meanings

Here are few handy Oracle Apps queries :

To find the meaning of attribute columns(descriptive flexfield columns) in a table.

Step 1:

SELECT descriptive_flexfield_name, context_column_name, title, description
FROM fnd_descriptive_flexs_vl fdfv
WHERE application_table_name = /* Give the table name here */

Step 2:
SELECT descriptive_flex_context_code, enabled_flag, description,
       descriptive_flex_context_name
  FROM fnd_descr_flex_contexts_vl
 WHERE descriptive_flexfield_name = /* Get from Step 1 */

Step 3:
SELECT application_column_name, end_user_column_name, enabled_flag,
       display_flag, DEFAULT_VALUE, description
  FROM fnd_descr_flex_col_usage_vl
 WHERE descriptive_flexfield_name = 'OE_HEADER_ATTRIBUTES'
   AND descriptive_flex_context_code = /* Get from Step 2 */

To find the meaning of segment columns(key flexfield columns) in a table.

Step 1:

SELECT id_flex_code, id_flex_name, unique_id_column_name, description,
       set_defining_column_name
  FROM fnd_id_flexs
 WHERE application_table_name = /* Give the table name here */

Step 2:
SELECT id_flex_num, id_flex_structure_code, structure_view_name,
       id_flex_structure_name, description
  FROM fnd_id_flex_structures_vl
 WHERE id_flex_code = /* Get from Step 1 */

Step 3:

 SELECT application_column_name, segment_name, enabled_flag, description
  FROM fnd_id_flex_segments_vl
 WHERE id_flex_code = /* Get from Step 2 */ AND id_flex_num =  /* Get from Step 2 */