Problem 7
SELECT O.Order_ID, O.Order_Date, C.Name Customer, L.Type, L.Cost, L.Quantity Qty, I.Name Item,     IT.Name Type
  FROM Orders O, Order_Lines L, Items I, Customers C,
       Item_Types IT
 WHERE O.Customer_ID = :B1
   AND L.Order_ID = O.Order_ID
   AND I.Item_ID(+) = L.Item_ID
   AND I.Org_ID(+) = :B2
   AND C.Customer_ID = O.Customer_ID
   AND I.Item_Type_ID = IT.Item_Type_ID;
•The inner join from I to IT discards the outer case of the outer join from L to I.
•The “(+)”s could be removed without changing the functional result, and this would be clearer, if this is the desired result.
•If you don’t want all inner joins, make I to IT outer.