Includes and Excludes for a rule

SELECT   fvrtl.description

       , fvrtl.error_message

       , DECODE(

            ffvrl.include_exclude_indicator

          , 'I', 'INCLUDE'

          , 'E', 'EXCLUDE'

         ) "TYPE"

       , ffvrl.flex_value_low "FROM"

       , ffvrl.flex_value_high "TO"

       , ffvs.flex_value_set_name

    FROM applsys.fnd_flex_value_rule_lines ffvrl

       , applsys.fnd_flex_value_rules_tl fvrtl

       , applsys.fnd_flex_value_sets ffvs

   WHERE ffvrl.flex_value_rule_id = fvrtl.flex_value_rule_id

     AND fvrtl.description = :the_rule

     AND ffvs.flex_value_set_id = ffvrl.flex_value_set_id

--     AND ffvs.flex_value_set_name LIKE :ew

ORDER BY 6

       , 3 DESC

       , 4;