oracle inventory tables flow.Item master table in oracle apps r12

Oracle inventory tables flow. Item master table in oracle apps r12

 

 

Query to get item details in oracle apps

mtl_category_sets_tl

 

In this table you will get the ITem Categories Set Name and its informations.

 

 

mtl_categories_b_kfv

 

In this table you will the Item Catrgories Key Flex Values.

 

 

mtl_categories_v

 

In this table you will the Item Category Name.

 

 

Subinventory table in oracle apps r12

 

mtl_secondary_inventories_fk_v

 

In this table , you will the get the Inventory Sub Inventories Informations. This is the complete Subinventory Table.

 

 

 mtl_item_locations_kfv

 

 In this table , you will get the Subinventory Locators Informations. This is the Complete Item Subinventory Locator Information table.

 

 

 mtl_item_templates

 

 In this table , you will get the Inventory Item Itemplates Informations. This template assign to the Items.

 

 

 mtl_system_items_b

 

 This is the complete Item master table in Oracle Apps.

 

 

 

  mtl_item_sub_defaults

 

  In this table , you will get the Subinventoty Informations which is assigned to the items. Here you will get the details of Item assigned to which sub-inventories.