In this post we will see organization table list in Oracle Apps R12, multiple organization tables are available in Oracle R12, listed tables are described about their uses in Oracle Apps R12
Organization Table in Oracle Apps R12
HR_ORGANIZATION_UNITS: This table stores information about all the organizations (including inventory organizations) are available.
HR_ALL_ORGANIZATION_UNITS: This table stores definitions that identify business groups and organization units within a single business group
HR_OPERATING_UNITS: This table stores information about all the operating units are available in the system.
Inventory Organization Table in Oracle Apps R12
ORG_ORGANIZATION_DEFINITIONS: This is a view and depends on MTL_PARAMETERS table
Sub Inventory Table in Oracle Apps R12
MTL_SECONDARY_INVENTORIES: This table stores the sub inventory information.