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