EBS中安全性规则限制sql(Oracle官方写法)

SELECT fnd_flex_values_vl.flex_value,
       fnd_flex_values_vl.flex_value VALUE,
       fnd_flex_values_vl.description DESCRIPTION,
       nvl(fnd_flex_values_vl.summary_flag, 'N'),
       nvl(to_number(fnd_flex_values_vl.structured_hierarchy_level), -1),
       fnd_flex_values_vl.compiled_value_attributes,
       nvl(fnd_flex_values_vl.enabled_flag, 'Y'),
       nvl(to_char(fnd_flex_values_vl.start_date_active, 'J'), 0),
       nvl(to_char(fnd_flex_values_vl.end_date_active, 'J'), 0)
  FROM fnd_flex_values_vl fnd_flex_values_vl
  WHERE (fnd_flex_values_vl.flex_value_set_id = 1013707)--p_flex_value_set_id
    AND (((1 = 1) AND /*
        gl_coa_bs_tag */
        (gl_aff_awc_api_pkg.gl_valid_flex_values(SYSDATE,--p_date
                                                  fnd_flex_values_vl.flex_value) = 'Y')))
    AND NOT EXISTS (SELECT NULL FROM fnd_flex_value_rule_lines l, fnd_flex_value_rule_usages u
                     WHERE u.application_id = 101--p_application_id
                       AND u.responsibility_id = 50726--p_responsibility_id
                       AND u.flex_value_set_id = 1013707--p_flex_value_set_id
                       AND l.flex_value_rule_id = u.flex_value_rule_id
                       AND l.include_exclude_indicator = 'E'
                       AND fnd_flex_values_vl.flex_value BETWEEN
                           nvl(decode(u.flex_value_set_id,
                                      1013707,--p_flex_value_set_id
                                      l.flex_value_low,
                                      NULL),
                               fnd_flex_values_vl.flex_value) AND
                           nvl(decode(u.flex_value_set_id,
                                      1013707,--p_flex_value_set_id
                                      l.flex_value_high,
                                      NULL),
                               fnd_flex_values_vl.flex_value))                 
   AND NOT EXISTS (SELECT NULL FROM fnd_flex_value_rule_usages u
         WHERE u.application_id = 101--p_application_id
           AND u.responsibility_id = 50726--p_responsibility_id
           AND u.flex_value_set_id = 1013707--p_flex_value_set_id
           AND NOT EXISTS (SELECT NULL FROM fnd_flex_value_rule_lines l
                             WHERE l.flex_value_rule_id = u.flex_value_rule_id
                               AND l.include_exclude_indicator = 'I'
                               AND fnd_flex_values_vl.flex_value BETWEEN
                                   nvl(decode(u.flex_value_set_id,
                                              1013707,--p_flex_value_set_id
                                              l.flex_value_low,
                                              NULL),
                                       fnd_flex_values_vl.flex_value) AND
                                   nvl(decode(u.flex_value_set_id,
                                              1013707,--p_flex_value_set_id
                                              l.flex_value_high,
                                              NULL),
                                       fnd_flex_values_vl.flex_value)))
ORDER BY fnd_flex_values_vl.flex_value

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/603436/viewspace-675124/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/603436/viewspace-675124/