How to initialize apps
fnd_global.APPS_INITIALIZE(user_id=>0,--l_user_id,
resp_id=>20707,--l_resp_id,
resp_appl_id=>201);--l_resp_appl_id);
select fnd.user_id ,
fresp.responsibility_id,
fresp.application_id
from fnd_user fnd
, fnd_responsibility_tl fresp
where fnd.user_name = 'SYSADMIN'
and fresp.responsibility_name = 'Purchasing Super User';
No comments:
Post a Comment