FND Flex Values

➜ Back to Library

Description
Categories: Application, Enginatics more less

Copy

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 Concurrent Programs and Executables JE Israeli Withholding Annual Certificate To Vendors GL Balance by Account Hierarchy GL Balance by Account FND Flex Value Sets, Usages and Values FND Flex Value Hierarchy FND Descriptive Flexfields PER Organizations FND Key Flexfields