SQL & PL/SQL

I need a Query for Inventory item Number, Inventory item description, Inventory item Category, Inventory Item type and approved supplier(if any), BOM Operation Sequence Number for each item in BOM. for this I wrote a query, but i am getting Duplicate item.

when I join MTL_SYSTEM_ITEMS_B, MTL_ITEM_CATEGORIES and MTL_CATEGORIES_B i am getting duplicate items.

any body can help to eliminate duplicate.

This is my query:
SELECT MC.SEGMENT1 MODEL
,MC.SEGMENT3 ITEM_GROUP
,MC.SEGMENT4 ITEM_TYPE
,BCB.OPERATION_SEQ_NUM OPERATION_NUM
,MSI.SEGMENT1 PART_NUMBER
,MSI.DESCRIPTION PART_NAME
,MSI.INVENTORY_ITEM_ID
,msi.organization_id
FROM BOM_BILL_OF_MATERIALS BBM
,bom_components_b bcb
,MTL_SYSTEM_ITEMS_B MSI
,MTL_ITEM_CATEGORIES MIC
,MTL_CATEGORIES_B MC
WHERE BBM.BILL_SEQUENCE_ID = BCB.BILL_SEQUENCE_ID
AND BCB.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND BBM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MIC.CATEGORY_ID = MC.CATEGORY_ID;

Thanks in advance.

Regards
Ravi