Oracle EBS Items Details Query R12

Inventory Itemes Details Query Sample:

SELECT a.segment1 item_number , a.description item_desc ,msi.description name_other, a.organization_id ,mp.organization_code,a.item_type,inventory_item_status_code status,
,ick.concatenated_segments item_category ,a.inventory_item_flag  ,a.inventory_item_status_code,a.primary_uom_code ,a.primary_unit_of_measure,fa.concatenated_segments asset_category
FROM 
 mtl_system_items a
,mtl_categories_b_kfv ick
,mtl_category_sets_vl cs
,mtl_item_categories c
,mtl_parameters mp
,mtl_system_items_tl msi
,fa_categories_b_kfv fa
 where 1 =1 
 and fa.category_id (+)= a.asset_category_id
   and cs.structure_id = ick.structure_id 
  and ick.category_id = c.category_id

 and a.inventory_item_id = msi.inventory_item_id
 and a.inventory_item_id = c.inventory_item_id
 and a.organization_id = c.organization_id
and msi.language = US''
and msi.organization_id = a.organization_id  
 and a.organization_id = mp.organization_id ;


Hope this query help full .....