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