Query of Business Structure

select * from per_business_groups
where business_group_id= 101

select * from hr_operating_units
where organization_id = 112 -- (ORG_ID)

select * from org_organization_definitions
where OPERATING_UNIT = 112  -- Organization_id exists in INV tables

select * from hr_locations
where location_id = 142

select * from mtl_system_items_b
where ORGANIZATION_ID = 133 -- (Organization id of org_organization_definitions table)