WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ZCX	3500833474	zcx1	1	10.2.0.4.0	YES	ZCXDB1

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	6927	11-3ÔÂ -13 19:00:02	417	2.6
End Snap:	6928	11-3ÔÂ -13 20:00:13	365	2.5
Elapsed:		60.19 (mins)
DB Time:		33.58 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	3,920M	3,920M	Std Block Size:	8K
Shared Pool Size:	6,128M	6,128M	Log Buffer:	47,096K

Load Profile

	Per Second	Per Transaction
Redo size:	2,742,885.66	369,112.41
Logical reads:	28,252.81	3,802.00
Block changes:	23,275.52	3,132.21
Physical reads:	2.56	0.34
Physical writes:	264.31	35.57
User calls:	227.93	30.67
Parses:	79.54	10.70
Hard parses:	4.02	0.54
Sorts:	13.43	1.81
Logons:	0.19	0.03
Executes:	92.36	12.43
Transactions:	7.43

% Blocks changed per Read:	82.38	Recursive Call %:	22.55
Rollback per transaction %:	13.69	Rows per Sort:	4063.89

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	93.73	Soft Parse %:	94.95
Execute to Parse %:	13.88	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	99.44	% Non-Parse CPU:	89.36

Shared Pool Statistics

	Begin	End
Memory Usage %:	90.12	90.54
% SQL with executions>1:	88.67	87.58
% Memory for SQL w/exec>1:	86.55	81.64

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		1,707		84.7
Log archive I/O	9,623	329	34	16.3	System I/O
log file parallel write	30,059	306	10	15.2	System I/O
log file sync	20,148	240	12	11.9	Commit
log file sequential read	10,020	146	15	7.2	System I/O

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	43.18	5.81
Global Cache blocks served:	10.26	1.38
GCS/GES messages received:	39.72	5.34
GCS/GES messages sent:	75.89	10.21
DBWR Fusion writes:	1.07	0.14
Estd Interconnect traffic (KB)	450.14

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %:	99.85
Buffer access - remote cache %:	0.15
Buffer access - disk %:	0.00

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	0.4
Avg global cache current block receive time (ms):	0.4
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	1.7
Avg global cache cr block flush time (ms):	15.0
Avg global cache current block pin time (ms):	1,485.5
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	1.2
Avg global cache current block flush time (ms):	78.5

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	387.3
Avg message sent queue time on ksxp (ms):	0.2
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	61.52
% of indirect sent messages:	24.92
% of flow controlled messages:	13.56

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
• init.ora Parameters

More RAC Statistics

• RAC Report Summary
• Global Enqueue Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats

Wait Events Statistics

• Time Model Statistics
• Wait Class
• Wait Events
• Background Wait Events
• Operating System Statistics
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 2014.9s
• 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

Wait Class

• s - second
• cs - centisecond - 100th of a second
• ms - millisecond - 1000th of a second
• us - microsecond - 1000000th of a second
• ordered by wait time desc, waits desc

Back to Wait Events Statistics
Back to Top

Wait Events

• s - second
• cs - centisecond - 100th of a second
• ms - millisecond - 1000th of a second
• us - microsecond - 1000000th of a second
• ordered by wait time desc, waits desc (idle events last)

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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 centisecond (100th of a second)

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• SQL ordered by Cluster Wait Time
• 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

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 DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

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: 102,038,176
• Captured SQL account for 76.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 9,249
• Captured SQL account for 32.8% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 333,570
• Captured SQL account for 74.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 287,282
• Captured SQL account for 79.8% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0dwr2vd6vbqzs	SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0g47gcz2jh18c	select * from(select tmptable1.*, rownum from (select * from shortmessage_wait_send where send_status='0' and sm_type_code in (1, 2, 3, 4, 5, 6, 7, 10, 11, 12, 13, 14) and (retry_count is null or retry_count=-1 or send_count<retry_count) and schedule_time<=sysdate and (expire_time is null or expire_time>sysdate) order by priority asc, schedule_time asc, expire_time asc) tmptable1)tmptable2 where rownum <= 100 order by rownum asc
0hn47ugzrmka3	insert into INTERFACE_LOG (RESTAURANT_ID, METHOD, NOTE, IP_ADDRESS, OPERATE_TIME, RS_INTERFACE_LOG_ID) values (:1, :2, :3, :4, :5, :6)
0x6vgnxuq1dwh	SELECT TR.T_ID FROM TEMP_REST TR WHERE (((INSTR(TR.T_NAME, :B3 ) > 0 OR INSTR(:B3 , TR.T_NAME) > 0) AND (INSTR(TR.T_ADDRESS, :B2 ) > 0 OR INSTR(:B2 , TR.T_ADDRESS) > 0)) OR ((INSTR(TR.T_NAME, :B3 ) > 0 OR INSTR(:B3 , TR.T_NAME) > 0) AND (INSTR(TR.T_TEL, :B1 ) > 0 OR INSTR(:B1 , TR.T_TEL) > 0)) OR ((INSTR(TR.T_ADDRESS, :B2 ) > 0 OR INSTR(:B2 , TR.T_ADDRESS) > 0) AND (INSTR(TR.T_TEL, :B1 ) > 0 OR INSTR(:B1 , TR.T_TEL) > 0)))
0xfzvtfau27h0	SELECT r.RESTAURANT_ID FROM restaurant r, prod_food_card pfc WHERE r.restaurant_id = pfc.restaurant_id(+) AND (r.operate_time > to_date('2013-03-11 16:09:53', 'yyyy-MM-dd HH24:mi:ss') or pfc.update_time > to_date('2013-03-11 16:09:53', 'yyyy-MM-dd HH24:mi:ss'))
17f603htbs76j	select tbl.*, cast(cast(tbl.ORDER_RS_AFFIRM_TIMELY_NUM / decode(tbl.ORDER_RS_AFFIRM_NUM, 0, 1, tbl.ORDER_RS_AFFIRM_NUM) * 100 as decimal(10, 2)) as varchar(5)) || '%' ORDER_RS_AFFIRM_TIMELY_PERCENT from (select (select nvl(sum(CREATE_ORDER_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.create_time, 'YYYY-MM-DD') as OPERATE_DATE, o.create_operator_id as OPERATOR_ID, o.create_operator as OPERATOR_NAME, 1 as CREATE_ORDER_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.create_operator_id=u.sys_user_id where 1=1 and o.create_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.create_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.accept_city_org_id=86) t) order_total_num, (select nvl(sum(CREATE_DEAL_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.create_time, 'YYYY-MM-DD') as OPERATE_DATE, o.create_operat or_id as OPERATOR_ID, o.create_operator as OPERATOR_NAME, 1 as CREATE_ORDER_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.create_operator_id=u.sys_user_id where 1=1 and o.create_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.create_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.accept_city_org_id=86) t) order_create_deal_num, (select nvl(sum(CANCEL_ORDER_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.order_cancel_time, 'YYYY-MM-DD') as OPERATE_DATE, o.order_cancel_operator_id as OPERATOR_ID, o.order_cancel_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 1 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.order_cancel_operator_id=u.sys_user_id where 1=1 and o.order_cancel _time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.order_cancel_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and ( o.accept_city_org_id=86 or ( o.handle_org_id=22 and o.handle_city_org_id=86))) t) order_cancel_num, (select nvl(sum(RS_AFFIRM_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, case when (o.rs_affirm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.rs_affirm_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86) t) order_rs_affirm_num, (select nvl(sum(RS_AFFIRM _TIMELY_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, case when (o.rs_affirm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.rs_affirm_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86) t) order_rs_affirm_timely_num, (select nvl(sum(CUST_AFFIRM_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_affirm_operator_id as OPERATOR_ID, o.cust_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 1 as CUST_AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else 1 end as AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.cust_affirm_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86) t) order_cust_affirm_num, (select nvl(sum(AFFIRM_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, cas e when (o.rs_affirm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.rs_affirm_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_affirm_operator_id as OPERATOR_ID, o.cust_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 1 as CUST_AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else 1 end as AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o .rs_affirm_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.cust_affirm_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86) t) order_affirm_num, (select nvl(sum(AFFIRM_DEAL_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, case when (o.rs_affirm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:0 0:00', 'yyyy-MM-dd hh24:mi:ss') and o.rs_affirm_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_affirm_operator_id as OPERATOR_ID, o.cust_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 1 as CUST_AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else 1 end as AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.cust_affirm_time<=to_date('2013-03-11 23:59:59', 'y yyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86) t) order_affirm_deal_num, (select nvl(sum(RS_CHECK_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_check_operator_id as OPERATOR_ID, o.rs_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 1 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 1 as CHECK_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.rs_check_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86) t) order_rs_check_num, (select nvl(sum(CUST_CHECK_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_check_operator_id as OPERATOR_ID, o .cust_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 1 as CUST_CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else 1 end as CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.cust_check_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86) t) order_cust_check_num, (select nvl(sum(CHECK_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_check_operator_id as OPERATOR_ID, o.rs_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM , 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 1 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 1 as CHECK_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.rs_check_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_check_operator_id as OPERATOR_ID, o.cust_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 1 as CUST_CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else 1 end as CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.cust_check_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86) t) order_check_num, (select nvl(sum(CHECK_DEAL_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_check_operator_id as OPERATOR_ID, o.rs_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 1 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 1 as CHECK_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.rs_check_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_check_operator_id as OPERATOR_ID, o.cust_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 1 as CUST_CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else 1 end as CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.cust_check_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city _org_id=86) t) order_check_deal_num from dual) tbl
19tf6qxr2gpv2	insert into ORDER_LOG (ORDER_ID, IP_ADDRESS, ACTION, OLD_STATUS, NEW_STATUS, NOTE, OPERATOR, OPERATE_TIME, SERVICE_CENTER_ID, ORDER_LOG_ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
1tj9txn0w686a	select count(*) amt from order_info a left join order_info_4bill o4 on a.order_id = o4.order_id where 1=1 and a.order_status in (2, 3) and a.check_order_mode= '1' and o4.rs_check_flag is null and o4.cust_check_flag is null and a.BOOK_TIME>= TO_DATE('2013-03-01', 'YYYY-MM-DD') and a.BOOK_TIME< TO_DATE('2013-03-10', 'YYYY-MM-DD')+1 AND ((1=0) or (a.handle_org_id=20)) AND (1=0 or a.order_process_flag='1' or a.order_process_flag='2')
1xtpt28s7mff1	SELECT O.ORDER_ID FROM ORDER_INFO O LEFT JOIN ORDER_INFO_4BILL B4 ON O.ORDER_ID = B4.ORDER_ID LEFT JOIN ORDER_CHECK C ON O.ORDER_ID = C.ORDER_ID WHERE 1=1 AND O.HANDLE_ORG_ID = '10' AND O.HANDLE_CITY_ORG_ID = '84' AND ((O.CREATE_TIME >= TO_DATE('20130311185813', 'yyyy-MM-dd hh24:mi:ss') AND O.CREATE_TIME <= TO_DATE('20130311191813', 'yyyy-MM-dd hh24:mi:ss')) OR (O.OPERATE_TIME >= TO_DATE('20130311185813', 'yyyy-MM-dd hh24:mi:ss') AND O.OPERATE_TIME <= TO_DATE('20130311191813', 'yyyy-MM-dd hh24:mi:ss')) OR (C.RS_AFFIRM_TIME >= TO_DATE('20130311185813', 'yyyy-MM-dd hh24:mi:ss') AND C.RS_AFFIRM_TIME <= TO_DATE('20130311191813', 'yyyy-MM-dd hh24:mi:ss')) OR (C.CUST_AFFIRM_TIME >= TO_DATE('20130311185813', 'yyyy-MM-dd hh24:mi:ss') AND C.CUST_AFFIRM_TIME <= TO_DATE('20130311191813', 'yyyy-MM-dd hh24:mi:ss')) OR (B4.RS_CHECK_TIME >= TO_DATE('20130311185813', 'yyyy-MM-dd hh24:mi:ss') AND B4.RS_CHECK_TIME <= TO_DATE('20130311191813', 'yyyy-MM-dd hh24:mi:ss')) OR (B4.CUST_CHECK_TIME >= TO_DATE('20130311185813', 'yyyy-MM-dd hh24:mi:ss') AND B4.CUST_CHECK_TIME <= TO_DATE('20130311191813', 'yyyy-MM-dd hh24:mi:ss')) OR (C.ORDER_CANCEL_TIME >= TO_DATE('20130311185813', 'yyyy-MM-dd hh24:mi:ss') AND C.ORDER_CANCEL_TIME <= TO_DATE('20130311191813', 'yyyy-MM-dd hh24:mi:ss')))
1y0a5myacftqz	select t.*, pro.province_name, pro.province_code, cit.city_name, cit.city_code, dis.district_name, dis.district_code, bus.business_area_name, cf.cuisine_first_name, cs.cuisine_second_name from (select * from (select RESTAURANT_ID, ORG_PROVINCE_ID, ORG_CITY_ID, NAME, ENG_NAME, NAME_FIRST_PY, ALIAS_NAME, REGISTER_NAME, BOOK_TEL, PROVINCE_ID, CITY_ID, DISTRICT_ID, ZIP, ADDRESS, ADDRESS_FIRST_PY, CROSS_ROAD, BUSINESS_AREA_ID, LANDMARK, TRAFFIC_ROUTE, GPS_X, GPS_Y, FAX, WEBSITE, EMAIL, INTRODUCE, BUSINESS_TIME, decode(publish_status, 0, 0, sign_status) sign_status, BUSINESS_STATUS, CONTRACT_ID, LOW_AVG_COST, HIGH_AVG_COST, SUIT_TYPE, FLAVOUR, CUISINE_FIRST_ID, CUISINE_SECOND_ID, MINOR_CUISINE, SPECIALTY, IS_RESERVE_ROOM, RESERVE_ROOM_NUM, RESERVE_ROOM_DESC, MIN_CHARGE_DESC, IS_SERVICE_CHARGE, SERVICE_CHARGE_DESC, IS_SUPPORT_CARD, CARD_DESC, TOTAL_SEAT_NUM, TOTAL_DESK_NUM, HALL_SEAT_NUM, HALL_DESK_NUM, BUSINESS_ACREAGE, IS_PARKING, PARKING_DESC, TAKEOUT_SERVICE, FACILITY, SERVICE, ENVIRONMENT, RECOMMEND_VALUE, SP_FOLLOWER, SP_FOLLOWER_TEL, REPRESENT, REPRESENT_TEL, FINANCE_NAME, FINANCE_TEL, FINANCE_FAX, FINANCE_EMAIL, BILL_POST_ADDRESS, BILL_POST_ZIP, DEPOSIT_RULE, RETAIN_TIME, ORDER_CHECKER, ORDER_CHECK_TEL, ORDER_CHECK_ATTENTION, CUST_CHECK_WAY, NOTE, CREATE_OPERATOR, CREATE_TIME, OPERATOR, OPERATE_TIME, ORG_ID, decode(publish_status, 0, 0, booking_status) BOOKING_STATUS, CARD_CONSUME, IS_TAKEOUT, BOOK_REQUIREMENT, LOCAL_ID, IMAGE_ABBR_ID, SOURCE, REALTIME_SERVICE_FLAG, REALTIME_INTERFACE_ID, PASSWORD, CHECK_BILL_DATE, BILL_POST_WAY, INVOICE_HEADING, INVOICE_POST_ADDR, INVOICE_CONSIGNEE, INVOCIE_POST_CODE, CREATE_OPERATOR_ID, OPERATOR_ID, CHECK_ORDER_MODE, KEY_WORD, PUBLISH_STATUS, DISCOUNT, DISCOUNT_DESC, CUST_ID, IMAGE_FULL_ID, BILL_CONSIGNEE, JIAMENG_APPLY_SIGN, RECOMMEND_STATUS, HOT, REDFLAG_GIS_SPACE, CHECK_SEAT_FLAG, KOUBEI_RS_FLAG, BOOK_SUCCESS_SMS, CONSUME_SUCCESS_SMS, EBOOKING_FLAG, COUPON_BUSINESS_FLAG, BUSINESS_CARD_FLAG, COUPON_RS_TYPE, GRADE, IS_TRUST, PRODUCT_INTRODUCE, PREFERENTIAL_INFO, LAST_OPERATE_SOURCE, LAST_OPERATE_IP, VIP_DISCOUNT, 'Y' delete_flag from H_RESTAURANT r where 1=1 and r.operate_time >= to_date(:1 , 'yyyy-mm-dd hh24:mi:ss') union all select RESTAURANT_ID, ORG_PROVINCE_ID, ORG_CITY_ID, NAME, ENG_NAME, NAME_FIRST_PY, ALIAS_NAME, REGISTER_NAME, BOOK_TEL, PROVINCE_ID, CITY_ID, DISTRICT_ID, ZIP, ADDRESS, ADDRESS_FIRST_PY, CROSS_ROAD, BUSINESS_AREA_ID, LANDMARK, TRAFFIC_ROUTE, GPS_X, GPS_Y, FAX, WEBSITE, EMAIL , INTRODUCE, BUSINESS_TIME, decode(publish_status, 0, 0, sign_status) sign_status, BUSINESS_STATUS, CONTRACT_ID, LOW_AVG_COST, HIGH_AVG_COST, SUIT_TYPE, FLAVOUR, CUISINE_FIRST_ID, CUISINE_SECOND_ID, MINOR_CUISINE, SPECIALTY, IS_RESERVE_ROOM, RESERVE_ROOM_NUM, RESERVE_ROOM_DESC, MIN_CHARGE_DESC, IS_SERVICE_CHARGE, SERVICE_CHARGE_DESC, IS_SUPPORT_CARD, CARD_DESC, TOTAL_SEAT_NUM, TOTAL_DESK_NUM, HALL_SEAT_NUM, HALL_DESK_NUM, BUSINESS_ACREAGE, IS_PARKING, PARKING_DESC, TAKEOUT_SERVICE, FACILITY, SERVICE, ENVIRONMENT, RECOMMEND_VALUE, SP_FOLLOWER, SP_FOLLOWER_TEL, REPRESENT, REPRESENT_TEL, FINANCE_NAME, FINANCE_TEL, FINANCE_FAX, FINANCE_EMAIL, BILL_POST_ADDRESS, BILL_POST_ZIP, DEPOSIT_RULE, RETAIN_TIME, ORDER_CHECKER, ORDER_CHECK_TEL, ORDER_CHECK_ATTENTION, CUST_CHECK_WAY, NOTE, CREATE_OPERATOR, CREATE_TIME, OPERATOR, OPERATE_TIME, ORG_ID, decode(publish_status, 0, 0, booking_status) booking_status, CARD_CONSUME, IS_TAKEOUT, BOOK_REQUIREMENT, LOCAL_ID, IMAGE_ABBR_ID, SOURCE, REALTIME_SERVICE_FLAG, REALTIME_INTERFACE_ID, PASSWORD, CHECK_BILL_DATE, BILL_POST_WAY, INVOICE_HEADING, INVOICE_POST_ADDR, INVOICE_CONSIGNEE, INVOCIE_POST_CODE, CREATE_OPERATOR_ID, OPERATOR_ID, CHECK_ORDER_MODE, KEY_WORD, PUBLISH_STATUS, DISCOUNT, DISCOUNT_DESC, CUST_ID, IMAGE_FULL_ID, BILL_CONSIGNEE, JIAMENG_APPLY_SIGN, RECOMMEND_STATUS, HOT, REDFLAG_GIS_SPACE, CHECK_SEAT_FLAG, KOUBEI_RS_FLAG, BOOK_SUCCESS_SMS, CONSUME_SUCCESS_SMS, EBOOKING_FLAG, COUPON_BUSINESS_FLAG, BUSINESS_CARD_FLAG, COUPON_RS_TYPE, GRADE, IS_TRUST, PRODUCT_INTRODUCE, PREFERENTIAL_INFO, LAST_OPERATE_SOURCE, LAST_OPERATE_IP, VIP_DISCOUNT, 'N' as delete_flag from RESTAURANT r where 1=1 and r.operate_time >= to_date(:2 , 'yyyy-mm-dd hh24:mi:ss') ) hr where hr.restaurant_id > :3 order by hr.restaurant_id asc) t , cuisine_first cf, cuisine_second cs, province pro, city cit, district dis, business_area bus where t.province_id = pro.province_id(+) and t.city_id = cit.city_id(+) and t.district_id = dis.district_id(+) and t.business_area_id = bus.business_area_id(+) and t.cuisine_first_id=cf.cuisine_first_id(+) and t.cuisine_second_id=cs.cuisine_second_id(+) and rownum <= :4
2r8m6sczasak5	select 1 FROM dual
34v2tcm3r80jc	BEGIN p_matchProvideRes( :1, :2); END;
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4nvs08fnngd66	select x.* from (select rownum x_rownum, o.* from (select OPERATOR_ID as CID, OPERATOR_NAME as OPERATOR, sum(CREATE_ORDER_NUM) ORDER_TOTAL_NUM, sum(CREATE_DEAL_NUM) ORDER_CREATE_DEAL_NUM, sum(CANCEL_ORDER_NUM) ORDER_CANCEL_NUM, sum(RS_AFFIRM_NUM) ORDER_RS_AFFIRM_NUM, sum(RS_AFFIRM_TIMELY_NUM) ORDER_RS_AFFIRM_TIMELY_NUM, cast(cast(sum(RS_AFFIRM_TIMELY_NUM) / decode(sum(RS_AFFIRM_NUM), 0, 1, sum(RS_AFFIRM_NUM)) * 100 as decimal(10, 2)) as varchar(5)) || '%' ORDER_RS_AFFIRM_TIMELY_PERCENT, sum(CUST_AFFIRM_NUM) ORDER_CUST_AFFIRM_NUM, sum(AFFIRM_NUM) ORDER_AFFIRM_NUM, sum(AFFIRM_DEAL_NUM) ORDER_AFFIRM_DEAL_NUM, sum(RS_CHECK_NUM) ORDER_RS_CHECK_NUM, sum(CUST_CHECK_NUM) ORDER_CUST_CHECK_NUM, sum(CHECK_NUM) ORDER_CHECK_NUM, sum(CHECK_DEAL_NUM) ORDER_CHECK_DEAL_NUM from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.create_time, 'YYYY-MM-DD') as OPERATE_DATE, o.create_operator_id as OPERATOR_ID, o.create_operator as OPERATOR_NAME, 1 as CREATE_ORDER_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.create_operator_id=u.sys_user_id where 1=1 and o.create_time>=to_date('201 3-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.accept_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.order_cancel_time, 'YYYY-MM-DD') as OPERATE_DATE, o.order_cancel_operator_id as OPERATOR_ID, o.order_cancel_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 1 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.order_cancel_operator_id=u.sys_user_id where 1=1 and o.order_cancel_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and ( o.accept_org_id=9 or o.handle_org_id=9) union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, case when (o.rs_affirm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIR M_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_affirm_operator_id as OPERATOR_ID, o.cust_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 1 as CUST_AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else 1 end as AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_check_operator_id as OPERATOR_ID, o.rs_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 1 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 1 as CHECK_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_check_operator_id as OPERATOR_ID, o.cust_check_operator as OPERATO R_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 1 as CUST_CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else 1 end as CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 ) t group by OPERATOR_ID, OPERATOR_NAME order by CID) o ) x where x_rownum<=10 and x_rownum>=1 order by x.x_rownum
520mkxqpf15q8	select 1 from dual
5v7ydyz8rvx3n	select PROV_RES_ID, PROVIDER_TYPE, RELATION_ID, RES_NAME, RES_TEL, RES_ADDRESS, RES_DISCOUNT, PROVINCE_ID, CITY_ID, CREATE_TIME, UPDATE_TIME, CREATER_NAME, UPDATER_NAME, DISCOUNT_REMARK, IS_DELETE from PROD_PROVIDER_RES where PROV_RES_ID = :1
67mvkmkdrtbk6	select SEQ_INTERFACE_LOG.nextval from dual
6cv3th0fzdvj7	select 1 FROM dual
6r48tax1318zz	select x.* from (select rownum x_rownum, o.* from (SELECT o.order_id, o.cust_name, o.cust_tel, o.restaurant_name, o.order_status, o.vip, o.restaurant_tel, o.book_time, o.book_require, o.assigned_confirmor , o.ORDER_SOURCE, o.BOOK_RESULT, o.DEAL_LEVEL, o.BOOK_PERSON_NUM, o.BOOK_DESK_NUM, o.RESTAURANT_ID, DECODE(o.restaurant_affirm_flag, 1, 'ÊÇ', '') ||'/'|| rs_affirm_operator rs_affirm_dis, DECODE(o.customer_affirm_flag, 1, 'ÊÇ', '') ||'/'|| cust_affirm_operator cs_affirm_dis, (select b.status_name from dic_order_status b where b.status_code=o.order_status) status_name, (select d.source_name from dic_source d where d.source_code=o.order_source) source_name, o.create_operator, o.create_time, decode(deal_level, 1, '¡Ì', '') deal_lev, case when (ol.lock_time+15/1440 < sysdate) then (select u1.full_name from sys_service_center_user u1 where u1.sys_user_id=ol.lock_operator) ||'(³¬)' else (select u1.full_name from sys_service_center_user u1 where u1.sys_user_id=ol.lock_operator) end lockoperator FROM (select a.*, b.restaurant_affirm_flag, b.rs_affirm_operator, b.rs_affirm_time, b.restaurant_affirmer, b.cust_affirm_operator, b.cust_affirm_operator_id, b.rs_affirm_operator_id, b.cust_affirm_time, b.customer_affirm_flag, b.is_deposit, b.reserve_time, b.book_result, b.order_cancel_operator, b.order_cancel_time, b.order_cancel_operator_id, b.order_cancel_reason from ( select * from order_info a where 1=1 AND book_time >= TO_ DATE('2013-03-11', 'YYYY-MM-DD')) a left join (select * from order_check b where 1=1 ) b on a.order_id = b.order_id) o LEFT JOIN order_lock ol ON o.order_id = ol.Order_Id WHERE 1=1 AND ( 1=0 OR o.order_status = 1 OR o.order_status = 6 OR o.order_status = 5 ) AND ( 1=0 OR ol.lock_operator = '4145' OR ((ol.order_id IS NULL OR trim(ol.order_id) = '') and (o.ebooking_flag is null or o.ebooking_flag='0' or (o.ebooking_flag='1' and (o.restaurant_affirm_flag is not null or o.create_time<sysdate-5/1440)))) OR ol.lock_time < sysdate-15/1440 ) AND ((1=0) or (o.handle_org_id=9)) AND (1=0 or o.order_process_flag='1' or o.order_process_flag='2')ORDER BY O.VIP DESC, o.deal_level desc, o.create_time ) o ) x where x_rownum<=10 and x_rownum>=1 order by x.x_rownum
760p0g98cwdjg	select SEQ_ORDER_LOG.nextval from dual
7bfagrnpbjtdr	select count(1) from ( SELECT REST.Restaurant_Id AS RestaurantId, con.COMMISSION_FIX, REST.NAME AS RESTAURANTNAME, CT.CITY_NAME ||'/'||DIST.DISTRICT_NAME AS DISTRICT , BA.BUSINESS_AREA_NAME AS BUSINESS_AREA_NAME, REST.RECOMMEND_VALUE AS RECOMMENDVALUE, REST.LOW_AVG_COST ||'-'||REST.HIGH_AVG_COST AS AVGCOST, DICS.SETTLE_WAY_NAME AS WAYNAME, DECODE(REST.SIGN_STATUS, 0, 'δǩԼ', '1', 'ÒÑÇ©Ô¼') AS SIGNSTATUS, SUM(CASE WHEN ORD.ORDER_ID IS NOT NULL THEN 1 ELSE 0 END ) AS COUNT, SUM(CASE WHEN ORD.ORDER_STATUS=3 OR ORD.ORDER_STATUS=2 THEN 1 ELSE 0 END) AS ORDEROK , ROUND((SUM(CASE WHEN ORD.ORDER_STATUS = 3 OR ORD.ORDER_STATUS = 2 THEN 1 ELSE 0 END)/COUNT(*) ) * 100 )|| '%'AS CCO, SUM(CASE WHEN ORD.ORDER_STATUS=4 or ORD.ORDER_STATUS=5 or ORD.ORDER_STATUS=6 THEN 1 ELSE 0 END )AS CANCELORDER, SUM(CASE WHEN ORD.ORDER_STATUS=3 AND ORD.RS_CHECK_FLAG=1 THEN 1 ELSE 0 END) AS TradingVolume, ROUND((SUM(CASE WHEN ORD.ORDER_STATUS = 3 AND ORD.RS_CHECK_FLAG = 1 THEN 1 ELSE 0 END)/COUNT(*))*100 )|| '%'AS SSO, SUM (CASE WHEN ORD.ORDER_STATUS=3 AND ORD.RS_CHECK_FLAG=1 THEN ORD.Check_Desk_Num ELSE 0 END) AS TOTALDESKNUM , SUM (CASE WHEN ORD.ORDER_STATUS=3 AND ORD.RS_CHECK_FLAG=1 THEN ORD.CHECK_PERSON_NUM ELSE 0 END) AS TOTALPERSONNUM, SUM (CASE WHEN ORD.ORDER_STATUS=3 AND ORD.RS_CHECK_FLAG=1 THEN ORD.CHECK_AMOUNT_TOTAL ELSE 0 END) AS AMOUNTTOTA, SUM (CASE WHEN ORD.ORDER_STATUS=3 AND ORD.RS_CHECK_FLAG=3 THEN 1 ELSE 0 END) AS EXCEPTIONORDER, SUM (bl.C OMMISION) as COMMISIONSUM FROM Restaurant REST LEFT JOIN ORG_PROVINCE SYSPRO ON REST.ORG_PROVINCE_ID = SYSPRO.ORG_PROVINCE_ID LEFT OUTER JOIN ORG_CITY SYSCITY ON REST.Org_City_Id = SYSCITY.ORG_CITY_ID LEFT JOIN PROVINCE PRO ON PRO.PROVINCE_ID = REST.PROVINCE_ID LEFT OUTER JOIN DISTRICT DIST ON DIST.DISTRICT_ID = REST.DISTRICT_ID LEFT JOIN City CT ON REST.CITY_ID = CT.CITY_ID LEFT JOIN BUSINESS_AREA BA ON REST.BUSINESS_AREA_ID = BA.BUSINESS_AREA_ID LEFT JOIN REPORT_REST_DEALT ORD ON ORD.RESTAURANT_ID = REST.RESTAURANT_ID LEFT OUTER JOIN CONTRACT CON ON CON.CONTRACT_ID = REST.CONTRACT_ID LEFT OUTER JOIN DIC_SETTLE_WAY DICS ON DICS.SETTLE_WAY_CODE = CON.SETTLE_WAY_CODE LEFT JOIN BILL_LIST bl on ORD.order_id=bl.order_id WHERE 1=1 AND REST.ORG_PROVINCE_ID = '19' AND REST.Province_Id = '19' AND REST.City_Id = '200' AND ORD.CREATE_TIME >= TO_DATE('2013-03-11', 'YYYY-MM-DD') AND ORD.CREATE_TIME < TO_DATE('2013-03-11', 'YYYY-MM-DD')+1 GROUP BY REST.Restaurant_Id, con.COMMISSION_FIX, SYSCITY.NAME, SYSPRO.NAME, REST.NAME, DICS.SETTLE_WAY_NAME, CT.CITY_NAME, DIST.DISTRICT_NAME, BA.BUSINESS_AREA_NAME, REST.RECOMMEND_VALUE, REST.LOW_AVG_COST, REST.HIGH_AVG_COST, REST.SIGN_STATUS ORDER BY SUM(CASE WHEN ORD.ORDER_ID IS NOT NULL THEN 1 ELSE 0 END ) desc)
7h35uxf5uhmm1	select sysdate from dual
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
827qu4m10cj55	update shortmessage_wait_send set send_status='1' where (send_status is null or send_status='0') and sysdate>=expire_time
89ykc55t68q1t	select count(1) from (select create_operator, count(*) orders_total_num, sum(decode(business_type, 1, 1, 0)) orders_meal_num, sum(decode(business_type, 2, 1, 0)) orders_ktv_num, sum(decode(order_status, 2, 1, 3, 1, 0)) orders_success_num, cast(cast(sum(decode(order_status, 2, 1, 3, 1, 0)) / count(*) * 100 as decimal(10, 2)) as varchar(5)) || '%' success_percent, sum(decode(order_status, 4, 1, 0)) order_cancel_num, sum(decode(order_status, 1, 1, 0)) order_not_confirm_num, sum(decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0)) order_deal_num, cast(cast(sum(decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0)) / count(*) * 100 as decimal(10, 2)) as varchar(5)) || '%' deal_percent, sum(check_desk_num) check_desk_num, sum(check_person_num) check_person_num, sum(check_amount_total) check_amount_total, sum(decode(order_status, 3, decode(rs_check_flag, 2, 1, 0), 0)) order_not_consume_num, sum(decode(order_status, 3, decode(rs_check_flag, 3, 1, 0), 0)) order_exception_num from REPORT_ORDER_VOLUME where 1=1 and create_time>=to_date('2013-02-20', 'yyyy-MM-dd') and create_time<to_date('2013-03-11', 'yyyy-MM-dd')+1 and accept_org_id=28 and accept_city_org_id=4 and ((1=0) or (accept_org_id=28)) group by create_operator_id, create_operator order by create_operator)
8prjhgrpvx46c	INSERT INTO TEMP_REST ( SELECT R.RESTAURANT_ID, R.NAME, R.ADDRESS, R.BOOK_TEL FROM RESTAURANT R WHERE R.CITY_ID=:B1 )
8zgpq15rjtxz7	DELETE FROM TEMP_REST
9rrsshamt76mj	select count(1) from (select a.*, b.name_first_py, b.name, b.order_check_attention, b.book_tel, b.order_check_tel, b.sign_status from (select a.restaurant_id, case when (min(restaurant_lock.lock_time)+20/1440 < sysdate) then '' else min(c.full_name) end lock_operator, count(*) amt from order_info a left join order_info_4bill o4 on a.order_id = o4.order_id left join restaurant_lock on a.restaurant_id=restaurant_lock.restaurant_id left join sys_service_center_user c on restaurant_lock.lock_operator=c.sys_user_id where 1=1 and a.order_status in (2, 3) and a.check_order_mode= '1' and o4.rs_check_flag is null and o4.cust_check_flag is null and a.BOOK_TIME>= TO_DATE('2013-03-01', 'YYYY-MM-DD') and a.BOOK_TIME< TO_DATE('2013-03-10', 'YYYY-MM-DD')+1 AND ((1=0) or (a.handle_org_id=20)) AND (1=0 or a.order_process_flag='1' or a.order_process_flag='2') group by a.restaurant_id )a, restaurant b where a.restaurant_id=b.restaurant_id order by name_first_py)
a66x81cyzf2uy	select x.* from (select rownum x_rownum, o.* from (select OPERATOR_ID as CID, OPERATOR_NAME as OPERATOR, sum(CREATE_ORDER_NUM) ORDER_TOTAL_NUM, sum(CREATE_DEAL_NUM) ORDER_CREATE_DEAL_NUM, sum(CANCEL_ORDER_NUM) ORDER_CANCEL_NUM, sum(RS_AFFIRM_NUM) ORDER_RS_AFFIRM_NUM, sum(RS_AFFIRM_TIMELY_NUM) ORDER_RS_AFFIRM_TIMELY_NUM, cast(cast(sum(RS_AFFIRM_TIMELY_NUM) / decode(sum(RS_AFFIRM_NUM), 0, 1, sum(RS_AFFIRM_NUM)) * 100 as decimal(10, 2)) as varchar(5)) || '%' ORDER_RS_AFFIRM_TIMELY_PERCENT, sum(CUST_AFFIRM_NUM) ORDER_CUST_AFFIRM_NUM, sum(AFFIRM_NUM) ORDER_AFFIRM_NUM, sum(AFFIRM_DEAL_NUM) ORDER_AFFIRM_DEAL_NUM, sum(RS_CHECK_NUM) ORDER_RS_CHECK_NUM, sum(CUST_CHECK_NUM) ORDER_CUST_CHECK_NUM, sum(CHECK_NUM) ORDER_CHECK_NUM, sum(CHECK_DEAL_NUM) ORDER_CHECK_DEAL_NUM from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.create_time, 'YYYY-MM-DD') as OPERATE_DATE, o.create_operator_id as OPERATOR_ID, o.create_operator as OPERATOR_NAME, 1 as CREATE_ORDER_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.create_operator_id=u.sys_user_id where 1=1 and o.create_time>=to_date('201 3-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.accept_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.order_cancel_time, 'YYYY-MM-DD') as OPERATE_DATE, o.order_cancel_operator_id as OPERATOR_ID, o.order_cancel_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 1 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.order_cancel_operator_id=u.sys_user_id where 1=1 and o.order_cancel_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and ( o.accept_org_id=9 or o.handle_org_id=9) union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, case when (o.rs_affirm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIR M_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_affirm_operator_id as OPERATOR_ID, o.cust_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 1 as CUST_AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else 1 end as AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_check_operator_id as OPERATOR_ID, o.rs_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 1 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 1 as CHECK_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_check_operator_id as OPERATOR_ID, o.cust_check_operator as OPERATO R_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 1 as CUST_CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else 1 end as CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 ) t group by OPERATOR_ID, OPERATOR_NAME order by CID) o ) x where x_rownum<=20 and x_rownum>=11 order by x.x_rownum
ab85rhgcg34qr	SELECT O.ORDER_ID FROM ORDER_INFO O LEFT JOIN ORDER_INFO_4BILL B4 ON O.ORDER_ID = B4.ORDER_ID LEFT JOIN ORDER_CHECK C ON O.ORDER_ID = C.ORDER_ID WHERE 1=1 AND O.HANDLE_ORG_ID = '10' AND O.HANDLE_CITY_ORG_ID = '100' AND ((O.CREATE_TIME >= TO_DATE('20130311185724', 'yyyy-MM-dd hh24:mi:ss') AND O.CREATE_TIME <= TO_DATE('20130311191724', 'yyyy-MM-dd hh24:mi:ss')) OR (O.OPERATE_TIME >= TO_DATE('20130311185724', 'yyyy-MM-dd hh24:mi:ss') AND O.OPERATE_TIME <= TO_DATE('20130311191724', 'yyyy-MM-dd hh24:mi:ss')) OR (C.RS_AFFIRM_TIME >= TO_DATE('20130311185724', 'yyyy-MM-dd hh24:mi:ss') AND C.RS_AFFIRM_TIME <= TO_DATE('20130311191724', 'yyyy-MM-dd hh24:mi:ss')) OR (C.CUST_AFFIRM_TIME >= TO_DATE('20130311185724', 'yyyy-MM-dd hh24:mi:ss') AND C.CUST_AFFIRM_TIME <= TO_DATE('20130311191724', 'yyyy-MM-dd hh24:mi:ss')) OR (B4.RS_CHECK_TIME >= TO_DATE('20130311185724', 'yyyy-MM-dd hh24:mi:ss') AND B4.RS_CHECK_TIME <= TO_DATE('20130311191724', 'yyyy-MM-dd hh24:mi:ss')) OR (B4.CUST_CHECK_TIME >= TO_DATE('20130311185724', 'yyyy-MM-dd hh24:mi:ss') AND B4.CUST_CHECK_TIME <= TO_DATE('20130311191724', 'yyyy-MM-dd hh24:mi:ss')) OR (C.ORDER_CANCEL_TIME >= TO_DATE('20130311185724', 'yyyy-MM-dd hh24:mi:ss') AND C.ORDER_CANCEL_TIME <= TO_DATE('20130311191724', 'yyyy-MM-dd hh24:mi:ss')))
akrj56fjmsv58	select count(1) from (select OPERATOR_ID as CID, OPERATOR_NAME as OPERATOR, sum(CREATE_ORDER_NUM) ORDER_TOTAL_NUM, sum(CREATE_DEAL_NUM) ORDER_CREATE_DEAL_NUM, sum(CANCEL_ORDER_NUM) ORDER_CANCEL_NUM, sum(RS_AFFIRM_NUM) ORDER_RS_AFFIRM_NUM, sum(RS_AFFIRM_TIMELY_NUM) ORDER_RS_AFFIRM_TIMELY_NUM, cast(cast(sum(RS_AFFIRM_TIMELY_NUM) / decode(sum(RS_AFFIRM_NUM), 0, 1, sum(RS_AFFIRM_NUM)) * 100 as decimal(10, 2)) as varchar(5)) || '%' ORDER_RS_AFFIRM_TIMELY_PERCENT, sum(CUST_AFFIRM_NUM) ORDER_CUST_AFFIRM_NUM, sum(AFFIRM_NUM) ORDER_AFFIRM_NUM, sum(AFFIRM_DEAL_NUM) ORDER_AFFIRM_DEAL_NUM, sum(RS_CHECK_NUM) ORDER_RS_CHECK_NUM, sum(CUST_CHECK_NUM) ORDER_CUST_CHECK_NUM, sum(CHECK_NUM) ORDER_CHECK_NUM, sum(CHECK_DEAL_NUM) ORDER_CHECK_DEAL_NUM from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.create_time, 'YYYY-MM-DD') as OPERATE_DATE, o.create_operator_id as OPERATOR_ID, o.create_operator as OPERATOR_NAME, 1 as CREATE_ORDER_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.create_operator_id=u.sys_user_id where 1=1 and o.create_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-d d hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.accept_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.order_cancel_time, 'YYYY-MM-DD') as OPERATE_DATE, o.order_cancel_operator_id as OPERATOR_ID, o.order_cancel_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 1 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.order_cancel_operator_id=u.sys_user_id where 1=1 and o.order_cancel_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and ( o.accept_org_id=9 or o.handle_org_id=9) union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, case when (o.rs_affirm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIR M_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_affirm_operator_id as OPERATOR_ID, o.cust_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 1 as CUST_AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else 1 end as AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_S EAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_check_operator_id as OPERATOR_ID, o.rs_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 1 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 1 as CHECK_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_check_operator_id as OPERATOR_ID, o.cust_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM , 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 1 as CUST_CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else 1 end as CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 ) t group by OPERATOR_ID, OPERATOR_NAME order by CID)
aq9706bk6j5x5	select DOC_ID, DOC_TYPE, DOC_OWNER, UPDATE_DATE , DOC_DATA from DOCUMENT where DOC_ID = :1
aqjm2pvdxzqwm	select count(*) from (select COLLECT_ORDER_ID, ORG_ID, RESTAURANT_ID, AUTO_MATCH_NUM, OPERATE_TYPE, PROVINCE_CODE, CITY_CODE, DISTRICT_CODE, NAME, BOOK_TEL, ZIP, ADDRESS, INTRODUCE, MINOR_CUISINE, GPS_X, GPS_Y, SUBJECT_WORD, FLAVOUR, CUISINE_FIRST_ID, CUISINE_SECOND_ID, CREATE_TIME, SOURCE, ORIGIN_OPERATE_TYPE, STATUS, ORIGIN_NAME, ORIGIN_BOOK_TEL, ORIGIN_ADDRESS, ORG_PROVINCE_ID, ORG_CITY_ID, PROVINCE_ID, CITY_ID, DISTRICT_ID, NAME_FIRST_PY, ADDRESS_FIRST_PY, SIGN_STATUS, BUSINESS_STATUS, BOOKING_STATUS, PUBLISH_STATUS, NOTE, CHECK_OPERATOR, CHECK_OPERATOR_ID, CHECK_TIME, EXECUTE_OPERATOR, EXECUTE_OPERATOR_ID, EXECUTE_TIME, EXECUTE_RESULT, CUST_ID, ORIGIN_ZIP, ORIGIN_MINOR_CUISINE, ORIGIN_GPS_X, ORIGIN_GPS_Y, CHECK_PROMPT, SUBSCRIPTION_ID, ORIGIN_REGISTER_NAME, REGISTER_NAME, CHANGE_INFO_LOG, DETAIL_FLAG, FAILURE_TIMES, OPERATOR_SOURCE_FLAG, DETAILS_FAILURE_CONTENT, COLLECT_FAILURE_CONTENT from RESTAURANT_COLLECT rc where rc.DETAIL_FLAG=0 and rc.failure_times <= :1 and (rc.OPERATOR_SOURCE_FLAG <> 1 or rc.OPERATOR_SOURCE_FLAG is null) and rc.COLLECT_ORDER_ID > :2 order by rc.COLLECT_ORDER_ID)
aqzrjxr2rgh1w	select count(1) from (SELECT o.order_id, o.cust_name, o.cust_tel, o.restaurant_name, o.order_status, o.vip, o.restaurant_tel, o.book_time, o.book_require, o.assigned_confirmor , o.ORDER_SOURCE, o.BOOK_RESULT, o.DEAL_LEVEL, o.BOOK_PERSON_NUM, o.BOOK_DESK_NUM, o.RESTAURANT_ID, DECODE(o.restaurant_affirm_flag, 1, 'ÊÇ', '') ||'/'|| rs_affirm_operator rs_affirm_dis, DECODE(o.customer_affirm_flag, 1, 'ÊÇ', '') ||'/'|| cust_affirm_operator cs_affirm_dis, (select b.status_name from dic_order_status b where b.status_code=o.order_status) status_name, (select d.source_name from dic_source d where d.source_code=o.order_source) source_name, o.create_operator, o.create_time, decode(deal_level, 1, '¡Ì', '') deal_lev, case when (ol.lock_time+15/1440 < sysdate) then (select u1.full_name from sys_service_center_user u1 where u1.sys_user_id=ol.lock_operator) ||'(³¬)' else (select u1.full_name from sys_service_center_user u1 where u1.sys_user_id=ol.lock_operator) end lockoperator FROM (select a.*, b.restaurant_affirm_flag, b.rs_affirm_operator, b.rs_affirm_time, b.restaurant_affirmer, b.cust_affirm_operator, b.cust_affirm_operator_id, b.rs_affirm_operator_id, b.cust_affirm_time, b.customer_affirm_flag, b.is_deposit, b.reserve_time, b.book_result, b.order_cancel_operator, b.order_cancel_time, b.order_cancel_operator_id, b.order_cancel_reason from ( select * from order_info a where 1=1 AND book_time >= TO_DATE('2013-03-11', 'YYYY-MM-D D')) a left join (select * from order_check b where 1=1 ) b on a.order_id = b.order_id) o LEFT JOIN order_lock ol ON o.order_id = ol.Order_Id WHERE 1=1 AND ( 1=0 OR o.order_status = 1 OR o.order_status = 6 OR o.order_status = 5 ) AND ( 1=0 OR ol.lock_operator = '4145' OR ((ol.order_id IS NULL OR trim(ol.order_id) = '') and (o.ebooking_flag is null or o.ebooking_flag='0' or (o.ebooking_flag='1' and (o.restaurant_affirm_flag is not null or o.create_time<sysdate-5/1440)))) OR ol.lock_time < sysdate-15/1440 ) AND ((1=0) or (o.handle_org_id=9)) AND (1=0 or o.order_process_flag='1' or o.order_process_flag='2')ORDER BY O.VIP DESC, o.deal_level desc, o.create_time )
c1cscqsbrmdak	select orderinfo0_.ORDER_ID as ORDER1_9_2_, orderinfo0_.RESTAURANT_ID as RESTAURANT2_9_2_, orderinfo0_.SP_ID as SP3_9_2_, orderinfo0_.ACCEPT_ORG_ID as ACCEPT4_9_2_, orderinfo0_.ACCEPT_CITY_ORG_ID as ACCEPT5_9_2_, orderinfo0_.HANDLE_ORG_ID as HANDLE6_9_2_, orderinfo0_.HANDLE_CITY_ORG_ID as HANDLE7_9_2_, orderinfo0_.ORDER_SOURCE as ORDER8_9_2_, orderinfo0_.ORDER_PROCESS_FLAG as ORDER9_9_2_, orderinfo0_.CALL_TEL as CALL10_9_2_, orderinfo0_.CARD_NO as CARD11_9_2_, orderinfo0_.CUST_NAME as CUST12_9_2_, orderinfo0_.CUST_TEL as CUST13_9_2_, orderinfo0_.CUST_EMAIL as CUST14_9_2_, orderinfo0_.CUST_ID as CUST15_9_2_, orderinfo0_.SEX as SEX9_2_, orderinfo0_.CHECK_ORDER_MODE as CHECK17_9_2_, orderinfo0_.BOOK_TIME as BOOK18_9_2_, orderinfo0_.BOOK_ENVIRONMENT as BOOK19_9_2_, orderinfo0_.BOOK_PERSON_NUM as BOOK20_9_2_, orderinfo0_.BOOK_DESK_NUM as BOOK21_9_2_, orderinfo0_.BOOK_REQUIRE as BOOK22_9_2_, orderinfo0_.IS_SEND_INVITE as IS23_9_2_, orderinfo0_.DEAL_LEVEL as DEAL24_9_2_, orderinfo0_.CUST_AFFIRM_WAY as CUST25_9_2_, orderinfo0_.DISCOUNT_DESC as DISCOUNT26_9_2_, orderinfo0_.NOTE as NOTE9_2_, orderinfo0_.RESTAURANT_NAME as RESTAURANT28_9_2_, orderinfo0_.RESTAURANT_ADDRESS as RESTAURANT29_9_2_, orderinfo0_.RESTAURANT_TEL as RESTAURANT30_9_2_, orderinfo0_.PROVINCE_ID as PROVINCE31_9_2_, orderinfo0_.CITY_ID as CITY32_9_2_, orderinfo0_.DISTRICT_ID as DISTRICT33_9_2_, orderinfo0_.CUST_FEEDBACK as CUST34_9_2_, orderinfo0_.CREATE_OPERATOR as CREATE35_9_2_, or derinfo0_.CREATE_TIME as CREATE36_9_2_, orderinfo0_.CREATE_OPERATOR_ID as CREATE37_9_2_, orderinfo0_.ASSIGNED_CONFIRMOR as ASSIGNED38_9_2_, orderinfo0_.ASSIGNED_CONFIRMOR_ID as ASSIGNED39_9_2_, orderinfo0_.LOCAL_CARD_NO as LOCAL40_9_2_, orderinfo0_.ORDER_DELIVER_FLAG as ORDER41_9_2_, orderinfo0_.ORIGIN_ORDER_ID as ORIGIN42_9_2_, orderinfo0_.COOPERATION_PARTNER_ID as COOPERA43_9_2_, orderinfo0_.BUSINESS_TYPE as BUSINESS44_9_2_, orderinfo0_.OPERATE_TIME as OPERATE45_9_2_, orderinfo0_.OPERATOR as OPERATOR9_2_, orderinfo0_.OPERATOR_ID as OPERATOR47_9_2_, orderinfo0_.SECOND_BOOK_FLAG as SECOND48_9_2_, orderinfo0_.EBOOKING_FLAG as EBOOKING49_9_2_, orderinfo0_.ORDER_STATUS as ORDER50_9_2_, orderinfo0_.RESTAURANT_FIRST_PY as RESTAURANT51_9_2_, orderinfo0_.IS_CHARGE as IS52_9_2_, orderinfo0_.VIP as VIP9_2_, ordercheck1_.ORDER_ID as ORDER1_88_0_, ordercheck1_.RESTAURANT_AFFIRM_FLAG as RESTAURANT2_88_0_, ordercheck1_.RS_AFFIRM_OPERATOR as RS3_88_0_, ordercheck1_.RS_AFFIRM_TIME as RS4_88_0_, ordercheck1_.RESTAURANT_AFFIRMER as RESTAURANT5_88_0_, ordercheck1_.CUST_AFFIRM_OPERATOR as CUST6_88_0_, ordercheck1_.CUST_AFFIRM_OPERATOR_ID as CUST7_88_0_, ordercheck1_.RS_AFFIRM_OPERATOR_ID as RS8_88_0_, ordercheck1_.CUST_AFFIRM_TIME as CUST9_88_0_, ordercheck1_.CUSTOMER_AFFIRM_FLAG as CUSTOMER10_88_0_, ordercheck1_.IS_DEPOSIT as IS11_88_0_, ordercheck1_.RESERVE_TIME as RESERVE12_88_0_, ordercheck1_.BOOK_RESULT as BOOK13_88_0_, ordercheck1_.ORDER_CANCEL_OPERATOR as O RDER14_88_0_, ordercheck1_.ORDER_CANCEL_TIME as ORDER15_88_0_, ordercheck1_.ORDER_CANCEL_OPERATOR_ID as ORDER16_88_0_, ordercheck1_.ORDER_CANCEL_REASON as ORDER17_88_0_, ordercheck1_.PROVINCE_ID as PROVINCE18_88_0_, orderinfo4x2_.ORDER_ID as ORDER1_89_1_, orderinfo4x2_.BILL_ID as BILL2_89_1_, orderinfo4x2_.RESTAURANT_ID as RESTAURANT3_89_1_, orderinfo4x2_.CUST_CHECK_WAY as CUST4_89_1_, orderinfo4x2_.CHECK_PERSON_NUM as CHECK5_89_1_, orderinfo4x2_.CHECK_DESK_NUM as CHECK6_89_1_, orderinfo4x2_.CHECK_ENVIRONMENT as CHECK7_89_1_, orderinfo4x2_.CHECK_AMOUNT_TOTAL as CHECK8_89_1_, orderinfo4x2_.CHECK_AMOUNT_COMMON as CHECK9_89_1_, orderinfo4x2_.CHECK_AMOUNT_DISCOUNT as CHECK10_89_1_, orderinfo4x2_.CHECK_AMOUNT_SAVE as CHECK11_89_1_, orderinfo4x2_.CHECK_AMOUNT_OTHER as CHECK12_89_1_, orderinfo4x2_.CHECK_POSITION as CHECK13_89_1_, orderinfo4x2_.RESTAURANT_CHECKER as RESTAURANT14_89_1_, orderinfo4x2_.CUST_CHECK_PERSON_NUM as CUST15_89_1_, orderinfo4x2_.CUST_CHECK_DESK_NUM as CUST16_89_1_, orderinfo4x2_.CUST_CHECK_AMOUNT as CUST17_89_1_, orderinfo4x2_.ORIGIN_ORDER_ID as ORIGIN18_89_1_, orderinfo4x2_.RS_CHECK_FLAG as RS19_89_1_, orderinfo4x2_.CHECK_RESULT_DESC as CHECK20_89_1_, orderinfo4x2_.CUST_CHECK_FLAG as CUST21_89_1_, orderinfo4x2_.RS_CHECK_TIME as RS22_89_1_, orderinfo4x2_.RS_CHECK_OPERATOR as RS23_89_1_, orderinfo4x2_.CUST_CHECK_OPERATOR as CUST24_89_1_, orderinfo4x2_.CUST_CHECK_TIME as CUST25_89_1_, orderinfo4x2_.RS_CHECK_OPERATOR_ID as RS26_89_1_, orderinfo4x2_.CUST_CHECK_OPERATOR_ID as CUST27_89_1_, orderinfo4x2_.PROVINCE_ID as PROVINCE28_89_1_ from ORDER_INFO orderinfo0_ left outer join ORDER_CHECK ordercheck1_ on orderinfo0_.ORDER_ID=ordercheck1_.ORDER_ID left outer join ORDER_INFO_4BILL orderinfo4x2_ on orderinfo0_.ORDER_ID=orderinfo4x2_.ORDER_ID where orderinfo0_.ORDER_ID=:1
c642s3tkxswz8	insert into INTERFACE_LOG (RS_INTERFACE_LOG_ID, RESTAURANT_ID, METHOD, NOTE, IP_ADDRESS, OPERATE_TIME, CALLER_ID, SERVICE_NAME, APP_KEY, ORG_ID) values (:1, :2, :3, :4, :5, sysdate, :6, :7, :8, :9)
cqh9dz0xrpqab	select count(1) from (select OPERATOR_ID as CID, OPERATOR_NAME as OPERATOR, sum(CREATE_ORDER_NUM) ORDER_TOTAL_NUM, sum(CREATE_DEAL_NUM) ORDER_CREATE_DEAL_NUM, sum(CANCEL_ORDER_NUM) ORDER_CANCEL_NUM, sum(RS_AFFIRM_NUM) ORDER_RS_AFFIRM_NUM, sum(RS_AFFIRM_TIMELY_NUM) ORDER_RS_AFFIRM_TIMELY_NUM, cast(cast(sum(RS_AFFIRM_TIMELY_NUM) / decode(sum(RS_AFFIRM_NUM), 0, 1, sum(RS_AFFIRM_NUM)) * 100 as decimal(10, 2)) as varchar(5)) || '%' ORDER_RS_AFFIRM_TIMELY_PERCENT, sum(CUST_AFFIRM_NUM) ORDER_CUST_AFFIRM_NUM, sum(AFFIRM_NUM) ORDER_AFFIRM_NUM, sum(AFFIRM_DEAL_NUM) ORDER_AFFIRM_DEAL_NUM, sum(RS_CHECK_NUM) ORDER_RS_CHECK_NUM, sum(CUST_CHECK_NUM) ORDER_CUST_CHECK_NUM, sum(CHECK_NUM) ORDER_CHECK_NUM, sum(CHECK_DEAL_NUM) ORDER_CHECK_DEAL_NUM from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.create_time, 'YYYY-MM-DD') as OPERATE_DATE, o.create_operator_id as OPERATOR_ID, o.create_operator as OPERATOR_NAME, 1 as CREATE_ORDER_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.create_operator_id=u.sys_user_id where 1=1 and o.create_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-d d hh24:mi:ss') and o.create_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.accept_city_org_id=86 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.order_cancel_time, 'YYYY-MM-DD') as OPERATE_DATE, o.order_cancel_operator_id as OPERATOR_ID, o.order_cancel_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 1 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.order_cancel_operator_id=u.sys_user_id where 1=1 and o.order_cancel_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.order_cancel_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and ( o.accept_city_org_id=86 or ( o.handle_org_id=22 and o.handle_city_org_id=86)) union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OP ERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, case when (o.rs_affirm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.rs_affirm_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_affirm_operator_id as OPERATOR_ID, o.cust_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 1 as CUST_AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else 1 end as AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operato r_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.cust_affirm_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_check_operator_id as OPERATOR_ID, o.rs_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 1 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 1 as CHECK_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') a nd o.rs_check_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_check_operator_id as OPERATOR_ID, o.cust_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 1 as CUST_CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else 1 end as CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and o.cust_check_time<=to_date('2013-03-11 23:59:59', 'yyyy-MM-dd hh24:mi:ss') and ((1=0) or (decode(u.org_ province_id, null, o.accept_city_org_id, u.org_city_id)=86)) and o.handle_city_org_id=86 ) t group by OPERATOR_ID, OPERATOR_NAME order by CID)
czm5xw4a1zzt1	select tbl.*, cast(cast(tbl.ORDER_RS_AFFIRM_TIMELY_NUM / decode(tbl.ORDER_RS_AFFIRM_NUM, 0, 1, tbl.ORDER_RS_AFFIRM_NUM) * 100 as decimal(10, 2)) as varchar(5)) || '%' ORDER_RS_AFFIRM_TIMELY_PERCENT from (select (select nvl(sum(CREATE_ORDER_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.create_time, 'YYYY-MM-DD') as OPERATE_DATE, o.create_operator_id as OPERATOR_ID, o.create_operator as OPERATOR_NAME, 1 as CREATE_ORDER_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.create_operator_id=u.sys_user_id where 1=1 and o.create_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.accept_org_id=9) t) order_total_num, (select nvl(sum(CREATE_DEAL_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.create_time, 'YYYY-MM-DD') as OPERATE_DATE, o.create_operator_id as OPERATOR_ID, o.create_operator as OPERATOR_NAME, 1 as CREATE_ORDER_NUM, decode(order _status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.create_operator_id=u.sys_user_id where 1=1 and o.create_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.accept_org_id=9) t) order_create_deal_num, (select nvl(sum(CANCEL_ORDER_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.order_cancel_time, 'YYYY-MM-DD') as OPERATE_DATE, o.order_cancel_operator_id as OPERATOR_ID, o.order_cancel_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 1 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.order_cancel_operator_id=u.sys_user_id where 1=1 and o.order_cancel_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and ( o.accept_org_id=9 or o.handle_org _id=9)) t) order_cancel_num, (select nvl(sum(RS_AFFIRM_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, case when (o.rs_affirm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9) t) order_rs_affirm_num, (select nvl(sum(RS_AFFIRM_TIMELY_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, case when (o.rs_aff irm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9) t) order_rs_affirm_timely_num, (select nvl(sum(CUST_AFFIRM_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_affirm_operator_id as OPERATOR_ID, o.cust_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 1 as CUST_AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else 1 end as AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else deco de(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9) t) order_cust_affirm_num, (select nvl(sum(AFFIRM_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, case when (o.rs_affirm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all s elect nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_affirm_operator_id as OPERATOR_ID, o.cust_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 1 as CUST_AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else 1 end as AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9) t) order_affirm_num, (select nvl(sum(AFFIRM_DEAL_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) O RG_CITY_ID, to_char(o.rs_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_affirm_operator_id as OPERATOR_ID, o.rs_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 1 as RS_AFFIRM_NUM, case when (o.rs_affirm_time - o.create_time) * 24 * 60 <= -1 then 1 else 0 end as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 1 as AFFIRM_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.rs_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_affirm_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_affirm_operator_id as OPERATOR_ID, o.cust_affirm_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 1 as CUST_AFFIRM_NUM, case when cust_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else 1 end as AFFIRM_NUM, case when cu st_affirm_operator_id=rs_affirm_operator_id and cust_affirm_operator=rs_affirm_operator and to_char(o.cust_affirm_time, 'YYYY-MM-DD')=to_char(o.rs_affirm_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 0 as CHECK_NUM, 0 as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_affirm_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9) t) order_affirm_deal_num, (select nvl(sum(RS_CHECK_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_check_operator_id as OPERATOR_ID, o.rs_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 1 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 1 as CHECK_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9) t) order_rs_check_num, (select nvl(sum(CUST_CHECK_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_check_operator_id as OPERATOR_ID, o.cust_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 1 as CUST_CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else 1 end as CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9) t) order_cust_check_num, (select nvl(sum(CHECK_N UM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_check_operator_id as OPERATOR_ID, o.rs_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 1 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 1 as CHECK_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_check_operator_id as OPERATOR_ID, o.cust_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 1 as CUST_CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_op erator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else 1 end as CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9) t) order_check_num, (select nvl(sum(CHECK_DEAL_NUM), 0) from (select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.rs_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.rs_check_operator_id as OPERATOR_ID, o.rs_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 1 as RS_CHECK_NUM, 0 as CUST_CHECK_NUM, 1 as CHECK_NUM, decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.rs_check_time>=to_date('2013 -03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9 union all select nvl(u.org_province_id, o.accept_org_id) ORG_PROVINCE_ID, decode(u.org_province_id, null, o.accept_city_org_id, u.org_city_id) ORG_CITY_ID, to_char(o.cust_check_time, 'YYYY-MM-DD') as OPERATE_DATE, o.cust_check_operator_id as OPERATOR_ID, o.cust_check_operator as OPERATOR_NAME, 0 as CREATE_ORDER_NUM, 0 as CREATE_DEAL_NUM, 0 as CANCEL_ORDER_NUM, 0 as RS_AFFIRM_NUM, 0 as RS_AFFIRM_TIMELY_NUM, 0 as CUST_AFFIRM_NUM, 0 as AFFIRM_NUM, 0 as AFFIRM_DEAL_NUM, 0 as RS_CHECK_NUM, 1 as CUST_CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else 1 end as CHECK_NUM, case when cust_check_operator_id=rs_check_operator_id and cust_check_operator=rs_check_operator and to_char(o.cust_check_time, 'YYYY-MM-DD')=to_char(o.rs_check_time, 'YYYY-MM-DD') then 0 else decode(order_status, 3, decode(rs_check_flag, 1, 1, 0), 0) end as CHECK_DEAL_NUM from REPORT_SEAT_VOLUME o left join sys_service_center_user u on o.cust_affirm_operator_id=u.sys_user_id where 1=1 and o.cust_check_time>=to_date('2013-03-11 00:00:00', 'yyyy-MM-dd hh24:mi:ss') and u.user_group='1' and ((1=0) or (nvl(u.org_province_id, o.accept_org_id)=9)) and o.handle_org_id=9) t) order_check_deal_num from dual) tbl
d084nnf7u2vt8	select SEQ_INTERFACE_LOG.Nextval from dual
d5311xq5wwwjh	SELECT COUNT(1) FROM TEMP_REST TR WHERE (((INSTR(TR.T_NAME, :B3 ) > 0 OR INSTR(:B3 , TR.T_NAME) > 0) AND (INSTR(TR.T_ADDRESS, :B2 ) > 0 OR INSTR(:B2 , TR.T_ADDRESS) > 0)) OR ((INSTR(TR.T_NAME, :B3 ) > 0 OR INSTR(:B3 , TR.T_NAME) > 0) AND (INSTR(TR.T_TEL, :B1 ) > 0 OR INSTR(:B1 , TR.T_TEL) > 0)) OR ((INSTR(TR.T_ADDRESS, :B2 ) > 0 OR INSTR(:B2 , TR.T_ADDRESS) > 0) AND (INSTR(TR.T_TEL, :B1 ) > 0 OR INSTR(:B1 , TR.T_TEL) > 0)))
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dujc578p6dnyz	select restaurant0_.RESTAURANT_ID as RESTAURANT1_10_0_, restaurant0_.ORG_PROVINCE_ID as ORG2_10_0_, restaurant0_.ORG_CITY_ID as ORG3_10_0_, restaurant0_.NAME as NAME10_0_, restaurant0_.ENG_NAME as ENG5_10_0_, restaurant0_.NAME_FIRST_PY as NAME6_10_0_, restaurant0_.ALIAS_NAME as ALIAS7_10_0_, restaurant0_.REGISTER_NAME as REGISTER8_10_0_, restaurant0_.BOOK_TEL as BOOK9_10_0_, restaurant0_.PROVINCE_ID as PROVINCE10_10_0_, restaurant0_.CITY_ID as CITY11_10_0_, restaurant0_.DISTRICT_ID as DISTRICT12_10_0_, restaurant0_.ZIP as ZIP10_0_, restaurant0_.ADDRESS as ADDRESS10_0_, restaurant0_.ADDRESS_FIRST_PY as ADDRESS15_10_0_, restaurant0_.CROSS_ROAD as CROSS16_10_0_, restaurant0_.BUSINESS_AREA_ID as BUSINESS17_10_0_, restaurant0_.LANDMARK as LANDMARK10_0_, restaurant0_.TRAFFIC_ROUTE as TRAFFIC19_10_0_, restaurant0_.GPS_X as GPS20_10_0_, restaurant0_.GPS_Y as GPS21_10_0_, restaurant0_.FAX as FAX10_0_, restaurant0_.WEBSITE as WEBSITE10_0_, restaurant0_.EMAIL as EMAIL10_0_, restaurant0_.INTRODUCE as INTRODUCE10_0_, restaurant0_.BUSINESS_TIME as BUSINESS26_10_0_, restaurant0_.SIGN_STATUS as SIGN27_10_0_, restaurant0_.BUSINESS_STATUS as BUSINESS28_10_0_, restaurant0_.CONTRACT_ID as CONTRACT29_10_0_, restaurant0_.LOW_AVG_COST as LOW30_10_0_, restaurant0_.HIGH_AVG_COST as HIGH31_10_0_, restaurant0_.SUIT_TYPE as SUIT32_10_0_, restaurant0_.FLAVOUR as FLAVOUR10_0_, restaurant0_.CUISINE_FIRST_ID as CUISINE34_10_0_, restaurant0_.CUISINE_SECOND_ID as CUISINE35_10 _0_, restaurant0_.MINOR_CUISINE as MINOR36_10_0_, restaurant0_.SPECIALTY as SPECIALTY10_0_, restaurant0_.IS_RESERVE_ROOM as IS38_10_0_, restaurant0_.RESERVE_ROOM_NUM as RESERVE39_10_0_, restaurant0_.RESERVE_ROOM_DESC as RESERVE40_10_0_, restaurant0_.MIN_CHARGE_DESC as MIN41_10_0_, restaurant0_.IS_SERVICE_CHARGE as IS42_10_0_, restaurant0_.SERVICE_CHARGE_DESC as SERVICE43_10_0_, restaurant0_.IS_SUPPORT_CARD as IS44_10_0_, restaurant0_.CARD_DESC as CARD45_10_0_, restaurant0_.TOTAL_SEAT_NUM as TOTAL46_10_0_, restaurant0_.TOTAL_DESK_NUM as TOTAL47_10_0_, restaurant0_.HALL_SEAT_NUM as HALL48_10_0_, restaurant0_.HALL_DESK_NUM as HALL49_10_0_, restaurant0_.BUSINESS_ACREAGE as BUSINESS50_10_0_, restaurant0_.IS_PARKING as IS51_10_0_, restaurant0_.PARKING_DESC as PARKING52_10_0_, restaurant0_.TAKEOUT_SERVICE as TAKEOUT53_10_0_, restaurant0_.FACILITY as FACILITY10_0_, restaurant0_.SERVICE as SERVICE10_0_, restaurant0_.ENVIRONMENT as ENVIRON56_10_0_, restaurant0_.RECOMMEND_VALUE as RECOMMEND57_10_0_, restaurant0_.SP_FOLLOWER as SP58_10_0_, restaurant0_.SP_FOLLOWER_TEL as SP59_10_0_, restaurant0_.REPRESENT as REPRESENT10_0_, restaurant0_.REPRESENT_TEL as REPRESENT61_10_0_, restaurant0_.FINANCE_NAME as FINANCE62_10_0_, restaurant0_.FINANCE_TEL as FINANCE63_10_0_, restaurant0_.FINANCE_FAX as FINANCE64_10_0_, restaurant0_.FINANCE_EMAIL as FINANCE65_10_0_, restaurant0_.BILL_POST_ADDRESS as BILL66_10_0_, restaurant0_.BILL_POST_ZIP as BILL67_10_0_, restaurant0_. DEPOSIT_RULE as DEPOSIT68_10_0_, restaurant0_.RETAIN_TIME as RETAIN69_10_0_, restaurant0_.ORDER_CHECKER as ORDER70_10_0_, restaurant0_.ORDER_CHECK_TEL as ORDER71_10_0_, restaurant0_.ORDER_CHECK_ATTENTION as ORDER72_10_0_, restaurant0_.CUST_CHECK_WAY as CUST73_10_0_, restaurant0_.NOTE as NOTE10_0_, restaurant0_.CREATE_OPERATOR as CREATE75_10_0_, restaurant0_.CREATE_TIME as CREATE76_10_0_, restaurant0_.OPERATOR as OPERATOR10_0_, restaurant0_.OPERATE_TIME as OPERATE78_10_0_, restaurant0_.ORG_ID as ORG79_10_0_, restaurant0_.BOOKING_STATUS as BOOKING80_10_0_, restaurant0_.CARD_CONSUME as CARD81_10_0_, restaurant0_.IS_TAKEOUT as IS82_10_0_, restaurant0_.BOOK_REQUIREMENT as BOOK83_10_0_, restaurant0_.IMAGE_ABBR_ID as IMAGE84_10_0_, restaurant0_.IMAGE_FULL_ID as IMAGE85_10_0_, restaurant0_.LOCAL_ID as LOCAL86_10_0_, restaurant0_.REALTIME_SERVICE_FLAG as REALTIME87_10_0_, restaurant0_.REALTIME_INTERFACE_ID as REALTIME88_10_0_, restaurant0_.CHECK_BILL_DATE as CHECK89_10_0_, restaurant0_.BILL_POST_WAY as BILL90_10_0_, restaurant0_.INVOICE_HEADING as INVOICE91_10_0_, restaurant0_.INVOICE_POST_ADDR as INVOICE92_10_0_, restaurant0_.INVOICE_CONSIGNEE as INVOICE93_10_0_, restaurant0_.INVOCIE_POST_CODE as INVOCIE94_10_0_, restaurant0_.PASSWORD as PASSWORD10_0_, restaurant0_.CREATE_OPERATOR_ID as CREATE96_10_0_, restaurant0_.OPERATOR_ID as OPERATOR97_10_0_, restaurant0_.SOURCE as SOURCE10_0_, restaurant0_.CHECK_ORDER_MODE as CHECK99_10_0_, restaurant0_.KEY_WORD as KEY100_10_0_, restaurant0_.PUBLISH_STATUS as PUBLISH101_10_0_, restaurant0_.DISCOUNT as DISCOUNT10_0_, restaurant0_.VIP_DISCOUNT as VIP103_10_0_, restaurant0_.DISCOUNT_DESC as DISCOUNT104_10_0_, restaurant0_.CUST_ID as CUST105_10_0_, restaurant0_.BILL_CONSIGNEE as BILL106_10_0_, restaurant0_.JIAMENG_APPLY_SIGN as JIAMENG107_10_0_, restaurant0_.RECOMMEND_STATUS as RECOMMEND108_10_0_, restaurant0_.HOT as HOT10_0_, restaurant0_.REDFLAG_GIS_SPACE as REDFLAG110_10_0_, restaurant0_.CHECK_SEAT_FLAG as CHECK111_10_0_, restaurant0_.KOUBEI_RS_FLAG as KOUBEI112_10_0_, restaurant0_.BOOK_SUCCESS_SMS as BOOK113_10_0_, restaurant0_.CONSUME_SUCCESS_SMS as CONSUME114_10_0_, restaurant0_.EBOOKING_FLAG as EBOOKING115_10_0_ from RESTAURANT restaurant0_ where restaurant0_.RESTAURANT_ID=:1
f0ymgsxng2v5k	select x.* from (select rownum x_rownum, o.* from (select COLLECT_ORDER_ID, ORG_ID, RESTAURANT_ID, AUTO_MATCH_NUM, OPERATE_TYPE, PROVINCE_CODE, CITY_CODE, DISTRICT_CODE, NAME, BOOK_TEL, ZIP, ADDRESS, INTRODUCE, MINOR_CUISINE, GPS_X, GPS_Y, SUBJECT_WORD, FLAVOUR, CUISINE_FIRST_ID, CUISINE_SECOND_ID, CREATE_TIME, SOURCE, ORIGIN_OPERATE_TYPE, STATUS, ORIGIN_NAME, ORIGIN_BOOK_TEL, ORIGIN_ADDRESS, ORG_PROVINCE_ID, ORG_CITY_ID, PROVINCE_ID, CITY_ID, DISTRICT_ID, NAME_FIRST_PY, ADDRESS_FIRST_PY, SIGN_STATUS, BUSINESS_STATUS, BOOKING_STATUS, PUBLISH_STATUS, NOTE, CHECK_OPERATOR, CHECK_OPERATOR_ID, CHECK_TIME, EXECUTE_OPERATOR, EXECUTE_OPERATOR_ID, EXECUTE_TIME, EXECUTE_RESULT, CUST_ID, ORIGIN_ZIP, ORIGIN_MINOR_CUISINE, ORIGIN_GPS_X, ORIGIN_GPS_Y, CHECK_PROMPT, SUBSCRIPTION_ID, ORIGIN_REGISTER_NAME, REGISTER_NAME, CHANGE_INFO_LOG, DETAIL_FLAG, FAILURE_TIMES, OPERATOR_SOURCE_FLAG, DETAILS_FAILURE_CONTENT, COLLECT_FAILURE_CONTENT from RESTAURANT_COLLECT rc where rc.DETAIL_FLAG=0 and rc.failure_times <= :1 and (rc.OPERATOR_SOURCE_FLAG <> 1 or rc.OPERATOR_SOURCE_FLAG is null) and rc.COLLECT_ORDER_ID > :2 order by rc.COLLECT_ORDER_ID) o) x where x_rownum>=1 and x_rownum<=100 order by x.x_rownum
fdxbf238fy7yc	select count(1) from (SELECT o.order_id, o.cust_name, o.cust_tel, o.restaurant_name, o.order_status, o.vip, o.restaurant_tel, o.book_time, o.book_require, o.assigned_confirmor , o.ORDER_SOURCE, o.BOOK_RESULT, o.DEAL_LEVEL, o.BOOK_PERSON_NUM, o.BOOK_DESK_NUM, o.RESTAURANT_ID, DECODE(o.restaurant_affirm_flag, 1, 'ÊÇ', '') ||'/'|| rs_affirm_operator rs_affirm_dis, DECODE(o.customer_affirm_flag, 1, 'ÊÇ', '') ||'/'|| cust_affirm_operator cs_affirm_dis, (select b.status_name from dic_order_status b where b.status_code=o.order_status) status_name, (select d.source_name from dic_source d where d.source_code=o.order_source) source_name, o.create_operator, o.create_time, decode(deal_level, 1, '¡Ì', '') deal_lev, case when (ol.lock_time+15/1440 < sysdate) then (select u1.full_name from sys_service_center_user u1 where u1.sys_user_id=ol.lock_operator) ||'(³¬)' else (select u1.full_name from sys_service_center_user u1 where u1.sys_user_id=ol.lock_operator) end lockoperator FROM (select a.*, b.restaurant_affirm_flag, b.rs_affirm_operator, b.rs_affirm_time, b.restaurant_affirmer, b.cust_affirm_operator, b.cust_affirm_operator_id, b.rs_affirm_operator_id, b.cust_affirm_time, b.customer_affirm_flag, b.is_deposit, b.reserve_time, b.book_result, b.order_cancel_operator, b.order_cancel_time, b.order_cancel_operator_id, b.order_cancel_reason from ( select * from order_info a where 1=1 AND book_time >= TO_DATE('2013-03-11', 'YYYY-MM-D D')) a left join (select * from order_check b where 1=1 ) b on a.order_id = b.order_id) o LEFT JOIN order_lock ol ON o.order_id = ol.Order_Id WHERE 1=1 AND ( 1=0 OR o.order_status = 1 OR o.order_status = 6 OR o.order_status = 5 ) AND ((1=0) or (o.handle_city_org_id=12)) AND (1=0 or o.order_process_flag='1' or o.order_process_flag='2')ORDER BY O.VIP DESC, o.deal_level desc, o.create_time )
fh5q7b445q8zs	select contract0_.CONTRACT_ID as CONTRACT1_11_0_, contract0_.RESTAURANT_ID as RESTAURANT2_11_0_, contract0_.SP_ID as SP3_11_0_, contract0_.CONTRACT_CODE as CONTRACT4_11_0_, contract0_.EFFECT_DATE as EFFECT5_11_0_, contract0_.EXPIRE_DATE as EXPIRE6_11_0_, contract0_.CONTRACT_STATUS as CONTRACT7_11_0_, contract0_.RESTAURANT_NAME as RESTAURANT8_11_0_, contract0_.SETTLE_WAY_CODE as SETTLE9_11_0_, contract0_.COMMISSION_RATE_COMMON as COMMISSION10_11_0_, contract0_.COMMISSION_RATE_SAVE as COMMISSION11_11_0_, contract0_.COMMISSION_RATE_DISCOUNT as COMMISSION12_11_0_, contract0_.COMMISSION_RATE_OTHER as COMMISSION13_11_0_, contract0_.COMMISSION_FIX as COMMISSION14_11_0_, contract0_.COMMISSION_FORMULA as COMMISSION15_11_0_, contract0_.COMMISSION_UPPER as COMMISSION16_11_0_, contract0_.ORG_SIGNER as ORG17_11_0_, contract0_.RESTAURANT_SIGNER as RESTAURANT18_11_0_, contract0_.NOTE as NOTE11_0_, contract0_.CREATE_OPERATOR as CREATE20_11_0_, contract0_.CREATE_TIME as CREATE21_11_0_, contract0_.OPERATOR as OPERATOR11_0_, contract0_.OPERATE_TIME as OPERATE23_11_0_, contract0_.PAYMENT_CODE as PAYMENT24_11_0_, contract0_.BANK_ACCOUNT as BANK25_11_0_, contract0_.BANK_NAME as BANK26_11_0_, contract0_.ACCOUNT_NAME as ACCOUNT27_11_0_, contract0_.ACCOUNT_TEL as ACCOUNT28_11_0_, contract0_.RESTAURANT_SIGNER_TEL as RESTAURANT29_11_0_, contract0_.ORG_SIGNER_TEL as ORG30_11_0_, contract0_.ACCOUNT_TEL_OWNER as ACCOUNT31_11_0_, contract0_.CHARGE_TYPE as CHARGE32_11_0_, con tract0_.SETTLE_WAY_DESC as SETTLE33_11_0_, contract0_.IS_AUTO_CALCULATE as IS34_11_0_, contract0_.CALCULATE_TYPE as CALCULATE35_11_0_, contract0_.LEVEL_TYPE as LEVEL36_11_0_, contract0_.LEVEL_NUM as LEVEL37_11_0_, contract0_.LEVEL1 as LEVEL38_11_0_, contract0_.VALUE1 as VALUE39_11_0_, contract0_.LEVEL2 as LEVEL40_11_0_, contract0_.VALUE2 as VALUE41_11_0_, contract0_.LEVEL3 as LEVEL42_11_0_, contract0_.VALUE3 as VALUE43_11_0_, contract0_.LEVEL4 as LEVEL44_11_0_, contract0_.VALUE4 as VALUE45_11_0_, contract0_.LEVEL5 as LEVEL46_11_0_, contract0_.VALUE5 as VALUE47_11_0_, contract0_.LEVEL_CALCULATE_TYPE as LEVEL48_11_0_, contract0_.CREATE_OPERATOR_ID as CREATE49_11_0_, contract0_.OPERATOR_ID as OPERATOR50_11_0_, contract0_.BOX_LEVEL1 as BOX51_11_0_, contract0_.BOX_VALUE1 as BOX52_11_0_, contract0_.BOX_LEVEL2 as BOX53_11_0_, contract0_.BOX_VALUE2 as BOX54_11_0_, contract0_.BOX_LEVEL3 as BOX55_11_0_, contract0_.BOX_VALUE3 as BOX56_11_0_, contract0_.BOX_LEVEL4 as BOX57_11_0_, contract0_.BOX_VALUE4 as BOX58_11_0_, contract0_.BOX_LEVEL5 as BOX59_11_0_, contract0_.BOX_VALUE5 as BOX60_11_0_, contract0_.BOX_COMMISSION_FIX as BOX61_11_0_, contract0_.BOX_COMMISSION_FLAG as BOX62_11_0_, contract0_.BILL_MONTH_TYPE as BILL63_11_0_, contract0_.MONTH_BASE_FEE as MONTH64_11_0_, contract0_.MONTH_BASE_VALUE as MONTH65_11_0_, contract0_.MONTH_BASE_BOX_VALUE as MONTH66_11_0_ from CONTRACT contract0_ where contract0_.CONTRACT_ID=:1
gpp5bnnfdr9p0	insert into shortmessage_log(sm_log_id, send_device, receive_device, sm_content, sm_type_code, send_time, send_way, status, order_id, service_center_id) values(seq_shortmessage_log.nextval, :1, :2, :3, :4, :5, :6, :7, :8, :9)

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

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

• Tablespace IO Stats
• File IO Stats

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

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

Back to Top

Advisory Statistics

• Instance Recovery Stats
• 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

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

• B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
• Auto PGA Target - actual workarea memory target
• W/A PGA Used - amount of memory used for all Workareas (manual + auto)
• %PGA W/A Mem - percentage of PGA memory allocated to workareas
• %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
• %Man W/A Mem - percentage of workarea memory under manual control

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Back to Advisory Statistics
Back to Top

SGA Target Advisory

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Back to Wait Statistics
Back to Top

Enqueue Activity

• only enqueues with waits are shown
• Enqueue stats gathered prior to 10g should not be compared with 10g data
• ordered by Wait Time desc, Waits desc

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

• Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
• STO - Snapshot Too Old count, OOS - Out of Space count
• Undo segment block stats:
• uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
• eS - expired Stolen, eR - expired Released, eU - expired reUsed

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

Back to Undo Statistics
Back to Top

Latch Statistics

• Latch Activity
• Latch Sleep Breakdown
• Latch Miss Sources
• Parent Latch Statistics
• Child Latch Statistics

Latch Activity

• "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
• "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
• "Pct Misses" for both should be very close to 0.0