FND Flex Values

Description

Categories: Application, Enginatics

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

Ask a question

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 INV Item cross-references listing FND Descriptive Flexfields