PL/SQL (MOSC)

MOSC Banner

Like

in PL/SQL (MOSC) 2 commentsAnswered ✓

Hi,

I run the following:

select c.profile_option_name, b.level_id, b.level_value, PROFILE_OPTION_VALUE
from apps.fnd_profile_options a, apps.fnd_profile_option_values b, apps.fnd_profile_options_tl c
where a.profile_option_id = b.profile_option_id
and a.PROFILE_OPTION_NAME=c.PROFILE_OPTION_NAME
and c.USER_PROFILE_OPTION_NAME like 'WF%';

But I get also what begins with FND. What is wrone with my query? I want only those which begins with WF.

Thanks and regards.

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