037517';这一步是根据出库单查看小车分配表(4)selectt.*,t.rowidfromck_cartinfo_hztwheredanj_no='CKD02000422140';这一步是根据出库单查看小车分配表(5)selectt.*,t.rowidfromck_cartinfo_mxtwheredanj_no='CKD02000422140'这一步是看是不是还有没有释放的小车,如果货到齐了,没释放,手工释放(6)electt.*,t.rowidfromyw_ckcmdtwheretiaoj_valuelike'%CKD02000422140%';有未处理的分拣指令,调过程(或者不调用过程,系统会自动跑)(7)select*fromyw_ckcmdwheremingl_type='31';(8)select*fromjc_fjhd_mxwheredanj_no='CKD02000403237'begin--Calltheprocedurepkg_utl_cmd.p_runcmd(iv_mltype=>:iv_mltype,--14iv_tjval=>:iv_tjval,--<CKD02000261791>iv_cmtflg=>:iv_cmtflg);end;报ck_jg违法唯一约束条件select*fromck_kpd_hzwhereyewdj_no='XSGFDE03653291'selectt.*,t.rowidfromjg_cktwherejiang_cdin(selectjiang_cdfromck_outchk_jgwhereliush_barcodein(selectliush_barcodefromyw_sptmwheredanj_no='CKD02000416136'));把查询结果删除单据〖ZPC02000004735〗已经下发,不能再执行调度冲红
全文预览
