–已测试(两段均可),请变更账套名
select x.flex_validation_rule_name,
x.description,
h.include_exclude_indicator,
h.concatenated_segments_low,
h.concatenated_segments_high
from apps.fnd_flex_vdation_rules_vl x,
apps.fnd_flex_validation_rule_lines h,
gl_ledgers g
where 1 = 1
and x.id_flex_num = g.chart_of_accounts_id
and x.flex_validation_rule_name = h.flex_validation_rule_name
and (h.id_flex_code = 'GL#')
and (h.application_id = 101)
and g.name = 'FIN_Ledger'
order by x.flex_validation_rule_name;
SELECT FFCV.APPLICATION_NAME,
FFCV.FLEX_STRUCTURE_NAME,
FFVV.FLEX_VALIDATION_RULE_NAME,
FFVV.DESCRIPTION,
FFVV.ERROR_MESSAGE_TEXT 错误信息,
DECODE(FFVL.INCLUDE_EXCLUDE_INDICATOR, 'I', '包括', '排除'