Wednesday, December 27, 2017

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)

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete