Descriptive flexfields SQL to get DFF Details

Descriptive flex fields have always been used on Standard Oracle forms to provide the business additional fields for information representation.

From the front end information of the DFF can be seen from the Application Developer Responsibility

Flexfields --> Descriptive --> Register

For a technical developer if needed the DFF information can be checked from the Data base too via an SQL.

The below SQL gives the DFF details defined for AR Invoices :
Line transaction flexfield

SELECT fdf.application_id,
       fdf.APPLICATION_TABLE_NAME,
       fdf.TITLE,
       fdfc.DESCRIPTIVE_FLEX_CONTEXT_CODE,
       fdfc.DESCRIPTION    ,
       col.APPLICATION_COLUMN_NAME,
       col.end_user_column_name,
       col.ENABLED_FLAG,
       col.FLEX_VALUE_SET_ID
  FROM FND_DESCRIPTIVE_FLEXS_VL fdf,
       FND_DESCR_FLEX_CONTEXTS_VL fdfc,
       FND_DESCR_FLEX_COL_USAGE_VL col
 WHERE     fdfc.DESCRIPTIVE_FLEXFIELD_NAME = fdf.DESCRIPTIVE_FLEXFIELD_NAME
       AND (fdf.TITLE) LIKE '%Orga%para%'
       AND fdf.application_id = col.application_id
       AND col.DESCRIPTIVE_FLEXFIELD_NAME = fdf.DESCRIPTIVE_FLEXFIELD_NAME
       AND fdfc.descriptive_flex_context_code = col.descriptive_flex_context_code;

Changing the Title we can get details of Order flexfield Structures too