Oracle Flexfield query

Flexfield Header

his shows the highest / top level of detail for a DFF - in this case, using 'Flexfield Segment Values' as an example.

-- Setup > Financials > Flexfields > Descriptive > Segments

SELECT fat.application_name
     , fdfv.title
     , fdfv.descriptive_flexfield_name dff_name
     , fdfv.freeze_flex_definition_flag frozen_tick
     , fdfv.concatenated_segment_delimiter separator
     , fdfv.form_context_prompt prompt
     , fdfv.default_context_field_name ref_field
     , fdfv.context_required_flag required_tick
     , fdfv.context_user_override_flag displayed_tick
     , fdfv.context_synchronization_flag sync_tick
  FROM apps.fnd_descriptive_flexs_vl fdfv
     , applsys.fnd_application_tl fat
 WHERE fdfv.application_id = fat.application_id
   AND fdfv.title = 'Flexfield Segment Values'
   AND 1 = 1;

Flexfield Header and Contexts

 Setup > Financials > Flexfields > Descriptive > Segments

 Search for relevant Title, second half of the screen, under "Context Field Values" lists the

 main parts of the Flexfield

 

SELECT fat.application_name

     , fdfv.title

     , fdfv.descriptive_flexfield_name dff_name

     , fdfcv.descriptive_flex_context_code

     , fdfcv.description context_description

  FROM apps.fnd_descriptive_flexs_vl fdfv

     , applsys.fnd_application_tl fat

     , apps.fnd_descr_flex_contexts_vl fdfcv

 WHERE fdfv.application_id = fat.application_id

   AND fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name

   AND fdfv.title = 'Flexfield Segment Values'

   AND 1 = 1;

 

Flexfield Header, Contexts and Segments

 

 Setup > Financials > Flexfields > Descriptive > Segments Search for relevant Title, second half of the screen, under "Context Field Values" lists the  main parts of the Flexfield Click into a name on the "Context Field Values" section in the lower part of the screen, and click "Segments" This lists the bits users see in Core Applications when they click into the DFF plus shows if there is a LOV linked to the field

  SELECT fat.application_name
       , fdfv.title
       , fdfcv.descriptive_flex_context_code context
       , fdfcuv.column_seq_num num
       , fdfcuv.end_user_column_name name
       , fdfcuv.application_column_name column_
       , ffvs.flex_value_set_name value_set
       , ffvs.description value_set_description
       , fdfcuv.required_flag
       , fdfcuv.display_flag
       , fdfcuv.enabled_flag
       , fdfcuv.security_enabled_flag
       , fdfcuv.default_value
    FROM apps.fnd_descriptive_flexs_vl fdfv
       , applsys.fnd_application_tl fat
       , apps.fnd_descr_flex_contexts_vl fdfcv
       , apps.fnd_descr_flex_col_usage_vl fdfcuv
       , applsys.fnd_flex_value_sets ffvs
   WHERE fdfv.application_id = fat.application_id
     AND fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name
     AND fdfcv.descriptive_flexfield_name = fdfcuv.descriptive_flexfield_name
     AND fdfcv.descriptive_flex_context_code = fdfcuv.descriptive_flex_context_code
     AND fdfcuv.flex_value_set_id = ffvs.flex_value_set_id(+)
     AND fdfv.title = 'Tasks'
--     AND fdfcuv.end_user_column_name LIKE 'RAE%'
--     AND fdfcv.descriptive_flex_context_code = 'TEST'
ORDER BY fat.application_name
       , fdfv.title
       , fdfcv.descriptive_flex_context_code
       , fdfcuv.column_seq_num;