–已测试（两段均可），请变更账套名
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';