FND Flex Values

➜ Back to Library
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 NameSQL textValidation
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
Download
 
Related Blitz Reports
FND Flex Value Hierarchy COPY OF: GL Balance by Account Hierarchy JE Israeli Withholding Annual Certificate To Vendors GL Balance by Account Hierarchy FND Flex Value Sets, Usages and Values FND Key Flexfields FND Concurrent Programs and Executables FND Flex Security Rules FND Descriptive Flexfields
Blitz Report In Action