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/,如需转载,请注明出处,否则将追究法律责任。