Query to get item type in oracle apps

Query to get item type in oracle apps

In this post , we will be discuss about the Query to get item type in oracle apps. This query will helps to find the inventory item type in oracle apps. We have different types of Inventory Items in oracle apps , this query will help to get these item type inflammations. Item Type value do stores in the Inventory Lookups in oracle apps. This Item type lookup Type name is 'ITEM_TYPE'. Here below is the detail sql Query to get item type in oracle apps.

Most Important Tables used by query to get item type in oracle apps

1.mtl_system_items_b 

2.fnd_lookup_values

Detail SQL Query to get item type in oracle apps

select msb.organization_id,msb.segment1 ITEM_CODE,
 MSB.DESCRIPTION ITEM_DESCRIPTION,
                   item_type,
                   flv.meaning item_type_meaning
         from apps.mtl_system_items_b msb,
                   apps.fnd_lookup_values flv
       where lookup_type ='ITEM_TYPE'
           and msb.item_type=flv.lookup_code
           and msb.organization_id=:P_INV_ORG_ID
           ORDER BY 1

Query to get item type in oracle apps