Item Category Details in Oracle Apps

Item Category Details Based on Item Wise:


SELECT msi.segment1 Item_Number,mc.segment1 Category
            FROM inv.mtl_system_items_b msi,
              inv.mtl_item_categories mic,
                 inv.mtl_categories_b mc,
                 inv.mtl_category_sets_b mcs,
                 inv.mtl_default_category_sets mdcs
           WHERE 1 = 1
             AND mic.inventory_item_id = msi.inventory_item_id
             AND mic.organization_id = msi.organization_id
             AND mic.category_id = mc.category_id
             AND mic.category_set_id = mcs.category_set_id
             AND mcs.category_set_id = mdcs.category_set_id
             AND msi.segment1='Item Number'
             AND msi.organization_id=Organization_id
             AND mdcs.functional_area_id = 1;