Performance issue.

Hi Gurus,

Am very new to performance tuning. Can u tell me how can I improve performance of below query.

SQL

SELECT OOH.order_number,

       OEL.line_id,

       MTL.header_id,

       MTL.to_subinventory_code,

       MTL.from_subinventory_code,

       Nvl(MTL.from_locator_id, 7777777) FROM_LOCATOR_ID,

       Nvl(MTL.to_locator_id, 9999999)   TO_LOCATOR_ID,

       OEL.item_type_code

FROM   mtl_txn_request_lines MTL,

       oe_order_lines_all OEL,

       oe_order_headers_all OOH,

       mtl_parameters MP,

       oe_transaction_types_tl OTT

WHERE  ( MTL.last_update_date BETWEEN SYSDATE - 15 AND SYSDATE + 1 )

       AND MTL.txn_source_line_id = OEL.line_id