Security rule on custom profile
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