Query Rewrite - How to Avoid Multiple Left Outer Join

Hi,

We have a database, using Entity–attribute–value model. So, we are using automatic SQL Query generations, which generates a lot of Left Outer Join. Is there a better way to write this query ?

I tried pivot and max case, but i can't get the logic or syntax. Appreciate some help here.

SQL Query

========

SELECT I.ITEM_ID AS ITEM_ID,

       IP_NAME.PROPERTY_STRING AS ITEM_NAME,

       IP_ACTIVE.PROPERTY_STRING AS ACTIVE,

       IP_TYPE.PROPERTY_STRING AS TYPE,

       CL_TYPE.CODE_TEXT AS TYPE_TEXT,

       IL_ITEM_BORE.TO_ITEM_ID AS BORE_ID,

       NVL (IP_BORE_NAME.PROPERTY_STRING, 'Not defined') AS BORE