Reports2017-11-18T12:27:27+00:00

FND Flex Values

Description
Categories: Application, Enginatics

select
ffvs.flex_value_set_name,
ffvv.flex_value,
ffvv.flex_value_meaning,
ffvv.description,
xxen_util.meaning(decode(ffvv.summary_flag,'Y','Y'),'YES_NO',0) summary_flag,
ffvv.parent_flex_value_low,
ffvv.parent_flex_value_high,
ffvv.start_date_active,
ffvv.end_date_active,
xxen_util.meaning(decode(ffvv.enabled_flag,'Y','Y'),'YES_NO',0) enabled_flag,
xxen_util.user_name(ffvv.created_by) created_by,
xxen_util.client_time(ffvv.creation_date) creation_date,
xxen_util.user_name(ffvv.last_updated_by) last_updated_by,
xxen_util.client_time(ffvv.last_update_date) last_update_date
from
fnd_flex_value_sets ffvs,
fnd_flex_values_vl ffvv
where
1=1 and
ffvs.flex_value_set_id=ffvv.flex_value_set_id

Parameter Name SQL text Validation
Last Updated By
ffvv.last_updated_by in (select fu.user_id from fnd_user fu where fu.user_name=:last_updated_by)
LOV
Created By
ffvv.created_by in (select fu.user_id from fnd_user fu where fu.user_name=:user_name)
LOV
Last Update Date From
ffvv.last_update_date>=:last_update_date_from
DateTime
Creation Date From
ffvv.creation_date>=:creation_date_from
Date
Flex Value Set
ffvs.flex_value_set_name=:flex_value_set_name
LOV

By continuing to use the site, you agree to the use of cookies. Accept