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