SELECT OOL.inventory_item_id 
FROM   oe_order_lines OOL, 
       mtl_system_items_b MSIB 
WHERE  OOL.top_model_line_id = :B4 
       AND OOL.header_id = :B3 
       AND MSIB.item_type IN ( :B2, :B1 ) 
       AND OOL.inventory_item_id = MSIB.inventory_item_id 
       AND OOL.ship_from_org_id = MSIB.organization_id 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.00          0          0          0           0
Execute  12166      0.72       0.79          0          0          0           0
Fetch    12178    153.73    5089.92     475806    4102075          0      499422
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    24345    154.46    5090.71     475806    4102075          0      499422

SQL> select 499422/12166 rows_per_call, 5090.71/12166 secs_per_call from dual;

ROWS_PER_CALL SECS_PER_CALL
------------- -------------
   41.0506329    .418437449

CREATE INDEX ... ON OE_ORDER_LINES_ALL ( top_model_line_id, header_id, inventory_item_id, ship_from_org_id ) ...