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 21-May-06 06:56:00 3345 182.3
End Snap: 55 21-May-06 07:57:12 3360 227.9
Elapsed:   61.20 (mins)    
DB Time:   661.46 (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: 8,150,381.71 33,071.94
Logical reads: 469,857.47 1,906.55
Block changes: 50,335.31 204.25
Physical reads: 237.98 0.97
Physical writes: 710.41 2.88
User calls: 8,313.43 33.73
Parses: 2,126.75 8.63
Hard parses: 1.97 0.01
Sorts: 2,724.49 11.06
Logons: 1.83 0.01
Executes: 20,430.57 82.90
Transactions: 246.44  

% Blocks changed per Read: 10.71 Recursive Call %: 80.62
Rollback per transaction %: 18.51 Rows per Sort: 21.61

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97 Redo NoWait %: 100.00
Buffer Hit %: 99.95 In-memory Sort %: 100.00
Library Hit %: 99.99 Soft Parse %: 99.91
Execute to Parse %: 89.59 Latch Hit %: 98.88
Parse CPU to Parse Elapsd %: 54.15 % Non-Parse CPU: 97.45

Shared Pool Statistics

  Begin End
Memory Usage %: 63.89 86.31
% SQL with executions>1: 65.52 82.07
% Memory for SQL w/exec>1: 72.38 62.23

Top 5 Timed Events

Event Waits Time(s) Percent Total DB Time Wait Class
CPU time   23,025 58.01  
db file sequential read 705,787 3,033 7.64 User I/O
latch: cache buffers chains 85,508 873 2.20 Concurrency
log file sync 325,885 844 2.13 Commit
log file parallel write 1,282,131 793 2.00 System I/O

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 705,787 0 3,033 4 0.78
latch: cache buffers chains 85,508 85,508 873 10 0.09
log file sync 325,885 0 844 3 0.36
log file parallel write 1,282,131 0 793 1 1.42
enq: UL - contention 4,301 35 557 129 0.00
enq: TX - row lock contention 544 114 353 648 0.00
db file parallel write 221,291 0 313 1 0.24
buffer busy waits 524,865 3 108 0 0.58
SQL*Net more data from client 1,656,247 0 96 0 1.83
read by other session 39,519 0 77 2 0.04
library cache pin 2,659 0 66 25 0.00
enq: TX - index contention 15,458 0 59 4 0.02
rdbms ipc reply 16,909 7 35 2 0.02
SQL*Net more data to client 1,499,819 0 34 0 1.66
db file scattered read 14,464 0 32 2 0.02
library cache load lock 755 0 28 37 0.00
SQL*Net message to client 31,780,159 0 24 0 35.12
latch free 2,037 1,981 24 12 0.00
latch: undo global data 2,735 0 21 8 0.00
direct path read temp 9,892 0 18 2 0.01
SQL*Net break/reset to client 48,044 0 18 0 0.05
latch: In memory undo latch 2,958 0 16 5 0.00
latch: library cache 5,352 0 10 2 0.01
direct path write temp 3,252 0 9 3 0.00
PX Deq Credit: send blkd 10,117 0 7 1 0.01
enq: RO - fast object reuse 35 0 7 200 0.00
enq: CI - contention 2,995 0 7 2 0.00
local write wait 885 0 6 6 0.00
LGWR wait for redo copy 41,157 18 4 0 0.05
enq: TX - contention 2,591 0 3 1 0.00
control file parallel write 1,632 0 3 2 0.00
enq: HW - contention 2,539 0 3 1 0.00
latch: library cache pin 849 0 2 3 0.00
enq: DV - contention 108 0 2 17 0.00
PX Deq: Signal ACK 139 48 2 12 0.00
enq: TM - contention 3 0 1 498 0.00
enq: SQ - contention 2,846 0 1 0 0.00
library cache lock 23 0 1 43 0.00
latch: redo allocation 387 0 1 2 0.00
enq: CU - contention 25 0 1 28 0.00
control file sequential read 948 0 1 1 0.00
log buffer space 10 0 1 52 0.00
process startup 17 0 0 26 0.00
latch: row cache objects 61 0 0 6 0.00
log file switch completion 23 0 0 15 0.00
latch: cache buffers lru chain 93 0 0 3 0.00
enq: FB - contention 795 0 0 0 0.00
latch: library cache lock 37 0 0 6 0.00
row cache lock 562 0 0 0 0.00
latch: session allocation 74 0 0 2 0.00
control file single write 133 0 0 1 0.00
latch: checkpoint queue latch 6 0 0 13 0.00
latch: object queue header operation 33 0 0 2 0.00
undo segment extension 11,055 11,020 0 0 0.01
latch: cache buffer handles 38 0 0 1 0.00
buffer deadlock 5,319 5,289 0 0 0.01
kksfbc child completion 1 1 0 49 0.00
enq: TX - allocate ITL entry 71 0 0 1 0.00
latch: enqueue hash chains 9 0 0 4 0.00
latch: shared pool 26 0 0 1 0.00
db file parallel read 1 0 0 27 0.00
direct path read 420 0 0 0 0.00
latch: redo writing 3 0 0 4 0.00
direct path write 2,686 0 0 0 0.00
L1 validation 1 1 0 10 0.00
log file sequential read 2 0 0 5 0.00
enq: PS - contention 21 0 0 0 0.00
latch: messages 4 0 0 1 0.00
log file single write 2 0 0 0 0.00
PX Deq: Table Q qref 8 0 0 0 0.00
SQL*Net message from client 31,780,110 0 6,849,482 216 35.12
queue messages 6,697 6,032 41,087 6,135 0.01
pipe get 16,461 5,127 21,501 1,306 0.02
PL/SQL lock timer 699 698 7,959 11,386 0.00
PX Idle Wait 2,737 2,553 5,028 1,837 0.00
Queue Monitor Wait 122 122 3,561 29,191 0.00
wakeup time manager 1,776 922 2,837 1,597 0.00
PX Deq: Execution Msg 6,646 16 69 10 0.01
jobq slave wait 22 21 63 2,885 0.00
PX Deq: Execute Reply 4,746 1 14 3 0.01
PX Deq Credit: need buffer 1,543 0 1 1 0.00
PX Deq: Table Q Normal 1,743 0 1 0 0.00
PX Deq: Msg Fragment 1,583 0 0 0 0.00
PX Deq: Table Q Sample 37 0 0 3 0.00
PX Deq: Parse Reply 120 0 0 1 0.00
PX Deq: Join ACK 131 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,282,183 0 793 1 1.42
db file parallel write 221,291 0 313 1 0.24
LGWR wait for redo copy 41,157 18 4 0 0.05
control file parallel write 1,632 0 3 2 0.00
rdbms ipc reply 5,967 0 1 0 0.01
latch: cache buffers chains 133 133 1 10 0.00
latch free 129 126 1 10 0.00
db file sequential read 235 0 1 3 0.00
control file sequential read 690 0 0 1 0.00
latch: library cache 225 0 0 1 0.00
latch: redo allocation 161 0 0 1 0.00
buffer busy waits 492 0 0 0 0.00
control file single write 133 0 0 1 0.00
db file scattered read 12 0 0 6 0.00
latch: cache buffers lru chain 45 0 0 1 0.00
process startup 1 0 0 35 0.00
latch: undo global data 5 0 0 6 0.00
latch: library cache pin 18 0 0 1 0.00
latch: session allocation 7 0 0 2 0.00
direct path read 420 0 0 0 0.00
latch: redo writing 3 0 0 4 0.00
latch: In memory undo latch 8 0 0 1 0.00
log file sequential read 2 0 0 5 0.00
latch: shared pool 7 0 0 1 0.00
direct path write 220 0 0 0 0.00
latch: messages 4 0 0 1 0.00
latch: library cache lock 1 0 0 2 0.00
enq: CI - contention 3 0 0 1 0.00
log file single write 2 0 0 0 0.00
latch: object queue header operation 2 0 0 0 0.00
rdbms ipc message 649,025 9,595 25,728 40 0.72
Queue Monitor Wait 122 122 3,561 29,191 0.00
smon timer 47,771 0 3,561 75 0.05
wakeup time manager 1,776 922 2,837 1,597 0.00

Back to Wait Events Statistics
Back to Top

Time Model Statistics

Statistic Name Time (seconds) % Total DB Time
DB time 39,687.78 100.00
sql execute elapsed time 34,675.00 87.37
DB CPU 23,024.83 58.01
PL/SQL execution elapsed time 8,031.51 20.24
inbound PL/SQL rpc elapsed time 5,898.38 14.86
Java execution elapsed time 2,304.64 5.81
background elapsed time 2,011.99 5.07
parse time elapsed 1,037.08 2.61
hard parse elapsed time 714.84 1.80
background cpu time 559.70 1.41
sequence load elapsed time 19.03 0.05
connection management call elapsed time 12.97 0.03
PL/SQL compilation elapsed time 8.59 0.02
failed parse elapsed time 3.45 0.01
hard parse (sharing criteria) elapsed time 2.23 0.01
hard parse (bind mismatch) elapsed time 2.21 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 4,330,136
AVG_IDLE_TICKS 148,087
AVG_IN_BYTES 212,224
AVG_IOWAIT_TICKS 10,506
AVG_OUT_BYTES 904,960
AVG_SYS_TICKS 14,448
AVG_USER_TICKS 204,271
BUSY_TICKS 69,284,146
IDLE_TICKS 2,371,252
IN_BYTES 3,395,584
IOWAIT_TICKS 170,062
OS_CPU_WAIT_TIME 3,939,700
OUT_BYTES 14,479,360
RSRC_MGR_CPU_WAIT_TIME 0
SYS_TICKS 233,134
USER_TICKS 3,270,101

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
VIS 30,769.60 17,719.00 372,850 1,555,582,945
SYS$USERS 8,918.30 5,306.70 500,561 152,710,601
SYS$BACKGROUND 0.00 0.00 698 16,927,167

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 344,048 115,003 631,018 113,454 0 0 15,368,858 12,932
SYS$USERS 432,593 202,364 7,133 2,656 0 0 19,555,528 2,381
SYS$BACKGROUND 887 88 878 184 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,767 2,671 8 595.85 12.01 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
3,494 1,756 10 349.38 8.80 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
2,541 1,145 274 9.27 6.40 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,342 728 10 134.15 3.38 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
990 683 8 123.75 2.49 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
820 425 8 102.53 2.07 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
694 15 1,467 0.47 1.75 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
683 428 54,355 0.01 1.72 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
678 401 49,986 0.01 1.71 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
668 101 1,467 0.46 1.68 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
541 115 164,446 0.00 1.36 6gnth2mfbs2nq WSHFRREL declare v_ret number := 0...
518 423 68,777 0.01 1.30 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
488 266 8 60.96 1.23 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
446 313 5,000 0.09 1.12 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
417 234 876 0.48 1.05 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
400 276 8 49.94 1.01 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
399 66 16 24.95 1.01 944u2vd2tkmff ARGLTP select 'lock' from ra_cust_tr...

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,671 4,767 8 333.87 12.01 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
1,756 3,494 10 175.56 8.80 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,145 2,541 274 4.18 6.40 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
728 1,342 10 72.76 3.38 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
683 990 8 85.42 2.49 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
428 683 54,355 0.01 1.72 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
425 820 8 53.10 2.07 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
423 518 68,777 0.01 1.30 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
401 678 49,986 0.01 1.71 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
326 358 154,329 0.00 0.90 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
313 446 5,000 0.06 1.12 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
276 400 8 34.47 1.01 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
266 488 8 33.21 1.23 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
234 417 876 0.27 1.05 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
115 541 164,446 0.00 1.36 6gnth2mfbs2nq WSHFRREL declare v_ret number := 0...
101 668 1,467 0.07 1.68 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
66 399 16 4.11 1.01 944u2vd2tkmff ARGLTP select 'lock' from ra_cust_tr...
15 694 1,467 0.01 1.75 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
232,512,615 8 29,064,076.88 13.48 2,670.98 4,766.80 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
168,668,036 10 16,866,803.60 9.78 1,755.60 3,493.76 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
115,418,764 8 14,427,345.50 6.69 424.77 820.24 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
107,928,555 49,986 2,159.18 6.26 401.17 678.39 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
106,783,458 8 13,347,932.25 6.19 683.39 989.96 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
81,427,352 10 8,142,735.20 4.72 727.64 1,341.54 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
61,129,282 154,329 396.10 3.54 326.29 357.58 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
46,688,601 274 170,396.35 2.71 1,144.92 2,540.79 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
45,938,345 8 5,742,293.13 2.66 275.77 399.51 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
45,499,601 8 5,687,450.13 2.64 172.73 316.06 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
40,489,998 54,355 744.92 2.35 427.52 683.28 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
36,445,096 63 578,493.59 2.11 129.73 214.57 3n8tvc1tsqua0 WSHINTERFACES SELECT DISTINCT WTS.STOP_ID FR...
35,711,013 5,000 7,142.20 2.07 312.62 445.65 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
35,003,498 164,410 212.90 2.03 283.25 366.44 gf1u933c95jb5 WSHFRREL DECLARE l_ret_stat varchar2...
35,001,792 164,431 212.87 2.03 300.09 384.75 3b3psftuyks81 WSHFRREL BEGIN INV_TXNSTUB_PUB.postTran...
34,793,181 984 35,358.92 2.02 151.37 226.15 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
32,599,425 8 4,074,928.13 1.89 188.17 263.16 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
27,116,417 1,868 14,516.28 1.57 157.77 268.49 4adc1zhg5cmx0 WSHINTERFACE UPDATE WSH_DELIVERY_DETAILS DD...
26,384,126 9,999 2,638.68 1.53 118.63 346.58 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
20,832,479 1,328,196 15.68 1.21 179.49 218.94 66tmsr3446uqn OEXOETEL SELECT WIAS.ACTIVITY_STATUS, ...
19,339,188 41,384 467.31 1.12 245.16 292.97 64z4pgdwwm6g2 WSHINTERFACE SELECT STOP_ID FROM WSH_TRIP_S...
18,118,125 8 2,264,765.63 1.05 265.71 487.68 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
147,360 1,467 100.45 16.86 15.37 693.76 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
110,456 1,467 75.29 12.64 101.37 667.97 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
54,465 9,999 5.45 6.23 118.63 346.58 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
53,615 2,496 21.48 6.14 9.47 269.27 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
18,348 10 1,834.80 2.10 1,755.60 3,493.76 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
13,937 246,158 0.06 1.59 73.28 132.77 ccprbqfuu8wb1 WSHINTERFACE SELECT NUMBER_VALUE FROM WF_IT...
13,805 13,201 1.05 1.58 80.14 248.22 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
9,554 1 9,554.00 1.09 30.25 38.01 gczkkgwgkyjh3 SQL*Plus select /*+ parallel(t, 8) para...
3,258 8 407.25 0.37 275.77 399.51 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
2,635 8 329.38 0.30 188.17 263.16 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...

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,508,441 1,508,415 1.00 0.00 0.00 9dvfguzd15kpv JDBC Thin Client SELECT VALUE FROM V$NLS_PARAME...
1,328,196 688,762 0.52 0.00 0.00 66tmsr3446uqn OEXOETEL SELECT WIAS.ACTIVITY_STATUS, ...
812,250 812,250 1.00 0.00 0.00 cgb6kp2umq52a   select t.schema, t.name, t.f...
811,991 811,991 1.00 0.00 0.00 8bsm049u7thjd   select min(next_date) from "AP...
759,481 759,069 1.00 0.00 0.00 cd9mbmqyf4qhp OEXOETEL UPDATE WF_ITEM_ACTIVITY_STATUS...
707,497 706,859 1.00 0.00 0.00 gnhmcahkmrnzs OEXOETEL INSERT INTO WF_ITEM_ACTIVITY_S...
418,905 418,909 1.00 0.00 0.00 821fx90awyvj7 OEXOETEL SELECT ACCOUNTING_RULE_ID , A...
369,578 369,540 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
246,158 245,454 1.00 0.00 0.00 ccprbqfuu8wb1 WSHINTERFACE SELECT NUMBER_VALUE FROM WF_IT...
234,014 183,481 0.78 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
812,250 812,250 10.40 cgb6kp2umq52a   select t.schema, t.name, t.f...
811,991 1,280 10.40 20rc3cmapyvnz   select q_name, state, delay,...
811,991 811,991 10.40 8bsm049u7thjd   select min(next_date) from "AP...
369,591 369,578 4.73 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
234,040 234,014 3.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
164,396 164,446 2.11 6gnth2mfbs2nq WSHFRREL declare v_ret number := 0...
110,115 110,129 1.41 1c0b7sas42w2z WSHFRREL SELECT NVL(ITEM_COST, 0), ...
85,123 85,133 1.09 76sw2a4vnc89j ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.S...
81,447 81,476 1.04 bf7uwg5pa3pj6 ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.V...
81,446 81,498 1.04 608c0n36kaw62 ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.C...
81,388 85,119 1.04 dcvv68fju01g4 ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.E...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
4,438,832 8 0.14 45z5kajtbgmj0 RAXMTR select /*+ parallel(t, 8) para...
3,540,808 8 0.11 awz0s801s8fh2 RAXMTR select /*+ parallel(t, 8) para...
1,064,364 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 ;
1q78dwnrrkf6c BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); 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 )
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;
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
9dvfguzd15kpv SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = :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)
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
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,694,007 461.37 1.87
CPU used when call started 1,698,979 462.72 1.88
CR blocks created 14,021,732 3,818.85 15.50
Cached Commit SCN referenced 953,839 259.78 1.05
Commit SCN cached 420 0.11 0.00
DB time 10,690,336 2,911.54 11.81
DBWR checkpoint buffers written 1,423,874 387.80 1.57
DBWR checkpoints 37 0.01 0.00
DBWR object drop buffers written 58,949 16.05 0.07
DBWR revisited being-written buffer 1,265 0.34 0.00
DBWR thread checkpoint buffers written 136,215 37.10 0.15
DBWR transaction table writes 5,907 1.61 0.01
DBWR undo block writes 1,523,747 415.00 1.68
DFO trees parallelized 23 0.01 0.00
IMU CR rollbacks 36,259,402 9,875.32 40.07
IMU Flushes 294,385 80.18 0.33
IMU Redo allocation size 1,982,696,820 539,991.58 2,191.13
IMU bind flushes 1,078 0.29 0.00
IMU commits 465,373 126.75 0.51
IMU contention 32,157 8.76 0.04
IMU ktichg flush 10,144 2.76 0.01
IMU pool not allocated 176 0.05 0.00
IMU recursive-transaction flush 1,194 0.33 0.00
IMU undo allocation size 4,250,831,496 1,157,722.76 4,697.71
IMU- failed to get a private strand 176 0.05 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 29,692 8.09 0.03
PX local messages sent 29,692 8.09 0.03
Parallel operations downgraded 25 to 50 pct 18 0.00 0.00
Parallel operations downgraded to serial 13 0.00 0.00
Parallel operations not downgraded 5 0.00 0.00
SQL*Net roundtrips to/from client 31,767,949 8,652.07 35.11
active txn count during cleanout 65,973,808 17,968.10 72.91
application wait time 93,528 25.47 0.10
background checkpoints completed 2 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 10,502 2.86 0.01
branch node splits 944 0.26 0.00
buffer is not pinned count 570,279,261 155,316.74 630.23
buffer is pinned count 1,164,149,997 317,058.66 1,286.53
bytes received via SQL*Net from client 7,284,486,732 1,983,945.04 8,050.29
bytes sent via SQL*Net to client 6,837,570,822 1,862,226.57 7,556.39
calls to get snapshot scn: kcmgss 89,627,238 24,410.16 99.05
calls to kcmgas 17,537,165 4,776.28 19.38
calls to kcmgcs 8,827,718 2,404.25 9.76
change write time 71,435 19.46 0.08
cleanout - number of ktugct calls 21,924,081 5,971.07 24.23
cluster key scan block gets 527,598 143.69 0.58
cluster key scans 89,584 24.40 0.10
commit cleanout failures: block lost 210,227 57.26 0.23
commit cleanout failures: buffer being written 237 0.06 0.00
commit cleanout failures: callback failure 100,991 27.51 0.11
commit cleanout failures: cannot pin 30,634 8.34 0.03
commit cleanouts 7,931,629 2,160.20 8.77
commit cleanouts successfully completed 7,589,540 2,067.03 8.39
commit txn count during cleanout 931,133 253.60 1.03
concurrency wait time 116,221 31.65 0.13
consistent changes 678,632,929 184,827.08 749.98
consistent gets 1,519,892,098 413,945.76 1,679.67
consistent gets - examination 1,075,162,394 292,822.70 1,188.19
consistent gets from cache 1,519,892,119 413,945.77 1,679.67
current blocks converted for CR 47 0.01 0.00
cursor authentications 2,159 0.59 0.00
data blocks consistent reads - undo records applied 675,144,839 183,877.09 746.12
db block changes 184,817,071 50,335.31 204.25
db block gets 205,292,206 55,911.76 226.87
db block gets direct 6,976 1.90 0.01
db block gets from cache 205,285,219 55,909.85 226.87
deferred (CURRENT) block cleanout applications 1,626,009 442.85 1.80
dirty buffers inspected 627,460 170.89 0.69
enqueue conversions 7,821 2.13 0.01
enqueue releases 7,725,128 2,103.95 8.54
enqueue requests 7,734,740 2,106.57 8.55
enqueue timeouts 9,322 2.54 0.01
enqueue waits 30,653 8.35 0.03
exchange deadlocks 5,319 1.45 0.01
execute count 75,015,278 20,430.57 82.90
failed probes on index block reclamation 12,711 3.46 0.01
free buffer inspected 4,530,351 1,233.85 5.01
free buffer requested 18,369,007 5,002.84 20.30
heap block compress 23,395,299 6,371.76 25.85
hot buffers moved to head of LRU 2,491,470 678.56 2.75
immediate (CR) block cleanout applications 12,584,940 3,427.53 13.91
immediate (CURRENT) block cleanout applications 1,089,505 296.73 1.20
index fast full scans (full) 242,845 66.14 0.27
index fast full scans (rowid ranges) 189 0.05 0.00
index fetch by key 157,356,656 42,856.41 173.90
index scans kdiixs1 107,380,442 29,245.29 118.67
java call heap collected bytes 796,057,576 216,807.93 879.75
java call heap collected count 10,598,213 2,886.45 11.71
java call heap gc count 983 0.27 0.00
java call heap live object count 222,943 60.72 0.25
java call heap live object count max 223,833 60.96 0.25
java call heap live size 53,825,808 14,659.57 59.48
java call heap live size max 53,940,480 14,690.80 59.61
java call heap object count 4,322,578 1,177.26 4.78
java call heap object count max 4,324,882 1,177.89 4.78
java call heap total size 174,850,048 47,620.77 193.23
java call heap total size max 174,850,048 47,620.77 193.23
java call heap used size 357,686,016 97,416.53 395.29
java call heap used size max 358,248,104 97,569.61 395.91
leaf node 90-10 splits 18,754 5.11 0.02
leaf node splits 227,900 62.07 0.25
logons cumulative 6,714 1.83 0.01
messages received 895,978 244.02 0.99
messages sent 895,978 244.02 0.99
no buffer to keep pinned count 18 0.00 0.00
no work - consistent read gets 334,077,727 90,986.76 369.20
opened cursors cumulative 6,132,778 1,670.27 6.78
parse count (failures) 2,199 0.60 0.00
parse count (hard) 7,227 1.97 0.01
parse count (total) 7,808,828 2,126.75 8.63
parse time cpu 58,743 16.00 0.06
parse time elapsed 108,482 29.55 0.12
physical read IO requests 729,145 198.58 0.81
physical reads 873,799 237.98 0.97
physical reads cache 807,762 220.00 0.89
physical reads cache prefetch 87,513 23.83 0.10
physical reads direct 66,037 17.99 0.07
physical reads direct temporary tablespace 65,617 17.87 0.07
physical reads prefetch warmup 19,116 5.21 0.02
physical write IO requests 987,008 268.81 1.09
physical writes 2,608,427 710.41 2.88
physical writes direct 72,813 19.83 0.08
physical writes direct (lob) 3,066 0.84 0.00
physical writes direct temporary tablespace 69,437 18.91 0.08
physical writes from cache 2,535,614 690.58 2.80
physical writes non checkpoint 2,319,270 631.66 2.56
pinned buffers inspected 5,276 1.44 0.01
prefetch warmup blocks aged out before use 200,814 54.69 0.22
prefetched blocks aged out before use 929 0.25 0.00
process last non-idle time 3,673 1.00 0.00
queries parallelized 23 0.01 0.00
recursive calls 127,001,489 34,589.12 140.35
recursive cpu usage 1,021,319 278.16 1.13
redo blocks written 60,990,067 16,610.77 67.40
redo buffer allocation retries 24 0.01 0.00
redo entries 95,552,285 26,023.86 105.60
redo log space requests 23 0.01 0.00
redo log space wait time 38 0.01 0.00
redo ordering marks 1,239,989 337.71 1.37
redo size 29,925,903,240 8,150,381.71 33,071.94
redo synch time 84,439 23.00 0.09
redo synch writes 372,722 101.51 0.41
redo wastage 279,872,732 76,223.92 309.30
redo write time 81,935 22.32 0.09
redo writer latching time 521 0.14 0.00
redo writes 641,325 174.67 0.71
rollback changes - undo records applied 216,046 58.84 0.24
rows fetched via callback 121,805,398 33,173.95 134.61
session connect time 0 0.00 0.00
session cursor cache hits 3,193,048 869.63 3.53
session logical reads 1,725,184,148 469,857.47 1,906.55
session pga memory 7,206,657,376 1,962,748.06 7,964.27
session pga memory max 8,841,629,760 2,408,036.17 9,771.13
session uga memory 10,466,263,464 2,850,508.53 11,566.56
session uga memory max 52,211,835,136 14,220,001.41 57,700.73
shared hash latch upgrades - no wait 120,333,025 32,772.95 132.98
shared hash latch upgrades - wait 165,533 45.08 0.18
sorts (disk) 4 0.00 0.00
sorts (memory) 10,003,555 2,724.49 11.06
sorts (rows) 216,139,332 58,865.99 238.86
summed dirty queue length 2,763,337 752.60 3.05
switch current to new buffer 1,121,084 305.33 1.24
table fetch by rowid 733,438,706 199,753.55 810.54
table fetch continued row 32,292,026 8,794.80 35.69
table scan blocks gotten 53,042,779 14,446.31 58.62
table scan rows gotten 1,687,579,391 459,615.74 1,864.99
table scans (long tables) 5,363 1.46 0.01
table scans (rowid ranges) 5,346 1.46 0.01
table scans (short tables) 4,966,989 1,352.77 5.49
transaction rollbacks 4,340 1.18 0.00
transaction tables consistent read rollbacks 46 0.01 0.00
transaction tables consistent reads - undo records applied 1,902 0.52 0.00
undo change vector size 10,442,523,568 2,844,042.92 11,540.32
user I/O wait time 317,067 86.35 0.35
user calls 30,524,581 8,313.43 33.73
user commits 737,365 200.82 0.81
user rollbacks 167,508 45.62 0.19
workarea executions - onepass 8 0.00 0.00
workarea executions - optimal 5,431,551 1,479.29 6.00
write clones created in background 885 0.24 0.00
write clones created in foreground 1,135 0.31 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 96,034 212,692
opened cursors current 609,868 765,581
workarea memory allocated 2,232 3,787
logons current 3,345 3,360

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 1 0.98

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 10,658 3 1.05 1.00 593,173 162 191,751 0.20
APPS_TS_TX_DATA 419,649 114 4.53 1.05 114,940 31 74,623 0.59
APPS_TS_TX_IDX 188,029 51 4.83 1.05 105,198 29 55,754 0.72
APPS_ASSM_DATA 56,708 15 1.40 1.84 67,636 18 135,623 0.24
APPS_ASSM_IDX 24,085 7 2.20 1.03 61,714 17 75,910 0.28
TEMP 10,974 3 17.05 6.51 17,464 5 0 0.00
APPS_TS_SEED 9,872 3 6.27 1.19 2,986 1 973 3.27
APPS_TS_TX_INTERFACE 1,556 0 3.72 3.20 11,094 3 20,651 0.18
SYSTEM 5,215 1 4.37 1.01 1,847 1 7,099 0.63
APPS_TS_QUEUES 556 0 4.77 1.19 5,490 1 75 14.40
APPS_TS_SUMMARY 188 0 3.88 1.00 3,233 1 1,689 0.25
CTXSYS 424 0 9.22 1.05 1,303 0 2 0.00
APPS_TS_ARCHIVE 180 0 6.50 1.00 563 0 27 8.15
SYSAUX 405 0 2.94 1.88 312 0 0 0.00
APPS_TS_NOLOGGING 39 0 4.62 1.36 28 0 0 0.00
APPS_TS_MEDIA 6 0 5.00 1.00 6 0 0 0.00
ODM 5 0 4.00 1.00 2 0 0 0.00
OLAP 5 0 12.00 1.00 2 0 0 0.00
OWAPUB 5 0 10.00 1.00 2 0 0 0.00
PORTAL 5 0 12.00 1.00 2 0 0 0.00
SYNCSERVER 5 0 6.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 56,708 15 1.40 1.84 67,636 18 135,623 0.24
APPS_ASSM_IDX /oasb_data/apps_assm_idx.dbf 24,085 7 2.20 1.03 61,714 17 75,910 0.28
APPS_TS_ARCHIVE /oasb_data/archive1.dbf 75 0 7.20 1.00 245 0 15 9.33
APPS_TS_ARCHIVE /oasb_data/archive2.dbf 105 0 6.00 1.00 318 0 12 6.67
APPS_TS_MEDIA /oasb_data/media1.dbf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /oasb_data/media2.dbf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /oasb_data/media3.dbf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging1.dbf 27 0 4.81 1.52 24 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging2.dbf 6 0 3.33 1.00 2 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging3.dbf 6 0 5.00 1.00 2 0 0 0.00
APPS_TS_QUEUES /oasb_data/queues1.dbf 21 0 7.14 1.62 463 0 4 2.50
APPS_TS_QUEUES /oasb_data/queues2.dbf 120 0 4.75 1.49 714 0 26 39.62
APPS_TS_QUEUES /oasb_data/queues3.dbf 89 0 4.49 1.15 940 0 12 0.83
APPS_TS_QUEUES /oasb_data/queues4.dbf 75 0 5.87 1.01 869 0 15 0.67
APPS_TS_QUEUES /oasb_data/queues5.dbf 89 0 4.38 1.06 834 0 3 6.67
APPS_TS_QUEUES /oasb_data/queues6.dbf 83 0 4.34 1.01 821 0 6 0.00
APPS_TS_QUEUES /oasb_data/queues7.dbf 79 0 4.30 1.16 849 0 9 0.00
APPS_TS_SEED /oasb_data/reference1.dbf 1,129 0 4.84 1.23 277 0 240 3.08
APPS_TS_SEED /oasb_data/reference10.dbf 690 0 9.06 1.16 244 0 0 0.00
APPS_TS_SEED /oasb_data/reference2.dbf 1,273 0 5.27 1.22 240 0 710 3.41
APPS_TS_SEED /oasb_data/reference3.dbf 1,039 0 6.73 1.18 324 0 13 0.77
APPS_TS_SEED /oasb_data/reference4.dbf 953 0 4.88 1.16 290 0 0 0.00
APPS_TS_SEED /oasb_data/reference5.dbf 956 0 7.13 1.17 315 0 0 0.00
APPS_TS_SEED /oasb_data/reference6.dbf 951 0 5.37 1.19 345 0 1 10.00
APPS_TS_SEED /oasb_data/reference7.dbf 946 0 7.54 1.17 332 0 6 0.00
APPS_TS_SEED /oasb_data/reference8.dbf 976 0 7.82 1.19 314 0 1 0.00
APPS_TS_SEED /oasb_data/reference9.dbf 959 0 5.34 1.16 305 0 2 0.00
APPS_TS_SUMMARY /oasb_data/summary1.dbf 9 0 3.33 1.00 459 0 192 0.10
APPS_TS_SUMMARY /oasb_data/summary2.dbf 8 0 5.00 1.00 68 0 4 0.00
APPS_TS_SUMMARY /oasb_data/summary3.dbf 16 0 3.75 1.00 479 0 188 0.11
APPS_TS_SUMMARY /oasb_data/summary4.dbf 23 0 2.17 1.00 413 0 226 0.44
APPS_TS_SUMMARY /oasb_data/summary5.dbf 27 0 2.22 1.00 483 0 371 0.46
APPS_TS_SUMMARY /oasb_data/summary6.dbf 31 0 3.55 1.00 434 0 270 0.11
APPS_TS_SUMMARY /oasb_data/summary7.dbf 30 0 4.33 1.00 445 0 177 0.34
APPS_TS_SUMMARY /oasb_data/summary8.dbf 44 0 5.68 1.00 452 0 261 0.11
APPS_TS_TX_DATA /oasb_data/tx_data1.dbf 1,486 0 4.15 1.23 4,363 1 3,037 0.70
APPS_TS_TX_DATA /oasb_data/tx_data10.dbf 1,338 0 3.49 1.23 4,243 1 3,382 0.66
APPS_TS_TX_DATA /oasb_data/tx_data11.dbf 1,440 0 3.76 1.20 4,386 1 4,087 0.92
APPS_TS_TX_DATA /oasb_data/tx_data12.dbf 37,616 10 4.05 1.02 6,410 2 3,573 0.50
APPS_TS_TX_DATA /oasb_data/tx_data13.dbf 37,061 10 4.65 1.02 6,331 2 3,551 0.33
APPS_TS_TX_DATA /oasb_data/tx_data14.dbf 37,030 10 5.31 1.03 6,173 2 3,361 0.29
APPS_TS_TX_DATA /oasb_data/tx_data15.dbf 44,197 12 4.42 1.02 10,029 3 3,530 0.36
APPS_TS_TX_DATA /oasb_data/tx_data16.dbf 37,050 10 4.25 1.02 6,208 2 3,242 0.35
APPS_TS_TX_DATA /oasb_data/tx_data17.dbf 36,934 10 4.13 1.03 6,265 2 3,149 0.36
APPS_TS_TX_DATA /oasb_data/tx_data18.dbf 36,876 10 4.58 1.02 6,282 2 2,990 0.31
APPS_TS_TX_DATA /oasb_data/tx_data19.dbf 36,772 10 5.25 1.02 6,179 2 3,418 0.21
APPS_TS_TX_DATA /oasb_data/tx_data2.dbf 1,666 0 3.18 1.95 4,319 1 3,528 0.70
APPS_TS_TX_DATA /oasb_data/tx_data20.dbf 36,642 10 4.94 1.02 6,234 2 2,871 0.41
APPS_TS_TX_DATA /oasb_data/tx_data21.dbf 36,511 10 4.27 1.02 6,239 2 2,892 0.35
APPS_TS_TX_DATA /oasb_data/tx_data3.dbf 2,267 1 4.40 1.74 4,504 1 4,062 1.02
APPS_TS_TX_DATA /oasb_data/tx_data4.dbf 2,745 1 5.07 1.57 4,667 1 3,434 0.83
APPS_TS_TX_DATA /oasb_data/tx_data5.dbf 11,868 3 3.87 1.14 4,184 1 3,859 0.62
APPS_TS_TX_DATA /oasb_data/tx_data6.dbf 3,686 1 3.95 1.41 4,377 1 4,437 0.59
APPS_TS_TX_DATA /oasb_data/tx_data7.dbf 11,655 3 4.09 1.15 4,406 1 3,908 0.62
APPS_TS_TX_DATA /oasb_data/tx_data8.dbf 2,158 1 4.49 1.70 4,764 1 4,503 0.99
APPS_TS_TX_DATA /oasb_data/tx_data9.dbf 2,651 1 4.31 1.57 4,377 1 3,809 0.78
APPS_TS_TX_IDX /oasb_data/tx_idx1.dbf 1,496 0 4.05 1.04 2,123 1 1,414 0.53
APPS_TS_TX_IDX /oasb_data/tx_idx10.dbf 1,974 1 5.14 1.04 5,063 1 1,103 0.68
APPS_TS_TX_IDX /oasb_data/tx_idx11.dbf 2,081 1 5.19 1.03 4,028 1 2,565 1.54
APPS_TS_TX_IDX /oasb_data/tx_idx12.dbf 15,624 4 4.81 1.05 7,135 2 3,409 0.35
APPS_TS_TX_IDX /oasb_data/tx_idx13.dbf 15,777 4 5.35 1.06 7,143 2 3,096 0.41
APPS_TS_TX_IDX /oasb_data/tx_idx14.dbf 15,485 4 5.84 1.05 6,928 2 2,742 0.25
APPS_TS_TX_IDX /oasb_data/tx_idx15.dbf 15,601 4 4.24 1.05 6,893 2 3,196 0.99
APPS_TS_TX_IDX /oasb_data/tx_idx16.dbf 15,307 4 4.03 1.05 6,848 2 2,356 0.34
APPS_TS_TX_IDX /oasb_data/tx_idx17.dbf 15,413 4 4.89 1.05 6,685 2 2,771 0.33
APPS_TS_TX_IDX /oasb_data/tx_idx18.dbf 15,345 4 6.21 1.05 6,690 2 2,922 0.26
APPS_TS_TX_IDX /oasb_data/tx_idx19.dbf 15,447 4 5.71 1.05 6,679 2 3,029 1.09
APPS_TS_TX_IDX /oasb_data/tx_idx2.dbf 2,199 1 7.78 1.03 3,472 1 6,371 0.62
APPS_TS_TX_IDX /oasb_data/tx_idx20.dbf 15,015 4 4.39 1.05 6,404 2 3,230 0.30
APPS_TS_TX_IDX /oasb_data/tx_idx21.dbf 15,291 4 3.95 1.04 6,640 2 3,282 0.44
APPS_TS_TX_IDX /oasb_data/tx_idx3.dbf 3,161 1 3.75 1.03 3,789 1 1,584 0.73
APPS_TS_TX_IDX /oasb_data/tx_idx4.dbf 3,973 1 3.48 1.02 3,510 1 1,515 0.92
APPS_TS_TX_IDX /oasb_data/tx_idx5.dbf 3,806 1 4.15 1.01 3,090 1 1,771 0.78
APPS_TS_TX_IDX /oasb_data/tx_idx6.dbf 3,937 1 4.33 1.02 3,178 1 1,845 0.60
APPS_TS_TX_IDX /oasb_data/tx_idx7.dbf 3,857 1 4.48 1.03 2,882 1 2,346 0.65
APPS_TS_TX_IDX /oasb_data/tx_idx8.dbf 3,594 1 3.62 1.03 3,420 1 2,516 0.63
APPS_TS_TX_IDX /oasb_data/tx_idx9.dbf 3,646 1 3.46 1.02 2,598 1 2,691 3.08
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte.dbf 620 0 3.29 2.86 2,480 1 5,829 0.22
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte2.dbf 219 0 4.34 3.22 1,849 1 3,534 0.22
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte3.dbf 152 0 3.88 4.04 1,651 0 3,374 0.12
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte4.dbf 179 0 3.97 3.51 1,764 0 2,828 0.19
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte5.dbf 192 0 3.49 3.28 1,673 0 2,602 0.13
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte6.dbf 194 0 4.28 3.23 1,677 0 2,484 0.17
APPS_UNDOTS1 /oasb_data/undo01.dbf 399 0 1.13 1.00 26,607 7 14,420 0.15
APPS_UNDOTS1 /oasb_data/undo02.dbf 300 0 1.60 1.00 29,487 8 22,649 0.18
APPS_UNDOTS1 /oasb_data/undo03.dbf 304 0 1.18 1.00 33,486 9 20,749 0.31
APPS_UNDOTS1 /oasb_data/undo04.dbf 345 0 1.48 1.00 31,362 9 18,457 0.18
APPS_UNDOTS1 /oasb_data/undo05.dbf 1,851 1 0.84 1.00 100,731 27 22,161 0.19
APPS_UNDOTS1 /oasb_data/undo06.dbf 2,386 1 0.71 1.00 98,488 27 22,653 0.19
APPS_UNDOTS1 /oasb_data/undo07.dbf 1,879 1 1.21 1.00 95,016 26 22,021 0.20
APPS_UNDOTS1 /oasb_data/undo08.dbf 1,684 0 1.46 1.00 89,925 24 26,073 0.19
APPS_UNDOTS1 /oasb_data/undo09.dbf 1,510 0 0.95 1.00 88,071 24 22,568 0.18
CTXSYS /oasb_data/ctx1.dbf 124 0 10.97 1.06 237 0 2 0.00
CTXSYS /oasb_data/ctx2.dbf 300 0 8.50 1.05 1,066 0 0 0.00
ODM /oasb_data/odm.dbf 5 0 4.00 1.00 2 0 0 0.00
OLAP /oasb_data/olap.dbf 5 0 12.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 12.00 1.00 2 0 0 0.00
SYNCSERVER /oasb_data/mobile01.dbf 5 0 6.00 1.00 2 0 0 0.00
SYSAUX /oasb_data/sysaux01.dbf 190 0 2.63 1.77 163 0 0 0.00
SYSAUX /oasb_data/sysaux02.dbf 215 0 3.21 1.97 149 0 0 0.00
SYSTEM /oasb_data/sys1.dbf 686 0 4.49 1.02 174 0 67 3.58
SYSTEM /oasb_data/sys2.dbf 947 0 4.15 1.00 214 0 209 1.00
SYSTEM /oasb_data/sys3.dbf 699 0 4.23 1.00 257 0 182 0.82
SYSTEM /oasb_data/sys4.dbf 936 0 4.33 1.00 403 0 212 1.51
SYSTEM /oasb_data/sys5.dbf 698 0 5.20 1.00 355 0 1,537 0.60
SYSTEM /oasb_data/sys6.dbf 610 0 4.03 1.01 243 0 2,469 0.41
SYSTEM /oasb_data/sys7.dbf 610 0 4.03 1.01 142 0 302 0.73
SYSTEM /oasb_data/sys8.dbf 11 0 6.36 1.00 28 0 1,664 0.75
SYSTEM /oasb_data/sys9.dbf 18 0 7.22 1.17 31 0 457 0.39
TEMP /oasb_data/tmp1.dbf 2,961 1 25.80 5.32 3,599 1 0  
TEMP /oasb_data/tmp2.dbf 2,929 1 13.32 10.23 4,087 1 0  
TEMP /oasb_data/tmp3.dbf 1,764 0 9.37 4.83 5,774 2 0  
TEMP /oasb_data/tmp4.dbf 3,320 1 16.62 5.19 4,004 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,722,550,399 807,837 2,535,614 0 0 564,378


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 4,055 33,780 743,006 1,899,135 29,489,355 1,899,135  
E 0 4,275 35,914 779,644 24,263,924 29,489,355 24,263,924  

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.75 455,696 1,153

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 960 24,886.71 1.51 0.01 100.00 0.00 102,400
E 15,360 960 32,014.06 3.03 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,979,898 4,979,898 0 0
64K 128K 11,604 11,604 0 0
128K 256K 1,198 1,198 0 0
256K 512K 1,138 1,138 0 0
512K 1024K 131,697 131,697 0 0
1M 2M 301,752 301,752 0 0
2M 4M 1,518 1,518 0 0
4M 8M 40 40 0 0
8M 16M 5 5 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 549,911.75 9,963.66 98.00 1,219
3,840 0.25 549,911.75 9,963.66 98.00 1,217
7,680 0.50 549,911.75 9,872.95 98.00 1,176
11,520 0.75 549,911.75 9,792.31 98.00 1,120
15,360 1.00 549,911.75 576.71 100.00 1,048
18,432 1.20 549,911.75 576.71 100.00 933
21,504 1.40 549,911.75 576.71 100.00 534
24,576 1.60 549,911.75 576.71 100.00 0
27,648 1.80 549,911.75 576.71 100.00 0
30,720 2.00 549,911.75 576.71 100.00 0
46,080 3.00 549,911.75 576.71 100.00 0
61,440 4.00 549,911.75 576.71 100.00 0
92,160 6.00 549,911.75 576.71 100.00 0
122,880 8.00 549,911.75 576.71 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
2,112 0.69 328 17,010 936,297 1.00 1,655 1.16 99,981,341
2,432 0.79 649 24,408 936,520 1.00 1,432 1.00 100,002,785
2,752 0.90 959 49,943 936,523 1.00 1,429 1.00 100,003,636
3,072 1.00 1,082 59,599 936,523 1.00 1,429 1.00 100,003,810
3,392 1.10 1,103 61,593 936,523 1.00 1,429 1.00 100,003,810
3,712 1.21 1,103 61,593 936,523 1.00 1,429 1.00 100,003,810
4,032 1.31 1,103 61,593 936,523 1.00 1,429 1.00 100,003,810
4,352 1.42 1,103 61,593 936,523 1.00 1,429 1.00 100,003,810
4,672 1.52 1,103 61,593 936,523 1.00 1,429 1.00 100,003,810
4,992 1.63 1,103 61,593 936,523 1.00 1,429 1.00 100,003,810
5,312 1.73 1,103 61,593 936,523 1.00 1,429 1.00 100,003,810
5,632 1.83 1,103 61,593 936,523 1.00 1,429 1.00 100,003,810
5,952 1.94 1,103 61,593 936,523 1.00 1,429 1.00 100,003,810
6,272 2.04 1,103 61,593 936,523 1.00 1,429 1.00 100,003,810

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 365 1,254 1.00 1,429 1.00 13,800
32 0.50 23 532 1,254 1.00 1,429 1.00 13,800
48 0.75 23 532 1,254 1.00 1,429 1.00 13,800
64 1.00 23 532 1,254 1.00 1,429 1.00 13,800
80 1.25 23 532 1,254 1.00 1,429 1.00 13,800
96 1.50 23 532 1,254 1.00 1,429 1.00 13,800
112 1.75 23 532 1,254 1.00 1,429 1.00 13,800
128 2.00 23 532 1,254 1.00 1,429 1.00 13,800

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 363,494 146 0
undo block 163,355 31 0
undo header 28,407 7 0
1st level bmb 6,943 2 0
segment header 1,311 1 1
2nd level bmb 754 1 1
extent map 7 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 64,821 63,340 1,481 4,126 570 138.22
TX-Transaction (row lock contention) 8,015 424 7,591 422 361 855.54
TX-Transaction (index contention) 18,778 18,778 0 14,891 60 4.03
RO-Multiple Object Reuse (fast object reuse) 245 245 0 35 7 205.23
CI-Cross-Instance Call Invocation 33,812 33,812 0 2,922 7 2.43
TX-Transaction 1,068,337 1,068,539 0 2,258 4 1.57
HW-Segment High Water Mark 213,973 213,970 2 2,395 3 1.36
DV-Diana Versioning 18,358 18,358 0 106 2 17.32
TM-DML 4,958,422 4,958,583 0 3 2 510.00
SQ-Sequence Cache 35,397 35,397 0 2,665 1 0.50
CU-Cursor 8,275 8,275 0 25 1 28.12
FB-Format Block 33,723 33,725 0 718 0 0.34
TX-Transaction (allocate ITL entry) 198 198 0 71 0 0.59
PS-PX Process Reservation 1,000 751 248 16 0 0.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,509,248 1,046,816 1,857 251 0 0 0/0/0/0/0/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
21-May 07:55 159,225 107,284 826 230 0 0 0/0/0/0/0/0
21-May 07:45 461,311 178,934 618 237 0 0 0/0/0/0/0/0
21-May 07:35 312,844 210,913 520 240 0 0 0/0/0/0/0/0
21-May 07:25 151,971 136,286 1,857 245 0 0 0/0/0/0/0/0
21-May 07:15 158,568 200,643 1,845 241 0 0 0/0/0/0/0/0
21-May 07:05 265,329 212,756 1,242 251 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 642,117 0.05 0.00 0 0  
FOB s.o list latch 71,260 0.02 0.00 0 0  
In memory undo latch 651,821,381 2.70 0.00 16 2,548,962 0.00
JOX SGA heap latch 520,811 0.00   0 0  
JS queue state obj latch 22,020 0.00   0 0  
JS slv state obj latch 3 0.00   0 0  
KMG MMAN ready and startup request latch 1,224 0.00   0 0  
KTF sga enqueue 12 0.00   0 1,236 0.00
KWQMN job cache list latch 1,657,312 0.08 1.35 23 0  
MQL Tracking Latch 0     0 74 0.00
Memory Management Latch 18,360 0.00   0 1,224 0.00
PL/SQL warning settings 2,393,083 0.00   0 0  
SQL memory manager latch 1 0.00   0 1,221 0.00
SQL memory manager workarea list latch 2,788,946 0.00 0.00 0 0  
SWRF Alerted Metric Element list 216,914 0.00   0 0  
Shared B-Tree 2 0.00   0 0  
active checkpoint queue latch 247,682 0.00   0 0  
active service list 18,913 0.00   0 0  
begin backup scn array 854 0.00   0 0  
cache buffer handles 21,403,139 0.57 0.00 0 0  
cache buffers chains 4,152,119,015 0.72 0.00 894 16,400,331 1.66
cache buffers lru chain 8,387,125 0.29 0.00 0 31,779,166 0.42
channel handle pool latch 267,330 0.02 0.00 0 0  
channel operations parent latch 1,031,121 0.69 0.00 0 0  
checkpoint queue latch 9,139,575 0.01 0.01 0 2,506,280 0.01
child cursor hash table 71,824 0.01 0.00 0 0  
client/application info 1,051,598 0.01 0.00 0 0  
commit callback allocation 96,659 0.00   0 0  
compile environment latch 2,179,859 0.00   0 0  
cursor bind value capture 1,650 0.30 0.00 0 16,013 0.00
dictionary lookup 82 1.22 0.00 0 0  
dml lock allocation 9,905,990 0.18 0.00 0 0  
dummy allocation 13,444 0.38 0.00 0 0  
enqueue hash chains 15,501,483 0.04 0.00 0 29 0.00
enqueues 3,362,084 0.15 0.00 0 0  
error message lists 404 5.45 0.00 0 0  
event group latch 3,605 0.00   0 0  
file cache latch 34,200 0.01 0.00 0 0  
global KZLD latch for mem in SGA 6,525 0.00   0 0  
global ctx hash table latch 30,006 0.00   0 0  
hash table column usage latch 1,081 0.19 0.00 0 11,021,831 0.00
hash table modification latch 139 0.72 0.00 0 0  
job workq parent latch 0     0 2 0.00
job_queue_processes parameter latch 62 0.00   0 0  
ksuosstats global area 247 0.00   0 0  
ktm global data 48,536 0.00   0 0  
lgwr LWN SCN 643,781 0.08 0.00 0 0  
library cache 377,251,596 0.82 0.00 10 1,343 389.95
library cache load lock 4,793 1.36 0.00 0 40 2.50
library cache lock 49,980,846 0.05 0.00 0 0  
library cache lock allocation 1,161,013 0.00 0.03 0 0  
library cache pin 318,784,796 0.23 0.00 2 78 1.28
library cache pin allocation 1,282,864 0.00 0.00 0 0  
list of block allocation 404,126 0.02 0.00 0 0  
loader state object freelist 209,374 0.00 0.00 0 0  
longop free list parent 42 0.00   0 42 0.00
message pool operations parent latch 270,846 0.01 0.05 0 0  
messages 2,658,267 0.09 0.00 0 0  
mostly latch-free SCN 673,321 3.02 0.00 0 0  
multiblock read objects 35,610 0.00   0 0  
ncodef allocation latch 68 0.00   0 0  
object queue header heap 495,200 0.00   0 504,979 0.00
object queue header operation 59,841,796 0.03 0.00 0 0  
object stats modification 49,740 0.02 0.00 0 0  
parallel query alloc buffer 4,056 1.82 0.00 0 0  
parallel query stats 279 16.49 0.00 0 0  
parameter list 18,336 0.00   0 0  
parameter table allocation management 13,445 0.49 0.00 0 0  
post/wait queue 605,084 0.01 0.00 0 326,082 0.02
process allocation 7,229 0.07 0.00 0 3,602 0.08
process group creation 7,193 0.00   0 0  
process queue 2,425 1.48 0.00 0 0  
process queue reference 488,453 0.04 0.00 0 42,879 8.10
query server freelists 2,028 9.07 0.00 0 0  
query server process 16 0.00   0 16 0.00
redo allocation 7,565,143 1.04 0.00 1 95,446,686 1.40
redo copy 0     0 95,585,658 0.06
redo writing 2,650,390 0.01 0.01 0 0  
row cache objects 60,161,241 0.26 0.00 0 0  
rules engine statistics 29,634 0.02 0.00 0 0  
sequence cache 15,550,949 0.78 0.00 0 0  
session allocation 11,615,578 0.41 0.00 0 0  
session idle bit 63,224,158 0.03 0.01 1 0  
session switching 9,390 0.00   0 0  
session timer 1,248 0.00   0 0  
shared pool 20,249,422 0.10 0.00 0 0  
sort extent pool 864,095 0.07 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 514 0.00   0 0  
temporary table state object allocation 8,927 0.03 0.00 0 0  
threshold alerts latch 318 0.00   0 0  
trace latch 18 0.00   0 0  
transaction allocation 81,041 0.00   0 0  
transaction branch allocation 68 0.00   0 0  
undo global data 791,424,709 2.82 0.00 21 68 0.00
user lock 26,074 0.03 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
cache buffers chains 4,152,119,015 29,972,418 85,504 29,924,734 84,751 263 55
undo global data 791,424,709 22,355,375 2,735 22,352,660 2,695 20 0
In memory undo latch 651,821,381 17,599,201 2,958 17,596,274 2,896 31 0
library cache 377,251,596 3,101,862 5,352 3,096,529 5,314 19 0
library cache pin 318,784,796 717,442 849 716,593 849 0 0
row cache objects 60,161,241 157,984 61 157,923 61 0 0
cache buffer handles 21,403,139 122,378 38 122,341 36 1 0
sequence cache 15,550,949 121,497 30 121,467 30 0 0
redo allocation 7,565,143 78,814 387 78,430 381 3 0
session allocation 11,615,578 48,087 74 48,013 74 0 0
cache buffers lru chain 8,387,125 24,209 93 24,118 89 2 0
library cache lock 49,980,846 23,153 37 23,117 35 1 0
shared pool 20,249,422 20,967 26 20,941 26 0 0
mostly latch-free SCN 673,321 20,317 15 20,302 15 0 0
dml lock allocation 9,905,990 17,826 4 17,822 4 0 0
session idle bit 63,224,158 17,322 93 17,230 91 1 0
object queue header operation 59,841,796 15,386 33 15,353 33 0 0
channel operations parent latch 1,031,121 7,151 12 7,139 12 0 0
enqueue hash chains 15,501,483 6,374 9 6,365 9 0 0
enqueues 3,362,084 5,035 3 5,032 3 0 0
messages 2,658,267 2,290 4 2,286 4 0 0
KWQMN job cache list latch 1,657,312 1,394 1,875 163 830 245 156
sort extent pool 864,095 626 3 623 3 0 0
checkpoint queue latch 9,139,575 539 6 534 4 1 0
redo writing 2,650,390 234 3 231 3 0 0
library cache lock allocation 1,161,013 37 1 36 1 0 0
message pool operations parent latch 270,846 19 1 18 1 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 2,599 2,788
In memory undo latch ktiFlush: child 0 101 143
In memory undo latch ktiTxnPoolFree 0 95 0
In memory undo latch kticmt: child 0 76 3
In memory undo latch ktichg: child 0 70 21
In memory undo latch ktiBRacquire 0 12 0
In memory undo latch ktbgfc 0 5 4
KWQMN job cache list latch kwqmnuji: update job item 0 1,874 1,768
KWQMN job cache list latch kwqmndej: dequeue 0 1 107
cache buffer handles kcbzfs 0 21 16
cache buffer handles kcbzgs 0 17 22
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 40,538 42,876
cache buffers chains kcbgtcr: fast path 0 14,496 6,864
cache buffers chains kcbchg: kslbegin: call CR func 0 8,181 19,480
cache buffers chains kcbzgb: scan from tail. nowait 0 7,581 0
cache buffers chains kcbgtcr: kslbegin excl 0 7,346 5,372
cache buffers chains kcbgcur: kslbegin 0 2,145 2,377
cache buffers chains kcbrls: kslbegin 0 1,943 5,898
cache buffers chains kcbget: pin buffer 0 1,222 1,242
cache buffers chains kcbget: exchange rls 0 684 140
cache buffers chains kcbget: exchange 0 462 278
cache buffers chains kcbzwb 0 314 171
cache buffers chains kcbnew: new latch again 0 141 15
cache buffers chains kcbgtcr: kslbegin shared 0 99 70
cache buffers chains kcbcge 0 90 230
cache buffers chains kcbnlc 0 31 59
cache buffers chains kcbbxsv 0 8 14
cache buffers chains kcbso1: set no access 0 7 13
cache buffers chains kcbzib: finish free bufs 0 5 3
cache buffers chains kcbesc: escalate 0 5 0
cache buffers chains kcb_is_private 0 4 156
cache buffers chains kcbbic2 0 3 2
cache buffers chains kcbnew_1 0 2 1
cache buffers chains kcbgtcr 0 2 0
cache buffers chains kcb_pre_apply: kcbhq61 0 2 97
cache buffers chains kcb_post_apply: kcbhq62 0 1 4
cache buffers lru chain kcbzgws 0 66 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 16 0
cache buffers lru chain kcbzswcu 0 4 0
cache buffers lru chain kcbzgb: posted for free bufs 0 2 42
cache buffers lru chain kcbo_ivd_proc 0 2 4
cache buffers lru chain kcbzfw 0 1 0
cache buffers lru chain kcbbic2 0 1 31
cache buffers lru chain kcbbxsv: move to being written 0 1 9
channel operations parent latch ksrchdelete() 0 5 2
channel operations parent latch ksrwait() 0 2 5
channel operations parent latch ksrsconsume() 0 2 0
channel operations parent latch ksrmfree() 0 1 1
channel operations parent latch ksrchconnect() 0 1 4
channel operations parent latch ksrapublish() 0 1 1
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 4 0
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 2 1
dml lock allocation ktaiam 0 3 2
dml lock allocation ktaidm 0 1 2
enqueue hash chains ksqrcl 0 6 2
enqueue hash chains ksqgtl3 0 3 5
enqueues ksqgel: create enqueue 0 2 3
enqueues ksqdel 0 1 0
library cache kglpndl: child: before processing 0 1,065 736
library cache kglpnc: child 0 953 1,600
library cache kglupc: child 0 917 570
library cache kglpnp: child 0 881 1,605
library cache kglpndl: child: after processing 0 468 4
library cache kglobpn: child: 0 125 338
library cache kglpin: child: heap processing 0 112 104
library cache kgldte: child 0 0 69 101
library cache kglhdgn: child: 0 43 152
library cache kglpin 0 31 17
library cache kglhdgc: child: 0 21 5
library cache kglhdiv: child 0 20 0
library cache kglget: set reserved lock 0 14 37
library cache kglupd: child 0 8 0
library cache kglhdiv0: parent: invalidate 0 3 0
library cache kglidp: child 0 3 0
library cache kglpur: child 0 2 0
library cache kglic 0 2 0
library cache kgldti: 2child 0 2 1
library cache kglini: child 0 1 0
library cache lock kgllkdl: child: no lock handle 0 612 92
library cache lock kgllkdl: child: cleanup 0 22 25
library cache lock kgllkal: child: multiinstance 0 15 13
library cache lock allocation kgllkget 0 1 1
library cache pin kglpndl 0 230 99
library cache pin kglpnc: child 0 193 243
library cache pin kglupc 0 188 103
library cache pin kglpnp: child 0 174 269
library cache pin kglpnal: child: alloc space 0 64 137
message pool operations parent latch ksrmalloc() 0 1 1
messages ksaamb: after wakeup 0 3 2
messages ksarcv: after wait 0 1 0
mostly latch-free SCN kcslcu3 0 15 15
object queue header operation kcbo_ivbo 0 29 5
object queue header operation kcbw_link_q 0 4 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 278 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 74 227
redo allocation kcrfw_redo_write: more space 0 15 98
redo allocation kcrfw_redo_write: before write 0 12 63
redo allocation kcrfw_redo_gen: redo allocation 2 0 8 0
redo writing kcrfw_cal_target_rba 0 2 0
redo writing kcrfw_post: rba scn pair 0 1 0
row cache objects kqreqd: reget 0 52 0
row cache objects kqrpre: find obj 0 5 61
row cache objects kqreqd 0 4 0
sequence cache kdnssd 0 28 0
sequence cache kdnss 0 2 30
session allocation ksucri 0 25 33
session allocation ksuprc 0 17 9
session allocation ksudlc 0 15 7
session allocation ksuxds: not user session 0 15 25
session allocation ksuxds: KSUSFCLC not set 0 2 0
session idle bit ksupuc: set busy 0 51 44
session idle bit ksupuc: clear busy 0 40 46
session idle bit ksuxds 0 2 3
shared pool kghupr1 0 13 19
shared pool kghfre 0 7 1
shared pool kghalo 0 5 8
shared pool kghfen: not perm alloc class 0 1 0
sort extent pool ktstdt: dealloc sort extent 0 2 0
sort extent pool ktstsmonmsg 0 1 2
undo global data kturimugur: child 0 2,425 1,470
undo global data ktudba: KSLBEGIN 0 303 1,242
undo global data ktusmasp: ktugd_tuux 0 4 3
undo global data ktudnx:child 0 3 3

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 63,000,704 8.40
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 36,406,016 4.85
GL APPS_TS_TX_IDX GL_CODE_COMBINATIONS_U1   INDEX 35,355,696 4.71
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 23,830,096 3.18
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N1   INDEX 18,980,320 2.53

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 48,234 21.08
AR APPS_ASSM_DATA RA_CUST_TRX_LINE_GL_DIST_ALL   TABLE 18,983 8.30
HR APPS_TS_TX_IDX PAY_BALANCE_CONTEXT_VALUES_PK   INDEX 15,742 6.88
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 12,342 5.39
HR APPS_TS_TX_DATA PAY_BALANCE_CONTEXT_VALUES   TABLE 10,354 4.52

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 49,732 15.19
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 46,526 14.21
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 41,756 12.76
AR APPS_ASSM_DATA RA_CUST_TRX_LINE_GL_DIST_ALL   TABLE 32,398 9.90
GL APPS_ASSM_DATA GL_INTERFACE   TABLE 29,590 9.04

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,384 27.55
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 11,742 26.12
APPLSYS APPS_TS_TX_DATA FND_CONCURRENT_REQUESTS   TABLE 2,870 6.39
HR APPS_TS_TX_IDX PAY_RUN_BALANCES_N3   INDEX 2,356 5.24
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 2,116 4.71

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits %Total
HR APPS_ASSM_IDX PAY_RUN_RESULTS_PK   INDEX 8 18.60
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N4   INDEX 4 9.30
INV APPS_ASSM_IDX MTL_MATERIAL_TRANSACTIONS_N23   INDEX 4 9.30
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 4 9.30
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N3   INDEX 4 9.30

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.13 0   696 193
dc_free_extents 22 31.82 10 0.00 14 109
dc_global_oids 3,123,201 0.00 0   0 83
dc_histogram_data 3,668 2.92 0   16 959
dc_histogram_defs 284,195 2.45 0   4,277 29,053
dc_object_ids 6,635,727 0.01 0   60 6,280
dc_objects 158,962 0.54 0   376 9,504
dc_profiles 6,526 0.00 0   0 1
dc_rollback_segments 56,885 0.00 0   0 985
dc_segments 1,070,868 0.05 0   16,924 8,311
dc_sequences 44,740 0.04 0   44,740 166
dc_table_scns 63,307 0.01 0   0 14
dc_tablespace_quotas 16,820 0.10 0   16,820 57
dc_tablespaces 2,870,115 0.00 0   0 21
dc_used_extents 6 100.00 0   6 12
dc_usernames 245,165 0.00 0   0 87
dc_users 5,795,076 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 459,279 0.02 25,241,054 0.00 0 0
CLUSTER 28 0.00 43 0.00 0 0
INDEX 9,789 0.79 10,378 1.22 0 0
JAVA DATA 282 0.00 0   0 0
PIPE 31,734 2.60 43,015 1.92 0 0
SQL AREA 3,272,011 0.15 89,456,146 0.01 2,813 306
TABLE/PROCEDURE 326,723 0.19 37,319,430 0.00 9 0
TRIGGER 19,933 0.03 1,208,632 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 25,165,824 25,165,824 0.00
shared FileOpenBlock 12,563,648 12,563,648 0.00
shared KEWS sesstat values 3,024,000 3,024,000 0.00
shared KGLF Frame Hea 15,008 15,008 0.00
shared KGLS heap 42,268,328 46,301,032 9.54
shared KQR L PO 14,828,424 16,184,688 9.15
shared KQR L SO 104,448 106,496 1.96
shared KQR M PO 17,374,472 20,091,160 15.64
shared KQR M SO 386,136 437,856 13.39
shared KQR S SO 11,104 11,616 4.61
shared KTI-UNDO 59,745,840 59,745,840 0.00
shared PL/SQL DIANA 30,143,096 34,899,472 15.78
shared PL/SQL MPCODE 75,272,192 80,573,624 7.04
shared PLS non-lib hp 14,760 14,760 0.00
shared QSMQUTL summar 18,840 24,696 31.08
shared SGA struct - SWRF Metrics 3,536,000 3,536,000 0.00
shared Wait History 3,360,000 3,360,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 2,255,856 2,255,856 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,163,302,312 441,070,168 -62.08
shared joxlod exec hp 966,768 966,768 0.00
shared joxlod pcod hp 173,880 173,880 0.00
shared joxlod rsrc hp 7,128 7,128 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 810,304,640 1,108,330,920 36.78
shared miscellaneous 280,339,920 308,492,544 10.04
shared parameters 1,168,120 1,296,216 10.97
shared partitioning d 463,352 515,056 11.16
shared pl/sql source 17,048 17,048 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 3,054,672 3,199,384 4.74
shared row cache 8,472,848 8,472,848 0.00
shared rule set evalu 71,192 71,192 0.00
shared sessions 26,222,000 26,222,000 0.00
shared sql area 279,592,840 658,036,592 135.36
shared synonym source 31,600 53,872 70.48
shared table definiti 70,992 82,160 15.73
shared temporary tabl 8,753,960 10,195,792 16.47
shared transaction 13,093,200 13,093,200 0.00
shared trigger defini 137,608 146,960 6.80
shared trigger inform 2,088 2,088 0.00
shared trigger source 8,456 8,456 0.00
shared type object de 812,216 817,744 0.68
  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