Friday, March 23, 2012

Copy F41021 from other Branch Plant


INSERT INTO testdta.F41021
(SELECT LIITM,'     2050405' ,LILOCN,LILOTN,LIPBIN,LIGLPT,LILOTS,LILRCJ,LIPQOH,LIPBCK,LIPREQ,LIQWBO,LIOT1P,LIOT2P,LIOT1A,LIHCOM,LIPCOM,LIFCOM,LIFUN1,LIQOWO,LIQTTR,LIQTIN,LIQONL,LIQTRI,LIQTRO,LINCDJ,LIQTY1,LIQTY2,LIURAB,LIURRF,LIURAT,LIURCD,LIJOBN,'C58_2B3',LIUPMJ,LIUSER,LITDAY,LIURDT,LIQTO1,LIQTO2,LIHCMS,LIPJCM,LIPJDM,LISCMS,LISIBW,LISOBW,LISQOH,LISQWO,LISREQ,LISWHC,LISWSC,LICHDF,LIWPDF,LICFGSID FROM testdta.F41021 WHERE  limcu = '     2050012' );

No comments:

Post a Comment