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 |
1hk6wj4jy065a | DELETE FROM INVENTORY_GOODSFORSALE T WHERE EXISTS (SELECT 1 FROM INVENTORY_GOODSFORSALE_TEMP S WHERE S.GOODSFORSALEID = T.GOODSFORSALEID AND S.SYSTEMID = T.SYSTEMID AND S.SYSTEMID = :B1 ) |
1hyv78p73sby6 | SELECT SUM(B.PACKAGE_QTY) FROM PACKAGE_BILLDETAIL B WHERE B.LOGISTICSTYPEID = '进退单' AND B.SYSTEMID = :B7 AND B.LOGISTICSBILLID = :B6 AND B.OWNERID = :B5 AND B.WAREHOUSEID = :B4 AND B.SKUID = :B3 AND B.WARRANTY_ENDDATE = :B2 AND B.PRODUCTION_BATCHNUMBER = :B1 |
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) |
2vq7yv9nn1b0r |
Select :reprintflag, pr.outpurchasereturnbillno, pr.remark, pr.purchasereturnbillno, decode(pr.addressid, :"SYS_B_0", :"SYS_B_1", :"SYS_B_2") delivertype, decode(pr.addressid, :"SYS_B_3", :"SYS_B_4", a.address_name) address_name, ck.warehousename, decode(pr.addressid, :"SYS_B_5", :"SYS_B_6", a.receivetel) receivetel, decode(pr.addressid, :"SYS_B_7", :"SYS_B_8", a.receivecontact) receivecontact, hz.companyname, sp.companyname as spcompanyname, z.packagebillno, sysdate pbrp34_date_1, z.entering_varietyqty, z.entering_qty From Package_Billdetail g Left Join Package_Bill z On z.Packagebillid = g.Packagebillid Left Join Base_Company Hz On Hz.Companyid = z.Ownerid Left Join Base_Warehouse Ck On Ck.Warehouseid = z.Warehouseid left join purchase_returnbill pr on (z.Logisticstypeid =:"SYS_B_9" and z.logisticsbillid = pr.purchasereturnbillid) left join base_address a on a.address_id=pr
.addressid left join base_company sp on sp.companyid = pr.supplierid where g.packagebillid=:arg_billid |
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 |
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" |
572pfbk8f3x4y |
select count(:"SYS_B_0") from (select waybill_packagehangding.systemid, waybill_packagehangding.waybill_packageid, waybill_packagehangding.waybill_packageno, waybill_packagehangding.package_serial, waybill_packagehangding.package_number, waybill_packagehangding.mopocsalesorderbillid, waybill_packagehangding.outersalesorderbillid, waybill_packagehangding.shopid, waybill_packagehangding.ownerid, waybill_packagehangding.ordertypeid, waybill_packagehangding.warehouseid, waybill_packagehangding.inputtypeid, waybill_packagehangding.package_varietyqty, waybill_packagehangding.package_detailqty, waybill_packagehangding.package_qty, waybill_packagehangding.package_saleamount, waybill_packagehangding.goods_weight, waybill_packagehangding.othersgoods_weight, waybill_packagehangding.consign_weight, waybill_packagehangding.packaging_skuid, waybill_packagehangding.packaging_cost, waybill_packagehangding.receivable_amount, waybill_packagehangding.scanno, waybill_packa
gehangding.deliverid, waybill_packagehangding.deliverno, waybill_packagehangding.delivernoprintflag, waybill_packagehangding.printnum, waybill_packagehangding.pickingbillid, waybill_packagehangding.pickingbillno, waybill_packagehangding.batchbillid, waybill_packagehangding.batchbillno, waybill_packagehangding.createuserid, waybill_packagehangding.updateuserid, waybill_packagehangding.createtime, waybill_packagehangding.updatetime, waybill_packagehangding.bill_state, waybill_packagehangding.oldbill_state, waybill_packagehangding.state_desc, waybill_packagehangding.packtime, waybill_packagehangding.packuserid, waybill_packagehangding.handingtime, waybill_packagehangding.handinguserid, waybill_packagehangding.waybillid, waybill_packagehangding.waybillno, waybill_packagehangding.posid, 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, base_goodsinfo.goodsbarcode, PICKING_BILL.PICKINGFLAG from waybill_packagehangding, salesorder_bill, BASE_PROVINCE, BASE_CITY, BASE_AREA, base_goodsinfo, PICKING_BILL where waybill_packagehangding.mopocsalesorderbillid = salesorder_bill.mopocsalesorderbillid 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 waybill_packagehangding.packaging_skuid = base_goodsinfo.skuid(+) and waybill_packagehangding.PICKINGBILLID = picking_bill.pickingbillid(+) AND WAYBILL_PACKAGEHANGDING.WAREHOUSEID=:"SYS_B_1" AND waybill_packagehangding.HANDINGTIME BETWEEN TO_DATE(:"SYS_B_2", :"SYS_B_3") AND TO_DATE(:"SYS_B_4", :"SYS_B_5") Order By CREATETIME desc, WAYBILL_PACKAGEID desc ) |
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 |
57a37zd77u4yv | begin Purchase_Returnbill_Outsure30(AS_SYSTEMID=>:AS_SYSTEMID, AS_PURCHASERETURNBILLID=>:AS_PURCHASERETURNBILLID, AS_PURCHASERETURNBILLNO=>:AS_PURCHASERETURNBILLNO, AS_PURCHASERETURNTYPEID=>:AS_PURCHASERETURNTYPEID, AS_DEPARTMENTID=>:AS_DEPARTMENTID, AS_USERID=>:AS_USERID, AS_BILLSTATE=>:AS_BILLSTATE, DESCERR=>:DESCERR); end; |
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 ( ) |
6uhvyfmmqfkgr | SELECT COUNT(1) FROM WAYBILL_PACKAGINGSKU R WHERE R.BILL_STATE = '02' AND R.SYSTEMID = :B1 |
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" |
7urcp0fzuzgcc | UPDATE PURCHASE_RETURNBILLDETAIL T SET (T.CONSIGN_QUANTITY, T.CONSIGN_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) |
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; |
81pj6yhd2qp5k |
select count(:"SYS_B_0") from (Select Waybill_Packagingsku.Systemid, Waybill_Packagingsku.Mopocsalesorderbillid, Waybill_Packagingsku.Outersalesorderbillid, Waybill_Packagingsku.Packaging_Skuid, Waybill_Packagingsku.Packaging_Cost, Waybill_Packagingsku.Packaging_Weight, Waybill_Packagingsku.Packaging_Qty, Waybill_Packagingsku.Createtime, Waybill_Packagingsku.Updatetime, Waybill_Packagingsku.Bill_State, Waybill_Packagingsku.Oldbill_State, Waybill_Packagingsku.State_Desc, Base_Goodsinfo.Goodsno, Base_Goodsinfo.Goodsbarcode, Base_Goodsinfo.Goodsname, Base_Goodsinfo.Other_Barcodes, Waybill_Packagingsku.Warehouseid, Waybill_Packagingsku.Ownerid, Waybill_Packagingsku.Shopid, Waybill_Packagingsku.Departmentid, Waybill_Packagingsku.Sourceownerid, Waybill_Packagingsku.Sourcedepartmentid, Waybill_Packagingsku.WAYBILL_PACKAGENO From Waybill_Packagingsku, Base_Goodsinfo Where Waybill_Packagingsku.Packaging_Skuid = Base_Goodsinfo.Skuid AND Waybill_Packagingsku.WAREHOU
SEID=:"SYS_B_1" AND CREATETIME BETWEEN TO_DATE(:"SYS_B_2", :"SYS_B_3") AND TO_DATE(:"SYS_B_4", :"SYS_B_5") and WAREHOUSEID = :"SYS_B_6") |
830grrcnqx0ja |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (Select Waybill_Packagingsku.Systemid, Waybill_Packagingsku.Mopocsalesorderbillid, Waybill_Packagingsku.Outersalesorderbillid, Waybill_Packagingsku.Packaging_Skuid, Waybill_Packagingsku.Packaging_Cost, Waybill_Packagingsku.Packaging_Weight, Waybill_Packagingsku.Packaging_Qty, Waybill_Packagingsku.Createtime, Waybill_Packagingsku.Updatetime, Waybill_Packagingsku.Bill_State, Waybill_Packagingsku.Oldbill_State, Waybill_Packagingsku.State_Desc, Base_Goodsinfo.Goodsno, Base_Goodsinfo.Goodsbarcode, Base_Goodsinfo.Goodsname, Base_Goodsinfo.Other_Barcodes, Waybill_Packagingsku.Warehouseid, Waybill_Packagingsku.Ownerid, Waybill_Packagingsku.Shopid, Waybill_Packagingsku.Departmentid, Waybill_Packagingsku.Sourceownerid, Waybill_Packagingsku.Sourcedepartmentid, Waybill_Packagingsku.WAYBILL_PACKAGENO From Waybill_Packagingsku, Base_Goodsinfo Where Waybill_Packagingsku.Packaging_Skuid = Base_Goodsinfo.Skuid AND Waybill_Packagingsku.WARE
HOUSEID=:"SYS_B_0" AND CREATETIME BETWEEN TO_DATE(:"SYS_B_1", :"SYS_B_2") AND TO_DATE(:"SYS_B_3", :"SYS_B_4") and WAREHOUSEID = :"SYS_B_5") A WHERE ROWNUM <= :"SYS_B_6" ) WHERE RN > :"SYS_B_7" |
837svcmjhsf06 |
SELECT SALESORDER_BILLDETAIL.MOPOCSALESORDERBILLDETAILID, SALESORDER_BILLDETAIL.MOPOCSALESORDERBILLID, SALESORDER_BILLDETAIL.OUTERSALESORDERBILLID, SALESORDER_BILLDETAIL.OUTERSALESORDERBILLDETAILID, SALESORDER_BILLDETAIL.MOPOCSOURCEORDERBILLID, SALESORDER_BILLDETAIL.MOPOCSOURCEBILLDETAILID, SALESORDER_BILLDETAIL.OUTERSOURCEORDERBILLID, SALESORDER_BILLDETAIL.OUTERSOURCEBILLDETAILID, SALESORDER_BILLDETAIL.SHOPID, SALESORDER_BILLDETAIL.OWNERID, SALESORDER_BILLDETAIL.ORDERTYPEID, SALESORDER_BILLDETAIL.WAREHOUSEID, SALESORDER_BILLDETAIL.SKUID, SALESORDER_BILLDETAIL.SALEPRICE, SALESORDER_BILLDETAIL.DISCOUNT, SALESORDER_BILLDETAIL.ORDER_QTY, SALESORDER_BILLDETAIL.ORDER_SALEAMOUNT, SALESORDER_BILLDETAIL.ORDER_WEIGHT, SALESORDER_BILLDETAIL.ASSIGN_QTY, SALESORDER_BILLDETAIL.PICKING_QTY, SALESORDER_BILLDETAIL.QC_QTY, SALESORDER_BILLDETAIL.QC_SALEAMOUNT, SALESORDER_BILLDETAIL.QC_WEIGHT, SALESORDER_BILLDETAIL.CONSIGN_QTY, SALESORDER_BILLDETAIL.CONSIGN_SALEAMOUNT, SALESORDER
_BILLDETAIL.CONSIGN_WEIGHT, SALESORDER_BILLDETAIL.QCTIME, SALESORDER_BILLDETAIL.QCUSERID, SALESORDER_BILLDETAIL.ACTUALSHORTTIME, SALESORDER_BILLDETAIL.ACTUALSHORTUSERID, SALESORDER_BILLDETAIL.ACCOUNTDATE, SALESORDER_BILLDETAIL.ACCOUNTUSERID, SALESORDER_BILLDETAIL.MODIFIEDTIME, SALESORDER_BILLDETAIL.SHORTFLAG, SALESORDER_BILLDETAIL.ACTUALSHORTFLAG, SALESORDER_BILLDETAIL.UNITEFLAG, SALESORDER_BILLDETAIL.DONATIONFLAG, SALESORDER_BILLDETAIL.DMFLAG, SALESORDER_BILLDETAIL.ACCOUNTFLAG, SALESORDER_BILLDETAIL.VOUCHERFLAG, SALESORDER_BILLDETAIL.WAYBILLID, SALESORDER_BILLDETAIL.WAYBILLNO, SALESORDER_BILLDETAIL.WAYBILLDETAILID, SALESORDER_BILLDETAIL.PICKINGBILLID, SALESORDER_BILLDETAIL.PICKINGBILLNO, SALESORDER_BILLDETAIL.PICKINGBILLBATCHID, SALESORDER_BILLDETAIL.PICKINGBILLBATCHNO, SALESORDER_BILLDETAIL.ORDERMOVEINGBILLBATCHID, SALESORDER_BILLDETAIL.ORDERMOVEINGBILLBATCHNO, SALESORDER_BILLDETAIL.CREATETIME, SALESORDER_BILLDETAIL.UPDATETIME, SALESORDER_BILLDETAIL.BILL_STA
TE, SALESORDER_BILLDETAIL.OLDBILL_STATE, --SALESORDER_BILLDETAIL.STATE_DESC, BASE_GOODSINFO.PRODUCTID, BASE_GOODSINFO.BRANDID, BASE_GOODSINFO.GOODSNO, BASE_GOODSINFO.GOODSBARCODE, BASE_GOODSINFO.GOODSNAME, BASE_GOODSINFO.SNNO, BASE_GOODSINFO.DISPLAYNAME, BASE_GOODSINFO.ENGLISHNAME, BASE_GOODSINFO.MARKETPRICE, BASE_GOODSINFO.MNEMONICCODE, BASE_GOODSINFO.KEYWORD, BASE_GOODSINFO.GOODSTYPEID, BASE_GOODSINFO.STATISTICID, BASE_GOODSINFO.SEXPROPERTYID, BASE_GOODSINFO.SEASONPROPERTYID, BASE_GOODSINFO.AGEPROPERTYID, BASE_GOODSINFO.SALEPROPERTYID, BASE_GOODSINFO.COLORPROPERTYID, BASE_GOODSINFO.UNITRPROPERTYID, BASE_GOODSINFO.GRADEPROPERTYID, BASE_GOODSINFO.STYLEPROPERTYID, BASE_GOODSINFO.LEVELPROPERTYID, BASE_GOODSINFO.MANAGEPROPERTYID, BASE_GOODSINFO.REGISTERED_TRADEMARK, BASE_GOODSINFO.WARRANTYFLAG, BASE_GOODSINFO.WARRANTY, BASE_GOODSINFO.APPROVAL_CODE, BASE_GOODSINFO.PLACE_PRODUCTION, BASE_GOODSINFO.MANUFACTURER, BASE_GOODSINFO.MANUFACTURERGOODSNO, BASE_GOODST
YPE.GOODSTYPE_CODE, BASE_GOODSTYPE.GOODSTYPE_NAME, SALESORDER_BILL.STATE_DESC FROM SALESORDER_BILLDETAIL, BASE_GOODSINFO, BASE_GOODSTYPE, SALESORDER_BILL Where (SALESORDER_BILLDETAIL.SKUID = BASE_GOODSINFO.SKUID(+)) And (BASE_GOODSINFO.GOODSTYPEID = BASE_GOODSTYPE.GOODSTYPE_ID(+)) and salesorder_bill.mopocsalesorderbillid = SALESORDER_BILLDETAIL.MOPOCSALESORDERBILLID And ((SALESORDER_BILLDETAIL.mopocsalesorderbillid =:"SYS_B_0")) |
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 ) |
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; |
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; |
965myf8ddfzg8 |
SELECT SALESRETURN_INORDER.MOPOCSALESORDERBILLID, SALESRETURN_INORDER.OUTERSALESORDERBILLID, SALESRETURN_INORDER.MOPOCSOURCEORDERBILLID, SALESRETURN_INORDER.OUTERSOURCEORDERBILLID, SALESRETURN_INORDER.SHOPID, SALESRETURN_INORDER.OWNERID, SALESRETURN_INORDER.PLATFORMID, SALESRETURN_INORDER.PLATFORMSTATUS, SALESRETURN_INORDER.ORDERTYPEID, SALESRETURN_INORDER.INPUTTYPEID, SALESRETURN_INORDER.WAREHOUSEID, SALESRETURN_INORDER.ORDER_VARIETYQTY, SALESRETURN_INORDER.ORDER_DETAILQTY, SALESRETURN_INORDER.ORDER_QTY, SALESRETURN_INORDER.ORDER_SALEAMOUNT, SALESRETURN_INORDER.ORDER_WEIGHT, SALESRETURN_INORDER.ASSIGN_QTY, SALESRETURN_INORDER.PICKING_QTY, SALESRETURN_INORDER.QC_VARIETYQTY, SALESRETURN_INORDER.QC_QTY, SALESRETURN_INORDER.QC_SALEAMOUNT, SALESRETURN_INORDER.QC_WEIGHT, SALESRETURN_INORDER.CONSIGN_VARIETYQTY, SALESRETURN_INORDER.CONSIGN_QTY, SALESRETURN_INORDER.CONSIGN_SALEAMOUNT, SALESRETURN_INORDER.CONSIGN_WEIGHT, SALESRETURN_INORDER.GOODS_WEIGHT, SALESRETURN_I
NORDER.OTHERSGOODS_WEIGHT, SALESRETURN_INORDER.BUYERNICK, SALESRETURN_INORDER.BUYEREMAIL, SALESRETURN_INORDER.BUYERMESSAGE, SALESRETURN_INORDER.CUSTOMERID, SALESRETURN_INORDER.RECEIVERNAME, SALESRETURN_INORDER.RECEIVERADDRESS, SALESRETURN_INORDER.RECEIVERZIP, SALESRETURN_INORDER.RECEIVERSTATE, SALESRETURN_INORDER.RECEIVERCITY, SALESRETURN_INORDER.RECEIVERDISTRICT, SALESRETURN_INORDER.RECEIVERMOBILE, SALESRETURN_INORDER.RECEIVERPHONE, SALESRETURN_INORDER.ORDERTIME, SALESRETURN_INORDER.ENTERHEADQUARTERSTIME, SALESRETURN_INORDER.UNITEHEADQUARTERSTIME, SALESRETURN_INORDER.DISTRIBUTETIME, SALESRETURN_INORDER.ENTERWAREHOUSETIME, SALESRETURN_INORDER.UNITEWAREHOUSETIME, SALESRETURN_INORDER.IMPORTTIME, SALESRETURN_INORDER.IMPORTUSERID, SALESRETURN_INORDER.MERGETIME, SALESRETURN_INORDER.MERGEUSERID, SALESRETURN_INORDER.WAITINGTIME, SALESRETURN_INORDER.WAITINGUSERID, SALESRETURN_INORDER.CANCELWAITINGTIME, SALESRETURN_INORDER.CANCELWAITINGUSERID, SALESRETURN_INORDER.CANC
ELORDERTIME, SALESRETURN_INORDER.CANCELORDERUSERID, SALESRETURN_INORDER.ACTUALCANCELTIME, SALESRETURN_INORDER.ACTUALCANCELUSERID, SALESRETURN_INORDER.ORDERPRINTTIME, SALESRETURN_INORDER.ORDERPRINTUSERID, SALESRETURN_INORDER.ASSIGNORDERTIME, SALESRETURN_INORDER.ASSIGNORDERUSERID, SALESRETURN_INORDER.PICKINGTIME, SALESRETURN_INORDER.PICKINGUSERID, SALESRETURN_INORDER.QCTIME, SALESRETURN_INORDER.QCUSERID, SALESRETURN_INORDER.ACTUALSHORTTIME, SALESRETURN_INORDER.ACTUALSHORTUSERID, SALESRETURN_INORDER.PACKTIME, SALESRETURN_INORDER.PACKUSERID, SALESRETURN_INORDER.WAYBILLTIME, SALESRETURN_INORDER.WAYBILLUSERID, SALESRETURN_INORDER.HANDINGTIME, SALESRETURN_INORDER.HANDINGUSERID, SALESRETURN_INORDER.CONSIGNTIME, SALESRETURN_INORDER.CONSIGNUSERID, SALESRETURN_INORDER.ENDTIME, SALESRETURN_INORDER.ENDUSERID, SALESRETURN_INORDER.ACCOUNTDATE, SALESRETURN_INORDER.ACCOUNTUSERID, SALESRETURN_INORDER.MODIFIEDTIME, SALESRETURN_INORDER.SHORTFLAG, SALESRETURN_INORDER.ACTUALSHORT
FLAG, SALESRETURN_INORDER.UNITEFLAG, SALESRETURN_INORDER.ACCOUNTFLAG, SALESRETURN_INORDER.VOUCHERFLAG, SALESRETURN_INORDER.INNERSTATUS, SALESRETURN_INORDER.REFUNDSTATUS, SALESRETURN_INORDER.STOCKSTATUS, SALESRETURN_INORDER.DELIVERID, SALESRETURN_INORDER.DELIVERNO, SALESRETURN_INORDER.DELIVERYMODEID, SALESRETURN_INORDER.DELIVERYTIME, SALESRETURN_INORDER.RETURNMODEID, SALESRETURN_INORDER.PAYMENTMODEID, SALESRETURN_INORDER.REFUND_MODEID, SALESRETURN_INORDER.PACKAGING_MODEID, SALESRETURN_INORDER.PACKAGING_COST, SALESRETURN_INORDER.PACKAGING_SKUID, SALESRETURN_INORDER.RECEIVABLE_AMOUNT, SALESRETURN_INORDER.GOODS_PAYMENT, SALESRETURN_INORDER.DELIVERY_COST, SALESRETURN_INORDER.INVOICE_AMOUNT, SALESRETURN_INORDER.ACCOUNT_PAID, SALESRETURN_INORDER.SHOPPING_VOUCHER, SALESRETURN_INORDER.ACCOUNT_BALANCE, SALESRETURN_INORDER.PAYTIME, SALESRETURN_INORDER.INVOICEFLAG, SALESRETURN_INORDER.INVOICE_NAME, SALESRETURN_INORDER.INVOICE_CONTENT, SALESRETURN_INORDER.ORDER_DISCOUNT,
SALESRETURN_INORDER.GROUPORDERFLAG, SALESRETURN_INORDER.ADVANCEORDERFLAG, SALESRETURN_INORDER.PAYMENTFLAG, SALESRETURN_INORDER.BLENDFLAG, SALESRETURN_INORDER.RETURNREASONDESC, SALESRETURN_INORDER.WAYBILLID, SALESRETURN_INORDER.WAYBILLNO, SALESRETURN_INORDER.PICKINGBILLID, SALESRETURN_INORDER.PICKINGBILLNO, SALESRETURN_INORDER.PICKINGBILLBATCHID, SALESRETURN_INORDER.PICKINGBILLBATCHNO, SALESRETURN_INORDER.ORDERMOVEINGBILLBATCHID, SALESRETURN_INORDER.ORDERMOVEINGBILLBATCHNO, SALESRETURN_INORDER.WAREHOUSEAREAQTY, SALESRETURN_INORDER.WAREHOUSEAREAWAY, SALESRETURN_INORDER.CREATETIME, SALESRETURN_INORDER.UPDATETIME, SALESRETURN_INORDER.BILL_STATE, SALESRETURN_INORDER.OLDBILL_STATE, SALESRETURN_INORDER.STATE_DESC, salesreturn_inorder.costlyflag FROM SALESRETURN_INORDER WHERE SALESRETURN_INORDER.BILL_STATE in (:"SYS_B_0", :"SYS_B_1") and SALESRETURN_INORDER.ORDERTYPEID in (:"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5
") and SALESRETURN_INORDER.MOPOCSOURCEORDERBILLID LIKE :"SYS_B_6" and SALESRETURN_INORDER.WAREHOUSEID = :"SYS_B_7" |
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" |
9b9cx124fxqah |
select count(:"SYS_B_00") 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_LEAD
IN.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_01" as selectedflag, WAYBILL_LEADIN.INPUTTYPEID, WAYBILL_LEADIN.ORDER_SALEAMOUNT, WAYBILL_LEADIN.PLATFORMID, WAYBILL_LEADIN.CUSTOMER_MESSAGE From WAYBILL_LEADIN Where :"SYS_B_02"=:"SYS_B_03" And ALLOT_OCCUPY_FLAG = :"SYS_B_04" and WAREHOUSEID=:"SYS_B_05"
And nvl(DELIVERID, :"SYS_B_06") = :"SYS_B_07" And (WAYBILL_LEADIN.OWNERID =:"SYS_B_08") and Not Exists ( Select :"SYS_B_09" From Base_Shopgroup, Base_Shopgroup_Shop Where Base_Shopgroup.Shopgroupid = Base_Shopgroup_Shop.Shopgroupid And Base_Shopgroup_Shop.Enableflag = :"SYS_B_10" And Base_Shopgroup.Enableflag = :"SYS_B_11" 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 ) |
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 |
b9vkrdqqk15mr | SELECT COUNT(1) FROM WAYBILL_PACKAGE T WHERE T.MOPOCSALESORDERBILLID = :B1 |
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 |
c412fnd0cdmc0 | SELECT COUNT(1) FROM IF_SALESORDER_BILL_INTERCEPT T WHERE T.MOPOCSALESORDERBILLID = :B1 AND NOT EXISTS (SELECT 1 FROM SALESORDER_BILL A WHERE A.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID AND A.BILL_STATE IN ('05', '06', '07', '08') UNION SELECT 1 FROM SALESRETURN_BILL S WHERE T.MOPOCSALESORDERBILLID = S.SALESORDERID AND S.BILL_STATE IN ('02', '03')) |
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 |
cwz9p369sva5w | SELECT COUNT(1) FROM SALESORDER_BILL_INTERCEPT T WHERE T.MOPOCSALESORDERBILLID = :B1 AND NOT EXISTS (SELECT 1 FROM SALESORDER_BILL A WHERE A.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID AND A.BILL_STATE IN ('05', '06', '07', '08') UNION SELECT 1 FROM SALESRETURN_BILL S WHERE T.MOPOCSALESORDERBILLID = S.SALESORDERID AND S.BILL_STATE IN ('02', '03')) |
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" |
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 ) |
f9qxutrsfs9m6 |
select count(:"SYS_B_0") from (select waybill_packagehangding.systemid, waybill_packagehangding.waybill_packageid, waybill_packagehangding.waybill_packageno, waybill_packagehangding.package_serial, waybill_packagehangding.package_number, waybill_packagehangding.mopocsalesorderbillid, waybill_packagehangding.outersalesorderbillid, waybill_packagehangding.shopid, waybill_packagehangding.ownerid, waybill_packagehangding.ordertypeid, waybill_packagehangding.warehouseid, waybill_packagehangding.inputtypeid, waybill_packagehangding.package_varietyqty, waybill_packagehangding.package_detailqty, waybill_packagehangding.package_qty, waybill_packagehangding.package_saleamount, waybill_packagehangding.goods_weight, waybill_packagehangding.othersgoods_weight, waybill_packagehangding.consign_weight, waybill_packagehangding.packaging_skuid, waybill_packagehangding.packaging_cost, waybill_packagehangding.receivable_amount, waybill_packagehangding.scanno, waybill_packa
gehangding.deliverid, waybill_packagehangding.deliverno, waybill_packagehangding.delivernoprintflag, waybill_packagehangding.printnum, waybill_packagehangding.pickingbillid, waybill_packagehangding.pickingbillno, waybill_packagehangding.batchbillid, waybill_packagehangding.batchbillno, waybill_packagehangding.createuserid, waybill_packagehangding.updateuserid, waybill_packagehangding.createtime, waybill_packagehangding.updatetime, waybill_packagehangding.bill_state, waybill_packagehangding.oldbill_state, waybill_packagehangding.state_desc, waybill_packagehangding.packtime, waybill_packagehangding.packuserid, waybill_packagehangding.handingtime, waybill_packagehangding.handinguserid, waybill_packagehangding.waybillid, waybill_packagehangding.waybillno, waybill_packagehangding.posid, 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, base_goodsinfo.goodsbarcode, PICKING_BILL.PICKINGFLAG from waybill_packagehangding, salesorder_bill, BASE_PROVINCE, BASE_CITY, BASE_AREA, base_goodsinfo, PICKING_BILL where waybill_packagehangding.mopocsalesorderbillid = salesorder_bill.mopocsalesorderbillid 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 waybill_packagehangding.packaging_skuid = base_goodsinfo.skuid(+) and waybill_packagehangding.PICKINGBILLID = picking_bill.pickingbillid(+) AND WAYBILL_PACKAGEHANGDING.WAREHOUSEID=:"SYS_B_1" AND WAYBILL_PACKAGEHANGDING.OUTERSALESORDERBILLID = :"SYS_B_2" Order By CREATETIME desc, WAYBILL_PACKAGEID desc ) |
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 |
fp6r6v4ruj77h | begin Picking_Bill_Order_Sure_Cd30(AS_SYSTEMID=>:AS_SYSTEMID, AS_ORDERBILLID=>:AS_ORDERBILLID, AS_BILLSTATE=>:AS_BILLSTATE, AS_USERID=>:AS_USERID, DESCERR=>:DESCERR); end; |
g0g00yjvb0f5n |
Select nvl(z.Entering_Weight, :"SYS_B_0")||:"SYS_B_1" Entering_Weight, :reprintflag, s.Goodsname, g.Entering_Qty, z.packagebillno, pr.purchasereturnbillno, pr.OUTPURCHASERETURNBILLNO, decode( pr.OUTPURCHASERETURNBILLNO, null, pr.purchasereturnbillno, pr.OUTPURCHASERETURNBILLNO) printcod, z.logisticsbillno, ck.SUPPLY_DELIVERYTEL, ck.Supply_Deliveryaddress, pr.remark, ck.SUPPLY_DELIVERYCONTACT, rownum pbrp34_compute_1, decode(s.goodsno, null , s.goodsbarcode, s.goodsno ) pbrp34_compute_9, sysdate pbrp34_date_1 From Package_Billdetail g Left Join Base_Goodsinfo s On s.Skuid = g.Skuid Left Join Package_Bill z On z.Packagebillid = g.Packagebillid Left Join Base_Company Hz On Hz.Companyid = z.Ownerid Left Join Base_Warehouse Ck On Ck.Warehouseid = z.Warehouseid left join purchase_returnbill pr on (z.Logisticstypeid =:"SYS_B_2" and z.logisticsbillid = pr.purchasereturnbillid) where g.packagebillid=:arg_billid
|
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 |