R12 Multi Org Tables in Oracle Apps

Business Groups

select * from hrfv_business_groups

Set Of Books / Ledgers

select * from gl_ledgers

select * from gl_sets_of_books

Legal Entities

select * from xle_entity_profiles

Operating Units

select * from hr_operating_units

Organizations /Inventories

select * from org_organization_definitions

Sub- Inventories

select * from mtl_secondary_inventories

select * from mtl_item_sub_inventories

Locators

select * from mtl_item_locations

Initializing Global Variables 

g_user_id                 NUMBER   := fnd_global.user_id;

g_reps_id                 NUMBER   := fnd_global.resp_id;

g_reps_appl_id            NUMBER   := fnd_global.resp_appl_id;

g_user_name               VARCHAR2 := fnd_global.user_name;

g_resp_name               VARCHAR2 := fnd_global.resp_name;

g_application_name        NUMBER   := fnd_global.application_name;

g_application_short_name  VARCHAR2 := fnd_global.application_short_name;

g_login_id                NUMBER   := fnd_global.login_id;

g_conc_login_id           NUMBER   := fnd_global.conc_login_id;

g_conc_request_id         NUMBER   := fnd_global.conc_request_id;

g_org_id                  NUMBER   := fnd_global.org_id;

g_org_name                VARCHAR2 := fnd_global.org_name;

fnd_global.APPS_INITIALIZE(

    user_id IN NUMBER,

    resp_id IN NUMBER,

    resp_appl_id IN NUMBER,

    security_group_id IN NUMBER DEFAULT 0,

    server_id IN NUMBER DEFAULT -1);

mo_global.set_policy_context(p_access_mode VARCHAR2, -- 'S','M'

                             p_org_id      NUMBER);