Oracle Organizations Tables

-- Oracle Organizations Tables

SELECT * FROM HR_LOCATIONS ;

SELECT * FROM HR_ORGANIZATION_UNITS ;

SELECT * FROM HR_ALL_ORGANIZATION_UNITS ;

SELECT * FROM HR_ORGANIZATION_INFORMATION ;

SELECT * FROM HR_LEGAL_ENTITIES ;

SELECT * FROM HR_OPERATING_UNITS ;

-- INVENTORY_ORGANIZATION

SELECT * FROM ORG_ORGANIZATION_DEFINITIONS ;

-- SUB-INVENTORY

SELECT * FROM MTL_SECONDARY_INVENTORIES ;