WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release Cluster Host
VIS 127695557 VIS 1 10.1.0.5.0 NO db0

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 54 22-May-06 12:19:49 2664 179.0
End Snap: 55 22-May-06 13:21:55 2693 233.3
Elapsed:   62.10 (mins)    
DB Time:   589.07 (mins)    

 

Report Summary

Cache Sizes (end)

Buffer Cache: 7,168M Std Block Size: 8K
Shared Pool Size: 3,072M Log Buffer: 16,384K

Load Profile

  Per Second Per Transaction
Redo size: 7,759,280.29 37,014.48
Logical reads: 476,323.34 2,272.23
Block changes: 47,706.99 227.58
Physical reads: 230.26 1.10
Physical writes: 685.99 3.27
User calls: 6,595.47 31.46
Parses: 1,739.46 8.30
Hard parses: 1.78 0.01
Sorts: 2,331.00 11.12
Logons: 1.47 0.01
Executes: 17,747.41 84.66
Transactions: 209.63  

% Blocks changed per Read: 10.02 Recursive Call %: 82.03
Rollback per transaction %: 17.11 Rows per Sort: 22.23

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96 Redo NoWait %: 100.00
Buffer Hit %: 99.96 In-memory Sort %: 100.00
Library Hit %: 99.99 Soft Parse %: 99.90
Execute to Parse %: 90.20 Latch Hit %: 98.37
Parse CPU to Parse Elapsd %: 54.05 % Non-Parse CPU: 97.75

Shared Pool Statistics

  Begin End
Memory Usage %: 57.00 76.82
% SQL with executions>1: 70.09 83.18
% Memory for SQL w/exec>1: 77.25 64.59

Top 5 Timed Events

Event Waits Time(s) Percent Total DB Time Wait Class
CPU time   20,727 58.64  
db file sequential read 649,344 2,619 7.41 User I/O
latch: cache buffers chains 92,795 939 2.66 Concurrency
log file parallel write 1,130,141 724 2.05 System I/O
log file sync 261,302 666 1.88 Commit

Main Report


Back to Top

Wait Events Statistics

Back to Top

Wait Events

Event Waits Timeouts Total Wait Time (s) Avg wait (ms) Waits /txn
db file sequential read 649,344 0 2,619 4 0.83
latch: cache buffers chains 92,795 92,795 939 10 0.12
log file parallel write 1,130,141 0 724 1 1.45
log file sync 261,302 0 666 3 0.33
enq: UL - contention 3,511 33 390 111 0.00
enq: TX - row lock contention 688 116 365 531 0.00
db file parallel write 198,983 0 300 2 0.25
read by other session 92,073 0 129 1 0.12
buffer busy waits 566,150 3 97 0 0.72
library cache pin 4,105 0 83 20 0.01
SQL*Net more data from client 1,333,912 0 67 0 1.71
db file scattered read 19,471 0 53 3 0.02
enq: TX - index contention 14,305 0 52 4 0.02
rdbms ipc reply 18,949 5 38 2 0.02
library cache load lock 928 0 32 34 0.00
latch: undo global data 4,153 0 29 7 0.01
latch: In memory undo latch 4,002 0 29 7 0.01
SQL*Net more data to client 1,313,890 0 23 0 1.68
SQL*Net message to client 25,594,967 0 17 0 32.77
direct path read temp 9,852 0 16 2 0.01
latch free 1,214 1,175 13 11 0.00
SQL*Net break/reset to client 39,644 0 11 0 0.05
control file parallel write 1,654 0 6 4 0.00
local write wait 885 0 5 6 0.00
latch: library cache 3,070 0 5 2 0.00
direct path write temp 3,200 0 5 1 0.00
enq: HW - contention 2,889 0 4 1 0.00
enq: RO - fast object reuse 36 0 4 111 0.00
control file sequential read 928 0 4 4 0.00
library cache lock 102 0 4 36 0.00
LGWR wait for redo copy 34,201 12 4 0 0.04
PX Deq Credit: send blkd 3,954 0 3 1 0.01
enq: DV - contention 181 0 3 16 0.00
enq: TX - contention 2,806 0 3 1 0.00
enq: TM - contention 3 0 3 838 0.00
enq: SQ - contention 4,588 0 2 0 0.01
enq: CI - contention 741 0 1 2 0.00
latch: library cache pin 460 0 1 2 0.00
PX Deq: Signal ACK 94 31 1 12 0.00
row cache lock 1,213 0 1 1 0.00
latch: redo allocation 279 0 1 3 0.00
control file single write 135 0 1 6 0.00
process startup 17 0 0 26 0.00
enq: CU - contention 33 0 0 11 0.00
log file switch completion 23 0 0 13 0.00
PX qref latch 14 14 0 15 0.00
enq: TX - allocate ITL entry 303 0 0 1 0.00
enq: FB - contention 1,103 0 0 0 0.00
latch: cache buffers lru chain 62 0 0 3 0.00
latch: row cache objects 36 0 0 4 0.00
latch: cache buffer handles 50 0 0 2 0.00
direct path read 420 0 0 0 0.00
undo segment extension 11,451 11,418 0 0 0.01
latch: session allocation 33 0 0 1 0.00
buffer deadlock 5,931 5,913 0 0 0.01
latch: library cache lock 16 0 0 2 0.00
direct path write 2,238 0 0 0 0.00
latch: object queue header operation 11 0 0 2 0.00
enq: PS - contention 14 0 0 1 0.00
db file parallel read 2 0 0 8 0.00
latch: shared pool 14 0 0 1 0.00
latch: redo writing 6 0 0 1 0.00
log file sequential read 2 0 0 3 0.00
log file single write 2 0 0 0 0.00
latch: checkpoint queue latch 1 0 0 0 0.00
latch: enqueue hash chains 1 0 0 0 0.00
PX Deq: Table Q qref 1 0 0 0 0.00
SQL*Net message from client 25,594,986 0 5,644,352 221 32.77
queue messages 6,628 6,153 41,515 6,264 0.01
pipe get 14,325 5,365 21,821 1,523 0.02
PL/SQL lock timer 699 699 7,871 11,260 0.00
PX Idle Wait 2,566 2,427 4,774 1,861 0.00
Queue Monitor Wait 124 124 3,626 29,245 0.00
wakeup time manager 1,262 671 3,085 2,444 0.00
PX Deq: Execution Msg 5,152 16 68 13 0.01
jobq slave wait 22 21 63 2,886 0.00
PX Deq: Execute Reply 3,867 1 13 3 0.00
PX Deq: Msg Fragment 931 0 1 1 0.00
PX Deq: Table Q Normal 1,745 0 1 0 0.00
PX Deq Credit: need buffer 579 0 0 1 0.00
PX Deq: Parse Reply 90 0 0 2 0.00
PX Deq: Table Q Sample 37 0 0 2 0.00
PX Deq: Join ACK 97 0 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits Timeouts Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 1,130,091 0 724 1 1.45
db file parallel write 198,983 0 300 2 0.25
control file parallel write 1,655 0 6 4 0.00
db file scattered read 2,130 0 6 3 0.00
control file sequential read 700 0 4 5 0.00
LGWR wait for redo copy 34,201 12 4 0 0.04
rdbms ipc reply 7,857 0 1 0 0.01
db file sequential read 813 0 1 1 0.00
latch: cache buffers chains 97 97 1 11 0.00
control file single write 135 0 1 6 0.00
latch free 67 66 1 10 0.00
enq: CI - contention 24 0 0 12 0.00
latch: redo allocation 139 0 0 2 0.00
buffer busy waits 530 0 0 0 0.00
latch: library cache 124 0 0 1 0.00
direct path read 420 0 0 0 0.00
latch: cache buffers lru chain 28 0 0 2 0.00
direct path write 220 0 0 0 0.00
process startup 1 0 0 26 0.00
latch: library cache pin 7 0 0 2 0.00
latch: redo writing 6 0 0 1 0.00
log file sequential read 2 0 0 3 0.00
latch: undo global data 5 0 0 1 0.00
latch: session allocation 5 0 0 1 0.00
latch: shared pool 3 0 0 1 0.00
latch: library cache lock 1 0 0 2 0.00
latch: In memory undo latch 2 0 0 1 0.00
log file single write 2 0 0 0 0.00
undo segment extension 385 385 0 0 0.00
latch: object queue header operation 2 0 0 0 0.00
latch: checkpoint queue latch 1 0 0 0 0.00
rdbms ipc message 584,126 9,818 27,215 47 0.75
Queue Monitor Wait 124 124 3,626 29,245 0.00
smon timer 37,115 0 3,610 97 0.05
wakeup time manager 1,262 671 3,085 2,444 0.00

Back to Wait Events Statistics
Back to Top

Time Model Statistics

Statistic Name Time (seconds) % Total DB Time
DB time 35,344.36 100.00
sql execute elapsed time 31,584.90 89.36
DB CPU 20,726.73 58.64
PL/SQL execution elapsed time 6,461.14 18.28
inbound PL/SQL rpc elapsed time 4,334.54 12.26
Java execution elapsed time 2,291.88 6.48
background elapsed time 1,735.81 4.91
parse time elapsed 825.85 2.34
hard parse elapsed time 554.07 1.57
background cpu time 473.68 1.34
sequence load elapsed time 17.91 0.05
connection management call elapsed time 9.87 0.03
PL/SQL compilation elapsed time 8.12 0.02
failed parse elapsed time 2.59 0.01
hard parse (bind mismatch) elapsed time 2.09 0.01
hard parse (sharing criteria) elapsed time 2.09 0.01
failed parse (out of shared memory) elapsed t 0.00 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Name Value
AVG_BUSY_TICKS 3,636,607
AVG_IDLE_TICKS 176,660
AVG_IN_BYTES 75,264
AVG_IOWAIT_TICKS 10,613
AVG_OUT_BYTES 896,768
AVG_SYS_TICKS 11,699
AVG_USER_TICKS 183,880
BUSY_TICKS 58,187,535
IDLE_TICKS 2,828,374
IN_BYTES 1,204,224
IOWAIT_TICKS 171,707
OS_CPU_WAIT_TIME 3,366,700
OUT_BYTES 14,348,288
RSRC_MGR_CPU_WAIT_TIME 0
SYS_TICKS 188,919
USER_TICKS 2,943,877

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
VIS 28,659.90 16,741.80 383,227 1,642,978,149
SYS$USERS 6,683.00 3,984.10 457,235 118,154,527
SYS$BACKGROUND 0.00 0.00 17,764 13,687,811

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
VIS 406,616 114,355 681,758 122,036 0 0 12,783,308 9,045
SYS$USERS 367,792 167,594 4,627 2,093 0 0 15,449,697 1,685
SYS$BACKGROUND 3,583 742 761 125 0 0 0 0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
4,659 2,705 8 582.33 13.18 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
2,921 1,754 10 292.07 8.26 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
2,494 1,081 268 9.30 7.06 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,289 762 10 128.95 3.65 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,280 616 8 160.02 3.62 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
1,102 558 49,985 0.02 3.12 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
871 675 8 108.94 2.47 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
655 566 153,427 0.00 1.85 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
622 418 53,437 0.01 1.76 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
545 12 1,157 0.47 1.54 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
509 71 1,157 0.44 1.44 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
460 262 8 57.46 1.30 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
438 217 8 54.75 1.24 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
411 315 161,243 0.00 1.16 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
394 299 161,299 0.00 1.11 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
393 311 5,000 0.08 1.11 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
389 284 8 48.64 1.10 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
382 109 161,282 0.00 1.08 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
378 67 16 23.64 1.07 944u2vd2tkmff ARGLTP select 'lock' from ra_cust_tr...
373 317 53,964 0.01 1.06 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
358 168 8 44.81 1.01 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
2,705 4,659 8 338.19 13.18 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
1,754 2,921 10 175.42 8.26 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,081 2,494 268 4.03 7.06 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
762 1,289 10 76.20 3.65 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
675 871 8 84.35 2.47 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
616 1,280 8 77.00 3.62 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
566 655 153,427 0.00 1.85 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
558 1,102 49,985 0.01 3.12 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
418 622 53,437 0.01 1.76 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
317 373 53,964 0.01 1.06 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
315 411 161,243 0.00 1.16 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
311 393 5,000 0.06 1.11 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
299 394 161,299 0.00 1.11 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
284 389 8 35.55 1.10 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
262 460 8 32.76 1.30 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
217 438 8 27.06 1.24 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
168 358 8 21.00 1.01 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
109 382 161,282 0.00 1.08 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
71 509 1,157 0.06 1.44 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
67 378 16 4.20 1.07 944u2vd2tkmff ARGLTP select 'lock' from ra_cust_tr...
12 545 1,157 0.01 1.54 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
248,579,773 8 31,072,471.63 14.01 2,705.49 4,658.60 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
174,382,049 8 21,797,756.13 9.83 615.96 1,280.20 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
169,694,966 10 16,969,496.60 9.56 1,754.16 2,920.73 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
166,578,090 49,985 3,332.56 9.39 557.86 1,102.24 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
104,066,814 8 13,008,351.75 5.86 674.78 871.50 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
99,256,038 153,427 646.93 5.59 566.02 654.90 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
86,910,649 10 8,691,064.90 4.90 762.02 1,289.46 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
59,935,359 8 7,491,919.88 3.38 216.50 438.02 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
49,945,335 8 6,243,166.88 2.81 168.00 358.45 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
46,382,835 8 5,797,854.38 2.61 284.37 389.09 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
46,155,034 268 172,220.28 2.60 1,080.83 2,493.71 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
38,957,413 161,299 241.52 2.19 298.87 393.73 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
38,943,332 161,243 241.52 2.19 315.06 411.32 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
38,783,229 53,437 725.77 2.19 417.89 622.05 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
38,487,710 71 542,080.42 2.17 136.64 201.28 3n8tvc1tsqua0 WSHINTERFACES SELECT DISTINCT WTS.STOP_ID FR...
35,525,770 5,000 7,105.15 2.00 311.05 393.43 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
34,785,669 984 35,351.29 1.96 149.51 218.90 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
33,237,712 8 4,154,714.00 1.87 189.10 263.72 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
32,309,685 48 673,118.44 1.82 161.82 313.38 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
26,371,452 10,000 2,637.15 1.49 116.05 330.47 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
25,794,108 1,500 17,196.07 1.45 151.17 226.98 4adc1zhg5cmx0 WSHINTERFACE UPDATE WSH_DELIVERY_DETAILS DD...
20,057,413 1,241,282 16.16 1.13 162.83 196.50 66tmsr3446uqn   SELECT WIAS.ACTIVITY_STATUS, ...
18,416,701 40,805 451.33 1.04 244.73 273.46 64z4pgdwwm6g2 WSHINTERFACE SELECT STOP_ID FROM WSH_TRIP_S...
18,086,038 8 2,260,754.75 1.02 262.05 459.67 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
126,743 1,157 109.54 14.77 11.78 545.27 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
88,934 1,157 76.87 10.37 70.76 509.49 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
54,462 10,000 5.45 6.35 116.05 330.47 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
49,452 1,994 24.80 5.76 7.61 225.46 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
10,907 10 1,090.70 1.27 1,754.16 2,920.73 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
9,554 1 9,554.00 1.11 29.72 37.50 gczkkgwgkyjh3 SQL*Plus select /*+ parallel(t, 8) para...
9,122 204,964 0.04 1.06 52.53 102.37 ccprbqfuu8wb1 WSHINTERFACE SELECT NUMBER_VALUE FROM WF_IT...
3,415 8 426.88 0.40 284.37 389.09 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
2,854 8 356.75 0.33 189.10 263.72 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
2,386 16 149.13 0.28 67.25 378.29 944u2vd2tkmff ARGLTP select 'lock' from ra_cust_tr...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
1,241,282 644,472 0.52 0.00 0.00 66tmsr3446uqn   SELECT WIAS.ACTIVITY_STATUS, ...
712,987 712,347 1.00 0.00 0.00 cd9mbmqyf4qhp   UPDATE WF_ITEM_ACTIVITY_STATUS...
662,478 661,293 1.00 0.00 0.00 gnhmcahkmrnzs hxc.selfservice.timecard.server.TimecardAM INSERT INTO WF_ITEM_ACTIVITY_S...
646,521 646,521 1.00 0.00 0.00 cgb6kp2umq52a   select t.schema, t.name, t.f...
646,282 646,282 1.00 0.00 0.00 8bsm049u7thjd   select min(next_date) from "AP...
403,976 404,046 1.00 0.00 0.00 821fx90awyvj7 OEXOETEL SELECT ACCOUNTING_RULE_ID , A...
294,415 294,407 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
204,964 204,412 1.00 0.00 0.00 ccprbqfuu8wb1 WSHINTERFACE SELECT NUMBER_VALUE FROM WF_IT...
198,122 158,137 0.80 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
191,528 191,391 1.00 0.00 0.00 9bbak9qpg1c7x hxc.selfservice.timecard.server.TimecardAM INSERT INTO WF_ITEM_ATTRIBUTE_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
646,521 646,521 9.97 cgb6kp2umq52a   select t.schema, t.name, t.f...
646,282 1,013 9.97 20rc3cmapyvnz   select q_name, state, delay,...
646,282 646,282 9.97 8bsm049u7thjd   select min(next_date) from "AP...
294,432 294,415 4.54 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
198,219 198,122 3.06 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
161,250 161,282 2.49 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
107,904 107,907 1.66 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
79,572 79,678 1.23 76sw2a4vnc89j ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.S...
76,700 76,861 1.18 608c0n36kaw62 ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.C...
76,693 76,741 1.18 bf7uwg5pa3pj6 ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.V...
76,497 79,605 1.18 dcvv68fju01g4 ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.E...
69,992 69,965 1.08 97mt0g20bcfc3 PYUSLV begin ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
2,218,312 8 0.07 45z5kajtbgmj0 RAXMTR select /*+ parallel(t, 8) para...
1,769,872 8 0.05 awz0s801s8fh2 RAXMTR select /*+ parallel(t, 8) para...
1,064,284 1 0.03 gczkkgwgkyjh3 SQL*Plus select /*+ parallel(t, 8) para...

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
0qcpgw43yqj5r ( SELECT DISTINCT WDD.SOURCE_LINE_ID, WDD.SOURCE_HEADER_ID, WDD.ORGANIZATION_ID, WDD.INVENTORY_ITEM_ID, WDD.MOVE_ORDER_LINE_ID, WDD.DELIVERY_DETAIL_ID, WDD.SHIP_MODEL_COMPLETE_FLAG, WDD.TOP_MODEL_LINE_ID, WDD.SHIP_FROM_LOCATION_ID, NULL SHIP_METHOD_CODE, WDD.SHIPMENT_PRIORITY_CODE, WDD.DATE_SCHEDULED DATE_SCHEDULED, WDD.REQUESTED_QUANTITY, WDD.REQUESTED_QUANTITY_UOM, WDD.PREFERRED_GRADE, WDD.REQUESTED_QUANTITY2, WDD.REQUESTED_QUANTI TY_UOM2, WDD.PROJECT_ID, WDD.TASK_ID, WDD.SUBINVENTORY FROM_SUBINVENTORY_CODE, WDD.SUBINVENTORY TO_SUBINVENTORY_CODE, WDD.RELEASED_STATUS RELEASED_STATUS, WDD.SHIP_SET_ID SHIP_SET_ID, WDD.SOURCE_CODE SOURCE_CODE, WDD.SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER, NULL PLANNED_DEPARTURE_DATE, WDA.DELIVERY_ID, OL.END_ITEM_UNIT_NUMBER, OL.SOURCE_DOCUMENT_TYPE_ID, MSI.RESERVABLE_TYPE, WDD.LAST_UPDATE_DATE, -1 DEMAND_SOURCE_HEADER_ID, -1 OUT STANDING_ORDER_VALUE FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA, OE_ORDER_LINES_ALL OL, MTL_SYSTEM_ITEMS MSI , MTL_CATEGORY_SETS MCS, MTL_ITEM_CATEGORIES MIC WHERE WDD.DATE_SCHEDULED IS NOT NULL AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND NVL(WDD.REQUESTED_QUANTITY, 0) > 0 AND WDD.SOURCE_LINE_ID = OL.LINE_ID AND WDD.SOURCE_CODE = 'OE' AND WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND WDD.ORGANIZATION_ID = MSI.ORGA NIZATION_ID AND WDD.RELEASED_STATUS IN ( 'R', 'X') AND WDD.SHIP_FROM_LOCATION_ID = :X_ship_from_loc_id AND WDD.ORGANIZATION_ID = :X_org_id AND (WDA.DELIVERY_ID IS NULL ) AND (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'N' OR (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'Y' AND EXISTS ( SELECT 1 FROM WSH_NEW_DELIVERIES WDE1 WHERE WDE1.DELIVERY_ID = WDA.DELIVERY_ID AND ( NVL(WDE1.PLANNED_FLAG, 'N') IN ('Y', 'F' ) )) )) AND MCS.category_set_id = MIC.category_set_id AND MCS.categ ory_set_id = :x_CategorySetID AND MIC.category_id = :x_CategoryID AND MIC.organization_id = WDD.organization_id AND MIC.inventory_item_id = WDD.inventory_item_id ) ORDER BY WDD.INVENTORY_ITEM_ID, DATE_SCHEDULED ASC, SHIPMENT_PRIORITY_CODE ASC, to_number(SOURCE_HEADER_NUMBER) ASC, SHIP_FROM_LOCATION_ID
0z318y6g3uagc declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1du9v021t8m46 insert into gl_interface(created_by, date_created, status, actual_flag, group_id, set_of_books_id, user_je_source_name, user_je_category_name, accounting_date, subledger_doc_sequence_id, subledger_doc_sequence_value, ussgl_transaction_code, currency_code, code_combination_id, entered_dr, entered_cr, accounted_dr, accounted_cr, reference1, reference10, reference21, reference22, reference23, reference24, reference25, reference26, reference27, reference28, reference29, reference30, request_id)selec t /*+ ORDERED USE_NL (l ctlgd ct ctt cust) INDEX (ctlgd, RA_CUST_TRX_LINE_GL_DIST_N5) +*/ :b0 created_by , trunc(sysdate ) date_created , :b1 status , :b2 actual_flag , :b3 group_id , :b4 sob_id , :b5 source_name , decode(ctt.type, 'CM', :b6, 'DM', :b7, 'CB', :b8, :b9) category , ctlgd.gl_date gl_date , ct.doc_sequence_id doc_seqid , ct.doc_sequence_value doc_num , ctlgd.ussgl_transaction_code ussgl , ct.invoice_currency_code currency , ctlgd.code_combination_id ccid , decod e(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null )) entered_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), decode(sign(nvl(ctlgd.amount , 0)), (-1), null , nvl(ctlgd.amount, 0))) entered_cr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null )) acctd_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd. acctd_amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0))) acctd_cr , (:b10||to_char(:b3)) ref1 , decode(:b12, 'Y', null , ((((((l.meaning||' ')||:b13)||decode(ctt.type, 'CB', :b14, 'CM', :b15, 'DEP', :b16, 'DM', :b17, 'GUAR', :b18, 'INV', :b19, null ))||' ')||ct.trx_number)||:b20)) ref10 , to_char(:b3) ref21 , to_char(ct.customer_trx_id) ref22 , to_char(ctlgd.cust_trx_line_gl_dist_id) ref23 , ct.trx_number ref24 , cu st.account_number ref25 , 'CUSTOMER' ref26 , to_char(ct.bill_to_customer_id) ref27 , decode(ctt.type, 'CM', 'CM', 'DM', 'DM', 'CB', 'CB', 'INV') ref28 , (decode(ctt.type, 'CM', 'CM_', 'DM', 'DM_', 'CB', 'CB_', 'INV_')||ctlgd.account_class) ref29 , 'RA_CUST_TRX_LINE_GL_DIST' ref30 , :b22 from ra_cust_trx_line_gl_dist ctlgd , ra_cust_trx_line_gl_dist rec , ar_lookups l , ra_customer_trx ct , ra_cust_trx_types ctt , hz_cust_accounts cust where ((((((((((((((((ctlgd.cust_trx_line_gl_dist_id+0)<: b23 and ctlgd.gl_date between to_date((:b24||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b25||' 23:59:59'), 'DD-MON-RR HH24:MI:SS')) and ctlgd.posting_control_id=(-3)) and ctlgd.set_of_books_id=:b4) and ctlgd.account_set_flag='N') and ctlgd.customer_trx_id=ct.customer_trx_id) and l.lookup_type='AUTOGL_TYPE') and l.lookup_code=nvl(ctlgd.account_class, 'REV')) and ct.complete_flag='Y') and ct.bill_to_customer_id=cust.cust_account_id) and ct.cust_trx_type_id=ctt.cust_trx_type_id) and ctlgd. customer_trx_id=rec.customer_trx_id) and rec.account_class='REC') and rec.latest_rec_flag='Y') and rec.account_set_flag='N') and 'NOT_MFAR_TYPE'=AR_MFAR_PKG.ar_mfar_trx_post(ctlgd.customer_trx_id, :b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b12, :b13, :b20, :b14, :b15, :b17, :b16, :b18, :b19, :b24, :b25, :b23))
1nj7kuvxgpwah begin ARP_TAX . SET_DEFAULT_TAX_CODE ( :setSql , :updSql ) ; END ;
20rc3cmapyvnz select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no, priority, exception_qschema, exception_queue, retry_count, corrid, time_manager_info, sender_name, sender_address, sender_protocol from "APPLSYS"."WF_DEFERRED_TABLE_M" where msgid = :1
2fjd6cndjby9p INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID ) SELECT /*+ ORDERED */ ASS.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX _ID, DIST.CODE_COMBINATION_ID, :B12 , ASS.ACCOUNT_CLASS, 'N', ROUND( (DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1 ), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1 ) ), ASS.AMOUNT ), FC.PRECISION), ROUND( ((DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1) , DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1) ), ASS.AMOUNT) ) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT) / DECODE(LINES.EXTENDED_AMOUNT, 0, 1, LINES.EXTENDED_AMOUNT)) * DECODE(ASS.AMOUNT, 0, 0, 100), 4), DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), DECODE(:B10 , NULL, ROUND( NVL(HEADER.EXCHANGE_ RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ), :B11 ), ROUND( ( NVL(HEADER.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ( (DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) ) / :B10 ) * :B10 ), DEC ODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_DATE(ASS.GL_DATE) ), DECODE(DIST.CUSTOMER_TRX_ID, HEADER.CUSTOMER_TRX_ID, DIST.CUST_TRX_LINE_SALESREP_ID, CMSREP.CUST_TRX_LINE_SALESREP_ID), :B9 , :B8 , :B7 , SYSDATE, SYSDATE, :B6 , SYSDATE, :B6 , -3, ASS.GL_DATE, RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES FC, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE, RA_CUST_TRX_LINE_GL_DIST REC, RA_CUST_TRX_LINE_GL_DIST DIST, RA_CUST_TRX_LINE _SALESREPS CMSREP, AR_REVENUE_ASSIGNMENTS ASS WHERE HEADER.CUSTOMER_TRX_ID = :B1 AND HEADER.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = HEADER.INVOICE_CURRENCY_CODE AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINES.AUTORULE_COMPLETE_FLAG||'' = 'N' AND ASS.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND ASS.PERIOD_SET_NAME = :B5 AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID AND DECODE(HEADER.INVOICING_RULE_ID, -3, :B3 , DECODE(NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), 'Y', :B2 , DECODE(:B4 , 'N', :B3 , DECODE(HEADER.PREVIOUS_CUSTOMER_TRX_ID, NULL, AR_REVENUE_MANAGEMENT_PVT.LINE_COLLECTIBILITY(:B1 , LINES.CUSTOMER_TRX_LINE_ID), AR_REVENUE_MANAGEMENT_PVT.CASH_BASED(HEADER.PREVIOUS_CUSTOMER_TRX_ID))))) <> :B2 AND REC.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND DIST.CUSTOMER_TRX_LINE_ID = (SELECT DECODE(COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID, LINES.CUST OMER_TRX_LINE_ID), LINES.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' AND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND DIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND DIST.ACCOUNT_SET_FLAG = 'Y' AND DIST.CUST_TRX_LINE_SALESREP_ID = CMSREP.PREV_CUST_TRX_LINE_SALESREP_ID (+) AND :B1 = CMSREP.CUSTOMER_TRX_ID (+) AND NOT EXISTS ( SELECT 'distribution exists' FROM RA_CUST_TRX_LINE_GL_D IST SUBDIST WHERE SUBDIST.CUSTOMER_TRX_LINE_ID = ASS.CUSTOMER_TRX_LINE_ID AND SUBDIST.CUSTOMER_TRX_ID + 0 = LINES.CUSTOMER_TRX_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND SUBDIST.ORIGINAL_GL_DATE = ASS.GL_DATE )
37f1qguwxw0sk begin IF ( :v_msg_level:i_msg_level > 0 ) THEN arp_util . enable_debug ( 1000000 ) ; arp_global . msg_level := :v_msg_level:i_msg_level ; END IF ; arp_auto_accounting . g_error_buffer := NULL ; :v_num_failed_dist_rows:i_num_failed_dist_rows := 0 ; :v_coa_id:i_coa_id := arp_standard . gl_chart_of_accounts_id ; :v_retval:i_retval := 1 ; arp_auto_accounting . do_autoaccounting ( :v_mode:i_vmode , :v_account_class , :v_trx_id:i_trx_id , :v_line_id:i_line_id , :v_line_salesrep_id:i_line_salesr ep_id , :v_request_id:i_request_id , :v_gl_date , :v_orig_gl_date , :v_total_trx_amount:i_total_trx_amount , :v_passed_ccid:i_passed_ccid , :v_force_acct_set_no , :v_cust_trx_type_id:i_cust_trx_type_id , :v_primary_salesrep_id:i_primary_salesrep_id , :v_inv_item_id:i_inv_item_id , :v_memo_line_id:i_memo_line_id , :v_ccid:i_ccid , :v_concat_segments:i_concat_segments , :v_num_failed_dist_rows:i_num_failed_dist_rows ) ; IF ( :v_mode:i_vmode = 'G' AND :v_ccid:i_ccid = -1 ) THEN :v_retv al:i_retval := 0 ; END IF ; EXCEPTION WHEN arp_auto_accounting . no_ccid THEN :v_retval:i_retval := 0 ; WHEN NO_DATA_FOUND THEN NULL ; WHEN OTHERS THEN arp_util . debug ( 'arcdaa()' ) ; arp_util . debug ( SQLERRM ) ; :v_errorbuf:i_errorbuf := arp_auto_accounting . g_error_buffer ; :v_sqlcode:i_sqlcode := SQLCODE ; END ;
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3dssuqfjsynrk SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, ' CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustPa rty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.sta tus_code = :4 ORDER BY age ) )
3n8tvc1tsqua0 SELECT DISTINCT WTS.STOP_ID FROM WSH_TRIP_STOPS WTS, WSH_TRIP_STOPS WTS2, WSH_DELIVERY_LEGS WDL, WSH_DELIVERY_LEGS WDL2, WSH_DELIVERY_ASSIGNMENTS WDA, WSH_DELIVERY_ASSIGNMENTS WDA2, WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_DETAILS WDD2 WHERE WTS.BATCH_ID = :B1 AND WTS.STOP_ID = WDL.PICK_UP_STOP_ID AND WDA.DELIVERY_ID = WDL.DELIVERY_ID AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND WDD.SOURCE_CODE = 'OE' AND NVL(WDD.OE_INTERFACED_FLAG, 'N') <> 'Y' AND WDD.RELEASED_STATUS <& gt; 'D' AND WTS2.BATCH_ID = :B1 AND WTS2.STOP_ID = WDL2.PICK_UP_STOP_ID AND WDA2.DELIVERY_ID = WDL2.DELIVERY_ID AND WDA2.DELIVERY_DETAIL_ID = WDD2.DELIVERY_DETAIL_ID AND WDD2.SOURCE_LINE_ID = WDD.SOURCE_LINE_ID AND WDD2.SOURCE_CODE = 'OE' AND NVL(WDD2.OE_INTERFACED_FLAG, 'N') <> 'Y' AND WDD2.RELEASED_STATUS <> 'D' AND WTS2.STOP_ID <> WTS.STOP_ID
45z5kajtbgmj0 select /*+ parallel(t, 8) parallel_index(t, 8) cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(vsize("INTERFACE_LINE_ATTRIBUTE13")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE14"), count(distinct "INTERFACE_LINE_ATTRIBUTE14"), sum(vsize("INTERFACE _LINE_ATTRIBUTE14")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE15"), count(distinct "INTERFACE_LINE_ATTRIBUTE15"), sum(vsize("INTERFACE_LINE_ATTRIBUTE15")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE9"), count(distinct "INTERFACE_LINE_ATTRIBUTE9 "), sum(vsize("INTERFACE_LINE_ATTRIBUTE9")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("VAT_TAX_ID"), count(distinct "VAT_TAX_ID"), sum(vsize("VAT_TAX_ID")), substrb(dump(min("VAT_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("VAT_TAX_ID"), 16, 0, 32), 1, 120), count("REASON_CODE_MEANING"), count(distinct "REASON_CODE_MEANING"), sum(vsize("REASON_CODE_MEANING")), substrb(dump(min(substrb("REASON _CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("LAST_PERIOD_TO_CREDIT"), count(distinct "LAST_PERIOD_TO_CREDIT"), sum(vsize("LAST_PERIOD_TO_CREDIT")), substrb(dump(min("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), count("PAYING_CUSTOMER_ID"), count(distinct "PAYING_CUSTOMER_ID"), sum(vsize("PAYING_CUSTOMER_ID")), substrb(dump(min("PAYING_CUSTOMER_ID" ), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("PAYING_SITE_USE_ID"), count(distinct "PAYING_SITE_USE_ID"), sum(vsize("PAYING_SITE_USE_ID")), substrb(dump(min("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_FLAG"), count(distinct "TAX_EXEMPT_FLAG"), sum(vsize("TAX_EXEMPT_FLAG")), substrb(dump(min("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_FLAG"), 16, 0 , 32), 1, 120), count("TAX_EXEMPT_REASON_CODE"), count(distinct "TAX_EXEMPT_REASON_CODE"), sum(vsize("TAX_EXEMPT_REASON_CODE")), substrb(dump(min("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE_MEANING"), count(distinct "TAX_EXEMPT_REASON_CODE_MEANING"), sum(vsize("TAX_EXEMPT_REASON_CODE_MEANING")), substrb(dump(min(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(ma x(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("TAX_EXEMPT_NUMBER"), count(distinct "TAX_EXEMPT_NUMBER"), sum(vsize("TAX_EXEMPT_NUMBER")), substrb(dump(min(substrb("TAX_EXEMPT_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_EXEMPT_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("SALES_TAX_ID"), count(distinct "SALES_TAX_ID"), sum(vsize("SALES_TAX_ID")), substrb(dump(min("SALES_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_TAX_ID"), 16, 0, 32), 1, 120), count("CREATED_BY"), count(distinct "CREATED_BY"), sum(vsize("CREATED_BY")), substrb(dump(min("CREATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("CREATED_BY"), 16, 0, 32), 1, 120), count("CREATION_DATE"), count(distinct "CREATION_DATE"), substrb(dump(min("CREATION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CREATION_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATED_BY"), count(distinct "LAST_UPDATED_BY"), sum(vsize("LAST_UPDATED_BY")), substrb(dump(min("LAST_UPDATED_BY"), 16 , 0, 32), 1, 120), substrb(dump(max("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), count("LAST_UPDATE_DATE"), count(distinct "LAST_UPDATE_DATE"), substrb(dump(min("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATE_LOGIN"), count(distinct "LAST_UPDATE_LOGIN"), sum(vsize("LAST_UPDATE_LOGIN")), substrb(dump(min("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), count("LOCATION_SEGMENT_ ID"), count(distinct "LOCATION_SEGMENT_ID"), sum(vsize("LOCATION_SEGMENT_ID")), substrb(dump(min("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), count("MOVEMENT_ID"), count(distinct "MOVEMENT_ID"), sum(vsize("MOVEMENT_ID")), substrb(dump(min("MOVEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MOVEMENT_ID"), 16, 0, 32), 1, 120), count("ORG_ID"), count(distinct "ORG_ID"), sum(vsize("ORG_ID")), substrb(dump(min("ORG_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORG_ID"), 16, 0, 32), 1, 120), count("AMOUNT_INCLUDES_TAX_FLAG"), count(distinct "AMOUNT_INCLUDES_TAX_FLAG"), sum(vsize("AMOUNT_INCLUDES_TAX_FLAG")), substrb(dump(min("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTR_CATEGORY"), count(distinct "HEADER_GDF_ATTR_CATEGORY"), sum(vsize("HEADER_GDF_ATTR_CATEGORY")), substrb(dump(min("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substr b(dump(max("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE1"), count(distinct "HEADER_GDF_ATTRIBUTE1"), sum(vsize("HEADER_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE2"), count(distinct "HEADER_GDF_ATTRIBUTE2"), sum(vsize("HEADER_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE3"), count(distinct "HEADER_GDF_ATTRIBUTE3"), sum(vsize("HEADER_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE4"), count(distinct "HEADER_GDF_ATTRIBUTE4"), sum(vsize("HEADER_GDF_ATTRIBUTE4")), substrb(dump(min(su bstrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE5"), count(distinct "HEADER_GDF_ATTRIBUTE5"), sum(vsize("HEADER_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE6"), count(distinct "HEADER_GDF_ATTRIBUTE6"), sum(vsize("HEADE R_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE7"), count(distinct "HEADER_GDF_ATTRIBUTE7"), sum(vsize("HEADER_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE8"), count(distinct "H EADER_GDF_ATTRIBUTE8"), sum(vsize("HEADER_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE9"), count(distinct "HEADER_GDF_ATTRIBUTE9"), sum(vsize("HEADER_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HE ADER_GDF_ATTRIBUTE10"), count(distinct "HEADER_GDF_ATTRIBUTE10"), sum(vsize("HEADER_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE11"), count(distinct "HEADER_GDF_ATTRIBUTE11"), sum(vsize("HEADER_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATT RIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE12"), count(distinct "HEADER_GDF_ATTRIBUTE12"), sum(vsize("HEADER_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE13"), count(distinct "HEADER_GDF_ATTRIBUTE13"), sum(vsize("HEADER_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE14"), count(distinct "HEADER_GDF_ATTRIBUTE14"), sum(vsize("HEADER_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE15"), count(distinct "HEADER_GDF_ATTRIBUTE15"), sum(vsize("HEADER_GDF_ATTRIBUTE15")), substrb(dump(min(subs trb("HEADER_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE16"), count(distinct "HEADER_GDF_ATTRIBUTE16"), sum(vsize("HEADER_GDF_ATTRIBUTE16")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE17"), count(distinct "HEADER_GDF_ATTRIBUTE17"), sum(vsize ("HEADER_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE18"), count(distinct "HEADER_GDF_ATTRIBUTE18"), sum(vsize("HEADER_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE19"), c ount(distinct "HEADER_GDF_ATTRIBUTE19"), sum(vsize("HEADER_GDF_ATTRIBUTE19")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE20"), count(distinct "HEADER_GDF_ATTRIBUTE20"), sum(vsize("HEADER_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE20", 1, 32)), 16, 0 , 32), 1, 120), count("HEADER_GDF_ATTRIBUTE21"), count(distinct "HEADER_GDF_ATTRIBUTE21"), sum(vsize("HEADER_GDF_ATTRIBUTE21")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE22"), count(distinct "HEADER_GDF_ATTRIBUTE22"), sum(vsize("HEADER_GDF_ATTRIBUTE22")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(ma x(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE23"), count(distinct "HEADER_GDF_ATTRIBUTE23"), sum(vsize("HEADER_GDF_ATTRIBUTE23")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE24"), count(distinct "HEADER_GDF_ATTRIBUTE24"), sum(vsize("HEADER_GDF_ATTRIBUTE24")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE 24", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE25"), count(distinct "HEADER_GDF_ATTRIBUTE25"), sum(vsize("HEADER_GDF_ATTRIBUTE25")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE26"), count(distinct "HEADER_GDF_ATTRIBUTE26"), sum(vsize("HEADER_GDF_ATTRIBUTE26" )), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE26", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE26", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE27"), count(distinct "HEADER_GDF_ATTRIBUTE27"), sum(vsize("HEADER_GDF_ATTRIBUTE27")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE27", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE27", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE28"), count(distinct "HEADER_GDF _ATTRIBUTE28"), sum(vsize("HEADER_GDF_ATTRIBUTE28")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE28", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE28", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE29"), count(distinct "HEADER_GDF_ATTRIBUTE29"), sum(vsize("HEADER_GDF_ATTRIBUTE29")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE29", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE29", 1, 32)), 16, 0, 32), 1, 120), count("HE ADER_GDF_ATTRIBUTE30"), count(distinct "HEADER_GDF_ATTRIBUTE30"), sum(vsize("HEADER_GDF_ATTRIBUTE30")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE30", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE30", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTR_CATEGORY"), count(distinct "LINE_GDF_ATTR_CATEGORY"), sum(vsize("LINE_GDF_ATTR_CATEGORY")), substrb(dump(min("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE1"), count(distinct "LINE_GDF_ATTRIBUTE1"), sum(vsize("LINE_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE2"), count(distinct "LINE_GDF_ATTRIBUTE2"), sum(vsize("LINE_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE2", 1 , 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE3"), count(distinct "LINE_GDF_ATTRIBUTE3"), sum(vsize("LINE_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE4"), count(distinct "LINE_GDF_ATTRIBUTE4"), sum(vsize("LINE_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LIN E_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE5"), count(distinct "LINE_GDF_ATTRIBUTE5"), sum(vsize("LINE_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE6"), count(distinct "LINE_GDF_ATTRIBUTE6"), sum(vsize("LINE_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(d ump(max(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE7"), count(distinct "LINE_GDF_ATTRIBUTE7"), sum(vsize("LINE_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE8"), count(distinct "LINE_GDF_ATTRIBUTE8"), sum(vsize("LINE_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32) , 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE9"), count(distinct "LINE_GDF_ATTRIBUTE9"), sum(vsize("LINE_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE10"), count(distinct "LINE_GDF_ATTRIBUTE10"), sum(vsize("LINE_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE 10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE11"), count(distinct "LINE_GDF_ATTRIBUTE11"), sum(vsize("LINE_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE12"), count(distinct "LINE_GDF_ATTRIBUTE12"), sum(vsize("LINE_GDF_ATTRIBUTE12")), substrb(dump(m in(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE13"), count(distinct "LINE_GDF_ATTRIBUTE13"), sum(vsize("LINE_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE14"), count(distinct "LINE_GDF_ATTRIBUTE14"), sum(vsize("LINE_GDF_ ATTRIBUTE14")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE15"), count(distinct "LINE_GDF_ATTRIBUTE15"), sum(vsize("LINE_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE16"), count(distinct "LINE_GDF_ATTRI BUTE16"), sum(vsize("LINE_GDF_ATTRIBUTE16")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE17"), count(distinct "LINE_GDF_ATTRIBUTE17"), sum(vsize("LINE_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE18"), count(distinct "LINE_GDF_ATTRIBUTE18"), sum(vsize("LINE_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE19"), count(distinct "LINE_GDF_ATTRIBUTE19"), sum(vsize("LINE_GDF_ATTRIBUTE19")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), c ount("LINE_GDF_ATTRIBUTE20"), count(distinct "LINE_GDF_ATTRIBUTE20"), sum(vsize("LINE_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), count("RESET_TRX_DATE_FLAG"), count(distinct "RESET_TRX_DATE_FLAG"), sum(vsize("RESET_TRX_DATE_FLAG")), substrb(dump(min("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), count("P AYMENT_SERVER_ORDER_NUM"), count(distinct "PAYMENT_SERVER_ORDER_NUM"), sum(vsize("PAYMENT_SERVER_ORDER_NUM")), substrb(dump(min(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), count("APPROVAL_CODE"), count(distinct "APPROVAL_CODE"), sum(vsize("APPROVAL_CODE")), substrb(dump(min(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), count("ADDRESS_VERIFICATION_CODE"), count(distinct "ADDRESS_VERIFICATION_CODE"), sum(vsize("ADDRESS_VERIFICATION_CODE")), substrb(dump(min(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120), count("WAREHOUSE_ID"), count(distinct "WAREHOUSE_ID"), sum(vsize("WAREHOUSE_ID")), substrb(dump(min("WAREHOUSE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("WAREHOUSE_ID"), 16, 0, 32), 1, 120), count("TRA NSLATED_DESCRIPTION"), count(distinct "TRANSLATED_DESCRIPTION"), sum(vsize("TRANSLATED_DESCRIPTION")), substrb(dump(min(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count("CONS_BILLING_NUMBER"), count(distinct "CONS_BILLING_NUMBER"), sum(vsize("CONS_BILLING_NUMBER")), substrb(dump(min("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), count(" PROMISED_COMMITMENT_AMOUNT"), count(distinct "PROMISED_COMMITMENT_AMOUNT"), sum(vsize("PROMISED_COMMITMENT_AMOUNT")), substrb(dump(min("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), count("PAYMENT_SET_ID"), count(distinct "PAYMENT_SET_ID"), sum(vsize("PAYMENT_SET_ID")), substrb(dump(min("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), count("ORIGINAL_GL_DATE"), count(distinct "ORIGINAL_GL_DATE"), substrb(dump(min("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), count("CONTRACT_LINE_ID"), count(distinct "CONTRACT_LINE_ID"), sum(vsize("CONTRACT_LINE_ID")), substrb(dump(min("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), count("CONTRACT_ID"), count(distinct "CONTRACT_ID"), sum(vsize("CONTRACT_ID")), substrb(dump(min("CONTRACT_ID"), 16, 0, 32), 1, 120), substrb(dump( max("CONTRACT_ID"), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY1"), count(distinct "SOURCE_DATA_KEY1"), sum(vsize("SOURCE_DATA_KEY1")), substrb(dump(min(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY2"), count(distinct "SOURCE_DATA_KEY2"), sum(vsize("SOURCE_DATA_KEY2")), substrb(dump(min(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY3"), count(distinct "SOURCE_DATA_KEY3"), sum(vsize("SOURCE_DATA_KEY3")), substrb(dump(min(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY4"), count(distinct "SOURCE_DATA_KEY4"), sum(vsize("SOURCE_DATA_KEY4")), substrb(dump(min(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY5"), count(distinct "SOURCE_DATA_KEY5"), sum(vsize("SOURCE_DATA_KEY5")), substrb(dump(min(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120), count("INVOICED_LINE_ACCTG_LEVEL"), count(distinct "INVOICED_LINE_ACCTG_LEVEL"), sum(vsize("INVOICED_LINE_ACCTG_LEVEL")), substrb(dump(min("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICED_LINE_ACCTG_LEVEL" ), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG10"), count(distinct "MTL_SYSTEM_ITEMS_SEG10"), sum(vsize("MTL_SYSTEM_ITEMS_SEG10")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG11"), count(distinct "MTL_SYSTEM_ITEMS_SEG11"), sum(vsize("MTL_SYSTEM_ITEMS_SEG11")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG11", 1, 32)), 16, 0, 32), 1, 120), substrb (dump(max(substrb("MTL_SYSTEM_ITEMS_SEG11", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG12"), count(distinct "MTL_SYSTEM_ITEMS_SEG12"), sum(vsize("MTL_SYSTEM_ITEMS_SEG12")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG12", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG13"), count(distinct "MTL_SYSTEM_ITEMS_SEG13"), sum(vsize("MTL_SYSTEM_ITEMS_SEG13")), substrb(dump(min(substrb("MTL_SYSTEM_I TEMS_SEG13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG13", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG14"), count(distinct "MTL_SYSTEM_ITEMS_SEG14"), sum(vsize("MTL_SYSTEM_ITEMS_SEG14")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG15"), count(distinct "MTL_SYSTEM_ITEMS_SEG15"), sum(vsize("MTL_SYSTEM_ITEM S_SEG15")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG16"), count(distinct "MTL_SYSTEM_ITEMS_SEG16"), sum(vsize("MTL_SYSTEM_ITEMS_SEG16")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG17"), count(distinct "MT L_SYSTEM_ITEMS_SEG17"), sum(vsize("MTL_SYSTEM_ITEMS_SEG17")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG18"), count(distinct "MTL_SYSTEM_ITEMS_SEG18"), sum(vsize("MTL_SYSTEM_ITEMS_SEG18")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), c ount("MTL_SYSTEM_ITEMS_SEG19"), count(distinct "MTL_SYSTEM_ITEMS_SEG19"), sum(vsize("MTL_SYSTEM_ITEMS_SEG19")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG20"), count(distinct "MTL_SYSTEM_ITEMS_SEG20"), sum(vsize("MTL_SYSTEM_ITEMS_SEG20")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SY STEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ID"), count(distinct "REFERENCE_LINE_ID"), sum(vsize("REFERENCE_LINE_ID")), substrb(dump(min("REFERENCE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ID"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_CONTEXT"), count(distinct "REFERENCE_LINE_CONTEXT"), sum(vsize("REFERENCE_LINE_CONTEXT")), substrb(dump(min("REFERENCE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE1"), count(distinct "REFERENCE_LINE_ATTRIBUTE1"), sum(vsize("REFERENCE_LINE_ATTRIBUTE1")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE2"), count(distinct "REFERENCE_LINE_ATTRIBUTE2"), sum(vsize("REFERENCE_LINE_ATTRIBUTE2")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE 2"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE3"), count(distinct "REFERENCE_LINE_ATTRIBUTE3"), sum(vsize("REFERENCE_LINE_ATTRIBUTE3")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE4"), count(distinct "REFERENCE_LINE_ATTRIBUTE4"), sum(vsize("REFERENCE_LINE_ATTRIBUTE4")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENC E_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE5"), count(distinct "REFERENCE_LINE_ATTRIBUTE5"), sum(vsize("REFERENCE_LINE_ATTRIBUTE5")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE6"), count(distinct "REFERENCE_LINE_ATTRIBUTE6"), sum(vsize("REFERENCE_LINE_ATTRIBUTE6")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(du mp(max("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE7"), count(distinct "REFERENCE_LINE_ATTRIBUTE7"), sum(vsize("REFERENCE_LINE_ATTRIBUTE7")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("TERRITORY_ID"), count(distinct "TERRITORY_ID"), sum(vsize("TERRITORY_ID")), substrb(dump(min("TERRITORY_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_ID"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT1"), count(distinct "TERRITORY_SEGMENT1"), sum(vsize("TERRITORY_SEGMENT1")), substrb(dump(min("TERRITORY_SEGMENT1"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT1"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT2"), count(distinct "TERRITORY_SEGMENT2"), sum(vsize("TERRITORY_SEGMENT2")), substrb(dump(min("TERRITORY_SEGMENT2"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT2"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT3"), count(distinct " TERRITORY_SEGMENT3"), sum(vsize("TERRITORY_SEGMENT3")), substrb(dump(min("TERRITORY_SEGMENT3"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT3"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT4"), count(distinct "TERRITORY_SEGMENT4"), sum(vsize("TERRITORY_SEGMENT4")), substrb(dump(min("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT5"), count(distinct "TERRITORY_SEGMENT5"), sum(vsize("TERRITORY_SEGMENT5")) , substrb(dump(min("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT6"), count(distinct "TERRITORY_SEGMENT6"), sum(vsize("TERRITORY_SEGMENT6")), substrb(dump(min("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT7"), count(distinct "TERRITORY_SEGMENT7"), sum(vsize("TERRITORY_SEGMENT7")), substrb(dump(min("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT8"), count(distinct "TERRITORY_SEGMENT8"), sum(vsize("TERRITORY_SEGMENT8")), substrb(dump(min("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT9"), count(distinct "TERRITORY_SEGMENT9"), sum(vsize("TERRITORY_SEGMENT9")), substrb(dump(min("TERRITORY_SEGMENT9"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT9"), 16, 0 , 32), 1, 120), count("TERRITORY_SEGMENT10"), count(distinct "TERRITORY_SEGMENT10"), sum(vsize("TERRITORY_SEGMENT10")), substrb(dump(min("TERRITORY_SEGMENT10"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT10"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT11"), count(distinct "TERRITORY_SEGMENT11"), sum(vsize("TERRITORY_SEGMENT11")), substrb(dump(min("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT12") , count(distinct "TERRITORY_SEGMENT12"), sum(vsize("TERRITORY_SEGMENT12")), substrb(dump(min("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT13"), count(distinct "TERRITORY_SEGMENT13"), sum(vsize("TERRITORY_SEGMENT13")), substrb(dump(min("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT14"), count(distinct "TERRITORY_SEGMENT14"), sum (vsize("TERRITORY_SEGMENT14")), substrb(dump(min("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT15"), count(distinct "TERRITORY_SEGMENT15"), sum(vsize("TERRITORY_SEGMENT15")), substrb(dump(min("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT16"), count(distinct "TERRITORY_SEGMENT16"), sum(vsize("TERRITORY_SEGMENT16")), substrb(dump (min("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT17"), count(distinct "TERRITORY_SEGMENT17"), sum(vsize("TERRITORY_SEGMENT17")), substrb(dump(min("TERRITORY_SEGMENT17"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT17"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT18"), count(distinct "TERRITORY_SEGMENT18"), sum(vsize("TERRITORY_SEGMENT18")), substrb(dump(min("TERRITORY_SEGMENT18"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT18"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT19"), count(distinct "TERRITORY_SEGMENT19"), sum(vsize("TERRITORY_SEGMENT19")), substrb(dump(min("TERRITORY_SEGMENT19"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT19"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT20"), count(distinct "TERRITORY_SEGMENT20"), sum(vsize("TERRITORY_SEGMENT20")), substrb(dump(min("TERRITORY_SEGMENT20"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT20" ), 16, 0, 32), 1, 120), count("ATTRIBUTE_CATEGORY"), count(distinct "ATTRIBUTE_CATEGORY"), sum(vsize("ATTRIBUTE_CATEGORY")), substrb(dump(min("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("ATTRIBUTE1"), count(distinct "ATTRIBUTE1"), sum(vsize("ATTRIBUTE1")), substrb(dump(min(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE2"), count(distinct "A TTRIBUTE2"), sum(vsize("ATTRIBUTE2")), substrb(dump(min(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE3"), count(distinct "ATTRIBUTE3"), sum(vsize("ATTRIBUTE3")), substrb(dump(min(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE4"), count(distinct "ATTRIBUTE4"), sum(vsize("ATTRIBUTE4")), substrb(dump(min(substrb("ATTRI BUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE5"), count(distinct "ATTRIBUTE5"), sum(vsize("ATTRIBUTE5")), substrb(dump(min(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE6"), count(distinct "ATTRIBUTE6"), sum(vsize("ATTRIBUTE6")), substrb(dump(min(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIB UTE6", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE7"), count(distinct "ATTRIBUTE7"), sum(vsize("ATTRIBUTE7")), substrb(dump(min(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE8"), count(distinct "ATTRIBUTE8"), sum(vsize("ATTRIBUTE8")), substrb(dump(min(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE9"), count(distin ct "ATTRIBUTE9"), sum(vsize("ATTRIBUTE9")), substrb(dump(min(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE10"), count(distinct "ATTRIBUTE10"), sum(vsize("ATTRIBUTE10")), substrb(dump(min(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE11"), count(distinct "ATTRIBUTE11"), sum(vsize("ATTRIBUTE11")), substrb(dump(min(s ubstrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE12"), count(distinct "ATTRIBUTE12"), sum(vsize("ATTRIBUTE12")), substrb(dump(min(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE13"), count(distinct "ATTRIBUTE13"), sum(vsize("ATTRIBUTE13")), substrb(dump(min(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb( dump(max(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE14"), count(distinct "ATTRIBUTE14"), sum(vsize("ATTRIBUTE14")), substrb(dump(min(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE15"), count(distinct "ATTRIBUTE15"), sum(vsize("ATTRIBUTE15")), substrb(dump(min(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120) , count("HEADER_ATTRIBUTE_CATEGORY"), count(distinct "HEADER_ATTRIBUTE_CATEGORY"), sum(vsize("HEADER_ATTRIBUTE_CATEGORY")), substrb(dump(min("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE1"), count(distinct "HEADER_ATTRIBUTE1"), sum(vsize("HEADER_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE2"), count(distinct "HEADER_ATTRIBUTE2"), sum(vsize("HEADER_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE3"), count(distinct "HEADER_ATTRIBUTE3"), sum(vsize("HEADER_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE4"), count(distinct "HEADER_ATTRIBUTE4"), sum(vsize("HEADER_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE5"), count(distinct "HEADER_ATTRIBUTE5"), sum(vsize("HEADER_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE6"), count(distinct "HEADER_ATTRIBUTE6"), sum(vsize("HEADER_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE7"), count(distinct "HEADER_ATTRIBUTE7"), sum(vsize("HEADER_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE8"), count(distinct "HEADER_ATTRIBUTE8"), sum(vsize("HEADER_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE9"), count(distinct "HEADER_ATTRIBUTE9"), sum(vsize("HEADER_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE10"), count(distinct "HEADER_ATTRIBUTE10"), sum(vsize("HEADER_ATTRIBUTE10")), substrb(dump(min(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE11"), count(distinct "HEADER_ATTRIBUTE11"), sum(vsize("HEADER_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE11", 1, 32)), 1 6, 0, 32), 1, 120), count("HEADER_ATTRIBUTE12"), count(distinct "HEADER_ATTRIBUTE12"), sum(vsize("HEADER_ATTRIBUTE12")), substrb(dump(min(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE13"), count(distinct "HEADER_ATTRIBUTE13"), sum(vsize("HEADER_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE14"), count(distinct "HEADER_ATTRIBUTE14"), sum(vsize("HEADER_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE15"), count(distinct "HEADER_ATTRIBUTE15"), sum(vsize("HEADER_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTR IBUTE15", 1, 32)), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t
4adc1zhg5cmx0 UPDATE WSH_DELIVERY_DETAILS DD SET OE_INTERFACED_FLAG = :B5 WHERE SOURCE_LINE_ID = :B1 AND CONTAINER_FLAG = :B4 AND SOURCE_CODE = :B3 AND RELEASED_STATUS <> :B2 AND DD.DELIVERY_DETAIL_ID IN ( SELECT /*+ no_unnest */ DA.DELIVERY_DETAIL_ID FROM WSH_DELIVERY_ASSIGNMENTS DA , WSH_DELIVERY_LEGS DG, WSH_NEW_DELIVERIES DL, WSH_TRIP_STOPS ST WHERE DA.DELIVERY_DETAIL_ID = DD.DELIVERY_DETAIL_ID AND DL.DELIVERY_ID = DA.DELIVERY_ID AND DA.DELIVERY_ID IS NOT NULL AND ST.STOP_ID = DG.PICK_UP_STOP_ID AND ST.BATCH_ID = :B6 AND ST.STOP_LOCATION_ID = DL.INITIAL_PICKUP_LOCATION_ID AND DG.DELIVERY_ID = DL.DELIVERY_ID )
4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5kqw5535fjvw6 SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
5qyckzm5v1qmj begin :return_value:i_return_value := arp_rounding . correct_dist_rounding_errors ( :request_id , NULL , NULL , :rows_processed:i_rows_processed , :error_msg:i_error_msg , NULL , NULL , :trx_class , 'N' , :debug_mode , arp_global . sysparam . trx_header_level_rounding , 'N' ) ; END ;
608c0n36kaw62 begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
64qc329wgjv39 select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_cha r(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assign ment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
64z4pgdwwm6g2 SELECT STOP_ID FROM WSH_TRIP_STOPS WHERE STOP_ID = :B2 AND PENDING_INTERFACE_FLAG = :B1 FOR UPDATE NOWAIT
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6gnth2mfbs2nq declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7 BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
72cqcsuq5wgh0 SELECT aslrt.meaning as rank_name , aslrt.rank_id, sum(case when asl.status_open_flag = 'Y' AND round(sysdate-asl.creation_date)<= 2 THEN 1 else 0 END) as day0_2, sum(case when asl.status_open_flag = 'Y' AND round((sysdate - asl.creation_date)) between 3 and 7 THEN 1 else 0 END) as day3_7, sum(case when asl.status_open_flag = 'Y' AND round((sysdate - asl.creation_date)) between 8 and 30 THEN 1 else 0 END) as day8_30, sum(case when asl.status_open_fla g = 'Y' AND round((sysdate - asl.creation_date)) >= 31 THEN 1 else 0 END) as day_31, sum(case when nvl(asl.status_open_flag, 'N') = 'N' AND asl.status_code <> 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END) as closed, sum(case when asl.status_code = 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END) as converted, round((sum(case when asl.status_code = 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END)/count(asl.sales_lead_id)) * 100, 2) as conversion, count(aslrt.ra nk_id) total_leads FROM as_sales_leads asl, as_sales_lead_ranks_tl aslrt, as_sales_lead_ranks_b aslrb, ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id , aaa.customer_id FROM as_accesses_all aaa WHERE aaa.lead_id is null AND aaa.sales_lead_id IS NOT NULL AND aaa.salesforce_id = :1)secu WHERE asl.lead_rank_id = aslrt.rank_id AND aslrb.rank_id = aslrt.rank_id AND aslrt.language = USERENV('LANG') AND secu.sa les_lead_id = asl.sales_lead_id AND secu.customer_id = asl.customer_id GROUP BY aslrt.rank_id, aslrt.meaning, aslrb.min_score ORDER BY aslrb.min_score DESC
76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7g05xfvc5vp74 BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END;
815ygd4pc1bpd INSERT INTO RA_CUSTOMER_TRX_LINES ( customer_trx_line_id, last_update_date, last_updated_by, creation_date, created_by, last_update_login, customer_trx_id, interface_line_attribute1, interface_line_attribute2, interface_line_attribute3, interface_line_attribute4, interface_line_attribute5, interface_line_attribute6, interface_line_attribute7, interface_line_attribute8, interface_line_attribute9, interface_line_attribute10, interface_line_attribute11, interface_line_attribute12, interface_line_attribute13, interface_line_attribute14, interface_line_attribute15, interface_line_context, line_number, set_of_books_id, reason_code, inventory_item_id, description, translated_description, previous_customer_trx_id, previous_customer_trx_line_id, initial_customer_trx_line_id, quantity_ordered, quantity_credited, quantity_invoiced, unit_standard_price, unit_selling_price, amount_includes_tax_flag, uom_code, sales_order, sales_order_line, sales_order_date, sales_order_source, sales_order_revision, accounting_rule_id, accounting_rule_duration, line_type, rule_start_date, extended_amount, taxable_amount, revenue_amount, link_to_cust_trx_line_id, sales_tax_id, location_segment_id, vat_tax_id, tax_precedence, tax_rate, item_exception_rate_id, tax_exemption_id, memo_line_id, attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribut e11, attribute12, attribute13, attribute14, attribute15, global_attribute_category, global_attribute1, global_attribute2, global_attribute3, global_attribute4, global_attribute5, global_attribute6, global_attribute7, global_attribute8, global_attribute9, global_attribute10, global_attribute11, global_attribute12, global_attribute13, global_attribute14, global_attribute15, global_attribute16, global_attribute17, global_attribute18, global_attribute19, global_attribute20, request_id, program_application_id, program_id, program_update_date, default_ussgl_transaction_code, autorule_complete_flag, last_period_to_credit, tax_exempt_flag, tax_exempt_reason_code, tax_exempt_number, movement_id, payment_set_id, warehouse_id, contract_line_id, invoiced_line_acctg_level, source_data_key1, source_data_key2, source_data_key3, source_data_key4, source_data_key5) SELECT l.interface_line_id, sysdate, :b1, sysdate, :b2, :b3, l.customer_trx_id, l.inter face_line_attribute1, l.interface_line_attribute2, l.interface_line_attribute3, l.interface_line_attribute4, l.interface_line_attribute5, l.interface_line_attribute6, l.interface_line_attribute7, l.interface_line_attribute8, l.interface_line_attribute9, l.interface_line_attribute10, l.interface_line_attribute11, l.interface_line_attribute12, l.interface_line_attribute13, l.interface_line_attribute14, l.interface_line_attribute15, substr(decode(l.interface_line_context, 'Global Dat a Elements', null, l.interface_line_context), 1, 30), l.line_number, l.set_of_books_id, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.reason_code, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.inventory_item_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.description, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.t ranslated_description, null), null, null, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.reference_line_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.quantity_ordered, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(t.type, 'CM', l.quantity, null), null), decode(l.line_type, 'LINE', decode(t.type, 'CM', null, nvl(l.quantity, 1)), 'CHARGES', 1, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.unit_standard_price, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', nvl(l.unit_selling_price, decode(t.type, 'CM', decode(l.credit_method_for_acct_rule, 'UNIT', l.amount/l.quantity, null), decode(l.quantity, 0, l.amount, null, l.amount, ROUND(l.amount/l.quantity, 15)))), null), l.amount_includes_tax_flag, decode(l.line_type, 'LINE', l.uom_code, 'CHARGES', null, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.sales_order, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', ltrim(l.sales_order_line) , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type) , 'LINE', l.sales_order_date , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.sales_order_source , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.sales_order_revision , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.accounting_rule_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.accounting_rule_id, null, null, decode(r.type, 'A', r.occurrences, l.accounting_rule_duration)), null), l.line_type, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.accounting_rule_id, null, null, l.rule_start_date), null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.quantity * l.unit_selling_pr ice, null, nvl(l.amount, 0), decode(c.minimum_accountable_unit, null, round(l.quantity * l.unit_selling_price, c.precision), round(l.quantity * l.unit_selling_price / c.minimum_accountable_unit)* c.minimum_accountable_unit)), 'TAX', decode(l.amount, null, decode(l.tax_precedence, null, deco de(parent.quantity * parent.unit_selling_price, null, decode(c.minimum_accountable_unit, null, round(nvl(parent.amount, 0) * (nvl(l.tax_rate, 0)/100), c.precision), round(nvl(parent.amount, 0) * (nvl(l.tax_rate, 0)/100)/ c.minimum_accountable_unit) * c.minimum_accountable_unit), decode(c.minimum_accountable_unit, null, round(parent.quantity * parent.unit_selling_price * (nvl(l.tax_rate, 0)/100), c.precision), round(parent.quantity * parent.unit_selling_price * (nvl(l.tax_rate, 0)/100)/ c.minimum_accountable_unit) * c.minimum_accountable_unit)), 0), nvl(l.amount, 0)), nvl(l.amount, 0)), decode(l.line_type, 'TAX', decode(l.tax_precedence, n ull, decode(parent.quantity * parent.unit_selling_price, null, decode(c.minimum_accountable_unit, null, round(nvl(parent.amount, 0), c.precision), round(nvl(parent.amount, 0) / c.minimum_accountable_unit) * c.minimum_accountable_unit), decode(c.minimum_accountable_unit, null, round(parent.quantity * parent.unit_selling_price , c.precision), round(parent.quantity * parent.unit_selling_price / c.minimum_accountable_ unit) * c.minimum_accountable_unit)), 0), null), decode(l.line_type, 'LINE', nvl(l.amount, 0), 'CHARGES', null, null), decode(l.line_type, 'TAX', l.link_to_line_id, 'FREIGHT', l.link_to_line_id, null), decode(l.line_type, 'TAX', l.sales_tax_id, null), decode(l.line_type, 'TAX', l.location_segment_id, null), decode(l.line_type, 'TAX', l.vat_tax_id, 'LINE', l.vat_tax_id, null), decode(l.l ine_type, 'TAX', l.tax_precedence, null), decode(l.line_type, 'TAX', l.tax_rate, null), decode(l.line_type, 'TAX', l.exception_id, null), decode(l.line_type, 'TAX', l.exemption_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.memo_line_id, null), l.attribute_category, rtrim(l.attribute1), rtrim(l.attribute2), rtrim(l.attribute3), rtrim(l.attribute4), rtrim(l.attribute5), rtrim(l.attribute6), rtrim(l.attribute7), rtrim(l.attribute8), rtrim(l.attribute9), rtrim(l.attribute10), rtrim(l.attribute11), rtrim(l.attribute12), rtrim(l.attribute13), rtrim(l.attribute14), rtrim(l.attribute15), l.line_gdf_attr_category, l.line_gdf_attribute1, l.line_gdf_attribute2, l.line_gdf_attribute3, l.line_gdf_attribute4, l.line_gdf_attribute5, l.line_gdf_attribute6, l.line_gdf_attribute7, l.line_gdf_attribute8, l.line_gdf_attribute9, l.line_gdf_attribute10, l.line_gdf_attribute11, l.line_gdf_attribute12, l.line_gdf_attribute1 3, l.line_gdf_attribute14, l.line_gdf_attribute15, l.line_gdf_attribute16, l.line_gdf_attribute17, l.line_gdf_attribute18, l.line_gdf_attribute19, l.line_gdf_attribute20, :b4, :b5, :b6, sysdate, l.ussgl_transaction_code, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.accounting_rule_id, null, null, 'N'), null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.credit_method_for_acct_rule, 'UNIT' , null, null), null), decode(l.line_type, 'LINE', l.tax_exempt_flag, null), decode(l.line_type, 'LINE', decode(l.tax_exempt_flag, 'E', l.tax_exempt_reason_code, null), null), decode(l.line_type, 'LINE', decode(l.tax_exempt_flag, 'E', l.tax_exempt_number, null), null), l.movement_id, l.payment_set_id, l.warehouse_id, l.contract_line_id, l.invoiced_line_acctg_level, l.source_data_key1, l.source_data_ key2, l.source_data_key3, l.source_data_key4, l.source_data_key5 FROM FND_CURRENCIES C, RA_CUST_TRX_TYPES t, RA_RULES r, RA_INTERFACE_LINES_GT parent, RA_INTERFACE_LINES_GT l WHERE l.request_id = :b7 AND l.currency_code = c.currency_code AND l.cust_trx_type_id = t.cust_trx_type_id AND l.accounting_rule_id = r.rule_id(+) AND l.customer_trx_id is not null AND l.link_to_line_id = parent.interface_line_id(+) AND nvl(l.interface_status, '~') != 'P'
821fx90awyvj7 SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOO KED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET _PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST _CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , RE FERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_ LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE _TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRIBUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
8bsm049u7thjd select min(next_date) from "APPLSYS"."AQ$_WF_DEFERRED_TABLE_M_T"
8c30hkqv9n7cr BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
8c8cf4vtv4tx2 SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNI TY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age )
8vmj377jqyqwq BEGIN WSH_BATCH_PROCESS.CONFIRM_DELIVERY_SRS( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14, :A15, :A16, :A17, :A18, :A19, :A20, :A21, :A22); END;
944u2vd2tkmff select 'lock' from ra_cust_trx_line_gl_dist ctlgd , ra_customer_trx ct where ((((((ctlgd.posting_control_id=(-3) and ctlgd.set_of_books_id=:b0) and ctlgd.account_set_flag='N') and ctlgd.cust_trx_line_gl_dist_id<:b1) and ctlgd.customer_trx_id=ct.customer_trx_id) and ct.complete_flag='Y') and ctlgd.gl_date between to_date((:b2||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b3||' 23:59:59'), 'DD-MON-RR HH24:MI:SS')) for update of ctlgd.cust_trx_line_gl_dist_id
97mt0g20bcfc3 begin pay_US_rules.get_default_jurisdiction (:asgact, :eeid, :defval:defvalind); end;
9bbak9qpg1c7x INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE ) VALUES ( :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
avc1jqzz04wpr SELECT 'x' FROM DUAL
awz0s801s8fh2 select /*+ parallel(t, 8) parallel_index(t, 8) cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("COMMENTS"), count(distinct "COMMENTS"), sum(vsize("COMMENTS")), substrb(dump(min(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), count("INTERNAL_NOTES"), count(distinct "INTERNAL_NOTES"), sum(vsize("INTERNAL_NOTES")), substrb(dump(min(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), count("INITIAL_CUSTOMER_TRX_ID"), count(distinct "INITIAL_CUSTOMER_TRX_ID"), sum(vsize("INITIAL_CUSTOMER_TRX_ID")), substrb(dump(min("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE_CONTEXT"), count(distinct "USSGL_TRANSACTION_CODE_CONTEXT"), sum(vsize("USSGL_TRANSACTION_CODE_CONTEXT")), substrb(dump(min("USSGL_TRANSACTION_CODE_ CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE"), count(distinct "USSGL_TRANSACTION_CODE"), sum(vsize("USSGL_TRANSACTION_CODE")), substrb(dump(min("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), count("ACCTD_AMOUNT"), count(distinct "ACCTD_AMOUNT"), sum(vsize("ACCTD_AMOUNT")), substrb(dump(min("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(m ax("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), count("CUSTOMER_BANK_ACCOUNT_ID"), count(distinct "CUSTOMER_BANK_ACCOUNT_ID"), sum(vsize("CUSTOMER_BANK_ACCOUNT_ID")), substrb(dump(min("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), count("CUSTOMER_BANK_ACCOUNT_NAME"), count(distinct "CUSTOMER_BANK_ACCOUNT_NAME"), sum(vsize("CUSTOMER_BANK_ACCOUNT_NAME")), substrb(dump(min(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 12 0), substrb(dump(max(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), count("UOM_CODE"), count(distinct "UOM_CODE"), sum(vsize("UOM_CODE")), substrb(dump(min("UOM_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_CODE"), 16, 0, 32), 1, 120), count("UOM_NAME"), count(distinct "UOM_NAME"), sum(vsize("UOM_NAME")), substrb(dump(min("UOM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_NAME"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER_SEQUENCE_ID"), count(distinct "DOCUMENT_NU MBER_SEQUENCE_ID"), sum(vsize("DOCUMENT_NUMBER_SEQUENCE_ID")), substrb(dump(min("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE10"), count(distinct "LINK_TO_LINE_ATTRIBUTE10"), sum(vsize("LINK_TO_LINE_ATTRIBUTE10")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE11"), count(dis tinct "LINK_TO_LINE_ATTRIBUTE11"), sum(vsize("LINK_TO_LINE_ATTRIBUTE11")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE12"), count(distinct "LINK_TO_LINE_ATTRIBUTE12"), sum(vsize("LINK_TO_LINE_ATTRIBUTE12")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE13"), cou nt(distinct "LINK_TO_LINE_ATTRIBUTE13"), sum(vsize("LINK_TO_LINE_ATTRIBUTE13")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE14"), count(distinct "LINK_TO_LINE_ATTRIBUTE14"), sum(vsize("LINK_TO_LINE_ATTRIBUTE14")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE15" ), count(distinct "LINK_TO_LINE_ATTRIBUTE15"), sum(vsize("LINK_TO_LINE_ATTRIBUTE15")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE8"), count(distinct "LINK_TO_LINE_ATTRIBUTE8"), sum(vsize("LINK_TO_LINE_ATTRIBUTE8")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE9" ), count(distinct "LINK_TO_LINE_ATTRIBUTE9"), sum(vsize("LINK_TO_LINE_ATTRIBUTE9")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE10"), count(distinct "REFERENCE_LINE_ATTRIBUTE10"), sum(vsize("REFERENCE_LINE_ATTRIBUTE10")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("REFERENCE_LIN E_ATTRIBUTE11"), count(distinct "REFERENCE_LINE_ATTRIBUTE11"), sum(vsize("REFERENCE_LINE_ATTRIBUTE11")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE12"), count(distinct "REFERENCE_LINE_ATTRIBUTE12"), sum(vsize("REFERENCE_LINE_ATTRIBUTE12")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE13"), count(distinct "REFERENCE_LINE_ATTRIBUTE13"), sum(vsize("REFERENCE_LINE_ATTRIBUTE13")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE14"), count(distinct "REFERENCE_LINE_ATTRIBUTE14"), sum(vsize("REFERENCE_LINE_ATTRIBUTE14")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTR IBUTE14"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE15"), count(distinct "REFERENCE_LINE_ATTRIBUTE15"), sum(vsize("REFERENCE_LINE_ATTRIBUTE15")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE8"), count(distinct "REFERENCE_LINE_ATTRIBUTE8"), sum(vsize("REFERENCE_LINE_ATTRIBUTE8")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(ma x("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE9"), count(distinct "REFERENCE_LINE_ATTRIBUTE9"), sum(vsize("REFERENCE_LINE_ATTRIBUTE9")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(vsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 1 20), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(vsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE12"), count(distinct "INTERFACE_LINE_ATTRIBUTE12"), sum(vsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRI BUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ID"), sum(vsize("INTERFACE_LINE_ID")), substrb(dump(min("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_CONTEXT"), count(distinct "INTERFACE_LINE_CONTEXT"), sum(vsize("INTERFACE_LINE_CONTEXT")), substrb(dump(min("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_CONTEXT" ), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE1"), count(distinct "INTERFACE_LINE_ATTRIBUTE1"), sum(vsize("INTERFACE_LINE_ATTRIBUTE1")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE2"), count(distinct "INTERFACE_LINE_ATTRIBUTE2"), sum(vsize("INTERFACE_LINE_ATTRIBUTE2")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_ LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE3"), count(distinct "INTERFACE_LINE_ATTRIBUTE3"), sum(vsize("INTERFACE_LINE_ATTRIBUTE3")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE4"), count(distinct "INTERFACE_LINE_ATTRIBUTE4"), sum(vsize("INTERFACE_LINE_ATTRIBUTE4")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump (max("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE5"), count(distinct "INTERFACE_LINE_ATTRIBUTE5"), sum(vsize("INTERFACE_LINE_ATTRIBUTE5")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE6"), count(distinct "INTERFACE_LINE_ATTRIBUTE6"), sum(vsize("INTERFACE_LINE_ATTRIBUTE6")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 12 0), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE7"), count(distinct "INTERFACE_LINE_ATTRIBUTE7"), sum(vsize("INTERFACE_LINE_ATTRIBUTE7")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE8"), count(distinct "INTERFACE_LINE_ATTRIBUTE8"), sum(vsize("INTERFACE_LINE_ATTRIBUTE8")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE8"), 1 6, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count(distinct "BATCH_SOURCE_NAME"), sum(vsize("BATCH_SOURCE_NAME")), substrb(dump(min(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("SET_OF_BOOKS_ID"), count(distinct "SET_OF_BOOKS_ID"), sum(vsize("SET_OF_BOOKS_ID")), substrb(dump(min("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), count(distinct "LINE_TYPE"), sum(vsize("LINE_TYPE")), substrb(dump(min("LINE_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_TYPE"), 16, 0, 32), 1, 120), count(distinct "DESCRIPTION"), sum(vsize("DESCRIPTION")), substrb(dump(min(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count(distinct "CURRENCY_CODE"), sum(vsize("CURRENCY_CODE")), substrb(dump(min("CURRENCY_CODE"), 16, 0, 32), 1, 120), substrb( dump(max("CURRENCY_CODE"), 16, 0, 32), 1, 120), count("AMOUNT"), count(distinct "AMOUNT"), sum(vsize("AMOUNT")), substrb(dump(min("AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT"), 16, 0, 32), 1, 120), count("CUST_TRX_TYPE_NAME"), count(distinct "CUST_TRX_TYPE_NAME"), sum(vsize("CUST_TRX_TYPE_NAME")), substrb(dump(min("CUST_TRX_TYPE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("CUST_TRX_TYPE_NAME"), 16, 0, 32), 1, 120), count("CUST_TRX_TYPE_ID"), count(distinct "CUST_TRX_TYPE_ID"), sum (vsize("CUST_TRX_TYPE_ID")), substrb(dump(min("CUST_TRX_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUST_TRX_TYPE_ID"), 16, 0, 32), 1, 120), count("TERM_NAME"), count(distinct "TERM_NAME"), sum(vsize("TERM_NAME")), substrb(dump(min("TERM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("TERM_NAME"), 16, 0, 32), 1, 120), count("TERM_ID"), count(distinct "TERM_ID"), sum(vsize("TERM_ID")), substrb(dump(min("TERM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TERM_ID"), 16, 0, 32), 1, 120), count(" ORIG_SYSTEM_BATCH_NAME"), count(distinct "ORIG_SYSTEM_BATCH_NAME"), sum(vsize("ORIG_SYSTEM_BATCH_NAME")), substrb(dump(min(substrb("ORIG_SYSTEM_BATCH_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BATCH_NAME", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_BILL_CUSTOMER_REF"), sum(vsize("ORIG_SYSTEM_BILL_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(du mp(max(substrb("ORIG_SYSTEM_BILL_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_BILL_CUSTOMER_ID"), sum(vsize("ORIG_SYSTEM_BILL_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_REF"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_REF"), sum(vsize("ORIG_SYSTEM_BILL_ADDRESS_REF")), substrb(dump(min(s ubstrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_ID"), sum(vsize("ORIG_SYSTEM_BILL_ADDRESS_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_REF"), count(distinct "ORIG_SYSTEM_BILL_CONT ACT_REF"), sum(vsize("ORIG_SYSTEM_BILL_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_ID"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_ID"), sum(vsize("ORIG_SYSTEM_BILL_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), cou nt("ORIG_SYSTEM_SHIP_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_SHIP_CUSTOMER_REF"), sum(vsize("ORIG_SYSTEM_SHIP_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_SHIP_CUSTOMER_ID"), sum(vsize("ORIG_SYSTEM_SHIP_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_ADDRESS_REF"), count(distinct "ORIG_SYSTEM_SHIP_ADDRESS_REF"), sum(vsize("ORIG_SYSTEM_SHIP_ADDRESS_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_SHIP_ADDRESS_ID"), sum(vsize("ORIG_SYSTEM_SHIP_AD DRESS_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CONTACT_REF"), count(distinct "ORIG_SYSTEM_SHIP_CONTACT_REF"), sum(vsize("ORIG_SYSTEM_SHIP_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CONTACT_ID"), coun t(distinct "ORIG_SYSTEM_SHIP_CONTACT_ID"), sum(vsize("ORIG_SYSTEM_SHIP_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_CONTACT_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SOLD_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_SOLD_CUSTOMER_REF"), sum(vsize("ORIG_SYSTEM_SOLD_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SOLD_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SOLD_CUSTOMER_ REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_SOLD_CUSTOMER_ID"), sum(vsize("ORIG_SYSTEM_SOLD_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ID"), count(distinct "LINK_TO_LINE_ID"), sum(vsize("LINK_TO_LINE_ID")), substrb(dump(min("LINK_TO_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_CONTEXT"), count(distinct "LINK_TO_LINE_CONTEXT"), sum(vsize("LINK_TO_LINE_CONTEXT")), substrb(dump(min("LINK_TO_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE1"), count(distinct "LINK_TO_LINE_ATTRIBUTE1"), sum(vsize("LINK_TO_LINE_ATTRIBUTE1")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), co unt("LINK_TO_LINE_ATTRIBUTE2"), count(distinct "LINK_TO_LINE_ATTRIBUTE2"), sum(vsize("LINK_TO_LINE_ATTRIBUTE2")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE3"), count(distinct "LINK_TO_LINE_ATTRIBUTE3"), sum(vsize("LINK_TO_LINE_ATTRIBUTE3")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count( "LINK_TO_LINE_ATTRIBUTE4"), count(distinct "LINK_TO_LINE_ATTRIBUTE4"), sum(vsize("LINK_TO_LINE_ATTRIBUTE4")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE5"), count(distinct "LINK_TO_LINE_ATTRIBUTE5"), sum(vsize("LINK_TO_LINE_ATTRIBUTE5")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("LIN K_TO_LINE_ATTRIBUTE6"), count(distinct "LINK_TO_LINE_ATTRIBUTE6"), sum(vsize("LINK_TO_LINE_ATTRIBUTE6")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE7"), count(distinct "LINK_TO_LINE_ATTRIBUTE7"), sum(vsize("LINK_TO_LINE_ATTRIBUTE7")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("RECEIPT _METHOD_NAME"), count(distinct "RECEIPT_METHOD_NAME"), sum(vsize("RECEIPT_METHOD_NAME")), substrb(dump(min("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), count("RECEIPT_METHOD_ID"), count(distinct "RECEIPT_METHOD_ID"), sum(vsize("RECEIPT_METHOD_ID")), substrb(dump(min("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), count(distinct "CONVERSION_TYPE"), sum(vsize("CONVERSION_TYPE")), su bstrb(dump(min("CONVERSION_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_TYPE"), 16, 0, 32), 1, 120), count("CONVERSION_DATE"), count(distinct "CONVERSION_DATE"), substrb(dump(min("CONVERSION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_DATE"), 16, 0, 32), 1, 120), count("CONVERSION_RATE"), count(distinct "CONVERSION_RATE"), sum(vsize("CONVERSION_RATE")), substrb(dump(min("CONVERSION_RATE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_RATE"), 16, 0, 32), 1, 120), c ount("CUSTOMER_TRX_ID"), count(distinct "CUSTOMER_TRX_ID"), sum(vsize("CUSTOMER_TRX_ID")), substrb(dump(min("CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("TRX_DATE"), count(distinct "TRX_DATE"), substrb(dump(min("TRX_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("TRX_DATE"), 16, 0, 32), 1, 120), count("GL_DATE"), count(distinct "GL_DATE"), substrb(dump(min("GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("GL_DATE"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER"), count(distinct "DOCUMENT_NUMBER"), sum(vsize("DOCUMENT_NUMBER")), substrb(dump(min("DOCUMENT_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER"), 16, 0, 32), 1, 120), count("TRX_NUMBER"), count(distinct "TRX_NUMBER"), sum(vsize("TRX_NUMBER")), substrb(dump(min("TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("TRX_NUMBER"), 16, 0, 32), 1, 120), count("LINE_NUMBER"), count(distinct "LINE_NUMBER"), sum(vsize("LINE_NUMBER")), substrb(dump(min("LINE_NUMBE R"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_NUMBER"), 16, 0, 32), 1, 120), count("QUANTITY"), count(distinct "QUANTITY"), sum(vsize("QUANTITY")), substrb(dump(min("QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY"), 16, 0, 32), 1, 120), count("QUANTITY_ORDERED"), count(distinct "QUANTITY_ORDERED"), sum(vsize("QUANTITY_ORDERED")), substrb(dump(min("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), count("UNIT_SELLING_PRICE"), count (distinct "UNIT_SELLING_PRICE"), sum(vsize("UNIT_SELLING_PRICE")), substrb(dump(min("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), count("UNIT_STANDARD_PRICE"), count(distinct "UNIT_STANDARD_PRICE"), sum(vsize("UNIT_STANDARD_PRICE")), substrb(dump(min("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), count("PRINTING_OPTION"), count(distinct "PRINTING_OPTION"), sum(vsize("PRINTING_OP TION")), substrb(dump(min("PRINTING_OPTION"), 16, 0, 32), 1, 120), substrb(dump(max("PRINTING_OPTION"), 16, 0, 32), 1, 120), count("INTERFACE_STATUS"), count(distinct "INTERFACE_STATUS"), sum(vsize("INTERFACE_STATUS")), substrb(dump(min("INTERFACE_STATUS"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_STATUS"), 16, 0, 32), 1, 120), count("REQUEST_ID"), count(distinct "REQUEST_ID"), sum(vsize("REQUEST_ID")), substrb(dump(min("REQUEST_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REQUEST_ID"), 16, 0, 32), 1, 120), count("RELATED_BATCH_SOURCE_NAME"), count(distinct "RELATED_BATCH_SOURCE_NAME"), sum(vsize("RELATED_BATCH_SOURCE_NAME")), substrb(dump(min(substrb("RELATED_BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("RELATED_BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("RELATED_TRX_NUMBER"), count(distinct "RELATED_TRX_NUMBER"), sum(vsize("RELATED_TRX_NUMBER")), substrb(dump(min("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_T RX_NUMBER"), 16, 0, 32), 1, 120), count("RELATED_CUSTOMER_TRX_ID"), count(distinct "RELATED_CUSTOMER_TRX_ID"), sum(vsize("RELATED_CUSTOMER_TRX_ID")), substrb(dump(min("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("PREVIOUS_CUSTOMER_TRX_ID"), count(distinct "PREVIOUS_CUSTOMER_TRX_ID"), sum(vsize("PREVIOUS_CUSTOMER_TRX_ID")), substrb(dump(min("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PREVIOUS_CUSTO MER_TRX_ID"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_ACCT_RULE"), count(distinct "CREDIT_METHOD_FOR_ACCT_RULE"), sum(vsize("CREDIT_METHOD_FOR_ACCT_RULE")), substrb(dump(min("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_INSTALLMENTS"), count(distinct "CREDIT_METHOD_FOR_INSTALLMENTS"), sum(vsize("CREDIT_METHOD_FOR_INSTALLMENTS")), substrb(dump(min("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 3 2), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 32), 1, 120), count("REASON_CODE"), count(distinct "REASON_CODE"), sum(vsize("REASON_CODE")), substrb(dump(min("REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_RATE"), count(distinct "TAX_RATE"), sum(vsize("TAX_RATE")), substrb(dump(min("TAX_RATE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_RATE"), 16, 0, 32), 1, 120), count("TAX_CODE"), count(distinct "TAX_CODE"), sum(vs ize("TAX_CODE")), substrb(dump(min(substrb("TAX_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_CODE", 1, 32)), 16, 0, 32), 1, 120), count("TAX_PRECEDENCE"), count(distinct "TAX_PRECEDENCE"), sum(vsize("TAX_PRECEDENCE")), substrb(dump(min("TAX_PRECEDENCE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_PRECEDENCE"), 16, 0, 32), 1, 120), count("EXCEPTION_ID"), count(distinct "EXCEPTION_ID"), sum(vsize("EXCEPTION_ID")), substrb(dump(min("EXCEPTION_ID"), 16, 0, 32), 1, 120), substrb (dump(max("EXCEPTION_ID"), 16, 0, 32), 1, 120), count("EXEMPTION_ID"), count(distinct "EXEMPTION_ID"), sum(vsize("EXEMPTION_ID")), substrb(dump(min("EXEMPTION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("EXEMPTION_ID"), 16, 0, 32), 1, 120), count("SHIP_DATE_ACTUAL"), count(distinct "SHIP_DATE_ACTUAL"), substrb(dump(min("SHIP_DATE_ACTUAL"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_DATE_ACTUAL"), 16, 0, 32), 1, 120), count("FOB_POINT"), count(distinct "FOB_POINT"), sum(vsize("FOB_POINT")), subs trb(dump(min("FOB_POINT"), 16, 0, 32), 1, 120), substrb(dump(max("FOB_POINT"), 16, 0, 32), 1, 120), count("SHIP_VIA"), count(distinct "SHIP_VIA"), sum(vsize("SHIP_VIA")), substrb(dump(min("SHIP_VIA"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_VIA"), 16, 0, 32), 1, 120), count("WAYBILL_NUMBER"), count(distinct "WAYBILL_NUMBER"), sum(vsize("WAYBILL_NUMBER")), substrb(dump(min(substrb("WAYBILL_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("WAYBILL_NUMBER", 1, 32)), 16, 0, 32), 1 , 120), count("INVOICING_RULE_NAME"), count(distinct "INVOICING_RULE_NAME"), sum(vsize("INVOICING_RULE_NAME")), substrb(dump(min("INVOICING_RULE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICING_RULE_NAME"), 16, 0, 32), 1, 120), count("INVOICING_RULE_ID"), count(distinct "INVOICING_RULE_ID"), sum(vsize("INVOICING_RULE_ID")), substrb(dump(min("INVOICING_RULE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICING_RULE_ID"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_NAME"), count(distinct "ACCOUNTING_RULE_NAME"), sum(vsize("ACCOUNTING_RULE_NAME")), substrb(dump(min("ACCOUNTING_RULE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_NAME"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_ID"), count(distinct "ACCOUNTING_RULE_ID"), sum(vsize("ACCOUNTING_RULE_ID")), substrb(dump(min("ACCOUNTING_RULE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_ID"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_DURATION"), count(distinct "ACCOUNTING_RULE_DURATION"), sum(vsize(" ACCOUNTING_RULE_DURATION")), substrb(dump(min("ACCOUNTING_RULE_DURATION"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_DURATION"), 16, 0, 32), 1, 120), count("RULE_START_DATE"), count(distinct "RULE_START_DATE"), substrb(dump(min("RULE_START_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("RULE_START_DATE"), 16, 0, 32), 1, 120), count("PRIMARY_SALESREP_NUMBER"), count(distinct "PRIMARY_SALESREP_NUMBER"), sum(vsize("PRIMARY_SALESREP_NUMBER")), substrb(dump(min("PRIMARY_SALESREP_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("PRIMARY_SALESREP_NUMBER"), 16, 0, 32), 1, 120), count("PRIMARY_SALESREP_ID"), count(distinct "PRIMARY_SALESREP_ID"), sum(vsize("PRIMARY_SALESREP_ID")), substrb(dump(min("PRIMARY_SALESREP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PRIMARY_SALESREP_ID"), 16, 0, 32), 1, 120), count("SALES_ORDER"), count(distinct "SALES_ORDER"), sum(vsize("SALES_ORDER")), substrb(dump(min(substrb("SALES_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SALES_OR DER", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_LINE"), count(distinct "SALES_ORDER_LINE"), sum(vsize("SALES_ORDER_LINE")), substrb(dump(min("SALES_ORDER_LINE"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_LINE"), 16, 0, 32), 1, 120), count("SALES_ORDER_DATE"), count(distinct "SALES_ORDER_DATE"), substrb(dump(min("SALES_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_DATE"), 16, 0, 32), 1, 120), count("SALES_ORDER_SOURCE"), count(distinct "SALES_ORDER_SOURCE"), sum (vsize("SALES_ORDER_SOURCE")), substrb(dump(min(substrb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_REVISION"), count(distinct "SALES_ORDER_REVISION"), sum(vsize("SALES_ORDER_REVISION")), substrb(dump(min("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), count("PURCHASE_ORDER"), count(distinct "PURCHASE_ORDER"), sum(vsize("PURCHASE_ORD ER")), substrb(dump(min(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), count("PURCHASE_ORDER_REVISION"), count(distinct "PURCHASE_ORDER_REVISION"), sum(vsize("PURCHASE_ORDER_REVISION")), substrb(dump(min(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), count("PURCHASE_ORDER_DATE"), count(distinct "PURCHASE_ORDER_DATE") , substrb(dump(min("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), count("AGREEMENT_NAME"), count(distinct "AGREEMENT_NAME"), sum(vsize("AGREEMENT_NAME")), substrb(dump(min("AGREEMENT_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_NAME"), 16, 0, 32), 1, 120), count("AGREEMENT_ID"), count(distinct "AGREEMENT_ID"), sum(vsize("AGREEMENT_ID")), substrb(dump(min("AGREEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_ID"), 16, 0, 32), 1, 120), count("MEMO_LINE_NAME"), count(distinct "MEMO_LINE_NAME"), sum(vsize("MEMO_LINE_NAME")), substrb(dump(min(substrb("MEMO_LINE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MEMO_LINE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("MEMO_LINE_ID"), count(distinct "MEMO_LINE_ID"), sum(vsize("MEMO_LINE_ID")), substrb(dump(min("MEMO_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MEMO_LINE_ID"), 16, 0, 32), 1, 120), count("INVENTORY_ITEM_ID"), count(distinct "INVENT ORY_ITEM_ID"), sum(vsize("INVENTORY_ITEM_ID")), substrb(dump(min("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG1"), count(distinct "MTL_SYSTEM_ITEMS_SEG1"), sum(vsize("MTL_SYSTEM_ITEMS_SEG1")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG2"), count(distinct "MTL_SYSTEM_ITE MS_SEG2"), sum(vsize("MTL_SYSTEM_ITEMS_SEG2")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG3"), count(distinct "MTL_SYSTEM_ITEMS_SEG3"), sum(vsize("MTL_SYSTEM_ITEMS_SEG3")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEM S_SEG4"), count(distinct "MTL_SYSTEM_ITEMS_SEG4"), sum(vsize("MTL_SYSTEM_ITEMS_SEG4")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG5"), count(distinct "MTL_SYSTEM_ITEMS_SEG5"), sum(vsize("MTL_SYSTEM_ITEMS_SEG5")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG6"), count(distinct "MTL_SYSTEM_ITEMS_SEG6"), sum(vsize("MTL_SYSTEM_ITEMS_SEG6")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG6", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG7"), count(distinct "MTL_SYSTEM_ITEMS_SEG7"), sum(vsize("MTL_SYSTEM_ITEMS_SEG7")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(subst rb("MTL_SYSTEM_ITEMS_SEG7", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG8"), count(distinct "MTL_SYSTEM_ITEMS_SEG8"), sum(vsize("MTL_SYSTEM_ITEMS_SEG8")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG8", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG9"), count(distinct "MTL_SYSTEM_ITEMS_SEG9"), sum(vsize("MTL_SYSTEM_ITEMS_SEG9")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG9", 1, 32)), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t
bf7uwg5pa3pj6 begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bkxrrs52m7d8p BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
bp8crdjba8zgt update ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b 4)
ccprbqfuu8wb1 SELECT NUMBER_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
cd9mbmqyf4qhp UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
cgb6kp2umq52a select t.schema, t.name, t.flags, q.name, t.timezone from system.aq$_queue_tables t, system.aq$_queues q where t.objno = :1 and q.table_objno = t.objno and q.usage = 0 and NOT ( t.name in ('DEF$_AQCALL' , 'DEF$_AQERROR') and t.schema = 'SYSTEM')
dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23 SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
gczkkgwgkyjh3 select /*+ parallel(t, 8) parallel_index(t, 8) cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("LAST_UPDATE_LOGIN"), count(distinct "LAST_UPDATE_LOGIN"), sum(vsize("LAST_UPDATE_LOGIN")), substrb(dump(min("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), count("PROGRAM_APPLICATION_ID"), count(distinct "PROGRAM_APPLICATION_ID"), sum(vsize("PROGRAM_APPLICATION_ID")), substrb(dump(min("PROGRAM_APPLICATI ON_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PROGRAM_APPLICATION_ID"), 16, 0, 32), 1, 120), count("PROGRAM_ID"), count(distinct "PROGRAM_ID"), sum(vsize("PROGRAM_ID")), substrb(dump(min("PROGRAM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PROGRAM_ID"), 16, 0, 32), 1, 120), count("PROGRAM_UPDATE_DATE"), count(distinct "PROGRAM_UPDATE_DATE"), substrb(dump(min("PROGRAM_UPDATE_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("PROGRAM_UPDATE_DATE"), 16, 0, 32), 1, 120), count("REQUEST_ID"), count(di stinct "REQUEST_ID"), sum(vsize("REQUEST_ID")), substrb(dump(min("REQUEST_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REQUEST_ID"), 16, 0, 32), 1, 120), count("MOVEMENT_ID"), count(distinct "MOVEMENT_ID"), sum(vsize("MOVEMENT_ID")), substrb(dump(min("MOVEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MOVEMENT_ID"), 16, 0, 32), 1, 120), count("SPLIT_FROM_DELIVERY_DETAIL_ID"), count(distinct "SPLIT_FROM_DELIVERY_DETAIL_ID"), sum(vsize("SPLIT_FROM_DELIVERY_DETAIL_ID")), substrb(dump(min("SPLIT_ FROM_DELIVERY_DETAIL_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SPLIT_FROM_DELIVERY_DETAIL_ID"), 16, 0, 32), 1, 120), count("INV_INTERFACED_FLAG"), count(distinct "INV_INTERFACED_FLAG"), sum(vsize("INV_INTERFACED_FLAG")), substrb(dump(min("INV_INTERFACED_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("INV_INTERFACED_FLAG"), 16, 0, 32), 1, 120), count("SEAL_CODE"), count(distinct "SEAL_CODE"), sum(vsize("SEAL_CODE")), substrb(dump(min("SEAL_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("SEAL_COD E"), 16, 0, 32), 1, 120), count("MINIMUM_FILL_PERCENT"), count(distinct "MINIMUM_FILL_PERCENT"), sum(vsize("MINIMUM_FILL_PERCENT")), substrb(dump(min("MINIMUM_FILL_PERCENT"), 16, 0, 32), 1, 120), substrb(dump(max("MINIMUM_FILL_PERCENT"), 16, 0, 32), 1, 120), count("MAXIMUM_VOLUME"), count(distinct "MAXIMUM_VOLUME"), sum(vsize("MAXIMUM_VOLUME")), substrb(dump(min("MAXIMUM_VOLUME"), 16, 0, 32), 1, 120), substrb(dump(max("MAXIMUM_VOLUME"), 16, 0, 32), 1, 120), count("MAXIMUM_LOAD_WEIGHT"), count(di stinct "MAXIMUM_LOAD_WEIGHT"), sum(vsize("MAXIMUM_LOAD_WEIGHT")), substrb(dump(min("MAXIMUM_LOAD_WEIGHT"), 16, 0, 32), 1, 120), substrb(dump(max("MAXIMUM_LOAD_WEIGHT"), 16, 0, 32), 1, 120), count("MASTER_SERIAL_NUMBER"), count(distinct "MASTER_SERIAL_NUMBER"), sum(vsize("MASTER_SERIAL_NUMBER")), substrb(dump(min("MASTER_SERIAL_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("MASTER_SERIAL_NUMBER"), 16, 0, 32), 1, 120), count("GROSS_WEIGHT"), count(distinct "GROSS_WEIGHT"), sum(vsize("GROSS_WEIGH T")), substrb(dump(min("GROSS_WEIGHT"), 16, 0, 32), 1, 120), substrb(dump(max("GROSS_WEIGHT"), 16, 0, 32), 1, 120), count("FILL_PERCENT"), count(distinct "FILL_PERCENT"), sum(vsize("FILL_PERCENT")), substrb(dump(min("FILL_PERCENT"), 16, 0, 32), 1, 120), substrb(dump(max("FILL_PERCENT"), 16, 0, 32), 1, 120), count("CONTAINER_NAME"), sum(vsize("CONTAINER_NAME")), substrb(dump(min(substrb("CONTAINER_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CONTAINER_NAME", 1, 32)), 16, 0, 32), 1, 120), count("CONTAINER_TYPE_CODE"), count(distinct "CONTAINER_TYPE_CODE"), sum(vsize("CONTAINER_TYPE_CODE")), substrb(dump(min("CONTAINER_TYPE_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("CONTAINER_TYPE_CODE"), 16, 0, 32), 1, 120), count(distinct "CONTAINER_FLAG"), sum(vsize("CONTAINER_FLAG")), substrb(dump(min("CONTAINER_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("CONTAINER_FLAG"), 16, 0, 32), 1, 120), count("PREFERRED_GRADE"), count(distinct "PREFERRED_GRADE"), sum(vsize("PREFERRED_GR ADE")), substrb(dump(min("PREFERRED_GRADE"), 16, 0, 32), 1, 120), substrb(dump(max("PREFERRED_GRADE"), 16, 0, 32), 1, 120), count("SRC_REQUESTED_QUANTITY2"), count(distinct "SRC_REQUESTED_QUANTITY2"), sum(vsize("SRC_REQUESTED_QUANTITY2")), substrb(dump(min("SRC_REQUESTED_QUANTITY2"), 16, 0, 32), 1, 120), substrb(dump(max("SRC_REQUESTED_QUANTITY2"), 16, 0, 32), 1, 120), count("SRC_REQUESTED_QUANTITY_UOM2"), count(distinct "SRC_REQUESTED_QUANTITY_UOM2"), sum(vsize("SRC_REQUESTED_QUANTITY_UOM2")), substrb(dump(min("SRC_REQUESTED_QUANTITY_UOM2"), 16, 0, 32), 1, 120), substrb(dump(max("SRC_REQUESTED_QUANTITY_UOM2"), 16, 0, 32), 1, 120), count("REQUESTED_QUANTITY2"), count(distinct "REQUESTED_QUANTITY2"), sum(vsize("REQUESTED_QUANTITY2")), substrb(dump(min("REQUESTED_QUANTITY2"), 16, 0, 32), 1, 120), substrb(dump(max("REQUESTED_QUANTITY2"), 16, 0, 32), 1, 120), count("SHIPPED_QUANTITY2"), count(distinct "SHIPPED_QUANTITY2"), sum(vsize("SHIPPED_QUANTITY2")), substrb(dump(min("SHIPPED_QUANTITY 2"), 16, 0, 32), 1, 120), substrb(dump(max("SHIPPED_QUANTITY2"), 16, 0, 32), 1, 120), count("DELIVERED_QUANTITY2"), count(distinct "DELIVERED_QUANTITY2"), sum(vsize("DELIVERED_QUANTITY2")), substrb(dump(min("DELIVERED_QUANTITY2"), 16, 0, 32), 1, 120), substrb(dump(max("DELIVERED_QUANTITY2"), 16, 0, 32), 1, 120), count("CANCELLED_QUANTITY2"), count(distinct "CANCELLED_QUANTITY2"), sum(vsize("CANCELLED_QUANTITY2")), substrb(dump(min("CANCELLED_QUANTITY2"), 16, 0, 32), 1, 120), substrb(dump(max("CA NCELLED_QUANTITY2"), 16, 0, 32), 1, 120), count("QUALITY_CONTROL_QUANTITY2"), count(distinct "QUALITY_CONTROL_QUANTITY2"), sum(vsize("QUALITY_CONTROL_QUANTITY2")), substrb(dump(min("QUALITY_CONTROL_QUANTITY2"), 16, 0, 32), 1, 120), substrb(dump(max("QUALITY_CONTROL_QUANTITY2"), 16, 0, 32), 1, 120), count("CYCLE_COUNT_QUANTITY2"), count(distinct "CYCLE_COUNT_QUANTITY2"), sum(vsize("CYCLE_COUNT_QUANTITY2")), substrb(dump(min("CYCLE_COUNT_QUANTITY2"), 16, 0, 32), 1, 120), substrb(dump(max("CYCLE_CO UNT_QUANTITY2"), 16, 0, 32), 1, 120), count("REQUESTED_QUANTITY_UOM2"), count(distinct "REQUESTED_QUANTITY_UOM2"), sum(vsize("REQUESTED_QUANTITY_UOM2")), substrb(dump(min("REQUESTED_QUANTITY_UOM2"), 16, 0, 32), 1, 120), substrb(dump(max("REQUESTED_QUANTITY_UOM2"), 16, 0, 32), 1, 120), count("SUBLOT_NUMBER"), count(distinct "SUBLOT_NUMBER"), sum(vsize("SUBLOT_NUMBER")), substrb(dump(min("SUBLOT_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("SUBLOT_NUMBER"), 16, 0, 32), 1, 120), count("UNIT_PRIC E"), count(distinct "UNIT_PRICE"), sum(vsize("UNIT_PRICE")), substrb(dump(min("UNIT_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_PRICE"), 16, 0, 32), 1, 120), count("CURRENCY_CODE"), count(distinct "CURRENCY_CODE"), sum(vsize("CURRENCY_CODE")), substrb(dump(min("CURRENCY_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("CURRENCY_CODE"), 16, 0, 32), 1, 120), count("UNIT_NUMBER"), count(distinct "UNIT_NUMBER"), sum(vsize("UNIT_NUMBER")), substrb(dump(min("UNIT_NUMBER"), 16, 0, 32), 1, 120), s ubstrb(dump(max("UNIT_NUMBER"), 16, 0, 32), 1, 120), count("FREIGHT_CLASS_CAT_ID"), count(distinct "FREIGHT_CLASS_CAT_ID"), sum(vsize("FREIGHT_CLASS_CAT_ID")), substrb(dump(min("FREIGHT_CLASS_CAT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("FREIGHT_CLASS_CAT_ID"), 16, 0, 32), 1, 120), count("COMMODITY_CODE_CAT_ID"), count(distinct "COMMODITY_CODE_CAT_ID"), sum(vsize("COMMODITY_CODE_CAT_ID")), substrb(dump(min("COMMODITY_CODE_CAT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("COMMODITY_CODE_CAT_ID" ), 16, 0, 32), 1, 120), count("LPN_CONTENT_ID"), count(distinct "LPN_CONTENT_ID"), sum(vsize("LPN_CONTENT_ID")), substrb(dump(min("LPN_CONTENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LPN_CONTENT_ID"), 16, 0, 32), 1, 120), count("LPN_ID"), count(distinct "LPN_ID"), sum(vsize("LPN_ID")), substrb(dump(min("LPN_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LPN_ID"), 16, 0, 32), 1, 120), count("INSPECTION_FLAG"), count(distinct "INSPECTION_FLAG"), sum(vsize("INSPECTION_FLAG")), substrb(dump(min(" INSPECTION_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("INSPECTION_FLAG"), 16, 0, 32), 1, 120), count("SHIP_TO_SITE_USE_ID"), count(distinct "SHIP_TO_SITE_USE_ID"), sum(vsize("SHIP_TO_SITE_USE_ID")), substrb(dump(min("SHIP_TO_SITE_USE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_TO_SITE_USE_ID"), 16, 0, 32), 1, 120), count("DELIVER_TO_SITE_USE_ID"), count(distinct "DELIVER_TO_SITE_USE_ID"), sum(vsize("DELIVER_TO_SITE_USE_ID")), substrb(dump(min("DELIVER_TO_SITE_USE_ID"), 16, 0, 32), 1, 12 0), substrb(dump(max("DELIVER_TO_SITE_USE_ID"), 16, 0, 32), 1, 120), count("ORIGINAL_SUBINVENTORY"), count(distinct "ORIGINAL_SUBINVENTORY"), sum(vsize("ORIGINAL_SUBINVENTORY")), substrb(dump(min("ORIGINAL_SUBINVENTORY"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGINAL_SUBINVENTORY"), 16, 0, 32), 1, 120), count("PICKABLE_FLAG"), count(distinct "PICKABLE_FLAG"), sum(vsize("PICKABLE_FLAG")), substrb(dump(min("PICKABLE_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("PICKABLE_FLAG"), 16, 0, 32), 1, 1 20), count("SOURCE_HEADER_NUMBER"), count(distinct "SOURCE_HEADER_NUMBER"), sum(vsize("SOURCE_HEADER_NUMBER")), substrb(dump(min(substrb("SOURCE_HEADER_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_HEADER_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_LINE_NUMBER"), count(distinct "SOURCE_LINE_NUMBER"), sum(vsize("SOURCE_LINE_NUMBER")), substrb(dump(min(substrb("SOURCE_LINE_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_LINE_NUMBER", 1, 32 )), 16, 0, 32), 1, 120), count("TO_SERIAL_NUMBER"), count(distinct "TO_SERIAL_NUMBER"), sum(vsize("TO_SERIAL_NUMBER")), substrb(dump(min("TO_SERIAL_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("TO_SERIAL_NUMBER"), 16, 0, 32), 1, 120), count("PICKED_QUANTITY"), count(distinct "PICKED_QUANTITY"), sum(vsize("PICKED_QUANTITY")), substrb(dump(min("PICKED_QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("PICKED_QUANTITY"), 16, 0, 32), 1, 120), count("PICKED_QUANTITY2"), count(distinct "PICKED_QUAN TITY2"), sum(vsize("PICKED_QUANTITY2")), substrb(dump(min("PICKED_QUANTITY2"), 16, 0, 32), 1, 120), substrb(dump(max("PICKED_QUANTITY2"), 16, 0, 32), 1, 120), count("CUSTOMER_PRODUCTION_LINE"), count(distinct "CUSTOMER_PRODUCTION_LINE"), sum(vsize("CUSTOMER_PRODUCTION_LINE")), substrb(dump(min(substrb("CUSTOMER_PRODUCTION_LINE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CUSTOMER_PRODUCTION_LINE", 1, 32)), 16, 0, 32), 1, 120), count("CUSTOMER_JOB"), count(distinct "CUSTOMER_JOB"), s um(vsize("CUSTOMER_JOB")), substrb(dump(min(substrb("CUSTOMER_JOB", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CUSTOMER_JOB", 1, 32)), 16, 0, 32), 1, 120), count("CUST_MODEL_SERIAL_NUMBER"), count(distinct "CUST_MODEL_SERIAL_NUMBER"), sum(vsize("CUST_MODEL_SERIAL_NUMBER")), substrb(dump(min(substrb("CUST_MODEL_SERIAL_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CUST_MODEL_SERIAL_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("RECEIVED_QUANTITY"), count(distinct "RE CEIVED_QUANTITY"), sum(vsize("RECEIVED_QUANTITY")), substrb(dump(min("RECEIVED_QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIVED_QUANTITY"), 16, 0, 32), 1, 120), count("RECEIVED_QUANTITY2"), count(distinct "RECEIVED_QUANTITY2"), sum(vsize("RECEIVED_QUANTITY2")), substrb(dump(min("RECEIVED_QUANTITY2"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIVED_QUANTITY2"), 16, 0, 32), 1, 120), count("SOURCE_LINE_SET_ID"), count(distinct "SOURCE_LINE_SET_ID"), sum(vsize("SOURCE_LINE_SET_ID")), subs trb(dump(min("SOURCE_LINE_SET_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SOURCE_LINE_SET_ID"), 16, 0, 32), 1, 120), count("BATCH_ID"), count(distinct "BATCH_ID"), sum(vsize("BATCH_ID")), substrb(dump(min("BATCH_ID"), 16, 0, 32), 1, 120), substrb(dump(max("BATCH_ID"), 16, 0, 32), 1, 120), count("TRANSACTION_ID"), count(distinct "TRANSACTION_ID"), sum(vsize("TRANSACTION_ID")), substrb(dump(min("TRANSACTION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TRANSACTION_ID"), 16, 0, 32), 1, 120), count( "SERVICE_LEVEL"), count(distinct "SERVICE_LEVEL"), sum(vsize("SERVICE_LEVEL")), substrb(dump(min("SERVICE_LEVEL"), 16, 0, 32), 1, 120), substrb(dump(max("SERVICE_LEVEL"), 16, 0, 32), 1, 120), count("MODE_OF_TRANSPORT"), count(distinct "MODE_OF_TRANSPORT"), sum(vsize("MODE_OF_TRANSPORT")), substrb(dump(min("MODE_OF_TRANSPORT"), 16, 0, 32), 1, 120), substrb(dump(max("MODE_OF_TRANSPORT"), 16, 0, 32), 1, 120), count("EARLIEST_PICKUP_DATE"), count(distinct "EARLIEST_PICKUP_DATE"), substrb(dump(min("E ARLIEST_PICKUP_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("EARLIEST_PICKUP_DATE"), 16, 0, 32), 1, 120), count("LATEST_PICKUP_DATE"), count(distinct "LATEST_PICKUP_DATE"), substrb(dump(min("LATEST_PICKUP_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("LATEST_PICKUP_DATE"), 16, 0, 32), 1, 120), count("EARLIEST_DROPOFF_DATE"), count(distinct "EARLIEST_DROPOFF_DATE"), substrb(dump(min("EARLIEST_DROPOFF_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("EARLIEST_DROPOFF_DATE"), 16, 0, 32), 1, 120), cou nt("LATEST_DROPOFF_DATE"), count(distinct "LATEST_DROPOFF_DATE"), substrb(dump(min("LATEST_DROPOFF_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("LATEST_DROPOFF_DATE"), 16, 0, 32), 1, 120), count("REQUEST_DATE_TYPE_CODE"), count(distinct "REQUEST_DATE_TYPE_CODE"), sum(vsize("REQUEST_DATE_TYPE_CODE")), substrb(dump(min("REQUEST_DATE_TYPE_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("REQUEST_DATE_TYPE_CODE"), 16, 0, 32), 1, 120), count("TP_DELIVERY_DETAIL_ID"), count(distinct "TP_DELIVERY_DETAIL_ ID"), sum(vsize("TP_DELIVERY_DETAIL_ID")), substrb(dump(min("TP_DELIVERY_DETAIL_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TP_DELIVERY_DETAIL_ID"), 16, 0, 32), 1, 120), count("SOURCE_DOCUMENT_TYPE_ID"), count(distinct "SOURCE_DOCUMENT_TYPE_ID"), sum(vsize("SOURCE_DOCUMENT_TYPE_ID")), substrb(dump(min("SOURCE_DOCUMENT_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SOURCE_DOCUMENT_TYPE_ID"), 16, 0, 32), 1, 120), count("VENDOR_ID"), count(distinct "VENDOR_ID"), sum(vsize("VENDOR_ID")), substrb (dump(min("VENDOR_ID"), 16, 0, 32), 1, 120), substrb(dump(max("VENDOR_ID"), 16, 0, 32), 1, 120), count("SHIP_FROM_SITE_ID"), count(distinct "SHIP_FROM_SITE_ID"), sum(vsize("SHIP_FROM_SITE_ID")), substrb(dump(min("SHIP_FROM_SITE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_FROM_SITE_ID"), 16, 0, 32), 1, 120), count("IGNORE_FOR_PLANNING"), count(distinct "IGNORE_FOR_PLANNING"), sum(vsize("IGNORE_FOR_PLANNING")), substrb(dump(min("IGNORE_FOR_PLANNING"), 16, 0, 32), 1, 120), substrb(dump(max("I GNORE_FOR_PLANNING"), 16, 0, 32), 1, 120), count("LINE_DIRECTION"), count(distinct "LINE_DIRECTION"), sum(vsize("LINE_DIRECTION")), substrb(dump(min("LINE_DIRECTION"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_DIRECTION"), 16, 0, 32), 1, 120), count("PARTY_ID"), count(distinct "PARTY_ID"), sum(vsize("PARTY_ID")), substrb(dump(min("PARTY_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PARTY_ID"), 16, 0, 32), 1, 120), count("ROUTING_REQ_ID"), count(distinct "ROUTING_REQ_ID"), sum(vsize("ROUTING_REQ _ID")), substrb(dump(min("ROUTING_REQ_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ROUTING_REQ_ID"), 16, 0, 32), 1, 120), count("SHIPPING_CONTROL"), count(distinct "SHIPPING_CONTROL"), sum(vsize("SHIPPING_CONTROL")), substrb(dump(min("SHIPPING_CONTROL"), 16, 0, 32), 1, 120), substrb(dump(max("SHIPPING_CONTROL"), 16, 0, 32), 1, 120), count("SOURCE_BLANKET_REFERENCE_ID"), count(distinct "SOURCE_BLANKET_REFERENCE_ID"), sum(vsize("SOURCE_BLANKET_REFERENCE_ID")), substrb(dump(min("SOURCE_BLANKET_REFE RENCE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SOURCE_BLANKET_REFERENCE_ID"), 16, 0, 32), 1, 120), count("SOURCE_BLANKET_REFERENCE_NUM"), count(distinct "SOURCE_BLANKET_REFERENCE_NUM"), sum(vsize("SOURCE_BLANKET_REFERENCE_NUM")), substrb(dump(min("SOURCE_BLANKET_REFERENCE_NUM"), 16, 0, 32), 1, 120), substrb(dump(max("SOURCE_BLANKET_REFERENCE_NUM"), 16, 0, 32), 1, 120), count("PO_SHIPMENT_LINE_ID"), count(distinct "PO_SHIPMENT_LINE_ID"), sum(vsize("PO_SHIPMENT_LINE_ID")), substrb(dump(min("PO _SHIPMENT_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PO_SHIPMENT_LINE_ID"), 16, 0, 32), 1, 120), count("PO_SHIPMENT_LINE_NUMBER"), count(distinct "PO_SHIPMENT_LINE_NUMBER"), sum(vsize("PO_SHIPMENT_LINE_NUMBER")), substrb(dump(min("PO_SHIPMENT_LINE_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("PO_SHIPMENT_LINE_NUMBER"), 16, 0, 32), 1, 120), count("SCHEDULED_QUANTITY"), count(distinct "SCHEDULED_QUANTITY"), sum(vsize("SCHEDULED_QUANTITY")), substrb(dump(min("SCHEDULED_QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("SCHEDULED_QUANTITY"), 16, 0, 32), 1, 120), count("RETURNED_QUANTITY"), count(distinct "RETURNED_QUANTITY"), sum(vsize("RETURNED_QUANTITY")), substrb(dump(min("RETURNED_QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("RETURNED_QUANTITY"), 16, 0, 32), 1, 120), count("SCHEDULED_QUANTITY2"), count(distinct "SCHEDULED_QUANTITY2"), sum(vsize("SCHEDULED_QUANTITY2")), substrb(dump(min("SCHEDULED_QUANTITY2"), 16, 0, 32), 1, 120), substrb(dump(max("SCHEDULED_QUANTITY2"), 16, 0, 32), 1, 120), count("RETURNED_QUANTITY2"), count(distinct "RETURNED_QUANTITY2"), sum(vsize("RETURNED_QUANTITY2")), substrb(dump(min("RETURNED_QUANTITY2"), 16, 0, 32), 1, 120), substrb(dump(max("RETURNED_QUANTITY2"), 16, 0, 32), 1, 120), count("SOURCE_LINE_TYPE_CODE"), count(distinct "SOURCE_LINE_TYPE_CODE"), sum(vsize("SOURCE_LINE_TYPE_CODE")), substrb(dump(min("SOURCE_LINE_TYPE_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("SOURCE_LINE_TYPE_CODE"), 16, 0, 32), 1, 120), count("RCV_SHIPMEN T_LINE_ID"), count(distinct "RCV_SHIPMENT_LINE_ID"), sum(vsize("RCV_SHIPMENT_LINE_ID")), substrb(dump(min("RCV_SHIPMENT_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RCV_SHIPMENT_LINE_ID"), 16, 0, 32), 1, 120), count("SUPPLIER_ITEM_NUMBER"), count(distinct "SUPPLIER_ITEM_NUMBER"), sum(vsize("SUPPLIER_ITEM_NUMBER")), substrb(dump(min(substrb("SUPPLIER_ITEM_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SUPPLIER_ITEM_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("FILLED_VOLUME "), count(distinct "FILLED_VOLUME"), sum(vsize("FILLED_VOLUME")), substrb(dump(min("FILLED_VOLUME"), 16, 0, 32), 1, 120), substrb(dump(max("FILLED_VOLUME"), 16, 0, 32), 1, 120), count("UNIT_WEIGHT"), count(distinct "UNIT_WEIGHT"), sum(vsize("UNIT_WEIGHT")), substrb(dump(min("UNIT_WEIGHT"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_WEIGHT"), 16, 0, 32), 1, 120), count("UNIT_VOLUME"), count(distinct "UNIT_VOLUME"), sum(vsize("UNIT_VOLUME")), substrb(dump(min("UNIT_VOLUME"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_VOLUME"), 16, 0, 32), 1, 120), count("WV_FROZEN_FLAG"), count(distinct "WV_FROZEN_FLAG"), sum(vsize("WV_FROZEN_FLAG")), substrb(dump(min("WV_FROZEN_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("WV_FROZEN_FLAG"), 16, 0, 32), 1, 120), count("PO_REVISION_NUMBER"), count(distinct "PO_REVISION_NUMBER"), sum(vsize("PO_REVISION_NUMBER")), substrb(dump(min("PO_REVISION_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("PO_REVISION_NUMBER"), 16, 0, 32), 1, 120), count("RELEASE_REVIS ION_NUMBER"), count(distinct "RELEASE_REVISION_NUMBER"), sum(vsize("RELEASE_REVISION_NUMBER")), substrb(dump(min("RELEASE_REVISION_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("RELEASE_REVISION_NUMBER"), 16, 0, 32), 1, 120), sum(vsize("DELIVERY_DETAIL_ID")), substrb(dump(min("DELIVERY_DETAIL_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DELIVERY_DETAIL_ID"), 16, 0, 32), 1, 120), count(distinct "SOURCE_CODE"), sum(vsize("SOURCE_CODE")), substrb(dump(min("SOURCE_CODE"), 16, 0, 32), 1, 120), subs trb(dump(max("SOURCE_CODE"), 16, 0, 32), 1, 120), count("SOURCE_HEADER_ID"), count(distinct "SOURCE_HEADER_ID"), sum(vsize("SOURCE_HEADER_ID")), substrb(dump(min("SOURCE_HEADER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SOURCE_HEADER_ID"), 16, 0, 32), 1, 120), count(distinct "SOURCE_LINE_ID"), sum(vsize("SOURCE_LINE_ID")), substrb(dump(min("SOURCE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SOURCE_LINE_ID"), 16, 0, 32), 1, 120), count("SOURCE_HEADER_TYPE_ID"), count(distinct "SOURCE_HEAD ER_TYPE_ID"), sum(vsize("SOURCE_HEADER_TYPE_ID")), substrb(dump(min("SOURCE_HEADER_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SOURCE_HEADER_TYPE_ID"), 16, 0, 32), 1, 120), count("SOURCE_HEADER_TYPE_NAME"), count(distinct "SOURCE_HEADER_TYPE_NAME"), sum(vsize("SOURCE_HEADER_TYPE_NAME")), substrb(dump(min(substrb("SOURCE_HEADER_TYPE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_HEADER_TYPE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("CUST_PO_NUMBER"), count(distinct " CUST_PO_NUMBER"), sum(vsize("CUST_PO_NUMBER")), substrb(dump(min(substrb("CUST_PO_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CUST_PO_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("CUSTOMER_ID"), count(distinct "CUSTOMER_ID"), sum(vsize("CUSTOMER_ID")), substrb(dump(min("CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_ID"), 16, 0, 32), 1, 120), count("SOLD_TO_CONTACT_ID"), count(distinct "SOLD_TO_CONTACT_ID"), sum(vsize("SOLD_TO_CONTACT_ID")), substrb(dump(min( "SOLD_TO_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SOLD_TO_CONTACT_ID"), 16, 0, 32), 1, 120), count("INVENTORY_ITEM_ID"), count(distinct "INVENTORY_ITEM_ID"), sum(vsize("INVENTORY_ITEM_ID")), substrb(dump(min("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), count("ITEM_DESCRIPTION"), count(distinct "ITEM_DESCRIPTION"), sum(vsize("ITEM_DESCRIPTION")), substrb(dump(min(substrb("ITEM_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb (dump(max(substrb("ITEM_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count("SHIP_SET_ID"), count(distinct "SHIP_SET_ID"), sum(vsize("SHIP_SET_ID")), substrb(dump(min("SHIP_SET_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_SET_ID"), 16, 0, 32), 1, 120), count("ARRIVAL_SET_ID"), count(distinct "ARRIVAL_SET_ID"), sum(vsize("ARRIVAL_SET_ID")), substrb(dump(min("ARRIVAL_SET_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ARRIVAL_SET_ID"), 16, 0, 32), 1, 120), count("TOP_MODEL_LINE_ID"), count(distinc t "TOP_MODEL_LINE_ID"), sum(vsize("TOP_MODEL_LINE_ID")), substrb(dump(min("TOP_MODEL_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TOP_MODEL_LINE_ID"), 16, 0, 32), 1, 120), count("ATO_LINE_ID"), count(distinct "ATO_LINE_ID"), sum(vsize("ATO_LINE_ID")), substrb(dump(min("ATO_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ATO_LINE_ID"), 16, 0, 32), 1, 120), count("HOLD_CODE"), count(distinct "HOLD_CODE"), sum(vsize("HOLD_CODE")), substrb(dump(min("HOLD_CODE"), 16, 0, 32), 1, 120), substrb(d ump(max("HOLD_CODE"), 16, 0, 32), 1, 120), count("SHIP_MODEL_COMPLETE_FLAG"), count(distinct "SHIP_MODEL_COMPLETE_FLAG"), sum(vsize("SHIP_MODEL_COMPLETE_FLAG")), substrb(dump(min("SHIP_MODEL_COMPLETE_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_MODEL_COMPLETE_FLAG"), 16, 0, 32), 1, 120), count("HAZARD_CLASS_ID"), count(distinct "HAZARD_CLASS_ID"), sum(vsize("HAZARD_CLASS_ID")), substrb(dump(min("HAZARD_CLASS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("HAZARD_CLASS_ID"), 16, 0, 32), 1, 12 0), count("COUNTRY_OF_ORIGIN"), count(distinct "COUNTRY_OF_ORIGIN"), sum(vsize("COUNTRY_OF_ORIGIN")), substrb(dump(min(substrb("COUNTRY_OF_ORIGIN", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("COUNTRY_OF_ORIGIN", 1, 32)), 16, 0, 32), 1, 120), count("CLASSIFICATION"), count(distinct "CLASSIFICATION"), sum(vsize("CLASSIFICATION")), substrb(dump(min("CLASSIFICATION"), 16, 0, 32), 1, 120), substrb(dump(max("CLASSIFICATION"), 16, 0, 32), 1, 120), count(distinct "SHIP_FROM_LOCATION_ID"), su m(vsize("SHIP_FROM_LOCATION_ID")), substrb(dump(min("SHIP_FROM_LOCATION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_FROM_LOCATION_ID"), 16, 0, 32), 1, 120), count("ORGANIZATION_ID"), count(distinct "ORGANIZATION_ID"), sum(vsize("ORGANIZATION_ID")), substrb(dump(min("ORGANIZATION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORGANIZATION_ID"), 16, 0, 32), 1, 120), count("SHIP_TO_LOCATION_ID"), count(distinct "SHIP_TO_LOCATION_ID"), sum(vsize("SHIP_TO_LOCATION_ID")), substrb(dump(min("SHIP_TO _LOCATION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_TO_LOCATION_ID"), 16, 0, 32), 1, 120), count("SHIP_TO_CONTACT_ID"), count(distinct "SHIP_TO_CONTACT_ID"), sum(vsize("SHIP_TO_CONTACT_ID")), substrb(dump(min("SHIP_TO_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_TO_CONTACT_ID"), 16, 0, 32), 1, 120), count("DELIVER_TO_LOCATION_ID"), count(distinct "DELIVER_TO_LOCATION_ID"), sum(vsize("DELIVER_TO_LOCATION_ID")), substrb(dump(min("DELIVER_TO_LOCATION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DELIVER_TO_LOCATION_ID"), 16, 0, 32), 1, 120), count("DELIVER_TO_CONTACT_ID"), count(distinct "DELIVER_TO_CONTACT_ID"), sum(vsize("DELIVER_TO_CONTACT_ID")), substrb(dump(min("DELIVER_TO_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DELIVER_TO_CONTACT_ID"), 16, 0, 32), 1, 120), count("INTMED_SHIP_TO_LOCATION_ID"), count(distinct "INTMED_SHIP_TO_LOCATION_ID"), sum(vsize("INTMED_SHIP_TO_LOCATION_ID")), substrb(dump(min("INTMED_SHIP_TO_LOCATION_ID"), 16, 0, 32), 1, 120), sub strb(dump(max("INTMED_SHIP_TO_LOCATION_ID"), 16, 0, 32), 1, 120), count("INTMED_SHIP_TO_CONTACT_ID"), count(distinct "INTMED_SHIP_TO_CONTACT_ID"), sum(vsize("INTMED_SHIP_TO_CONTACT_ID")), substrb(dump(min("INTMED_SHIP_TO_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTMED_SHIP_TO_CONTACT_ID"), 16, 0, 32), 1, 120), count("SHIP_TOLERANCE_ABOVE"), count(distinct "SHIP_TOLERANCE_ABOVE"), sum(vsize("SHIP_TOLERANCE_ABOVE")), substrb(dump(min("SHIP_TOLERANCE_ABOVE"), 16, 0, 32), 1, 120), substr b(dump(max("SHIP_TOLERANCE_ABOVE"), 16, 0, 32), 1, 120), count("SHIP_TOLERANCE_BELOW"), count(distinct "SHIP_TOLERANCE_BELOW"), sum(vsize("SHIP_TOLERANCE_BELOW")), substrb(dump(min("SHIP_TOLERANCE_BELOW"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_TOLERANCE_BELOW"), 16, 0, 32), 1, 120), count("SRC_REQUESTED_QUANTITY"), count(distinct "SRC_REQUESTED_QUANTITY"), sum(vsize("SRC_REQUESTED_QUANTITY")), substrb(dump(min("SRC_REQUESTED_QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("SRC_REQUESTED_ QUANTITY"), 16, 0, 32), 1, 120), count("SRC_REQUESTED_QUANTITY_UOM"), count(distinct "SRC_REQUESTED_QUANTITY_UOM"), sum(vsize("SRC_REQUESTED_QUANTITY_UOM")), substrb(dump(min("SRC_REQUESTED_QUANTITY_UOM"), 16, 0, 32), 1, 120), substrb(dump(max("SRC_REQUESTED_QUANTITY_UOM"), 16, 0, 32), 1, 120), count("CANCELLED_QUANTITY"), count(distinct "CANCELLED_QUANTITY"), sum(vsize("CANCELLED_QUANTITY")), substrb(dump(min("CANCELLED_QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("CANCELLED_QUANTITY"), 16 , 0, 32), 1, 120), count(distinct "REQUESTED_QUANTITY"), sum(vsize("REQUESTED_QUANTITY")), substrb(dump(min("REQUESTED_QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("REQUESTED_QUANTITY"), 16, 0, 32), 1, 120), count(distinct "REQUESTED_QUANTITY_UOM"), sum(vsize("REQUESTED_QUANTITY_UOM")), substrb(dump(min("REQUESTED_QUANTITY_UOM"), 16, 0, 32), 1, 120), substrb(dump(max("REQUESTED_QUANTITY_UOM"), 16, 0, 32), 1, 120), count("SHIPPED_QUANTITY"), count(distinct "SHIPPED_QUANTITY"), sum(vsize("SHI PPED_QUANTITY")), substrb(dump(min("SHIPPED_QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("SHIPPED_QUANTITY"), 16, 0, 32), 1, 120), count("DELIVERED_QUANTITY"), count(distinct "DELIVERED_QUANTITY"), sum(vsize("DELIVERED_QUANTITY")), substrb(dump(min("DELIVERED_QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("DELIVERED_QUANTITY"), 16, 0, 32), 1, 120), count("QUALITY_CONTROL_QUANTITY"), count(distinct "QUALITY_CONTROL_QUANTITY"), sum(vsize("QUALITY_CONTROL_QUANTITY")), substrb(dump(min("QUAL ITY_CONTROL_QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("QUALITY_CONTROL_QUANTITY"), 16, 0, 32), 1, 120), count("CYCLE_COUNT_QUANTITY"), count(distinct "CYCLE_COUNT_QUANTITY"), sum(vsize("CYCLE_COUNT_QUANTITY")), substrb(dump(min("CYCLE_COUNT_QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("CYCLE_COUNT_QUANTITY"), 16, 0, 32), 1, 120), count("MOVE_ORDER_LINE_ID"), count(distinct "MOVE_ORDER_LINE_ID"), sum(vsize("MOVE_ORDER_LINE_ID")), substrb(dump(min("MOVE_ORDER_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MOVE_ORDER_LINE_ID"), 16, 0, 32), 1, 120), count("SUBINVENTORY"), count(distinct "SUBINVENTORY"), sum(vsize("SUBINVENTORY")), substrb(dump(min("SUBINVENTORY"), 16, 0, 32), 1, 120), substrb(dump(max("SUBINVENTORY"), 16, 0, 32), 1, 120), count("REVISION"), count(distinct "REVISION"), sum(vsize("REVISION")), substrb(dump(min("REVISION"), 16, 0, 32), 1, 120), substrb(dump(max("REVISION"), 16, 0, 32), 1, 120), count("LOT_NUMBER"), count(distinct "LOT_NUMBER"), sum(vsize("LOT_ NUMBER")), substrb(dump(min("LOT_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("LOT_NUMBER"), 16, 0, 32), 1, 120), count("RELEASED_STATUS"), count(distinct "RELEASED_STATUS"), sum(vsize("RELEASED_STATUS")), substrb(dump(min("RELEASED_STATUS"), 16, 0, 32), 1, 120), substrb(dump(max("RELEASED_STATUS"), 16, 0, 32), 1, 120), count("CUSTOMER_REQUESTED_LOT_FLAG"), count(distinct "CUSTOMER_REQUESTED_LOT_FLAG"), sum(vsize("CUSTOMER_REQUESTED_LOT_FLAG")), substrb(dump(min("CUSTOMER_REQUESTED_LOT_FLAG") , 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_REQUESTED_LOT_FLAG"), 16, 0, 32), 1, 120), count("SERIAL_NUMBER"), count(distinct "SERIAL_NUMBER"), sum(vsize("SERIAL_NUMBER")), substrb(dump(min("SERIAL_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("SERIAL_NUMBER"), 16, 0, 32), 1, 120), count("LOCATOR_ID"), count(distinct "LOCATOR_ID"), sum(vsize("LOCATOR_ID")), substrb(dump(min("LOCATOR_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LOCATOR_ID"), 16, 0, 32), 1, 120), count("DATE_REQUESTED"), c ount(distinct "DATE_REQUESTED"), substrb(dump(min("DATE_REQUESTED"), 16, 0, 32), 1, 120), substrb(dump(max("DATE_REQUESTED"), 16, 0, 32), 1, 120), count("DATE_SCHEDULED"), count(distinct "DATE_SCHEDULED"), substrb(dump(min("DATE_SCHEDULED"), 16, 0, 32), 1, 120), substrb(dump(max("DATE_SCHEDULED"), 16, 0, 32), 1, 120), count("MASTER_CONTAINER_ITEM_ID"), count(distinct "MASTER_CONTAINER_ITEM_ID"), sum(vsize("MASTER_CONTAINER_ITEM_ID")), substrb(dump(min("MASTER_CONTAINER_ITEM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MASTER_CONTAINER_ITEM_ID"), 16, 0, 32), 1, 120), count("DETAIL_CONTAINER_ITEM_ID"), count(distinct "DETAIL_CONTAINER_ITEM_ID"), sum(vsize("DETAIL_CONTAINER_ITEM_ID")), substrb(dump(min("DETAIL_CONTAINER_ITEM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DETAIL_CONTAINER_ITEM_ID"), 16, 0, 32), 1, 120), count("LOAD_SEQ_NUMBER"), count(distinct "LOAD_SEQ_NUMBER"), sum(vsize("LOAD_SEQ_NUMBER")), substrb(dump(min("LOAD_SEQ_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("LOAD_S EQ_NUMBER"), 16, 0, 32), 1, 120), count("SHIP_METHOD_CODE"), count(distinct "SHIP_METHOD_CODE"), sum(vsize("SHIP_METHOD_CODE")), substrb(dump(min("SHIP_METHOD_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_METHOD_CODE"), 16, 0, 32), 1, 120), count("CARRIER_ID"), count(distinct "CARRIER_ID"), sum(vsize("CARRIER_ID")), substrb(dump(min("CARRIER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CARRIER_ID"), 16, 0, 32), 1, 120), count("FREIGHT_TERMS_CODE"), count(distinct "FREIGHT_TERMS_CODE"), sum (vsize("FREIGHT_TERMS_CODE")), substrb(dump(min("FREIGHT_TERMS_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("FREIGHT_TERMS_CODE"), 16, 0, 32), 1, 120), count("SHIPMENT_PRIORITY_CODE"), count(distinct "SHIPMENT_PRIORITY_CODE"), sum(vsize("SHIPMENT_PRIORITY_CODE")), substrb(dump(min("SHIPMENT_PRIORITY_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("SHIPMENT_PRIORITY_CODE"), 16, 0, 32), 1, 120), count("FOB_CODE"), count(distinct "FOB_CODE"), sum(vsize("FOB_CODE")), substrb(dump(min("FOB_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("FOB_CODE"), 16, 0, 32), 1, 120), count("CUSTOMER_ITEM_ID"), count(distinct "CUSTOMER_ITEM_ID"), sum(vsize("CUSTOMER_ITEM_ID")), substrb(dump(min("CUSTOMER_ITEM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_ITEM_ID"), 16, 0, 32), 1, 120), count("DEP_PLAN_REQUIRED_FLAG"), count(distinct "DEP_PLAN_REQUIRED_FLAG"), sum(vsize("DEP_PLAN_REQUIRED_FLAG")), substrb(dump(min("DEP_PLAN_REQUIRED_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("DEP_PLAN_REQUIRED_FLAG "), 16, 0, 32), 1, 120), count("CUSTOMER_PROD_SEQ"), count(distinct "CUSTOMER_PROD_SEQ"), sum(vsize("CUSTOMER_PROD_SEQ")), substrb(dump(min(substrb("CUSTOMER_PROD_SEQ", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CUSTOMER_PROD_SEQ", 1, 32)), 16, 0, 32), 1, 120), count("CUSTOMER_DOCK_CODE"), count(distinct "CUSTOMER_DOCK_CODE"), sum(vsize("CUSTOMER_DOCK_CODE")), substrb(dump(min(substrb("CUSTOMER_DOCK_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CUSTOMER_DOCK_CODE", 1, 32)), 16, 0, 32), 1, 120), count("NET_WEIGHT"), count(distinct "NET_WEIGHT"), sum(vsize("NET_WEIGHT")), substrb(dump(min("NET_WEIGHT"), 16, 0, 32), 1, 120), substrb(dump(max("NET_WEIGHT"), 16, 0, 32), 1, 120), count("WEIGHT_UOM_CODE"), count(distinct "WEIGHT_UOM_C????????????????????????????????????????????????????????????????????????????? ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ?????????????????????????????????????????ATEGORY"), count(distinct "TP_ATTRIBUTE_CATEGORY"), sum(vsize("TP_ATTRIBUTE_CATEGORY")), substrb(dump(min(substrb("TP_ATTRIBUTE_CATEGORY", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TP_ATTRIBUTE_CATEGORY", 1, 32)), 16, 0, 32), 1, 120), count("TP_ATTRIBUTE1"), count(distinct "TP_ATTRIBUTE1"), sum(vsize("TP_ATTRIBUTE1")), substrb(dump(min(substrb("TP_ATTRIBUTE1", 6, 0, 32), 1, 120), count("TP_ATTRIBUTE2"), count(distinct "TP_ATTRIBUTE2"), sum(vsize("TP_ATTRIBUTE2")), substrb(dump(min(substrb("TP_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TP_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("TP_ATTRIBUTE3"), count(distinct "TP_ATTRIBUTE3"), sum(vsize("TP_ATTRIBUTE3")), substrb(dump(min(substrb("TP_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TP_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("TP_ATTRIBUTE4 "), count(distinct "TP_ATTRIBUTE4"), sum(vsize("TP_ATTRIBUTE4")), substrb(dump(min(substrb("TP_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TP_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("TP_ATTRIBUTE5"), count(distinct "TP_ATTRIBUTE5"), sum(vsize("TP_ATTRIBUTE5")), substrb(dump(min(substrb("TP_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TP_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("TP_ATTRIBUTE6"), count(distinct "TP_ATTRIBUTE6"), sum (vsize("TP_ATTRIBUTE6")), substrb(dump(min(substrb("TP_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TP_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120) from "WSH"."WSH_DELIVERY_DETAILS" t
gf1u933c95jb5 DECLARE l_ret_stat varchar2(56); BEGIN CSI_INV_TXN_HOOK_PKG.postTransaction( p_header_id => :1 , p_transaction_id => :2 , x_return_status => l_ret_stat ); INV_TXNSTUB_PUB.g_ret_status := l_ret_stat; END;
ghw9svn8x4vzu BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS( :errbuf, :rc, :A0, :A1, :A2); END;
gk43kd7q5mak4 update ra_customer_trx_lines l set (vat_tax_id, amount_includes_tax_flag) = (select :VAT_TAX_ID, decode(:AMOUNT_INCLUDES_TAX_OVERRIDE, 'N', :AMOUNT_INCLUDES_TAX_FLAG, NVL(l.amount_includes_tax_flag, :AMOUNT_INCLUDES_TAX_FLAG) ) from dual ) where customer_trx_line_id=:LINE_ID and line_type ='LINE'
gnhmcahkmrnzs INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 1,596,546 428.47 2.04
CPU used when call started 1,601,117 429.70 2.05
CR blocks created 13,206,183 3,544.19 16.91
Cached Commit SCN referenced 985,263 264.42 1.26
Commit SCN cached 461 0.12 0.00
DB time 10,261,735 2,753.98 13.14
DBWR checkpoint buffers written 1,290,408 346.31 1.65
DBWR checkpoints 37 0.01 0.00
DBWR object drop buffers written 58,877 15.80 0.08
DBWR revisited being-written buffer 1,021 0.27 0.00
DBWR thread checkpoint buffers written 102,883 27.61 0.13
DBWR transaction table writes 5,177 1.39 0.01
DBWR undo block writes 1,468,999 394.24 1.88
DFO trees parallelized 17 0.00 0.00
IMU CR rollbacks 33,351,629 8,950.70 42.70
IMU Flushes 265,602 71.28 0.34
IMU Redo allocation size 1,770,772,304 475,228.53 2,267.01
IMU bind flushes 777 0.21 0.00
IMU commits 403,055 108.17 0.52
IMU contention 28,935 7.77 0.04
IMU ktichg flush 8,263 2.22 0.01
IMU pool not allocated 161 0.04 0.00
IMU recursive-transaction flush 1,098 0.29 0.00
IMU undo allocation size 3,681,335,192 987,973.16 4,712.98
IMU- failed to get a private strand 161 0.04 0.00
PX local messages recv'd 18,056 4.85 0.02
PX local messages sent 18,056 4.85 0.02
Parallel operations downgraded 25 to 50 pct 15 0.00 0.00
Parallel operations downgraded to serial 19 0.01 0.00
Parallel operations not downgraded 2 0.00 0.00
SQL*Net roundtrips to/from client 25,584,794 6,866.28 32.75
active txn count during cleanout 58,042,116 15,576.97 74.31
application wait time 77,244 20.73 0.10
background checkpoints completed 2 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 10,660 2.86 0.01
branch node splits 925 0.25 0.00
buffer is not pinned count 546,884,982 146,769.49 700.14
buffer is pinned count 1,178,933,657 316,394.66 1,509.31
bytes received via SQL*Net from client 5,907,600,868 1,585,444.08 7,563.12
bytes sent via SQL*Net to client 5,721,510,173 1,535,502.25 7,324.88
calls to get snapshot scn: kcmgss 78,513,342 21,070.91 100.52
calls to kcmgas 16,494,845 4,426.78 21.12
calls to kcmgcs 8,776,624 2,355.41 11.24
change write time 66,533 17.86 0.09
cleanout - number of ktugct calls 21,183,030 5,684.97 27.12
cluster key scan block gets 507,921 136.31 0.65
cluster key scans 85,508 22.95 0.11
commit cleanout failures: block lost 189,419 50.84 0.24
commit cleanout failures: buffer being written 119 0.03 0.00
commit cleanout failures: callback failure 95,401 25.60 0.12
commit cleanout failures: cannot pin 27,626 7.41 0.04
commit cleanouts 7,183,143 1,927.77 9.20
commit cleanouts successfully completed 6,870,578 1,843.88 8.80
commit txn count during cleanout 888,785 238.53 1.14
concurrency wait time 124,227 33.34 0.16
consistent changes 790,988,176 212,280.34 1,012.65
consistent gets 1,576,231,000 423,018.78 2,017.95
consistent gets - examination 1,162,058,050 311,865.70 1,487.71
consistent gets from cache 1,576,231,003 423,018.78 2,017.95
current blocks converted for CR 1,767 0.47 0.00
cursor authentications 2,512 0.67 0.00
data blocks consistent reads - undo records applied 788,126,022 211,512.21 1,008.99
db block changes 177,763,363 47,706.99 227.58
db block gets 198,620,777 53,304.57 254.28
db block gets direct 6,292 1.69 0.01
db block gets from cache 198,614,495 53,302.89 254.27
deferred (CURRENT) block cleanout applications 1,526,762 409.74 1.95
dirty buffers inspected 685,825 184.06 0.88
enqueue conversions 7,165 1.92 0.01
enqueue releases 6,426,471 1,724.70 8.23
enqueue requests 6,435,828 1,727.21 8.24
enqueue timeouts 9,092 2.44 0.01
enqueue waits 29,470 7.91 0.04
exchange deadlocks 5,931 1.59 0.01
execute count 66,129,504 17,747.41 84.66
failed probes on index block reclamation 12,039 3.23 0.02
free buffer inspected 4,552,774 1,221.84 5.83
free buffer requested 17,323,876 4,649.27 22.18
heap block compress 26,896,064 7,218.19 34.43
hot buffers moved to head of LRU 2,339,869 627.96 3.00
immediate (CR) block cleanout applications 11,835,641 3,176.37 15.15
immediate (CURRENT) block cleanout applications 1,013,643 272.04 1.30
index fast full scans (full) 192,174 51.57 0.25
index fast full scans (rowid ranges) 189 0.05 0.00
index fetch by key 149,251,346 40,055.12 191.08
index scans kdiixs1 100,417,431 26,949.39 128.56
java call heap collected bytes 765,536,232 205,449.71 980.07
java call heap collected count 10,291,689 2,762.02 13.18
java call heap gc count 956 0.26 0.00
java call heap live object count 182,034 48.85 0.23
java call heap live object count max 182,874 49.08 0.23
java call heap live size 44,472,376 11,935.21 56.94
java call heap live size max 44,613,576 11,973.11 57.12
java call heap object count 4,137,280 1,110.34 5.30
java call heap object count max 4,142,513 1,111.74 5.30
java call heap total size 155,189,248 41,648.70 198.68
java call heap total size max 155,189,248 41,648.70 198.68
java call heap used size 335,421,616 90,018.30 429.42
java call heap used size max 336,135,248 90,209.82 430.33
leaf node 90-10 splits 17,518 4.70 0.02
leaf node splits 219,901 59.02 0.28
logons cumulative 5,492 1.47 0.01
messages received 799,673 214.61 1.02
messages sent 799,673 214.61 1.02
no buffer to keep pinned count 18 0.00 0.00
no work - consistent read gets 310,319,488 83,281.56 397.28
opened cursors cumulative 5,049,282 1,355.09 6.46
parse count (failures) 1,736 0.47 0.00
parse count (hard) 6,647 1.78 0.01
parse count (total) 6,481,472 1,739.46 8.30
parse time cpu 46,673 12.53 0.06
parse time elapsed 86,346 23.17 0.11
physical read IO requests 677,638 181.86 0.87
physical reads 857,997 230.26 1.10
physical reads cache 792,107 212.58 1.01
physical reads cache prefetch 123,356 33.11 0.16
physical reads direct 65,890 17.68 0.08
physical reads direct temporary tablespace 65,470 17.57 0.08
physical reads prefetch warmup 35,411 9.50 0.05
physical write IO requests 969,841 260.28 1.24
physical writes 2,556,086 685.99 3.27
physical writes direct 71,982 19.32 0.09
physical writes direct (lob) 2,464 0.66 0.00
physical writes direct temporary tablespace 69,218 18.58 0.09
physical writes from cache 2,484,104 666.67 3.18
physical writes non checkpoint 2,261,791 607.00 2.90
pinned buffers inspected 4,512 1.21 0.01
prefetch warmup blocks aged out before use 192,342 51.62 0.25
prefetched blocks aged out before use 1,187 0.32 0.00
process last non-idle time 3,729 1.00 0.00
queries parallelized 17 0.00 0.00
recursive aborts on index block reclamation 214 0.06 0.00
recursive calls 112,153,390 30,099.01 143.58
recursive cpu usage 971,912 260.84 1.24
redo blocks written 58,868,534 15,798.76 75.37
redo buffer allocation retries 13 0.00 0.00
redo entries 92,139,342 24,727.77 117.96
redo log space requests 23 0.01 0.00
redo log space wait time 34 0.01 0.00
redo ordering marks 1,212,460 325.39 1.55
redo size 28,912,234,492 7,759,280.29 37,014.48
redo synch time 67,222 18.04 0.09
redo synch writes 298,733 80.17 0.38
redo wastage 242,614,040 65,111.20 310.60
redo write time 74,665 20.04 0.10
redo writer latching time 381 0.10 0.00
redo writes 565,170 151.68 0.72
rollback changes - undo records applied 148,564 39.87 0.19
rows fetched via callback 115,786,943 31,074.16 148.23
session connect time 0 0.00 0.00
session cursor cache hits 2,749,658 737.94 3.52
session logical reads 1,774,851,745 476,323.34 2,272.23
session pga memory 6,823,992,560 1,831,379.41 8,736.32
session pga memory max 8,285,325,968 2,223,562.71 10,607.17
session uga memory 10,106,908,736 2,712,427.42 12,939.23
session uga memory max 42,999,271,600 11,539,869.07 55,049.21
shared hash latch upgrades - no wait 114,488,693 30,725.74 146.57
shared hash latch upgrades - wait 226,379 60.75 0.29
sorts (disk) 4 0.00 0.00
sorts (memory) 8,685,666 2,331.00 11.12
sorts (rows) 193,050,960 51,809.78 247.15
summed dirty queue length 2,660,057 713.89 3.41
switch current to new buffer 1,039,535 278.98 1.33
table fetch by rowid 734,062,568 197,003.01 939.77
table fetch continued row 29,673,787 7,963.66 37.99
table scan blocks gotten 42,109,158 11,300.99 53.91
table scan rows gotten 1,185,862,436 318,254.16 1,518.18
table scans (long tables) 4,132 1.11 0.01
table scans (rowid ranges) 4,109 1.10 0.01
table scans (short tables) 4,021,764 1,079.34 5.15
transaction rollbacks 4,118 1.11 0.01
transaction tables consistent read rollbacks 38 0.01 0.00
transaction tables consistent reads - undo records applied 3,582 0.96 0.00
undo change vector size 10,067,332,412 2,701,806.18 12,888.56
user I/O wait time 282,772 75.89 0.36
user calls 24,575,700 6,595.47 31.46
user commits 647,458 173.76 0.83
user rollbacks 133,648 35.87 0.17
workarea executions - onepass 8 0.00 0.00
workarea executions - optimal 4,602,458 1,235.18 5.89
write clones created in background 886 0.24 0.00
write clones created in foreground 920 0.25 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 76,406 181,171
opened cursors current 476,811 628,152
workarea memory allocated 618 987
logons current 2,664 2,693

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 1 0.97

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_UNDOTS1 18,055 5 1.18 1.00 576,808 155 209,037 0.14
APPS_TS_TX_DATA 352,175 95 4.38 1.10 112,782 30 79,873 0.52
APPS_TS_TX_IDX 176,401 47 4.71 1.07 93,160 25 51,442 0.51
APPS_ASSM_DATA 72,569 19 1.49 1.75 83,188 22 175,571 0.41
APPS_ASSM_IDX 27,358 7 2.68 1.02 59,980 16 70,345 0.42
TEMP 10,651 3 18.46 6.66 14,972 4 0 0.00
APPS_TS_TX_INTERFACE 1,448 0 4.97 2.00 13,710 4 58,271 0.27
APPS_TS_SEED 8,406 2 6.04 1.21 3,033 1 1,231 2.78
SYSTEM 8,426 2 3.66 2.71 1,903 1 9,695 0.60
APPS_TS_QUEUES 628 0 6.85 1.16 4,948 1 82 25.49
APPS_TS_SUMMARY 180 0 10.11 1.00 2,755 1 2,002 0.33
CTXSYS 505 0 5.88 1.08 1,424 0 2 0.00
APPS_TS_ARCHIVE 198 0 5.15 1.00 557 0 45 8.89
SYSAUX 401 0 3.22 1.91 318 0 1 10.00
APPS_TS_NOLOGGING 42 0 16.90 1.33 51 0 2 0.00
APPS_TS_MEDIA 6 0 11.67 1.00 6 0 0 0.00
ODM 5 0 8.00 1.00 2 0 0 0.00
OLAP 5 0 48.00 1.00 2 0 0 0.00
OWAPUB 5 0 10.00 1.00 2 0 0 0.00
PORTAL 5 0 10.00 1.00 2 0 0 0.00
SYNCSERVER 5 0 60.00 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_ASSM_DATA /oasb_data/apps_assm_data.dbf 72,569 19 1.49 1.75 83,188 22 175,571 0.41
APPS_ASSM_IDX /oasb_data/apps_assm_idx.dbf 27,358 7 2.68 1.02 59,980 16 70,345 0.42
APPS_TS_ARCHIVE /oasb_data/archive1.dbf 92 0 4.35 1.00 271 0 27 7.41
APPS_TS_ARCHIVE /oasb_data/archive2.dbf 106 0 5.85 1.00 286 0 18 11.11
APPS_TS_MEDIA /oasb_data/media1.dbf 2 0 10.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /oasb_data/media2.dbf 2 0 15.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /oasb_data/media3.dbf 2 0 10.00 1.00 2 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging1.dbf 30 0 12.00 1.47 47 0 2 0.00
APPS_TS_NOLOGGING /oasb_data/nologging2.dbf 6 0 6.67 1.00 2 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging3.dbf 6 0 51.67 1.00 2 0 0 0.00
APPS_TS_QUEUES /oasb_data/queues1.dbf 25 0 6.40 1.00 380 0 0 0.00
APPS_TS_QUEUES /oasb_data/queues2.dbf 148 0 4.66 1.22 763 0 23 0.43
APPS_TS_QUEUES /oasb_data/queues3.dbf 95 0 4.42 1.11 814 0 14 0.71
APPS_TS_QUEUES /oasb_data/queues4.dbf 93 0 9.57 1.06 752 0 20 102.00
APPS_TS_QUEUES /oasb_data/queues5.dbf 88 0 4.09 1.16 745 0 2 0.00
APPS_TS_QUEUES /oasb_data/queues6.dbf 105 0 4.10 1.14 815 0 7 0.00
APPS_TS_QUEUES /oasb_data/queues7.dbf 74 0 18.24 1.27 679 0 16 1.88
APPS_TS_SEED /oasb_data/reference1.dbf 1,005 0 5.66 1.20 204 0 328 2.53
APPS_TS_SEED /oasb_data/reference10.dbf 637 0 7.39 1.24 256 0 0 0.00
APPS_TS_SEED /oasb_data/reference2.dbf 1,215 0 5.44 1.28 240 0 883 2.85
APPS_TS_SEED /oasb_data/reference3.dbf 810 0 5.38 1.23 360 0 11 6.36
APPS_TS_SEED /oasb_data/reference4.dbf 774 0 5.10 1.20 371 0 8 0.00
APPS_TS_SEED /oasb_data/reference5.dbf 843 0 7.40 1.16 329 0 0 0.00
APPS_TS_SEED /oasb_data/reference6.dbf 825 0 5.73 1.14 320 0 0 0.00
APPS_TS_SEED /oasb_data/reference7.dbf 739 0 7.55 1.22 320 0 0 0.00
APPS_TS_SEED /oasb_data/reference8.dbf 789 0 6.19 1.25 309 0 0 0.00
APPS_TS_SEED /oasb_data/reference9.dbf 769 0 5.19 1.17 324 0 1 0.00
APPS_TS_SUMMARY /oasb_data/summary1.dbf 16 0 3.75 1.00 309 0 278 0.36
APPS_TS_SUMMARY /oasb_data/summary2.dbf 5 0 50.00 1.00 81 0 9 0.00
APPS_TS_SUMMARY /oasb_data/summary3.dbf 50 0 13.20 1.00 391 0 293 0.96
APPS_TS_SUMMARY /oasb_data/summary4.dbf 24 0 2.08 1.00 356 0 273 0.07
APPS_TS_SUMMARY /oasb_data/summary5.dbf 6 0 38.33 1.00 348 0 405 0.35
APPS_TS_SUMMARY /oasb_data/summary6.dbf 11 0 28.18 1.00 404 0 266 0.11
APPS_TS_SUMMARY /oasb_data/summary7.dbf 26 0 2.69 1.00 432 0 269 0.33
APPS_TS_SUMMARY /oasb_data/summary8.dbf 42 0 4.52 1.00 434 0 209 0.00
APPS_TS_TX_DATA /oasb_data/tx_data1.dbf 1,339 0 3.76 1.23 4,243 1 3,754 0.50
APPS_TS_TX_DATA /oasb_data/tx_data10.dbf 1,293 0 3.60 1.24 4,331 1 3,768 0.48
APPS_TS_TX_DATA /oasb_data/tx_data11.dbf 8,725 2 1.04 1.04 8,203 2 4,558 0.91
APPS_TS_TX_DATA /oasb_data/tx_data12.dbf 31,033 8 4.22 1.07 6,124 2 3,003 1.17
APPS_TS_TX_DATA /oasb_data/tx_data13.dbf 31,007 8 5.00 1.07 6,029 2 3,830 0.26
APPS_TS_TX_DATA /oasb_data/tx_data14.dbf 30,724 8 4.82 1.06 5,882 2 3,242 0.27
APPS_TS_TX_DATA /oasb_data/tx_data15.dbf 30,506 8 4.29 1.07 6,108 2 3,571 0.19
APPS_TS_TX_DATA /oasb_data/tx_data16.dbf 30,700 8 4.22 1.06 6,099 2 3,475 0.24
APPS_TS_TX_DATA /oasb_data/tx_data17.dbf 30,605 8 4.48 1.07 5,959 2 3,432 0.35
APPS_TS_TX_DATA /oasb_data/tx_data18.dbf 30,561 8 4.99 1.06 5,960 2 3,372 0.22
APPS_TS_TX_DATA /oasb_data/tx_data19.dbf 30,405 8 4.93 1.08 5,792 2 3,049 0.27
APPS_TS_TX_DATA /oasb_data/tx_data2.dbf 1,636 0 2.78 1.99 4,388 1 4,095 0.81
APPS_TS_TX_DATA /oasb_data/tx_data20.dbf 30,297 8 4.32 1.06 5,806 2 3,587 0.21
APPS_TS_TX_DATA /oasb_data/tx_data21.dbf 30,247 8 4.19 1.07 5,806 2 2,975 0.24
APPS_TS_TX_DATA /oasb_data/tx_data3.dbf 2,274 1 3.67 1.73 4,771 1 4,042 0.81
APPS_TS_TX_DATA /oasb_data/tx_data4.dbf 2,621 1 3.52 1.61 4,679 1 3,807 0.68
APPS_TS_TX_DATA /oasb_data/tx_data5.dbf 9,966 3 3.97 1.19 4,348 1 4,043 0.70
APPS_TS_TX_DATA /oasb_data/tx_data6.dbf 3,445 1 4.14 1.45 4,414 1 4,260 0.62
APPS_TS_TX_DATA /oasb_data/tx_data7.dbf 9,777 3 3.96 1.19 4,483 1 4,580 0.54
APPS_TS_TX_DATA /oasb_data/tx_data8.dbf 2,401 1 3.43 1.65 4,948 1 5,067 0.58
APPS_TS_TX_DATA /oasb_data/tx_data9.dbf 2,613 1 2.99 1.58 4,409 1 4,363 0.56
APPS_TS_TX_IDX /oasb_data/tx_idx1.dbf 1,229 0 4.48 1.05 2,022 1 1,650 0.72
APPS_TS_TX_IDX /oasb_data/tx_idx10.dbf 1,727 0 7.48 1.06 4,720 1 1,249 0.61
APPS_TS_TX_IDX /oasb_data/tx_idx11.dbf 1,741 0 6.05 1.04 3,522 1 2,484 1.65
APPS_TS_TX_IDX /oasb_data/tx_idx12.dbf 14,936 4 4.98 1.06 6,191 2 2,638 0.24
APPS_TS_TX_IDX /oasb_data/tx_idx13.dbf 14,735 4 5.31 1.07 6,131 2 2,606 0.48
APPS_TS_TX_IDX /oasb_data/tx_idx14.dbf 14,749 4 4.36 1.07 6,246 2 2,941 0.29
APPS_TS_TX_IDX /oasb_data/tx_idx15.dbf 14,868 4 4.16 1.07 6,192 2 2,754 0.38
APPS_TS_TX_IDX /oasb_data/tx_idx16.dbf 14,524 4 4.29 1.06 5,742 2 2,450 0.16
APPS_TS_TX_IDX /oasb_data/tx_idx17.dbf 14,653 4 5.28 1.06 5,767 2 2,175 0.21
APPS_TS_TX_IDX /oasb_data/tx_idx18.dbf 14,716 4 5.70 1.07 5,846 2 2,300 0.28
APPS_TS_TX_IDX /oasb_data/tx_idx19.dbf 14,655 4 4.49 1.07 5,875 2 2,368 0.30
APPS_TS_TX_IDX /oasb_data/tx_idx2.dbf 1,706 0 3.45 1.17 3,007 1 6,255 0.57
APPS_TS_TX_IDX /oasb_data/tx_idx20.dbf 14,484 4 4.40 1.06 5,600 2 2,816 0.32
APPS_TS_TX_IDX /oasb_data/tx_idx21.dbf 14,504 4 4.44 1.06 5,830 2 3,136 0.19
APPS_TS_TX_IDX /oasb_data/tx_idx3.dbf 2,585 1 3.45 1.14 3,757 1 1,541 0.76
APPS_TS_TX_IDX /oasb_data/tx_idx4.dbf 3,554 1 4.59 1.11 3,211 1 1,528 0.81
APPS_TS_TX_IDX /oasb_data/tx_idx5.dbf 3,588 1 4.68 1.10 2,796 1 1,647 0.64
APPS_TS_TX_IDX /oasb_data/tx_idx6.dbf 3,541 1 4.77 1.10 2,888 1 1,678 0.60
APPS_TS_TX_IDX /oasb_data/tx_idx7.dbf 3,375 1 4.12 1.11 2,493 1 2,230 0.81
APPS_TS_TX_IDX /oasb_data/tx_idx8.dbf 3,244 1 3.93 1.11 3,031 1 2,459 0.76
APPS_TS_TX_IDX /oasb_data/tx_idx9.dbf 3,287 1 4.12 1.11 2,293 1 2,537 0.32
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte.dbf 619 0 3.89 2.28 2,981 1 13,297 0.47
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte2.dbf 210 0 6.52 1.66 2,289 1 12,225 0.24
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte3.dbf 195 0 4.97 1.68 2,152 1 9,230 0.16
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte4.dbf 178 0 5.45 1.68 2,095 1 9,467 0.25
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte5.dbf 150 0 4.47 1.98 2,156 1 7,176 0.14
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte6.dbf 96 0 8.44 2.22 2,037 1 6,876 0.29
APPS_UNDOTS1 /oasb_data/undo01.dbf 375 0 1.23 1.00 14,122 4 10,198 0.12
APPS_UNDOTS1 /oasb_data/undo02.dbf 586 0 1.14 1.00 15,430 4 16,227 0.16
APPS_UNDOTS1 /oasb_data/undo03.dbf 580 0 1.45 1.00 17,000 5 19,659 0.29
APPS_UNDOTS1 /oasb_data/undo04.dbf 677 0 1.61 1.00 19,012 5 13,188 0.10
APPS_UNDOTS1 /oasb_data/undo05.dbf 4,318 1 0.94 1.00 112,606 30 28,757 0.13
APPS_UNDOTS1 /oasb_data/undo06.dbf 3,253 1 1.17 1.00 107,356 29 30,679 0.13
APPS_UNDOTS1 /oasb_data/undo07.dbf 2,467 1 1.71 1.00 95,581 26 30,494 0.13
APPS_UNDOTS1 /oasb_data/undo08.dbf 2,448 1 1.42 1.00 95,934 26 31,136 0.11
APPS_UNDOTS1 /oasb_data/undo09.dbf 3,351 1 0.81 1.00 99,767 27 28,699 0.14
CTXSYS /oasb_data/ctx1.dbf 87 0 5.06 1.28 191 0 2 0.00
CTXSYS /oasb_data/ctx2.dbf 418 0 6.05 1.04 1,233 0 0 0.00
ODM /oasb_data/odm.dbf 5 0 8.00 1.00 2 0 0 0.00
OLAP /oasb_data/olap.dbf 5 0 48.00 1.00 2 0 0 0.00
OWAPUB /oasb_data/owa1.dbf 5 0 10.00 1.00 2 0 0 0.00
PORTAL /oasb_data/portal.dbf 5 0 10.00 1.00 2 0 0 0.00
SYNCSERVER /oasb_data/mobile01.dbf 5 0 60.00 1.00 2 0 0 0.00
SYSAUX /oasb_data/sysaux01.dbf 192 0 2.45 1.79 165 0 1 10.00
SYSAUX /oasb_data/sysaux02.dbf 209 0 3.92 2.02 153 0 0 0.00
SYSTEM /oasb_data/sys1.dbf 1,108 0 3.29 2.73 174 0 325 0.95
SYSTEM /oasb_data/sys2.dbf 1,361 0 3.78 2.45 221 0 335 1.19
SYSTEM /oasb_data/sys3.dbf 1,142 0 3.52 2.81 260 0 342 1.84
SYSTEM /oasb_data/sys4.dbf 1,384 0 3.77 2.61 416 0 482 0.33
SYSTEM /oasb_data/sys5.dbf 1,302 0 4.07 2.89 369 0 2,643 0.39
SYSTEM /oasb_data/sys6.dbf 1,065 0 3.32 2.78 258 0 2,635 0.33
SYSTEM /oasb_data/sys7.dbf 1,034 0 3.69 2.81 154 0 844 0.73
SYSTEM /oasb_data/sys8.dbf 15 0 4.00 1.27 33 0 1,848 0.88
SYSTEM /oasb_data/sys9.dbf 15 0 6.67 1.07 18 0 241 0.62
TEMP /oasb_data/tmp1.dbf 585 0 2.67 2.39 2,796 1 0  
TEMP /oasb_data/tmp2.dbf 3,038 1 18.52 5.47 3,152 1 0  
TEMP /oasb_data/tmp3.dbf 5,129 1 24.58 5.65 3,618 1 0  
TEMP /oasb_data/tmp4.dbf 1,899 1 6.71 12.61 5,406 1 0  

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 890,624 100 1,771,692,148 792,166 2,484,104 0 0 658,217


Back to Top

 

Advisory Statistics

Back to Top

Instance Recovery Stats

  Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual Redo Blks Target Redo Blks Log File Size Redo Blks Log Ckpt Timeout Redo Blks Log Ckpt Interval Redo Blks
B 0 2,952 25,318 537,165 1,396,717 29,489,355 1,396,717  
E 0 3,266 30,383 603,427 23,277,640 29,489,355 23,277,640  

Back to Advisory Statistics
Back to Top

 

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
99.68 363,172 1,151

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 15,360 1,356 19,405.35 1.80 0.01 100.00 0.00 102,400
E 15,360 960 26,299.30 1.66 0.01 100.00 0.00 102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 4,238,596 4,238,596 0 0
64K 128K 11,370 11,370 0 0
128K 256K 1,129 1,129 0 0
256K 512K 1,039 1,039 0 0
512K 1024K 104,660 104,660 0 0
1M 2M 239,483 239,483 0 0
2M 4M 1,208 1,208 0 0
4M 8M 32 32 0 0
8M 16M 21 21 0 0
64M 128M 14 8 6 0
128M 256M 2 0 2 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
1,920 0.13 430,842.90 9,008.98 98.00 1,049
3,840 0.25 430,842.90 9,008.98 98.00 1,046
7,680 0.50 430,842.90 8,927.64 98.00 980
11,520 0.75 430,842.90 8,809.73 98.00 907
15,360 1.00 430,842.90 575.42 100.00 775
18,432 1.20 430,842.90 575.42 100.00 251
21,504 1.40 430,842.90 575.42 100.00 0
24,576 1.60 430,842.90 575.42 100.00 0
27,648 1.80 430,842.90 575.42 100.00 0
30,720 2.00 430,842.90 575.42 100.00 0
46,080 3.00 430,842.90 575.42 100.00 0
61,440 4.00 430,842.90 575.42 100.00 0
92,160 6.00 430,842.90 575.42 100.00 0
122,880 8.00 430,842.90 575.42 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
1,792 0.58 326 17,894 594,591 1.00 1,325 1.16 83,810,650
2,112 0.69 641 29,444 594,776 1.00 1,140 1.00 83,828,659
2,432 0.79 898 51,660 594,778 1.00 1,138 1.00 83,829,071
2,752 0.90 966 57,231 594,778 1.00 1,138 1.00 83,829,114
3,072 1.00 966 57,231 594,778 1.00 1,138 1.00 83,829,114
3,392 1.10 966 57,231 594,778 1.00 1,138 1.00 83,829,114
3,712 1.21 966 57,231 594,778 1.00 1,138 1.00 83,829,114
4,032 1.31 966 57,231 594,778 1.00 1,138 1.00 83,829,114
4,352 1.42 966 57,231 594,778 1.00 1,138 1.00 83,829,114
4,672 1.52 966 57,231 594,778 1.00 1,138 1.00 83,829,114
4,992 1.63 966 57,231 594,778 1.00 1,138 1.00 83,829,114
5,312 1.73 966 57,231 594,778 1.00 1,138 1.00 83,829,114
5,632 1.83 966 57,231 594,778 1.00 1,138 1.00 83,829,114
5,952 1.94 966 57,231 594,778 1.00 1,138 1.00 83,829,114
6,272 2.04 966 57,231 594,778 1.00 1,138 1.00 83,829,114

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M) JP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
16 0.25 16 384 781 1.00 1,138 1.00 5,740
32 0.50 23 504 781 1.00 1,138 1.00 5,740
48 0.75 23 504 781 1.00 1,138 1.00 5,740
64 1.00 23 504 781 1.00 1,138 1.00 5,740
80 1.25 23 504 781 1.00 1,138 1.00 5,740
96 1.50 23 504 781 1.00 1,138 1.00 5,740
112 1.75 23 504 781 1.00 1,138 1.00 5,740
128 2.00 23 504 781 1.00 1,138 1.00 5,740

Back to Advisory Statistics
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 436,866 187 0
undo block 176,112 23 0
undo header 32,931 7 0
1st level bmb 8,563 5 1
2nd level bmb 1,867 3 2
segment header 1,609 2 1
file header block 29 0 0
extent map 10 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
UL-User-defined 61,666 60,143 1,523 3,386 399 117.84
TX-Transaction (row lock contention) 7,869 573 7,296 569 374 657.14
TX-Transaction (index contention) 16,834 16,834 0 13,789 54 3.89
HW-Segment High Water Mark 182,853 182,851 2 2,719 4 1.57
RO-Multiple Object Reuse (fast object reuse) 245 245 0 35 4 116.37
DV-Diana Versioning 15,012 15,012 0 178 3 17.01
TX-Transaction 964,504 964,694 0 2,481 3 1.20
TM-DML 4,038,767 4,038,823 0 3 3 858.67
SQ-Sequence Cache 34,169 34,169 0 4,258 2 0.41
CI-Cross-Instance Call Invocation 38,102 38,102 0 714 1 1.94
CU-Cursor 7,611 7,611 0 33 0 11.12
FB-Format Block 33,470 33,471 0 994 0 0.22
TX-Transaction (allocate ITL entry) 373 373 0 298 0 0.69
PS-PX Process Reservation 834 564 271 13 0 1.38

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Undo Blocks Num Trans Max Qry Len (s) Max Tx Concurcy Snap TooOld OutOf Space uS/uR/uU/ eS/eR/eU
1 1,454,812 946,797 1,939 203 0 0 0/0/0/24/50344/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Undo Blocks Num Trans Max Qry Len (s) Max Tx Concy Snap TooOld OutOf Space uS/uR/uU/ eS/eR/eU
22-May 13:12 454,179 156,912 763 193 0 0 0/0/0/24/50344/0
22-May 13:02 351,932 158,999 656 192 0 0 0/0/0/0/0/0
22-May 12:52 186,019 183,502 1,924 195 0 0 0/0/0/0/0/0
22-May 12:42 124,398 123,678 1,939 191 0 0 0/0/0/0/0/0
22-May 12:32 169,056 223,896 1,336 196 0 0 0/0/0/0/0/0
22-May 12:22 169,228 99,810 734 203 0 0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
Consistent RBA 565,850 0.06 0.00 0 0  
FOB s.o list latch 61,314 0.02 0.00 0 0  
In memory undo latch 762,721,628 3.56 0.00 29 2,087,561 0.00
JOX SGA heap latch 509,771 0.00   0 0  
JS queue state obj latch 22,350 0.00   0 0  
JS slv state obj latch 3 0.00   0 0  
KMG MMAN ready and startup request latch 1,242 0.00   0 0  
KTF sga enqueue 13 0.00   0 1,255 0.00
KWQMN job cache list latch 1,315,739 0.06 1.43 13 0  
MQL Tracking Latch 0     0 73 0.00
Memory Management Latch 18,630 0.00   0 1,242 0.00
PL/SQL warning settings 2,016,414 0.00   0 0  
SQL memory manager latch 1 0.00   0 1,238 0.00
SQL memory manager workarea list latch 2,276,887 0.00 0.02 0 0  
SWRF Alerted Metric Element list 176,893 0.00   0 0  
Shared B-Tree 2 0.00   0 0  
active checkpoint queue latch 225,780 0.00 0.00 0 0  
active service list 16,486 0.00   0 0  
begin backup scn array 705 0.00   0 0  
cache buffer handles 20,966,693 0.60 0.00 0 0  
cache buffers chains 4,384,502,814 0.76 0.00 962 15,455,985 1.70
cache buffers lru chain 8,061,336 0.27 0.00 0 29,994,187 0.40
channel handle pool latch 213,892 0.01 0.00 0 0  
channel operations parent latch 838,521 0.66 0.00 0 0  
checkpoint queue latch 8,481,371 0.01 0.00 0 2,462,928 0.01
child cursor hash table 69,944 0.04 0.00 0 0  
client/application info 861,498 0.02 0.00 0 0  
commit callback allocation 77,251 0.00   0 0  
compile environment latch 1,734,032 0.00   0 0  
cursor bind value capture 1,631 0.55 0.00 0 16,613 0.07
dictionary lookup 82 0.00   0 0  
dml lock allocation 8,068,956 0.16 0.00 0 0  
dummy allocation 10,988 0.39 0.00 0 0  
enqueue hash chains 12,895,813 0.05 0.00 0 7 0.00
enqueues 2,806,704 0.16 0.00 0 0  
error message lists 308 7.47 0.00 0 0  
event group latch 3,045 0.00   0 0  
file cache latch 36,427 0.00   0 0  
global KZLD latch for mem in SGA 5,350 0.00   0 0  
global ctx hash table latch 23,716 0.00   0 0  
hash table column usage latch 1,356 0.07 0.00 0 8,771,415 0.00
hash table modification latch 137 0.00   0 0  
internal temp table object number allocation latc 3 0.00   0 0  
job workq parent latch 0     0 2 0.00
job_queue_processes free list latch 1 0.00   0 0  
job_queue_processes parameter latch 64 0.00   0 0  
ksuosstats global area 251 0.00   0 0  
ktm global data 38,272 0.00   0 0  
lgwr LWN SCN 567,323 0.06 0.00 0 0  
library cache 322,440,426 0.74 0.00 5 1,142 0.35
library cache load lock 5,538 2.04 0.00 0 32 0.00
library cache lock 40,206,035 0.04 0.00 0 0  
library cache lock allocation 941,831 0.00 0.00 0 0  
library cache pin 273,498,634 0.22 0.00 1 65 0.00
library cache pin allocation 1,038,842 0.00 0.00 0 0  
list of block allocation 380,036 0.01 0.00 0 0  
loader state object freelist 167,170 0.00 0.00 0 0  
longop free list parent 43 0.00   0 43 0.00
message pool operations parent latch 216,254 0.01 0.10 0 0  
messages 2,388,712 0.09 0.00 0 0  
mostly latch-free SCN 590,101 2.59 0.00 0 0  
multiblock read objects 48,814 0.00 0.00 0 0  
ncodef allocation latch 68 0.00   0 0  
object queue header heap 390,800 0.00   0 397,679 0.00
object queue header operation 54,048,263 0.02 0.00 0 0  
object stats modification 44,067 0.04 0.00 0 0  
parallel query alloc buffer 3,302 2.24 0.00 0 0  
parallel query stats 226 20.35 0.00 0 0  
parameter list 15,000 0.03 0.00 0 0  
parameter table allocation management 10,988 0.55 0.00 0 0  
post/wait queue 482,788 0.00 0.00 0 261,383 0.02
process allocation 6,099 0.10 0.00 0 3,042 0.10
process group creation 6,063 0.02 0.00 0 0  
process queue 1,961 1.94 0.00 0 0  
process queue reference 340,949 0.05 0.00 0 23,656 18.11
query server freelists 1,648 13.05 0.00 0 0  
query server process 16 0.00   0 16 0.00
redo allocation 6,341,172 1.15 0.00 1 92,040,777 1.38
redo copy 0     0 92,166,193 0.05
redo writing 2,324,893 0.01 0.03 0 0  
row cache objects 48,564,667 0.24 0.00 0 0  
rules engine statistics 24,555 0.02 0.00 0 0  
sequence cache 15,176,404 0.69 0.00 0 0  
session allocation 10,415,718 0.54 0.00 0 0  
session idle bit 50,882,158 0.02 0.00 1 0  
session switching 7,412 0.03 0.00 0 0  
session timer 1,261 0.00   0 0  
shared pool 16,493,735 0.09 0.00 0 0  
sort extent pool 689,688 0.06 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 112 0.00   0 0  
temp lob duration state obj allocation 430 0.00   0 0  
temporary table state object allocation 7,229 0.10 0.00 0 0  
threshold alerts latch 318 0.00   0 0  
trace latch 36 0.00   0 0  
transaction allocation 66,303 0.00 0.00 0 0  
transaction branch allocation 68 0.00   0 0  
undo global data 888,461,151 5.58 0.00 29 340 0.00
user lock 21,350 0.09 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
undo global data 888,461,151 49,596,580 4,153 49,592,441 4,125 14 0
cache buffers chains 4,384,502,814 33,114,332 92,788 33,032,985 91,920 257 89
In memory undo latch 762,721,628 27,135,212 4,002 27,131,238 3,946 28 0
library cache 322,440,426 2,398,134 3,070 2,395,081 3,036 17 0
library cache pin 273,498,634 614,333 460 613,876 454 3 0
cache buffer handles 20,966,693 124,957 50 124,907 50 0 0
row cache objects 48,564,667 118,413 36 118,377 36 0 0
sequence cache 15,176,404 104,683 22 104,661 22 0 0
redo allocation 6,341,172 73,084 279 72,808 273 3 0
session allocation 10,415,718 56,127 33 56,095 31 1 0
cache buffers lru chain 8,061,336 22,040 62 21,978 62 0 0
library cache lock 40,206,035 17,639 16 17,623 16 0 0
mostly latch-free SCN 590,101 15,268 3 15,265 3 0 0
shared pool 16,493,735 14,888 14 14,874 14 0 0
dml lock allocation 8,068,956 12,971 11 12,960 11 0 0
session idle bit 50,882,158 11,518 57 11,461 57 0 0
object queue header operation 54,048,263 9,485 11 9,474 11 0 0
enqueue hash chains 12,895,813 6,634 1 6,633 1 0 0
channel operations parent latch 838,521 5,558 4 5,554 4 0 0
enqueues 2,806,704 4,524 2 4,522 2 0 0
KWQMN job cache list latch 1,315,739 776 1,112 72 448 157 99
checkpoint queue latch 8,481,371 499 1 498 1 0 0
redo writing 2,324,893 226 6 220 6 0 0
SQL memory manager workarea list latch 2,276,887 43 1 42 1 0 0
message pool operations parent latch 216,254 20 2 18 2 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch kturbk 0 3,680 3,864
In memory undo latch ktichg: child 0 103 7
In memory undo latch ktiTxnPoolFree 0 76 0
In memory undo latch ktiFlush: child 0 72 121
In memory undo latch kticmt: child 0 59 5
In memory undo latch ktiBRacquire 0 6 0
In memory undo latch ktbgfc 0 6 5
KWQMN job cache list latch kwqmnuji: update job item 0 1,111 1,062
KWQMN job cache list latch kwqmndej: dequeue 0 1 50
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 1 0
cache buffer handles kcbzgs 0 34 35
cache buffer handles kcbzfs 0 16 15
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 44,528 45,754
cache buffers chains kcbgtcr: fast path 0 15,053 6,333
cache buffers chains kcbgtcr: kslbegin excl 0 9,918 6,800
cache buffers chains kcbchg: kslbegin: call CR func 0 8,482 21,551
cache buffers chains kcbzgb: scan from tail. nowait 0 5,689 0
cache buffers chains kcbrls: kslbegin 0 2,276 6,510
cache buffers chains kcbgcur: kslbegin 0 2,269 1,949
cache buffers chains kcbget: pin buffer 0 1,140 921
cache buffers chains kcbgkcbcr 0 1,046 1,055
cache buffers chains kcbzwb 0 848 685
cache buffers chains kcbget: exchange rls 0 495 115
cache buffers chains kcbget: exchange 0 366 232
cache buffers chains kcbgtcr: kslbegin shared 0 142 94
cache buffers chains kcbnew: new latch again 0 102 8
cache buffers chains kcbcge 0 64 253
cache buffers chains kcbnlc 0 25 55
cache buffers chains kcbbic2 0 10 4
cache buffers chains kcbbxsv 0 8 5
cache buffers chains kcbgtcr 0 4 0
cache buffers chains kcbso1: set no access 0 3 13
cache buffers chains kcbzib: finish free bufs 0 2 0
cache buffers chains kcbesc: escalate 0 2 0
cache buffers chains kcb_is_private 0 1 101
cache buffers chains kcbibr 0 1 3
cache buffers chains kcbzib: multi-block read: nowait 0 1 0
cache buffers chains kcb_pre_apply: kcbhq61 0 1 107
cache buffers chains kcb_post_apply: kcbhq63 0 1 1
cache buffers lru chain kcbzgws 0 43 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 8 0
cache buffers lru chain kcbzswcu 0 5 0
cache buffers lru chain kcbzgb: posted for free bufs 0 2 29
cache buffers lru chain kcbbic2 0 2 18
cache buffers lru chain kcbbxsv: move to being written 0 1 8
cache buffers lru chain kcbo_ivd_proc 0 1 4
channel operations parent latch ksrwait() 0 3 1
channel operations parent latch ksrchconnect() 0 1 1
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 1 0
dml lock allocation ktaidm 0 9 3
dml lock allocation ktaiam 0 2 8
enqueue hash chains ksqgtl3 0 1 1
enqueues ksqgel: create enqueue 0 1 2
enqueues ksqdel 0 1 0
library cache kglpndl: child: before processing 0 603 419
library cache kglpnc: child 0 522 933
library cache kglpnp: child 0 508 940
library cache kglupc: child 0 496 282
library cache kglpndl: child: after processing 0 272 0
library cache kglpin: child: heap processing 0 72 70
library cache kglobpn: child: 0 70 216
library cache kgldte: child 0 0 34 42
library cache kglhdgn: child: 0 21 87
library cache kglpin 0 18 8
library cache kglhdiv: child 0 15 0
library cache kglupd: child 0 8 0
library cache kglhdgc: child: 0 7 3
library cache kglget: set reserved lock 0 6 15
library cache kglidp: child 0 4 0
library cache kglic 0 2 0
library cache kgldti: 2child 0 2 0
library cache kglhdgh: child: 0 1 1
library cache kglget: unpin heap 0 0 1 2
library cache lock kgllkdl: child: no lock handle 0 408 52
library cache lock kgllkdl: child: cleanup 0 12 9
library cache lock kgllkal: child: multiinstance 0 4 8
library cache pin kglpndl 0 125 54
library cache pin kglpnp: child 0 106 160
library cache pin kglpnc: child 0 103 133
library cache pin kglupc 0 79 44
library cache pin kglpnal: child: alloc space 0 47 69
message pool operations parent latch ksrmalloc() 0 1 1
message pool operations parent latch ksrmfree() 0 1 1
mostly latch-free SCN kcslcu3 0 3 3
object queue header operation kcbo_ivbo 0 11 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 198 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 49 140
redo allocation kcrfw_redo_write: before write 0 14 56
redo allocation kcrfw_redo_write: more space 0 13 84
redo allocation kcrfw_redo_gen: redo allocation 2 0 5 0
redo writing kcrfw_post: rba scn pair 0 4 0
redo writing kcrfw_cal_target_rba 0 1 0
redo writing kcrfwcr 0 1 5
row cache objects kqreqd: reget 0 29 1
row cache objects kqrpre: find obj 0 6 35
row cache objects kqrpup 0 1 0
sequence cache kdnssd 0 18 0
sequence cache kdnss 0 4 21
session allocation ksuprc 0 11 6
session allocation ksucri 0 7 13
session allocation ksuxds: not user session 0 7 12
session allocation ksudlc 0 5 2
session allocation ksuxds: KSUSFCLC not set 0 3 0
session idle bit ksupuc: clear busy 0 26 24
session idle bit ksupuc: set busy 0 25 30
session idle bit ksuxds 0 6 6
shared pool kghupr1 0 7 6
shared pool kghalo 0 5 7
shared pool kghfre 0 2 1
undo global data kturimugur: child 0 3,835 2,519
undo global data ktudba: KSLBEGIN 0 299 1,602
undo global data ktusmasp: ktugd_tuux 0 9 2
undo global data ktudnx:child 0 8 6
undo global data ktufrbs: child 0 1 1
undo global data ktibnd: child 0 1 22

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 61,097,456 8.34
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 36,181,408 4.94
GL APPS_TS_TX_IDX GL_CODE_COMBINATIONS_U1   INDEX 35,248,544 4.81
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 24,588,224 3.36
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N1   INDEX 18,945,696 2.59

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 56,728 22.73
GL APPS_ASSM_DATA GL_INTERFACE   TABLE 21,348 8.55
AR APPS_ASSM_DATA RA_CUST_TRX_LINE_GL_DIST_ALL   TABLE 20,775 8.32
HR APPS_TS_TX_IDX PAY_BALANCE_CONTEXT_VALUES_PK   INDEX 15,742 6.31
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 12,417 4.97

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits %Total
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 52,595 14.98
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 43,967 12.52
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 43,004 12.25
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 36,485 10.39
AR APPS_ASSM_DATA RA_CUST_TRX_LINE_GL_DIST_ALL   TABLE 36,323 10.35

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits %Total
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 12,269 29.25
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 10,981 26.18
APPLSYS APPS_TS_TX_DATA FND_CONCURRENT_REQUESTS   TABLE 2,350 5.60
HR APPS_TS_TX_IDX PAY_RUN_BALANCES_N3   INDEX 2,192 5.23
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 1,871 4.46

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits %Total
SYS SYSTEM COL$   TABLE 274 89.54
HR APPS_TS_TX_IDX PAY_COSTS_FK1   INDEX 5 1.63
INV APPS_ASSM_IDX MTL_MATERIAL_TRANSACTIONS_N23   INDEX 3 0.98
HR APPS_ASSM_IDX PAY_RUN_RESULTS_N50   INDEX 3 0.98
HR APPS_ASSM_IDX PAY_RUN_RESULTS_PK   INDEX 3 0.98

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 4 0.00 0   2 1
dc_constraints 696 47.27 0   696 181
dc_free_extents 32 40.63 14 0.00 22 109
dc_global_oids 2,478,749 0.00 0   0 84
dc_histogram_data 4,306 2.81 0   16 957
dc_histogram_defs 241,974 2.99 0   4,277 28,948
dc_object_ids 5,347,978 0.01 0   61 6,258
dc_objects 135,852 0.71 0   378 9,471
dc_profiles 5,352 0.00 0   0 1
dc_rollback_segments 88,202 0.00 0   9 937
dc_segments 867,156 0.07 0   16,366 8,255
dc_sequences 41,500 0.05 0   41,500 165
dc_table_scns 55,893 0.01 0   0 14
dc_tablespace_quotas 16,249 0.13 0   16,249 57
dc_tablespaces 2,296,049 0.00 0   0 21
dc_used_extents 10 100.00 0   10 12
dc_usernames 204,467 0.00 0   0 88
dc_users 4,648,519 0.00 0   0 143
outstanding_alerts 128 0.00 0   0 20


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 378,117 0.02 21,014,766 0.00 0 0
CLUSTER 50 0.00 97 0.00 0 0
INDEX 7,997 0.96 8,496 1.49 0 0
JAVA DATA 276 0.00 0   0 0
PIPE 25,278 2.61 34,182 1.93 0 0
SQL AREA 2,629,629 0.18 78,187,708 0.01 2,453 304
TABLE/PROCEDURE 265,176 0.27 31,540,726 0.01 9 0
TRIGGER 16,472 0.08 1,143,810 0.00 0 0


Back to Top

 

SGA Statistics

Back to Top

SGA Memory Summary

SGA regions Size in Bytes
Database Buffers 7,516,192,768
Fixed Size 1,343,848
Redo Buffers 16,777,216
Variable Size 3,303,767,704

Back to SGA Statistics
Back to Top

SGA breakdown difference

Pool Name Begin value End value % Diff
java free memory 51,464,704 51,464,704 0.00
java joxlod exec hp 14,966,784 14,966,784 0.00
java joxs heap 677,376 677,376 0.00
shared ASH buffers 33,554,432 33,554,432 0.00
shared FileOpenBlock 12,563,648 12,563,648 0.00
shared KGLF Frame Hea 15,112 15,112 0.00
shared KGLS heap 41,591,184 46,257,592 11.22
shared KQR L PO 14,592,880 16,128,456 10.52
shared KQR L SO 104,448 106,496 1.96
shared KQR M PO 17,077,792 19,978,288 16.98
shared KQR M SO 378,032 436,920 15.58
shared KQR S SO 11,064 11,600 4.84
shared KTI-UNDO 59,745,840 59,745,840 0.00
shared PL/SQL DIANA 30,013,632 35,011,152 16.65
shared PL/SQL MPCODE 74,948,512 80,475,024 7.37
shared PLS non-lib hp 14,760 14,760 0.00
shared QSMQUTL summar 3,800 24,840 553.68
shared SGA struct - SWRF Metrics 3,536,000 3,536,000 0.00
shared constraints 1,743,712 1,743,712 0.00
shared db_block_hash_buckets 33,554,432 33,554,432 0.00
shared enqueue resources 4,418,528 4,418,528 0.00
shared evaluation con 17,760 17,760 0.00
shared event statistics per sess 181,888,000 181,888,000 0.00
shared fixed allocation callback 1,424 1,424 0.00
shared free memory 1,385,193,192 746,603,744 -46.10
shared joxlod exec hp 964,608 964,608 0.00
shared joxlod pcod hp 178,776 178,776 0.00
shared joxlod rsrc hp 7,392 7,392 0.00
shared joxs heap 4,240 4,240 0.00
shared ktlbk state objects 4,127,200 4,127,200 0.00
shared library cache 661,906,152 937,572,008 41.65
shared miscellaneous 206,788,088 232,636,792 12.50
shared parameters 1,143,472 1,295,616 13.31
shared partitioning d 459,088 511,024 11.31
shared pl/sql source 16,704 16,704 0.00
shared private strands 101,713,920 101,713,920 0.00
shared procs: ksunfy 2,200,000 2,200,000 0.00
shared replication session stats 1,904,000 1,904,000 0.00
shared repository 2,998,032 3,143,704 4.86
shared row cache 8,472,848 8,472,848 0.00
shared rule set evalu 71,136 71,136 0.00
shared session parame 25,128,600 25,553,200 1.69
shared sessions 34,944,008 34,944,008 0.00
shared sql area 250,526,448 568,081,672 126.76
shared synonym source 32,216 54,304 68.56
shared table definiti 70,968 82,056 15.62
shared temporary tabl 6,779,712 8,185,176 20.73
shared transaction 12,365,800 12,365,800 0.00
shared trigger defini 135,512 148,456 9.55
shared trigger inform 2,496 2,496 0.00
shared trigger source 3,800 8,752 130.32
shared type object de 814,632 820,304 0.70
  buffer_cache 7,516,192,768 7,516,192,768 0.00
  fixed_sga 1,343,848 1,343,848 0.00
  log_buffer 16,777,216 16,777,216 0.00

Back to SGA Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

Parameter Name Begin value End value (if different)
O7_DICTIONARY_ACCESSIBILITY FALSE  
_b_tree_bitmap_plans FALSE  
_like_with_bind_as_equality TRUE  
_swrf_mmon_dbfus FALSE  
_swrf_mmon_flush FALSE  
_system_trig_enabled TRUE  
aq_tm_processes 1  
background_dump_dest /o11510/oracle/visdb/10.1.0/admin  
compatible 10.1.0.5  
control_files /oasb_data/cntrl01.dbf, /oasb_dat  
core_dump_dest /o11510/oracle/visdb/10.1.0/admin  
cursor_sharing exact  
cursor_space_for_time FALSE  
db_block_checking FALSE  
db_block_checksum TRUE  
db_block_size 8192  
db_cache_advice off  
db_cache_size 7516192768  
db_files 130  
db_name VIS  
db_writer_processes 1  
dml_locks 10000  
enqueue_resources 32000  
java_pool_size 67108864  
job_queue_processes 10  
lock_sga TRUE  
log_buffer 16777216  
log_checkpoint_timeout 1200  
log_checkpoints_to_alert TRUE  
max_dump_file_size unlimited  
nls_comp binary  
nls_date_format DD-MON-RR  
nls_language american  
nls_length_semantics BYTE  
nls_numeric_characters .,  
nls_sort binary  
nls_territory america  
olap_page_pool_size 4194304  
open_cursors 1000  
parallel_max_servers 8  
pga_aggregate_target 16106127360  
plsql_code_type INTERPRETED  
plsql_native_library_dir /o11510/oracle/visdb/10.1.0/nativ  
plsql_optimize_level 2  
processes 5000  
remote_archive_enable false  
replication_dependency_tracking FALSE  
session_cached_cursors 500  
sessions 7000  
shared_pool_reserved_size 41943040  
shared_pool_size 3221225472  
sql_trace FALSE  
timed_statistics TRUE  
trace_enabled FALSE  
undo_management AUTO  
undo_tablespace APPS_UNDOTS1  
user_dump_dest /o11510/oracle/visdb/10.1.0/admin  
utl_file_dir /usr/tmp, /o11510/oracle/visdb/9.  
workarea_size_policy AUTO  


Back to Top

End of Report