Tuesday 13 January 2015

Query to find org_id attached to a responsibility

Query to find org_id attached to a responsibility

SELECT * --fpov.profile_option_value
             FROM applsys.fnd_profile_option_values fpov
                , applsys.fnd_profile_options fpo
                , applsys.fnd_profile_options_tl fpot
                , applsys.fnd_responsibility_tl fr
            WHERE 1 = 1
              AND fpo.profile_option_name = fpot.profile_option_name
              AND fpo.profile_option_id = fpov.profile_option_id
              AND fr.responsibility_id(+) = fpov.level_value
             -- AND fr.responsibility_id = :$PROFILES$.RESP_ID
              AND fpot.profile_option_name = 'ORG_ID'
              --and fpov.profile_option_value='11'
              --and fr.responsibility_name like '%U1%Order%Super%User%';
                and fr.responsibility_id = 51973;
                

No comments:

Post a Comment