INSERT INTO TESTDTA.F41021 T3
(SELECT T2.LIITM,
T2.LIMCU,
'SF',
' ',
'S',
T2.LIGLPT,
' ',
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,0,
0,
T2.LIURRF,
T2.LIURAT,
T2.LIURCD,
T2.LIJOBN,
'SF_INS',
T2.LIUPMJ,
T2.LIUSER,
T2.LITDAY,
T2.LIURDT,
0,0,0,0,0,0,0,0,0,0,0,0,0,
T2.LICHDF,
T2.LIWPDF,
T2.LICFGSID
FROM TESTDTA.F41021 T2
WHERE T2.LIMCU = ' 2050012' AND T2.LIPBIN = 'P' AND NOT EXISTS (SELECT * FROM testdta.F41021 T1 WHERE T2.LIITM = T1.LIITM AND T2.LIMCU = T1.LIMCU AND T1.LILOCN = 'SF') AND ROWNUM <1000);