create or replace view stock_trns as
select
       s.TRID,      (Transfer ID)
       s.TRDATE,    (Date)
       s.TRNO,      (Transfer #)
       s.ITID,      (Item ID Reff Items Table that name is v_items vi)  
       vi.item_name,(Transferred Item Name Reff Item Table)
       s.FWID,      (From Warehouse ID) 
       w.wtitle,    (Warehouse name for FWID Reff Warehouse Table)
       s.QTY,       (Transferred Item Quantity)  
       s.TWID,      (To Warehouse ID)
       s.TRREMARKS 

from stock_transfer s, v_items vi, warehouse w
where s.itid = vi.itid and s.fwid = w.wid and s.twid = w.wid;

select ...
  wt.wtitle wtitle_to,
  wf.wtitle wtitle_from
from ..., warehouse wf, warehouse wt
where ...