1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query To Display Security Rules Details in General Ledger

Discussion in 'Oracle Apps Technical' started by jagadekara, May 28, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Code (SQL):
    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 1=1
       AND fif.id_flex_name='Accounting Flexfield'
       --AND fif.id_flex_number= fifs.id_flex_num
       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
     
  2. oracleappstraining18

    oracleappstraining18 Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Bangalore
    Nice information really