Security rule on custom profile
Hi,
We have created a profile that's being set on user level through the form FNDPOSMV. It's basically just bringing in a LoV from the natural accounts segment based on the following SQL:
SQL="SELECT FLEX_VALUE||' - '||DESCRIPTION \"Account\", FLEX_VALUE
into :visible_option_value,
:profile_option_value
from fnd_flex_values_vl
where enabled_flag = 'Y'
and Summary_flag = 'N'
and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
and flex_value_set_id = (
select flex_value_set_id
from fnd_id_flex_segments
where id_flex_num = (select chart_of_accounts_id
SQL="SELECT FLEX_VALUE||' - '||DESCRIPTION \"Account\", FLEX_VALUE
into :visible_option_value,
:profile_option_value
from fnd_flex_values_vl
where enabled_flag = 'Y'
and Summary_flag = 'N'
and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
and flex_value_set_id = (
select flex_value_set_id
from fnd_id_flex_segments
where id_flex_num = (select chart_of_accounts_id
0