Select poli.crn, poli.line_num, p.ponum,c.name,
mtl.recnum from po p, po_line_items poli,
company c, mtl_tracker mtl
where p.recnum = poli.link2po and
c.recnum = p.link2vendor and 
mtl.recnum = poli.recnum and 
poli.crn ='' and 
p.type = 'Bought Out'


crn,partnum,custponum,custlino,scheule date,qty*
35-535,D522 73379 200 00,,,08/22/2018,121* 


crn,partnum,custponum,custpoli,scheduledate,qty*
35A-003,test8888,,,04/28/2018,6*
35A-003,test8888,,,03/28/2018,6*
35A-003,test8888,,,05/01/2018,6*
35A-003,test8888,,,05/15/2018,6*


crn,partnum,custponum,custpoli,scheduledate,qty*
18A-130,test8888,,,04/30/2018,6*
18A-130,test8888,,,03/30/2018,6*
18A-130,test8888,,,05/05/2018,6*
18A-130,test8888,,,05/20/2018,6*


crn,partnum,custponum,custpoli,scheduledate,qty*
35A-002,test8888,,,04/20/2018,6*
35A-002,test8888,,,03/15/2018,6*
35A-002,test8888,,,05/01/2018,6*
35A-002,test8888,,,05/10/2018,6*


crn,partnum,custponum,custpoli,scheduledate,qty*
18A-001,test8888,,,02/10/2018,6*


crn,partnum,custponum,custpoli,scheduledate,qty*
51A-054,test1,,,03/10/2018,100*
51A-027,test23,,,02/20/2018,100*
51A-059,test34,,,04/25/2018,100*
51A-049,test324,,,05/25/2018,100*
51A-042,test,,,06/25/2018,100*
51A-059,test3424,,,07/25/2018,100*
51A-038,test77988,,,08/25/2018,100*
51A-028,tes88,,,09/25/2018,100*
51A-046,tes88r3,,,03/25/2018,100*
51A-017,tedt777,,,05/25/2018,100*


 update mtl_tracker_li set link2delivery =183686 where crn = 'BACN10KE3B2CD';
 update mtl_tracker_li set link2delivery =183687 where crn = 'BACR15BA3AD4C';
 update mtl_tracker_li set link2delivery =183688 where crn = 'BACR15BA3AD5C';


  update mtl_tracker_li set link2delivery =183691 where crn = 'BACN10KE3B2CD';
 update mtl_tracker_li set link2delivery =183687 where crn = 'BACR15BA3AD4C';
 update mtl_tracker_li set link2delivery =183688 where crn = 'BACR15BA3AD5C';

 update delievry_sch set schedule_qty = 
  update mtl_tracker_li set link2delivery =183700 where crn = 'BACN10JN3CD';
 update mtl_tracker_li set link2delivery =183687 where crn = 'BACN10KE3B2CD';
 update mtl_tracker_li set link2delivery =183703 where crn = 'BACR15BA3AD5C';



 crn,partnum,custponum,custpoli,scheduledate,qty*
18-001,test8888,,,02/10/2018,6*