Oracle 值集-值查询 

 1 SELECT ffvs.flex_value_set_id,
 2        ffvs.flex_value_set_name 值集名称,
 3        ffv.flex_value_id,
 4        ffv.flex_value           值,
 5        ffv.description          说明,
 6        ffv.start_date_active    起始日期,
 7        ffv.end_date_active      终止日期,
 8        ffv.enabled_flag         是否启用,
 9        ffv.summary_flag         父组标识
10   FROM fnd_flex_values_vl  ffv,
11        fnd_flex_value_sets ffvs
12  WHERE ffv.flex_value_set_id = ffvs.flex_value_set_id
13    AND ffvs.flex_value_set_name = 'DSL_COA_ACCOUNT'

 

posted @ 2020-09-28 10:24  kiko_0926  阅读(572)  评论(0)  编辑  收藏  举报