Dependent Values in DFF Enabled Fields in Oracle APPS

 We can use :$FLEX$.Previous_Value_Set_Name to get dependent Values in DFF Enabled Fields in Oracle APPS.

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

API to Delete Descriptive Flex Field Context in Oracle APPS

--------------------------------------------------------------------------------
--API to delete Descriptive Flex Field Context
--------------------------------------------------------------------------------
DECLARE
CURSOR c1
IS
SELECT dff.application_id
  ,dff.descriptive_flexfield_name
              ,dff_context.descriptive_flex_context_code
  FROM fnd_descriptive_flexs_vl dff
              ,fnd_descr_flex_contexts_vl dff_context
         WHERE title = 'Requisition Headers'
   AND dff.descriptive_flexfield_name = dff_context.descriptive_flexfield_name
   AND dff_context.descriptive_flex_context_code IN ('Test','Req Operating Enable')
;
BEGIN
FOR i IN c1
LOOP
BEGIN 
fnd_descr_flex_contexts_pkg.delete_row(x_application_id                => i.application_id
  ,x_descriptive_flexfield_name    => i.descriptive_flexfield_name
  ,x_descriptive_flex_context_cod  => i.descriptive_flex_context_code
  ); 
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('Error occured while deleting DFF Context. Error Message: '||SQLERRM);
END;

dbms_output.put_line('DFF Conetext Filed: '||i.descriptive_flex_context_code ||' deleted successfully');

END LOOP;


END;

--
--Run below query to validate deletion successfully or not
/*SELECT dff.application_id
  ,dff.descriptive_flexfield_name
              ,dff_context.descriptive_flex_context_code
  FROM fnd_descriptive_flexs_vl dff
              ,fnd_descr_flex_contexts_vl dff_context
         WHERE title = 'Requisition Headers'
   AND dff.descriptive_flexfield_name = dff_context.descriptive_flexfield_name
   AND dff_context.descriptive_flex_context_code IN ('Test','Req Operating Enable')
;
*/

-- Issue commit