I was working with Oracle R12 application.Can anybody suggest some queries to identify the Profile names and Profile values related to a particular product/item selected??
I tried using
SELECT *
FROM fnd_profile_options_vl po,
fnd_profile_option_values pov,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
WHERE 1 = 1
AND pov.application_id = po.application_id
AND pov.profile_option_id = po.profile_option_id
AND usr.user_id(+) = pov.level_value
AND rsp.application_id(+) = pov.level_value_application_id
AND rsp.responsibility_id(+) = pov.level_value
AND app.application_id(+) = pov.level_value
AND svr.node_id(+) = pov.level_value
AND org.organization_id(+) = pov.level_value
It will return all profile values. But how can I identify the profile value of an item/product I selected.
check my post:http://blog.csdn.net/pan_tian/article/details/7652968
1. List E-Business Suite Profile Option Values For All Levels
2. How to Search all of the Profile Options for a Specific Value
3. How To Find All Users With A Particular Profile Option Set