title: Oracle EBS: Get profile values
body: <p>I was working with Oracle R12 application.Can anybody suggest some queries to identify the <code>Profile names and Profile values</code> related to a particular product/item selected??</p>
  
  <p>I tried using </p>
  
  <pre><code>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
  </code></pre>
  
  <p>It will return all profile values. But how can I identify the profile value of an item/product I selected.</p>