1、从值集中取值
SELECT
ffv.flex_value, ffv.description
FROM
fnd_flex_values_vl ffv, fnd_flex_value_sets
ffs
WHERE
ffv.flex_value_set_id = ffs.flex_value_set_id
AND
ffs.flex_value_set_name =
'CUX_GL_COA_CO'
--值集名
AND
ffv.enabled_flag =
'Y'
AND
SYSDATE
BETWEEN
nvl
(ffv.start_date_active,
SYSDATE
)