Query to display Security Rule details in General Ledger

 SELECT fif.id_flex_name

      ,fifs.id_flex_structure_name

      ,ffksv.parent_segment_name

      ,ffvrv.flex_value_rule_name

      ,ffvrv.description

      ,ffvrv.error_message

      ,DECODE(ffvrl.include_exclude_indicator, 'I','Include'

                                         , 'E','Exclude')

      ,ffvrl.flex_value_low

      ,ffvrl.flex_value_high

      ,fav.application_name

      ,frv.responsibility_name

      ,ffvrv2.flex_value_rule_name

  FROM fnd_id_flexs fif

      ,fnd_id_flex_structures_tl fifs

      ,fnd_flex_key_seg_vset_v ffksv

      ,fnd_flex_value_rules_vl ffvrv

      ,fnd_flex_value_rule_lines ffvrl

      ,fnd_flex_value_rule_usages ffvru

      ,fnd_application_vl fav

      ,fnd_responsibility_vl frv

      ,fnd_flex_value_rules_vl ffvrv2

 WHERE fif.id_flex_name ='Accounting Flexfield'

   AND fif.id_flex_code = fifs.id_flex_code

   AND ffksv.id_flex_name = fif.id_flex_name

   AND ffksv.id_flex_structure_name = fifs.id_flex_structure_name

   AND ffvrv.flex_value_set_id = ffksv.flex_value_set_id

   AND ffvrl.flex_value_set_id = ffksv.flex_value_set_id

   AND ffvrl.flex_value_rule_id = ffvrv.flex_value_rule_id

   AND ffvru.flex_value_set_id = ffksv.flex_value_set_id

   AND fav.application_id = ffvru.application_id

   AND frv.responsibility_id = ffvru.responsibility_id

   AND ffvrv2.flex_value_set_id = ffvru.flex_value_set_id

   AND ffvrv2.flex_value_rule_id = ffvru.flex_value_rule_id