Query to get item catalog in oracle apps

Query to get item catalog in oracle apps

In this post , We will be discuss about the Query to get item catalog in oracle apps. Item Catalog is the concept in oracle inventory. Item catalog helps to group the inventory item in oracle apps , which share the common characteristics. This helps to identify the common types of inventory items in oracle apps. We do create the Item Catalog groups to divide the Item Master based on their characteristics in oracle apps.

Most Important Tables used by Query to get item catalog in oracle apps

1.Mtl_Item_Catalog_Groups

2.Mtl_Descriptive_Elements

3.Mtl_descr_element_values

4.mtl_system_items_b

Detail SQL Query to get item catalog in oracle apps

SELECT micg.segment1,micg.description,mde.element_name,mde.description element_description FROM apps.Mtl_Item_Catalog_Groups micg, apps.Mtl_Descriptive_Elements  mde
where micg.item_catalog_group_id=mde.item_catalog_group_id
order by 1

select msb.segment1 ITEM_CODE, MSB.DESCRIPTION ITEM_DESCRIPTION,MDEV.ELEMENT_SEQUENCE,MDEV.ELEMENT_NAME,MDEV.ELEMENT_VALUE from
apps.Mtl_descr_element_values mdev,apps.mtl_system_items_b msb
where mdev.inventory_item_id=msb.inventory_item_id
ORDER BY 1