SQL Id | SQL Text |
003090gzr56w2 |
SELECT (case when plan_qty > return_qty then :"SYS_B_0" else :"SYS_B_1" end) FINISHFLAG, SALESRETURN_BILL.SYSTEMID, SALESRETURN_BILL.SALESRETURNBILLID, SALESRETURN_BILL.SALESRETURNBILLNO, SALESRETURN_BILL.SALESRETURNBILLBATCHID, SALESRETURN_BILL.SALESRETURNBILLBATCHNO, SALESRETURN_BILL.SALESORDERID, SALESRETURN_BILL.OUTERSALESORDERID, SALESRETURN_BILL.ORDERTYPEID, SALESRETURN_BILL.OLDSALESORDERID, SALESRETURN_BILL.OLDOUTSALESORDERID, SALESRETURN_BILL.POSID, SALESRETURN_BILL.OUTWAREHOUSEID, SALESRETURN_BILL.WAREHOUSEID, SALESRETURN_BILL.WAREHOUSEAREAID, SALESRETURN_BILL.CARGOSPACEID, SALESRETURN_BILL.SALESRETURNTYPEID, SALESRETURN_BILL.SALESRETURNREASONID, SALESRETURN_BILL.EXPRESSDELIVERYID, SALESRETURN_BILL.WAYBILLNO, SALESRETURN_BILL.PLAN_VARIETYQTY, SALESRETURN_BILL.PLAN_QTY, SALESRETURN_BILL.PLAN_PRICEAMOUNT, SALESRETURN_BILL.PLAN_SALEAMOUNT, SALESRETURN_BILL.PLAN_WEIGHT, SALESRETURN_BILL.RETURN_VARIETYQTY, SALESRETURN_BILL.RETURN_QTY
, SALESRETURN_BILL.RETURN_PRICEAMOUNT, SALESRETURN_BILL.RETURN_SALEAMOUNT, SALESRETURN_BILL.RETURN_WEIGHT, SALESRETURN_BILL.DAMAGE_VARIETYQTY, SALESRETURN_BILL.DAMAGE_QTY, SALESRETURN_BILL.DAMAGE_PRICEMOUNT, SALESRETURN_BILL.DAMAGE_SALEAMOUNT, SALESRETURN_BILL.DAMAGE_WEIGHT, SALESRETURN_BILL.REMARK, SALESRETURN_BILL.CREATEDATE, SALESRETURN_BILL.CONFIRMDATE, SALESRETURN_BILL.SHELVEDATE, SALESRETURN_BILL.ACCOUNTDATE, SALESRETURN_BILL.CREATEUSERID, SALESRETURN_BILL.CONFIRMUSERID, SALESRETURN_BILL.SHELVEUSERID, SALESRETURN_BILL.ACCOUNTUSERID, SALESRETURN_BILL.INPUTFLAG, SALESRETURN_BILL.BILL_STATE, SALESRETURN_BILL.OLDBILL_STATE, SALESRETURN_BILL.STATE_DESC, salesreturn_inorder.RECEIVERNAME, salesreturn_inorder.RECEIVERMOBILE, salesreturn_inorder.RECEIVERPHONE, salesreturn_inorder.receiveraddress , dp.companyname dp, hz.companyname hz, salesreturn_bill.costlyflag, t.DELIVERNO, t.ownerid, t.shopid FROM SALESRETURN_BILL left join salesorder_bill t on t.mopocsales
orderbillid = SALESRETURN_BILL.Oldsalesorderid left join base_company hz on hz.companyid = t.ownerid left join base_company dp on dp.companyid = t.shopid left join salesreturn_inorder on SALESRETURN_BILL.salesorderid=salesreturn_inorder.mopocsalesorderbillid where :"SYS_B_2" =:"SYS_B_3" and SALESRETURN_BILL.Salesorderid = :"SYS_B_4" |
0bxgpsyhq71ds |
SELECT SYSTEMID, PICKINGBILLSOURCEID, PICKINGBILLDETAILID, PICKINGBILLID, PICKINGBILLNO, PICKINGBILLBATCHID, PICKINGBILLBATCHNO, PICKINGTYPEID, MOPOCSALESORDERBILLDETAILID, MOPOCSALESORDERBILLID, OUTERSALESORDERBILLID, OUTERSALESORDERBILLDETAILID, MOPOCSOURCEORDERBILLID, MOPOCSOURCEBILLDETAILID, OUTERSOURCEORDERBILLID, OUTERSOURCEBILLDETAILID, WAYBILLDETAILID, WAYBILLID, WAYBILLNO, DEPARTMENTID, OWNERID, DELIVERID, WAREHOUSEID, JXFQID, BOXNO, WAREHOUSEAREAID, CARGOSPACEID, INVENTORYCARGOSPACEID, INVENTORYOWNERID, SKUID, PRODUCTION_DATE, PACKED_DATE, WARRANTY_ENDDATE, WARRANTY, PRODUCTION_BATCHNUMBER, PICKING_QTY, PACKAGE_QTY, DIVERSITY_QTY, REMARK, QUALITYUSERID, QUALITYDATE, CREATEUSERID, CREATEDATE, UPDATEUSERID, UPDATEDATE, BILL_STATE, OLDBILL_STATE, STATE_DESC, RECORDTIME, TASKSTATE FROM IF_PICKING_BILLSOURCE WHERE TASKSTATE=:"SYS_B_0" AND OWNERID<>:"SYS_B_1" AND OWNERID<>:"SYS_B_2" AND OWNERID
<>:"SYS_B_3" AND ROWNUM < :"SYS_B_4" |
0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
0tnjgjztc81h2 | UPDATE SALESORDER_BILL T SET T.PACKTIME = SYSDATE, T.PACKUSERID = :B2 , T.UPDATETIME = SYSDATE, T.OLDBILL_STATE = T.BILL_STATE, T.BILL_STATE = '05', T.STATE_DESC = '包装确认' WHERE T.MOPOCSALESORDERBILLID = :B1 |
19ndx01y0mz8a |
select count(:"SYS_B_0") from (select waybilldetail_packagehangding.systemid, waybilldetail_packagehangding.waybill_packagedetailid, waybilldetail_packagehangding.waybill_packageid, waybilldetail_packagehangding.waybill_packageno, waybilldetail_packagehangding.mopocsalesorderbilldetailid, waybilldetail_packagehangding.mopocsalesorderbillid, waybilldetail_packagehangding.outersalesorderbillid, waybilldetail_packagehangding.outersalesorderbilldetailid, waybilldetail_packagehangding.shopid, waybilldetail_packagehangding.ownerid, waybilldetail_packagehangding.ordertypeid, waybilldetail_packagehangding.departmentid, waybilldetail_packagehangding.warehouseid, waybilldetail_packagehangding.skuid, waybilldetail_packagehangding.saleprice, waybilldetail_packagehangding.discount, waybilldetail_packagehangding.package_qty, waybilldetail_packagehangding.package_saleamount, waybilldetail_packagehangding.qc_weight, waybilldetail_packagehangding.production_date, waybilldet
ail_packagehangding.packed_date, waybilldetail_packagehangding.warranty_enddate, waybilldetail_packagehangding.warranty, waybilldetail_packagehangding.production_batchnumber, waybilldetail_packagehangding.pickingbillid, waybilldetail_packagehangding.pickingbillno, waybilldetail_packagehangding.createuserid, waybilldetail_packagehangding.updateuserid, waybilldetail_packagehangding.createtime, waybilldetail_packagehangding.updatetime, waybilldetail_packagehangding.bill_state, waybilldetail_packagehangding.oldbill_state, waybilldetail_packagehangding.state_desc, BASE_GOODSINFO.GOODSBARCODE, BASE_GOODSINFO.GOODSNAME, BASE_GOODSINFO.GOODSNO, salesorder_bill.RECEIVERNAME, salesorder_bill.RECEIVERADDRESS, salesorder_bill.RECEIVERZIP, BASE_PROVINCE.PROVINCE_NAME, BASE_CITY.CITY_NAME, BASE_AREA.AREA_NAME, salesorder_bill.RECEIVERMOBILE, salesorder_bill.RECEIVERPHONE from waybilldetail_packagehangding, salesorder_bill, BASE_GOODSINFO, BASE_PROVINCE, BASE_CITY, BASE_AR
EA where waybilldetail_packagehangding.mopocsalesorderbillid = salesorder_bill.mopocsalesorderbillid and waybilldetail_packagehangding.SKUID = BASE_GOODSINFO.SKUID(+) AND salesorder_bill.RECEIVERSTATE = BASE_PROVINCE.PROVINCE_ID(+) AND salesorder_bill.RECEIVERCITY = BASE_CITY.CITY_ID(+) AND salesorder_bill.RECEIVERDISTRICT = BASE_AREA.AREA_ID(+) AND WAYBILLDETAIL_PACKAGEHANGDING.WAREHOUSEID=:"SYS_B_1" AND WAYBILLDETAIL_PACKAGEHANGDING.PICKINGBILLNO = :"SYS_B_2" Order By CREATETIME desc, WAYBILL_PACKAGEDETAILID desc, WAYBILL_PACKAGEDETAILID desc) |
1q85jprkn4c32 |
select count(:"SYS_B_0") from (SELECT SALESORDER_BILL.salesoder_codno, SALESORDER_BILL.STATE_DESC, SALESORDER_BILL.MOPOCSALESORDERBILLID, SALESORDER_BILL.OUTERSALESORDERBILLID, SALESORDER_BILL.MOPOCSOURCEORDERBILLID, SALESORDER_BILL.OUTERSOURCEORDERBILLID, SALESORDER_BILL.DELIVERID, SALESORDER_BILL.DELIVERNO, SALESORDER_BILL.DELIVERYMODEID, SALESORDER_BILL.DELIVERYTIME, SALESORDER_BILL.SHOPID, SALESORDER_BILL.OWNERID, SALESORDER_BILL.BUYERNICK, SALESORDER_BILL.BUYEREMAIL, SALESORDER_BILL.BUYERMESSAGE, SALESORDER_BILL.CUSTOMERID, SALESORDER_BILL.RECEIVERNAME, SALESORDER_BILL.RECEIVERADDRESS, SALESORDER_BILL.RECEIVERZIP, SALESORDER_BILL.RECEIVERSTATE, SALESORDER_BILL.RECEIVERCITY, SALESORDER_BILL.RECEIVERDISTRICT, SALESORDER_BILL.RECEIVERMOBILE, SALESORDER_BILL.RECEIVERPHONE, SALESORDER_BILL.PLATFORMID, SALESORDER_BILL.PLATFORMSTATUS, SALESORDER_BILL.ORDERTYPEID, SALESORDER_BILL.INPUTTYPEID, SALESORDER_BILL.WAREHOUSEID, SALESORDER_BILL.ORDER_VARIETYQ
TY, SALESORDER_BILL.ORDER_DETAILQTY, SALESORDER_BILL.ORDER_QTY, SALESORDER_BILL.ORDER_SALEAMOUNT, SALESORDER_BILL.ORDER_WEIGHT, SALESORDER_BILL.ASSIGN_QTY, SALESORDER_BILL.PICKING_QTY, SALESORDER_BILL.QC_VARIETYQTY, SALESORDER_BILL.QC_QTY, SALESORDER_BILL.QC_SALEAMOUNT, SALESORDER_BILL.QC_WEIGHT, SALESORDER_BILL.CONSIGN_VARIETYQTY, SALESORDER_BILL.CONSIGN_QTY, SALESORDER_BILL.CONSIGN_SALEAMOUNT, SALESORDER_BILL.CONSIGN_WEIGHT, SALESORDER_BILL.GOODS_WEIGHT, SALESORDER_BILL.OTHERSGOODS_WEIGHT, SALESORDER_BILL.ORDERTIME, SALESORDER_BILL.ENTERHEADQUARTERSTIME, SALESORDER_BILL.UNITEHEADQUARTERSTIME, SALESORDER_BILL.DISTRIBUTETIME, SALESORDER_BILL.ENTERWAREHOUSETIME, SALESORDER_BILL.UNITEWAREHOUSETIME, SALESORDER_BILL.IMPORTTIME, SALESORDER_BILL.IMPORTUSERID, SALESORDER_BILL.MERGETIME, SALESORDER_BILL.MERGEUSERID, SALESORDER_BILL.WAITINGTIME, SALESORDER_BILL.WAITINGUSERID, SALESORDER_BILL.CANCELWAITINGTIME, SALESORDER_BILL.CANCELWAITINGUSERID, SALESORDER_BILL.C
ANCELORDERTIME, SALESORDER_BILL.CANCELORDERUSERID, SALESORDER_BILL.ACTUALCANCELTIME, SALESORDER_BILL.ACTUALCANCELUSERID, SALESORDER_BILL.ORDERPRINTTIME, SALESORDER_BILL.ORDERPRINTUSERID, SALESORDER_BILL.ASSIGNORDERTIME, SALESORDER_BILL.ASSIGNORDERUSERID, SALESORDER_BILL.PICKINGTIME, SALESORDER_BILL.PICKINGUSERID, SALESORDER_BILL.QCTIME, SALESORDER_BILL.QCUSERID, SALESORDER_BILL.ACTUALSHORTTIME, SALESORDER_BILL.ACTUALSHORTUSERID, SALESORDER_BILL.PACKTIME, SALESORDER_BILL.PACKUSERID, SALESORDER_BILL.WAYBILLTIME, SALESORDER_BILL.WAYBILLUSERID, SALESORDER_BILL.HANDINGTIME, SALESORDER_BILL.HANDINGUSERID, SALESORDER_BILL.CONSIGNTIME, SALESORDER_BILL.CONSIGNUSERID, SALESORDER_BILL.ENDTIME, SALESORDER_BILL.ENDUSERID, SALESORDER_BILL.ACCOUNTDATE, SALESORDER_BILL.ACCOUNTUSERID, SALESORDER_BILL.MODIFIEDTIME, SALESORDER_BILL.SHORTFLAG, SALESORDER_BILL.ACTUALSHORTFLAG, SALESORDER_BILL.UNITEFLAG, SALESORDER_BILL.ACCOUNTFLAG, SALESORDER_BILL.VOUCHERFLAG, SALESORDER_BIL
L.INNERSTATUS, SALESORDER_BILL.REFUNDSTATUS, SALESORDER_BILL.STOCKSTATUS, SALESORDER_BILL.RETURNMODEID, SALESORDER_BILL.PAYMENTMODEID, SALESORDER_BILL.REFUND_MODEID, SALESORDER_BILL.PACKAGING_MODEID, SALESORDER_BILL.PACKAGING_COST, SALESORDER_BILL.PACKAGING_SKUID, SALESORDER_BILL.RECEIVABLE_AMOUNT, SALESORDER_BILL.GOODS_PAYMENT, SALESORDER_BILL.DELIVERY_COST, SALESORDER_BILL.INVOICE_AMOUNT, SALESORDER_BILL.ACCOUNT_PAID, SALESORDER_BILL.SHOPPING_VOUCHER, SALESORDER_BILL.ACCOUNT_BALANCE, SALESORDER_BILL.PAYTIME, SALESORDER_BILL.INVOICEFLAG, SALESORDER_BILL.INVOICE_NAME, SALESORDER_BILL.INVOICE_CONTENT, SALESORDER_BILL.ORDER_DISCOUNT, SALESORDER_BILL.GROUPORDERFLAG, SALESORDER_BILL.ADVANCEORDERFLAG, SALESORDER_BILL.PAYMENTFLAG, SALESORDER_BILL.BLENDFLAG, SALESORDER_BILL.RETURNREASONDESC, SALESORDER_BILL.WAYBILLID, SALESORDER_BILL.WAYBILLNO, SALESORDER_BILL.PICKINGBILLID, SALESORDER_BILL.PICKINGBILLNO, SALESORDER_BILL.PICKINGBILLBATCHID, SALESORDER_BILL.PICKI
NGBILLBATCHNO, SALESORDER_BILL.ORDERMOVEINGBILLBATCHID, SALESORDER_BILL.ORDERMOVEINGBILLBATCHNO, SALESORDER_BILL.WAREHOUSEAREAQTY, SALESORDER_BILL.WAREHOUSEAREAWAY, SALESORDER_BILL.CREATETIME, SALESORDER_BILL.UPDATETIME, SALESORDER_BILL.BILL_STATE, SALESORDER_BILL.OLDBILL_STATE, salesorder_bill.costlyflag, salesorder_bill.DANGEROUS_FLAG, salesorder_bill.TRAVELSFLAG, SALESORDER_BILL.batchbillid, SALESORDER_BILL.batchbillno FROM SALESORDER_BILL where WAREHOUSEID=:"SYS_B_1" AND MOPOCSALESORDERBILLID = :"SYS_B_2" Order By MOPOCSALESORDERBILLID) |
2mqb8vy7su3f0 |
select count(:"SYS_B_0") from (SELECT SALESORDER_BILL.salesoder_codno, SALESORDER_BILL.STATE_DESC, SALESORDER_BILL.MOPOCSALESORDERBILLID, SALESORDER_BILL.OUTERSALESORDERBILLID, SALESORDER_BILL.MOPOCSOURCEORDERBILLID, SALESORDER_BILL.OUTERSOURCEORDERBILLID, SALESORDER_BILL.DELIVERID, SALESORDER_BILL.DELIVERNO, SALESORDER_BILL.DELIVERYMODEID, SALESORDER_BILL.DELIVERYTIME, SALESORDER_BILL.SHOPID, SALESORDER_BILL.OWNERID, SALESORDER_BILL.BUYERNICK, SALESORDER_BILL.BUYEREMAIL, SALESORDER_BILL.BUYERMESSAGE, SALESORDER_BILL.CUSTOMERID, SALESORDER_BILL.RECEIVERNAME, SALESORDER_BILL.RECEIVERADDRESS, SALESORDER_BILL.RECEIVERZIP, SALESORDER_BILL.RECEIVERSTATE, SALESORDER_BILL.RECEIVERCITY, SALESORDER_BILL.RECEIVERDISTRICT, SALESORDER_BILL.RECEIVERMOBILE, SALESORDER_BILL.RECEIVERPHONE, SALESORDER_BILL.PLATFORMID, SALESORDER_BILL.PLATFORMSTATUS, SALESORDER_BILL.ORDERTYPEID, SALESORDER_BILL.INPUTTYPEID, SALESORDER_BILL.WAREHOUSEID, SALESORDER_BILL.ORDER_VARIETYQ
TY, SALESORDER_BILL.ORDER_DETAILQTY, SALESORDER_BILL.ORDER_QTY, SALESORDER_BILL.ORDER_SALEAMOUNT, SALESORDER_BILL.ORDER_WEIGHT, SALESORDER_BILL.ASSIGN_QTY, SALESORDER_BILL.PICKING_QTY, SALESORDER_BILL.QC_VARIETYQTY, SALESORDER_BILL.QC_QTY, SALESORDER_BILL.QC_SALEAMOUNT, SALESORDER_BILL.QC_WEIGHT, SALESORDER_BILL.CONSIGN_VARIETYQTY, SALESORDER_BILL.CONSIGN_QTY, SALESORDER_BILL.CONSIGN_SALEAMOUNT, SALESORDER_BILL.CONSIGN_WEIGHT, SALESORDER_BILL.GOODS_WEIGHT, SALESORDER_BILL.OTHERSGOODS_WEIGHT, SALESORDER_BILL.ORDERTIME, SALESORDER_BILL.ENTERHEADQUARTERSTIME, SALESORDER_BILL.UNITEHEADQUARTERSTIME, SALESORDER_BILL.DISTRIBUTETIME, SALESORDER_BILL.ENTERWAREHOUSETIME, SALESORDER_BILL.UNITEWAREHOUSETIME, SALESORDER_BILL.IMPORTTIME, SALESORDER_BILL.IMPORTUSERID, SALESORDER_BILL.MERGETIME, SALESORDER_BILL.MERGEUSERID, SALESORDER_BILL.WAITINGTIME, SALESORDER_BILL.WAITINGUSERID, SALESORDER_BILL.CANCELWAITINGTIME, SALESORDER_BILL.CANCELWAITINGUSERID, SALESORDER_BILL.C
ANCELORDERTIME, SALESORDER_BILL.CANCELORDERUSERID, SALESORDER_BILL.ACTUALCANCELTIME, SALESORDER_BILL.ACTUALCANCELUSERID, SALESORDER_BILL.ORDERPRINTTIME, SALESORDER_BILL.ORDERPRINTUSERID, SALESORDER_BILL.ASSIGNORDERTIME, SALESORDER_BILL.ASSIGNORDERUSERID, SALESORDER_BILL.PICKINGTIME, SALESORDER_BILL.PICKINGUSERID, SALESORDER_BILL.QCTIME, SALESORDER_BILL.QCUSERID, SALESORDER_BILL.ACTUALSHORTTIME, SALESORDER_BILL.ACTUALSHORTUSERID, SALESORDER_BILL.PACKTIME, SALESORDER_BILL.PACKUSERID, SALESORDER_BILL.WAYBILLTIME, SALESORDER_BILL.WAYBILLUSERID, SALESORDER_BILL.HANDINGTIME, SALESORDER_BILL.HANDINGUSERID, SALESORDER_BILL.CONSIGNTIME, SALESORDER_BILL.CONSIGNUSERID, SALESORDER_BILL.ENDTIME, SALESORDER_BILL.ENDUSERID, SALESORDER_BILL.ACCOUNTDATE, SALESORDER_BILL.ACCOUNTUSERID, SALESORDER_BILL.MODIFIEDTIME, SALESORDER_BILL.SHORTFLAG, SALESORDER_BILL.ACTUALSHORTFLAG, SALESORDER_BILL.UNITEFLAG, SALESORDER_BILL.ACCOUNTFLAG, SALESORDER_BILL.VOUCHERFLAG, SALESORDER_BIL
L.INNERSTATUS, SALESORDER_BILL.REFUNDSTATUS, SALESORDER_BILL.STOCKSTATUS, SALESORDER_BILL.RETURNMODEID, SALESORDER_BILL.PAYMENTMODEID, SALESORDER_BILL.REFUND_MODEID, SALESORDER_BILL.PACKAGING_MODEID, SALESORDER_BILL.PACKAGING_COST, SALESORDER_BILL.PACKAGING_SKUID, SALESORDER_BILL.RECEIVABLE_AMOUNT, SALESORDER_BILL.GOODS_PAYMENT, SALESORDER_BILL.DELIVERY_COST, SALESORDER_BILL.INVOICE_AMOUNT, SALESORDER_BILL.ACCOUNT_PAID, SALESORDER_BILL.SHOPPING_VOUCHER, SALESORDER_BILL.ACCOUNT_BALANCE, SALESORDER_BILL.PAYTIME, SALESORDER_BILL.INVOICEFLAG, SALESORDER_BILL.INVOICE_NAME, SALESORDER_BILL.INVOICE_CONTENT, SALESORDER_BILL.ORDER_DISCOUNT, SALESORDER_BILL.GROUPORDERFLAG, SALESORDER_BILL.ADVANCEORDERFLAG, SALESORDER_BILL.PAYMENTFLAG, SALESORDER_BILL.BLENDFLAG, SALESORDER_BILL.RETURNREASONDESC, SALESORDER_BILL.WAYBILLID, SALESORDER_BILL.WAYBILLNO, SALESORDER_BILL.PICKINGBILLID, SALESORDER_BILL.PICKINGBILLNO, SALESORDER_BILL.PICKINGBILLBATCHID, SALESORDER_BILL.PICKI
NGBILLBATCHNO, SALESORDER_BILL.ORDERMOVEINGBILLBATCHID, SALESORDER_BILL.ORDERMOVEINGBILLBATCHNO, SALESORDER_BILL.WAREHOUSEAREAQTY, SALESORDER_BILL.WAREHOUSEAREAWAY, SALESORDER_BILL.CREATETIME, SALESORDER_BILL.UPDATETIME, SALESORDER_BILL.BILL_STATE, SALESORDER_BILL.OLDBILL_STATE, salesorder_bill.costlyflag, salesorder_bill.DANGEROUS_FLAG, salesorder_bill.TRAVELSFLAG, SALESORDER_BILL.batchbillid, SALESORDER_BILL.batchbillno FROM SALESORDER_BILL where WAREHOUSEID=:"SYS_B_1" AND RECEIVERMOBILE = :"SYS_B_2" Order By MOPOCSALESORDERBILLID) |
350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
3h8bbarvsmgjn |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM ( Select WAYBILL_LEADIN.SYSTEMID, WAYBILL_LEADIN.PAYTIME, WAYBILL_LEADIN.MOPOCSALESORDERBILLID, WAYBILL_LEADIN.OUTERSALESORDERBILLID, WAYBILL_LEADIN.MOPOCSOURCEORDERBILLID, WAYBILL_LEADIN.OUTERSOURCEORDERBILLID, WAYBILL_LEADIN.WAYBILLID, WAYBILL_LEADIN.WAYBILLNO, WAYBILL_LEADIN.SHOPID, WAYBILL_LEADIN.OWNERID, WAYBILL_LEADIN.ORDERTYPEID, WAYBILL_LEADIN.WAREHOUSEID, WAYBILL_LEADIN.JXFQID, WAYBILL_LEADIN.BOXNO, WAYBILL_LEADIN.ORDER_VARIETYQTY, WAYBILL_LEADIN.ORDER_DETAILQTY, WAYBILL_LEADIN.ORDER_QTY, WAYBILL_LEADIN.ASSIGN_QTY, WAYBILL_LEADIN.RECEIVABLE_AMOUNT, WAYBILL_LEADIN.RECEIVERNAME, WAYBILL_LEADIN.RECEIVERADDRESS, WAYBILL_LEADIN.RECEIVERZIP, WAYBILL_LEADIN.RECEIVERSTATE, WAYBILL_LEADIN.RECEIVERCITY, WAYBILL_LEADIN.RECEIVERDISTRICT, WAYBILL_LEADIN.RECEIVERMOBILE, WAYBILL_LEADIN.RECEIVERPHONE, WAYBILL_LEADIN.ORDERTIME, WAYBILL_LEADIN.DELIVERYTIME, WAYBILL_LEADIN.DELIVERID, WAYBILL_LEADIN.GROUPORDERFLAG, WAYBILL_LE
ADIN.INVOICEFLAG, WAYBILL_LEADIN.ADVANCEORDERFLAG, WAYBILL_LEADIN.PAYMENTFLAG, WAYBILL_LEADIN.BLENDFLAG, WAYBILL_LEADIN.PICKINGBILLID, WAYBILL_LEADIN.PICKINGBILLNO, WAYBILL_LEADIN.PICKINGBILLBATCHID, WAYBILL_LEADIN.PICKINGBILLBATCHNO, WAYBILL_LEADIN.WAREHOUSEAREAQTY, WAYBILL_LEADIN.WAREHOUSEAREAWAY, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHID, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHNO, WAYBILL_LEADIN.CREATEUSERID, WAYBILL_LEADIN.UPDATEUSERID, WAYBILL_LEADIN.CREATETIME, WAYBILL_LEADIN.UPDATETIME, WAYBILL_LEADIN.BILL_STATE, WAYBILL_LEADIN.OLDBILL_STATE, WAYBILL_LEADIN.STATE_DESC , WAYBILL_LEADIN.costlyflag , WAYBILL_LEADIN.Paymentmodeid, WAYBILL_LEADIN.Buyermessage, :"SYS_B_00" as selectedflag, WAYBILL_LEADIN.INPUTTYPEID, WAYBILL_LEADIN.ORDER_SALEAMOUNT, WAYBILL_LEADIN.PLATFORMID, WAYBILL_LEADIN.CUSTOMER_MESSAGE From WAYBILL_LEADIN Where :"SYS_B_01"=:"SYS_B_02" And ALLOT_OCCUPY_FLAG = :"SYS_B_03" and WAREHOUSEID=:"SYS_B_04
" And (WAYBILL_LEADIN.OWNERID =:"SYS_B_05") and Not Exists ( Select :"SYS_B_06" From Base_Shopgroup, Base_Shopgroup_Shop Where Base_Shopgroup.Shopgroupid = Base_Shopgroup_Shop.Shopgroupid And Base_Shopgroup_Shop.Enableflag = :"SYS_B_07" And Base_Shopgroup.Enableflag = :"SYS_B_08" And Base_Shopgroup_Shop.Shopid = Waybill_Leadin.Shopid And Base_Shopgroup_Shop.warehouseid = Waybill_Leadin.warehouseid ) Order By WAYBILL_LEADIN.BILL_STATE asc , WAYBILL_LEADIN.paytime asc, WAYBILL_LEADIN.MOPOCSALESORDERBILLID asc ) A WHERE ROWNUM <= :"SYS_B_09" ) WHERE RN > :"SYS_B_10" |
3hkxqb42macn7 | SELECT S.SYSTEM_PREFIXION FROM SYS_SYSINFO S WHERE S.SYSTEM_ID = :B1 |
3rfa3jdts90xg | UPDATE PURCHASE_RETURNBILLDETAIL T SET (T.CHECK_QUANTITY, T.CHECK_PRICEAMOUNT) = (SELECT SUM(S.SORTING_QTY), SUM(S.SORTING_PRICEAMOUNT) FROM SORTING_BILLDETAIL S WHERE S.LOGISTICSTYPEID = '进退单' AND S.LOGISTICSBILLDETAILID = T.PURCHASERETURNBILLDETAILID) WHERE T.PURCHASERETURNBILLID = :B2 AND T.SYSTEMID = :B1 AND EXISTS (SELECT 1 FROM SORTING_BILLDETAIL Y WHERE Y.LOGISTICSTYPEID = '进退单' AND Y.LOGISTICSBILLDETAILID = T.PURCHASERETURNBILLDETAILID) |
47a50dvdgnxc2 | update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4 |
49235vb3j9h2h |
select count(:"SYS_B_0") from (select waybilldetail_packagehangding.systemid, waybilldetail_packagehangding.waybill_packagedetailid, waybilldetail_packagehangding.waybill_packageid, waybilldetail_packagehangding.waybill_packageno, waybilldetail_packagehangding.mopocsalesorderbilldetailid, waybilldetail_packagehangding.mopocsalesorderbillid, waybilldetail_packagehangding.outersalesorderbillid, waybilldetail_packagehangding.outersalesorderbilldetailid, waybilldetail_packagehangding.shopid, waybilldetail_packagehangding.ownerid, waybilldetail_packagehangding.ordertypeid, waybilldetail_packagehangding.departmentid, waybilldetail_packagehangding.warehouseid, waybilldetail_packagehangding.skuid, waybilldetail_packagehangding.saleprice, waybilldetail_packagehangding.discount, waybilldetail_packagehangding.package_qty, waybilldetail_packagehangding.package_saleamount, waybilldetail_packagehangding.qc_weight, waybilldetail_packagehangding.production_date, waybilldet
ail_packagehangding.packed_date, waybilldetail_packagehangding.warranty_enddate, waybilldetail_packagehangding.warranty, waybilldetail_packagehangding.production_batchnumber, waybilldetail_packagehangding.pickingbillid, waybilldetail_packagehangding.pickingbillno, waybilldetail_packagehangding.createuserid, waybilldetail_packagehangding.updateuserid, waybilldetail_packagehangding.createtime, waybilldetail_packagehangding.updatetime, waybilldetail_packagehangding.bill_state, waybilldetail_packagehangding.oldbill_state, waybilldetail_packagehangding.state_desc, BASE_GOODSINFO.GOODSBARCODE, BASE_GOODSINFO.GOODSNAME, BASE_GOODSINFO.GOODSNO, salesorder_bill.RECEIVERNAME, salesorder_bill.RECEIVERADDRESS, salesorder_bill.RECEIVERZIP, BASE_PROVINCE.PROVINCE_NAME, BASE_CITY.CITY_NAME, BASE_AREA.AREA_NAME, salesorder_bill.RECEIVERMOBILE, salesorder_bill.RECEIVERPHONE from waybilldetail_packagehangding, salesorder_bill, BASE_GOODSINFO, BASE_PROVINCE, BASE_CITY, BASE_AR
EA where waybilldetail_packagehangding.mopocsalesorderbillid = salesorder_bill.mopocsalesorderbillid and waybilldetail_packagehangding.SKUID = BASE_GOODSINFO.SKUID(+) AND salesorder_bill.RECEIVERSTATE = BASE_PROVINCE.PROVINCE_ID(+) AND salesorder_bill.RECEIVERCITY = BASE_CITY.CITY_ID(+) AND salesorder_bill.RECEIVERDISTRICT = BASE_AREA.AREA_ID(+) AND WAYBILLDETAIL_PACKAGEHANGDING.WAREHOUSEID=:"SYS_B_1" AND WAYBILLDETAIL_PACKAGEHANGDING.MOPOCSALESORDERBILLID = :"SYS_B_2" Order By CREATETIME desc, WAYBILL_PACKAGEDETAILID desc, WAYBILL_PACKAGEDETAILID desc) |
4wp3919j4r4wx |
select tt.* from ( select rq, sum(jxdds) jxdds, sum(jxrs) jxrs, trunc(sum(jxdds) / decode(sum(jxrs), :"SYS_B_00", :"SYS_B_01", sum(jxrs)), :"SYS_B_02") zdxl, sum(zjdds) zjdds, sum(zjrs) zjrs, trunc(sum(zjdds) / decode(sum(zjrs), :"SYS_B_03", :"SYS_B_04", sum(zjrs)), :"SYS_B_05") zjxl, sum(xtdds) xtdds, sum(xtrs) xtrs, trunc(sum(xtdds) / decode(sum(xtrs), :"SYS_B_06", :"SYS_B_07", sum(xtrs)), :"SYS_B_08") xtxl from (select trunc(t.pickingtime) rq, count(*) jxdds, count(distinct t.pickinguserid) jxrs, :"SYS_B_09" zjdds, :"SYS_B_10" zjrs, :"SYS_B_11" xtdds, :"SYS_B_12" xtrs from salesorder_bill t where t.pickingtime > to_date(:"SYS_B_13", :"SYS_B_14") and t.pickingtime < to_date(:"SYS_B_15", :"SYS_B_16") and t.warehouseid = :"SYS_B_17" group by trunc(t.pickingtime) union all sel
ect trunc(r.QCTIME) rq, :"SYS_B_18", :"SYS_B_19", count(*) zjdds, count(distinct b.posid), :"SYS_B_20", :"SYS_B_21" from salesorder_bill r, picking_bill_his b where r.pickingbillid = b.pickingbillid and r.qctime > to_date(:"SYS_B_22", :"SYS_B_23") and r.qctime < to_date(:"SYS_B_24", :"SYS_B_25") and r.warehouseid = :"SYS_B_26" group by trunc(r.QCTIME) union select trunc(y.QCTIME) rq, :"SYS_B_27", :"SYS_B_28", count(*) zjdds, count(distinct c.posid), :"SYS_B_29", :"SYS_B_30" from salesorder_bill y, picking_bill c where y.pickingbillid = c.pickingbillid and y.qctime > to_date(:"SYS_B_31", :"SYS_B_32") and y.qctime < to_date(:"SYS_B_33", :"SYS_B_34") and y.warehouseid like :"SYS_B_35" group by trunc(y.QCTIME) union select trunc(w.createdate), :"SYS_B_36", :"SYS_B_37
", :"SYS_B_38", :"SYS_B_39", count(*), count(distinct w.confirmuserid) from salesreturn_bill w where w.createdate > to_date(:"SYS_B_40", :"SYS_B_41") and w.createdate < to_date(:"SYS_B_42", :"SYS_B_43") and w.warehouseid = :"SYS_B_44" group by trunc(w.createdate)) y group by rq --order by rq ) tt where :"SYS_B_45"=:"SYS_B_46" AND :"SYS_B_47"=:"SYS_B_48" Order By rq |
4y3n46d9brtxv |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT SALESORDER_BILL.salesoder_codno, SALESORDER_BILL.STATE_DESC, SALESORDER_BILL.MOPOCSALESORDERBILLID, SALESORDER_BILL.OUTERSALESORDERBILLID, SALESORDER_BILL.MOPOCSOURCEORDERBILLID, SALESORDER_BILL.OUTERSOURCEORDERBILLID, SALESORDER_BILL.DELIVERID, SALESORDER_BILL.DELIVERNO, SALESORDER_BILL.DELIVERYMODEID, SALESORDER_BILL.DELIVERYTIME, SALESORDER_BILL.SHOPID, SALESORDER_BILL.OWNERID, SALESORDER_BILL.BUYERNICK, SALESORDER_BILL.BUYEREMAIL, SALESORDER_BILL.BUYERMESSAGE, SALESORDER_BILL.CUSTOMERID, SALESORDER_BILL.RECEIVERNAME, SALESORDER_BILL.RECEIVERADDRESS, SALESORDER_BILL.RECEIVERZIP, SALESORDER_BILL.RECEIVERSTATE, SALESORDER_BILL.RECEIVERCITY, SALESORDER_BILL.RECEIVERDISTRICT, SALESORDER_BILL.RECEIVERMOBILE, SALESORDER_BILL.RECEIVERPHONE, SALESORDER_BILL.PLATFORMID, SALESORDER_BILL.PLATFORMSTATUS, SALESORDER_BILL.ORDERTYPEID, SALESORDER_BILL.INPUTTYPEID, SALESORDER_BILL.WAREHOUSEID, SALESORDER_BILL.ORDER_VARIE
TYQTY, SALESORDER_BILL.ORDER_DETAILQTY, SALESORDER_BILL.ORDER_QTY, SALESORDER_BILL.ORDER_SALEAMOUNT, SALESORDER_BILL.ORDER_WEIGHT, SALESORDER_BILL.ASSIGN_QTY, SALESORDER_BILL.PICKING_QTY, SALESORDER_BILL.QC_VARIETYQTY, SALESORDER_BILL.QC_QTY, SALESORDER_BILL.QC_SALEAMOUNT, SALESORDER_BILL.QC_WEIGHT, SALESORDER_BILL.CONSIGN_VARIETYQTY, SALESORDER_BILL.CONSIGN_QTY, SALESORDER_BILL.CONSIGN_SALEAMOUNT, SALESORDER_BILL.CONSIGN_WEIGHT, SALESORDER_BILL.GOODS_WEIGHT, SALESORDER_BILL.OTHERSGOODS_WEIGHT, SALESORDER_BILL.ORDERTIME, SALESORDER_BILL.ENTERHEADQUARTERSTIME, SALESORDER_BILL.UNITEHEADQUARTERSTIME, SALESORDER_BILL.DISTRIBUTETIME, SALESORDER_BILL.ENTERWAREHOUSETIME, SALESORDER_BILL.UNITEWAREHOUSETIME, SALESORDER_BILL.IMPORTTIME, SALESORDER_BILL.IMPORTUSERID, SALESORDER_BILL.MERGETIME, SALESORDER_BILL.MERGEUSERID, SALESORDER_BILL.WAITINGTIME, SALESORDER_BILL.WAITINGUSERID, SALESORDER_BILL.CANCELWAITINGTIME, SALESORDER_BILL.CANCELWAITINGUSERID, SALESORDER_BIL
L.CANCELORDERTIME, SALESORDER_BILL.CANCELORDERUSERID, SALESORDER_BILL.ACTUALCANCELTIME, SALESORDER_BILL.ACTUALCANCELUSERID, SALESORDER_BILL.ORDERPRINTTIME, SALESORDER_BILL.ORDERPRINTUSERID, SALESORDER_BILL.ASSIGNORDERTIME, SALESORDER_BILL.ASSIGNORDERUSERID, SALESORDER_BILL.PICKINGTIME, SALESORDER_BILL.PICKINGUSERID, SALESORDER_BILL.QCTIME, SALESORDER_BILL.QCUSERID, SALESORDER_BILL.ACTUALSHORTTIME, SALESORDER_BILL.ACTUALSHORTUSERID, SALESORDER_BILL.PACKTIME, SALESORDER_BILL.PACKUSERID, SALESORDER_BILL.WAYBILLTIME, SALESORDER_BILL.WAYBILLUSERID, SALESORDER_BILL.HANDINGTIME, SALESORDER_BILL.HANDINGUSERID, SALESORDER_BILL.CONSIGNTIME, SALESORDER_BILL.CONSIGNUSERID, SALESORDER_BILL.ENDTIME, SALESORDER_BILL.ENDUSERID, SALESORDER_BILL.ACCOUNTDATE, SALESORDER_BILL.ACCOUNTUSERID, SALESORDER_BILL.MODIFIEDTIME, SALESORDER_BILL.SHORTFLAG, SALESORDER_BILL.ACTUALSHORTFLAG, SALESORDER_BILL.UNITEFLAG, SALESORDER_BILL.ACCOUNTFLAG, SALESORDER_BILL.VOUCHERFLAG, SALESORDER_
BILL.INNERSTATUS, SALESORDER_BILL.REFUNDSTATUS, SALESORDER_BILL.STOCKSTATUS, SALESORDER_BILL.RETURNMODEID, SALESORDER_BILL.PAYMENTMODEID, SALESORDER_BILL.REFUND_MODEID, SALESORDER_BILL.PACKAGING_MODEID, SALESORDER_BILL.PACKAGING_COST, SALESORDER_BILL.PACKAGING_SKUID, SALESORDER_BILL.RECEIVABLE_AMOUNT, SALESORDER_BILL.GOODS_PAYMENT, SALESORDER_BILL.DELIVERY_COST, SALESORDER_BILL.INVOICE_AMOUNT, SALESORDER_BILL.ACCOUNT_PAID, SALESORDER_BILL.SHOPPING_VOUCHER, SALESORDER_BILL.ACCOUNT_BALANCE, SALESORDER_BILL.PAYTIME, SALESORDER_BILL.INVOICEFLAG, SALESORDER_BILL.INVOICE_NAME, SALESORDER_BILL.INVOICE_CONTENT, SALESORDER_BILL.ORDER_DISCOUNT, SALESORDER_BILL.GROUPORDERFLAG, SALESORDER_BILL.ADVANCEORDERFLAG, SALESORDER_BILL.PAYMENTFLAG, SALESORDER_BILL.BLENDFLAG, SALESORDER_BILL.RETURNREASONDESC, SALESORDER_BILL.WAYBILLID, SALESORDER_BILL.WAYBILLNO, SALESORDER_BILL.PICKINGBILLID, SALESORDER_BILL.PICKINGBILLNO, SALESORDER_BILL.PICKINGBILLBATCHID, SALESORDER_BILL.PI
CKINGBILLBATCHNO, SALESORDER_BILL.ORDERMOVEINGBILLBATCHID, SALESORDER_BILL.ORDERMOVEINGBILLBATCHNO, SALESORDER_BILL.WAREHOUSEAREAQTY, SALESORDER_BILL.WAREHOUSEAREAWAY, SALESORDER_BILL.CREATETIME, SALESORDER_BILL.UPDATETIME, SALESORDER_BILL.BILL_STATE, SALESORDER_BILL.OLDBILL_STATE, salesorder_bill.costlyflag, salesorder_bill.DANGEROUS_FLAG, salesorder_bill.TRAVELSFLAG, SALESORDER_BILL.batchbillid, SALESORDER_BILL.batchbillno FROM SALESORDER_BILL where WAREHOUSEID=:"SYS_B_0" AND MOPOCSALESORDERBILLID = :"SYS_B_1" Order By MOPOCSALESORDERBILLID) A WHERE ROWNUM <= :"SYS_B_2" ) WHERE RN > :"SYS_B_3" |
578kvyc0rcmm4 |
INSERT INTO WAYBILL_PACKAGE (SYSTEMID, WAYBILL_PACKAGEID, WAYBILL_PACKAGENO, MOPOCSALESORDERBILLID, OUTERSALESORDERBILLID, SHOPID, OWNERID, ORDERTYPEID, WAREHOUSEID, INPUTTYPEID, PACKAGE_VARIETYQTY, PACKAGE_DETAILQTY, PACKAGE_QTY, PACKAGE_SALEAMOUNT, GOODS_WEIGHT, OTHERSGOODS_WEIGHT, CONSIGN_WEIGHT, PACKAGING_SKUID, PACKAGING_COST, RECEIVABLE_AMOUNT, SCANNO, DELIVERID, DELIVERNO, DELIVERNOPRINTFLAG, PRINTNUM, PICKINGBILLID, PICKINGBILLNO, BATCHBILLID, BATCHBILLNO, CREATEUSERID, UPDATEUSERID, CREATETIME, UPDATETIME, BILL_STATE, OLDBILL_STATE, STATE_DESC, PACKAGE_SERIAL, WAYBILLID, WAYBILLNO, POSID, RECEIVERNAME, RECEIVERADDRESS, RECEIVERZIP, RECEIVERSTATE, RECEIVERCITY, RECEIVERDISTRICT, RECEIVERMOBILE, RECEIVERPHONE, INVOICEFLAG, PAYMENTFLAG, COSTLYFLAG, PAYMENTMODEID, BUYERMESSAGE, ORDERTIME, INVOICE_NAME, INVOICE_CONTENT, DELIVERY_COST, PLATFORMID, BOXNO, PICKINGBILLBATCHID, PICKINGBILLBATCHNO, INVOICE_AMOUNT, SALESODER_COD
NO) SELECT P.SYSTEMID, P.WAYBILL_PACKAGEID, P.WAYBILL_PACKAGENO, R.MOPOCSALESORDERBILLID, R.OUTERSALESORDERBILLID, R.SHOPID, R.OWNERID, R.ORDERTYPEID, R.WAREHOUSEID, S.INPUTTYPEID, P.PACKAGE_VARIETYQTY, P.PACKAGE_DETAILQTY, P.PACKAGE_QTY, DECODE(P.PACKAGE_SALEAMOUNT * :B6 * :B5 , 0, 0, (P.PACKAGE_SALEAMOUNT / :B6 * :B5 )), P.GOODS_WEIGHT, 0, 0, NULL, 0, DECODE(S.PAYMENTMODEID, 'COD', S.RECEIVABLE_AMOUNT, 0), NULL, R.DELIVERID, NULL, 'false', 0, R.PICKINGBILLID, R.PICKINGBILLNO, NULL, NULL, :B4 , :B4 , SYSDATE, SYSDATE, R.BILL_STATE, R.BILL_STATE, R.STATE_DESC, :B3 , R.WAYBILLID, R.WAYBILLNO, :B2 , R.RECEIVERNAME, R.RECEIVERADDRESS, R.RECEIVERZIP, R.RECEIVERSTATE, R.RECEIVERCITY, R.RECEIVERDISTRICT, R.RECEIVERMOBILE, R.RECEIVERPHONE, R.INVOICEFLAG, R.PAYMENTFLAG, R.COSTLYFLAG, R.PAYMENTMODEID, R.BUYERMESSAGE, R.ORDERTIME, S.INVOICE_NAME, S.INVOICE_CONTENT, S.DELIVERY_COST, S.PLATFORMID, R.BOXNO, R.PICKINGBILLBATCHID, R.PI
CKINGBILLBATCHNO, S.INVOICE_AMOUNT, S.SALESODER_CODNO FROM (SELECT COUNT(DISTINCT T.SKUID) PACKAGE_VARIETYQTY, COUNT(1) PACKAGE_DETAILQTY, SUM(T.PACKAGE_QTY) PACKAGE_QTY, SUM(NVL(T.PACKAGE_SALEAMOUNT, 0)) PACKAGE_SALEAMOUNT, SUM(T.QC_WEIGHT) GOODS_WEIGHT, T.MOPOCSALESORDERBILLID, T.WAYBILL_PACKAGEID, T.WAYBILL_PACKAGENO, T.SYSTEMID FROM WAYBILLDETAIL_PACKAGE T WHERE T.WAYBILL_PACKAGEID = :B1 GROUP BY T.MOPOCSALESORDERBILLID, T.WAYBILL_PACKAGEID, T.WAYBILL_PACKAGENO, T.SYSTEMID) P, WAYBILL_CONSIGN R, SALESORDER_BILL S WHERE P.MOPOCSALESORDERBILLID = R.MOPOCSALESORDERBILLID AND R.MOPOCSALESORDERBILLID = S.MOPOCSALESORDERBILLID |
5hwdf0wvghfcw | UPDATE SALESORDER_BILL T SET T.OLDBILL_STATE = T.BILL_STATE, T.BILL_STATE = '02', T.STATE_DESC = '订单汇总', T.MERGETIME = SYSDATE, T.MERGEUSERID = :B1 , (T.ASSIGN_QTY, T.PICKINGBILLID, T.PICKINGBILLNO) = (SELECT YD.ASSIGN_QTY, YD.PICKINGBILLID, YD.PICKINGBILLNO FROM WAYBILL_LEADIN_TEMP YD WHERE YD.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID) WHERE EXISTS (SELECT 1 FROM WAYBILL_LEADIN_TEMP S WHERE S.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID) |
6182rs2up50j6 | begin Waybill_Package_Packing(AS_SYSTEMID=>:AS_SYSTEMID, AS_BATCHID=>:AS_BATCHID, AS_BATCHNO=>:AS_BATCHNO, AS_USERID=>:AS_USERID, DESCERR=>:DESCERR); end; |
6mcpb06rctk0x | call dbms_space.auto_space_advisor_job_proc ( ) |
7a5jkcsq9rghb |
insert into if_base_goodsinfo (goodsid, skuid, productid, brandid, goodsno, goodsbarcode, goodsname, snno, displayname, englishname, marketprice, mnemoniccode, keyword, goodstypeid, statisticid, sexpropertyid, seasonpropertyid, agepropertyid, salepropertyid, colorpropertyid, unitrpropertyid, gradepropertyid, stylepropertyid, levelpropertyid, managepropertyid, registered_trademark, warrantyflag, warranty, approval_code, place_production, manufacturer, manufacturergoodsno, taxrate, accountrate, marketingtypeid, remark, prodescription, marketdate, freight, specification, costlyflag, weight, length, width, heigth, volume, partitionqty, partitionrate, partitionflag, logisticsflag, jitflag, snflag, pubflag, pubdate, pubuserid, enableflag, enableuserid, enabledate, disableuserid, disabledate, createuserid, createdate, updateuserid, updatedate, dangerflag, ownerid) values(:goodsid, :skuid, :productid, :brandid, :goodsno, :goodsbarcode, :goodsname, :snno, :displayname, :englishname, :mark
etprice, :mnemoniccode, :keyword, :goodstypeid, :statisticid, :sexpropertyid, :seasonpropertyid, :agepropertyid, :salepropertyid, :colorpropertyid, :unitrpropertyid, :gradepropertyid, :stylepropertyid, :levelpropertyid, :managepropertyid, :registered_trademark, :warrantyflag, :warranty, :approval_code, :place_production, :manufacturer, :manufacturergoodsno, :taxrate, :accountrate, :marketingtypeid, :remark, :prodescription, :marketdate, :freight, :specification, :costlyflag, :weight, :length, :width, :heigth, :volume, :partitionqty, :partitionrate, :partitionflag, :logisticsflag, :jitflag, :snflag, :pubflag, :pubdate, :pubuserid, :enableflag, :enableuserid, :enabledate, :disableuserid, :disabledate, :createuserid, :createdate, :updateuserid, :updatedate, :dangerousflag, :ownerid) |
7d9bcscmbwshd | begin Picking_Bill_Sure30(AS_SYSTEMID=>:AS_SYSTEMID, AS_PICKINGBILLID=>:AS_PICKINGBILLID, AS_PICKINGBILLNO=>:AS_PICKINGBILLNO, AS_BILLSTATE=>:AS_BILLSTATE, AS_USERID=>:AS_USERID, RFJXFLAG=>:RFJXFLAG, WAYBILLFRONTFLAG=>:WAYBILLFRONTFLAG, DESCERR=>:DESCERR); end; |
7h38rm3myd747 |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT SALESORDER_BILL.salesoder_codno, SALESORDER_BILL.STATE_DESC, SALESORDER_BILL.MOPOCSALESORDERBILLID, SALESORDER_BILL.OUTERSALESORDERBILLID, SALESORDER_BILL.MOPOCSOURCEORDERBILLID, SALESORDER_BILL.OUTERSOURCEORDERBILLID, SALESORDER_BILL.DELIVERID, SALESORDER_BILL.DELIVERNO, SALESORDER_BILL.DELIVERYMODEID, SALESORDER_BILL.DELIVERYTIME, SALESORDER_BILL.SHOPID, SALESORDER_BILL.OWNERID, SALESORDER_BILL.BUYERNICK, SALESORDER_BILL.BUYEREMAIL, SALESORDER_BILL.BUYERMESSAGE, SALESORDER_BILL.CUSTOMERID, SALESORDER_BILL.RECEIVERNAME, SALESORDER_BILL.RECEIVERADDRESS, SALESORDER_BILL.RECEIVERZIP, SALESORDER_BILL.RECEIVERSTATE, SALESORDER_BILL.RECEIVERCITY, SALESORDER_BILL.RECEIVERDISTRICT, SALESORDER_BILL.RECEIVERMOBILE, SALESORDER_BILL.RECEIVERPHONE, SALESORDER_BILL.PLATFORMID, SALESORDER_BILL.PLATFORMSTATUS, SALESORDER_BILL.ORDERTYPEID, SALESORDER_BILL.INPUTTYPEID, SALESORDER_BILL.WAREHOUSEID, SALESORDER_BILL.ORDER_VARIE
TYQTY, SALESORDER_BILL.ORDER_DETAILQTY, SALESORDER_BILL.ORDER_QTY, SALESORDER_BILL.ORDER_SALEAMOUNT, SALESORDER_BILL.ORDER_WEIGHT, SALESORDER_BILL.ASSIGN_QTY, SALESORDER_BILL.PICKING_QTY, SALESORDER_BILL.QC_VARIETYQTY, SALESORDER_BILL.QC_QTY, SALESORDER_BILL.QC_SALEAMOUNT, SALESORDER_BILL.QC_WEIGHT, SALESORDER_BILL.CONSIGN_VARIETYQTY, SALESORDER_BILL.CONSIGN_QTY, SALESORDER_BILL.CONSIGN_SALEAMOUNT, SALESORDER_BILL.CONSIGN_WEIGHT, SALESORDER_BILL.GOODS_WEIGHT, SALESORDER_BILL.OTHERSGOODS_WEIGHT, SALESORDER_BILL.ORDERTIME, SALESORDER_BILL.ENTERHEADQUARTERSTIME, SALESORDER_BILL.UNITEHEADQUARTERSTIME, SALESORDER_BILL.DISTRIBUTETIME, SALESORDER_BILL.ENTERWAREHOUSETIME, SALESORDER_BILL.UNITEWAREHOUSETIME, SALESORDER_BILL.IMPORTTIME, SALESORDER_BILL.IMPORTUSERID, SALESORDER_BILL.MERGETIME, SALESORDER_BILL.MERGEUSERID, SALESORDER_BILL.WAITINGTIME, SALESORDER_BILL.WAITINGUSERID, SALESORDER_BILL.CANCELWAITINGTIME, SALESORDER_BILL.CANCELWAITINGUSERID, SALESORDER_BIL
L.CANCELORDERTIME, SALESORDER_BILL.CANCELORDERUSERID, SALESORDER_BILL.ACTUALCANCELTIME, SALESORDER_BILL.ACTUALCANCELUSERID, SALESORDER_BILL.ORDERPRINTTIME, SALESORDER_BILL.ORDERPRINTUSERID, SALESORDER_BILL.ASSIGNORDERTIME, SALESORDER_BILL.ASSIGNORDERUSERID, SALESORDER_BILL.PICKINGTIME, SALESORDER_BILL.PICKINGUSERID, SALESORDER_BILL.QCTIME, SALESORDER_BILL.QCUSERID, SALESORDER_BILL.ACTUALSHORTTIME, SALESORDER_BILL.ACTUALSHORTUSERID, SALESORDER_BILL.PACKTIME, SALESORDER_BILL.PACKUSERID, SALESORDER_BILL.WAYBILLTIME, SALESORDER_BILL.WAYBILLUSERID, SALESORDER_BILL.HANDINGTIME, SALESORDER_BILL.HANDINGUSERID, SALESORDER_BILL.CONSIGNTIME, SALESORDER_BILL.CONSIGNUSERID, SALESORDER_BILL.ENDTIME, SALESORDER_BILL.ENDUSERID, SALESORDER_BILL.ACCOUNTDATE, SALESORDER_BILL.ACCOUNTUSERID, SALESORDER_BILL.MODIFIEDTIME, SALESORDER_BILL.SHORTFLAG, SALESORDER_BILL.ACTUALSHORTFLAG, SALESORDER_BILL.UNITEFLAG, SALESORDER_BILL.ACCOUNTFLAG, SALESORDER_BILL.VOUCHERFLAG, SALESORDER_
BILL.INNERSTATUS, SALESORDER_BILL.REFUNDSTATUS, SALESORDER_BILL.STOCKSTATUS, SALESORDER_BILL.RETURNMODEID, SALESORDER_BILL.PAYMENTMODEID, SALESORDER_BILL.REFUND_MODEID, SALESORDER_BILL.PACKAGING_MODEID, SALESORDER_BILL.PACKAGING_COST, SALESORDER_BILL.PACKAGING_SKUID, SALESORDER_BILL.RECEIVABLE_AMOUNT, SALESORDER_BILL.GOODS_PAYMENT, SALESORDER_BILL.DELIVERY_COST, SALESORDER_BILL.INVOICE_AMOUNT, SALESORDER_BILL.ACCOUNT_PAID, SALESORDER_BILL.SHOPPING_VOUCHER, SALESORDER_BILL.ACCOUNT_BALANCE, SALESORDER_BILL.PAYTIME, SALESORDER_BILL.INVOICEFLAG, SALESORDER_BILL.INVOICE_NAME, SALESORDER_BILL.INVOICE_CONTENT, SALESORDER_BILL.ORDER_DISCOUNT, SALESORDER_BILL.GROUPORDERFLAG, SALESORDER_BILL.ADVANCEORDERFLAG, SALESORDER_BILL.PAYMENTFLAG, SALESORDER_BILL.BLENDFLAG, SALESORDER_BILL.RETURNREASONDESC, SALESORDER_BILL.WAYBILLID, SALESORDER_BILL.WAYBILLNO, SALESORDER_BILL.PICKINGBILLID, SALESORDER_BILL.PICKINGBILLNO, SALESORDER_BILL.PICKINGBILLBATCHID, SALESORDER_BILL.PI
CKINGBILLBATCHNO, SALESORDER_BILL.ORDERMOVEINGBILLBATCHID, SALESORDER_BILL.ORDERMOVEINGBILLBATCHNO, SALESORDER_BILL.WAREHOUSEAREAQTY, SALESORDER_BILL.WAREHOUSEAREAWAY, SALESORDER_BILL.CREATETIME, SALESORDER_BILL.UPDATETIME, SALESORDER_BILL.BILL_STATE, SALESORDER_BILL.OLDBILL_STATE, salesorder_bill.costlyflag, salesorder_bill.DANGEROUS_FLAG, salesorder_bill.TRAVELSFLAG, SALESORDER_BILL.batchbillid, SALESORDER_BILL.batchbillno FROM SALESORDER_BILL where WAREHOUSEID=:"SYS_B_0" AND RECEIVERMOBILE Like :"SYS_B_1" Order By MOPOCSALESORDERBILLID) A WHERE ROWNUM <= :"SYS_B_2" ) WHERE RN > :"SYS_B_3" |
7k8g2vt2m1c8p |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM ( Select WAYBILL_LEADIN.SYSTEMID, WAYBILL_LEADIN.PAYTIME, WAYBILL_LEADIN.MOPOCSALESORDERBILLID, WAYBILL_LEADIN.OUTERSALESORDERBILLID, WAYBILL_LEADIN.MOPOCSOURCEORDERBILLID, WAYBILL_LEADIN.OUTERSOURCEORDERBILLID, WAYBILL_LEADIN.WAYBILLID, WAYBILL_LEADIN.WAYBILLNO, WAYBILL_LEADIN.SHOPID, WAYBILL_LEADIN.OWNERID, WAYBILL_LEADIN.ORDERTYPEID, WAYBILL_LEADIN.WAREHOUSEID, WAYBILL_LEADIN.JXFQID, WAYBILL_LEADIN.BOXNO, WAYBILL_LEADIN.ORDER_VARIETYQTY, WAYBILL_LEADIN.ORDER_DETAILQTY, WAYBILL_LEADIN.ORDER_QTY, WAYBILL_LEADIN.ASSIGN_QTY, WAYBILL_LEADIN.RECEIVABLE_AMOUNT, WAYBILL_LEADIN.RECEIVERNAME, WAYBILL_LEADIN.RECEIVERADDRESS, WAYBILL_LEADIN.RECEIVERZIP, WAYBILL_LEADIN.RECEIVERSTATE, WAYBILL_LEADIN.RECEIVERCITY, WAYBILL_LEADIN.RECEIVERDISTRICT, WAYBILL_LEADIN.RECEIVERMOBILE, WAYBILL_LEADIN.RECEIVERPHONE, WAYBILL_LEADIN.ORDERTIME, WAYBILL_LEADIN.DELIVERYTIME, WAYBILL_LEADIN.DELIVERID, WAYBILL_LEADIN.GROUPORDERFLAG, WAYBILL_LE
ADIN.INVOICEFLAG, WAYBILL_LEADIN.ADVANCEORDERFLAG, WAYBILL_LEADIN.PAYMENTFLAG, WAYBILL_LEADIN.BLENDFLAG, WAYBILL_LEADIN.PICKINGBILLID, WAYBILL_LEADIN.PICKINGBILLNO, WAYBILL_LEADIN.PICKINGBILLBATCHID, WAYBILL_LEADIN.PICKINGBILLBATCHNO, WAYBILL_LEADIN.WAREHOUSEAREAQTY, WAYBILL_LEADIN.WAREHOUSEAREAWAY, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHID, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHNO, WAYBILL_LEADIN.CREATEUSERID, WAYBILL_LEADIN.UPDATEUSERID, WAYBILL_LEADIN.CREATETIME, WAYBILL_LEADIN.UPDATETIME, WAYBILL_LEADIN.BILL_STATE, WAYBILL_LEADIN.OLDBILL_STATE, WAYBILL_LEADIN.STATE_DESC , WAYBILL_LEADIN.costlyflag , WAYBILL_LEADIN.Paymentmodeid, WAYBILL_LEADIN.Buyermessage, :"SYS_B_00" as selectedflag, WAYBILL_LEADIN.INPUTTYPEID, WAYBILL_LEADIN.ORDER_SALEAMOUNT, WAYBILL_LEADIN.PLATFORMID, WAYBILL_LEADIN.CUSTOMER_MESSAGE From WAYBILL_LEADIN Where :"SYS_B_01"=:"SYS_B_02" And ALLOT_OCCUPY_FLAG = :"SYS_B_03" and WAREHOUSEID=:"SYS_B_04
" and nvl(DELIVERID, :"SYS_B_05") = :"SYS_B_06" And (WAYBILL_LEADIN.OWNERID =:"SYS_B_07") and Not Exists ( Select :"SYS_B_08" From Base_Shopgroup, Base_Shopgroup_Shop Where Base_Shopgroup.Shopgroupid = Base_Shopgroup_Shop.Shopgroupid And Base_Shopgroup_Shop.Enableflag = :"SYS_B_09" And Base_Shopgroup.Enableflag = :"SYS_B_10" And Base_Shopgroup_Shop.Shopid = Waybill_Leadin.Shopid And Base_Shopgroup_Shop.warehouseid = Waybill_Leadin.warehouseid ) And SHOPID in (:"SYS_B_11") Order By WAYBILL_LEADIN.BILL_STATE asc , WAYBILL_LEADIN.paytime asc, WAYBILL_LEADIN.MOPOCSALESORDERBILLID asc ) A WHERE ROWNUM <= :"SYS_B_12" ) WHERE RN > :"SYS_B_13" |
7wahvsbqhx79c | begin Salesorder_Collect31(AS_SYSTEMID=>:AS_SYSTEMID, AS_WAREHOUSEID=>:AS_WAREHOUSEID, AS_USERID=>:AS_USERID, AS_HHZD=>:AS_HHZD, AS_WHERE=>:AS_WHERE, AS_ROWNUMWHERE=>:AS_ROWNUMWHERE, DESCERR=>:DESCERR); end; |
84k2mp6rgxpy6 | UPDATE SALESORDER_BILL T SET T.ORDERPRINTTIME = SYSDATE, T.ORDERPRINTUSERID = :B3 , T.PICKINGBILLID = NVL(T.PICKINGBILLID, :B2 ), T.PICKINGBILLNO = NVL(T.PICKINGBILLNO, :B1 ) WHERE EXISTS (SELECT 1 FROM PICKING_BILLSOURCE S WHERE S.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID AND S.PICKINGBILLID = :B2 ) |
855ujr57gfudb |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM ( Select WAYBILL_LEADIN.SYSTEMID, WAYBILL_LEADIN.PAYTIME, WAYBILL_LEADIN.MOPOCSALESORDERBILLID, WAYBILL_LEADIN.OUTERSALESORDERBILLID, WAYBILL_LEADIN.MOPOCSOURCEORDERBILLID, WAYBILL_LEADIN.OUTERSOURCEORDERBILLID, WAYBILL_LEADIN.WAYBILLID, WAYBILL_LEADIN.WAYBILLNO, WAYBILL_LEADIN.SHOPID, WAYBILL_LEADIN.OWNERID, WAYBILL_LEADIN.ORDERTYPEID, WAYBILL_LEADIN.WAREHOUSEID, WAYBILL_LEADIN.JXFQID, WAYBILL_LEADIN.BOXNO, WAYBILL_LEADIN.ORDER_VARIETYQTY, WAYBILL_LEADIN.ORDER_DETAILQTY, WAYBILL_LEADIN.ORDER_QTY, WAYBILL_LEADIN.ASSIGN_QTY, WAYBILL_LEADIN.RECEIVABLE_AMOUNT, WAYBILL_LEADIN.RECEIVERNAME, WAYBILL_LEADIN.RECEIVERADDRESS, WAYBILL_LEADIN.RECEIVERZIP, WAYBILL_LEADIN.RECEIVERSTATE, WAYBILL_LEADIN.RECEIVERCITY, WAYBILL_LEADIN.RECEIVERDISTRICT, WAYBILL_LEADIN.RECEIVERMOBILE, WAYBILL_LEADIN.RECEIVERPHONE, WAYBILL_LEADIN.ORDERTIME, WAYBILL_LEADIN.DELIVERYTIME, WAYBILL_LEADIN.DELIVERID, WAYBILL_LEADIN.GROUPORDERFLAG, WAYBILL_LE
ADIN.INVOICEFLAG, WAYBILL_LEADIN.ADVANCEORDERFLAG, WAYBILL_LEADIN.PAYMENTFLAG, WAYBILL_LEADIN.BLENDFLAG, WAYBILL_LEADIN.PICKINGBILLID, WAYBILL_LEADIN.PICKINGBILLNO, WAYBILL_LEADIN.PICKINGBILLBATCHID, WAYBILL_LEADIN.PICKINGBILLBATCHNO, WAYBILL_LEADIN.WAREHOUSEAREAQTY, WAYBILL_LEADIN.WAREHOUSEAREAWAY, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHID, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHNO, WAYBILL_LEADIN.CREATEUSERID, WAYBILL_LEADIN.UPDATEUSERID, WAYBILL_LEADIN.CREATETIME, WAYBILL_LEADIN.UPDATETIME, WAYBILL_LEADIN.BILL_STATE, WAYBILL_LEADIN.OLDBILL_STATE, WAYBILL_LEADIN.STATE_DESC , WAYBILL_LEADIN.costlyflag , WAYBILL_LEADIN.Paymentmodeid, WAYBILL_LEADIN.Buyermessage, :"SYS_B_00" as selectedflag, WAYBILL_LEADIN.INPUTTYPEID, WAYBILL_LEADIN.ORDER_SALEAMOUNT, WAYBILL_LEADIN.PLATFORMID, WAYBILL_LEADIN.CUSTOMER_MESSAGE From WAYBILL_LEADIN Where :"SYS_B_01"=:"SYS_B_02" And ALLOT_OCCUPY_FLAG = :"SYS_B_03" and WAREHOUSEID=:"SYS_B_04
" and nvl(DELIVERID, :"SYS_B_05") = :"SYS_B_06" And (WAYBILL_LEADIN.OWNERID =:"SYS_B_07") and Not Exists ( Select :"SYS_B_08" From Base_Shopgroup, Base_Shopgroup_Shop Where Base_Shopgroup.Shopgroupid = Base_Shopgroup_Shop.Shopgroupid And Base_Shopgroup_Shop.Enableflag = :"SYS_B_09" And Base_Shopgroup.Enableflag = :"SYS_B_10" And Base_Shopgroup_Shop.Shopid = Waybill_Leadin.Shopid And Base_Shopgroup_Shop.warehouseid = Waybill_Leadin.warehouseid ) Order By WAYBILL_LEADIN.BILL_STATE asc , WAYBILL_LEADIN.paytime asc, WAYBILL_LEADIN.MOPOCSALESORDERBILLID asc ) A WHERE ROWNUM <= :"SYS_B_11" ) WHERE RN > :"SYS_B_12" |
8ht8yrs78xj49 | begin Create_Waybillpackage30(AS_SYSTEMID=>:AS_SYSTEMID, AS_ORDERBILLID=>:AS_ORDERBILLID, AS_BILLSTATE=>:AS_BILLSTATE, AS_USERID=>:AS_USERID, AS_WAREHOUSEID=>:AS_WAREHOUSEID, AS_POSID=>:AS_POSID, AS_OUTERBILLID=>:AS_OUTERBILLID, DESCERR=>:DESCERR); end; |
8mqu64chw8cmd |
Select Z.Mopocsalesorderbillid, Z.Outersalesorderbillid, Z.Invoice_Amount, Z.Invoice_Name, Z.Invoice_Content, Z.Ordertime, Z.Package_Saleamount, S.Skuid, S.Goodsbarcode, S.Goodsname, G.Package_Qty, G.Saleprice, G.Package_Saleamount, Z.Receivername, z.Posid, Z.Invoiceflag, Z.Shopid, Z.Waybill_Packageid, Z.Waybill_Packageno, Z.Package_Serial, Z.Package_Number, nvl((Select h.Waybill_Packageno From Waybill_Package h Where h.Mopocsalesorderbillid = Z.Mopocsalesorderbillid And h.Package_Serial = :"SYS_B_0"), :"SYS_B_1") Fpbg, F.Ksdz_Printflag, F.Ksdz, z.boxno, p.province_name, c.city_name, q.area_name, z.receiveraddress, z.receivermobile, z.receiverphone, d.account_paid, d.order_saleamount, d.Delivery_Cost, d.receivable_amount, z.Outersalesorderbillid sbrv27_compute_1, --条码为外部单号 s.goodsname sbrv27_compute_5, g.saleprice * g.PACKAGE_QTY sbrv27_detail_total, s.skuid sbrv27_compute_4, rownum sbrv27_compute_7, g.package_qty sbrv27_comp
ute_2, g.saleprice * g.PACKAGE_QTY sbrv27_compute_6, decode(d.account_paid, null, :"SYS_B_2", d.account_paid) sbrv27_compute_3 From Waybilldetail_Package g Left Join Waybill_Package z On Z.Waybill_Packageid = G.Waybill_Packageid Left Join Base_Goodsinfo s On S.Skuid = G.Skuid Left Join Base_Owner_Forhaitao f On F.Warehouseid = Z.Warehouseid And F.Platformid = Z.Platformid And F.Ownerid = Z.Ownerid Left Join Base_Province p On p.Province_Id = Z.Receiverstate Left Join Base_City c On C.City_Id = Z.Receivercity Left Join Base_Area q On Q.Area_Id = Z.Receiverdistrict Left Join salesorder_bill d On D.MOPOCSALESORDERBILLID = z.mopocsalesorderbillid Where G.Waybill_Packageid = :Arg_Billid |
8q1r67mcuxg6f | begin Sorting_Bill_Sure30(AS_SYSTEMID=>:AS_SYSTEMID, AS_SORTINGBILLID=>:AS_SORTINGBILLID, AS_SORTINGBILLNO=>:AS_SORTINGBILLNO, AS_POSID=>:AS_POSID, AS_SORTINGUSERID=>:AS_SORTINGUSERID, AS_USERID=>:AS_USERID, AS_BILLSTATE=>:AS_BILLSTATE, DESCERR=>:DESCERR); end; |
8szmwam7fysa3 | insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE')) |
98t4azsnjmvp0 |
SELECT (case when plan_qty > return_qty then :"SYS_B_00" else :"SYS_B_01" end) FINISHFLAG, SALESRETURN_BILL.SYSTEMID, SALESRETURN_BILL.SALESRETURNBILLID, SALESRETURN_BILL.SALESRETURNBILLNO, SALESRETURN_BILL.SALESRETURNBILLBATCHID, SALESRETURN_BILL.SALESRETURNBILLBATCHNO, SALESRETURN_BILL.SALESORDERID, SALESRETURN_BILL.OUTERSALESORDERID, SALESRETURN_BILL.ORDERTYPEID, SALESRETURN_BILL.OLDSALESORDERID, SALESRETURN_BILL.OLDOUTSALESORDERID, SALESRETURN_BILL.POSID, SALESRETURN_BILL.OUTWAREHOUSEID, SALESRETURN_BILL.WAREHOUSEID, SALESRETURN_BILL.WAREHOUSEAREAID, SALESRETURN_BILL.CARGOSPACEID, SALESRETURN_BILL.SALESRETURNTYPEID, SALESRETURN_BILL.SALESRETURNREASONID, SALESRETURN_BILL.EXPRESSDELIVERYID, SALESRETURN_BILL.WAYBILLNO, SALESRETURN_BILL.PLAN_VARIETYQTY, SALESRETURN_BILL.PLAN_QTY, SALESRETURN_BILL.PLAN_PRICEAMOUNT, SALESRETURN_BILL.PLAN_SALEAMOUNT, SALESRETURN_BILL.PLAN_WEIGHT, SALESRETURN_BILL.RETURN_VARIETYQTY, SALESRETURN_BILL.RETURN_Q
TY, SALESRETURN_BILL.RETURN_PRICEAMOUNT, SALESRETURN_BILL.RETURN_SALEAMOUNT, SALESRETURN_BILL.RETURN_WEIGHT, SALESRETURN_BILL.DAMAGE_VARIETYQTY, SALESRETURN_BILL.DAMAGE_QTY, SALESRETURN_BILL.DAMAGE_PRICEMOUNT, SALESRETURN_BILL.DAMAGE_SALEAMOUNT, SALESRETURN_BILL.DAMAGE_WEIGHT, SALESRETURN_BILL.REMARK, SALESRETURN_BILL.CREATEDATE, SALESRETURN_BILL.CONFIRMDATE, SALESRETURN_BILL.SHELVEDATE, SALESRETURN_BILL.ACCOUNTDATE, SALESRETURN_BILL.CREATEUSERID, SALESRETURN_BILL.CONFIRMUSERID, SALESRETURN_BILL.SHELVEUSERID, SALESRETURN_BILL.ACCOUNTUSERID, SALESRETURN_BILL.INPUTFLAG, SALESRETURN_BILL.BILL_STATE, SALESRETURN_BILL.OLDBILL_STATE, SALESRETURN_BILL.STATE_DESC, salesreturn_inorder.RECEIVERNAME, salesreturn_inorder.RECEIVERMOBILE, salesreturn_inorder.RECEIVERPHONE, salesreturn_inorder.receiveraddress , dp.companyname dp, hz.companyname hz, salesreturn_bill.costlyflag, t.DELIVERNO, t.ownerid, t.shopid FROM SALESRETURN_BILL left join salesorder_bill t on t.mopocsal
esorderbillid = SALESRETURN_BILL.Oldsalesorderid left join base_company hz on hz.companyid = t.ownerid left join base_company dp on dp.companyid = t.shopid left join salesreturn_inorder on SALESRETURN_BILL.salesorderid=salesreturn_inorder.mopocsalesorderbillid where :"SYS_B_02" =:"SYS_B_03" and (SALESRETURN_BILL.OLDSALESORDERID = t.MOPOCSALESORDERBILLID) AND (SALESRETURN_BILL.SALESRETURNBILLBATCHID = :"SYS_B_04" OR (SALESRETURN_BILL.SALESRETURNBILLBATCHID = :"SYS_B_05" AND SALESRETURN_BILL.BILL_STATE = :"SYS_B_06")) AND (SALESRETURN_BILL.SALESRETURNTYPEID NOT IN ( :"SYS_B_07", :"SYS_B_08")) AND (SALESRETURN_BILL.WAREHOUSEID = :"SYS_B_09") and salesreturn_bill.oldsalesorderid like :"SYS_B_10" |
9arsdb1fdbbky |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM ( SELECT STOCKOUT_DETAIL.SYSTEMID, STOCKOUT_DETAIL.STOCKOUTSTATE, STOCKOUT_DETAIL.STOCKOUTDETAILID, STOCKOUT_DETAIL.SOURCETYPEID, STOCKOUT_DETAIL.SOURCEBILLID, STOCKOUT_DETAIL.SOURCEBILLNO, STOCKOUT_DETAIL.SOURCEBILLDETAILID, STOCKOUT_DETAIL.OWNERID, STOCKOUT_DETAIL.DEPARTMENTID, STOCKOUT_DETAIL.WAREHOUSEID, STOCKOUT_DETAIL.STOCKOUTTYPEID, STOCKOUT_DETAIL.STOCKOUTRANKID, STOCKOUT_DETAIL.SKUID, STOCKOUT_DETAIL.PRICE, STOCKOUT_DETAIL.QTY, STOCKOUT_DETAIL.QTY_PRICEAMOUNT, STOCKOUT_DETAIL.CREATEUSERID, STOCKOUT_DETAIL.CREATEDATE, STOCKOUT_DETAIL.CHECKUSERID, STOCKOUT_DETAIL.CHECKDATE, STOCKOUT_DETAIL.UPDATEUSERID, STOCKOUT_DETAIL.UPDATEDATE, STOCKOUT_DETAIL.BILL_STATE, STOCKOUT_DETAIL.OLDBILL_STATE, STOCKOUT_DETAIL.STATE_DESC, BASE_GOODSINFO.GOODSNAME , BASE_GOODSINFO.GOODSNO , BASE_GOODSINFO.GOODSBARCODE , :"SYS_B_0" as selectedflag FROM STOCKOUT_DETAIL, BASE_GOODSINFO WHERE ( STOCKOUT_DETAIL.SKUID = BASE_GOODSINFO.SKUID(+) ) and (STOCK
OUT_DETAIL.BILL_STATE=:"SYS_B_1") and Stockout_Detail.warehouseid=:"SYS_B_2" and Stockout_Detail.ownerid=:"SYS_B_3" Order By STOCKOUTDETAILID desc) A WHERE ROWNUM <= :"SYS_B_4" ) WHERE RN > :"SYS_B_5" |
9ft6j9dzp08fu | DELETE FROM SALESORDER_BILL_INTERCEPT_TEMP |
9hy85jupdj6qt |
select count(:"SYS_B_0") from (SELECT WAYBILL_HANDINGBATCH.BATCHBILLID, WAYBILL_HANDINGBATCH.BATCHBILLNO, WAYBILL_HANDINGBATCH.RF_FLAG, WAYBILL_HANDINGBATCH.WAREHOUSEID, WAYBILL_HANDINGBATCH.DELIVERID, WAYBILL_HANDINGBATCH.POSID, WAYBILL_HANDINGBATCH.DEVICE_CODE, WAYBILL_HANDINGBATCH.ORDERBILL_QTY, WAYBILL_HANDINGBATCH.PRINTFLAG, WAYBILL_HANDINGBATCH.PRINTNUM, WAYBILL_HANDINGBATCH.PRINTDATE, WAYBILL_HANDINGBATCH.PRINTUSERID, WAYBILL_HANDINGBATCH.TRUCK_NUMBER, WAYBILL_HANDINGBATCH.TRUCK_PEOPLE, WAYBILL_HANDINGBATCH.HANDINGUSERID, WAYBILL_HANDINGBATCH.HANDINGTIME, WAYBILL_HANDINGBATCH.CREATEUSERID, WAYBILL_HANDINGBATCH.CREATETIME, WAYBILL_HANDINGBATCH.BILL_STATE, WAYBILL_HANDINGBATCH.OLDBILL_STATE, WAYBILL_HANDINGBATCH.STATE_DESC, WAYBILL_HANDINGBATCH.WEIGHT_TOTAL, WAYBILL_HANDINGBATCH.FINISHDATE, WAYBILL_HANDINGBATCH.FINISHUSERID FROM WAYBILL_HANDINGBATCH where :"SYS_B_1"=:"SYS_B_2" AND WAYBILL_HANDINGBATCH.WAREHOUSEID=:"SYS_B_3
" and WAYBILL_HANDINGBATCH.deliverid=:"SYS_B_4" Order By BATCHBILLNO desc, STATE_DESC) |
9rdgpzbfxaz5w |
INSERT INTO WAYBILL_PACKAGE (SYSTEMID, WAYBILL_PACKAGEID, WAYBILL_PACKAGENO, MOPOCSALESORDERBILLID, OUTERSALESORDERBILLID, SHOPID, OWNERID, ORDERTYPEID, WAREHOUSEID, INPUTTYPEID, PACKAGE_VARIETYQTY, PACKAGE_DETAILQTY, PACKAGE_QTY, PACKAGE_SALEAMOUNT, GOODS_WEIGHT, OTHERSGOODS_WEIGHT, CONSIGN_WEIGHT, PACKAGING_SKUID, PACKAGING_COST, RECEIVABLE_AMOUNT, SCANNO, DELIVERID, DELIVERNO, DELIVERNOPRINTFLAG, PRINTNUM, PICKINGBILLID, PICKINGBILLNO, BATCHBILLID, BATCHBILLNO, CREATEUSERID, UPDATEUSERID, CREATETIME, UPDATETIME, BILL_STATE, OLDBILL_STATE, STATE_DESC, PACKAGE_SERIAL, WAYBILLID, WAYBILLNO, POSID, RECEIVERNAME, RECEIVERADDRESS, RECEIVERZIP, RECEIVERSTATE, RECEIVERCITY, RECEIVERDISTRICT, RECEIVERMOBILE, RECEIVERPHONE, INVOICEFLAG, PAYMENTFLAG, COSTLYFLAG, PAYMENTMODEID, BUYERMESSAGE, ORDERTIME, INVOICE_NAME, INVOICE_CONTENT, DELIVERY_COST, PLATFORMID, BOXNO, PICKINGBILLBATCHID, PICKINGBILLBATCHNO, INVOICE_AMOUNT, PACKAGE_NUMB
ER, SALESODER_CODNO) SELECT P.SYSTEMID, :B1 , :B4 , R.MOPOCSALESORDERBILLID, R.OUTERSALESORDERBILLID, R.SHOPID, R.OWNERID, R.ORDERTYPEID, R.WAREHOUSEID, S.INPUTTYPEID, P.PACKAGE_VARIETYQTY, P.PACKAGE_DETAILQTY, P.PACKAGE_QTY, R.ORDER_SALEAMOUNT, P.GOODS_WEIGHT, 0, 0, NULL, 0, DECODE(S.PAYMENTMODEID, 'COD', S.RECEIVABLE_AMOUNT, 0), NULL, R.DELIVERID, R.WAYBILLID, 'false', 0, R.PICKINGBILLID, R.PICKINGBILLNO, NULL, NULL, :B3 , :B3 , SYSDATE, SYSDATE, R.BILL_STATE, R.BILL_STATE, R.STATE_DESC, 1, R.WAYBILLID, R.WAYBILLNO, '*****', R.RECEIVERNAME, R.RECEIVERADDRESS, R.RECEIVERZIP, R.RECEIVERSTATE, R.RECEIVERCITY, R.RECEIVERDISTRICT, R.RECEIVERMOBILE, R.RECEIVERPHONE, R.INVOICEFLAG, R.PAYMENTFLAG, R.COSTLYFLAG, R.PAYMENTMODEID, R.BUYERMESSAGE, R.ORDERTIME, S.INVOICE_NAME, S.INVOICE_CONTENT, S.DELIVERY_COST, S.PLATFORMID, R.BOXNO, R.PICKINGBILLBATCHID, R.PICKINGBILLBATCHNO, S.INVOICE_AMOUNT, 1, S.SALESODER_CODNO FROM (SELECT C
OUNT(DISTINCT T.SKUID) PACKAGE_VARIETYQTY, COUNT(*) PACKAGE_DETAILQTY, SUM(T.PACKAGE_QTY) PACKAGE_QTY, SUM(NVL(T.PACKAGE_SALEAMOUNT, 0)) PACKAGE_SALEAMOUNT, SUM(T.QC_WEIGHT) GOODS_WEIGHT, T.MOPOCSALESORDERBILLID, T.WAYBILL_PACKAGEID, T.WAYBILL_PACKAGENO, T.SYSTEMID FROM WAYBILLDETAIL_PACKAGE T WHERE T.WAYBILL_PACKAGEID = :B1 GROUP BY T.MOPOCSALESORDERBILLID, T.WAYBILL_PACKAGEID, T.WAYBILL_PACKAGENO, T.SYSTEMID) P, WAYBILL_COLLECT R, SALESORDER_BILL S WHERE P.MOPOCSALESORDERBILLID = R.MOPOCSALESORDERBILLID AND R.MOPOCSALESORDERBILLID = S.MOPOCSALESORDERBILLID AND R.MOPOCSALESORDERBILLID = :B2 |
a1bq05mx2wp39 | begin Picking_Bill_Consign30(AS_SYSTEMID=>:AS_SYSTEMID, AS_PICKINGBILLID=>:AS_PICKINGBILLID, AS_PICKINGBILLNO=>:AS_PICKINGBILLNO, AS_PRINTSTATE=>:AS_PRINTSTATE, AS_BILLSTATE=>:AS_BILLSTATE, AS_CONSIGNUSERID=>:AS_CONSIGNUSERID, AS_USERID=>:AS_USERID, DESCERR=>:DESCERR); end; |
ags6vx459vc0s |
INSERT INTO SALESORDER_CONSIGNLIST_TEMP (TITLE, SORDERID, OUTSORDERID, JOBNO, SHOPNAME, SHOPCODE, SHOPID, OWNERID, WAREHOUSEID, ORDERTIME, PAYMENTMODE, CONSIGN_WAREHOUSE, CONSIGN_CENTER, CONSIGN_SITE, CONSIGN_PICK, CONSIGN_DELIVER, RECEIVERNAME, RECEIVERADDRESS, RECEIVERZIP, RECEIVERSTATE, RECEIVERCITY, RECEIVERDISTRICT, RECEIVERMOBILE, RECEIVERPHONE, DELIVERTIME, CONSIGN_NOTIFY, CONSIGNTIME, ORDER_SALEAMOUNT, RECEIVABLE_AMOUNT, DELIVERY_COST, DISCOUNT_AMOUNT, OTHER_AMOUNT, REMARK, CONSIGN_NEED, RETURN_REMIND, RETURN_ADDRESS, RETURN_RECEIVER, RETURN_ZIP, RETURN_PHONE, RETURN_POLICY, CODFLAG, GOODS_TOTALQTY) SELECT T.TITLE, T.SORDERID, T.OUTSORDERID, T.JOBNO, T.SHOPNAME, T.SHOPCODE, R.SHOPID, R.OWNERID, R.WAREHOUSEID, T.ORDERTIME, T.PAYMENTMODE, T.CONSIGN_WAREHOUSE, T.CONSIGN_CENTER, T.CONSIGN_SITE, T.CONSIGN_PICK, T.CONSIGN_DELIVER, T.RECEIVERNAME, T.RECEIVERADDRESS, T.RECEIVERZIP, T.RECEIVERSTATE, T.RECEIVERCITY, T.RECEIVER
DISTRICT, T.RECEIVERMOBILE, T.RECEIVERPHONE, T.DELIVERTIME, T.CONSIGN_NOTIFY, T.CONSIGNTIME, T.ORDER_SALEAMOUNT, T.RECEIVABLE_AMOUNT, T.DELIVERY_COST, T.DISCOUNT_AMOUNT, T.OTHER_AMOUNT, T.REMARK, T.CONSIGN_NEED, T.RETURN_REMIND, T.RETURN_ADDRESS, T.RETURN_RECEIVER, T.RETURN_ZIP, T.RETURN_PHONE, T.RETURN_POLICY, T.CODFLAG, T.GOODS_TOTALQTY FROM IF_SALESORDER_CONSIGNLIST T, SALESORDER_BILL R WHERE T.SORDERID = R.MOPOCSALESORDERBILLID |
ah0gcgvg8d726 |
INSERT INTO SALESORDER_BILL_INTERCEPT (MOPOCSALESORDERBILLID, OUTERSALESORDERBILLID, MOPOCSOURCEORDERBILLID, OUTERSOURCEORDERBILLID, SHOPID, OWNERID, PLATFORMID, PLATFORMSTATUS, ORDERTYPEID, INPUTTYPEID, WAREHOUSEID, ORDER_VARIETYQTY, ORDER_DETAILQTY, ORDER_QTY, ORDER_SALEAMOUNT, ORDER_WEIGHT, ASSIGN_QTY, PICKING_QTY, QC_VARIETYQTY, QC_QTY, QC_SALEAMOUNT, QC_WEIGHT, CONSIGN_VARIETYQTY, CONSIGN_QTY, CONSIGN_SALEAMOUNT, CONSIGN_WEIGHT, BUYERNICK, BUYEREMAIL, BUYERMESSAGE, CUSTOMERID, RECEIVERNAME, RECEIVERADDRESS, RECEIVERZIP, RECEIVERSTATE, RECEIVERCITY, RECEIVERDISTRICT, RECEIVERMOBILE, RECEIVERPHONE, ORDERTIME, ENTERHEADQUARTERSTIME, UNITEHEADQUARTERSTIME, DISTRIBUTETIME, ENTERWAREHOUSETIME, UNITEWAREHOUSETIME, IMPORTTIME, IMPORTUSERID, MERGETIME, MERGEUSERID, WAITINGTIME, WAITINGUSERID, CANCELWAITINGTIME, CANCELWAITINGUSERID, CANCELORDERTIME, CANCELORDERUSERID, ACTUALCANCELTIME, ACTUALCANCELUSERID, ORDERPRINTTIME, ORDERPRINTUSE
RID, ASSIGNORDERTIME, ASSIGNORDERUSERID, QCTIME, QCUSERID, ACTUALSHORTTIME, ACTUALSHORTUSERID, PACKTIME, PACKUSERID, WAYBILLTIME, WAYBILLUSERID, HANDINGTIME, HANDINGUSERID, CONSIGNTIME, CONSIGNUSERID, ENDTIME, ENDUSERID, ACCOUNTDATE, ACCOUNTUSERID, MODIFIEDTIME, SHORTFLAG, ACTUALSHORTFLAG, UNITEFLAG, ACCOUNTFLAG, VOUCHERFLAG, INNERSTATUS, REFUNDSTATUS, STOCKSTATUS, GOODS_WEIGHT, OTHERSGOODS_WEIGHT, DELIVERID, DELIVERNO, DELIVERYMODEID, DELIVERYTIME, RETURNMODEID, PAYMENTMODEID, REFUND_MODEID, PACKAGING_MODEID, PACKAGING_COST, PACKAGING_SKUID, RECEIVABLE_AMOUNT, GOODS_PAYMENT, DELIVERY_COST, INVOICE_AMOUNT, ACCOUNT_PAID, SHOPPING_VOUCHER, ACCOUNT_BALANCE, PAYTIME, INVOICEFLAG, INVOICE_NAME, INVOICE_CONTENT, ORDER_DISCOUNT, GROUPORDERFLAG, ADVANCEORDERFLAG, PAYMENTFLAG, BLENDFLAG, RETURNREASONDESC, WAYBILLID, WAYBILLNO, PICKINGBILLID, PICKINGBILLNO, PICKINGBILLBATCHID, PICKINGBILLBATCHNO, ORDERMOVEINGBILLBATCHID, ORDERMOVEIN
GBILLBATCHNO, WAREHOUSEAREAQTY, WAREHOUSEAREAWAY, CREATETIME, UPDATETIME, BILL_STATE, OLDBILL_STATE, STATE_DESC, COSTLYFLAG, FROMSYSTEM) SELECT T.MOPOCSALESORDERBILLID, T.OUTERSALESORDERBILLID, T.MOPOCSOURCEORDERBILLID, T.OUTERSOURCEORDERBILLID, T.SHOPID, T.OWNERID, T.PLATFORMID, T.PLATFORMSTATUS, T.ORDERTYPEID, T.INPUTTYPEID, T.WAREHOUSEID, T.ORDER_VARIETYQTY, T.ORDER_DETAILQTY, T.ORDER_QTY, T.ORDER_SALEAMOUNT, T.ORDER_WEIGHT, T.ASSIGN_QTY, T.PICKING_QTY, T.QC_VARIETYQTY, T.QC_QTY, T.QC_SALEAMOUNT, T.QC_WEIGHT, T.CONSIGN_VARIETYQTY, T.CONSIGN_QTY, T.CONSIGN_SALEAMOUNT, T.CONSIGN_WEIGHT, T.BUYERNICK, T.BUYEREMAIL, T.BUYERMESSAGE, T.CUSTOMERID, T.RECEIVERNAME, T.RECEIVERADDRESS, T.RECEIVERZIP, T.RECEIVERSTATE, T.RECEIVERCITY, T.RECEIVERDISTRICT, T.RECEIVERMOBILE, T.RECEIVERPHONE, T.ORDERTIME, T.ENTERHEADQUARTERSTIME, T.UNITEHEADQUARTERSTIME, T.DISTRIBUTETIME, T.ENTERWAREHOUSETIME, T.UNITEWAREHOUSETIME, T.IMPORTTIME, T.IMPORTUSERID,
T.MERGETIME, T.MERGEUSERID, T.WAITINGTIME, T.WAITINGUSERID, T.CANCELWAITINGTIME, T.CANCELWAITINGUSERID, SYSDATE, :B2 , SYSDATE, :B2 , T.ORDERPRINTTIME, T.ORDERPRINTUSERID, T.ASSIGNORDERTIME, T.ASSIGNORDERUSERID, T.QCTIME, T.QCUSERID, T.ACTUALSHORTTIME, T.ACTUALSHORTUSERID, T.PACKTIME, T.PACKUSERID, T.WAYBILLTIME, T.WAYBILLUSERID, T.HANDINGTIME, T.HANDINGUSERID, T.CONSIGNTIME, T.CONSIGNUSERID, T.ENDTIME, T.ENDUSERID, T.ACCOUNTDATE, T.ACCOUNTUSERID, T.MODIFIEDTIME, T.SHORTFLAG, T.ACTUALSHORTFLAG, T.UNITEFLAG, T.ACCOUNTFLAG, T.VOUCHERFLAG, T.INNERSTATUS, T.REFUNDSTATUS, T.STOCKSTATUS, T.GOODS_WEIGHT, T.OTHERSGOODS_WEIGHT, T.DELIVERID, T.DELIVERNO, T.DELIVERYMODEID, T.DELIVERYTIME, T.RETURNMODEID, T.PAYMENTMODEID, T.REFUND_MODEID, T.PACKAGING_MODEID, T.PACKAGING_COST, T.PACKAGING_SKUID, T.RECEIVABLE_AMOUNT, T.GOODS_PAYMENT, T.DELIVERY_COST, T.INVOICE_AMOUNT, T.ACCOUNT_PAID, T.SHOPPING_VOUCHER, T.ACCOUNT_BALANCE, T.PAYTIME, T.INVOIC
EFLAG, T.INVOICE_NAME, T.INVOICE_CONTENT, T.ORDER_DISCOUNT, T.GROUPORDERFLAG, T.ADVANCEORDERFLAG, T.PAYMENTFLAG, T.BLENDFLAG, T.RETURNREASONDESC, T.WAYBILLID, T.WAYBILLNO, T.PICKINGBILLID, T.PICKINGBILLNO, T.PICKINGBILLBATCHID, T.PICKINGBILLBATCHNO, T.ORDERMOVEINGBILLBATCHID, T.ORDERMOVEINGBILLBATCHNO, T.WAREHOUSEAREAQTY, T.WAREHOUSEAREAWAY, T.CREATETIME, SYSDATE, T.BILL_STATE, T.OLDBILL_STATE, T.STATE_DESC, T.COSTLYFLAG, T.FROMSYSTEM FROM SALESORDER_BILL T, WAYBILL_LEADIN_JOBTEMP TP WHERE TP.SYSTEMID = :B1 AND TP.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID AND EXISTS (SELECT 1 FROM SALESORDER_BILL_INTERCEPT_TEMP D WHERE D.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID) |
apn3u2a6rx4s0 |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT SALESORDER_BILL.salesoder_codno, SALESORDER_BILL.STATE_DESC, SALESORDER_BILL.MOPOCSALESORDERBILLID, SALESORDER_BILL.OUTERSALESORDERBILLID, SALESORDER_BILL.MOPOCSOURCEORDERBILLID, SALESORDER_BILL.OUTERSOURCEORDERBILLID, SALESORDER_BILL.DELIVERID, SALESORDER_BILL.DELIVERNO, SALESORDER_BILL.DELIVERYMODEID, SALESORDER_BILL.DELIVERYTIME, SALESORDER_BILL.SHOPID, SALESORDER_BILL.OWNERID, SALESORDER_BILL.BUYERNICK, SALESORDER_BILL.BUYEREMAIL, SALESORDER_BILL.BUYERMESSAGE, SALESORDER_BILL.CUSTOMERID, SALESORDER_BILL.RECEIVERNAME, SALESORDER_BILL.RECEIVERADDRESS, SALESORDER_BILL.RECEIVERZIP, SALESORDER_BILL.RECEIVERSTATE, SALESORDER_BILL.RECEIVERCITY, SALESORDER_BILL.RECEIVERDISTRICT, SALESORDER_BILL.RECEIVERMOBILE, SALESORDER_BILL.RECEIVERPHONE, SALESORDER_BILL.PLATFORMID, SALESORDER_BILL.PLATFORMSTATUS, SALESORDER_BILL.ORDERTYPEID, SALESORDER_BILL.INPUTTYPEID, SALESORDER_BILL.WAREHOUSEID, SALESORDER_BILL.ORDER_VARIE
TYQTY, SALESORDER_BILL.ORDER_DETAILQTY, SALESORDER_BILL.ORDER_QTY, SALESORDER_BILL.ORDER_SALEAMOUNT, SALESORDER_BILL.ORDER_WEIGHT, SALESORDER_BILL.ASSIGN_QTY, SALESORDER_BILL.PICKING_QTY, SALESORDER_BILL.QC_VARIETYQTY, SALESORDER_BILL.QC_QTY, SALESORDER_BILL.QC_SALEAMOUNT, SALESORDER_BILL.QC_WEIGHT, SALESORDER_BILL.CONSIGN_VARIETYQTY, SALESORDER_BILL.CONSIGN_QTY, SALESORDER_BILL.CONSIGN_SALEAMOUNT, SALESORDER_BILL.CONSIGN_WEIGHT, SALESORDER_BILL.GOODS_WEIGHT, SALESORDER_BILL.OTHERSGOODS_WEIGHT, SALESORDER_BILL.ORDERTIME, SALESORDER_BILL.ENTERHEADQUARTERSTIME, SALESORDER_BILL.UNITEHEADQUARTERSTIME, SALESORDER_BILL.DISTRIBUTETIME, SALESORDER_BILL.ENTERWAREHOUSETIME, SALESORDER_BILL.UNITEWAREHOUSETIME, SALESORDER_BILL.IMPORTTIME, SALESORDER_BILL.IMPORTUSERID, SALESORDER_BILL.MERGETIME, SALESORDER_BILL.MERGEUSERID, SALESORDER_BILL.WAITINGTIME, SALESORDER_BILL.WAITINGUSERID, SALESORDER_BILL.CANCELWAITINGTIME, SALESORDER_BILL.CANCELWAITINGUSERID, SALESORDER_BIL
L.CANCELORDERTIME, SALESORDER_BILL.CANCELORDERUSERID, SALESORDER_BILL.ACTUALCANCELTIME, SALESORDER_BILL.ACTUALCANCELUSERID, SALESORDER_BILL.ORDERPRINTTIME, SALESORDER_BILL.ORDERPRINTUSERID, SALESORDER_BILL.ASSIGNORDERTIME, SALESORDER_BILL.ASSIGNORDERUSERID, SALESORDER_BILL.PICKINGTIME, SALESORDER_BILL.PICKINGUSERID, SALESORDER_BILL.QCTIME, SALESORDER_BILL.QCUSERID, SALESORDER_BILL.ACTUALSHORTTIME, SALESORDER_BILL.ACTUALSHORTUSERID, SALESORDER_BILL.PACKTIME, SALESORDER_BILL.PACKUSERID, SALESORDER_BILL.WAYBILLTIME, SALESORDER_BILL.WAYBILLUSERID, SALESORDER_BILL.HANDINGTIME, SALESORDER_BILL.HANDINGUSERID, SALESORDER_BILL.CONSIGNTIME, SALESORDER_BILL.CONSIGNUSERID, SALESORDER_BILL.ENDTIME, SALESORDER_BILL.ENDUSERID, SALESORDER_BILL.ACCOUNTDATE, SALESORDER_BILL.ACCOUNTUSERID, SALESORDER_BILL.MODIFIEDTIME, SALESORDER_BILL.SHORTFLAG, SALESORDER_BILL.ACTUALSHORTFLAG, SALESORDER_BILL.UNITEFLAG, SALESORDER_BILL.ACCOUNTFLAG, SALESORDER_BILL.VOUCHERFLAG, SALESORDER_
BILL.INNERSTATUS, SALESORDER_BILL.REFUNDSTATUS, SALESORDER_BILL.STOCKSTATUS, SALESORDER_BILL.RETURNMODEID, SALESORDER_BILL.PAYMENTMODEID, SALESORDER_BILL.REFUND_MODEID, SALESORDER_BILL.PACKAGING_MODEID, SALESORDER_BILL.PACKAGING_COST, SALESORDER_BILL.PACKAGING_SKUID, SALESORDER_BILL.RECEIVABLE_AMOUNT, SALESORDER_BILL.GOODS_PAYMENT, SALESORDER_BILL.DELIVERY_COST, SALESORDER_BILL.INVOICE_AMOUNT, SALESORDER_BILL.ACCOUNT_PAID, SALESORDER_BILL.SHOPPING_VOUCHER, SALESORDER_BILL.ACCOUNT_BALANCE, SALESORDER_BILL.PAYTIME, SALESORDER_BILL.INVOICEFLAG, SALESORDER_BILL.INVOICE_NAME, SALESORDER_BILL.INVOICE_CONTENT, SALESORDER_BILL.ORDER_DISCOUNT, SALESORDER_BILL.GROUPORDERFLAG, SALESORDER_BILL.ADVANCEORDERFLAG, SALESORDER_BILL.PAYMENTFLAG, SALESORDER_BILL.BLENDFLAG, SALESORDER_BILL.RETURNREASONDESC, SALESORDER_BILL.WAYBILLID, SALESORDER_BILL.WAYBILLNO, SALESORDER_BILL.PICKINGBILLID, SALESORDER_BILL.PICKINGBILLNO, SALESORDER_BILL.PICKINGBILLBATCHID, SALESORDER_BILL.PI
CKINGBILLBATCHNO, SALESORDER_BILL.ORDERMOVEINGBILLBATCHID, SALESORDER_BILL.ORDERMOVEINGBILLBATCHNO, SALESORDER_BILL.WAREHOUSEAREAQTY, SALESORDER_BILL.WAREHOUSEAREAWAY, SALESORDER_BILL.CREATETIME, SALESORDER_BILL.UPDATETIME, SALESORDER_BILL.BILL_STATE, SALESORDER_BILL.OLDBILL_STATE, salesorder_bill.costlyflag, salesorder_bill.DANGEROUS_FLAG, salesorder_bill.TRAVELSFLAG, SALESORDER_BILL.batchbillid, SALESORDER_BILL.batchbillno FROM SALESORDER_BILL where WAREHOUSEID=:"SYS_B_0" AND RECEIVERMOBILE = :"SYS_B_1" Order By MOPOCSALESORDERBILLID) A WHERE ROWNUM <= :"SYS_B_2" ) WHERE RN > :"SYS_B_3" |
aq8yqxyyb40nn | update sys.job$ set this_date=:1 where job=:2 |
as0uaw3pvcz1c | SELECT COUNT(*) FROM USER_OBJECTS WHERE OBJECT_TYPE = 'SEQUENCE' AND OBJECT_NAME = UPPER(:B1 ) |
awrr2c9hqf7p0 | select sysdate+:"SYS_B_0"/:"SYS_B_1" from dual |
bypmfr5wammfu |
Select WAYBILL_HANDINGBATCH.BATCHBILLID, Substr(waybill_handingbatch.batchbillno, Length(waybill_handingbatch.batchbillno)-:"SYS_B_0", :"SYS_B_1") billnoendstr, WAYBILL_HANDINGBATCH.BATCHBILLNO, WAYBILL_HANDINGBATCH.WAREHOUSEID, base_warehouse.warehousename, WAYBILL_HANDINGBATCH.DELIVERID, (Case When WAYBILL_HANDINGBATCH.DELIVERGROUPFLAG = :"SYS_B_2" Then (select companyname from base_company where base_company.companyid = WAYBILL_HANDINGBATCH.Deliverid) Else (select groupname from base_deliver where base_deliver.delivergroupid = WAYBILL_HANDINGBATCH.Deliverid) End) COMPANYNAME, WAYBILL_HANDINGBATCH.POSID, WAYBILL_HANDINGBATCH.DEVICE_CODE, WAYBILL_HANDINGBATCH.ORDERBILL_QTY, WAYBILL_HANDINGBATCH.PRINTFLAG, WAYBILL_HANDINGBATCH.PRINTNUM, WAYBILL_HANDINGBATCH.PRINTDATE, WAYBILL_HANDINGBATCH.PRINTUSERID, WAYBILL_HANDINGBATCH.TRUCK_NUMBER, WAYBILL_HANDINGBATCH.TRUCK_PEOPLE, ( select a.username from sys_user a where a.userid=WAYBILL_HANDINGBATCH
.HANDINGUSERID) as HANDINGUSERID, WAYBILL_HANDINGBATCH.HANDINGTIME, WAYBILL_HANDINGBATCH.CREATEUSERID, WAYBILL_HANDINGBATCH.CREATETIME, WAYBILL_HANDINGBATCH.BILL_STATE, WAYBILL_HANDINGBATCH.OLDBILL_STATE, WAYBILL_HANDINGBATCH.STATE_DESC, WAYBILL_HANDINGBATCH.WEIGHT_TOTAL, WAYBILL_HANDINGBATCH.FINISHDATE, WAYBILL_HANDINGBATCH.FINISHUSERID, Waybill_Handingbatch_Detail.Mopocsalesorderbillid, Waybill_Handingbatch_Detail.Outersalesorderbillid, Waybill_Handingbatch_Detail.Consign_Weight, Waybill_Package.Deliverno, Waybill_Handingbatch_Detail.Waybill_Packageno, sysdate as dtnow, rownum, Waybill_Package.Package_Serial From Waybill_Handingbatch_Detail Left Join Waybill_Package On Waybill_Handingbatch_Detail.Waybill_Packageid = Waybill_Package.Waybill_Packageid Left Join Waybill_Packagehangding On Waybill_Handingbatch_Detail.Waybill_Packageid = Waybill_Packagehangding.Waybill_Packageid left join WAYBILL_HANDINGBATCH on Waybill_Handingbatch_Detail.Batchbillid = WAYBILL_HANDINGBAT
CH.BATCHBILLID left join base_warehouse on WAYBILL_HANDINGBATCH.WAREHOUSEID = base_warehouse.warehouseid Where Waybill_Handingbatch_Detail.Batchbillid = :Arg_Batchbillid |
cg6hra1s3mg6v | SELECT * FROM (SELECT S.SALESORDERBILLSTATEID, S.MOPOCSALESORDERBILLID, S.OUTERSALESORDERBILLID, MOPOCSOURCEORDERBILLID, OUTERSOURCEORDERBILLID, SHOPID, S.OWNERID, ORDERTYPEID, S.WAREHOUSEID, QTY, BILLSTATE, OLDBILL_STATE, STATE_DESC, CREATETIME, CREATEUSERID, S.DELIVERID, DELIVERNO, WEIGHT, WAYBILL_PACKAGEID, INPUTTYPEID, S.RECORDTIME, FROMSYSTEM, TASKSTATE , NVL(G.GROUPNO, :"SYS_B_0") GROUPNO FROM IF_SALESORDER_BILLSTATE S LEFT JOIN IF_SALESORDER_GROUP G ON G.MOPOCSALESORDERBILLID = S.MOPOCSALESORDERBILLID WHERE S.TASKSTATE =:"SYS_B_1" AND S.BILLSTATE > :"SYS_B_2" ORDER BY RECORDTIME) WHERE ROWNUM < :"SYS_B_3" |
ckk296gsdch3b | Select Systemid, Availablesaleid, Departmentid, Ownerid, Warehouseid, Skuid, Availableqty, Stateflag, Createdate, Updatedate, Recordtime, Onwayqty, Fororder_Qty From If_Inventory_Availablesale where taskstate=:"SYS_B_0" and rownum <= :"SYS_B_1" and OWNERID<>:"SYS_B_2" AND OWNERID<>:"SYS_B_3" AND OWNERID<>:"SYS_B_4" order by availablesaleid asc |
cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
cumjq42201t37 | select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name |
d1bcnr2fp1hqq | INSERT INTO IF_INVENTORY_AVAILABLESALE (SYSTEMID, AVAILABLESALEID, DEPARTMENTID, OWNERID, WAREHOUSEID, SKUID, AVAILABLEQTY, FORORDER_QTY, ONWAYQTY, STATEFLAG, CREATEDATE, UPDATEDATE) (SELECT B.SYSTEMID, GET_SYS_PREFIXION(B.SYSTEMID) || TO_CHAR(SYSDATE, 'yymmdd') || F_GET_LPADSEQUENCE_VALUE('2', INVENTORY_AVAILABLESALE_SEQ.NEXTVAL, 13, '0'), B.DEPARTMENTID, B.OWNERID, B.WAREHOUSEID, B.SKUID, B.AVAILABLESALEQTY, :B5 , B.ONWAYQTY, '01', SYSDATE, SYSDATE FROM INVENTORY_OWNER B WHERE B.SKUID = :B4 AND B.DEPARTMENTID = :B3 AND :B2 = B.OWNERID AND :B1 = B.WAREHOUSEID) |
d6fx4dcuz5a30 | UPDATE SALESORDER_BILL T SET T.BILL_STATE = '04', T.STATE_DESC = '质检确认', (T.PICKING_QTY, T.QC_VARIETYQTY, T.QC_QTY, T.QC_SALEAMOUNT, T.QC_WEIGHT, T.QCTIME, T.QCUSERID) = (SELECT S.QC_QTY, S.QC_VARIETYQTY, S.QC_QTY, S.QC_SALEAMOUNT, S.GOODS_WEIGHT, SYSDATE, :B1 FROM WAYBILL_DELIVERY_TEMP S WHERE T.MOPOCSALESORDERBILLID = S.MOPOCSALESORDERBILLID) WHERE EXISTS (SELECT 1 FROM WAYBILL_DELIVERY_TEMP TP WHERE TP.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID) |
dn8w89jx7k958 | SELECT /*+ OPAQUE_TRANSFORM */ "SALESORDERBILLSTATEID", "MOPOCSALESORDERBILLID", "OUTERSALESORDERBILLID", "OWNERID", "WAREHOUSEID", "BILLSTATE", "CREATETIME", "DELIVERID", "RECORDTIME" FROM "IF_SALESORDER_BILLSTATE" "IF_SALESORDER_BILLSTATE" WHERE "CREATETIME">=:1 AND "BILLSTATE"=:"SYS_B_0" |
f1qpr4uk5rbtm |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT WAYBILL_HANDINGBATCH.BATCHBILLID, WAYBILL_HANDINGBATCH.BATCHBILLNO, WAYBILL_HANDINGBATCH.RF_FLAG, WAYBILL_HANDINGBATCH.WAREHOUSEID, WAYBILL_HANDINGBATCH.DELIVERID, WAYBILL_HANDINGBATCH.POSID, WAYBILL_HANDINGBATCH.DEVICE_CODE, WAYBILL_HANDINGBATCH.ORDERBILL_QTY, WAYBILL_HANDINGBATCH.PRINTFLAG, WAYBILL_HANDINGBATCH.PRINTNUM, WAYBILL_HANDINGBATCH.PRINTDATE, WAYBILL_HANDINGBATCH.PRINTUSERID, WAYBILL_HANDINGBATCH.TRUCK_NUMBER, WAYBILL_HANDINGBATCH.TRUCK_PEOPLE, WAYBILL_HANDINGBATCH.HANDINGUSERID, WAYBILL_HANDINGBATCH.HANDINGTIME, WAYBILL_HANDINGBATCH.CREATEUSERID, WAYBILL_HANDINGBATCH.CREATETIME, WAYBILL_HANDINGBATCH.BILL_STATE, WAYBILL_HANDINGBATCH.OLDBILL_STATE, WAYBILL_HANDINGBATCH.STATE_DESC, WAYBILL_HANDINGBATCH.WEIGHT_TOTAL, WAYBILL_HANDINGBATCH.FINISHDATE, WAYBILL_HANDINGBATCH.FINISHUSERID FROM WAYBILL_HANDINGBATCH where :"SYS_B_0"=:"SYS_B_1" AND WAYBILL_HANDINGBATCH.WAREHOUSEID=:"SYS_B_
2" and WAYBILL_HANDINGBATCH.deliverid=:"SYS_B_3" Order By BATCHBILLNO desc, STATE_DESC) A WHERE ROWNUM <= :"SYS_B_4" ) WHERE RN > :"SYS_B_5" |
f2mwz1zyzc4uv |
Select Z.Mopocsalesorderbillid, Z.Outersalesorderbillid, Z.Invoice_Amount, Z.Invoice_Name, Z.Invoice_Content, Z.Ordertime, Z.Package_Saleamount, S.Skuid, S.Goodsbarcode, S.Goodsname, G.Package_Qty, G.Saleprice, G.Package_Saleamount, Z.Receivername, z.Posid, Z.Invoiceflag, Z.Shopid, Z.Waybill_Packageid, Z.Waybill_Packageno, Z.Package_Serial, Z.Package_Number, nvl((Select h.Waybill_Packageno From Waybill_Package h Where h.Mopocsalesorderbillid = Z.Mopocsalesorderbillid And h.Package_Serial = :"SYS_B_0"), :"SYS_B_1") Fpbg, F.Ksdz_Printflag, F.Ksdz, z.boxno, p.province_name, c.city_name, q.area_name, z.receiveraddress, z.receivermobile, z.receiverphone, d.account_paid, d.order_saleamount, d.Delivery_Cost, d.receivable_amount, z.Outersalesorderbillid sbrvs30_compute_1, --条码为外部单号 s.goodsname sbrvs30_compute_5, g.saleprice * g.PACKAGE_QTY sbrvs30_detail_total, s.skuid sbrvs30_compute_4, rownum sbrvs30_compute_7, g.package_qty sbrvs3
0_compute_2, g.saleprice * g.PACKAGE_QTY sbrvs30_compute_6, decode(d.account_paid, null, :"SYS_B_2", d.account_paid) sbrvs30_compute_3 From Waybilldetail_Package g Left Join Waybill_Package z On Z.Waybill_Packageid = G.Waybill_Packageid Left Join Base_Goodsinfo s On S.Skuid = G.Skuid Left Join Base_Owner_Forhaitao f On F.Warehouseid = Z.Warehouseid And F.Platformid = Z.Platformid And F.Ownerid = Z.Ownerid Left Join Base_Province p On p.Province_Id = Z.Receiverstate Left Join Base_City c On C.City_Id = Z.Receivercity Left Join Base_Area q On Q.Area_Id = Z.Receiverdistrict Left Join salesorder_bill d On D.MOPOCSALESORDERBILLID = z.mopocsalesorderbillid Where G.Waybill_Packageid = :Arg_Billid |
f319mcpzrcydh | UPDATE SALESORDER_BILL T SET T.ASSIGNORDERTIME = SYSDATE, T.ASSIGNORDERUSERID = :B4 , T.PICKINGTIME = SYSDATE, T.PICKINGUSERID = :B3 , T.BILL_STATE = '03', T.STATE_DESC = '分配确认', T.PICKINGBILLID = NVL(T.PICKINGBILLID, :B2 ), T.PICKINGBILLNO = NVL(T.PICKINGBILLNO, :B1 ), T.PICKING_QTY = (SELECT SUM(A.PICKING_QTY) FROM PICKING_BILLSOURCE A WHERE A.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID) WHERE EXISTS (SELECT 1 FROM PICKING_BILLSOURCE S WHERE S.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID AND S.PICKINGBILLID = :B2 ) |
fg6k4m6t4cgx7 | SELECT KQ.CXFLAG, KQ.WAREHOUSEAREAID, KQ.SORTNO, KQ.WAREHOUSEAREACODE FROM BASE_WAREHOUSEAREA KQ, BASE_WAREHOUSECARGOSPACE HW WHERE KQ.WAREHOUSEID = :B1 AND HW.WAREHOUSEID = KQ.WAREHOUSEID AND HW.WAREHOUSEAREAID = KQ.WAREHOUSEAREAID AND KQ.ENABLEFLAG = '启用' AND HW.PURPOSEPROPERTYID = 'JX' AND HW.ENABLEFLAG = '启用' AND HW.CARGOSPACESTATEID <= '2' AND EXISTS (SELECT 1 FROM WAYBILLDETAIL_LEADIN_TEMP T, WAYBILL_LEADIN_TEMP W WHERE T.MOPOCSALESORDERBILLID = W.MOPOCSALESORDERBILLID AND W.ALLOT_OCCUPY_FLAG = 'false' AND T.OWNERID = HW.OWNERID AND T.DEPARTMENTID = HW.DEPAREMENTID AND T.WAREHOUSEID = HW.WAREHOUSEID) GROUP BY KQ.CXFLAG, KQ.WAREHOUSEAREAID, KQ.SORTNO, KQ.WAREHOUSEAREACODE ORDER BY DECODE(NVL(KQ.CXFLAG, 'false'), 'false', '1', '2'), KQ.SORTNO, KQ.WAREHOUSEAREACODE |
fwwdq59ky8mqb | select a.posid , decode(a.rf_flag, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02")||a.posid as post, count(*) as count from shelve_batch a where a.rf_flag<>:"SYS_B_03" and nvl(a.BUSINESSTYPEID, :"SYS_B_04") <> :"SYS_B_05" and (bill_state=:"SYS_B_06" or (bill_state=:"SYS_B_07" and (state_desc=:"SYS_B_08" or (state_desc=:"SYS_B_09" and exists (select a.shelve_batchid from receive_bill left join shelve_bill on shelve_bill.logisticsbillid=receive_bill.receivebillid where receive_bill.shelve_batchid =a.SHELVE_BATCHID group by a.shelve_batchid having sum(decode(shelve_bill.shelveprint, :"SYS_B_10", :"SYS_B_11", :"SYS_B_12")) < count(shelve_bill.shelvebillid) Or sum(shelve_bill.shelveprint)=:"SYS_B_13"))))) and a.warehouseid=:"SYS_B_14" group by a.posid, a.rf_flag |
gamdzj6zhw0wz |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM ( Select WAYBILL_LEADIN.SYSTEMID, WAYBILL_LEADIN.PAYTIME, WAYBILL_LEADIN.MOPOCSALESORDERBILLID, WAYBILL_LEADIN.OUTERSALESORDERBILLID, WAYBILL_LEADIN.MOPOCSOURCEORDERBILLID, WAYBILL_LEADIN.OUTERSOURCEORDERBILLID, WAYBILL_LEADIN.WAYBILLID, WAYBILL_LEADIN.WAYBILLNO, WAYBILL_LEADIN.SHOPID, WAYBILL_LEADIN.OWNERID, WAYBILL_LEADIN.ORDERTYPEID, WAYBILL_LEADIN.WAREHOUSEID, WAYBILL_LEADIN.JXFQID, WAYBILL_LEADIN.BOXNO, WAYBILL_LEADIN.ORDER_VARIETYQTY, WAYBILL_LEADIN.ORDER_DETAILQTY, WAYBILL_LEADIN.ORDER_QTY, WAYBILL_LEADIN.ASSIGN_QTY, WAYBILL_LEADIN.RECEIVABLE_AMOUNT, WAYBILL_LEADIN.RECEIVERNAME, WAYBILL_LEADIN.RECEIVERADDRESS, WAYBILL_LEADIN.RECEIVERZIP, WAYBILL_LEADIN.RECEIVERSTATE, WAYBILL_LEADIN.RECEIVERCITY, WAYBILL_LEADIN.RECEIVERDISTRICT, WAYBILL_LEADIN.RECEIVERMOBILE, WAYBILL_LEADIN.RECEIVERPHONE, WAYBILL_LEADIN.ORDERTIME, WAYBILL_LEADIN.DELIVERYTIME, WAYBILL_LEADIN.DELIVERID, WAYBILL_LEADIN.GROUPORDERFLAG, WAYBILL_LE
ADIN.INVOICEFLAG, WAYBILL_LEADIN.ADVANCEORDERFLAG, WAYBILL_LEADIN.PAYMENTFLAG, WAYBILL_LEADIN.BLENDFLAG, WAYBILL_LEADIN.PICKINGBILLID, WAYBILL_LEADIN.PICKINGBILLNO, WAYBILL_LEADIN.PICKINGBILLBATCHID, WAYBILL_LEADIN.PICKINGBILLBATCHNO, WAYBILL_LEADIN.WAREHOUSEAREAQTY, WAYBILL_LEADIN.WAREHOUSEAREAWAY, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHID, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHNO, WAYBILL_LEADIN.CREATEUSERID, WAYBILL_LEADIN.UPDATEUSERID, WAYBILL_LEADIN.CREATETIME, WAYBILL_LEADIN.UPDATETIME, WAYBILL_LEADIN.BILL_STATE, WAYBILL_LEADIN.OLDBILL_STATE, WAYBILL_LEADIN.STATE_DESC , WAYBILL_LEADIN.costlyflag , WAYBILL_LEADIN.Paymentmodeid, WAYBILL_LEADIN.Buyermessage, :"SYS_B_00" as selectedflag, WAYBILL_LEADIN.INPUTTYPEID, WAYBILL_LEADIN.ORDER_SALEAMOUNT, WAYBILL_LEADIN.PLATFORMID, WAYBILL_LEADIN.CUSTOMER_MESSAGE From WAYBILL_LEADIN Where :"SYS_B_01"=:"SYS_B_02" And ALLOT_OCCUPY_FLAG = :"SYS_B_03" and WAREHOUSEID=:"SYS_B_04
" And nvl(DELIVERID, :"SYS_B_05") = :"SYS_B_06" And (WAYBILL_LEADIN.OWNERID =:"SYS_B_07") and Not Exists ( Select :"SYS_B_08" From Base_Shopgroup, Base_Shopgroup_Shop Where Base_Shopgroup.Shopgroupid = Base_Shopgroup_Shop.Shopgroupid And Base_Shopgroup_Shop.Enableflag = :"SYS_B_09" And Base_Shopgroup.Enableflag = :"SYS_B_10" And Base_Shopgroup_Shop.Shopid = Waybill_Leadin.Shopid And Base_Shopgroup_Shop.warehouseid = Waybill_Leadin.warehouseid ) Order By WAYBILL_LEADIN.BILL_STATE asc , WAYBILL_LEADIN.paytime asc, WAYBILL_LEADIN.MOPOCSALESORDERBILLID asc ) A WHERE ROWNUM <= :"SYS_B_11" ) WHERE RN > :"SYS_B_12" |
ghn9v5v7n3h10 | UPDATE INVENTORY_OWNER B SET B.AVAILABLESALEQTY = B.AVAILABLESALEQTY + :B2 , B.ONWAYQTY=B.ONWAYQTY+:B1 WHERE B.SKUID = :B7 AND B.DEPARTMENTID = :B6 AND B.OWNERID = :B5 AND B.SYSTEMID = :B4 AND B.WAREHOUSEID = :B3 |
gkz1gdwyk1ubw | SELECT T.BILL_STATE, T.WAREHOUSEID, T.OWNERID FROM SALESORDER_BILL T WHERE T.MOPOCSALESORDERBILLID = :B1 |