This query selects FLEX_VALUE from FND_FLEX_VALUES by joining it with FND_VS_VALUE_SETS to identify the related value set. It returns only values that are enabled (ENABLED_FLAG = ‘Y’) and currently active based on the system date. The date filter ensures the flex values fall within their defined active start and end dates
SELECT fffv2.flex_value
FROM
fusion.fnd_vs_value_sets ffvvs1 , fusion.fnd_flex_values fffv2
WHERE
1=1
--ffvvs1.value_set_code LIKE 'Put your '
AND ffvvs1.value_set_id = fffv2.flex_value_set_id
AND fffv2.enabled_flag = 'Y'
AND TRUNC(SYSDATE) BETWEEN COALESCE(fffv2.start_date_active,
TRUNC(SYSDATE)) AND COALESCE(fffv2.end_date_active, TRUNC(SYSDATE)) Output Results
Related Posts
