WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
WZOL	3239828958	wzol	1	06-11月-13 23:11	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
db-m4-85	Linux x86 64-bit	32	16	2	31.27

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	19126	30-11月-13 10:00:21	87	1.3
End Snap:	19130	30-11月-13 12:00:28	76	1.2
Elapsed:		120.11 (mins)
DB Time:		396.98 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	11,776M	11,776M	Std Block Size:	8K
Shared Pool Size:	3,136M	3,136M	Log Buffer:	18,868K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	3.3	0.3	0.02	0.03
DB CPU(s):	2.8	0.3	0.02	0.02
Redo size:	185,182.0	17,795.7
Logical reads:	350,928.2	33,723.5
Block changes:	915.4	88.0
Physical reads:	2,444.8	234.9
Physical writes:	45.6	4.4
User calls:	114.0	11.0
Parses:	23.6	2.3
Hard parses:	0.2	0.0
W/A MB processed:	26.8	2.6
Logons:	0.4	0.0
Executes:	157.9	15.2
Rollbacks:	0.1	0.0
Transactions:	10.4

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	99.72	Soft Parse %:	99.12
Execute to Parse %:	85.09	Latch Hit %:	99.74
Parse CPU to Parse Elapsd %:	95.47	% Non-Parse CPU:	99.75

Shared Pool Statistics

	Begin	End
Memory Usage %:	48.80	59.58
% SQL with executions>1:	95.36	95.59
% Memory for SQL w/exec>1:	90.51	92.14

Top 5 Timed Foreground Events

Host CPU (CPUs: 32 Cores: 16 Sockets: 2)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
2.23	0.61	8.4	0.3	0.8	91.2

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
8.7	99.2	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	32,022.3	32,022.3
SGA use (MB):	15,680.0	15,680.0
PGA use (MB):	790.1	690.1
% Host Mem used for SGA+PGA:	51.43	51.12

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• Shared Server Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 23818.6s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 99.7% of Total DB time 23,818.64 (s)
• Total FG Wait Time: 3,786.29 (s) DB CPU time: 19,962.52 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 80.7% of Total DB Time (s): 23,819
• Captured PL/SQL account for 21.3% of Total DB Time (s): 23,819

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 90.1% of Total CPU Time (s): 19,963
• Captured PL/SQL account for 24.9% of Total CPU Time (s): 19,963

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 69.9% of Total User I/O Wait Time (s): 1,694
• Captured PL/SQL account for 5.7% of Total User I/O Wait Time (s): 1,694

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - Buffer Gets as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 2,529,097,153
• Captured SQL account for 88.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 17,619,611
• Captured SQL account for 88.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 303,182
• Captured SQL account for 49.0% of Total
• Total UnOptimized Read Requests: 303,182
• Captured SQL account for 49.0% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 1,137,762
• Captured SQL account for 12.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 169,686
• Captured SQL account for 22.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Buffer Pool Statistics
• Checkpoint Activity

Buffer Pool Statistics

• Standard block size Pools D: default, K: keep, R: recycle
• Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 328,582

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

• Instance Recovery Stats
• MTTR Advisory
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin Snapshot, E: End Snapshot

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

• SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
• Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

Back to Advisory Statistics
Back to Top

Streams Pool Advisory