Query Returning Duplicate rows

Dear Friends,

Can you please advise the missing joins to this query as its returning me duplicate rows...

Select  MCIX.CUSTOMER_ITEM_NUMBER    CUSTOMER_ITEM_NUMBER from MTL_CUSTOMER_ITEM_XREFS_V

AND OOLV.INVENTORY_ITEM_ID   =MCIX.INVENTORY_ITEM_ID(+)

my friend points me in this direction.But iam unable to get a solution...Can you please help as its urgent.

I suspect you need to be joining to the MTL_CUSTOMER_ITEM_XREFS_V view using more than just the item ID. I would guess organization_id and customer_id would be needed.

I think the order line contains a reference to the customer item id although that could be wrong. You may also need to check for enabled\active flags and end-dates to ensure no duplicates are returned.