Wednesday, April 27, 2011

Oracle Apps R12 Queries for Organization Hierarchy

In Oracle Apps R12


select * from gl_ledgers_v;


Shows the 4 c, Currency, Chart of accounts, Calendar and Accounting method


select * from hr_legal_entities;


Shows legal entities and its associated business group


select * from hr_operating_units;


Shows operating units, business group, legal entity context and ledger


select * from hr_organization_information_v;


select * from mtl_parameters;