值集维护

------------得到值集数据

-------------通过值集的名称得到值集的ID

---值集表： fnd_flex_value_sets

---值集ID： flex_value_set_id

---值集名称：flex_value_set_name

select flex_value_set_id
  from apps.fnd_flex_value_sets
 where flex_value_set_name = 'ML_INV_物料大类';
 

---通过值集ID得到值集列表

---值集列表：FND_FLEX_VALUES_VL

---列表ID：FLEX_VALUE

---列表名称：Description

---是否启用：ENABLED_FLAG   Y是，N否

---层次关系父：SUMMARY_FLAG   Y是，N否

---有效期始：START_DATE_ACTIVE

---有效期止：END_DATE_ACTIVE

--排序：attribute50

--俗称说明：attribute48

select a.flex_value flex_no,
       a.description flex_dsc,
       attribute50,
       attribute48
  from apps.fnd_flex_values_vl a
 where a.flex_value_set_id = 1009627
   and a.enabled_flag = 'Y'
   for update;
   
   ---调整排序

select flex_value,
       attribute50
  from apps.fnd_flex_values a
 where a.flex_value_set_id = 1009627;
--Order By a.flex_value

For Update

----值集代码修改

select *
  from apps.fnd_flex_values_tl t
 where t.flex_value_id = 59940
   and t.language = userenv('LANG')
   for update;