Organization Table In Oracle Apps R12

 Here are tables for organization 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_ORGANIZATION_INFORMATION

HR_LOCATIONS

HR_LEGAL_ENTITIES

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.