Showing posts with label oracle apps R12 organization hierarachy. Show all posts
Showing posts with label oracle apps R12 organization hierarachy. Show all posts

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;