WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
WZOL	3239828958	wzol	1	14-12月-13 19:12	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:	19905	16-12月-13 15:00:39	102	1.0
End Snap:	19909	16-12月-13 17:00:09	119	1.0
Elapsed:		119.50 (mins)
DB Time:		1,792.17 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	11,456M	11,456M	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):	15.0	2.2	0.09	0.11
DB CPU(s):	1.7	0.2	0.01	0.01
Redo size:	198,663.1	28,734.9
Logical reads:	162,403.3	23,490.2
Block changes:	1,154.1	166.9
Physical reads:	922.2	133.4
Physical writes:	71.0	10.3
User calls:	140.0	20.3
Parses:	26.2	3.8
Hard parses:	0.3	0.1
W/A MB processed:	19.0	2.7
Logons:	0.5	0.1
Executes:	160.8	23.3
Rollbacks:	0.0	0.0
Transactions:	6.9

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	99.95
Buffer Hit %:	99.89	In-memory Sort %:	100.00
Library Hit %:	99.46	Soft Parse %:	98.70
Execute to Parse %:	83.69	Latch Hit %:	99.81
Parse CPU to Parse Elapsd %:	84.31	% Non-Parse CPU:	99.51

Shared Pool Statistics

	Begin	End
Memory Usage %:	54.86	53.36
% SQL with executions>1:	85.98	91.93
% Memory for SQL w/exec>1:	86.55	87.04

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
6.77	3.93	5.1	0.3	7.2	94.7

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
5.3	98.6	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):	760.9	820.1
% Host Mem used for SGA+PGA:	51.34	51.53

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): 107530.1s
• 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 97.7% of Total DB time 107,530.07 (s)
• Total FG Wait Time: 93,118.03 (s) DB CPU time: 11,963.43 (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)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) h is 4096*1024 milliseconds (approximately 70 minutes or 1.17 hours)
• % 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

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 20.3% of Total DB Time (s): 107,530
• Captured PL/SQL account for 7.9% of Total DB Time (s): 107,530

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 88.3% of Total CPU Time (s): 11,963
• Captured PL/SQL account for 10.9% of Total CPU Time (s): 11,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 41.0% of Total User I/O Wait Time (s): 21,080
• Captured PL/SQL account for 29.9% of Total User I/O Wait Time (s): 21,080

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: 1,164,432,582
• Captured SQL account for 84.5% 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: 6,612,457
• Captured SQL account for 55.7% 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: 566,403
• Captured SQL account for 18.3% of Total
• Total UnOptimized Read Requests: 566,403
• Captured SQL account for 18.3% 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,152,720
• Captured SQL account for 15.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 188,015
• Captured SQL account for 20.4% 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
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"
0gkrn3gmumb0j	SELECT * FROM (SELECT A.*, ROWNUM RN FROM (Select Purchase_Order_Details.Systemid, Purchase_Order_Details.Pdetailid, Purchase_Order_Details.Porderid, Purchase_Order_Details.Porderno, Purchase_Order.Warehouseid, Purchase_Order.Ownerid, Purchase_Order.Departmentid, Purchase_Order.Supplierid, Purchase_Order.Deliveryno, Purchase_Order.Batchno, Purchase_Order.Boxno, Purchase_Order_Details.Skuid, Base_Goodsinfo.Goodsno, Base_Goodsinfo.Goodsbarcode, Base_Goodsinfo.Other_Barcodes, Base_Goodsinfo.Goodsname, Purchase_Order_Details.Price, Purchase_Order_Details.Warranty_Enddate, Purchase_Order_Details.Warranty, Purchase_Order_Details.Production_Batchnumber, Purchase_Order_Details.Inform_Quantity, Purchase_Order_Details.Receive_Quantity, Purchase_Order_Details.Remark, Purchase_Order.State_Desc, Purchase_Order.Outporderno, Purchase_Order.bill_State From Purchase_Order, Purchase_Order_Details, Base_Goodsinfo Where Purchase_Order.Porderid = Purchase_Order_Details.Porderid A nd Purchase_Order_Details.Skuid = Base_Goodsinfo.Skuid(+) and nvl(PURCHASE_ORDER.PURCHASETYPEID, :"SYS_B_0")<>:"SYS_B_1" and Purchase_Order.WAREHOUSEID=:"SYS_B_2" AND BATCHNO Like :"SYS_B_3" and PORDERNO Like :"SYS_B_4" Order By porderno desc) A WHERE ROWNUM <= :"SYS_B_5" ) WHERE RN > :"SYS_B_6"
0hhw9s8dy1bnf	begin Picking_Bill_Quality_cd30(AS_SYSTEMID=>:AS_SYSTEMID, AS_PICKINGBILLID=>:AS_PICKINGBILLID, AS_PICKINGBILLNO=>:AS_PICKINGBILLNO, AS_WAREHOUSEID=>:AS_WAREHOUSEID, AS_BILLSTATE=>:AS_BILLSTATE, AS_USERID=>:AS_USERID, AS_POSID=>:AS_POSID, DESCERR=>:DESCERR); end;
0k28mb75n0pgd	SELECT WAYBILL_PACKAGE.DELIVERID, COUNT(*) AS SL, D.DELIVERGROUPID, D.GROUPNAME, BASE_COMPANY.COMPANYNAME FROM WAYBILL_PACKAGE LEFT JOIN BASE_COMPANY ON WAYBILL_PACKAGE.DELIVERID = BASE_COMPANY.COMPANYID LEFT JOIN BASE_DELIVER_GROUP G ON (G.DELIVERID = BASE_COMPANY.COMPANYID AND G.ENABLEFLAG=:"SYS_B_0" AND G.WAREHOUSEID=:"SYS_B_1") LEFT JOIN BASE_DELIVER D ON (D.DELIVERGROUPID = G.DELIVERGROUPID AND D.ENABLEFLAG=:"SYS_B_2") WHERE BILL_STATE = :"SYS_B_3" AND STATE_DESC <> :"SYS_B_4" AND WAYBILL_PACKAGE.WAREHOUSEID= :"SYS_B_5" GROUP BY WAYBILL_PACKAGE.DELIVERID, D.DELIVERGROUPID, D.GROUPNAME, BASE_COMPANY.COMPANYNAME order by D.GROUPNAME, BASE_COMPANY.COMPANYNAME
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0tfq654877r7p	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 PICKINGBILLNO Like :"SYS_B_1" Order By MOPOCSALESORDERBILLID) A WHERE ROWNUM <= :"SYS_B_2" ) WHERE RN > :"SYS_B_3"
11k6jqrvqbpzy	begin Waybill_Packagehanding_Batch30(AS_SYSTEMID=>:AS_SYSTEMID, AS_BATCHBILLID=>:AS_BATCHBILLID, AS_BATCHBILLNO=>:AS_BATCHBILLNO, AS_USERID=>:AS_USERID, DESCERR=>:DESCERR); end;
121am7c1dynmb	SELECT DISTINCT WAREHOUSEID , COUNT(*)AS SL FROM WAYBILL_PACKAGE WHERE BILL_STATE=:"SYS_B_0" AND STATE_DESC<>:"SYS_B_1" AND WAREHOUSEID =:"SYS_B_2" GROUP BY WAREHOUSEID, BILL_STATE
13zy4w2mmkdzu	select count(:"SYS_B_0") from (SELECT BASE_COMPANY.COMPANYCODE, BASE_COMPANY.COMPANYNAME, BASE_GOODSINFO.SKUID, BASE_GOODSINFO.BRANDID, BASE_GOODSINFO.GOODSNO, BASE_GOODSINFO.GOODSBARCODE, BASE_GOODSINFO.GOODSNAME, BASE_GOODSINFO.SNFLAG, BASE_GOODSINFO.MARKETPRICE, BASE_GOODSINFO.GOODSTYPEID, BASE_GOODSINFO.STATISTICID, BASE_WAREHOUSECARGOSPACE.CARGOSPACECODE, INVENTORY_CARGOSPACEINOUT.SYSTEMID, INVENTORY_CARGOSPACEINOUT.INVENTORYINOUTDETAILID, INVENTORY_CARGOSPACEINOUT.RELATEINVENTORYINOUTDETAILID, INVENTORY_CARGOSPACEINOUT.INOUTTYPEID, INVENTORY_CARGOSPACEINOUT.INVENTORYCARGOSPACEID, INVENTORY_CARGOSPACEINOUT.INVENTORYOWNERID, INVENTORY_CARGOSPACEINOUT.OWNERID, INVENTORY_CARGOSPACEINOUT.DEPARTMENTID, INVENTORY_CARGOSPACEINOUT.WAREHOUSEID, INVENTORY_CARGOSPACEINOUT.WAREHOUSEAREAID, INVENTORY_CARGOSPACEINOUT.CARGOSPACEID, INVENTORY_CARGOSPACEINOUT.PRODUCTION_DATE, INVENTORY_CARGOSPACEINOUT.PACKED_DATE, INVENTORY_CARGOSPACEINOUT.WARRANTY_ENDDATE, INVE NTORY_CARGOSPACEINOUT.WARRANTY, INVENTORY_CARGOSPACEINOUT.PRODUCTION_BATCHNUMBER, INVENTORY_CARGOSPACEINOUT.BUSINESSTYPEID, INVENTORY_CARGOSPACEINOUT.BUSINESSBILLID, INVENTORY_CARGOSPACEINOUT.BUSINESSBILLNO, INVENTORY_CARGOSPACEINOUT.BUSINESSBILLDETAILID, INVENTORY_CARGOSPACEINOUT.LOGISTICSTYPEID, INVENTORY_CARGOSPACEINOUT.LOGISTICSBILLID, INVENTORY_CARGOSPACEINOUT.LOGISTICSBILLNO, INVENTORY_CARGOSPACEINOUT.LOGISTICSBILLDETAILID, INVENTORY_CARGOSPACEINOUT.PRICE, INVENTORY_CARGOSPACEINOUT.INOUTQTY, INVENTORY_CARGOSPACEINOUT.INOUTQTY_PRICEAMOUNT, INVENTORY_CARGOSPACEINOUT.OCCUPYQTY, INVENTORY_CARGOSPACEINOUT.FINALLYQTY, INVENTORY_CARGOSPACEINOUT.FINALLYQTY_PRICEAMOUNT, INVENTORY_CARGOSPACEINOUT.REMARK, INVENTORY_CARGOSPACEINOUT.CREATEDATE, INVENTORY_CARGOSPACEINOUT.UPDATEDATE , BASE_PRODUCTINFO.PRODUCENO, BASE_PRODUCTINFO.PRODUCTNAME, SHELVE_BILLSOURCE.Shelvebillno FROM INVENTORY_CARGOSPACEINOUT left join BASE_GOODSINFO on BASE_GOODSINFO.SKUID = INVENTORY_CARGOSPACEI NOUT.SKUID left join BASE_WAREHOUSECARGOSPACE on BASE_WAREHOUSECARGOSPACE.CARGOSPACEID = INVENTORY_CARGOSPACEINOUT.CARGOSPACEID left join BASE_COMPANY on BASE_COMPANY.COMPANYID = INVENTORY_CARGOSPACEINOUT.OWNERID left join BASE_PRODUCTINFO on BASE_PRODUCTINFO.PRODUCTID = BASE_GOODSINFO.PRODUCTID left join SHELVE_BILLSOURCE on SHELVE_BILLSOURCE.Targetinoutdetailid = INVENTORY_CARGOSPACEINOUT.Inventoryinoutdetailid where :"SYS_B_1"=:"SYS_B_2" AND INVENTORY_CARGOSPACEINOUT.WAREHOUSEID=:"SYS_B_3" AND BASE_GOODSINFO.GOODSBARCODE = :"SYS_B_4" Order By INVENTORY_CARGOSPACEINOUT.CREATEDATE desc )
1652p5s5jsk4w	SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT BASE_COMPANY.COMPANYCODE, BASE_COMPANY.COMPANYNAME, BASE_GOODSINFO.SKUID, BASE_GOODSINFO.BRANDID, BASE_GOODSINFO.GOODSNO, BASE_GOODSINFO.GOODSBARCODE, BASE_GOODSINFO.GOODSNAME, BASE_GOODSINFO.SNFLAG, BASE_GOODSINFO.MARKETPRICE, BASE_GOODSINFO.GOODSTYPEID, BASE_GOODSINFO.STATISTICID, BASE_WAREHOUSECARGOSPACE.CARGOSPACECODE, INVENTORY_CARGOSPACEINOUT.SYSTEMID, INVENTORY_CARGOSPACEINOUT.INVENTORYINOUTDETAILID, INVENTORY_CARGOSPACEINOUT.RELATEINVENTORYINOUTDETAILID, INVENTORY_CARGOSPACEINOUT.INOUTTYPEID, INVENTORY_CARGOSPACEINOUT.INVENTORYCARGOSPACEID, INVENTORY_CARGOSPACEINOUT.INVENTORYOWNERID, INVENTORY_CARGOSPACEINOUT.OWNERID, INVENTORY_CARGOSPACEINOUT.DEPARTMENTID, INVENTORY_CARGOSPACEINOUT.WAREHOUSEID, INVENTORY_CARGOSPACEINOUT.WAREHOUSEAREAID, INVENTORY_CARGOSPACEINOUT.CARGOSPACEID, INVENTORY_CARGOSPACEINOUT.PRODUCTION_DATE, INVENTORY_CARGOSPACEINOUT.PACKED_DATE, INVENTORY_CARGOSPACEINOUT.WARRANTY_ENDDATE, I NVENTORY_CARGOSPACEINOUT.WARRANTY, INVENTORY_CARGOSPACEINOUT.PRODUCTION_BATCHNUMBER, INVENTORY_CARGOSPACEINOUT.BUSINESSTYPEID, INVENTORY_CARGOSPACEINOUT.BUSINESSBILLID, INVENTORY_CARGOSPACEINOUT.BUSINESSBILLNO, INVENTORY_CARGOSPACEINOUT.BUSINESSBILLDETAILID, INVENTORY_CARGOSPACEINOUT.LOGISTICSTYPEID, INVENTORY_CARGOSPACEINOUT.LOGISTICSBILLID, INVENTORY_CARGOSPACEINOUT.LOGISTICSBILLNO, INVENTORY_CARGOSPACEINOUT.LOGISTICSBILLDETAILID, INVENTORY_CARGOSPACEINOUT.PRICE, INVENTORY_CARGOSPACEINOUT.INOUTQTY, INVENTORY_CARGOSPACEINOUT.INOUTQTY_PRICEAMOUNT, INVENTORY_CARGOSPACEINOUT.OCCUPYQTY, INVENTORY_CARGOSPACEINOUT.FINALLYQTY, INVENTORY_CARGOSPACEINOUT.FINALLYQTY_PRICEAMOUNT, INVENTORY_CARGOSPACEINOUT.REMARK, INVENTORY_CARGOSPACEINOUT.CREATEDATE, INVENTORY_CARGOSPACEINOUT.UPDATEDATE , BASE_PRODUCTINFO.PRODUCENO, BASE_PRODUCTINFO.PRODUCTNAME, SHELVE_BILLSOURCE.Shelvebillno FROM INVENTORY_CARGOSPACEINOUT left join BASE_GOODSINFO on BASE_GOODSINFO.SKUID = INVENTORY_CARGOSPA CEINOUT.SKUID left join BASE_WAREHOUSECARGOSPACE on BASE_WAREHOUSECARGOSPACE.CARGOSPACEID = INVENTORY_CARGOSPACEINOUT.CARGOSPACEID left join BASE_COMPANY on BASE_COMPANY.COMPANYID = INVENTORY_CARGOSPACEINOUT.OWNERID left join BASE_PRODUCTINFO on BASE_PRODUCTINFO.PRODUCTID = BASE_GOODSINFO.PRODUCTID left join SHELVE_BILLSOURCE on SHELVE_BILLSOURCE.Targetinoutdetailid = INVENTORY_CARGOSPACEINOUT.Inventoryinoutdetailid where :"SYS_B_0"=:"SYS_B_1" AND INVENTORY_CARGOSPACEINOUT.WAREHOUSEID=:"SYS_B_2" AND BASE_GOODSINFO.GOODSBARCODE = :"SYS_B_3" Order By INVENTORY_CARGOSPACEINOUT.CREATEDATE desc ) A WHERE ROWNUM <= :"SYS_B_4" ) WHERE RN > :"SYS_B_5"
1jhr8us51ayju	Select m.Goodstype_Name 部类, m.Depname 营销部门, m.Brand_Name 品牌, m.Skuid 商品sku, m.Goodsname 商品名称, m.Goodsno 商品编码, m.Goodsbarcode 条形码, m.Orikc 期初数量, m.Cursh 本期进货数量, m.Curjt 本期进退数量, m.Curxs 本期销售数量, m.Curxt 本期销退数量, m.Curps 本期报失数量, m.Curpy 本期报益数量, m.Curout 本期移仓出库数量, m.Curin 本期移仓收货数量, m.Endkc 期末数量 From (Select b.Goodstype_Name, Bm.Depname, p.Brand_Name, g.Skuid, g.Goodsname, g.Goodsno, g.Goodsbarcode, Sum(s.Lastsh + s.Lastxt - s.Lastjt - s.Lastxs - s.Lastps + s.Lastpy - s.Lastout + s.Lastin) Orikc, Sum(s.Cursh) Cursh, Sum(s.Curjt) Curjt, Sum(s.Curxs) Curxs, Sum(s.Curxt) Curxt, Sum(s.Curps) Curps, Sum(s.Curpy) Curpy, Sum(s.Curout) Curout, Sum(s.Curin) Curin, Sum(s.Shsl + s.Xtsl - s.Jtsl - s.Xssl - s.Pssl + s.Pysl - s.Ycout + s.Ycin) Endkc From (Select t.Skuid, k.Departmentid, Sum(t.Actual_Qty) Shsl, :"SYS_B_000" Shje, :"SYS_B_001" Xtsl, :"SYS_B_002" Xtje, :"SYS_B_003" Jtsl, :"SYS_B_004" Jtje, :"SYS_B_0 05" Xssl, :"SYS_B_006" Xsje, :"SYS_B_007" Pssl, :"SYS_B_008" Psje, :"SYS_B_009" Pysl, :"SYS_B_010" Pyje, :"SYS_B_011" Ycout, :"SYS_B_012" Ycin, Sum(Decode(Sign(k.Receivedate - To_Date(:"SYS_B_013", :"SYS_B_014")), :"SYS_B_015", t.Actual_Qty, :"SYS_B_016")) Cursh, :"SYS_B_017" Curxt, :"SYS_B_018" Curjt, :"SYS_B_019" Curxs, :"SYS_B_020" Curps, :"SYS_B_021" Curpy, :"SYS_B_022" Curout, :"SYS_B_023" Curin, Sum(Decode(Sign(k.Receivedate - To_Date(:"SYS_B_024", :"SYS_B_025")), -:"SYS_B_026", t.Actual_Qty, :"SYS_B_027")) Lastsh, :"SYS_B_028" Lastxt, :"SYS_B_029" Lastjt, :"SYS_B_030" Lastxs, :"SYS_B_031" Lastps, :"SYS_B_032" Lastpy, :"SYS_B_033" Lastout, :"SYS_B_034" Lastin From Receive_Billdetail t Left Join Receive_Bill k On k.Receivebillid = t.Receivebillid Where k.Ownerid = :"SYS_B_035" And k.Bill_State >= :"SYS_B_036" And k.Bill_State <> :"SYS_B_037" And t.Receive_Qty > :"SYS_B_038" And k.Businesstypeid <> :"SYS_B_039" And k.Receivedate < To_Date(:"SYS_B_040", :"SYS_B_041") Group By t.Skuid, k.Departmentid Union All Select t.Skuid, t.Departmentid, :"SYS_B_042", :"SYS_B_043", Sum(t.Return_Qty), Sum(Trunc(t.Return_Qty * t.Saleprice, :"SYS_B_044")), :"SYS_B_045", :"SYS_B_046", :"SYS_B_047", :"SYS_B_048", :"SYS_B_049", :"SYS_B_050", :"SYS_B_051", :"SYS_B_052", :"SYS_B_053", :"SYS_B_054", :"SYS_B_055", Sum(Decode(Sign(k.Confirmdate - To_Date(:"SYS_B_056", :"SYS_B_057")), :"SYS_B_058 ", t.Return_Qty, :"SYS_B_059")), :"SYS_B_060", :"SYS_B_061", :"SYS_B_062", :"SYS_B_063", :"SYS_B_064", :"SYS_B_065", :"SYS_B_066", Sum(Decode(Sign(k.Confirmdate - To_Date(:"SYS_B_067", :"SYS_B_068")), -:"SYS_B_069", t.Return_Qty, :"SYS_B_070")), :"SYS_B_071", :"SYS_B_072", :"SYS_B_073", :"SYS_B_074", :"SYS_B_075", :"SYS_B_076" From Salesreturn_Billdetail t Left Join Salesreturn_Bill k On k.Salesreturnbillid = t.Salesreturnbillid Where t.Ownerid = :"SYS_B_077" And k.Bill_State >= :"SYS_B_078" And k.Bill_State <> :"SYS_B_079" And t.Return_Qty > :"SYS_B_080" And k.Confirmdate < To_Date(:"SYS_B_081", :"SYS_B_082") Group By t.Skuid, t.Departmentid Union All Select t.Skuid, k.Departmentid, :"SYS_B_083", :"SYS_B_084", :"SYS_B_085", :"SYS_B_086", Sum(t.Consign_Quantity), Sum(Trunc(t.Price * t.Consign_Quantity, :"SYS_B_087")), :"SYS_B_088", :"SYS_B_089", :"SYS_B_090", :"SYS_B_091", :"SYS_B_092", :"SYS_B_093", :"SYS_B_094", :"SYS_B_095", :"SYS_B_096", :"SYS_B_097", Sum(Decode(Sign(k.Consigndate - To_Date(:"SYS_B_098", :"SYS_B_099")), :"SYS_B_100", t.Consign_Quantity, :"SYS_B_101")), :"SYS_B_102", :"SYS_B_103", :"SYS_B_104", :"SYS_B_105", :"SYS_B_106", :"SYS_B_107", :"SYS_B_108", Sum(Decode(Sign(k.Consigndate - To_Date(:"SYS_B_109", :"SYS_B_110")), -:"SYS_B_111", t.Consign_Quantity, :"SYS_B_112")), :"SYS_B_113", :"SYS_B_114", :"SYS_B_115", :"SYS_B_116", :"SYS_B_117" From Purchase_Returnbilldetail t Left Join Purchase_Returnbill k On k.Purchasereturnbillid = t.Purchasereturnbillid Where k.Ownerid = :"SYS_B_118" And k.Bill_State >= :"SYS_B_119" And k.Bill_State <> :"SYS_B_120" And k.Consigndate < To_Date(:"SYS_B_121", :"SYS_B_122") And t.Consign_Quantity > :"SYS_B_123" Group By t.Skuid, k.Departmentid Union All Select t.Skuid, t.Departmentid, :"SYS_B_124", :"SYS_B_125", :"SYS_B_126", :"SYS_B_127", :"SYS_B_128", :"SYS_B_129", Sum(t.Order_Qty), Sum(Trunc(t.Saleprice * t.Order_Qty, :"SYS_B_130")), :"SYS_B_131", :"SYS_B_132", :"SYS_B_133", :"SYS_B_134", :"SYS_B_135", :"SYS_B_136", :"SYS_B_137", :"SYS_B_138", :"SYS_B_139", Sum(Decode(Sign(k.Handingtime - To_Date(:"SYS_B_140", :"SYS_B_141")), :"SYS_B_142", t.Order_Qty, :"SYS_B_143")), :"SYS_B_144", :"SYS_B_145", :"SYS_B_146", :"SYS_B_147", :"SYS_B_148", :"SYS_B_149", :"SYS_B_150", Sum(Decode(Sign(k.Handingtime - To_Date(:"SYS_B_151", :"SYS_B_152")), -:"SYS_B_153", t.Order_Qty, :"SYS_B_154")), :"SYS_B_155", :"SYS_B_156", :"SYS_B_157", :"SYS_B_158" From Salesorder_Billdetail t Left Join Salesorder_Bill k On k.Mopocsalesorderbillid = t.Mopocsalesorderbillid Where t.Ownerid = :"SYS_B_159" And k.Bill_State <> :"SYS_B_160" And k.Bill_State >= :"SYS_B_161" And k.Ordertypeid In (:"SYS_B_162", :"SYS_B_163", :"SYS_B_164", :"SYS_B_165") And k.Handingtime < To_Date(:"SYS_B_166", :"SYS_B_167 ") Group By t.Skuid, t.Departmentid Union All Select t.Skuid, t.Departmentid, :"SYS_B_168", :"SYS_B_169", :"SYS_B_170", :"SYS_B_171", :"SYS_B_172", :"SYS_B_173", Sum(t.Order_Qty), Sum(Trunc(t.Saleprice * t.Order_Qty, :"SYS_B_174")), :"SYS_B_175", :"SYS_B_176", :"SYS_B_177", :"SYS_B_178", :"SYS_B_179", :"SYS_B_180", :"SYS_B_181", :"SYS_B_182", :"SYS_B_183", Sum(Decode(Sign(k.Handingtime - To_Date(:"SYS_B_184", :"SYS_B_185")), :"SYS_B_186", t.Order_Qty, :"SYS_B_187")), :"SYS_B_188", :"SYS_B_189", :"SYS_B_190", :"SYS_B_191", :"SYS_B_192", :"SYS_B_193", :"SYS_B_194", Sum(Decode(Sign(k.Handingtime - To_Date(:"SYS_B_195", :"SYS_B_196")), -:"SYS_B_197", t.Or der_Qty, :"SYS_B_198")), :"SYS_B_199", :"SYS_B_200", :"SYS_B_201", :"SYS_B_202" From Salesorder_Billdetail_His t Left Join Salesorder_Bill_His k On k.Mopocsalesorderbillid = t.Mopocsalesorderbillid Where t.Ownerid = :"SYS_B_203" And k.Bill_State <> :"SYS_B_204" And k.Bill_State >= :"SYS_B_205" And k.Ordertypeid In (:"SYS_B_206", :"SYS_B_207", :"SYS_B_208", :"SYS_B_209") And k.Handingtime < To_Date(:"SYS_B_210", :"SYS_B_211") Group By t.Skuid, t.Departmentid Union All Select t.Skuid, k.Departmentid, :"SYS_B_212", :"SYS_B_213", :"SYS_B_214", :"SYS_B_215", :"SYS_B_216", :"SYS_B_217", :"SYS_B_218", :"SYS_B_219", Sum(t.Qty), Sum(Trunc(t.Qty * t.Price, :"SYS_B_220")), :"SYS_B_221", :"SYS_B_222", :"SYS_B_2 23", :"SYS_B_224", :"SYS_B_225", :"SYS_B_226", :"SYS_B_227", :"SYS_B_228", Sum(Decode(Sign(k.Checkdate - To_Date(:"SYS_B_229", :"SYS_B_230")), :"SYS_B_231", t.Qty, :"SYS_B_232")), :"SYS_B_233", :"SYS_B_234", :"SYS_B_235", :"SYS_B_236", :"SYS_B_237", :"SYS_B_238", :"SYS_B_239", Sum(Decode(Sign(k.Checkdate - To_Date(:"SYS_B_240", :"SYS_B_241")), -:"SYS_B_242", t.Qty, :"SYS_B_243")), :"SYS_B_244", :"SYS_B_245", :"SYS_B_246" From Profitandloss_Billdetail t Left Join Profitandloss_Bill k On k.Profitandlossbillid = t.Profitandlossbillid Where k.Ownerid = :"SYS_B_247" And k.Bill_State >= :"SYS_B_248" And k.Bill_State <> :"SYS_B_249" And k.Profitandlosstypeid In (:"SYS_B_250", :"SYS_B _251", :"SYS_B_252", :"SYS_B_253") And k.Checkdate < To_Date(:"SYS_B_254", :"SYS_B_255") Group By t.Skuid, k.Departmentid Union All Select t.Skuid, k.Departmentid, :"SYS_B_256", :"SYS_B_257", :"SYS_B_258", :"SYS_B_259", :"SYS_B_260", :"SYS_B_261", :"SYS_B_262", :"SYS_B_263", :"SYS_B_264", :"SYS_B_265", Sum(t.Qty), Sum(Trunc(t.Qty * t.Price, :"SYS_B_266")), :"SYS_B_267", :"SYS_B_268", :"SYS_B_269", :"SYS_B_270", :"SYS_B_271", :"SYS_B_272", :"SYS_B_273", Sum(Decode(Sign(k.Checkdate - To_Date(:"SYS_B_274", :"SYS_B_275")), :"SYS_B_276", t.Qty, :"SYS_B_277")), :"SYS_B_278", :"SYS_B_279", :"SYS_B_280", :"SYS_B_281", :"SYS_B_282", :"SYS_B_2 83", :"SYS_B_284", Sum(Decode(Sign(k.Checkdate - To_Date(:"SYS_B_285", :"SYS_B_286")), -:"SYS_B_287", t.Qty, :"SYS_B_288")), :"SYS_B_289", :"SYS_B_290" From Profitandloss_Billdetail t Left Join Profitandloss_Bill k On k.Profitandlossbillid = t.Profitandlossbillid Where k.Ownerid = :"SYS_B_291" And k.Bill_State >= :"SYS_B_292" And k.Bill_State <> :"SYS_B_293" And k.Profitandlosstypeid In (:"SYS_B_294", :"SYS_B_295", :"SYS_B_296", :"SYS_B_297") And k.Checkdate < To_Date(:"SYS_B_298", :"SYS_B_299") Group By t.Skuid, k.Departmentid Union All Select Mx.Skuid, Mx.Departmentid, :"SYS_B_300", :"SYS_B_301", :"SYS_B_302", :"SYS_B_303", :"SYS_B_304", :"SYS_B_305", :"SYS_B_306", :"SYS_B_307", :"SYS_B_308", : "SYS_B_309", :"SYS_B_310", :"SYS_B_311", Sum(Mx.Inoutqty), :"SYS_B_312", :"SYS_B_313", :"SYS_B_314", :"SYS_B_315", :"SYS_B_316", :"SYS_B_317", :"SYS_B_318", Sum(Decode(Sign(Mx.Createdate - To_Date(:"SYS_B_319", :"SYS_B_320")), :"SYS_B_321", Mx.Inoutqty, :"SYS_B_322")), :"SYS_B_323", :"SYS_B_324", :"SYS_B_325", :"SYS_B_326", :"SYS_B_327", :"SYS_B_328", :"SYS_B_329", Sum(Decode(Sign(Mx.Createdate - To_Date(:"SYS_B_330", :"SYS_B_331")), -:"SYS_B_332", Mx.Inoutqty, :"SYS_B_333")), :"SYS_B_334" From Inventory_Inoutdetail Mx Where Mx.Logisticstypeid = :"SYS_B_335" And Mx.Ownerid = :"SYS_B_336" And Mx.Createdate < To_Date(:"SYS_B_337", :"SYS_B_338") Group By Mx.Skuid , Mx.Departmentid Union All Select Mx.Skuid, Mx.Departmentid, :"SYS_B_339", :"SYS_B_340", :"SYS_B_341", :"SYS_B_342", :"SYS_B_343", :"SYS_B_344", :"SYS_B_345", :"SYS_B_346", :"SYS_B_347", :"SYS_B_348", :"SYS_B_349", :"SYS_B_350", :"SYS_B_351", Sum(Mx.Inoutqty), :"SYS_B_352", :"SYS_B_353", :"SYS_B_354", :"SYS_B_355", :"SYS_B_356", :"SYS_B_357", :"SYS_B_358", Sum(Decode(Sign(Mx.Createdate - To_Date(:"SYS_B_359", :"SYS_B_360")), :"SYS_B_361", Mx.Inoutqty, :"SYS_B_362")), :"SYS_B_363", :"SYS_B_364", :"SYS_B_365", :"SYS_B_366", :"SYS_B_367", :"SYS_B_368", :"SYS_B_369", Sum(Decode(Sign(Mx.Createdate - To_Date(:"SYS_B_370", :"SYS_B_371 ")), -:"SYS_B_372", Mx.Inoutqty, :"SYS_B_373")) From Inventory_Inoutdetail Mx Where Mx.Businesstypeid = :"SYS_B_374" And Mx.Ownerid = :"SYS_B_375" And Mx.Createdate < To_Date(:"SYS_B_376", :"SYS_B_377") Group By Mx.Skuid, Mx.Departmentid) s Inner Join Base_Goodsinfo g On g.Skuid = s.Skuid Left Join Base_Goodstype b On b.Goodstype_Id = g.Goodstypeid Left Join Base_Brand p On p.Brand_Id = g.Brandid Left Join Base_Department Bm On Bm.Departmentid = s.Departmentid Where Nvl(g.Salepropertyid, :"SYS_B_378") <> :"SYS_B_379" Group By b.Goodstype_Name, Bm.Depname, p.Brand_Name, g.Skuid, g.Goodsname, g.Goodsno, g.Goodsbarcode) m Where m.Orikc + m.Cursh + m.Curjt + m.Curxs + m.Curxt + m.Curps + m.Curpy + m.Curout + m.Curin + m.Endkc > :"SYS_B_380" And m.Depname = :"SYS_B_381" Order By m.Skuid
1q5taw0aaz624	SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT RECEIVE_BILLDETAIL.SYSTEMID, RECEIVE_BILLDETAIL.RECEIVEBILLDETAILID, RECEIVE_BILLDETAIL.RECEIVEBILLID, RECEIVE_BILLDETAIL.RECEIVEBILLNO, RECEIVE_BILLDETAIL.SKUID, RECEIVE_BILLDETAIL.PRODUCTION_DATE, RECEIVE_BILLDETAIL.PACKED_DATE, RECEIVE_BILLDETAIL.WARRANTY_ENDDATE, RECEIVE_BILLDETAIL.WARRANTY, RECEIVE_BILLDETAIL.PRODUCTION_BATCHNUMBER, RECEIVE_BILLDETAIL.BILL_QTY, RECEIVE_BILLDETAIL.BILL_PRICEAMOUNT, RECEIVE_BILLDETAIL.BILL_WEIGHT, RECEIVE_BILLDETAIL.RECEIVE_QTY, RECEIVE_BILLDETAIL.RECEIVE_PRICEAMOUNT, RECEIVE_BILLDETAIL.RECEIVE_WEIGHT, RECEIVE_BILLDETAIL.DONATION_QTY, RECEIVE_BILLDETAIL.DONATION_PRICEAMOUNT, RECEIVE_BILLDETAIL.DAMAGE_QTY, RECEIVE_BILLDETAIL.DAMAGE_PRICEMOUNT, RECEIVE_BILLDETAIL.DAMAGE_WEIGHT, RECEIVE_BILLDETAIL.INPUTFLAG, RECEIVE_BILLDETAIL.BUSINESSTYPEID, RECEIVE_BILLDETAIL.BUSINESSBILLID, RECEIVE_BILLDETAIL.BUSINESSBILLNO, RECEIVE_BILLDETAIL.BUSINESSBILLDETAILID, BASE_GOODSINFO.PRODUCTID, BASE_GOODSINFO.BRANDID, BASE_GOODSINFO.GOODSNO, BASE_GOODSINFO.GOODSBARCODE, BASE_GOODSINFO.GOODSNAME, 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.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.SNFLAG, BASE_GOODSINFO.APPROVAL_CODE, BASE_GOODSINFO.PLACE_PRODUCTION, BASE_GOODSINFO.MANUFACTURER, BASE_GOODSINFO.MANUFACTURERGOODSNO, BASE_GOODSTYPE.GOODSTYPE_CODE, BASE_GOODSTYPE.GOODSTYPE_NAME, BASE_PRODUCTINFO.PRODUCENO, BASE_PRODUCTINFO.PRODUCTNAME, BASE_PRODUCTINFO.DISPLAYNAME, BASE_PRODUCTINFO.ENGLISHNAME, BASE_PRODUCTINFO.PRODUCTCODE, PURCHASE_ORDER.BO XNO , RECEIVE_BILLDETAIL.ACTUAL_QTY , RECEIVE_BILLDETAIL.ACTUAL_PRICEAMOUNT , RECEIVE_BILLDETAIL.ACTUAL_WEIGHT , RECEIVE_BILLDETAIL.LOSS_QTY , RECEIVE_BILLDETAIL.LOSS_PRICEAMOUNT , RECEIVE_BILLDETAIL.LOSS_WEIGHT , RECEIVE_BILL.OWNERID , RECEIVE_BILL.SUPPLIERID , RECEIVE_BILL.DEPARTMENTID , RECEIVE_BILL.WAREHOUSEID , RECEIVE_BILL.MARKETINGTYPEID , RECEIVE_BILL.BILL_STATE , RECEIVE_BILL.STATE_DESC, RECEIVE_BILL.RECEIVEDATE FROM RECEIVE_BILLDETAIL, BASE_GOODSINFO, BASE_GOODSTYPE, BASE_PRODUCTINFO, PURCHASE_ORDER, RECEIVE_BILL WHERE ( RECEIVE_BILLDETAIL.SKUID = BASE_GOODSINFO.SKUID(+) ) AND ( RECEIVE_BILLDETAIL.BUSINESSBILLID = PURCHASE_ORDER.PORDERID(+) ) AND ( BASE_GOODSINFO.GOODSTYPEID = BASE_GOODSTYPE.GOODSTYPE_ID(+) ) AND ( BASE_GOODSINFO.PRODUCTID = BASE_PRODUCTINFO.PRODUCTID(+) ) AND ( RECEIVE_BILLDETAIL.RECEIVEBILLID = RECEIVE_BILL.RECEIVEBILLID ) and instr(RECEIVE_BILLDETAIL.businesstypeid, :"SYS_B_0")<=:"SYS_B_1" and RECEIVE_BILL.WAREHOUSEID =:"SYS_B_ 2"AND instr(RECEIVE_BILLDETAIL.businesstypeid, :"SYS_B_3")<=:"SYS_B_4" AND RECEIVE_BILLDETAIL.BUSINESSBILLNO = :"SYS_B_5" Order By RECEIVEBILLNO DESC, SKUID ASC) A WHERE ROWNUM <= :"SYS_B_6" ) WHERE RN > :"SYS_B_7"
2776d4bpgv6hg	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" Order By CREATETIME desc, WAYBILL_PACKAGEID desc )
2cz2xq38xg1vv	Select G.Goodsbarcode 商品条码, G.Skuid, Sb.Order_Qty 数量 From Salesorder_Bill t, Salesorder_Billdetail Sb, Base_Goodsinfo g Where T.Bill_State > :"SYS_B_00" And Sb.Mopocsalesorderbillid = Sb.Mopocsalesorderbillid And Sb.Skuid = G.Skuid And T.Bill_State <> :"SYS_B_01" And T.Createtime >= To_Date(:"SYS_B_02", :"SYS_B_03") And T.Createtime <= To_Date(:"SYS_B_04", :"SYS_B_05") And Exists (Select :"SYS_B_06" From (Select Tt.Pickingbillid From Picking_Billsource_His Tt Where Tt.Jxfqid In (:"SYS_B_07", :"SYS_B_08") Union Select Tt.Pickingbillid From Picking_Billsource_His_Bhis Tt Where Tt.Warehouseareaid In (:"SYS_B_09", :"SYS_B_10")) d Where D.Pickingbillid = T.Pickingbillid) Union Select G.Goodsbarcode 商品条码, G.Skuid, Sb.Order_Qty 数量 From Salesorder_Bill_Bhis t, Salesorder_Billdetail_Bhis Sb, Base_Goodsinfo g Where T.Bill_State > :"SYS_B_11" And Sb .Mopocsalesorderbillid = Sb.Mopocsalesorderbillid And Sb.Skuid = G.Skuid And T.Bill_State <> :"SYS_B_12" And T.Createtime >= To_Date(:"SYS_B_13", :"SYS_B_14") And T.Createtime <= To_Date(:"SYS_B_15", :"SYS_B_16") And Exists (Select :"SYS_B_17" From ( Select Tt.Pickingbillid From Picking_Billsource_His Tt Where Tt.Warehouseareaid In (:"SYS_B_18", :"SYS_B_19") Union Select Tt.Pickingbillid From Picking_Billsource_His_Bhis Tt Where Tt.Warehouseareaid In (:"SYS_B_20", :"SYS_B_21")) d Where D.Pickingbillid = T.Pickingbillid)
2qvm7xd7x5gs8	select null from all_synonyms where :"SYS_B_0"=:"SYS_B_1"
2xav5v8c4mzm9	begin Shelve_Bill_Includewarehouse30(AS_SYSTEMID=>:AS_SYSTEMID, AS_WAREHOUSEID=>:AS_WAREHOUSEID, AS_SHELVE_BATCHID=>:AS_SHELVE_BATCHID, AS_SHELVE_BATCHNO=>:AS_SHELVE_BATCHNO, AS_ZCKQ_ZP=>:AS_ZCKQ_ZP, AS_ZCKQ_CP=>:AS_ZCKQ_CP, AS_ZCHW_ZP=>:AS_ZCHW_ZP, AS_ZCHW_CP=>:AS_ZCHW_CP, AS_USERID=>:AS_USERID, DESCERR=>:DESCERR); end;
342r5uabpnnps	begin Shelve_Bill_Sure30(AS_SYSTEMID=>:AS_SYSTEMID, AS_SHELVEBILLID=>:AS_SHELVEBILLID, AS_SHELVEBILLNO=>:AS_SHELVEBILLNO, AS_BUSINESSTYPEID=>:AS_BUSINESSTYPEID, AS_LOGISTICSTYPEID=>:AS_LOGISTICSTYPEID, AS_WAREHOUSEID=>:AS_WAREHOUSEID, AS_USERID=>:AS_USERID, AS_BILLSTATE=>:AS_BILLSTATE, DESCERR=>:DESCERR); end;
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
37g5sdzr2wupd	select Salesorder_Billstate_Seq2.nextval from dual
37ghrwx0wq00u	INSERT INTO SALESORDER_BILL (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, GOODS_WEIGHT, OTHERSGOODS_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, ORDE RPRINTTIME, ORDERPRINTUSERID, ASSIGNORDERTIME, ASSIGNORDERUSERID, PICKINGTIME, PICKINGUSERID, 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, 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, ORDERMOVEINGBILLB ATCHID, ORDERMOVEINGBILLBATCHNO, WAREHOUSEAREAQTY, WAREHOUSEAREAWAY, CREATETIME, UPDATETIME, BILL_STATE, OLDBILL_STATE, STATE_DESC, COSTLYFLAG, FROMSYSTEM, URGENT_FLAG, SALESODER_CODNO, CUSTOMER_MESSAGE) SELECT 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, GOODS_WEIGHT, OTHERSGOODS_WEIGHT, BUYERNICK, BUYEREMAIL, BUYERMESSAGE, CUSTOMERID, RECEIVERNAME, RECEIVERADDRESS, RECEIVERZIP, RECEIVERSTATE, RECEIVERCITY, RECEIVERDISTRICT, RECEIVERMOBILE, RECEIVERPHONE, ORDERTIME, ENTERHEADQUARTERSTIME, UNITEHEADQUARTERSTIME, DISTRIBUTETIME, SYSDATE, SYSDATE, SYSDATE, IMPORTUSERID, MERGETIME, MERGEUSERID, WAITINGTIME, WAITINGUSERID, CANCELWAITINGTIME, CANCELWAITINGUSERID, CANCELORDERTIME, CANCELORDERUSERID, ACTUALCANCELTIME, ACTUALCANCELUSERID, ORDERPRINTTIME, ORDERPRINTUSERID, ASSIGNORDERTIME, ASSIGNORDERUSERID, PICKINGTIME, PICKINGUSERID, 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, 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, ADVANCEOR DERFLAG, PAYMENTFLAG, BLENDFLAG, RETURNREASONDESC, WAYBILLID, WAYBILLNO, PICKINGBILLID, PICKINGBILLNO, PICKINGBILLBATCHID, PICKINGBILLBATCHNO, ORDERMOVEINGBILLBATCHID, ORDERMOVEINGBILLBATCHNO, WAREHOUSEAREAQTY, WAREHOUSEAREAWAY, CREATETIME, SYSDATE, BILL_STATE, OLDBILL_STATE, STATE_DESC, COSTLYFLAG, FROMSYSTEM, URGENT_FLAG, SALESODER_CODNO, CUSTOMER_MESSAGE FROM SALESORDER_BILL_TEMP WHERE ORDERTYPEID IN ('1', '4', '5', '7')
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)
3xm1c1qwmdy2g	select count(:"SYS_B_000") from (SELECT Trunc(k.统计日期) 统计日期, sum(k.进入总部单数) 进入总部单数, sum(k.总部合单单数) 总部合单单数, sum(k.仓库分单单数) 仓库分单单数, sum(k.Wms合单单数) Wms合单单数, sum(k.进入wms单数) 进入wms单数, sum(k.订单导入单数) 订单导入单数, sum(k.汇总订单单数) 汇总订单单数, sum(k.订单等待单数) 订单等待单数, sum(k.取消等待单数) 取消等待单数, sum(k.取消订单单数) 取消订单单数, sum(k.实际取消单数) 实际取消单数, sum(k.订单打印单数) 订单打印单数, sum(k.分配拣选单数) 分配拣选单数, sum(k.拣选拣货单数) 拣选拣货单数, sum(k.订单质检单数) 订单质检单数, sum(k.实物报缺单数) 实物报缺单数, sum(k.包裹包装单数) 包裹包装单数, sum(k.运号录入单数) 运号录入单数, sum(k.包裹交接单数) 包裹交接单数, sum(k.订单发出单数) 订单发出单数, sum(k.订单结束单数) 订单结束单数, sum(k.订单做账单数) 订单做账单数, sum(k.订单改单单数) 订单改单单数, sum(k.记录创建单数) 记录创建单数, sum(k.记录更新单数) 记录更新单数 FROM ( SELECT Trunc(t.Enterheadquarterstime) 统计日期, count(t.Mopocsalesorderbillid) 进入总部单数, :"SYS_B_001" 总部合单单数, :"SYS_B_002" 仓库分单单数, :"SYS_B_003" Wms合单单数, :"SYS_B_004" 进入wms单数, :"SYS_B_005" 订单导入单数, :"SYS_B_006" 汇总订单单数, :"SYS_B_007" 订单等待单数, :"SYS_B_008" 取消等待单数, : "SYS_B_009" 取消订单单数, :"SYS_B_010" 实际取消单数, :"SYS_B_011" 订单打印单数, :"SYS_B_012" 分配拣选单数, :"SYS_B_013" 拣选拣货单数, :"SYS_B_014" 订单质检单数, :"SYS_B_015" 实物报缺单数, :"SYS_B_016" 包裹包装单数, :"SYS_B_017" 运号录入单数, :"SYS_B_018" 包裹交接单数, :"SYS_B_019" 订单发出单数, :"SYS_B_020" 订单结束单数, :"SYS_B_021" 订单做账单数, :"SYS_B_022" 订单改单单数, :"SYS_B_023" 记录创建单数, :"SYS_B_024" 记录更新单数 FROM Salesorder_Bill t WHERE t.Enterheadquarterstime >= to_date(:"SYS_B_025", :"SYS_B_026") and t.WAREHOUSEID=:"SYS_B_027" AND t.Enterheadquarterstime <=to_date(:"SYS_B_028", :"SYS_B_029") GROUP BY Trunc(t.Enterheadquarterstime) UNION ALL SELECT Trunc(t.Uniteheadquarterstime) , :"SYS_B_030" , count(t.Mopocsalesorderbillid) , :"SYS_B_031", :"SYS_B_032", :"SYS_B_033", :"SYS_B_034", :"SYS_B_035", :"SYS_B_036", :"SYS_B_037", :"SYS_B_038", :"SYS_B_039", :"SYS_B_040", :"SYS_B_041", :"SYS_B_042", :"SYS_B_043", :"SYS_B_044", :"SYS_B_045", :"SYS_B_046", :"SYS_B_047", :"SYS_B_048", :"SYS_B_049", :"SYS_B_050", :"SYS_B_051", :"SYS_B_052", :"SYS_B_053" FROM Salesorder_Bill t WHERE t.Uniteheadquarterstime >= to_date(:"SYS_B_054", :"SYS_B_055") and t.WAREHOUSEID=:"SYS_B_056" AND t.Uniteheadquarterstime <= to_date(:"SYS_B_057", :"SYS_B_058") GROUP BY Trunc(t.Uniteheadquarterstime) UNION ALL SELECT Trunc( t.Distributetime) , :"SYS_B_059", :"SYS_B_060", count(t.Mopocsalesorderbillid) , :"SYS_B_061", :"SYS_B_062", :"SYS_B_063", :"SYS_B_064", :"SYS_B_065", : "SYS_B_066", :"SYS_B_067", :"SYS_B_068", :"SYS_B_069", :"SYS_B_070", :"SYS_B_071", :"SYS_B_072", :"SYS_B_073", :"SYS_B_074", :"SYS_B_075", :"SYS_B_076", :"SYS_B_077", :"SYS_B_078", :"SYS_B_079", :"SYS_B_080", :"SYS_B_081", :"SYS_B_082" FROM Salesorder_Bill t WHERE t.Distributetime >= to_date(:"SYS_B_083", :"SYS_B_084") and t.WAREHOUSEID=:"SYS_B_085" AND t.Distributetime <= to_date(:"SYS_B_086", :"SYS_B_087") GROUP BY Trunc(t.Distributetime) UNION ALL SELECT Trunc(t.Unitewarehousetime) , :"SYS_B_088", :"SYS_B_089", :"SYS_B_090", count(t.Mopocsalesorderbillid) , :"SYS_B_091", :"SYS_B_092", :"SYS_B_093", :"SYS_B_094", :"SYS_B_095", :"SYS_B_096", :"SYS_B_097", : "SYS_B_098", :"SYS_B_099", :"SYS_B_100", :"SYS_B_101", :"SYS_B_102", :"SYS_B_103", :"SYS_B_104", :"SYS_B_105", :"SYS_B_106", :"SYS_B_107", :"SYS_B_108", :"SYS_B_109", :"SYS_B_110", :"SYS_B_111" FROM Salesorder_Bill t WHERE t.Unitewarehousetime >= to_date(:"SYS_B_112", :"SYS_B_113") and t.WAREHOUSEID=:"SYS_B_114" AND t.Unitewarehousetime <= to_date(:"SYS_B_115", :"SYS_B_116") GROUP BY Trunc(t.Unitewarehousetime) UNION ALL SELECT Trunc(t.Enterwarehousetime) , :"SYS_B_117", :"SYS_B_118", :"SYS_B_119", :"SYS_B_120", count(t.Mopocsalesorderbillid) , :"SYS_B_121", :"SYS_B_122", :"SYS_B_123", :"SYS_B_124", :"SYS_B_125", :"SYS_B_126", :"SYS_B_127", :"SYS_B_128", :"SYS_B_1 29", :"SYS_B_130", :"SYS_B_131", :"SYS_B_132", :"SYS_B_133", :"SYS_B_134", :"SYS_B_135", :"SYS_B_136", :"SYS_B_137", :"SYS_B_138", :"SYS_B_139", :"SYS_B_140" FROM Salesorder_Bill t WHERE t.Enterwarehousetime >= to_date(:"SYS_B_141", :"SYS_B_142") and t.WAREHOUSEID=:"SYS_B_143" AND t.Enterwarehousetime <= to_date(:"SYS_B_144", :"SYS_B_145") GROUP BY Trunc(t.Enterwarehousetime) UNION ALL SELECT Trunc(t.Importtime) , :"SYS_B_146", :"SYS_B_147", :"SYS_B_148", :"SYS_B_149", :"SYS_B_150", count(t.Mopocsalesorderbillid) , :"SYS_B_151", :"SYS_B_152", :"SYS_B_153", :"SYS_B_154", :"SYS_B_155", :"SYS_B_156", :"SYS_B_157", :"SYS_B_158", :"SYS_B_159", :"SYS_B_160", :"SYS_ B_161", :"SYS_B_162", :"SYS_B_163", :"SYS_B_164", :"SYS_B_165", :"SYS_B_166", :"SYS_B_167", :"SYS_B_168", :"SYS_B_169" FROM Salesorder_Bill t WHERE t.Importtime >= to_date(:"SYS_B_170", :"SYS_B_171") and t.WAREHOUSEID=:"SYS_B_172" AND t.Importtime <= to_date(:"SYS_B_173", :"SYS_B_174") GROUP BY Trunc(t.Importtime) UNION ALL SELECT Trunc(t.Mergetime) , :"SYS_B_175", :"SYS_B_176", :"SYS_B_177", :"SYS_B_178", :"SYS_B_179", :"SYS_B_180", count(t.Mopocsalesorderbillid) , :"SYS_B_181", :"SYS_B_182", :"SYS_B_183", :"SYS_B_184", :"SYS_B_185", :"SYS_B_186", :"SYS_B_187", :"SYS_B_188", :"SYS_B_189", :"SYS_B_190", :"SYS_B_191", :"SYS_B_192", :"SYS_B_193", :"SY S_B_194", :"SYS_B_195", :"SYS_B_196", :"SYS_B_197", :"SYS_B_198" FROM Salesorder_Bill t WHERE t.Mergetime >= to_date(:"SYS_B_199", :"SYS_B_200") and t.WAREHOUSEID=:"SYS_B_201" AND t.Mergetime <= to_date(:"SYS_B_202", :"SYS_B_203") GROUP BY Trunc(t.Mergetime) UNION ALL SELECT Trunc(t.Waitingtime) , :"SYS_B_204", :"SYS_B_205", :"SYS_B_206", :"SYS_B_207", :"SYS_B_208", :"SYS_B_209", :"SYS_B_210", count(t.Mopocsalesorderbillid) , :"SYS_B_211", :"SYS_B_212", :"SYS_B_213", :"SYS_B_214", :"SYS_B_215", :"SYS_B_216", :"SYS_B_217", :"SYS_B_218", :"SYS_B_219", :"SYS_B_220", :"SYS_B_221", :"SYS_B_222", :"SYS_B_223", :"SYS_B_224", :"SYS_B_225", :"SYS_B_226", :" SYS_B_227" FROM Salesorder_Bill t WHERE t.Waitingtime >= to_date(:"SYS_B_228", :"SYS_B_229") and t.WAREHOUSEID=:"SYS_B_230" AND t.Waitingtime <= to_date(:"SYS_B_231", :"SYS_B_232") GROUP BY Trunc(t.Waitingtime) UNION ALL SELECT Trunc(t.Cancelwaitingtime) , :"SYS_B_233", :"SYS_B_234", :"SYS_B_235", :"SYS_B_236", :"SYS_B_237", :"SYS_B_238", :"SYS_B_239", :"SYS_B_240", count(t.Mopocsalesorderbillid) , :"SYS_B_241", :"SYS_B_242", :"SYS_B_243", :"SYS_B_244", :"SYS_B_245", :"SYS_B_246", :"SYS_B_247", :"SYS_B_248", :"SYS_B_249", :"SYS_B_250", :"SYS_B_251", :"SYS_B_252", :"SYS_B_253", :"SYS_B_254", :"SYS_B_255", :"SYS_B_256" FROM Salesorder_Bill t WHERE t.Cancelwaitingtime >= to_date(: "SYS_B_257", :"SYS_B_258") and t.WAREHOUSEID=:"SYS_B_259" AND t.Cancelwaitingtime <= to_date(:"SYS_B_260", :"SYS_B_261") GROUP BY Trunc(t.Cancelwaitingtime) UNION ALL SELECT Trunc(t.Cancelordertime) , :"SYS_B_262", :"SYS_B_263", :"SYS_B_264", :"SYS_B_265", :"SYS_B_266", :"SYS_B_267", :"SYS_B_268", :"SYS_B_269", :"SYS_B_270", count(t.Mopocsalesorderbillid) , :"SYS_B_271", :"SYS_B_272", :"SYS_B_273", :"SYS_B_274", :"SYS_B_275", :"SYS_B_276", :"SYS_B_277", :"SYS_B_278", :"SYS_B_279", :"SYS_B_280", :"SYS_B_281", :"SYS_B_282", :"SYS_B_283", :"SYS_B_284", :"SYS_B_285" FROM Salesorder_Bill t WHERE t.Cancelordertime >= to_date(:"SYS_B_286", :"SYS_B_287") and t.WAREHOUSEID=: "SYS_B_288" AND t.Cancelordertime <= to_date(:"SYS_B_289", :"SYS_B_290") GROUP BY Trunc(t.Cancelordertime) UNION ALL SELECT Trunc(t.Actualcanceltime) , :"SYS_B_291", :"SYS_B_292", :"SYS_B_293", :"SYS_B_294", :"SYS_B_295", :"SYS_B_296", :"SYS_B_297", :"SYS_B_298", :"SYS_B_299", :"SYS_B_300", count(t.Mopocsalesorderbillid) , :"SYS_B_301", :"SYS_B_302", :"SYS_B_303", :"SYS_B_304", :"SYS_B_305", :"SYS_B_306", :"SYS_B_307", :"SYS_B_308", :"SYS_B_309", :"SYS_B_310", :"SYS_B_311", :"SYS_B_312", :"SYS_B_313", :"SYS_B_314" FROM Salesorder_Bill t WHERE t.Actualcanceltime >= to_date(:"SYS_B_315", :"SYS_B_316") and t.WAREHOUSEID=:"SYS_B_317" AND t.Actualcanceltime <= to_date(:"SYS_B_ 318", :"SYS_B_319") GROUP BY Trunc(t.Actualcanceltime) UNION ALL SELECT Trunc(t.Orderprinttime) , :"SYS_B_320", :"SYS_B_321", :"SYS_B_322", :"SYS_B_323", :"SYS_B_324", :"SYS_B_325", :"SYS_B_326", :"SYS_B_327", :"SYS_B_328", :"SYS_B_329", :"SYS_B_330", count(t.Mopocsalesorderbillid) , :"SYS_B_331", :"SYS_B_332", :"SYS_B_333", :"SYS_B_334", :"SYS_B_335", :"SYS_B_336", :"SYS_B_337", :"SYS_B_338", :"SYS_B_339", :"SYS_B_340", :"SYS_B_341", :"SYS_B_342", :"SYS_B_343" FROM Salesorder_Bill t WHERE t.Orderprinttime >= to_date(:"SYS_B_344", :"SYS_B_345") and t.WAREHOUSEID=:"SYS_B_346" AND t.Orderprinttime <= to_date(:"SYS_B_347", :"SYS_B_348") GROUP BY Trunc(t.Orderprinttime) UNION A LL SELECT Trunc(t.Assignordertime) , :"SYS_B_349", :"SYS_B_350", :"SYS_B_351", :"SYS_B_352", :"SYS_B_353", :"SYS_B_354", :"SYS_B_355", :"SYS_B_356", :"SYS_B_357", :"SYS_B_358", :"SYS_B_359", :"SYS_B_360", count(t.Mopocsalesorderbillid) , :"SYS_B_361", :"SYS_B_362", :"SYS_B_363", :"SYS_B_364", :"SYS_B_365", :"SYS_B_366", :"SYS_B_367", :"SYS_B_368", :"SYS_B_369", :"SYS_B_370", :"SYS_B_371", :"SYS_B_372" FROM Salesorder_Bill t WHERE t.Assignordertime >= to_date(:"SYS_B_373", :"SYS_B_374") and t.WAREHOUSEID=:"SYS_B_375" AND t.Assignordertime <= to_date(:"SYS_B_376", :"SYS_B_377") GROUP BY Trunc(t.Assignordertime) UNION ALL SELECT Trunc(t.Pickingtime) , :"SYS_B_378", :"SYS_B_37 9", :"SYS_B_380", :"SYS_B_381", :"SYS_B_382", :"SYS_B_383", :"SYS_B_384", :"SYS_B_385", :"SYS_B_386", :"SYS_B_387", :"SYS_B_388", :"SYS_B_389", :"SYS_B_390", count(t.Mopocsalesorderbillid) , :"SYS_B_391", :"SYS_B_392", :"SYS_B_393", :"SYS_B_394", :"SYS_B_395", :"SYS_B_396", :"SYS_B_397", :"SYS_B_398", :"SYS_B_399", :"SYS_B_400", :"SYS_B_401" FROM Salesorder_Bill t WHERE t.Pickingtime >= to_date(:"SYS_B_402", :"SYS_B_403") and t.WAREHOUSEID=:"SYS_B_404" AND t.Pickingtime <= to_date(:"SYS_B_405", :"SYS_B_406") GROUP BY Trunc(t.Pickingtime) UNION ALL SELECT Trunc(t.Qctime) , :"SYS_B_407", :"SYS_B_408", :"SYS_B_409", :"SYS_B_410", :"SYS_B_411", :"SYS_B _412", :"SYS_B_413", :"SYS_B_414", :"SYS_B_415", :"SYS_B_416", :"SYS_B_417", :"SYS_B_418", :"SYS_B_419", :"SYS_B_420", count(t.Mopocsalesorderbillid) , :"SYS_B_421", :"SYS_B_422", :"SYS_B_423", :"SYS_B_424", :"SYS_B_425", :"SYS_B_426", :"SYS_B_427", :"SYS_B_428", :"SYS_B_429", :"SYS_B_430" FROM Salesorder_Bill t WHERE t.Qctime >= to_date(:"SYS_B_431", :"SYS_B_432") and t.WAREHOUSEID=:"SYS_B_433" AND t.Qctime <= to_date(:"SYS_B_434", :"SYS_B_435") GROUP BY Trunc(t.Qctime) UNION ALL SELECT Trunc(t.Actualshorttime) , :"SYS_B_436", :"SYS_B_437", :"SYS_B_438", :"SYS_B_439", :"SYS_B_440", :"SYS_B_441", :"SYS_B_442", :"SYS_B_443", :"SYS_B_444", :"SYS_B_445 ", :"SYS_B_446", :"SYS_B_447", :"SYS_B_448", :"SYS_B_449", :"SYS_B_450", count(t.Mopocsalesorderbillid) , :"SYS_B_451", :"SYS_B_452", :"SYS_B_453", :"SYS_B_454", :"SYS_B_455", :"SYS_B_456", :"SYS_B_457", :"SYS_B_458", :"SYS_B_459" FROM Salesorder_Bill t WHERE t.Actualshorttime >= to_date(:"SYS_B_460", :"SYS_B_461") and t.WAREHOUSEID=:"SYS_B_462" AND t.Actualshorttime <= to_date(:"SYS_B_463", :"SYS_B_464") GROUP BY Trunc(t.Actualshorttime) UNION ALL SELECT Trunc(t.Packtime), :"SYS_B_465", :"SYS_B_466", :"SYS_B_467", :"SYS_B_468", :"SYS_B_469", :"SYS_B_470", :"SYS_B_471", :"SYS_B_472", :"SYS_B_473", :"SYS_B_474", :"SYS_B_475", :"SYS_B_476", :"SYS_B_477", : "SYS_B_478", :"SYS_B_479", :"SYS_B_480", count(t.Mopocsalesorderbillid) , :"SYS_B_481", :"SYS_B_482", :"SYS_B_483", :"SYS_B_484", :"SYS_B_485", :"SYS_B_486", :"SYS_B_487", :"SYS_B_488" FROM Salesorder_Bill t WHERE t.Packtime >= to_date(:"SYS_B_489", :"SYS_B_490") and t.WAREHOUSEID=:"SYS_B_491" AND t.Packtime <= to_date(:"SYS_B_492", :"SYS_B_493") GROUP BY Trunc(t.Packtime) UNION ALL SELECT Trunc(t.Waybilltime) , :"SYS_B_494", :"SYS_B_495", :"SYS_B_496", :"SYS_B_497", :"SYS_B_498", :"SYS_B_499", :"SYS_B_500", :"SYS_B_501", :"SYS_B_502", :"SYS_B_503", :"SYS_B_504", :"SYS_B_505", :"SYS_B_506", :"SYS_B_507", :"SYS_B_508", :"SYS_B_509", :"SYS_B_510", c ount(t.Mopocsalesorderbillid) , :"SYS_B_511", :"SYS_B_512", :"SYS_B_513", :"SYS_B_514", :"SYS_B_515", :"SYS_B_516", :"SYS_B_517" FROM Salesorder_Bill t WHERE t.Waybilltime >= to_date(:"SYS_B_518", :"SYS_B_519") and t.WAREHOUSEID=:"SYS_B_520" AND t.Waybilltime <= to_date(:"SYS_B_521", :"SYS_B_522") GROUP BY Trunc(t.Waybilltime) UNION ALL SELECT Trunc(t.Handingtime) , :"SYS_B_523", :"SYS_B_524", :"SYS_B_525", :"SYS_B_526", :"SYS_B_527", :"SYS_B_528", :"SYS_B_529", :"SYS_B_530", :"SYS_B_531", :"SYS_B_532", :"SYS_B_533", :"SYS_B_534", :"SYS_B_535", :"SYS_B_536", :"SYS_B_537", :"SYS_B_538", :"SYS_B_539", :"SYS_B_540", count(t.Mopocsalesorderbillid) , :"SYS_B_541", :"S YS_B_542", :"SYS_B_543", :"SYS_B_544", :"SYS_B_545", :"SYS_B_546" FROM Salesorder_Bill t WHERE t.Handingtime >= to_date(:"SYS_B_547", :"SYS_B_548") and t.WAREHOUSEID=:"SYS_B_549" AND t.Handingtime <= to_date(:"SYS_B_550", :"SYS_B_551") GROUP BY Trunc(t.Handingtime) UNION ALL SELECT Trunc(t.Consigntime) , :"SYS_B_552", :"SYS_B_553", :"SYS_B_554", :"SYS_B_555", :"SYS_B_556", :"SYS_B_557", :"SYS_B_558", :"SYS_B_559", :"SYS_B_560", :"SYS_B_561", :"SYS_B_562", :"SYS_B_563", :"SYS_B_564", :"SYS_B_565", :"SYS_B_566", :"SYS_B_567", :"SYS_B_568", :"SYS_B_569", :"SYS_B_570", count(t.Mopocsalesorderbillid) , :"SYS_B_571", :"SYS_B_572", :"SYS_B_573", :"SYS_B_574", :"SYS_B_575" FROM Salesorder_Bill t WHERE t.Consigntime >= to_date(:"SYS_B_576", :"SYS_B_577") and t.WAREHOUSEID=:"SYS_B_578" AND t.Consigntime <= to_date(:"SYS_B_579", :"SYS_B_580") GROUP BY Trunc(t.Consigntime) UNION ALL SELECT Trunc(t.Endtime) , :"SYS_B_581", :"SYS_B_582", :"SYS_B_583", :"SYS_B_584", :"SYS_B_585", :"SYS_B_586", :"SYS_B_587", :"SYS_B_588", :"SYS_B_589", :"SYS_B_590", :"SYS_B_591", :"SYS_B_592", :"SYS_B_593", :"SYS_B_594", :"SYS_B_595", :"SYS_B_596", :"SYS_B_597", :"SYS_B_598", :"SYS_B_599", :"SYS_B_600", count(t.Mopocsalesorderbillid) , :"SYS_B_601", :"SYS_B_602", :"SYS_B_603", :"SYS_B_604" FROM Salesorder_Bill t WHERE t.Endtime >= to_date(:"SYS_B_605 ", :"SYS_B_606") and t.WAREHOUSEID=:"SYS_B_607" AND t.Endtime <= to_date(:"SYS_B_608", :"SYS_B_609") GROUP BY Trunc(t.Endtime) UNION ALL SELECT Trunc(t.Accountdate) , :"SYS_B_610", :"SYS_B_611", :"SYS_B_612", :"SYS_B_613", :"SYS_B_614", :"SYS_B_615", :"SYS_B_616", :"SYS_B_617", :"SYS_B_618", :"SYS_B_619", :"SYS_B_620", :"SYS_B_621", :"SYS_B_622", :"SYS_B_623", :"SYS_B_624", :"SYS_B_625", :"SYS_B_626", :"SYS_B_627", :"SYS_B_628", :"SYS_B_629", :"SYS_B_630", count(t.Mopocsalesorderbillid) , :"SYS_B_631", :"SYS_B_632", :"SYS_B_633" FROM Salesorder_Bill t WHERE t.Accountdate >= to_date(:"SYS_B_634", :"SYS_B_635") and t.WAREHOUSEID=:"SYS_B_636" AND t.Accountdate <= to_date(:"SYS_B_637", :"SYS_B_638") GROUP BY Trunc(t.Accountdate) UNION ALL SELECT Trunc(t.Modifiedtime) , :"SYS_B_639", :"SYS_B_640", :"SYS_B_641", :"SYS_B_642", :"SYS_B_643", :"SYS_B_644", :"SYS_B_645", :"SYS_B_646", :"SYS_B_647", :"SYS_B_648", :"SYS_B_649", :"SYS_B_650", :"SYS_B_651", :"SYS_B_652", :"SYS_B_653", :"SYS_B_654", :"SYS_B_655", :"SYS_B_656", :"SYS_B_657", :"SYS_B_658", :"SYS_B_659", :"SYS_B_660", count(t.Mopocsalesorderbillid) , :"SYS_B_661" , :"SYS_B_662" FROM Salesorder_Bill t WHERE t.Modifiedtime >= to_date(:"SYS_B_663", :"SYS_B_664") and t.WAREHOUSEID=:"SYS_B_665" AND t.Modifiedtime <= to_date(:"SYS_B_666", :"SYS_B_667") GROUP BY Trunc(t.Modifiedtim e) UNION ALL SELECT Trunc(t.Createtime) , :"SYS_B_668", :"SYS_B_669", :"SYS_B_670", :"SYS_B_671", :"SYS_B_672", :"SYS_B_673", :"SYS_B_674", :"SYS_B_675", :"SYS_B_676", :"SYS_B_677", :"SYS_B_678", :"SYS_B_679", :"SYS_B_680", :"SYS_B_681", :"SYS_B_682", :"SYS_B_683", :"SYS_B_684", :"SYS_B_685", :"SYS_B_686", :"SYS_B_687", :"SYS_B_688", :"SYS_B_689", :"SYS_B_690", count(t.Mopocsalesorderbillid) , :"SYS_B_691" FROM Salesorder_Bill t WHERE t.Createtime >= to_date(:"SYS_B_692", :"SYS_B_693") and t.WAREHOUSEID=:"SYS_B_694" AND t.Createtime <= to_date(:"SYS_B_695", :"SYS_B_696") GROUP BY Trunc(t.Createtime) UNION ALL SELECT Trunc(t.Updatetime) , :"SYS_B_697", :"SYS_B_698", : "SYS_B_699", :"SYS_B_700", :"SYS_B_701", :"SYS_B_702", :"SYS_B_703", :"SYS_B_704", :"SYS_B_705", :"SYS_B_706", :"SYS_B_707", :"SYS_B_708", :"SYS_B_709", :"SYS_B_710", :"SYS_B_711", :"SYS_B_712", :"SYS_B_713", :"SYS_B_714", :"SYS_B_715", :"SYS_B_716", :"SYS_B_717", :"SYS_B_718", :"SYS_B_719", :"SYS_B_720", count(t.Mopocsalesorderbillid) FROM Salesorder_Bill t WHERE t.Updatetime >= to_date(:"SYS_B_721", :"SYS_B_722") and t.WAREHOUSEID=:"SYS_B_723" AND t.Updatetime <= to_date(:"SYS_B_724", :"SYS_B_725") GROUP BY Trunc(t.Updatetime) ) k where :"SYS_B_726"=:"SYS_B_727" AND :"SYS_B_728"=:"SYS_B_729" Group By Trunc(k.统计日期))
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
48fcrbrw930j8	begin Purchase_Returnbill_Quality30(AS_SYSTEMID=>:AS_SYSTEMID, AS_PURCHASERETURNBILLID=>:AS_PURCHASERETURNBILLID, AS_PURCHASERETURNBILLNO=>:AS_PURCHASERETURNBILLNO, AS_PURCHASERETURNTYPEID=>:AS_PURCHASERETURNTYPEID, AS_DEPARTMENTID=>:AS_DEPARTMENTID, AS_WAREHOUSEID=>:AS_WAREHOUSEID, AS_USERID=>:AS_USERID, AS_BILLSTATE=>:AS_BILLSTATE, DESCERR=>:DESCERR); end;
4gh9nuu8f7auc	UPDATE PURCHASE_RETURNBILL T SET (T.CHECK_GOODSQTY, T.CHECK_QUANTITY, T.CHECK_PRICEAMOUNT) = (SELECT COUNT(*), SUM(SUM_QTY), SUM(SUM_PRICEAMOUNT) FROM ( SELECT SUM(S.SORTING_QTY) SUM_QTY, SUM(S.SORTING_PRICEAMOUNT) SUM_PRICEAMOUNT FROM SORTING_BILLDETAIL S WHERE S.LOGISTICSTYPEID = '进退单' AND S.LOGISTICSBILLID = :B2 AND S.SORTING_QTY>0 GROUP BY S.SKUID, S.PRODUCTION_BATCHNUMBER, S.WARRANTY_ENDDATE)) WHERE T.PURCHASERETURNBILLID = :B2 AND T.SYSTEMID = :B1
4zr4md3h0pann	begin Moving_Bill_Sure30(AS_SYSTEMID=>:AS_SYSTEMID, AS_WAREHOUSEID=>:AS_WAREHOUSEID, AS_OPERUSERID=>:AS_OPERUSERID, AS_USERID=>:AS_USERID, DESCERR=>:DESCERR); end;
5btmcxu111d7d	INSERT INTO PICKING_BILLSOURCE_HIS SELECT * FROM PICKING_BILLSOURCE T WHERE T.MOPOCSALESORDERBILLID = :B2 AND T.SYSTEMID = :B1
5gx1ptcc1mmwz	alter index IK_MERGETIME rebuild online
5rfjafx3fcjyq	select count(:"SYS_B_0") from (SELECT RECEIVE_BILLDETAIL.SYSTEMID, RECEIVE_BILLDETAIL.RECEIVEBILLDETAILID, RECEIVE_BILLDETAIL.RECEIVEBILLID, RECEIVE_BILLDETAIL.RECEIVEBILLNO, RECEIVE_BILLDETAIL.SKUID, RECEIVE_BILLDETAIL.PRODUCTION_DATE, RECEIVE_BILLDETAIL.PACKED_DATE, RECEIVE_BILLDETAIL.WARRANTY_ENDDATE, RECEIVE_BILLDETAIL.WARRANTY, RECEIVE_BILLDETAIL.PRODUCTION_BATCHNUMBER, RECEIVE_BILLDETAIL.BILL_QTY, RECEIVE_BILLDETAIL.BILL_PRICEAMOUNT, RECEIVE_BILLDETAIL.BILL_WEIGHT, RECEIVE_BILLDETAIL.RECEIVE_QTY, RECEIVE_BILLDETAIL.RECEIVE_PRICEAMOUNT, RECEIVE_BILLDETAIL.RECEIVE_WEIGHT, RECEIVE_BILLDETAIL.DONATION_QTY, RECEIVE_BILLDETAIL.DONATION_PRICEAMOUNT, RECEIVE_BILLDETAIL.DAMAGE_QTY, RECEIVE_BILLDETAIL.DAMAGE_PRICEMOUNT, RECEIVE_BILLDETAIL.DAMAGE_WEIGHT, RECEIVE_BILLDETAIL.INPUTFLAG, RECEIVE_BILLDETAIL.BUSINESSTYPEID, RECEIVE_BILLDETAIL.BUSINESSBILLID, RECEIVE_BILLDETAIL.BUSINESSBILLNO, RECEIVE_BILLDETAIL.BUSINESSBILLDETAILID, BASE_GOODSINFO.PRODUCTID, B ASE_GOODSINFO.BRANDID, BASE_GOODSINFO.GOODSNO, BASE_GOODSINFO.GOODSBARCODE, BASE_GOODSINFO.GOODSNAME, 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.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.SNFLAG, BASE_GOODSINFO.APPROVAL_CODE, BASE_GOODSINFO.PLACE_PRODUCTION, BASE_GOODSINFO.MANUFACTURER, BASE_GOODSINFO.MANUFACTURERGOODSNO, BASE_GOODSTYPE.GOODSTYPE_CODE, BASE_GOODSTYPE.GOODSTYPE_NAME, BASE_PRODUCTINFO.PRODUCENO, BASE_PRODUCTINFO.PRODUCTNAME, BASE_PRODUCTINFO.DISPLAYNAME, BASE_PRODUCTINFO.ENGLISHNAME, BASE_PRODUCTINFO.PRODUCTCODE, PURCHASE_ORDER.BOXNO , RECEIVE_BILLDETAIL.ACTUAL_QTY , RECEIVE_BILLDETAIL.ACTUAL_PRICEAMOUNT , RECEIVE_BILLDETAIL.ACTUAL_WEIGHT , RECEIVE_BILLDETAIL.LOSS_QTY , RECEIVE_BILLDETAIL.LOSS_PRICEAMOUNT , RECEIVE_BILLDETAIL.LOSS_WEIGHT , RECEIVE_BILL.OWNERID , RECEIVE_BILL.SUPPLIERID , RECEIVE_BILL.DEPARTMENTID , RECEIVE_BILL.WAREHOUSEID , RECEIVE_BILL.MARKETINGTYPEID , RECEIVE_BILL.BILL_STATE , RECEIVE_BILL.STATE_DESC, RECEIVE_BILL.RECEIVEDATE FROM RECEIVE_BILLDETAIL, BASE_GOODSINFO, BASE_GOODSTYPE, BASE_PRODUCTINFO, PURCHASE_ORDER, RECEIVE_BILL WHERE ( RECEIVE_BILLDETAIL.SKUID = BASE_GOODSINFO.SKUID(+) ) AND ( RECEIVE_BILLDETAIL.BUSINESSBILLID = PURCHASE_ORDER.PORDERID(+) ) AND ( BASE_GOODSINFO.GOODSTYPEID = BASE_GOODSTYPE.GOODSTYPE_ID(+) ) AND ( BASE_GOODSINFO.PRODUCTID = BASE_PRODUCTINFO.PRODUCTID(+) ) AND ( RECEIVE_BILLDETAIL.RECEIVEBILLID = RECEIVE_BILL.RECEIVEBILLID ) and instr(RECEIVE_BILLDETAIL.businesstypeid, :"SYS_B_1")<=:"SYS_B_2" and RECEIVE_BILL.WAREHOUSEID =:"SYS_B_3 "AND instr(RECEIVE_BILLDETAIL.businesstypeid, :"SYS_B_4")<=:"SYS_B_5" AND RECEIVE_BILLDETAIL.BUSINESSBILLNO = :"SYS_B_6" Order By RECEIVEBILLNO DESC, SKUID ASC)
6182rs2up50j6	begin Waybill_Package_Packing(AS_SYSTEMID=>:AS_SYSTEMID, AS_BATCHID=>:AS_BATCHID, AS_BATCHNO=>:AS_BATCHNO, AS_USERID=>:AS_USERID, DESCERR=>:DESCERR); end;
6mt76dd26sm6h	select count(*) from picking_billsource_his_bhis t
6uqmwkn1z4fjm	Insert into WAYBILL_PACKAGINGSKU (SYSTEMID, MOPOCSALESORDERBILLID, OUTERSALESORDERBILLID, PACKAGING_SKUID, PACKAGING_COST, PACKAGING_WEIGHT, PACKAGING_QTY, CREATETIME, UPDATETIME, BILL_STATE, OLDBILL_STATE, STATE_DESC, OWNERID, SHOPID, DEPARTMENTID, SOURCEOWNERID, SOURCEDEPARTMENTID, WAREHOUSEID, WAYBILL_PACKAGEID, WAYBILL_PACKAGENO)values(:"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", to_date(:"SYS_B_07", :"SYS_B_08"), to_date(:"SYS_B_09", :"SYS_B_10"), :"SYS_B_11", :"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21")
73jcp23cf4szj	select count(distinct a.Shelve_Batchid) as count, a.WAREHOUSEID from SHELVE_BATCH a where a.rf_flag<>:"SYS_B_00" and nvl(a.BUSINESSTYPEID, :"SYS_B_01") <> :"SYS_B_02" and (bill_state=:"SYS_B_03" or (bill_state=:"SYS_B_04" and (state_desc=:"SYS_B_05" or (state_desc=:"SYS_B_06" 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_07", :"SYS_B_08", :"SYS_B_09")) < count(shelve_bill.shelvebillid) Or sum(shelve_bill.shelveprint)=:"SYS_B_10"))))) and a.WAREHOUSEID in (:"SYS_B_11") group by a.WAREHOUSEID
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"
866ny6qzrfn8z	SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT COMPANYCODE, COMPANYID, COMPANYNAME, BRANDID, GOODSNO, GOODSid, GOODSBARCODE, GOODSNAME, SNFLAG, GOODSTYPEID, STATISTICID, CARGOSPACECODE, SYSTEMID, INVENTORYCARGOSPACEID, INVENTORYOWNERID, OWNERID, DEPARTMENTID, WAREHOUSEID, WAREHOUSEAREAID, CARGOSPACEID, SKUID, PRODUCTION_DATE, PACKED_DATE, WARRANTY_ENDDATE, WARRANTY, PRODUCTION_BATCHNUMBER, AVAILABLEQTY, DAMAGEQTY, MATERIALQTY, PURCHASEQTY, PURCHASERETURNQTY, SALEQTY, SALERETURNQTY, ACTIVEALLOCATEQTY, PASSIVEALLOCATEQTY, INQTY, OUTQTY, DRAWQTY, LOSSESQTY, BRIMQTY, OCCUPY_FOR_MOVING, OCCUPY_FOR_ORDERS, OCCUPY_FOR_RETURN, OCCUPY_FOR_ACTIVEALLOCATE, OCCUPY_FOR_PASSIVEALLOCATE, OCCUPY_FOR_DAMAGE, OCCUPY_FOR_GENUINE, OCCUPY_FOR_LOSE, REMARK, CREATEDATE, UPDATEDATE, PRODUCENO, PRODUCTNAME, kxskc FROM INVENTORY_CARGOSPACE_HZHW where :"SYS_B_0"=:"SYS_B_1" AND WAREHOUSEID=:"SYS_B_2" AND GOODSBARCODE Like :"SYS_B_3 ") A WHERE ROWNUM <= :"SYS_B_4" ) WHERE RN > :"SYS_B_5"
88zzurgd1rpz8	select count(:"SYS_B_0") from ( SELECT DRAW_BILLSOURCE_HC.SYSTEMID, DRAW_BILLSOURCE_HC.DRAW_BILLSOURCEID, DRAW_BILLSOURCE_HC.DRAWBILLDETAILID, DRAW_BILLSOURCE_HC.DRAWBILLID, DRAW_BILLSOURCE_HC.DRAWBILLNO, DRAW_BILLSOURCE_HC.SOURCETYPEID, DRAW_BILLSOURCE_HC.SOURCEBILLID, DRAW_BILLSOURCE_HC.SOURCEBILLNO, DRAW_BILLSOURCE_HC.INVENTORYCARGOSPACEID, DRAW_BILLSOURCE_HC.INVENTORYOWNERID, DRAW_BILLSOURCE_HC.OWNERID, DRAW_BILLSOURCE_HC.DEPARTMENTID, DRAW_BILLSOURCE_HC.WAREHOUSEID, DRAW_BILLSOURCE_HC.WAREHOUSEAREAID, DRAW_BILLSOURCE_HC.CARGOSPACEID, DRAW_BILLSOURCE_HC.SKUID, DRAW_BILLSOURCE_HC.PRICE, DRAW_BILLSOURCE_HC.PRODUCTION_DATE, DRAW_BILLSOURCE_HC.PACKED_DATE, DRAW_BILLSOURCE_HC.WARRANTY_ENDDATE, DRAW_BILLSOURCE_HC.WARRANTY, DRAW_BILLSOURCE_HC.PRODUCTION_BATCHNUMBER, DRAW_BILLSOURCE_HC.QTY, DRAW_BILLSOURCE_HC.QTY_PRICEAMOUNT, DRAW_BILLSOURCE_HC.CREATEUSERID, DRAW_BILLSOURCE_HC.CHECKUSERID, DRAW_BILLSOURCE_HC.CREATEDATE, DRAW_BILLSOURCE_HC.CHECKDATE, DR AW_BILLSOURCE_HC.BILL_STATE, DRAW_BILLSOURCE_HC.STATE_DESC, BASE_GOODSINFO.GOODSNO, BASE_GOODSINFO.GOODSBARCODE, BASE_GOODSINFO.GOODSNAME, BASE_GOODSINFO.OTHER_BARCODES FROM DRAW_BILLSOURCE_HC, BASE_GOODSINFO WHERE ( DRAW_BILLSOURCE_HC.SKUID = BASE_GOODSINFO.SKUID ) AND DRAW_BILLSOURCE_HC.WAREHOUSEID =:"SYS_B_1")
8wcqhm8dts8f1	UPDATE SALESORDER_BILLDETAIL T SET T.OLDBILL_STATE = T.BILL_STATE, T.BILL_STATE = '03', T.STATE_DESC = '分配确认', T.UPDATETIME = SYSDATE, 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.MOPOCSALESORDERBILLDETAILID = T.MOPOCSALESORDERBILLDETAILID) WHERE EXISTS (SELECT 1 FROM PICKING_BILLSOURCE S WHERE S.MOPOCSALESORDERBILLDETAILID = T.MOPOCSALESORDERBILLDETAILID AND S.PICKINGBILLID = :B2 )
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 )
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;
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
c25bqz9jjj5gn	SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT Trunc(k.统计日期) 统计日期, sum(k.进入总部单数) 进入总部单数, sum(k.总部合单单数) 总部合单单数, sum(k.仓库分单单数) 仓库分单单数, sum(k.Wms合单单数) Wms合单单数, sum(k.进入wms单数) 进入wms单数, sum(k.订单导入单数) 订单导入单数, sum(k.汇总订单单数) 汇总订单单数, sum(k.订单等待单数) 订单等待单数, sum(k.取消等待单数) 取消等待单数, sum(k.取消订单单数) 取消订单单数, sum(k.实际取消单数) 实际取消单数, sum(k.订单打印单数) 订单打印单数, sum(k.分配拣选单数) 分配拣选单数, sum(k.拣选拣货单数) 拣选拣货单数, sum(k.订单质检单数) 订单质检单数, sum(k.实物报缺单数) 实物报缺单数, sum(k.包裹包装单数) 包裹包装单数, sum(k.运号录入单数) 运号录入单数, sum(k.包裹交接单数) 包裹交接单数, sum(k.订单发出单数) 订单发出单数, sum(k.订单结束单数) 订单结束单数, sum(k.订单做账单数) 订单做账单数, sum(k.订单改单单数) 订单改单单数, sum(k.记录创建单数) 记录创建单数, sum(k.记录更新单数) 记录更新单数 FROM ( SELECT Trunc(t.Enterheadquarterstime) 统计日期, count(t.Mopocsalesorderbillid) 进入总部单数, :"SYS_B_000" 总部合单单数, :"SYS_B_001" 仓库分单单数, :"SYS_B_002" Wms合单单数, :"SYS_B_003" 进入wms单数, :"SYS_B_004" 订单导入单数, :"SYS_B_005" 汇总订单单数, :"SYS_B_006" 订单等待单数, :"SYS_B_007" 取消等待单数, : "SYS_B_008" 取消订单单数, :"SYS_B_009" 实际取消单数, :"SYS_B_010" 订单打印单数, :"SYS_B_011" 分配拣选单数, :"SYS_B_012" 拣选拣货单数, :"SYS_B_013" 订单质检单数, :"SYS_B_014" 实物报缺单数, :"SYS_B_015" 包裹包装单数, :"SYS_B_016" 运号录入单数, :"SYS_B_017" 包裹交接单数, :"SYS_B_018" 订单发出单数, :"SYS_B_019" 订单结束单数, :"SYS_B_020" 订单做账单数, :"SYS_B_021" 订单改单单数, :"SYS_B_022" 记录创建单数, :"SYS_B_023" 记录更新单数 FROM Salesorder_Bill t WHERE t.Enterheadquarterstime >= to_date(:"SYS_B_024", :"SYS_B_025") and t.WAREHOUSEID=:"SYS_B_026" AND t.Enterheadquarterstime <=to_date(:"SYS_B_027", :"SYS_B_028") GROUP BY Trunc(t.Enterheadquarterstime) UNION ALL SELECT Trunc(t.Uniteheadquarterstime) , :"SYS_B_029" , count(t.Mopocsalesorderbillid) , :"SYS_B_030", :"SYS_B_031", :"SYS_B_032", :"SYS_B_033", :"SYS_B_034", :"SYS_B_035", :"SYS_B_036", :"SYS_B_037", :"SYS_B_038", :"SYS_B_039", :"SYS_B_040", :"SYS_B_041", :"SYS_B_042", :"SYS_B_043", :"SYS_B_044", :"SYS_B_045", :"SYS_B_046", :"SYS_B_047", :"SYS_B_048", :"SYS_B_049", :"SYS_B_050", :"SYS_B_051", :"SYS_B_052" FROM Salesorder_Bill t WHERE t.Uniteheadquarterstime >= to_date(:"SYS_B_053", :"SYS_B_054") and t.WAREHOUSEID=:"SYS_B_055" AND t.Uniteheadquarterstime <= to_date(:"SYS_B_056", :"SYS_B_057") GROUP BY Trunc(t.Uniteheadquarterstime) UNION ALL SELECT Trunc( t.Distributetime) , :"SYS_B_058", :"SYS_B_059", count(t.Mopocsalesorderbillid) , :"SYS_B_060", :"SYS_B_061", :"SYS_B_062", :"SYS_B_063", :"SYS_B_064", : "SYS_B_065", :"SYS_B_066", :"SYS_B_067", :"SYS_B_068", :"SYS_B_069", :"SYS_B_070", :"SYS_B_071", :"SYS_B_072", :"SYS_B_073", :"SYS_B_074", :"SYS_B_075", :"SYS_B_076", :"SYS_B_077", :"SYS_B_078", :"SYS_B_079", :"SYS_B_080", :"SYS_B_081" FROM Salesorder_Bill t WHERE t.Distributetime >= to_date(:"SYS_B_082", :"SYS_B_083") and t.WAREHOUSEID=:"SYS_B_084" AND t.Distributetime <= to_date(:"SYS_B_085", :"SYS_B_086") GROUP BY Trunc(t.Distributetime) UNION ALL SELECT Trunc(t.Unitewarehousetime) , :"SYS_B_087", :"SYS_B_088", :"SYS_B_089", count(t.Mopocsalesorderbillid) , :"SYS_B_090", :"SYS_B_091", :"SYS_B_092", :"SYS_B_093", :"SYS_B_094", :"SYS_B_095", :"SYS_B_096", : "SYS_B_097", :"SYS_B_098", :"SYS_B_099", :"SYS_B_100", :"SYS_B_101", :"SYS_B_102", :"SYS_B_103", :"SYS_B_104", :"SYS_B_105", :"SYS_B_106", :"SYS_B_107", :"SYS_B_108", :"SYS_B_109", :"SYS_B_110" FROM Salesorder_Bill t WHERE t.Unitewarehousetime >= to_date(:"SYS_B_111", :"SYS_B_112") and t.WAREHOUSEID=:"SYS_B_113" AND t.Unitewarehousetime <= to_date(:"SYS_B_114", :"SYS_B_115") GROUP BY Trunc(t.Unitewarehousetime) UNION ALL SELECT Trunc(t.Enterwarehousetime) , :"SYS_B_116", :"SYS_B_117", :"SYS_B_118", :"SYS_B_119", count(t.Mopocsalesorderbillid) , :"SYS_B_120", :"SYS_B_121", :"SYS_B_122", :"SYS_B_123", :"SYS_B_124", :"SYS_B_125", :"SYS_B_126", :"SYS_B_127", :"SYS_B_1 28", :"SYS_B_129", :"SYS_B_130", :"SYS_B_131", :"SYS_B_132", :"SYS_B_133", :"SYS_B_134", :"SYS_B_135", :"SYS_B_136", :"SYS_B_137", :"SYS_B_138", :"SYS_B_139" FROM Salesorder_Bill t WHERE t.Enterwarehousetime >= to_date(:"SYS_B_140", :"SYS_B_141") and t.WAREHOUSEID=:"SYS_B_142" AND t.Enterwarehousetime <= to_date(:"SYS_B_143", :"SYS_B_144") GROUP BY Trunc(t.Enterwarehousetime) UNION ALL SELECT Trunc(t.Importtime) , :"SYS_B_145", :"SYS_B_146", :"SYS_B_147", :"SYS_B_148", :"SYS_B_149", count(t.Mopocsalesorderbillid) , :"SYS_B_150", :"SYS_B_151", :"SYS_B_152", :"SYS_B_153", :"SYS_B_154", :"SYS_B_155", :"SYS_B_156", :"SYS_B_157", :"SYS_B_158", :"SYS_B_159", :"SYS_ B_160", :"SYS_B_161", :"SYS_B_162", :"SYS_B_163", :"SYS_B_164", :"SYS_B_165", :"SYS_B_166", :"SYS_B_167", :"SYS_B_168" FROM Salesorder_Bill t WHERE t.Importtime >= to_date(:"SYS_B_169", :"SYS_B_170") and t.WAREHOUSEID=:"SYS_B_171" AND t.Importtime <= to_date(:"SYS_B_172", :"SYS_B_173") GROUP BY Trunc(t.Importtime) UNION ALL SELECT Trunc(t.Mergetime) , :"SYS_B_174", :"SYS_B_175", :"SYS_B_176", :"SYS_B_177", :"SYS_B_178", :"SYS_B_179", count(t.Mopocsalesorderbillid) , :"SYS_B_180", :"SYS_B_181", :"SYS_B_182", :"SYS_B_183", :"SYS_B_184", :"SYS_B_185", :"SYS_B_186", :"SYS_B_187", :"SYS_B_188", :"SYS_B_189", :"SYS_B_190", :"SYS_B_191", :"SYS_B_192", :"SY S_B_193", :"SYS_B_194", :"SYS_B_195", :"SYS_B_196", :"SYS_B_197" FROM Salesorder_Bill t WHERE t.Mergetime >= to_date(:"SYS_B_198", :"SYS_B_199") and t.WAREHOUSEID=:"SYS_B_200" AND t.Mergetime <= to_date(:"SYS_B_201", :"SYS_B_202") GROUP BY Trunc(t.Mergetime) UNION ALL SELECT Trunc(t.Waitingtime) , :"SYS_B_203", :"SYS_B_204", :"SYS_B_205", :"SYS_B_206", :"SYS_B_207", :"SYS_B_208", :"SYS_B_209", count(t.Mopocsalesorderbillid) , :"SYS_B_210", :"SYS_B_211", :"SYS_B_212", :"SYS_B_213", :"SYS_B_214", :"SYS_B_215", :"SYS_B_216", :"SYS_B_217", :"SYS_B_218", :"SYS_B_219", :"SYS_B_220", :"SYS_B_221", :"SYS_B_222", :"SYS_B_223", :"SYS_B_224", :"SYS_B_225", :" SYS_B_226" FROM Salesorder_Bill t WHERE t.Waitingtime >= to_date(:"SYS_B_227", :"SYS_B_228") and t.WAREHOUSEID=:"SYS_B_229" AND t.Waitingtime <= to_date(:"SYS_B_230", :"SYS_B_231") GROUP BY Trunc(t.Waitingtime) UNION ALL SELECT Trunc(t.Cancelwaitingtime) , :"SYS_B_232", :"SYS_B_233", :"SYS_B_234", :"SYS_B_235", :"SYS_B_236", :"SYS_B_237", :"SYS_B_238", :"SYS_B_239", count(t.Mopocsalesorderbillid) , :"SYS_B_240", :"SYS_B_241", :"SYS_B_242", :"SYS_B_243", :"SYS_B_244", :"SYS_B_245", :"SYS_B_246", :"SYS_B_247", :"SYS_B_248", :"SYS_B_249", :"SYS_B_250", :"SYS_B_251", :"SYS_B_252", :"SYS_B_253", :"SYS_B_254", :"SYS_B_255" FROM Salesorder_Bill t WHERE t.Cancelwaitingtime >= to_date(: "SYS_B_256", :"SYS_B_257") and t.WAREHOUSEID=:"SYS_B_258" AND t.Cancelwaitingtime <= to_date(:"SYS_B_259", :"SYS_B_260") GROUP BY Trunc(t.Cancelwaitingtime) UNION ALL SELECT Trunc(t.Cancelordertime) , :"SYS_B_261", :"SYS_B_262", :"SYS_B_263", :"SYS_B_264", :"SYS_B_265", :"SYS_B_266", :"SYS_B_267", :"SYS_B_268", :"SYS_B_269", count(t.Mopocsalesorderbillid) , :"SYS_B_270", :"SYS_B_271", :"SYS_B_272", :"SYS_B_273", :"SYS_B_274", :"SYS_B_275", :"SYS_B_276", :"SYS_B_277", :"SYS_B_278", :"SYS_B_279", :"SYS_B_280", :"SYS_B_281", :"SYS_B_282", :"SYS_B_283", :"SYS_B_284" FROM Salesorder_Bill t WHERE t.Cancelordertime >= to_date(:"SYS_B_285", :"SYS_B_286") and t.WAREHOUSEID=: "SYS_B_287" AND t.Cancelordertime <= to_date(:"SYS_B_288", :"SYS_B_289") GROUP BY Trunc(t.Cancelordertime) UNION ALL SELECT Trunc(t.Actualcanceltime) , :"SYS_B_290", :"SYS_B_291", :"SYS_B_292", :"SYS_B_293", :"SYS_B_294", :"SYS_B_295", :"SYS_B_296", :"SYS_B_297", :"SYS_B_298", :"SYS_B_299", count(t.Mopocsalesorderbillid) , :"SYS_B_300", :"SYS_B_301", :"SYS_B_302", :"SYS_B_303", :"SYS_B_304", :"SYS_B_305", :"SYS_B_306", :"SYS_B_307", :"SYS_B_308", :"SYS_B_309", :"SYS_B_310", :"SYS_B_311", :"SYS_B_312", :"SYS_B_313" FROM Salesorder_Bill t WHERE t.Actualcanceltime >= to_date(:"SYS_B_314", :"SYS_B_315") and t.WAREHOUSEID=:"SYS_B_316" AND t.Actualcanceltime <= to_date(:"SYS_B_ 317", :"SYS_B_318") GROUP BY Trunc(t.Actualcanceltime) UNION ALL SELECT Trunc(t.Orderprinttime) , :"SYS_B_319", :"SYS_B_320", :"SYS_B_321", :"SYS_B_322", :"SYS_B_323", :"SYS_B_324", :"SYS_B_325", :"SYS_B_326", :"SYS_B_327", :"SYS_B_328", :"SYS_B_329", count(t.Mopocsalesorderbillid) , :"SYS_B_330", :"SYS_B_331", :"SYS_B_332", :"SYS_B_333", :"SYS_B_334", :"SYS_B_335", :"SYS_B_336", :"SYS_B_337", :"SYS_B_338", :"SYS_B_339", :"SYS_B_340", :"SYS_B_341", :"SYS_B_342" FROM Salesorder_Bill t WHERE t.Orderprinttime >= to_date(:"SYS_B_343", :"SYS_B_344") and t.WAREHOUSEID=:"SYS_B_345" AND t.Orderprinttime <= to_date(:"SYS_B_346", :"SYS_B_347") GROUP BY Trunc(t.Orderprinttime) UNION A LL SELECT Trunc(t.Assignordertime) , :"SYS_B_348", :"SYS_B_349", :"SYS_B_350", :"SYS_B_351", :"SYS_B_352", :"SYS_B_353", :"SYS_B_354", :"SYS_B_355", :"SYS_B_356", :"SYS_B_357", :"SYS_B_358", :"SYS_B_359", count(t.Mopocsalesorderbillid) , :"SYS_B_360", :"SYS_B_361", :"SYS_B_362", :"SYS_B_363", :"SYS_B_364", :"SYS_B_365", :"SYS_B_366", :"SYS_B_367", :"SYS_B_368", :"SYS_B_369", :"SYS_B_370", :"SYS_B_371" FROM Salesorder_Bill t WHERE t.Assignordertime >= to_date(:"SYS_B_372", :"SYS_B_373") and t.WAREHOUSEID=:"SYS_B_374" AND t.Assignordertime <= to_date(:"SYS_B_375", :"SYS_B_376") GROUP BY Trunc(t.Assignordertime) UNION ALL SELECT Trunc(t.Pickingtime) , :"SYS_B_377", :"SYS_B_37 8", :"SYS_B_379", :"SYS_B_380", :"SYS_B_381", :"SYS_B_382", :"SYS_B_383", :"SYS_B_384", :"SYS_B_385", :"SYS_B_386", :"SYS_B_387", :"SYS_B_388", :"SYS_B_389", count(t.Mopocsalesorderbillid) , :"SYS_B_390", :"SYS_B_391", :"SYS_B_392", :"SYS_B_393", :"SYS_B_394", :"SYS_B_395", :"SYS_B_396", :"SYS_B_397", :"SYS_B_398", :"SYS_B_399", :"SYS_B_400" FROM Salesorder_Bill t WHERE t.Pickingtime >= to_date(:"SYS_B_401", :"SYS_B_402") and t.WAREHOUSEID=:"SYS_B_403" AND t.Pickingtime <= to_date(:"SYS_B_404", :"SYS_B_405") GROUP BY Trunc(t.Pickingtime) UNION ALL SELECT Trunc(t.Qctime) , :"SYS_B_406", :"SYS_B_407", :"SYS_B_408", :"SYS_B_409", :"SYS_B_410", :"SYS_B _411", :"SYS_B_412", :"SYS_B_413", :"SYS_B_414", :"SYS_B_415", :"SYS_B_416", :"SYS_B_417", :"SYS_B_418", :"SYS_B_419", count(t.Mopocsalesorderbillid) , :"SYS_B_420", :"SYS_B_421", :"SYS_B_422", :"SYS_B_423", :"SYS_B_424", :"SYS_B_425", :"SYS_B_426", :"SYS_B_427", :"SYS_B_428", :"SYS_B_429" FROM Salesorder_Bill t WHERE t.Qctime >= to_date(:"SYS_B_430", :"SYS_B_431") and t.WAREHOUSEID=:"SYS_B_432" AND t.Qctime <= to_date(:"SYS_B_433", :"SYS_B_434") GROUP BY Trunc(t.Qctime) UNION ALL SELECT Trunc(t.Actualshorttime) , :"SYS_B_435", :"SYS_B_436", :"SYS_B_437", :"SYS_B_438", :"SYS_B_439", :"SYS_B_440", :"SYS_B_441", :"SYS_B_442", :"SYS_B_443", :"SYS_B_444 ", :"SYS_B_445", :"SYS_B_446", :"SYS_B_447", :"SYS_B_448", :"SYS_B_449", count(t.Mopocsalesorderbillid) , :"SYS_B_450", :"SYS_B_451", :"SYS_B_452", :"SYS_B_453", :"SYS_B_454", :"SYS_B_455", :"SYS_B_456", :"SYS_B_457", :"SYS_B_458" FROM Salesorder_Bill t WHERE t.Actualshorttime >= to_date(:"SYS_B_459", :"SYS_B_460") and t.WAREHOUSEID=:"SYS_B_461" AND t.Actualshorttime <= to_date(:"SYS_B_462", :"SYS_B_463") GROUP BY Trunc(t.Actualshorttime) UNION ALL SELECT Trunc(t.Packtime), :"SYS_B_464", :"SYS_B_465", :"SYS_B_466", :"SYS_B_467", :"SYS_B_468", :"SYS_B_469", :"SYS_B_470", :"SYS_B_471", :"SYS_B_472", :"SYS_B_473", :"SYS_B_474", :"SYS_B_475", :"SYS_B_476", : "SYS_B_477", :"SYS_B_478", :"SYS_B_479", count(t.Mopocsalesorderbillid) , :"SYS_B_480", :"SYS_B_481", :"SYS_B_482", :"SYS_B_483", :"SYS_B_484", :"SYS_B_485", :"SYS_B_486", :"SYS_B_487" FROM Salesorder_Bill t WHERE t.Packtime >= to_date(:"SYS_B_488", :"SYS_B_489") and t.WAREHOUSEID=:"SYS_B_490" AND t.Packtime <= to_date(:"SYS_B_491", :"SYS_B_492") GROUP BY Trunc(t.Packtime) UNION ALL SELECT Trunc(t.Waybilltime) , :"SYS_B_493", :"SYS_B_494", :"SYS_B_495", :"SYS_B_496", :"SYS_B_497", :"SYS_B_498", :"SYS_B_499", :"SYS_B_500", :"SYS_B_501", :"SYS_B_502", :"SYS_B_503", :"SYS_B_504", :"SYS_B_505", :"SYS_B_506", :"SYS_B_507", :"SYS_B_508", :"SYS_B_509", c ount(t.Mopocsalesorderbillid) , :"SYS_B_510", :"SYS_B_511", :"SYS_B_512", :"SYS_B_513", :"SYS_B_514", :"SYS_B_515", :"SYS_B_516" FROM Salesorder_Bill t WHERE t.Waybilltime >= to_date(:"SYS_B_517", :"SYS_B_518") and t.WAREHOUSEID=:"SYS_B_519" AND t.Waybilltime <= to_date(:"SYS_B_520", :"SYS_B_521") GROUP BY Trunc(t.Waybilltime) UNION ALL SELECT Trunc(t.Handingtime) , :"SYS_B_522", :"SYS_B_523", :"SYS_B_524", :"SYS_B_525", :"SYS_B_526", :"SYS_B_527", :"SYS_B_528", :"SYS_B_529", :"SYS_B_530", :"SYS_B_531", :"SYS_B_532", :"SYS_B_533", :"SYS_B_534", :"SYS_B_535", :"SYS_B_536", :"SYS_B_537", :"SYS_B_538", :"SYS_B_539", count(t.Mopocsalesorderbillid) , :"SYS_B_540", :"S YS_B_541", :"SYS_B_542", :"SYS_B_543", :"SYS_B_544", :"SYS_B_545" FROM Salesorder_Bill t WHERE t.Handingtime >= to_date(:"SYS_B_546", :"SYS_B_547") and t.WAREHOUSEID=:"SYS_B_548" AND t.Handingtime <= to_date(:"SYS_B_549", :"SYS_B_550") GROUP BY Trunc(t.Handingtime) UNION ALL SELECT Trunc(t.Consigntime) , :"SYS_B_551", :"SYS_B_552", :"SYS_B_553", :"SYS_B_554", :"SYS_B_555", :"SYS_B_556", :"SYS_B_557", :"SYS_B_558", :"SYS_B_559", :"SYS_B_560", :"SYS_B_561", :"SYS_B_562", :"SYS_B_563", :"SYS_B_564", :"SYS_B_565", :"SYS_B_566", :"SYS_B_567", :"SYS_B_568", :"SYS_B_569", count(t.Mopocsalesorderbillid) , :"SYS_B_570", :"SYS_B_571", :"SYS_B_572", :"SYS_B_573", :"SYS_B_574" FROM Salesorder_Bill t WHERE t.Consigntime >= to_date(:"SYS_B_575", :"SYS_B_576") and t.WAREHOUSEID=:"SYS_B_577" AND t.Consigntime <= to_date(:"SYS_B_578", :"SYS_B_579") GROUP BY Trunc(t.Consigntime) UNION ALL SELECT Trunc(t.Endtime) , :"SYS_B_580", :"SYS_B_581", :"SYS_B_582", :"SYS_B_583", :"SYS_B_584", :"SYS_B_585", :"SYS_B_586", :"SYS_B_587", :"SYS_B_588", :"SYS_B_589", :"SYS_B_590", :"SYS_B_591", :"SYS_B_592", :"SYS_B_593", :"SYS_B_594", :"SYS_B_595", :"SYS_B_596", :"SYS_B_597", :"SYS_B_598", :"SYS_B_599", count(t.Mopocsalesorderbillid) , :"SYS_B_600", :"SYS_B_601", :"SYS_B_602", :"SYS_B_603" FROM Salesorder_Bill t WHERE t.Endtime >= to_date(:"SYS_B_604 ", :"SYS_B_605") and t.WAREHOUSEID=:"SYS_B_606" AND t.Endtime <= to_date(:"SYS_B_607", :"SYS_B_608") GROUP BY Trunc(t.Endtime) UNION ALL SELECT Trunc(t.Accountdate) , :"SYS_B_609", :"SYS_B_610", :"SYS_B_611", :"SYS_B_612", :"SYS_B_613", :"SYS_B_614", :"SYS_B_615", :"SYS_B_616", :"SYS_B_617", :"SYS_B_618", :"SYS_B_619", :"SYS_B_620", :"SYS_B_621", :"SYS_B_622", :"SYS_B_623", :"SYS_B_624", :"SYS_B_625", :"SYS_B_626", :"SYS_B_627", :"SYS_B_628", :"SYS_B_629", count(t.Mopocsalesorderbillid) , :"SYS_B_630", :"SYS_B_631", :"SYS_B_632" FROM Salesorder_Bill t WHERE t.Accountdate >= to_date(:"SYS_B_633", :"SYS_B_634") and t.WAREHOUSEID=:"SYS_B_635" AND t.Accountdate <= to_date(:"SYS_B_636", :"SYS_B_637") GROUP BY Trunc(t.Accountdate) UNION ALL SELECT Trunc(t.Modifiedtime) , :"SYS_B_638", :"SYS_B_639", :"SYS_B_640", :"SYS_B_641", :"SYS_B_642", :"SYS_B_643", :"SYS_B_644", :"SYS_B_645", :"SYS_B_646", :"SYS_B_647", :"SYS_B_648", :"SYS_B_649", :"SYS_B_650", :"SYS_B_651", :"SYS_B_652", :"SYS_B_653", :"SYS_B_654", :"SYS_B_655", :"SYS_B_656", :"SYS_B_657", :"SYS_B_658", :"SYS_B_659", count(t.Mopocsalesorderbillid) , :"SYS_B_660" , :"SYS_B_661" FROM Salesorder_Bill t WHERE t.Modifiedtime >= to_date(:"SYS_B_662", :"SYS_B_663") and t.WAREHOUSEID=:"SYS_B_664" AND t.Modifiedtime <= to_date(:"SYS_B_665", :"SYS_B_666") GROUP BY Trunc(t.Modifiedtim e) UNION ALL SELECT Trunc(t.Createtime) , :"SYS_B_667", :"SYS_B_668", :"SYS_B_669", :"SYS_B_670", :"SYS_B_671", :"SYS_B_672", :"SYS_B_673", :"SYS_B_674", :"SYS_B_675", :"SYS_B_676", :"SYS_B_677", :"SYS_B_678", :"SYS_B_679", :"SYS_B_680", :"SYS_B_681", :"SYS_B_682", :"SYS_B_683", :"SYS_B_684", :"SYS_B_685", :"SYS_B_686", :"SYS_B_687", :"SYS_B_688", :"SYS_B_689", count(t.Mopocsalesorderbillid) , :"SYS_B_690" FROM Salesorder_Bill t WHERE t.Createtime >= to_date(:"SYS_B_691", :"SYS_B_692") and t.WAREHOUSEID=:"SYS_B_693" AND t.Createtime <= to_date(:"SYS_B_694", :"SYS_B_695") GROUP BY Trunc(t.Createtime) UNION ALL SELECT Trunc(t.Updatetime) , :"SYS_B_696", :"SYS_B_697", : "SYS_B_698", :"SYS_B_699", :"SYS_B_700", :"SYS_B_701", :"SYS_B_702", :"SYS_B_703", :"SYS_B_704", :"SYS_B_705", :"SYS_B_706", :"SYS_B_707", :"SYS_B_708", :"SYS_B_709", :"SYS_B_710", :"SYS_B_711", :"SYS_B_712", :"SYS_B_713", :"SYS_B_714", :"SYS_B_715", :"SYS_B_716", :"SYS_B_717", :"SYS_B_718", :"SYS_B_719", count(t.Mopocsalesorderbillid) FROM Salesorder_Bill t WHERE t.Updatetime >= to_date(:"SYS_B_720", :"SYS_B_721") and t.WAREHOUSEID=:"SYS_B_722" AND t.Updatetime <= to_date(:"SYS_B_723", :"SYS_B_724") GROUP BY Trunc(t.Updatetime) ) k where :"SYS_B_725"=:"SYS_B_726" AND :"SYS_B_727"=:"SYS_B_728" Group By Trunc(k.统计日期)) A WHERE ROWNUM <= :"SYS_B_729" ) WHERE RN > :"SYS_B_730"
c945g7cwb4nb3	DELETE FROM PICKING_BILLSOURCE_HZTEMP
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"
ch0jb5v1psc13	create table jjjj_test as Select distinct m.Skuid 商品sku From (Select b.Goodstype_Name, Bm.Depname, p.Brand_Name, g.Skuid, g.Goodsname, g.Goodsno, g.Goodsbarcode, Sum(s.Lastsh + s.Lastxt - s.Lastjt - s.Lastxs - s.Lastps + s.Lastpy - s.Lastout + s.Lastin) Orikc, Sum(s.Cursh) Cursh, Sum(s.Curjt) Curjt, Sum(s.Curxs) Curxs, Sum(s.Curxt) Curxt, Sum(s.Curps) Curps, Sum(s.Curpy) Curpy, Sum(s.Curout) Curout, Sum(s.Curin) Curin, Sum(s.Shsl + s.Xtsl - s.Jtsl - s.Xssl - s.Pssl + s.Pysl - s.Ycout + s.Ycin) Endkc From (Select t.Skuid, k.Departmentid, Sum(t.Actual_Qty) Shsl, 0 Shje, 0 Xtsl, 0 Xtje, 0 Jtsl, 0 Jtje, 0 Xssl, 0 Xsje, 0 Pssl, 0 Psje, 0 Pysl, 0 Pyje, 0 Ycout, 0 Ycin, Sum(Decode(Sign(k.Receivedate - To_Date('2013-12-09', 'yyyy-mm-dd')), 1, t.Actual_Qty, 0)) Cursh, 0 Curxt, 0 Curjt, 0 Curxs, 0 Curps, 0 Curpy, 0 Curout, 0 Curin, Sum(Decode(Sign(k.Receivedate - To_Date('2013-12-09', 'yyyy-mm-dd')), -1, t.Actual_Qty, 0)) Lastsh, 0 Lastxt, 0 Last jt, 0 Lastxs, 0 Lastps, 0 Lastpy, 0 Lastout, 0 Lastin From Receive_Billdetail t Left Join Receive_Bill k On k.Receivebillid = t.Receivebillid Where k.Ownerid = '51034' And k.Bill_State >= '04' And k.Bill_State <> '09' And t.Receive_Qty > 0 And k.Businesstypeid <> '移仓单' And k.Receivedate < To_Date('2013-12-16', 'yyyy-mm-dd') Group By t.Skuid, k.Departmentid Union All Select t.Skuid, t.Departmentid, 0, 0, Sum(t.Return_Qty), Sum(Trunc(t.Return_Qty * t.Saleprice, 2)), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(k.Confirmdate - To_Date('2013-12-09', 'yyyy-mm-dd')), 1, t.Return_Qty, 0)), 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(k.Confirmdate - To_Date('2013-12-09', 'yyyy-mm-dd')), -1, t.Return_Qty, 0)), 0, 0, 0, 0, 0, 0 From Salesreturn_Billdetail t Left Join Salesreturn_Bill k On k.Salesreturnbillid = t.Salesreturnbillid Where t.Ownerid = '51034' And k.Bill_State >= '03' And k.Bill_State <> '09' And t.Return_Qty > 0 And k.Confirmdate < To_Date('2013-12-16', 'yyyy-mm-dd') Group By t.Skuid, t.Departmentid Union All Select t.Skuid, k.Departmentid, 0, 0, 0, 0, Sum(t.Consign_Quantity), Sum(Trunc(t.Price * t.Consign_Quantity, 2)), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(k.Consigndate - To_Date('2013-12-09', 'yyyy-mm-dd')), 1, t.Consign_Quantity, 0)), 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(k.Consigndate - To_Date('2013-12-09', 'yyyy-mm-dd')), -1, t.Consign_Quantity, 0)), 0, 0, 0, 0, 0 From Purchase_Returnbilldetail t Left Join Purchase_Returnbill k On k.Purchasereturnbillid = t.Purchasereturnbillid Where k.Ownerid = '51034' And k.Bill_State >= '06' And k.Bill_State <> '10' And k.Consigndate < To_Date('2013-12-16', 'yyyy-mm-dd') And t.Consign_Quantity > 0 Group By t.Skuid, k.Departmentid Union All Select t.Skuid, t.Departmentid, 0, 0, 0, 0, 0, 0, Sum(t.Order_Qty), Sum(Trunc(t.Saleprice * t.Order_Qty, 2)), 0, 0, 0, 0, 0 , 0, 0, 0, 0, Sum(Decode(Sign(k.Handingtime - To_Date('2013-12-09', 'yyyy-mm-dd')), 1, t.Order_Qty, 0)), 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(k.Handingtime - To_Date('2013-12-09', 'yyyy-mm-dd')), -1, t.Order_Qty, 0)), 0, 0, 0, 0 From Salesorder_Billdetail t Left Join Salesorder_Bill k On k.Mopocsalesorderbillid = t.Mopocsalesorderbillid Where t.Ownerid = '51034' And k.Bill_State <> '09' And k.Bill_State >= '06' And k.Ordertypeid In ('1', '4', '5', '7') And k.Handingtime < To_Date('2013-12-16', 'yyyy-mm-dd') Group By t.Skuid, t.Departmentid Union All Select t.Skuid, t.Departmentid, 0, 0, 0, 0, 0, 0, Sum(t.Order_Qty), Sum(Trunc(t.Saleprice * t.Order_Qty, 2)), 0, 0, 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(k.Handingtime - To_Date('2013-12-09', 'yyyy-mm-dd')), 1, t.Order_Qty, 0)), 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(k.Handingtime - To_Date('2013-12-09', 'yyyy-mm-dd')), -1, t.Order_Qty, 0)), 0, 0, 0, 0 From Sales order_Billdetail_His t Left Join Salesorder_Bill_His k On k.Mopocsalesorderbillid = t.Mopocsalesorderbillid Where t.Ownerid = '51034' And k.Bill_State <> '09' And k.Bill_State >= '06' And k.Ordertypeid In ('1', '4', '5', '7') And k.Handingtime < To_Date('2013-12-16', 'yyyy-mm-dd') Group By t.Skuid, t.Departmentid Union All Select t.Skuid, k.Departmentid, 0, 0, 0, 0, 0, 0, 0, 0, Sum(t.Qty), Sum(Trunc(t.Qty * t.Price, 2)), 0, 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(k.Checkdate - To_Date('2013-12-09', 'yyyy-mm-dd')), 1, t.Qty, 0)), 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(k.Checkdate - To_Date('2013-12-09', 'yyyy-mm-dd')), -1, t.Qty, 0)), 0, 0, 0 From Profitandloss_Billdetail t Left Join Profitandloss_Bill k On k.Profitandlossbillid = t.Profitandlossbillid Where k.Ownerid = '51034' And k.Bill_State >= '03' And k.Bill_State <> '89' And k.Profitandlosstypeid In ('1', '3', '4', '5') And k.Checkdate < To_Date('2013-12-16', 'yyy y-mm-dd') Group By t.Skuid, k.Departmentid Union All Select t.Skuid, k.Departmentid, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Sum(t.Qty), Sum(Trunc(t.Qty * t.Price, 2)), 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(k.Checkdate - To_Date('2013-12-09', 'yyyy-mm-dd')), 1, t.Qty, 0)), 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(k.Checkdate - To_Date('2013-12-09', 'yyyy-mm-dd')), -1, t.Qty, 0)), 0, 0 From Profitandloss_Billdetail t Left Join Profitandloss_Bill k On k.Profitandlossbillid = t.Profitandlossbillid Where k.Ownerid = '51034' And k.Bill_State >= '03' And k.Bill_State <> '89' And k.Profitandlosstypeid In ('2', '6', '7', '8') And k.Checkdate < To_Date('2013-12-16', 'yyyy-mm-dd') Group By t.Skuid, k.Departmentid Union All Select Mx.Skuid, Mx.Departmentid, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Sum(Mx.Inoutqty), 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(Mx.Createdate - To_Date('2013-12-09', 'yyyy-mm-dd')), 1, Mx.Inoutqty, 0)), 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(Mx.Createdate - To_Date('2013-12-09', 'yyyy-mm-dd')), -1, Mx.Inoutqty, 0)), 0 From Inventory_Inoutdetail Mx Where Mx.Logisticstypeid = '移仓单' And Mx.Ownerid = '51034' And Mx.Createdate < To_Date('2013-12-16', 'yyyy-mm-dd') Group By Mx.Skuid, Mx.Departmentid Union All Select Mx.Skuid, Mx.Departmentid, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Sum(Mx.Inoutqty), 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(Mx.Createdate - To_Date('2013-12-09', 'yyyy-mm-dd')), 1, Mx.Inoutqty, 0)), 0, 0, 0, 0, 0, 0, 0, Sum(Decode(Sign(Mx.Createdate - To_Date('2013-12-09', 'yyyy-mm-dd')), -1, Mx.Inoutqty, 0)) From Inventory_Inoutdetail Mx Where Mx.Businesstypeid = '移仓单' And Mx.Ownerid = '51034' And Mx.Createdate < To_Date('2013-12-16', 'yyyy-mm-dd') Group By Mx.Skuid, Mx.Departmentid) s Inner Join Base_Goodsinfo g On g.Skuid = s.Skuid Left Join Base_Goodstype b On b.Goodstype_Id = g.Goodstypeid Left Join Base_Brand p On p.Brand_Id = g.Brandid Left Join Base_Department Bm On Bm.Departmentid = s.Departmentid Where Nvl(g.Salepropertyid, ' ') <> 'WZ0031' Group By b.Goodstype_Name, Bm.Depname, p.Brand_Name, g.Skuid, g.Goodsname, g.Goodsno, g.Goodsbarcode) m Where m.Orikc + m.Cursh + m.Curjt + m.Curxs + m.Curxt + m.Curps + m.Curpy + m.Curout + m.Curin + m.Endkc > 0 And m.Depname = 'KDLY电子商务部'
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
cs8dmum3qmyk3	Select count(*) From Salesorder_Bill_Bhis t Order By T.Createtime Asc
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
czu08paxaswpm	select mopocsalesorderbillid, outersalesorderbillid, shopname, receivername, boxno, package_saleamount, package_sumqty, delivery_cost, goodsbarcode, goodsname, package_qty, saleprice, packageamount, invoiceflag, invoicedesc, invoicepackagedesc, printpriceflag, ordertime, ((case when t.package_serial >= :"SYS_B_0" and t.package_serial <= :"SYS_B_1" then :"SYS_B_2" || t.package_serial else t.package_serial || :"SYS_B_3" end) || :"SYS_B_4" || (case when t.package_number >= :"SYS_B_5" and t.package_number <= :"SYS_B_6" then :"SYS_B_7" || t.package_number else t.package_number || :"SYS_B_8" end)) package_serialdesc from waybilldetail_package_print t where t.waybill_packageid = :Arg_Billid
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)
drutu27fjdtr6	Select distinct m.Skuid 商品sku From (Select b.Goodstype_Name, Bm.Depname, p.Brand_Name, g.Skuid, g.Goodsname, g.Goodsno, g.Goodsbarcode, Sum(s.Lastsh + s.Lastxt - s.Lastjt - s.Lastxs - s.Lastps + s.Lastpy - s.Lastout + s.Lastin) Orikc, Sum(s.Cursh) Cursh, Sum(s.Curjt) Curjt, Sum(s.Curxs) Curxs, Sum(s.Curxt) Curxt, Sum(s.Curps) Curps, Sum(s.Curpy) Curpy, Sum(s.Curout) Curout, Sum(s.Curin) Curin, Sum(s.Shsl + s.Xtsl - s.Jtsl - s.Xssl - s.Pssl + s.Pysl - s.Ycout + s.Ycin) Endkc From (Select t.Skuid, k.Departmentid, Sum(t.Actual_Qty) Shsl, :"SYS_B_000" Shje, :"SYS_B_001" Xtsl, :"SYS_B_002" Xtje, :"SYS_B_003" Jtsl, :"SYS_B_004" Jtje, :"SYS_B_005" Xssl, :"SYS_B_006" Xsje, :"SYS_B_007" Pssl, :"SYS_B_008" Psje, :"SYS_B_009" Pysl, :"SYS_B_010" Pyje, :"SYS_B_011" Ycout, :"SYS_B_012" Ycin, Sum(Decode(Sign(k.Receivedate - To_Date(:"SY S_B_013", :"SYS_B_014")), :"SYS_B_015", t.Actual_Qty, :"SYS_B_016")) Cursh, :"SYS_B_017" Curxt, :"SYS_B_018" Curjt, :"SYS_B_019" Curxs, :"SYS_B_020" Curps, :"SYS_B_021" Curpy, :"SYS_B_022" Curout, :"SYS_B_023" Curin, Sum(Decode(Sign(k.Receivedate - To_Date(:"SYS_B_024", :"SYS_B_025")), -:"SYS_B_026", t.Actual_Qty, :"SYS_B_027")) Lastsh, :"SYS_B_028" Lastxt, :"SYS_B_029" Lastjt, :"SYS_B_030" Lastxs, :"SYS_B_031" Lastps, :"SYS_B_032" Lastpy, :"SYS_B_033" Lastout, :"SYS_B_034" Lastin From Receive_Billdetail t Left Join Receive_Bill k On k.Receivebillid = t.Receivebillid Where k.Ownerid = :"SYS_B_035" And k.Bill_State >= :"SYS_B_036" And k.Bill_State <> :"SYS_B_037" And t.Receive_Qty > :"SYS_B_038" And k. Businesstypeid <> :"SYS_B_039" And k.Receivedate < To_Date(:"SYS_B_040", :"SYS_B_041") Group By t.Skuid, k.Departmentid Union All Select t.Skuid, t.Departmentid, :"SYS_B_042", :"SYS_B_043", Sum(t.Return_Qty), Sum(Trunc(t.Return_Qty * t.Saleprice, :"SYS_B_044")), :"SYS_B_045", :"SYS_B_046", :"SYS_B_047", :"SYS_B_048", :"SYS_B_049", :"SYS_B_050", :"SYS_B_051", :"SYS_B_052", :"SYS_B_053", :"SYS_B_054", :"SYS_B_055", Sum(Decode(Sign(k.Confirmdate - To_Date(:"SYS_B_056", :"SYS_B_057")), :"SYS_B_058", t.Return_Qty, :"SYS_B_059")), :"SYS_B_060", :"SYS_B_061", :"SYS_B_062", :"SYS_B_063", :"SYS_B_064", :"SYS_B_065", :"SYS_B_066", Sum(Decode(Sign(k.Confirmdate - To_Date(:"SYS _B_067", :"SYS_B_068")), -:"SYS_B_069", t.Return_Qty, :"SYS_B_070")), :"SYS_B_071", :"SYS_B_072", :"SYS_B_073", :"SYS_B_074", :"SYS_B_075", :"SYS_B_076" From Salesreturn_Billdetail t Left Join Salesreturn_Bill k On k.Salesreturnbillid = t.Salesreturnbillid Where t.Ownerid = :"SYS_B_077" And k.Bill_State >= :"SYS_B_078" And k.Bill_State <> :"SYS_B_079" And t.Return_Qty > :"SYS_B_080" And k.Confirmdate < To_Date(:"SYS_B_081", :"SYS_B_082") Group By t.Skuid, t.Departmentid Union All Select t.Skuid, k.Departmentid, :"SYS_B_083", :"SYS_B_084", :"SYS_B_085", :"SYS_B_086", Sum(t.Consign_Quantity), Sum(Trunc(t.Price * t.Consign_Quantity, :"SYS_B_087")), :"SYS_B_088", :"SYS_B_089", :"SYS_B_090", :"SYS_B_091", : "SYS_B_092", :"SYS_B_093", :"SYS_B_094", :"SYS_B_095", :"SYS_B_096", :"SYS_B_097", Sum(Decode(Sign(k.Consigndate - To_Date(:"SYS_B_098", :"SYS_B_099")), :"SYS_B_100", t.Consign_Quantity, :"SYS_B_101")), :"SYS_B_102", :"SYS_B_103", :"SYS_B_104", :"SYS_B_105", :"SYS_B_106", :"SYS_B_107", :"SYS_B_108", Sum(Decode(Sign(k.Consigndate - To_Date(:"SYS_B_109", :"SYS_B_110")), -:"SYS_B_111", t.Consign_Quantity, :"SYS_B_112")), :"SYS_B_113", :"SYS_B_114", :"SYS_B_115", :"SYS_B_116", :"SYS_B_117" From Purchase_Returnbilldetail t Left Join Purchase_Returnbill k On k.Purchasereturnbillid = t.Purchasereturnbillid Where k.Ownerid = :"SYS_B_118" And k.Bill_State >= :"SYS_B_119" And k.Bill_State <> :"SYS_B_120" And k.Consigndate < To_Date(:"SYS_B_121", :"SYS_B_122") And t.Consign_Quantity > :"SYS_B_123" Group By t.Skuid, k.Departmentid Union All Select t.Skuid, t.Departmentid, :"SYS_B_124", :"SYS_B_125", :"SYS_B_126", :"SYS_B_127", :"SYS_B_128", :"SYS_B_129", Sum(t.Order_Qty), Sum(Trunc(t.Saleprice * t.Order_Qty, :"SYS_B_130")), :"SYS_B_131", :"SYS_B_132", :"SYS_B_133", :"SYS_B_134", :"SYS_B_135", :"SYS_B_136", :"SYS_B_137", :"SYS_B_138", :"SYS_B_139", Sum(Decode(Sign(k.Handingtime - To_Date(:"SYS_B_140", :"SYS_B_141")), :"SYS_B_142", t.Order_Qty, :"SYS_B_143")), :"SYS_B_144", :"SYS_B_145", :"SYS_B_146", :"SYS_B_147", :"SYS_B_148", :"SYS_B_149 ", :"SYS_B_150", Sum(Decode(Sign(k.Handingtime - To_Date(:"SYS_B_151", :"SYS_B_152")), -:"SYS_B_153", t.Order_Qty, :"SYS_B_154")), :"SYS_B_155", :"SYS_B_156", :"SYS_B_157", :"SYS_B_158" From Salesorder_Billdetail t Left Join Salesorder_Bill k On k.Mopocsalesorderbillid = t.Mopocsalesorderbillid Where t.Ownerid = :"SYS_B_159" And k.Bill_State <> :"SYS_B_160" And k.Bill_State >= :"SYS_B_161" And k.Ordertypeid In (:"SYS_B_162", :"SYS_B_163", :"SYS_B_164", :"SYS_B_165") And k.Handingtime < To_Date(:"SYS_B_166", :"SYS_B_167") Group By t.Skuid, t.Departmentid Union All Select t.Skuid, t.Departmentid, :"SYS_B_168", :"SYS_B_169", :"SYS_B_170", :"SYS_B_171", :"SYS_B_172", :"SYS_B_173", Sum(t.Order_Qty), Sum(Trunc(t.Sal eprice * t.Order_Qty, :"SYS_B_174")), :"SYS_B_175", :"SYS_B_176", :"SYS_B_177", :"SYS_B_178", :"SYS_B_179", :"SYS_B_180", :"SYS_B_181", :"SYS_B_182", :"SYS_B_183", Sum(Decode(Sign(k.Handingtime - To_Date(:"SYS_B_184", :"SYS_B_185")), :"SYS_B_186", t.Order_Qty, :"SYS_B_187")), :"SYS_B_188", :"SYS_B_189", :"SYS_B_190", :"SYS_B_191", :"SYS_B_192", :"SYS_B_193", :"SYS_B_194", Sum(Decode(Sign(k.Handingtime - To_Date(:"SYS_B_195", :"SYS_B_196")), -:"SYS_B_197", t.Order_Qty, :"SYS_B_198")), :"SYS_B_199", :"SYS_B_200", :"SYS_B_201", :"SYS_B_202" From Salesorder_Billdetail_His t Left Join Salesorder_Bill_His k On k.Mopocsalesorderbillid = t.Mopocsalesorderbillid Where t.Ownerid = :"SYS_B_203" And k.Bill_State <> :"SYS_B_204" And k.Bill_State >= :"SYS_B_205" And k.Ordertypeid In (:"SYS_B_206", :"SYS_B_207", :"SYS_B_208", :"SYS_B_209") And k.Handingtime < To_Date(:"SYS_B_210", :"SYS_B_211") Group By t.Skuid, t.Departmentid Union All Select t.Skuid, k.Departmentid, :"SYS_B_212", :"SYS_B_213", :"SYS_B_214", :"SYS_B_215", :"SYS_B_216", :"SYS_B_217", :"SYS_B_218", :"SYS_B_219", Sum(t.Qty), Sum(Trunc(t.Qty * t.Price, :"SYS_B_220")), :"SYS_B_221", :"SYS_B_222", :"SYS_B_223", :"SYS_B_224", :"SYS_B_225", :"SYS_B_226", :"SYS_B_227", :"SYS_B_228", Sum(Decode(Sign(k.Checkdate - To_Date(:"SYS_B_229", :"SYS_B_230")), :"SYS_B_231", t.Qty, :"SYS_ B_232")), :"SYS_B_233", :"SYS_B_234", :"SYS_B_235", :"SYS_B_236", :"SYS_B_237", :"SYS_B_238", :"SYS_B_239", Sum(Decode(Sign(k.Checkdate - To_Date(:"SYS_B_240", :"SYS_B_241")), -:"SYS_B_242", t.Qty, :"SYS_B_243")), :"SYS_B_244", :"SYS_B_245", :"SYS_B_246" From Profitandloss_Billdetail t Left Join Profitandloss_Bill k On k.Profitandlossbillid = t.Profitandlossbillid Where k.Ownerid = :"SYS_B_247" And k.Bill_State >= :"SYS_B_248" And k.Bill_State <> :"SYS_B_249" And k.Profitandlosstypeid In (:"SYS_B_250", :"SYS_B_251", :"SYS_B_252", :"SYS_B_253") And k.Checkdate < To_Date(:"SYS_B_254", :"SYS_B_255") Group By t.Skuid, k.Departmentid Union All Select t.Skuid, k.Departmentid, :"SYS_B_256", :"SYS_B_257", : "SYS_B_258", :"SYS_B_259", :"SYS_B_260", :"SYS_B_261", :"SYS_B_262", :"SYS_B_263", :"SYS_B_264", :"SYS_B_265", Sum(t.Qty), Sum(Trunc(t.Qty * t.Price, :"SYS_B_266")), :"SYS_B_267", :"SYS_B_268", :"SYS_B_269", :"SYS_B_270", :"SYS_B_271", :"SYS_B_272", :"SYS_B_273", Sum(Decode(Sign(k.Checkdate - To_Date(:"SYS_B_274", :"SYS_B_275")), :"SYS_B_276", t.Qty, :"SYS_B_277")), :"SYS_B_278", :"SYS_B_279", :"SYS_B_280", :"SYS_B_281", :"SYS_B_282", :"SYS_B_283", :"SYS_B_284", Sum(Decode(Sign(k.Checkdate - To_Date(:"SYS_B_285", :"SYS_B_286")), -:"SYS_B_287", t.Qty, :"SYS_B_288")), :"SYS_B_289", :"SYS_B_290" From Profitandloss_Billdetail t Le ft Join Profitandloss_Bill k On k.Profitandlossbillid = t.Profitandlossbillid Where k.Ownerid = :"SYS_B_291" And k.Bill_State >= :"SYS_B_292" And k.Bill_State <> :"SYS_B_293" And k.Profitandlosstypeid In (:"SYS_B_294", :"SYS_B_295", :"SYS_B_296", :"SYS_B_297") And k.Checkdate < To_Date(:"SYS_B_298", :"SYS_B_299") Group By t.Skuid, k.Departmentid Union All Select Mx.Skuid, Mx.Departmentid, :"SYS_B_300", :"SYS_B_301", :"SYS_B_302", :"SYS_B_303", :"SYS_B_304", :"SYS_B_305", :"SYS_B_306", :"SYS_B_307", :"SYS_B_308", :"SYS_B_309", :"SYS_B_310", :"SYS_B_311", Sum(Mx.Inoutqty), :"SYS_B_312", :"SYS_B_313", :"SYS_B_314", :"SYS_B_315", :"SYS_B_316", :"SYS_B_317", :"SYS_B_318", Sum(D ecode(Sign(Mx.Createdate - To_Date(:"SYS_B_319", :"SYS_B_320")), :"SYS_B_321", Mx.Inoutqty, :"SYS_B_322")), :"SYS_B_323", :"SYS_B_324", :"SYS_B_325", :"SYS_B_326", :"SYS_B_327", :"SYS_B_328", :"SYS_B_329", Sum(Decode(Sign(Mx.Createdate - To_Date(:"SYS_B_330", :"SYS_B_331")), -:"SYS_B_332", Mx.Inoutqty, :"SYS_B_333")), :"SYS_B_334" From Inventory_Inoutdetail Mx Where Mx.Logisticstypeid = :"SYS_B_335" And Mx.Ownerid = :"SYS_B_336" And Mx.Createdate < To_Date(:"SYS_B_337", :"SYS_B_338") Group By Mx.Skuid, Mx.Departmentid Union All Select Mx.Skuid, Mx.Departmentid, :"SYS_B_339", :"SYS_B_340", :"SYS_B_341", :"SYS_B_342", :"SYS_B_343", :"SYS_B_344", :"SYS_B_345", :"SYS_B_346", :"S YS_B_347", :"SYS_B_348", :"SYS_B_349", :"SYS_B_350", :"SYS_B_351", Sum(Mx.Inoutqty), :"SYS_B_352", :"SYS_B_353", :"SYS_B_354", :"SYS_B_355", :"SYS_B_356", :"SYS_B_357", :"SYS_B_358", Sum(Decode(Sign(Mx.Createdate - To_Date(:"SYS_B_359", :"SYS_B_360")), :"SYS_B_361", Mx.Inoutqty, :"SYS_B_362")), :"SYS_B_363", :"SYS_B_364", :"SYS_B_365", :"SYS_B_366", :"SYS_B_367", :"SYS_B_368", :"SYS_B_369", Sum(Decode(Sign(Mx.Createdate - To_Date(:"SYS_B_370", :"SYS_B_371")), -:"SYS_B_372", Mx.Inoutqty, :"SYS_B_373")) From Inventory_Inoutdetail Mx Where Mx.Businesstypeid = :"SYS_B_374" And Mx.Ownerid = :"SYS_B_375" And Mx.Createdate < To_Date(:"SYS_B_376", :"SYS_B_377") Group By Mx.Skuid, Mx.Departmentid) s Inner Join Base_Goodsinfo g On g.Skuid = s.Skuid Left Join Base_Goodstype b On b.Goodstype_Id = g.Goodstypeid Left Join Base_Brand p On p.Brand_Id = g.Brandid Left Join Base_Department Bm On Bm.Departmentid = s.Departmentid Where Nvl(g.Salepropertyid, :"SYS_B_378") <> :"SYS_B_379" Group By b.Goodstype_Name, Bm.Depname, p.Brand_Name, g.Skuid, g.Goodsname, g.Goodsno, g.Goodsbarcode) m Where m.Orikc + m.Cursh + m.Curjt + m.Curxs + m.Curxt + m.Curps + m.Curpy + m.Curout + m.Curin + m.Endkc > :"SYS_B_380" And m.Depname = :"SYS_B_381"
f0bau8us91au2	Select G.Goodsbarcode 商品条码, G.Skuid, Sb.Order_Qty 数量 From Salesorder_Bill t, Salesorder_Billdetail Sb, Base_Goodsinfo g Where T.Bill_State > :"SYS_B_00" And Sb.Mopocsalesorderbillid = Sb.Mopocsalesorderbillid And Sb.Skuid = G.Skuid And T.Bill_State <> :"SYS_B_01" And T.Createtime >= To_Date(:"SYS_B_02", :"SYS_B_03") And T.Createtime <= To_Date(:"SYS_B_04", :"SYS_B_05") And Exists (Select :"SYS_B_06" From (Select Tt.Pickingbillid From Picking_Bill Tt Where Tt.Jxfqid In (:"SYS_B_07", :"SYS_B_08") Union Select Tt.Pickingbillid From Picking_Bill_His Tt Where Tt.Jxfqid In (:"SYS_B_09", :"SYS_B_10") Union Select Tt.Pickingbillid From Picking_Bill_His_Bhis Tt Where Tt.Jxfqid In (:"SYS_B_11", :"SYS_B_12")) d Where D.Pickingbillid = T.Pickingbillid) Union Select G.Goodsbarcode 商品条码, G.Skuid, Sb.Order_Qty 数量 From Salesorder_Bill_Bhis t, Sale sorder_Billdetail_Bhis Sb, Base_Goodsinfo g Where T.Bill_State > :"SYS_B_13" And Sb.Mopocsalesorderbillid = Sb.Mopocsalesorderbillid And Sb.Skuid = G.Skuid And T.Bill_State <> :"SYS_B_14" And T.Createtime >= To_Date(:"SYS_B_15", :"SYS_B_16") And T.Createtime <= To_Date(:"SYS_B_17", :"SYS_B_18") And Exists (Select :"SYS_B_19" From (Select Tt.Pickingbillid From Picking_Bill Tt Where Tt.Jxfqid In (:"SYS_B_20", :"SYS_B_21") Union Select Tt.Pickingbillid From Picking_Bill_His Tt Where Tt.Jxfqid In (:"SYS_B_22", :"SYS_B_23") Union Select Tt.Pickingbillid From Picking_Bill_His_Bhis Tt Where Tt.Jxfqid In (:"SYS_B_24", :"SYS_B_25")) d Where D.Pickingbillid = T.Pickingbillid)
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
fp008yqbhbw8x	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN Declare Descerr Varchar2(500); Begin Job_If_Get_Salesorder30(As_Systemid => '2', As_Userid => 'admin', Descerr => Descerr); If Descerr Is Not Null Then Rollback; Sys_Sysjob_Logcreate('2', 1864, '存储过程Job_If_Get_Salesorder30执行失败' || Descerr, 'false', Descerr); End If; Commit; End; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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;
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
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
gp2srf6v3th3r	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in (:"SYS_B_0", :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in (:"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6", :"SYS_B_7")
gwgu2wkrdpsmp	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 PICKINGBILLNO Like :"SYS_B_2" Order By MOPOCSALESORDERBILLID)

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: 508,952

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.