EBS Customizations (MOSC)

MOSC Banner

Security rule on custom profile

edited Aug 25, 2009 4:12PM in EBS Customizations (MOSC) 2 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center