–已测试(两段均可),请变更账套名
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', '包括', '排除') INCLUDE_EXCLUDE_INDICATOR,
FFVL.CONCATENATED_SEGMENTS_LOW,
FFVL.CONCATENATED_SEGMENTS_HIGH
FROM FND_FLEX_CROSS_VALIDATION_V FFCV,
FND_FLEX_VDATION_RULES_VL FFVV,
FND_FLEX_VALIDATION_RULE_LINES FFVL
WHERE 1 = 1
AND FFCV.APPLICATION_ID = FFVV.APPLICATION_ID
AND FFCV.FLEX_CODE = FFVV.ID_FLEX_CODE
AND FFCV.FLEX_STRUCTURE_NUM = FFVV.ID_FLEX_NUM
AND FFVV.APPLICATION_ID = FFVL.APPLICATION_ID
AND FFVV.ID_FLEX_CODE = FFVL.ID_FLEX_CODE
AND FFVV.ID_FLEX_NUM = FFVL.ID_FLEX_NUM
AND FFVV.FLEX_VALIDATION_RULE_NAME = FFVL.FLEX_VALIDATION_RULE_NAME
AND FFCV.APPLICATION_ID = 101
AND FFVV.ENABLED_FLAG = 'Y'
AND FFVL.ENABLED_FLAG = 'Y';