Posts

Showing posts from March, 2016

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 ;