Oracle EBS 值集获取段限定词SQL

    SELECT b.flex_value
      ,b.enabled_flag
      ,b.summary_flag
      ,substr(replace(b.compiled_value_attributes, chr(10), ''), 1, 1)  "限定词部分1"
      ,substr(replace(b.compiled_value_attributes, chr(10), ''), 2, 1)  "限定词部分2"
  FROM fnd_flex_values_tl  t
      ,fnd_flex_values     b
      ,fnd_flex_value_sets ffvs
 WHERE ffvs.flex_value_set_name =    &flex_value_set_name
   AND ffvs.flex_value_set_id = b.flex_value_set_id
   AND b.flex_value_id = t.flex_value_id;

-- 刘轶鹤