FND_FLEX_VALUE_RULE_LINES equivalent table on Oracle Cloud Fusion
Hi all,
I'm working on an EBS to Cloud project, and we have the following requirement - Send to the legacy system all the valid account combinations. Today, they are using the FND_FLEX_VALUES table, and checking if the value is valid using the FND_FLEX_VALUE_RULE_LINES table. This is the SQL used:
select org.organization_code,
fv.flex_value,
fvtl.description as nome_estrut,
fv.enabled_flag,
sysdate
from apps.fnd_flex_values fv,
apps.fnd_flex_values_tl fvtl,
apps.org_organization_definitions org
where fv.flex_value_set_id = 1901
and fv.summary_flag = 'N'
Tagged:
0