Oracle Inventory
Main Tables involved in Oracle Inventory are
HR_LOCATIONS
Stores information about organization locations. Address, Org_id, ship_to /
bill_to site, receiving site, etc LOCATION_ID is the primary key on this
table. This table is accessed by forms or reports from the following modules;
HR, INV, PO/REC.
(See Oracle Inventory Technical or Oracle HR Technical Reference Manual for more detail)
HR_ORGANIZATION_INFORMATION
Stores the information on all organizations defined in the system. It also
stores most of the organization classification specific information. The table
is populated through the Define Organization form (PERWSDOR). Each organization
defined will have 1 row for the organization and 1 row for each organization
classification defined on the form. ORG_INFORMATION_ID is the primary key on
this table.
(See Oracle Inventory Technical or Oracle HR Technical Reference Manual for more detail)
HR_ORGANIZATION_UNITS
Stores generic information about the organizations. This is an excellent place
to go if you need to see the relationship between org id and Business group id
when troubleshooting a multi-org problem. ORGANIZATION_ID is the primary key
for this table. BUSINESS_GROUP_ID is a foreign key. This table is used by a
variety of org setup and item setup forms.
(See Oracle Inventory Technical or Oracle HR Technical Reference Manual for more detail)
MTL_PARAMETERS
Stores the set of general default options like GL accounts, locator, lot and
serial number controls, costing method, inter-org options, costing org and item
master, etc This table is populated by the org parameters form INVSDOIO. It is
accessed by a wide variety of forms, reports, user exits, and concurrent
programs throughout the manufacturing modules. ORGANIZATION_ID is the primary
key. This is the most heavily used Organization table in the manufacturing
products.
(See Oracle Inventory Technical Reference Manual for more detail)
RCV_PARAMETERS
Stores receiving options for each organization that is setup to receive items.
There is 1 row for each receiving organization. This table is populated by the
org parameters form, receiving options, or from PO setup receiving options.
(See Oracle Inventory Technical or Oracle Purchasing Technical Reference Manual for more detail)
Read Previous post on Inventory from below links
Part 1
Part 2
Part 3
Part 4:
For more information follow #ebiztechnics
