Query to get profile values for different levels in Oracle Fusion

by admin

SELECT
    fpob.profile_option_name,
    fpov.profile_option_value,
    fpov.level_value
FROM
    fnd_profile_option_values  fpov,
    fnd_profile_options_b      fpob
WHERE
        1 = 1
    AND fpob.profile_option_id = fpov.profile_option_id
  --  AND fpov.level_value = 'SITE'
   --AND fpob.profile_option_name = upper(p_profile_name)

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: OracleSaaSQueries