select fnd.User_id ,
fresp.Responsibility_id,
fresp.Responsibility_Name,
fresp.Application_id
from fnd_user fnd
, fnd_responsibility_tl fresp
where fnd.user_name = 'OPERATIONS'
And fresp.responsibility_name like 'Vision%'
And fresp.Language = 'US' ;
fnd_global.APPS_INITIALIZE(user_id=>l_user_id,
resp_id=>l_resp_id,
resp_appl_id=>l_resp_appl_id);
l_user_id = FND user ID
l_resp_id = responsibility ID
l_resp_appl_id = responsibility application ID
fresp.Responsibility_id,
fresp.Responsibility_Name,
fresp.Application_id
from fnd_user fnd
, fnd_responsibility_tl fresp
where fnd.user_name = 'OPERATIONS'
And fresp.responsibility_name like 'Vision%'
And fresp.Language = 'US' ;
fnd_global.APPS_INITIALIZE(user_id=>l_user_id,
resp_id=>l_resp_id,
resp_appl_id=>l_resp_appl_id);
l_user_id = FND user ID
l_resp_id = responsibility ID
l_resp_appl_id = responsibility application ID
No comments:
Post a Comment