Thursday 26 December 2013

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;

No comments:

Post a Comment