Wednesday, March 30, 2016

SQL-set context in toad

EXEC apps.mo_global.set_policy_context('S','83');
EXEC apps.mo_global.set_policy_context('S','141');


      -- to run from toad
      mo_global.init ('ONT');
      fnd_global.apps_initialize (user_id        => g_user_id,
                                  resp_id        => g_resp_id,
                                  resp_appl_id   => g_resp_appl_id);
      mo_global.set_policy_context ('S', 141);


    exec FND_GLOBAL.APPS_INITIALIZE(1130, 50850, 200);


  MO_GLOBAL.get_current_org_id,
                         FND_GLOBAL.CONC_REQUEST_ID,
                         SYSDATE,
                         FND_GLOBAL.USER_ID,
                         FND_GLOBAL.USER_ID,

select fnd_profile.value('ORG_ID') from dual;

FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id, fnd_global.resp_id, fnd_global.resp_appl_id);

select * from fnd_responsibility_vl where responsibility_name like 'CTY%' ;

select fnd_global.org_name from dual;

No comments: