ORA-00904: "MSIK"."INVENTORY_ITEM_ID": invalid identifier 00904. 00000 - "%s: invalid identifier"

Hi,

We are getting the above error message when executing the SQL behind the View Object MaterialsVO.xml in EAM:

The issue is being raised both in the EBS EAM application and when running it straight in SQL. When I remove the second outer join it is working correctly so itlooks like some DB issue. Can anybody help?

SELECT msix.item_name,

       msix.description,

       msix.organization_id,

       msix.primary_uom_code,

       msix.inventory_item_id,

       msix.category_name,

       msix.category_description,

       msix.category_id,

       msix.list_price,

       msix.transactablity,

       msix.inv_direct_item_type,

       msix.item_cost,

       msix.cross_reference_type,