Data Structure of Oracle Inventory

Data Structure of  Oracle Inventory

 

Org_organization_definitions

: Setup > Organizations > Parameters

This view contains basic information on all inventory organisations.

Some columns of interest includes :

·         Organization_code

·         Organization_name

·         Set_of_books_id (when you have more than one set of book, you’ll also need to link to gl_sets_of_books)

·         Inventory_enabled_flag

Mtl_secondary_inventories

: Setup > Organizations > Subinventories

This table stores all subinventory information for an inventory organisation.

Some columns of interest includes :

·         Secondary_inventory_name

·         Description

Mtl_material_transactions

: Transactions > Material Transactions (Inquiry)

This table stores all inventory transactions including cost updates.

Some columns of interest includes :

·         Transaction_quantity

·         Transaction_type_id

·         Transaction_source_type_id

·         Transaction_source_name

Mtl_transaction_accounts

: Transactions > Material Distributions (Inquiry)

This table stores the inventory accounting information.  There are two rows in this table for each transaction in mtl_material_transactions.

Some columns of interest includes :

·         Transaction_date

·         Gl_batch_id

·         Accounting_line_type

·         Base_transaction_value

Mtl_system_items

: Items > Master Items or Items > Organization Items

This table stores the item definition. An item must exist in an inventory organisation.

Your item number is stored in the columns segment1 to segment20 depending on your application configuration.  If you have configured your items to have to segments then you may be using segment1 and segment2

Some columns of interest includes :

·         Segment1 to segment20

·         Description

·         Invetory_item_flag

·         Purchasing_item_flag

·         Inventory_asset_flag

·         Stock_enabled_flag

·         Invoiceable_item_flag

·         Shippable_item_flag

·         So_transaction_flag

·         Mtl_transactions_enabled_flag

·         Primary_unit_of_measure

Mtl_onhand_quantities

: On-hand, Availability > On-hand Quantities

This table stores quantity on hand in a location for each item.

Some columns of interest includes :

·         Date_received

·         Transaction_quantity

·         Subinventory_code

Cst_item_costs

: Costs > Item Costs

This table stores the item cost information.  Note that there can be multiple costs per item and the actual cost is where the cost type is Frozen.

Some columns of interest includes :

·         Cost_type_id (link to cst_cost_types)

·         Item_cost

Oracle E-Business Suite Manufacturing & Supply Chain Management