SELECT ffvv.description
,ffvv.flex_value
FROM fnd_flex_value_sets ffvs
,fnd_flex_values_vl ffvv
WHERE ffvs.flex_value_set_id = ffvv.flex_value_set_id
AND ffvs.flex_value_set_name = 'CAAMS_OM_CLASS_WHERE'
AND ffvv.enabled_flag = 'Y'
AND nvl (ffvv.end_date_active, SYSDATE) >= SYSDATE
ORDER BY ffvv.description
懒人SQL-独立值集
最新推荐文章于 2023-04-04 01:38:56 发布