集值
路径:设置 >> 财务系统 >> 弹性域 >> 关键字 >> 值 (>>Setup >> Financials >> Flexfields >> Key >> Values)
1 SELECT ffvs.flex_value_set_id ,--集值 2 ffvs.flex_value_set_name , --名称 3 ffvs.description set_description , 4 ffvs.validation_type, 5 ffv.flex_value_id ,--ID 6 ffv.flex_value , --值 7 ffvt.flex_value_meaning ,--转换的值 8 ffvt.description value_description--值说明 9 FROM fnd_flex_value_sets ffvs ,--集值头 10 fnd_flex_values ffv , --行 11 fnd_flex_values_tl ffvt --多语言 12 WHERE ffvs.flex_value_set_id = ffv.flex_value_set_id 13 AND ffv.flex_value_id = ffvt.flex_value_id 14 AND ffvt.language = USERENV('LANG') 15 AND ffvs.flex_value_set_name='LSG_CITY'