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);