Improve SQL performance

I have a sql to referring unit price by oe_order_lines_all.line_id as below.Would you share the step or how is your thought to tune this sql?

I try to add index in oe_transaction_types_tl for "name" column. It reduce CPU cost a bit. But I cant change the sql use index instead of full table scan in oe_order_lines_all and oe_order_headers_all table.
Thank in advance to share your knowledge with others.

select oola.org_id , ooha.ordered_date, oola.ship_from_org_id, oola.ship_to_org_id