ORA-00600: internal error code, arguments: [kghfrh:ds], [0x4390D6BC0]

我来答

2020-03-18

Hla: 1
*** 2020-03-18 12:40:36.688
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kghfrh:ds], [0x4390D6BC0], [], [], [], [], [], []
Current SQL statement for this session:
select (case
when (t_gg_sj_goods.lockflag is not null and
t_gg_sj_goods.lockflag <> ‘0’) then
(case
when t_gg_sj_goods.locked_object is not null then
t_gg_sj_goods.locked_object
else
‘¿â´æËø¶¨’
end)
when
(select to_char(count(1))
from t_tm_stock_status s
where t_gg_sj_goods.goodsid = s.goods_id
and s.status != 0)=0 then ‘Î´Ëø¶¨’ else ‘ÒÑËø¶¨’
end) TMSTATUS,
(select case when max(PRINTFLAG)=0 then ‘Î´´òÓ¡’ else ‘ÒÑ´òÓ¡’ end PRINTFLAG from t_zy_jg_procarticledtl where t_zy_jg_procarticledtl.procarticledtlid = t_gg_sj_goods.goodsid and t_zy_jg_procarticledtl.deptid = t_gg_sj_goods.deptid ) PRINTFLAG,
(select MAX(T2.SYS_NAME) from t_tm_sys_info t2 where t2.sys_id = (select max(sys_id) from t_tm_stock_status s where t_gg_sj_goods.goodsid=s.goods_id and s.status!=0)) LOCKNAME,
case when (select count(1) from t_gu_gubpdetail p where t_gg_sj_goods.goodsid=p.goodsid and t_gg_sj_goods.deptid=p.deptid and p.gustate=‘10’)=0 then ‘Î´ÖÊÑº’ else ‘ÒÑÖÊÑº’ end ZYSTATUS,t_gg_sj_goods.*,(select x.ownername from t_gg_sj_customer x where x.deptid like substr(t_gg_sj_goods.deptid, 1, length(t_gg_sj_goods.deptid) - 2) || ‘%’ and x.ownerno = t_gg_sj_goods.firstinownerid) FIRSTINOWNERNAME,
(select case when l.gubillid like ‘ZY%’ then ‘ÊÖ¹¤ÖÊÑº’ else
(select f.sys_name from wmsdba.t_tm_sys_info f where l.gubillid = f.sys_id) end
from wmsdba.t_gu_gubpdetail l where l.goodsid=T_GG_SJ_Goods.goodsid and L.deptid=T_GG_SJ_Goods.deptid and l.gustate=‘10’ and rownum=1) ZYR from t_gg_sj_goods WHERE DeptID = :DeptID AND (PackNum LIKE ‘H205212581%’ ) AND 1 = :PackNum AND rownum <= :numsrow AND R_RECORD_IS_DELETED = :R_RECORD_IS_DELETED
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)

ksedst()+31 7FFF606FEAE0 ? 7FFF606FEB40 ?
7FFF606FEA80 ? 000000000 ?
ksedmp()+610 7FFF606FEAE0 ? 7FFF606FEB40 ?
7FFF606FEA80 ? 000000000 ?
ksfdmp()+21 7FFF606FEAE0 ? 7FFF606FEB40 ?
7FFF606FEA80 ? 000000000 ?
kgerinv()+161 7FFF606FEAE0 ? 7FFF606FEB40 ?
7FFF606FEA80 ? 000000000 ?
kgesinv()+33 7FFF606FEB40 ? 7FFF606FEA80 ?
000000000 ? 000000000 ?
kgesin()+143 7FFF606FEB40 ? 7FFF606FEA80 ?
000000000 ? 000000000 ?
kghnerror()+342 7FFF606FEB40 ? 7FFF606FEA80 ?
000000002 ? 4390D6BC0 ?
kghfrh_internal()+2 call 076 000000002 ? 4390D6BC0 ?
kghfrh()+11 000000000 ? 4390D6BC0 ?
000000002 ? 4390D6BC0 ?
kksFreeHeapGetMutex call ()+546 000000002 ? 4390D6BC0 ?
kksHeapFreeCbk()+55 call () 000000002 ? 4390D6BC0 ?
kghfrx()+42 42B603220 ? 00000000A ?
000000002 ? 4390D6BC0 ?
kghfrunp()+2456 42B603220 ? 00000000A ?
000000002 ? 4390D6BC0 ?
kghfnd()+1389 000001000 ? 060041F18 ?
060042080 ? 4390D6BC0 ?
kghalo()+587 060040828 ? 0600225C8 ?
000001000 ? 000000000 ?
kghgex()+606 000000FE8 ? 000000FE8 ?
000001000 ? 000001000 ?
kghalf()+521 42B7783D8 ? 000002000 ?
42B778424 ? 000000000 ?
kghalp()+3013 000000068 ? 000000000 ?
000000000 ? 00556BB10 ?
qkxrMemAlloc()+43 call 000000068 ? 000000000 ?
000000000 ? 00556BB10 ?
qkexrInitOpn()+76 call 000000000 ? 000000000 ?
000000000 ? 00556BB10 ?
qkexrXformOpn_Laz() call +49 7F692A033070 ? 00556BB10 ?
qkexrXformOpn()+114 call 6 7F692A033070 ? 00556BB10 ?
qkexrXformOpnArray( call )+152 7F692A033070 ? 00556BB10 ?
qkxrPXformQbc()+733 call ) 7F692A033070 ? 00556BB10 ?
qkxrDo()+141 000000000 ? 000000010 ?
7F692A033070 ? 00556BB10 ?
qkaTraverseQknDesce call ndents()+2179 7F692A033070 ? 00556BB10 ?
qkaTraverseQknDesce call ndents()+1960 000000000 ? 00556BB10 ?
qkaTraverseQkn()+21 call 1 000000000 ? 00556BB10 ?
qkadrv2Post()+586 call 00556BB10 ? 000000000 ?
000000000 ? 00556BB10 ?
qkadrv2()+151 00556BB10 ? 000000000 ?
000000000 ? 00556BB10 ?
opitca()+1900 00556BB10 ? 000000000 ?
000000000 ? 00556BB10 ?
kksSetBindType()+72 call 44 000000000 ? 00556BB10 ?
kksfbc()+10834 7FFF60702110 ? 000000102 ?
000000001 ? 000000000 ?
opiexe()+1884 000000102 ? 000000000 ?
000000000 ? 7FFF60702E10 ?
kpoal8()+2273 7FFF60703310 ? 000000053 ?
000000000 ? 7FFF60702E10 ?
opiodr()+984 7FFF607061F0 ? 000000053 ?
000000001 ? 7FFF60702E10 ?
ttcpip()+1012 7FFF607061F0 ? 000000000 ?
0059C09D0 ? 7FFF60702E10 ?
opitsk()+1322 7FFF607061F0 ? 000000000 ?
7FFF60705CE8 ? 7FFF60706358 ?
opiino()+1026 7FFF607061F0 ? 000000001 ?
000000000 ? 74C5AF200000001 ?
opiodr()+984 7FFF607073B8 ? 000000000 ?
000000000 ? 74C5AF200000001 ?
opidrv()+547 7FFF607073B8 ? 000000000 ?
0059C0480 ? 74C5AF200000001 ?
sou2o()+114 7FFF607073B8 ? 000000000 ?
0059C0480 ? 74C5AF200000001 ?
opimai_real()+163 call 000000004 ? 7FFF607073B8 ?
0059C0480 ? 74C5AF200000001 ?
main()+116 000000004 ? 7FFF607073B8 ?
0059C0480 ? 74C5AF200000001 ?
__libc_start_main() call +253 0059C0480 ? 74C5AF200000001 ?
_start()+41 7FFF60707578 ? 000000000 ?
0059C0480 ? 74C5AF200000001 ? call ksedst1() 000000000 ? 000000001 ?
call ksedst() 000000000 ? 000000001 ?
call ksedmp() 000000003 ? 000000001 ?
call ksfdmp() 000000003 ? 000000001 ?
call kgerinv() 006896700 ? 0074B4B80 ?
call kgesinv() 006896700 ? 0074B4B80 ?
call kgesin() 006896700 ? 0074B4B80 ?
kghnerror() 006896700 ? 42B603318 ?
005AE1F20 ? 4390D6BC0 ?
call kghfrh_internal() 006896700 ? 42B603318 ?
kghfrh() 006896700 ? 42B603318 ?
000000000 ? 4390D6BC0 ?
kksFreeHeapGetMutex 006896700 ? 42B6032A0 ?
000000000 ? 00000000A ?
call kksHeapFreeCbk() 006896700 ? 4390D6BC0 ?
call kghfrx() 006896700 ? 4390D6BC0 ?
call kghfrunp() 006896700 ? 060040828 ?
call kghfnd() 006896700 ? 000000018 ?
call kghalo() 000000000 ? 060040828 ?
call kghgex() 006896700 ? 000000000 ?
call kghalf() 006896700 ? 42B7783D8 ?
kghalp() 006896700 ? 42B7783D8 ?
qkxrMemAlloc() 000000068 ? 000000000 ?
qkexrInitOpn() 7F692A035680 ? 000000068 ?
000000000 ? 000000010 ?
qkexrXformOpn_Laz() 7F692A035680 ? 7F692A033070 ?
000000000 ? 000000010 ?
qkexrXformOpn() 7F692A035680 ? 7F692A033070 ?
000000000 ? 000000010 ?
qkexrXformOpnArray( 442B51000 ? 7F692A033100 ?
000000000 ? 000000010 ?
call qkxrPXformQbc() 000000001 ? 000000000 ?
qkxrDo() 7F692A035680 ? 001874824 ?
7F692A033F20 ? 000000010 ?
qkaTraverseQknDesce 7F692A033F20 ? 000000001 ?
ndents() 000000001 ? 000000000 ?
qkaTraverseQknDesce 7F692A0374D8 ? 7F69292B8138 ?
ndents() 000000001 ? 000000000 ?
qkaTraverseQkn() 7F69292B8138 ? 000000001 ?
call qkadrv2Post() 000000000 ? 000000001 ?
call qkadrv2() 000000001 ? 000000001 ?
opitca() 7F6929BAE138 ? 43EC216F8 ?
00556BB10 ? 000000000 ?
call kksSetBindType() 7FFF607021A8 ? 7F6929BAE138 ?
call kksfbc() 7F6929BAE138 ? 000000003 ?
call opiexe() 000000049 ? 000000003 ?
call kpoal8() 00000005E ? 000000017 ?
call opiodr() 00000005E ? 000000017 ?
call ttcpip() 00689E3D0 ? 000000001 ?
call opitsk() 000000003 ? 000000000 ?
call opiino() 00000003C ? 000000004 ?
call opiodr() 00000003C ? 000000004 ?
call opidrv() 00000003C ? 000000004 ?
sou2o() 7FFF60707390 ? 00000003C ?
call opimai_real() 000000002 ? 7FFF60707420 ?
main() 000000002 ? 7FFF60707420 ?
000000004 ? 7FFF607073B8 ?
call __libc_start_main() 0007230B4 ? 000000002 ?

--------------------- Binary Stack Dump ---------------------

========== FRAME [1] (ksedst()+31 -> ksedst1()) ==========
RDI 0000000000000000 RSI 0000000000000001 RDX 00007FFF606FEAE0
RCX 00007FFF606FEB40 R8 00007FFF606FEA80 R9 0000000000000000
RAX 00007FFF606FBF30 RBX 0000000000000000 RBP 00007FFF606FF5B0
R10 00007F692933D770 R11 00007FFF606FDF38 R12 0000000006896700
R13 00000000074B4B80 R14 00000000052FB5C0 R15 00000004390D6BC0
RSP 00007FFF606FF5B0 RIP 0000000000763249
Dump of memory from 0x00007FFF606FA4D0 to 0x00007FFF606FA8D0

还有一个trace
*** 2020-03-18 12:40:39.326
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kghfrh:ds], [0x4390D6BC0], [], [], [], [], [], []
Current SQL statement for this session:
SELECT ROWNUM,SYSDATE PRINTDATE,T.DEPTID,M.prodstoveno M_PRODSTOVENO,a.classgroup A_CLASSGROUP,
D.DEPTNAME,

(select max(e.ownername) from t_gg_sj_customer e where m.firstinownerid=e.ownerno and (case when m.deptid like ‘Z%’ then substr(m.deptid,1,4) else substr(m.deptid,1,2) end) = (case when e.deptid like ‘Z%’ then substr(e.deptid,1,4) else substr(e.deptid,1,2) end))firstinownername,
(select max(e.ownershort) from t_gg_sj_customer e where t.PROCESSDEPT=e.ownerno and (case when t.deptid like ‘Z%’ then substr(t.deptid,1,4) else substr(t.deptid,1,2) end) = (case when e.deptid like ‘Z%’ then substr(e.deptid,1,4) else substr(e.deptid,1,2) end)) OWNERSHORT,
(select max(d.ownershort) from t_gg_sj_customer d where t.processcustomno=d.ownerno and (case when t.deptid like ‘Z%’ then substr(t.deptid,1,4) else substr(t.deptid,1,2) end) = (case when d.deptid like ‘Z%’ then substr(d.deptid,1,4) else substr(d.deptid,1,2) end)) jianchen,
(
select sum(should_sum) from wmsdba.t_zy_js_settlement where deptid = T.deptid and biz_id = T.PROCESSID
) should_sum,
(select max(t_zy_js_settlementdetail.countunit) from t_zy_js_settlementdetail where t.deptid=t_zy_js_settlementdetail.deptid and t.processid=t_zy_js_settlementdetail.businessno and t_zy_js_settlementdetail.feetypename=‘¼Ó¹¤·Ñ’)JGDJ,
T.jgmessage,
T.PROCESSID,
T.PROCESSCUSTOMNAME,
T.PROCESSDEPT,
T.PROCESSDEPTNAME,
T.PROCESSMOLDNAME,
T.PLANENDDATE,
T.MENO,
T.OUTCARBILLEMPNAME CREATEUSER,
T.PACKTYPENAME,
T.WOODTYPENAME,
T.STRAPTYPENAME,
T.PACKTYPENAME||’ ‘||T.WOODTYPENAME||’ ‘||T.STRAPTYPENAME THREE,
T.PROCESSPRECISION,
T.CHANXIAN,
T.OUTCARBILLTIME,
T.ORDERINFO,
T.CUSTOMERID,
T.CBXJGTYPE,
T.CUSTOMERID,
T.USERNAME,
T.preweightsum,
substr(t.specialmemo,1,instr(t.specialmemo,’|’,1,1)-1) HDGC,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,1)+1,(instr(t.specialmemo,’|’,1,2)-instr(t.specialmemo,’|’,1,1)-1)) KDGC,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,2)+1,(instr(t.specialmemo,’|’,1,3)-instr(t.specialmemo,’|’,1,2)-1)) CDGC,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,3)+1,(instr(t.specialmemo,’|’,1,4)-instr(t.specialmemo,’|’,1,3)-1)) CPNJ,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,4)+1,(instr(t.specialmemo,’|’,1,5)-instr(t.specialmemo,’|’,1,4)-1)) DJX,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,5)+1,(instr(t.specialmemo,’|’,1,6)-instr(t.specialmemo,’|’,1,5)-1)) BMYQ,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,6)+1,(instr(t.specialmemo,’|’,1,7)-instr(t.specialmemo,’|’,1,6)-1)) PZD,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,7)+1,(instr(t.specialmemo,’|’,1,8)-instr(t.specialmemo,’|’,1,7)-1)) MC,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,8)+1,(instr(t.specialmemo,’|’,1,9)-instr(t.specialmemo,’|’,1,8)-1)) LDW,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,9)+1,(instr(t.specialmemo,’|’,1,10)-instr(t.specialmemo,’|’,1,9)-1)) SFKJJ,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,10)+1,(instr(t.specialmemo,’|’,1,11)-instr(t.specialmemo,’|’,1,10)-1)) LXDH,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,11)+1,length(t.specialmemo)) BZTSYQ,

               DECODE(T.PROCESSMOLDNAME,
                      '·Ö¾í',
                      ROUND(A.NETWEIGHT * 1000 * 1000 / 7.85 /
                            DECODE(A.GRADENUMWIDTH, 0, 1, A.GRADENUMWIDTH) /
                            DECODE(A.GRADENUMTHICK, 0, 1, A.GRADENUMTHICK),
                            2),
                      '×Ý¼ô',
                      ROUND(A.NETWEIGHT * 1000 * 1000 / 7.85 /
                            DECODE(A.GRADENUMWIDTH, 0, 1, A.GRADENUMWIDTH) /
                            DECODE(A.GRADENUMTHICK, 0, 1, A.GRADENUMTHICK),
                            2),
                      '×ÝÇÐ',
                      ROUND(A.NETWEIGHT * 1000 * 1000 / 7.85 /
                            DECODE(A.GRADENUMWIDTH, 0, 1, A.GRADENUMWIDTH) /
                            DECODE(A.GRADENUMTHICK, 0, 1, A.GRADENUMTHICK),
                            2),
                      0) LENGTH, 
               M.KINDNAME     M_KINDNAME,
               (SELECT MAX(M.KINDNAME)
                  FROM T_ZY_JG_PROCMATERIALDTL M2
                 WHERE M2.DEPTID = T.DEPTID
                   AND M2.PROCESSID = 'Z20820030368') MT_KINDNAME,
               M.GRADENUM     M_GRADENUM,
               M.MANAGENO     M_MANAGENO,
               M.PACKNUM      M_PACKNUM,
               M.SHEETNUM     M_SHEETNUM,
               M.NETWEIGHT    M_NETWEIGHT,
               (SELECT SUM(M1.NETWEIGHT) NETWEIGHT
                  FROM T_ZY_JG_PROCMATERIALDTL M1
                 WHERE M1.DEPTID = T.DEPTID
                   AND M1.PROCESSID = 'Z20820030368') MT_NETWEIGHT,
               M.POUNDWEIGHT  M_POUNDWEIGHT,
               M.SHOPSIGNNAME M_SHOPSIGNNAME,
               M.GOODSLOCID   M_GOODSLOCID,
               M.GOODSOWNERPACKNO M_GOODSOWNERPACKNO,    
               M.PRODAREANAME M_PRODAREANAME, 
               M.HANDNO M_HANDNO,
               M.SAVENO M_SAVENO,
               C.OWNERSHORT C_OWNERSHORT,   
               C.OWNERNAMECUT C_OWNERNAMECUT,
               C.LINKMAN C_LINKMAN,
               A.PACKNUM   A_PACKNUM,
               L.NETWEIGHT A_NETWEIGHT, 
               L.SHEETNUM L_SHEETNUM,
               L.GRADENUM L_GRADENUM,
               (SELECT SUM(A1.NETWEIGHT) NETWEIGHT
                  FROM T_ZY_JG_PROCARTICLEDTL A1
                 WHERE A1.DEPTID = T.DEPTID
                   AND A1.PROCESSID = 'Z20820030368') AT_NETWEIGHT,
               (SELECT TO_CHAR(Count(*)) FROM (SELECT gradenum
                  FROM T_ZY_JG_PROCARTICLEDTL A1
                 WHERE
                   A1.PROCESSID = 'Z20820030368' group by gradenum)) SHOW_GRADENUM,
                   (case when ASCIISTR(A.GRADENUM) LIKE '%\%' then A.Netweight when A.GRADENUM like '%C%' then A.Netweight else (A.gradenumthick*(A.gradenumwidth/1000)*(A.gradenumlength/1000)*1*0.00785) end) singlenetweight,
               A.GRADENUM  A_GRADENUM,

(case when T.PROCESSMOLDNAME =’¿ªÆ½’ then (select replace(wm_concat(distinct gradenum),’,’,’ , ‘) from T_ZY_JG_PROCARTICLEDTL where PROCESSID=‘Z20820030368’ and goodstypename =‘¼Ó¹¤³ÉÆ·’)
else (select replace(wm_concat(distinct gradenum),’,’,’ , ') from T_ZY_JG_PROCARTICLEDTL where PROCESSID=‘Z20820030368’) end ) as BOGRADENUM,
A.SHEETNUM A_SHEETNUM,
A.NETWEIGHT NEW_NETWEIGHT,
A.GROSSWEIGHT A_GROSSWEIGHT,
A.ORDERBY A_ORDERBY,

               A.ArticleMemo1 A_ARTICLEMEMO1,A.ARTICLEMEMO4 A_ARTICLEMEMO4,
               A.PRODAREANAME A_PRODAREANAME,A.KINDNAME A_KINDNAME,round(A.NETWEIGHT/DECODE(A.SHEETNUM,0,1,A.SHEETNUM),4) SINGLENETWEIGHT,A.DRAWNO A_DRAWNO,A.PACKTYPENAME A_PACKTYPENAME,
               M.PLY M_PLY,A.WOODTYPENAME A_WOODTYPENAME,A.SHOPSIGNNAME A_SHOPSIGNNAME,A.GOODSTYPENAME A_GOODSTYPENAME,A.GOODSLOCID A_GOODSLOCID,A.QUALITYMEMO,M.QUALITYMEMO AS M_QUALITYMEMO,M.MEMO M_MEMO,
               (SELECT SHIPNO FROM t_zy_rk_inbilldetail goods WHERE m.deptid=goods.deptid and m.goodsid=goods.goodsid) SHIPNO,
                T.DOWNORDERTIME
              ,(SELECT MEMO FROM t_zy_rk_inbilldetail goods WHERE m.deptid=goods.deptid and m.goodsid=goods.goodsid) INMEMO,
               (SELECT FIRSTINDATE FROM t_zy_rk_inbilldetail goods WHERE m.deptid=goods.deptid and m.goodsid=goods.goodsid) INFIRSTINDATE,T.CHENGPINGNEIJING
                ,A.HANDNO A_HANDNO/*¼Ó¹¤µ¥×Ô¶¨Òå´òÓ¡Êý¾ÝÔ´ÖÐÔö¼Ó³ÉÆ·ÊÖºÅÐÅÏ¢(A_HANDNO)(²Î¿¼ÐèÇóºÅWMSXQ-3966) add by xijunwei 20180827*/
                ,A.SAVENO A_SAVENO
              ,A.Memo A_MEMO
    ,case when  t.ftprocessid is null  then t.processid
     else  t.ftprocessid end ftprocessid,
   case when t.lvprocessid is null then t.processid
     else  t.lvprocessid end lvprocessid
          FROM T_ZY_JG_PROCESS T
          
          left join T_COMMON_DEPT D ON T.DEPTID = D.DEPTID
          left join T_ZY_JG_PROCMATERIALDTL M on T.PROCESSID = M.PROCESSID
          left join (Select PROCESSID,PROCARTICLEDTLID,PROCMATERIALDTLID,sum(NETWEIGHT) NETWEIGHT,sum(SHEETNUM) SHEETNUM ,GRADENUM From T_ZY_JG_PROCLINK 
          Where PROCESSID = 'Z20820030368' Group by PROCESSID,PROCARTICLEDTLID,PROCMATERIALDTLID,GRADENUM) L on T.PROCESSID = L.PROCESSID 
          left join T_ZY_JG_PROCARTICLEDTL A on T.PROCESSID = A.PROCESSID
          left join T_GG_SJ_CUSTOMER C ON (case when T.DEPTID like 'Z%' then substr(T.DEPTID,1,4) else substr(T.DEPTID,1,2) end) = (case when C.DEPTID like 'Z%' then substr(C.DEPTID,1,4) else substr(C.DEPTID,1,2) end) and T.PROCESSCUSTOMNO=C.OWNERNO 
         WHERE T.PROCESSID = 'Z20820030368'
           AND M.PROCMATERIALDTLID = L.PROCMATERIALDTLID
           AND A.PROCARTICLEDTLID = L.PROCARTICLEDTLID 
         UNION ALL
        SELECT ROWNUM,SYSDATE PRINTDATE,T.DEPTID,M.prodstoveno M_PRODSTOVENO,a.classgroup A_CLASSGROUP,
               D.DEPTNAME,

(select max(t_zy_js_settlementdetail.countunit) from t_zy_js_settlementdetail where t.deptid=t_zy_js_settlementdetail.deptid and t.processid=t_zy_js_settlementdetail.businessno and t_zy_js_settlementdetail.feetypename=‘¼Ó¹¤·Ñ’)JGDJ,
T.jgmessage,
T.PROCESSID,
T.PROCESSCUSTOMNAME,
T.PROCESSDEPT,
T.PROCESSDEPTNAME,
T.PROCESSMOLDNAME,
T.PLANENDDATE,
T.MENO,
T.OUTCARBILLEMPNAME CREATEUSER,
T.PACKTYPENAME,
T.WOODTYPENAME,
T.STRAPTYPENAME,
T.PACKTYPENAME||’ ‘||T.WOODTYPENAME||’ ‘||T.STRAPTYPENAME THREE,
T.PROCESSPRECISION,
T.CHANXIAN,
T.OUTCARBILLTIME,
T.ORDERINFO,
T.CUSTOMERID,
T.CBXJGTYPE,
T.CUSTOMERID,
T.USERNAME,
T.preweightsum,
substr(t.specialmemo,1,instr(t.specialmemo,’|’,1,1)-1) HDGC,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,1)+1,(instr(t.specialmemo,’|’,1,2)-instr(t.specialmemo,’|’,1,1)-1)) KDGC,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,2)+1,(instr(t.specialmemo,’|’,1,3)-instr(t.specialmemo,’|’,1,2)-1)) CDGC,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,3)+1,(instr(t.specialmemo,’|’,1,4)-instr(t.specialmemo,’|’,1,3)-1)) CPNJ,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,4)+1,(instr(t.specialmemo,’|’,1,5)-instr(t.specialmemo,’|’,1,4)-1)) DJX,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,5)+1,(instr(t.specialmemo,’|’,1,6)-instr(t.specialmemo,’|’,1,5)-1)) BMYQ,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,6)+1,(instr(t.specialmemo,’|’,1,7)-instr(t.specialmemo,’|’,1,6)-1)) PZD,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,7)+1,(instr(t.specialmemo,’|’,1,8)-instr(t.specialmemo,’|’,1,7)-1)) MC,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,8)+1,(instr(t.specialmemo,’|’,1,9)-instr(t.specialmemo,’|’,1,8)-1)) LDW,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,9)+1,(instr(t.specialmemo,’|’,1,10)-instr(t.specialmemo,’|’,1,9)-1)) SFKJJ,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,10)+1,(instr(t.specialmemo,’|’,1,11)-instr(t.specialmemo,’|’,1,10)-1)) LXDH,
substr(t.specialmemo,instr(t.specialmemo,’|’,1,11)+1,length(t.specialmemo)) BZTSYQ,

               DECODE(T.PROCESSMOLDNAME,
                      '·Ö¾í',
                      ROUND(A.NETWEIGHT * 1000 * 1000 / 7.85 /
                            DECODE(A.GRADENUMWIDTH, 0, 1, A.GRADENUMWIDTH) /
                            DECODE(A.GRADENUMTHICK, 0, 1, A.GRADENUMTHICK),
                            2),
                      '×Ý¼ô',
                      ROUND(A.NETWEIGHT * 1000 * 1000 / 7.85 /
                            DECODE(A.GRADENUMWIDTH, 0, 1, A.GRADENUMWIDTH) /
                            DECODE(A.GRADENUMTHICK, 0, 1, A.GRADENUMTHICK),
                            2),
                      '×ÝÇÐ',
                      ROUND(A.NETWEIGHT * 1000 * 1000 / 7.85 /
                            DECODE(A.GRADENUMWIDTH, 0, 1, A.GRADENUMWIDTH) /
                            DECODE(A.GRADENUMTHICK, 0, 1, A.GRADENUMTHICK),
                            2),
                      0) LENGTH, 
               M.KINDNAME     M_KINDNAME,
               (SELECT MAX(M.KINDNAME)
                  FROM T_ZY_JG_PROCMATERIALDTL M2
                 WHERE M2.DEPTID = T.DEPTID
                   AND M2.PROCESSID = 'Z20820030368') MT_KINDNAME,
               M.GRADENUM     M_GRADENUM,
               M.MANAGENO     M_MANAGENO,
               M.PACKNUM      M_PACKNUM,
               M.SHEETNUM     M_SHEETNUM,
               M.NETWEIGHT    M_NETWEIGHT,
               (SELECT SUM(M1.NETWEIGHT) NETWEIGHT
                  FROM T_ZY_JG_PROCMATERIALDTL M1
                 WHERE M1.DEPTID = T.DEPTID
                   AND M1.PROCESSID = 'Z20820030368') MT_NETWEIGHT,
               M.POUNDWEIGHT  M_POUNDWEIGHT,
               M.SHOPSIGNNAME M_SHOPSIGNNAME,
               M.GOODSLOCID   M_GOODSLOCID,
               M.GOODSOWNERPACKNO M_GOODSOWNERPACKNO,
               M.PRODAREANAME M_PRODAREANAME, 
               M.HANDNO M_HANDNO,
               M.SAVENO M_SAVENO,
               C.OWNERSHORT C_OWNERSHORT,      
               C.OWNERNAMECUT C_OWNERNAMECUT,
               C.LINKMAN C_LINKMAN,
               A.PACKNUM   A_PACKNUM,
               L.NETWEIGHT A_NETWEIGHT,
               L.SHEETNUM L_SHEETNUM,
               L.GRADENUM L_GRADENUM,
               (SELECT SUM(A1.NETWEIGHT) NETWEIGHT
                  FROM T_ZY_JG_PROCARTICLEDTL A1
                 WHERE A1.DEPTID = T.DEPTID
                   AND A1.PROCESSID = 'Z20820030368') AT_NETWEIGHT,
               (SELECT TO_CHAR(Count(*))  FROM (SELECT gradenum
                  FROM T_ZY_JG_PROCARTICLEDTL A1
                 WHERE 
                   A1.PROCESSID = 'Z20820030368' group by gradenum)) SHOW_GRADENUM,

(case when ASCIISTR(A.GRADENUM) LIKE ‘%%’ then A.Netweight when A.GRADENUM like ‘%C%’ then A.Netweight else (A.gradenumthick*(A.gradenumwidth/1000)*(A.gradenumlength/1000)10.00785) end) singlenetweight,
A.GRADENUM A_GRADENUM,
(case when T.PROCESSMOLDNAME =’¿ªÆ½’ then (select replace(wm_concat(distinct gradenum),’,’,’ , ‘) from T_ZY_JG_PROCARTICLEDTL where PROCESSID=‘Z20820030368’ and goodstypename =‘¼Ó¹¤³ÉÆ·’)
else (select replace(wm_concat(distinct gradenum),’,’,’ , ') from T_ZY_JG_PROCARTICLEDTL where PROCESSID=‘Z20820030368’) end ) as BOGRADENUM,
A.SHEETNUM A_SHEETNUM,
A.NETWEIGHT NEW_NETWEIGHT,
A.GROSSWEIGHT A_GROSSWEIGHT,
A.ORDERBY A_ORDERBY,

               A.ArticleMemo1 A_ARTICLEMEMO1,A.ARTICLEMEMO4 A_ARTICLEMEMO4,
               A.PRODAREANAME A_PRODAREANAME,A.KINDNAME A_KINDNAME,round(A.NETWEIGHT/DECODE(A.SHEETNUM,0,1,A.SHEETNUM),4) SINGLENETWEIGHT,A.DRAWNO A_DRAWNO,A.PACKTYPENAME A_PACKTYPENAME,
               M.PLY M_PLY,A.WOODTYPENAME A_WOODTYPENAME,A.SHOPSIGNNAME A_SHOPSIGNNAME,A.GOODSTYPENAME A_GOODSTYPENAME,A.GOODSLOCID A_GOODSLOCID,A.QUALITYMEMO,M.QUALITYMEMO AS M_QUALITYMEMO,M.MEMO M_MEMO,
               (SELECT SHIPNO FROM t_zy_rk_inbilldetail goods WHERE m.deptid=goods.deptid and m.goodsid=goods.goodsid) SHIPNO,
                T.DOWNORDERTIME
            ,(SELECT MEMO FROM t_zy_rk_inbilldetail goods WHERE m.deptid=goods.deptid and m.goodsid=goods.goodsid) INMEMO,
             (SELECT FIRSTINDATE FROM t_zy_rk_inbilldetail goods WHERE m.deptid=goods.deptid and m.goodsid=goods.goodsid) INFIRSTINDATE,T.CHENGPINGNEIJING
             ,A.HANDNO A_HANDNO/*¼Ó¹¤µ¥×Ô¶¨Òå´òÓ¡Êý¾ÝÔ´ÖÐÔö¼Ó³ÉÆ·ÊÖºÅÐÅÏ¢(A_HANDNO)(²Î¿¼ÐèÇóºÅWMSXQ-3966) add by xijunwei 20180827*/
             ,A.SAVENO A_SAVENO
           ,A.Memo A_MEMO
    ,case when  t.ftprocessid is null  then t.processid
     else  t.ftprocessid end ftprocessid,
   case when t.lvprocessid is null then t.processid
     else  t.lvprocessid end lvprocessid
          FROM T_ZY_JG_PROCESS T
          left join T_COMMON_DEPT D ON T.DEPTID = D.DEPTID
          left join T_ZY_JG_PROCMATERIALDTL M on T.PROCESSID = M.PROCESSID
          left join (Select PROCESSID,PROCARTICLEDTLID,PROCMATERIALDTLID,sum(NETWEIGHT) NETWEIGHT,sum(SHEETNUM) SHEETNUM ,GRADENUM From T_ZY_JG_PROCLINK 
          Where PROCESSID = 'Z20820030368' Group by PROCESSID,PROCARTICLEDTLID,PROCMATERIALDTLID,GRADENUM) L on T.PROCESSID = L.PROCESSID 
          left join T_ZY_JG_PROCARTICLEDTL_DEL A on T.PROCESSID = A.PROCESSID
          left join T_GG_SJ_CUSTOMER C ON (case when T.DEPTID like 'Z%' then substr(T.DEPTID,1,4) else substr(T.DEPTID,1,2) end) = (case when C.DEPTID like 'Z%' then substr(C.DEPTID,1,4) else substr(C.DEPTID,1,2) end) and T.PROCESSCUSTOMNO=C.OWNERNO 
         WHERE T.PROCESSID = 'Z20820030368'
           AND M.PROCMATERIALDTLID = L.PROCMATERIALDTLID
           AND A.PROCARTICLEDTLID = L.PROCARTICLEDTLID order by A_ORDERBY

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)

ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FFFA24F1FC0 ? 7FFFA24F2020 ?
7FFFA24F1F60 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7FFFA24F1FC0 ? 7FFFA24F2020 ?
7FFFA24F1F60 ? 000000000 ?

我来答

添加附件

问题补充

1条回答

默认