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 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
Download
 
Related Blitz Reports
FND Flex Value 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 JA Third Party Detail Trial Balance with Contra Accounts ONT Transaction Types Listing
Blitz Report In Action