Rule Basics

SELECT DISTINCT fvrtl.description

              , fvrtl.error_message

              , 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;