Set org context in R12
1. The SQL command to set the ORG_ID prior to running a script is:
SQL> exec mo_global.init('PN');
exec mo_global.set_policy_context('S','org_id');
The procedure mo_global.set_policy_context has two parameters
p_access_mode and p_org_id
p_access_mode
S ( In case you want your current session to work against single org_id)
M (In case you want your current session to work against multiple org_id )
p_org_id: only applicable if p_access_mode is passed value of "S"