SELECT   q.sup_ref_no, 
         q.qot_date, 
         q.mpr_no, 
         p.pty_name, 
         m.mpr_date, 
         j.proj_name, 
         j.proj_city, 
         q.item_code, 
         i.itm_description, 
         i.unit_measure, 
         q.itm_qty, 
         q.unit_price, 
         q.itm_dsc_perc, 
         q.itm_dsc_val, 
         q.itm_amt, 
         q.qot_dsc_perc, 
         q.qot_dsc_val, 
         q.qot_amt 
FROM     purchase_master..qotemst q, 
         purchase_master..partymst p, 
         purchase_master..itemmst i, 
         purchase_master..mprmst m, 
         emp_master..projectmst j 
WHERE    q.sup_ref_no = '103006' 
         AND p.pty_code = q.qot_sup_code 
         AND m.mpr_no = q.mpr_no 
         AND j.proj_code = m.proj_code 
         AND i.itm_code = q.item_code 
ORDER BY q.sup_ref_no