--
----------得到值集数据
-- -----------通过值集的名称得到值集的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 ;
-- -----------通过值集的名称得到值集的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 ;