Saturday, January 29, 2022

Query to find the Descriptive Flex Field (DFF) fields attached to a Context Code in Oracle APPS



SELECT fat.application_name

      ,desc_flex.descriptive_flexfield_name

      ,desc_flex.title

      ,desc_flex_col_usg.descriptive_flex_context_code

      ,desc_flex_col_usg.column_seq_num

      ,desc_flex_col_usg.end_user_column_name

      ,desc_flex_col_usg.application_column_name

      ,desc_flex_col_usg.form_left_prompt

      ,desc_flex_col_usg.form_above_prompt

      ,desc_flex_col_usg.flex_value_set_id value_set_id

      ,flex_vs.flex_value_set_name

      ,flex_vs.validation_type

      ,desc_flex_col_usg.enabled_flag

      ,desc_flex_col_usg.required_flag      

      ,desc_flex_col_usg.display_flag

      ,desc_flex_col_usg.display_size

  FROM fnd_descriptive_flexs_tl desc_flex

      ,fnd_descr_flex_col_usage_vl desc_flex_col_usg

      ,fnd_flex_value_sets flex_vs

      ,fnd_application_tl fat

 WHERE  1=1

   AND desc_flex.descriptive_flexfield_name = desc_flex_col_usg.descriptive_flexfield_name

   AND desc_flex.language = USERENV('LANG')

   AND desc_flex_col_usg.descriptive_flex_context_code = 'CONTRACTS'

   --AND desc_flex_col_usg.descriptive_flexfield_name = 'RA_INTERFACE_LINES'

   AND flex_vs.flex_value_set_id(+) = desc_flex_col_usg.flex_value_set_id

   AND desc_flex_col_usg.application_id = fat.application_id

   AND fat.language = USERENV('LANG')

   --AND fat.application_id = 222

   AND desc_flex.title = 'Line Transaction Flexfield'

ORDER BY desc_flex_col_usg.column_seq_num

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...