Tuesday, February 4, 2014

FND_GLOBAL.APPS_INITIALIZE

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 

No comments:

Post a Comment