1 WITH a AS (
 2 SELECT xmdkdocno,xmdlseq,xmdl001,xmdl002
 3 FROM xmdk_t
 4 LEFT JOIN xmdl_t ON xmdkent=xmdlent AND xmdkdocno=xmdldocno
 5 WHERE xmdkent=60 AND xmdksite='D' AND xmdkstus='Y' AND xmdk000='4' AND xmdk007='A0114010'
 6 )
 7 ,b AS (
 8 SELECT a.xmdkdocno,a.xmdlseq,xmdg.xmdgdocno,xmdh.xmdhseq
 9 FROM a
10 LEFT JOIN xmdl_t xmdl ON xmdl.xmdldocno=a.xmdl001 AND xmdl.xmdlseq=a.xmdl002
11 LEFT JOIN xmdh_t xmdh ON xmdh.xmdhdocno=xmdl.xmdl001 AND xmdh.xmdhseq=xmdl.xmdl002
12 LEFT JOIN xmdg_t xmdg ON xmdg.xmdgdocno=xmdh.xmdhdocno 
13 WHERE xmdgstus='Y'
14 ),
15 c AS (
16 SELECT 'N' sel,b.xmdkdocno,b.xmdlseq,x1.xmab006,x1.xmab007,x1.xmab009,x1.xmab010,x1.xmab012,x1.xmab013,x1.xmab011,
17        b.xmdgdocno,b.xmdhseq,x2.xmab009 xmab009_2,x2.xmab010 xmab010_2,x2.xmab011 xmab011_2
18 FROM b
19 LEFT JOIN xmab_t x1 ON x1.xmab003=b.xmdkdocno AND x1.xmab004=b.xmdlseq
20 LEFT JOIN xmab_t x2 ON x2.xmab003=b.xmdgdocno AND x2.xmab004=b.xmdhseq
21 WHERE x2.xmab009-x2.xmab010>0
22 ORDER BY b.xmdkdocno DESC,b.xmdlseq
23 )
24 INSERT INTO cxmq141_temp
25 SELECT sel,xmdkdocno,xmdlseq,xmab006,xmab007,xmab009,xmab010,xmab012,xmab013,xmab011,xmdgdocno,xmdhseq,xmab009_2,xmab010_2,xmab011_2 FROM c

CREATE TEMP TABLE cxmq141_temp
   (
      sel       LIKE type_t.chr1, 
   xmdkdocno    LIKE xmdk_t.xmdkdocno, 
   xmdlseq      LIKE xmdl_t.xmdlseq, 
   xmab006      LIKE xmab_t.xmab006, 
   xmab007      LIKE xmab_t.xmab007, 
   xmab009      LIKE xmab_t.xmab009, 
   xmab010      LIKE xmab_t.xmab010, 
   xmab012      LIKE xmab_t.xmab012, 
   xmab013      LIKE xmab_t.xmab013, 
   xmab011      LIKE xmab_t.xmab011, 
   xmdgdocno    LIKE xmdg_t.xmdgdocno, 
   xmdhseq      LIKE xmdh_t.xmdhseq, 
   xmab009_2    LIKE xmab_t.xmab009, 
   xmab010_2    LIKE xmab_t.xmab010, 
   xmab011_2    LIKE xmab_t.xmab011
    );