Oracle EBS 值集获取段限定词SQL
SELECT b.flex_value
,b.enabled_flag
,b.summary_flag
,substr(replace(piled_value_attributes, chr(10), ''), 1, 1)"限定词部分1"
,substr(replace(piled_value_attributes, chr(10), ''), 2, 1)"限定词部分2"
FROM fnd_flex_values_tlt
,fnd_flex_valuesb
,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;
-- 刘轶鹤