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 18-May-06 20:51:42 3699 181.5
End Snap: 55 18-May-06 21:53:00 3727 233.2
Elapsed:   61.31 (mins)    
DB Time:   747.99 (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,268,482.75 31,317.99
Logical reads: 501,805.49 1,900.66
Block changes: 51,173.66 193.83
Physical reads: 263.73 1.00
Physical writes: 730.48 2.77
User calls: 9,146.60 34.64
Parses: 2,291.13 8.68
Hard parses: 2.21 0.01
Sorts: 2,905.29 11.00
Logons: 1.98 0.01
Executes: 21,631.84 81.93
Transactions: 264.02  

% Blocks changed per Read: 10.20 Recursive Call %: 80.01
Rollback per transaction %: 19.11 Rows per Sort: 21.22

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.90
Execute to Parse %: 89.41 Latch Hit %: 98.84
Parse CPU to Parse Elapsd %: 51.02 % Non-Parse CPU: 97.38

Shared Pool Statistics

  Begin End
Memory Usage %: 66.28 91.99
% SQL with executions>1: 64.61 80.65
% Memory for SQL w/exec>1: 71.64 59.87

Top 5 Timed Events

Event Waits Time(s) Percent Total DB Time Wait Class
CPU time   24,901 55.48  
db file sequential read 776,411 3,230 7.20 User I/O
latch: cache buffers chains 102,687 1,096 2.44 Concurrency
log file sync 360,905 978 2.18 Commit
log file parallel write 1,343,916 852 1.90 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 776,411 0 3,230 4 0.80
latch: cache buffers chains 102,687 102,687 1,096 11 0.11
log file sync 360,905 0 978 3 0.37
log file parallel write 1,343,916 0 852 1 1.38
enq: UL - contention 4,128 35 560 136 0.00
enq: TX - row lock contention 616 111 349 567 0.00
db file parallel write 227,709 0 326 1 0.23
buffer busy waits 532,562 8 148 0 0.55
SQL*Net more data from client 1,821,495 0 123 0 1.88
read by other session 83,966 0 118 1 0.09
library cache pin 3,248 0 89 27 0.00
latch: In memory undo latch 5,991 0 59 10 0.01
enq: TX - index contention 14,313 0 56 4 0.01
latch: undo global data 5,963 0 51 9 0.01
db file scattered read 17,760 0 50 3 0.02
SQL*Net more data to client 1,597,480 0 45 0 1.64
rdbms ipc reply 17,904 5 32 2 0.02
latch free 2,643 2,546 31 12 0.00
SQL*Net message to client 35,026,603 0 27 0 36.07
library cache load lock 711 0 26 37 0.00
latch: library cache 7,615 0 25 3 0.01
SQL*Net break/reset to client 50,204 0 23 0 0.05
local write wait 3,304 0 18 6 0.00
enq: CI - contention 6,521 0 18 3 0.01
direct path read temp 9,890 0 17 2 0.01
LGWR wait for redo copy 46,169 71 9 0 0.05
library cache lock 309 0 8 26 0.00
enq: RO - fast object reuse 36 0 8 214 0.00
PX Deq Credit: send blkd 5,582 0 8 1 0.01
direct path write temp 3,171 0 6 2 0.00
control file parallel write 1,638 0 5 3 0.00
enq: HW - contention 2,687 0 4 2 0.00
enq: TX - contention 2,717 0 4 2 0.00
enq: TM - contention 2 0 4 1,768 0.00
enq: SQ - contention 3,735 0 3 1 0.00
latch: redo allocation 616 0 3 4 0.00
latch: library cache pin 1,261 0 2 2 0.00
PX Deq: Signal ACK 123 34 2 13 0.00
log file switch completion 35 0 1 32 0.00
control file sequential read 923 0 1 1 0.00
latch: cache buffers lru chain 148 0 1 7 0.00
enq: DV - contention 69 0 1 12 0.00
latch: row cache objects 102 0 1 8 0.00
row cache lock 869 0 1 1 0.00
process startup 17 0 0 29 0.00
enq: CU - contention 28 0 0 17 0.00
enq: FB - contention 1,030 0 0 0 0.00
latch: session allocation 104 0 0 3 0.00
latch: cache buffer handles 80 0 0 2 0.00
latch: shared pool 50 0 0 2 0.00
latch: object queue header operation 44 0 0 3 0.00
control file single write 134 0 0 1 0.00
latch: library cache lock 44 0 0 3 0.00
PX qref latch 10 9 0 11 0.00
buffer deadlock 5,980 5,957 0 0 0.01
kksfbc child completion 2 2 0 49 0.00
enq: TX - allocate ITL entry 167 0 0 1 0.00
direct path read 420 0 0 0 0.00
undo segment extension 16,791 16,742 0 0 0.02
latch: enqueue hash chains 15 0 0 3 0.00
latch: redo writing 13 0 0 3 0.00
direct path write 2,950 0 0 0 0.00
db file parallel read 1 0 0 6 0.00
latch: checkpoint queue latch 2 0 0 2 0.00
log file sequential read 2 0 0 1 0.00
enq: PS - contention 15 0 0 0 0.00
log file single write 2 0 0 0 0.00
PX Deq: Table Q qref 12 0 0 0 0.00
L1 validation 1 0 0 0 0.00
SQL*Net message from client 35,026,574 0 7,652,778 218 36.07
queue messages 6,756 6,054 41,096 6,083 0.01
pipe get 17,814 5,013 21,552 1,210 0.02
PL/SQL lock timer 710 709 8,191 11,536 0.00
PX Idle Wait 2,595 2,453 4,816 1,856 0.00
Queue Monitor Wait 123 123 3,583 29,134 0.00
wakeup time manager 1,760 914 2,754 1,565 0.00
PX Deq: Execution Msg 5,468 20 81 15 0.01
jobq slave wait 22 21 63 2,885 0.00
PX Deq: Execute Reply 3,823 1 15 4 0.00
PX Deq: Msg Fragment 1,035 0 2 2 0.00
PX Deq: Parse Reply 87 0 1 13 0.00
PX Deq Credit: need buffer 974 0 1 1 0.00
PX Deq: Table Q Normal 1,556 0 1 0 0.00
PX Deq: Table Q Sample 40 0 0 2 0.00
PX Deq: Join ACK 96 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,343,890 0 852 1 1.38
db file parallel write 227,709 0 326 1 0.23
LGWR wait for redo copy 46,170 71 9 0 0.05
db file scattered read 1,855 0 7 4 0.00
control file parallel write 1,634 0 5 3 0.00
latch: cache buffers chains 238 238 3 11 0.00
db file sequential read 883 0 2 2 0.00
rdbms ipc reply 7,114 0 1 0 0.01
latch free 141 131 1 10 0.00
control file sequential read 690 0 1 1 0.00
latch: redo allocation 264 0 1 2 0.00
latch: library cache 250 0 0 2 0.00
enq: CI - contention 54 0 0 4 0.00
buffer busy waits 576 0 0 0 0.00
latch: cache buffers lru chain 55 0 0 2 0.00
control file single write 133 0 0 1 0.00
direct path read 420 0 0 0 0.00
latch: redo writing 13 0 0 3 0.00
process startup 1 0 0 37 0.00
latch: library cache pin 21 0 0 2 0.00
latch: session allocation 8 0 0 3 0.00
direct path write 220 0 0 0 0.00
latch: shared pool 9 0 0 2 0.00
latch: object queue header operation 7 0 0 2 0.00
latch: In memory undo latch 8 0 0 1 0.00
latch: library cache lock 2 0 0 3 0.00
latch: undo global data 5 0 0 1 0.00
log file sequential read 2 0 0 1 0.00
latch: checkpoint queue latch 1 0 0 1 0.00
log file single write 2 0 0 0 0.00
undo segment extension 220 219 0 0 0.00
rdbms ipc message 677,543 9,543 26,928 40 0.70
Queue Monitor Wait 123 123 3,583 29,134 0.00
smon timer 53,148 0 3,555 67 0.05
wakeup time manager 1,760 914 2,754 1,565 0.00

Back to Wait Events Statistics
Back to Top

Time Model Statistics

Statistic Name Time (seconds) % Total DB Time
DB time 44,879.34 100.00
sql execute elapsed time 38,914.87 86.71
DB CPU 24,901.06 55.48
PL/SQL execution elapsed time 8,959.25 19.96
inbound PL/SQL rpc elapsed time 7,212.29 16.07
Java execution elapsed time 2,486.05 5.54
background elapsed time 2,204.50 4.91
parse time elapsed 1,224.60 2.73
hard parse elapsed time 843.74 1.88
background cpu time 583.59 1.30
sequence load elapsed time 23.00 0.05
connection management call elapsed time 15.27 0.03
PL/SQL compilation elapsed time 10.77 0.02
failed parse elapsed time 3.93 0.01
hard parse (sharing criteria) elapsed time 2.73 0.01
hard parse (bind mismatch) elapsed time 2.03 0.00
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,665,185
AVG_IDLE_TICKS 126,891
AVG_IN_BYTES 86,784
AVG_IOWAIT_TICKS 10,014
AVG_OUT_BYTES 905,472
AVG_SYS_TICKS 16,039
AVG_USER_TICKS 224,564
BUSY_TICKS 74,644,766
IDLE_TICKS 2,032,077
IN_BYTES 1,388,544
IOWAIT_TICKS 161,939
OS_CPU_WAIT_TIME 4,640,200
OUT_BYTES 14,487,552
RSRC_MGR_CPU_WAIT_TIME 0
SYS_TICKS 258,597
USER_TICKS 3,594,926

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
VIS 34,643.50 18,833.90 413,743 1,656,616,604
SYS$USERS 10,231.80 6,066.50 540,689 171,041,257
SYS$BACKGROUND 0.00 0.00 15,806 18,204,740

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 429,623 129,917 659,778 147,527 0 0 16,747,188 16,580
SYS$USERS 465,498 213,103 8,736 3,281 0 0 21,687,405 2,888
SYS$BACKGROUND 3,378 894 1,095 340 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,964 2,687 8 620.45 11.06 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
3,368 1,771 10 336.83 7.51 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
2,885 1,128 276 10.45 6.43 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,472 744 10 147.15 3.28 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,071 684 8 133.87 2.39 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
972 481 8 121.46 2.17 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
797 437 49,980 0.02 1.78 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
701 96 1,630 0.43 1.56 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
697 15 1,630 0.43 1.55 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
695 431 54,857 0.01 1.55 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
608 482 76,694 0.01 1.35 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
603 480 154,847 0.00 1.34 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
551 120 166,092 0.00 1.23 6gnth2mfbs2nq WSHFRREL declare v_ret number := 0...
501 262 975 0.51 1.12 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
499 265 8 62.32 1.11 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
489 316 5,000 0.10 1.09 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...

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,687 4,964 8 335.83 11.06 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
1,771 3,368 10 177.09 7.51 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,128 2,885 276 4.09 6.43 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
744 1,472 10 74.37 3.28 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
684 1,071 8 85.51 2.39 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
482 608 76,694 0.01 1.35 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
481 972 8 60.07 2.17 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
480 603 154,847 0.00 1.34 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
437 797 49,980 0.01 1.78 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
431 695 54,857 0.01 1.55 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
316 489 5,000 0.06 1.09 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
265 499 8 33.14 1.11 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
262 501 975 0.27 1.12 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
120 551 166,092 0.00 1.23 6gnth2mfbs2nq WSHFRREL declare v_ret number := 0...
96 701 1,630 0.06 1.56 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
15 697 1,630 0.01 1.55 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
239,659,840 8 29,957,480.00 12.98 2,686.64 4,963.62 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
167,759,314 10 16,775,931.40 9.09 1,770.86 3,368.35 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
127,978,690 8 15,997,336.25 6.93 480.52 971.72 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
120,250,674 49,980 2,405.98 6.51 437.46 797.05 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
106,174,425 8 13,271,803.13 5.75 684.10 1,070.93 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
84,023,742 154,847 542.62 4.55 480.39 602.54 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
81,634,949 10 8,163,494.90 4.42 743.67 1,471.52 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
48,745,291 276 176,613.37 2.64 1,128.33 2,885.48 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
45,193,653 8 5,649,206.63 2.45 272.90 390.12 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
44,949,409 8 5,618,676.13 2.44 154.37 384.94 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
42,720,179 8 5,340,022.38 2.31 165.61 340.94 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
39,136,891 54,857 713.43 2.12 430.58 695.16 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
38,123,429 166,060 229.58 2.07 312.28 420.90 gf1u933c95jb5 WSHFRREL DECLARE l_ret_stat varchar2...
38,122,936 166,058 229.58 2.07 330.34 441.33 3b3psftuyks81 WSHFRREL BEGIN INV_TXNSTUB_PUB.postTran...
35,634,935 5,000 7,126.99 1.93 316.14 488.61 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
34,788,273 984 35,353.94 1.88 149.59 230.21 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
33,282,078 8 4,160,259.75 1.80 191.61 281.25 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
27,741,885 48 577,955.94 1.50 148.88 309.41 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
26,810,724 2,072 12,939.54 1.45 150.30 247.65 4adc1zhg5cmx0 WSHINTERFACE UPDATE WSH_DELIVERY_DETAILS DD...
26,381,998 9,999 2,638.46 1.43 117.57 343.53 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
21,570,110 1,374,997 15.69 1.17 189.65 238.36 66tmsr3446uqn OEXOETEL SELECT WIAS.ACTIVITY_STATUS, ...

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
150,304 1,630 92.21 15.49 14.79 697.01 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
113,113 1,630 69.39 11.66 96.26 700.53 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
54,669 2,816 19.41 5.64 10.37 260.59 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
54,465 9,999 5.45 5.61 117.57 343.53 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
21,664 10 2,166.40 2.23 1,770.86 3,368.35 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
17,137 268,503 0.06 1.77 86.06 127.98 ccprbqfuu8wb1 WSHINTERFACE SELECT NUMBER_VALUE FROM WF_IT...
16,559 14,700 1.13 1.71 87.29 271.06 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
9,555 1 9,555.00 0.98 30.01 42.46 gczkkgwgkyjh3 SQL*Plus select /*+ parallel(t, 8) para...
2,826 8 353.25 0.29 272.90 390.12 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
2,427 8 303.38 0.25 191.61 281.25 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,374,997 712,433 0.52 0.00 0.00 66tmsr3446uqn OEXOETEL SELECT WIAS.ACTIVITY_STATUS, ...
865,962 865,962 1.00 0.00 0.00 cgb6kp2umq52a   select t.schema, t.name, t.f...
865,678 865,678 1.00 0.00 0.00 8bsm049u7thjd   select min(next_date) from "AP...
784,308 784,027 1.00 0.00 0.00 cd9mbmqyf4qhp OEXOETEL UPDATE WF_ITEM_ACTIVITY_STATUS...
731,652 731,116 1.00 0.00 0.00 gnhmcahkmrnzs OEXOETEL INSERT INTO WF_ITEM_ACTIVITY_S...
426,540 426,583 1.00 0.00 0.00 821fx90awyvj7 OEXOETEL SELECT ACCOUNTING_RULE_ID , A...
410,265 410,229 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
268,503 267,709 1.00 0.00 0.00 ccprbqfuu8wb1 WSHINTERFACE SELECT NUMBER_VALUE FROM WF_IT...
254,432 198,120 0.78 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
219,964 217,524 0.99 0.00 0.00 91hakq9n36htp ap.oie.server.WebExpensesAM SELECT TEXT_VALUE FROM WF_ITEM...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
865,962 865,962 10.28 cgb6kp2umq52a   select t.schema, t.name, t.f...
865,678 1,416 10.27 20rc3cmapyvnz   select q_name, state, delay,...
865,678 865,678 10.27 8bsm049u7thjd   select min(next_date) from "AP...
410,274 410,265 4.87 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
254,548 254,432 3.02 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
166,037 166,092 1.97 6gnth2mfbs2nq WSHFRREL declare v_ret number := 0...
111,255 111,255 1.32 1c0b7sas42w2z WSHFRREL SELECT NVL(ITEM_COST, 0), ...
87,825 87,885 1.04 76sw2a4vnc89j ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.S...
83,795 83,783 0.99 bf7uwg5pa3pj6 ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.V...
83,788 87,854 0.99 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
5,313,112 8 0.16 awz0s801s8fh2 RAXMTR select /*+ parallel(t, 8) para...
2,218,920 8 0.07 45z5kajtbgmj0 RAXMTR select /*+ parallel(t, 8) para...
1,064,052 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 )
37f1qguwxw0sk begin IF ( :v_msg_level:i_msg_level > 0 ) THEN arp_util . enable_debug ( 1000000 ) ; arp_global . msg_level := :v_msg_level:i_msg_level ; END IF ; arp_auto_accounting . g_error_buffer := NULL ; :v_num_failed_dist_rows:i_num_failed_dist_rows := 0 ; :v_coa_id:i_coa_id := arp_standard . gl_chart_of_accounts_id ; :v_retval:i_retval := 1 ; arp_auto_accounting . do_autoaccounting ( :v_mode:i_vmode , :v_account_class , :v_trx_id:i_trx_id , :v_line_id:i_line_id , :v_line_salesrep_id:i_line_salesr ep_id , :v_request_id:i_request_id , :v_gl_date , :v_orig_gl_date , :v_total_trx_amount:i_total_trx_amount , :v_passed_ccid:i_passed_ccid , :v_force_acct_set_no , :v_cust_trx_type_id:i_cust_trx_type_id , :v_primary_salesrep_id:i_primary_salesrep_id , :v_inv_item_id:i_inv_item_id , :v_memo_line_id:i_memo_line_id , :v_ccid:i_ccid , :v_concat_segments:i_concat_segments , :v_num_failed_dist_rows:i_num_failed_dist_rows ) ; IF ( :v_mode:i_vmode = 'G' AND :v_ccid:i_ccid = -1 ) THEN :v_retv al:i_retval := 0 ; END IF ; EXCEPTION WHEN arp_auto_accounting . no_ccid THEN :v_retval:i_retval := 0 ; WHEN NO_DATA_FOUND THEN NULL ; WHEN OTHERS THEN arp_util . debug ( 'arcdaa()' ) ; arp_util . debug ( SQLERRM ) ; :v_errorbuf:i_errorbuf := arp_auto_accounting . g_error_buffer ; :v_sqlcode:i_sqlcode := SQLCODE ; END ;
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3dssuqfjsynrk SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, ' CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustPa rty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.sta tus_code = :4 ORDER BY age ) )
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 ;
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
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6gnth2mfbs2nq declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7 BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
72cqcsuq5wgh0 SELECT aslrt.meaning as rank_name , aslrt.rank_id, sum(case when asl.status_open_flag = 'Y' AND round(sysdate-asl.creation_date)<= 2 THEN 1 else 0 END) as day0_2, sum(case when asl.status_open_flag = 'Y' AND round((sysdate - asl.creation_date)) between 3 and 7 THEN 1 else 0 END) as day3_7, sum(case when asl.status_open_flag = 'Y' AND round((sysdate - asl.creation_date)) between 8 and 30 THEN 1 else 0 END) as day8_30, sum(case when asl.status_open_fla g = 'Y' AND round((sysdate - asl.creation_date)) >= 31 THEN 1 else 0 END) as day_31, sum(case when nvl(asl.status_open_flag, 'N') = 'N' AND asl.status_code <> 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END) as closed, sum(case when asl.status_code = 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END) as converted, round((sum(case when asl.status_code = 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END)/count(asl.sales_lead_id)) * 100, 2) as conversion, count(aslrt.ra nk_id) total_leads FROM as_sales_leads asl, as_sales_lead_ranks_tl aslrt, as_sales_lead_ranks_b aslrb, ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id , aaa.customer_id FROM as_accesses_all aaa WHERE aaa.lead_id is null AND aaa.sales_lead_id IS NOT NULL AND aaa.salesforce_id = :1)secu WHERE asl.lead_rank_id = aslrt.rank_id AND aslrb.rank_id = aslrt.rank_id AND aslrt.language = USERENV('LANG') AND secu.sa les_lead_id = asl.sales_lead_id AND secu.customer_id = asl.customer_id GROUP BY aslrt.rank_id, aslrt.meaning, aslrb.min_score ORDER BY aslrb.min_score DESC
76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7g05xfvc5vp74 BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END;
815ygd4pc1bpd INSERT INTO RA_CUSTOMER_TRX_LINES ( customer_trx_line_id, last_update_date, last_updated_by, creation_date, created_by, last_update_login, customer_trx_id, interface_line_attribute1, interface_line_attribute2, interface_line_attribute3, interface_line_attribute4, interface_line_attribute5, interface_line_attribute6, interface_line_attribute7, interface_line_attribute8, interface_line_attribute9, interface_line_attribute10, interface_line_attribute11, interface_line_attribute12, interface_line_attribute13, interface_line_attribute14, interface_line_attribute15, interface_line_context, line_number, set_of_books_id, reason_code, inventory_item_id, description, translated_description, previous_customer_trx_id, previous_customer_trx_line_id, initial_customer_trx_line_id, quantity_ordered, quantity_credited, quantity_invoiced, unit_standard_price, unit_selling_price, amount_includes_tax_flag, uom_code, sales_order, sales_order_line, sales_order_date, sales_order_source, sales_order_revision, accounting_rule_id, accounting_rule_duration, line_type, rule_start_date, extended_amount, taxable_amount, revenue_amount, link_to_cust_trx_line_id, sales_tax_id, location_segment_id, vat_tax_id, tax_precedence, tax_rate, item_exception_rate_id, tax_exemption_id, memo_line_id, attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribut e11, attribute12, attribute13, attribute14, attribute15, global_attribute_category, global_attribute1, global_attribute2, global_attribute3, global_attribute4, global_attribute5, global_attribute6, global_attribute7, global_attribute8, global_attribute9, global_attribute10, global_attribute11, global_attribute12, global_attribute13, global_attribute14, global_attribute15, global_attribute16, global_attribute17, global_attribute18, global_attribute19, global_attribute20, request_id, program_application_id, program_id, program_update_date, default_ussgl_transaction_code, autorule_complete_flag, last_period_to_credit, tax_exempt_flag, tax_exempt_reason_code, tax_exempt_number, movement_id, payment_set_id, warehouse_id, contract_line_id, invoiced_line_acctg_level, source_data_key1, source_data_key2, source_data_key3, source_data_key4, source_data_key5) SELECT l.interface_line_id, sysdate, :b1, sysdate, :b2, :b3, l.customer_trx_id, l.inter face_line_attribute1, l.interface_line_attribute2, l.interface_line_attribute3, l.interface_line_attribute4, l.interface_line_attribute5, l.interface_line_attribute6, l.interface_line_attribute7, l.interface_line_attribute8, l.interface_line_attribute9, l.interface_line_attribute10, l.interface_line_attribute11, l.interface_line_attribute12, l.interface_line_attribute13, l.interface_line_attribute14, l.interface_line_attribute15, substr(decode(l.interface_line_context, 'Global Dat a Elements', null, l.interface_line_context), 1, 30), l.line_number, l.set_of_books_id, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.reason_code, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.inventory_item_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.description, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.t ranslated_description, null), null, null, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.reference_line_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.quantity_ordered, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(t.type, 'CM', l.quantity, null), null), decode(l.line_type, 'LINE', decode(t.type, 'CM', null, nvl(l.quantity, 1)), 'CHARGES', 1, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.unit_standard_price, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', nvl(l.unit_selling_price, decode(t.type, 'CM', decode(l.credit_method_for_acct_rule, 'UNIT', l.amount/l.quantity, null), decode(l.quantity, 0, l.amount, null, l.amount, ROUND(l.amount/l.quantity, 15)))), null), l.amount_includes_tax_flag, decode(l.line_type, 'LINE', l.uom_code, 'CHARGES', null, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.sales_order, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', ltrim(l.sales_order_line) , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type) , 'LINE', l.sales_order_date , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.sales_order_source , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.sales_order_revision , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.accounting_rule_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.accounting_rule_id, null, null, decode(r.type, 'A', r.occurrences, l.accounting_rule_duration)), null), l.line_type, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.accounting_rule_id, null, null, l.rule_start_date), null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.quantity * l.unit_selling_pr ice, null, nvl(l.amount, 0), decode(c.minimum_accountable_unit, null, round(l.quantity * l.unit_selling_price, c.precision), round(l.quantity * l.unit_selling_price / c.minimum_accountable_unit)* c.minimum_accountable_unit)), 'TAX', decode(l.amount, null, decode(l.tax_precedence, null, deco de(parent.quantity * parent.unit_selling_price, null, decode(c.minimum_accountable_unit, null, round(nvl(parent.amount, 0) * (nvl(l.tax_rate, 0)/100), c.precision), round(nvl(parent.amount, 0) * (nvl(l.tax_rate, 0)/100)/ c.minimum_accountable_unit) * c.minimum_accountable_unit), decode(c.minimum_accountable_unit, null, round(parent.quantity * parent.unit_selling_price * (nvl(l.tax_rate, 0)/100), c.precision), round(parent.quantity * parent.unit_selling_price * (nvl(l.tax_rate, 0)/100)/ c.minimum_accountable_unit) * c.minimum_accountable_unit)), 0), nvl(l.amount, 0)), nvl(l.amount, 0)), decode(l.line_type, 'TAX', decode(l.tax_precedence, n ull, decode(parent.quantity * parent.unit_selling_price, null, decode(c.minimum_accountable_unit, null, round(nvl(parent.amount, 0), c.precision), round(nvl(parent.amount, 0) / c.minimum_accountable_unit) * c.minimum_accountable_unit), decode(c.minimum_accountable_unit, null, round(parent.quantity * parent.unit_selling_price , c.precision), round(parent.quantity * parent.unit_selling_price / c.minimum_accountable_ unit) * c.minimum_accountable_unit)), 0), null), decode(l.line_type, 'LINE', nvl(l.amount, 0), 'CHARGES', null, null), decode(l.line_type, 'TAX', l.link_to_line_id, 'FREIGHT', l.link_to_line_id, null), decode(l.line_type, 'TAX', l.sales_tax_id, null), decode(l.line_type, 'TAX', l.location_segment_id, null), decode(l.line_type, 'TAX', l.vat_tax_id, 'LINE', l.vat_tax_id, null), decode(l.l ine_type, 'TAX', l.tax_precedence, null), decode(l.line_type, 'TAX', l.tax_rate, null), decode(l.line_type, 'TAX', l.exception_id, null), decode(l.line_type, 'TAX', l.exemption_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.memo_line_id, null), l.attribute_category, rtrim(l.attribute1), rtrim(l.attribute2), rtrim(l.attribute3), rtrim(l.attribute4), rtrim(l.attribute5), rtrim(l.attribute6), rtrim(l.attribute7), rtrim(l.attribute8), rtrim(l.attribute9), rtrim(l.attribute10), rtrim(l.attribute11), rtrim(l.attribute12), rtrim(l.attribute13), rtrim(l.attribute14), rtrim(l.attribute15), l.line_gdf_attr_category, l.line_gdf_attribute1, l.line_gdf_attribute2, l.line_gdf_attribute3, l.line_gdf_attribute4, l.line_gdf_attribute5, l.line_gdf_attribute6, l.line_gdf_attribute7, l.line_gdf_attribute8, l.line_gdf_attribute9, l.line_gdf_attribute10, l.line_gdf_attribute11, l.line_gdf_attribute12, l.line_gdf_attribute1 3, l.line_gdf_attribute14, l.line_gdf_attribute15, l.line_gdf_attribute16, l.line_gdf_attribute17, l.line_gdf_attribute18, l.line_gdf_attribute19, l.line_gdf_attribute20, :b4, :b5, :b6, sysdate, l.ussgl_transaction_code, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.accounting_rule_id, null, null, 'N'), null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.credit_method_for_acct_rule, 'UNIT' , null, null), null), decode(l.line_type, 'LINE', l.tax_exempt_flag, null), decode(l.line_type, 'LINE', decode(l.tax_exempt_flag, 'E', l.tax_exempt_reason_code, null), null), decode(l.line_type, 'LINE', decode(l.tax_exempt_flag, 'E', l.tax_exempt_number, null), null), l.movement_id, l.payment_set_id, l.warehouse_id, l.contract_line_id, l.invoiced_line_acctg_level, l.source_data_key1, l.source_data_ key2, l.source_data_key3, l.source_data_key4, l.source_data_key5 FROM FND_CURRENCIES C, RA_CUST_TRX_TYPES t, RA_RULES r, RA_INTERFACE_LINES_GT parent, RA_INTERFACE_LINES_GT l WHERE l.request_id = :b7 AND l.currency_code = c.currency_code AND l.cust_trx_type_id = t.cust_trx_type_id AND l.accounting_rule_id = r.rule_id(+) AND l.customer_trx_id is not null AND l.link_to_line_id = parent.interface_line_id(+) AND nvl(l.interface_status, '~') != 'P'
821fx90awyvj7 SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOO KED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET _PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST _CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , RE FERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_ LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE _TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRIBUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
8bsm049u7thjd select min(next_date) from "APPLSYS"."AQ$_WF_DEFERRED_TABLE_M_T"
8c30hkqv9n7cr BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
8c8cf4vtv4tx2 SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNI TY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age )
8vmj377jqyqwq BEGIN WSH_BATCH_PROCESS.CONFIRM_DELIVERY_SRS( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14, :A15, :A16, :A17, :A18, :A19, :A20, :A21, :A22); END;
91hakq9n36htp SELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :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,798,379 488.89 1.85
CPU used when call started 1,803,078 490.17 1.86
CR blocks created 14,110,021 3,835.83 14.53
Cached Commit SCN referenced 997,017 271.04 1.03
Commit SCN cached 555 0.15 0.00
DB time 11,278,653 3,066.12 11.61
DBWR checkpoint buffers written 1,399,645 380.50 1.44
DBWR checkpoints 37 0.01 0.00
DBWR object drop buffers written 59,001 16.04 0.06
DBWR revisited being-written buffer 1,208 0.33 0.00
DBWR thread checkpoint buffers written 105,463 28.67 0.11
DBWR transaction table writes 5,991 1.63 0.01
DBWR undo block writes 1,547,638 420.73 1.59
DFO trees parallelized 18 0.00 0.00
IMU CR rollbacks 38,697,915 10,520.10 39.85
IMU Flushes 310,540 84.42 0.32
IMU Redo allocation size 2,125,973,732 577,949.76 2,189.06
IMU bind flushes 1,204 0.33 0.00
IMU commits 498,302 135.46 0.51
IMU contention 32,105 8.73 0.03
IMU ktichg flush 11,078 3.01 0.01
IMU pool not allocated 255 0.07 0.00
IMU recursive-transaction flush 1,341 0.36 0.00
IMU undo allocation size 4,598,150,272 1,250,015.37 4,734.60
IMU- failed to get a private strand 255 0.07 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 21,370 5.81 0.02
PX local messages sent 21,370 5.81 0.02
Parallel operations downgraded 25 to 50 pct 15 0.00 0.00
Parallel operations downgraded to serial 18 0.00 0.00
Parallel operations not downgraded 3 0.00 0.00
SQL*Net roundtrips to/from client 35,013,953 9,518.61 36.05
active txn count during cleanout 71,532,849 19,446.33 73.66
application wait time 94,332 25.64 0.10
background checkpoints completed 2 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 10,520 2.86 0.01
branch node splits 961 0.26 0.00
buffer is not pinned count 590,784,319 160,605.77 608.32
buffer is pinned count 1,262,337,257 343,168.64 1,299.80
bytes received via SQL*Net from client 8,007,869,215 2,176,953.55 8,245.50
bytes sent via SQL*Net to client 7,404,731,061 2,012,989.37 7,624.47
calls to get snapshot scn: kcmgss 95,194,899 25,878.90 98.02
calls to kcmgas 17,761,193 4,828.41 18.29
calls to kcmgcs 8,030,041 2,182.98 8.27
change write time 76,475 20.79 0.08
cleanout - number of ktugct calls 21,253,018 5,777.67 21.88
cluster key scan block gets 547,402 148.81 0.56
cluster key scans 92,306 25.09 0.10
commit cleanout failures: block lost 223,373 60.72 0.23
commit cleanout failures: buffer being written 68 0.02 0.00
commit cleanout failures: callback failure 103,153 28.04 0.11
commit cleanout failures: cannot pin 30,577 8.31 0.03
commit cleanouts 8,257,554 2,244.83 8.50
commit cleanouts successfully completed 7,900,392 2,147.74 8.13
commit txn count during cleanout 974,031 264.79 1.00
concurrency wait time 151,148 41.09 0.16
consistent changes 758,062,377 206,080.61 780.56
consistent gets 1,637,744,025 445,223.64 1,686.34
consistent gets - examination 1,172,614,922 318,777.46 1,207.41
consistent gets from cache 1,637,744,024 445,223.64 1,686.34
current blocks converted for CR 1,117 0.30 0.00
cursor authentications 2,379 0.65 0.00
data blocks consistent reads - undo records applied 754,234,874 205,040.10 776.62
db block changes 188,241,014 51,173.66 193.83
db block gets 208,136,635 56,582.32 214.31
db block gets direct 7,385 2.01 0.01
db block gets from cache 208,129,253 56,580.31 214.31
deferred (CURRENT) block cleanout applications 1,690,841 459.66 1.74
dirty buffers inspected 696,118 189.24 0.72
enqueue conversions 8,417 2.29 0.01
enqueue releases 8,246,051 2,241.70 8.49
enqueue requests 8,254,743 2,244.07 8.50
enqueue timeouts 8,184 2.22 0.01
enqueue waits 34,220 9.30 0.04
exchange deadlocks 5,980 1.63 0.01
execute count 79,572,170 21,631.84 81.93
failed probes on index block reclamation 13,767 3.74 0.01
free buffer inspected 4,807,143 1,306.83 4.95
free buffer requested 18,672,716 5,076.21 19.23
heap block compress 25,844,151 7,025.78 26.61
hot buffers moved to head of LRU 2,579,133 701.14 2.66
immediate (CR) block cleanout applications 12,734,959 3,462.02 13.11
immediate (CURRENT) block cleanout applications 1,099,946 299.02 1.13
index fast full scans (full) 269,804 73.35 0.28
index fast full scans (rowid ranges) 191 0.05 0.00
index fetch by key 164,518,698 44,724.70 169.40
index scans kdiixs1 112,176,910 30,495.49 115.51
java call heap collected bytes 810,247,376 220,267.20 834.29
java call heap collected count 10,728,799 2,916.64 11.05
java call heap gc count 998 0.27 0.00
java call heap live object count 243,143 66.10 0.25
java call heap live object count max 244,179 66.38 0.25
java call heap live size 58,561,704 15,920.10 60.30
java call heap live size max 58,705,928 15,959.31 60.45
java call heap object count 4,388,198 1,192.94 4.52
java call heap object count max 4,396,485 1,195.19 4.53
java call heap total size 185,073,664 50,312.61 190.57
java call heap total size max 185,073,664 50,312.61 190.57
java call heap used size 367,287,776 99,847.84 378.19
java call heap used size max 368,278,832 100,117.26 379.21
leaf node 90-10 splits 18,947 5.15 0.02
leaf node splits 231,531 62.94 0.24
logons cumulative 7,284 1.98 0.01
messages received 934,018 253.91 0.96
messages sent 934,018 253.91 0.96
no buffer to keep pinned count 18 0.00 0.00
no work - consistent read gets 348,259,528 94,674.97 358.59
opened cursors cumulative 6,618,520 1,799.26 6.81
parse count (failures) 2,452 0.67 0.00
parse count (hard) 8,126 2.21 0.01
parse count (total) 8,427,854 2,291.13 8.68
parse time cpu 65,212 17.73 0.07
parse time elapsed 127,824 34.75 0.13
physical read IO requests 803,346 218.39 0.83
physical reads 970,106 263.73 1.00
physical reads cache 903,968 245.75 0.93
physical reads cache prefetch 109,527 29.78 0.11
physical reads direct 66,138 17.98 0.07
physical reads direct temporary tablespace 65,718 17.87 0.07
physical reads prefetch warmup 24,323 6.61 0.03
physical write IO requests 1,018,678 276.93 1.05
physical writes 2,687,064 730.48 2.77
physical writes direct 73,323 19.93 0.08
physical writes direct (lob) 3,418 0.93 0.00
physical writes direct temporary tablespace 69,583 18.92 0.07
physical writes from cache 2,613,741 710.55 2.69
physical writes non checkpoint 2,377,144 646.23 2.45
pinned buffers inspected 5,738 1.56 0.01
prefetch warmup blocks aged out before use 223,043 60.63 0.23
prefetched blocks aged out before use 1,138 0.31 0.00
process last non-idle time 3,678 1.00 0.00
queries parallelized 18 0.00 0.00
recursive aborts on index block reclamation 4 0.00 0.00
recursive calls 134,663,378 36,608.48 138.66
recursive cpu usage 1,097,482 298.35 1.13
redo blocks written 62,008,970 16,857.25 63.85
redo buffer allocation retries 19 0.01 0.00
redo entries 97,022,893 26,375.85 99.90
redo log space requests 35 0.01 0.00
redo log space wait time 124 0.03 0.00
redo ordering marks 1,247,340 339.09 1.28
redo size 30,415,407,072 8,268,482.75 31,317.99
redo synch time 98,992 26.91 0.10
redo synch writes 411,735 111.93 0.42
redo wastage 295,108,156 80,225.68 303.87
redo write time 87,885 23.89 0.09
redo writer latching time 913 0.25 0.00
redo writes 672,169 182.73 0.69
rollback changes - undo records applied 247,874 67.38 0.26
rows fetched via callback 126,086,507 34,276.84 129.83
session connect time 0 0.00 0.00
session cursor cache hits 3,430,857 932.68 3.53
session logical reads 1,845,878,943 501,805.49 1,900.66
session pga memory 8,804,860,520 2,393,617.06 9,066.15
session pga memory max 10,527,109,800 2,861,813.60 10,839.50
session uga memory 11,830,580,864 3,216,164.54 12,181.66
session uga memory max 57,157,674,808 15,538,416.00 58,853.84
shared hash latch upgrades - no wait 126,000,039 34,253.34 129.74
shared hash latch upgrades - wait 182,104 49.51 0.19
sorts (disk) 4 0.00 0.00
sorts (memory) 10,687,045 2,905.29 11.00
sorts (rows) 226,749,816 61,642.34 233.48
summed dirty queue length 3,390,158 921.62 3.49
switch current to new buffer 1,166,557 317.13 1.20
table fetch by rowid 788,687,168 214,406.02 812.09
table fetch continued row 29,878,271 8,122.46 30.76
table scan blocks gotten 57,996,956 15,766.58 59.72
table scan rows gotten 1,882,504,540 511,762.22 1,938.37
table scans (long tables) 4,390 1.19 0.00
table scans (rowid ranges) 4,368 1.19 0.00
table scans (short tables) 5,418,629 1,473.06 5.58
transaction rollbacks 4,056 1.10 0.00
transaction tables consistent read rollbacks 45 0.01 0.00
transaction tables consistent reads - undo records applied 2,295 0.62 0.00
undo change vector size 10,631,712,596 2,890,250.06 10,947.21
user I/O wait time 343,902 93.49 0.35
user calls 33,645,533 9,146.60 34.64
user commits 785,551 213.55 0.81
user rollbacks 185,629 50.46 0.19
workarea executions - onepass 8 0.00 0.00
workarea executions - optimal 5,845,138 1,589.01 6.02
write clones created in background 3,303 0.90 0.00
write clones created in foreground 745 0.20 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 103,161 243,830
opened cursors current 671,526 869,278
workarea memory allocated 3,813 1,066
logons current 3,699 3,727

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 23,099 6 1.59 1.00 601,194 163 190,206 0.24
APPS_TS_TX_DATA 441,894 120 4.42 1.06 116,544 32 78,764 0.65
APPS_TS_TX_IDX 211,448 57 4.74 1.05 110,880 30 50,861 0.63
APPS_ASSM_DATA 64,211 17 1.45 1.82 74,891 20 168,826 0.48
APPS_ASSM_IDX 26,859 7 2.29 1.02 60,068 16 77,554 0.37
TEMP 11,562 3 20.23 6.24 23,325 6 250 28.00
APPS_TS_TX_INTERFACE 2,074 1 4.64 2.10 14,436 4 38,262 0.37
APPS_TS_SEED 10,868 3 6.48 1.12 4,084 1 946 2.98
SYSTEM 8,558 2 4.16 2.48 1,896 1 8,316 0.83
APPS_TS_QUEUES 632 0 5.00 1.14 6,015 2 71 1.83
APPS_TS_SUMMARY 191 0 7.80 1.00 2,940 1 1,816 0.32
CTXSYS 475 0 5.96 1.04 1,342 0 3 0.00
APPS_TS_ARCHIVE 220 0 4.77 1.00 619 0 22 42.27
SYSAUX 402 0 3.06 1.88 327 0 11 8.18
APPS_TS_NOLOGGING 37 0 14.32 1.38 38 0 0 0.00
APPS_TS_MEDIA 6 0 28.33 1.00 6 0 0 0.00
ODM 5 0 6.00 1.00 2 0 0 0.00
OLAP 5 0 10.00 1.00 2 0 0 0.00
OWAPUB 5 0 8.00 1.00 2 0 0 0.00
PORTAL 5 0 10.00 1.00 2 0 0 0.00
SYNCSERVER 5 0 48.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 64,211 17 1.45 1.82 74,891 20 168,826 0.48
APPS_ASSM_IDX /oasb_data/apps_assm_idx.dbf 26,859 7 2.29 1.02 60,068 16 77,554 0.37
APPS_TS_ARCHIVE /oasb_data/archive1.dbf 92 0 4.35 1.00 287 0 12 75.83
APPS_TS_ARCHIVE /oasb_data/archive2.dbf 128 0 5.08 1.00 332 0 10 2.00
APPS_TS_MEDIA /oasb_data/media1.dbf 2 0 10.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /oasb_data/media2.dbf 2 0 10.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /oasb_data/media3.dbf 2 0 65.00 1.00 2 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging1.dbf 25 0 9.60 1.56 34 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging2.dbf 6 0 16.67 1.00 2 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging3.dbf 6 0 31.67 1.00 2 0 0 0.00
APPS_TS_QUEUES /oasb_data/queues1.dbf 30 0 8.33 1.43 459 0 3 3.33
APPS_TS_QUEUES /oasb_data/queues2.dbf 103 0 6.02 1.42 752 0 10 0.00
APPS_TS_QUEUES /oasb_data/queues3.dbf 89 0 3.82 1.07 930 0 23 1.74
APPS_TS_QUEUES /oasb_data/queues4.dbf 110 0 4.09 1.03 940 0 11 0.00
APPS_TS_QUEUES /oasb_data/queues5.dbf 105 0 4.19 1.10 979 0 5 12.00
APPS_TS_QUEUES /oasb_data/queues6.dbf 108 0 5.56 1.01 1,042 0 13 1.54
APPS_TS_QUEUES /oasb_data/queues7.dbf 87 0 5.29 1.15 913 0 6 0.00
APPS_TS_SEED /oasb_data/reference1.dbf 1,192 0 4.84 1.10 288 0 249 3.21
APPS_TS_SEED /oasb_data/reference10.dbf 852 0 8.71 1.15 319 0 0 0.00
APPS_TS_SEED /oasb_data/reference2.dbf 1,366 0 4.97 1.11 351 0 686 2.84
APPS_TS_SEED /oasb_data/reference3.dbf 1,071 0 6.51 1.12 456 0 9 6.67
APPS_TS_SEED /oasb_data/reference4.dbf 1,053 0 6.51 1.06 475 0 1 0.00
APPS_TS_SEED /oasb_data/reference5.dbf 1,086 0 6.54 1.16 445 0 0 0.00
APPS_TS_SEED /oasb_data/reference6.dbf 1,083 0 5.34 1.18 428 0 0 0.00
APPS_TS_SEED /oasb_data/reference7.dbf 1,036 0 8.52 1.11 443 0 0 0.00
APPS_TS_SEED /oasb_data/reference8.dbf 1,054 0 6.54 1.14 446 0 1 10.00
APPS_TS_SEED /oasb_data/reference9.dbf 1,075 0 7.44 1.12 433 0 0 0.00
APPS_TS_SUMMARY /oasb_data/summary1.dbf 16 0 2.50 1.00 425 0 210 0.38
APPS_TS_SUMMARY /oasb_data/summary2.dbf 4 0 7.50 1.00 61 0 60 0.17
APPS_TS_SUMMARY /oasb_data/summary3.dbf 30 0 11.67 1.00 454 0 213 0.14
APPS_TS_SUMMARY /oasb_data/summary4.dbf 25 0 3.20 1.00 354 0 239 0.25
APPS_TS_SUMMARY /oasb_data/summary5.dbf 12 0 4.17 1.00 381 0 435 0.55
APPS_TS_SUMMARY /oasb_data/summary6.dbf 22 0 12.73 1.00 418 0 179 0.11
APPS_TS_SUMMARY /oasb_data/summary7.dbf 16 0 3.75 1.00 399 0 223 0.18
APPS_TS_SUMMARY /oasb_data/summary8.dbf 66 0 9.09 1.00 448 0 257 0.43
APPS_TS_TX_DATA /oasb_data/tx_data1.dbf 1,582 0 4.08 1.25 4,282 1 3,647 0.72
APPS_TS_TX_DATA /oasb_data/tx_data10.dbf 1,456 0 4.31 1.19 4,304 1 3,640 0.62
APPS_TS_TX_DATA /oasb_data/tx_data11.dbf 1,672 0 3.50 1.18 4,442 1 4,161 0.94
APPS_TS_TX_DATA /oasb_data/tx_data12.dbf 39,236 11 4.17 1.04 6,638 2 3,353 0.90
APPS_TS_TX_DATA /oasb_data/tx_data13.dbf 39,196 11 4.78 1.03 6,570 2 3,373 0.47
APPS_TS_TX_DATA /oasb_data/tx_data14.dbf 39,032 11 4.73 1.03 6,484 2 3,870 0.75
APPS_TS_TX_DATA /oasb_data/tx_data15.dbf 38,853 11 4.50 1.03 6,297 2 4,287 0.58
APPS_TS_TX_DATA /oasb_data/tx_data16.dbf 38,771 11 4.54 1.03 6,227 2 3,768 0.45
APPS_TS_TX_DATA /oasb_data/tx_data17.dbf 38,951 11 4.15 1.03 6,264 2 3,610 0.30
APPS_TS_TX_DATA /oasb_data/tx_data18.dbf 38,753 11 4.82 1.03 6,348 2 3,633 0.34
APPS_TS_TX_DATA /oasb_data/tx_data19.dbf 38,740 11 4.71 1.03 6,148 2 3,019 0.54
APPS_TS_TX_DATA /oasb_data/tx_data2.dbf 1,820 0 3.23 1.88 4,399 1 4,046 0.81
APPS_TS_TX_DATA /oasb_data/tx_data20.dbf 38,632 11 4.50 1.04 6,065 2 3,531 0.43
APPS_TS_TX_DATA /oasb_data/tx_data21.dbf 38,271 10 4.49 1.03 6,316 2 3,349 0.49
APPS_TS_TX_DATA /oasb_data/tx_data3.dbf 2,498 1 3.48 1.67 4,481 1 4,048 0.60
APPS_TS_TX_DATA /oasb_data/tx_data4.dbf 10,160 3 1.22 1.16 8,357 2 4,011 0.76
APPS_TS_TX_DATA /oasb_data/tx_data5.dbf 12,541 3 4.11 1.14 4,444 1 3,735 0.72
APPS_TS_TX_DATA /oasb_data/tx_data6.dbf 4,109 1 4.61 1.37 4,487 1 4,003 0.70
APPS_TS_TX_DATA /oasb_data/tx_data7.dbf 12,099 3 4.40 1.15 4,556 1 3,349 0.89
APPS_TS_TX_DATA /oasb_data/tx_data8.dbf 2,528 1 3.51 1.62 4,936 1 4,569 0.76
APPS_TS_TX_DATA /oasb_data/tx_data9.dbf 2,994 1 3.51 1.50 4,499 1 3,762 0.66
APPS_TS_TX_IDX /oasb_data/tx_idx1.dbf 1,560 0 4.04 1.06 2,158 1 1,179 0.98
APPS_TS_TX_IDX /oasb_data/tx_idx10.dbf 2,215 1 6.29 1.04 5,232 1 1,288 0.54
APPS_TS_TX_IDX /oasb_data/tx_idx11.dbf 2,217 1 4.96 1.03 4,175 1 2,509 1.55
APPS_TS_TX_IDX /oasb_data/tx_idx12.dbf 17,657 5 5.18 1.05 7,562 2 2,759 0.37
APPS_TS_TX_IDX /oasb_data/tx_idx13.dbf 17,613 5 5.06 1.06 7,456 2 2,937 0.70
APPS_TS_TX_IDX /oasb_data/tx_idx14.dbf 17,696 5 4.72 1.05 7,446 2 2,512 0.20
APPS_TS_TX_IDX /oasb_data/tx_idx15.dbf 17,519 5 5.04 1.05 7,385 2 2,893 1.20
APPS_TS_TX_IDX /oasb_data/tx_idx16.dbf 17,304 5 4.09 1.06 7,100 2 2,379 0.32
APPS_TS_TX_IDX /oasb_data/tx_idx17.dbf 17,214 5 5.13 1.05 7,145 2 2,219 0.23
APPS_TS_TX_IDX /oasb_data/tx_idx18.dbf 17,260 5 5.14 1.05 7,313 2 2,529 0.40
APPS_TS_TX_IDX /oasb_data/tx_idx19.dbf 17,304 5 4.66 1.06 7,019 2 2,425 0.31
APPS_TS_TX_IDX /oasb_data/tx_idx2.dbf 2,451 1 5.23 1.03 3,518 1 6,455 0.63
APPS_TS_TX_IDX /oasb_data/tx_idx20.dbf 17,092 5 5.06 1.04 6,842 2 2,234 0.36
APPS_TS_TX_IDX /oasb_data/tx_idx21.dbf 16,972 5 4.12 1.05 7,125 2 2,742 0.42
APPS_TS_TX_IDX /oasb_data/tx_idx3.dbf 3,350 1 4.51 1.04 4,184 1 1,645 0.71
APPS_TS_TX_IDX /oasb_data/tx_idx4.dbf 4,538 1 3.48 1.03 3,925 1 1,493 1.09
APPS_TS_TX_IDX /oasb_data/tx_idx5.dbf 4,508 1 4.55 1.03 3,224 1 1,648 0.75
APPS_TS_TX_IDX /oasb_data/tx_idx6.dbf 4,337 1 4.53 1.04 3,244 1 1,914 0.68
APPS_TS_TX_IDX /oasb_data/tx_idx7.dbf 4,330 1 4.27 1.02 2,900 1 2,248 0.86
APPS_TS_TX_IDX /oasb_data/tx_idx8.dbf 4,084 1 4.17 1.03 3,402 1 2,303 0.70
APPS_TS_TX_IDX /oasb_data/tx_idx9.dbf 4,227 1 3.57 1.04 2,525 1 2,550 0.52
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte.dbf 753 0 3.67 2.23 3,073 1 8,148 0.47
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte2.dbf 325 0 4.74 1.85 2,351 1 7,220 0.28
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte3.dbf 251 0 5.06 2.15 2,234 1 7,269 0.23
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte4.dbf 241 0 3.78 2.07 2,225 1 6,328 0.34
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte5.dbf 222 0 4.95 2.18 2,254 1 4,917 0.40
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte6.dbf 282 0 7.27 1.97 2,299 1 4,380 0.54
APPS_UNDOTS1 /oasb_data/undo01.dbf 726 0 2.73 1.00 29,684 8 16,270 0.18
APPS_UNDOTS1 /oasb_data/undo02.dbf 813 0 2.34 1.00 30,669 8 20,394 0.20
APPS_UNDOTS1 /oasb_data/undo03.dbf 883 0 1.96 1.00 32,845 9 20,381 0.21
APPS_UNDOTS1 /oasb_data/undo04.dbf 871 0 2.27 1.00 33,107 9 14,030 0.22
APPS_UNDOTS1 /oasb_data/undo05.dbf 4,423 1 1.31 1.00 97,551 27 21,362 0.28
APPS_UNDOTS1 /oasb_data/undo06.dbf 4,097 1 1.54 1.00 96,840 26 23,810 0.29
APPS_UNDOTS1 /oasb_data/undo07.dbf 5,402 1 1.36 1.00 98,011 27 24,028 0.23
APPS_UNDOTS1 /oasb_data/undo08.dbf 3,010 1 1.54 1.00 90,368 25 23,825 0.26
APPS_UNDOTS1 /oasb_data/undo09.dbf 2,874 1 1.75 1.00 92,119 25 26,106 0.25
CTXSYS /oasb_data/ctx1.dbf 113 0 7.70 1.17 192 0 1 0.00
CTXSYS /oasb_data/ctx2.dbf 362 0 5.41 1.00 1,150 0 2 0.00
ODM /oasb_data/odm.dbf 5 0 6.00 1.00 2 0 0 0.00
OLAP /oasb_data/olap.dbf 5 0 10.00 1.00 2 0 0 0.00
OWAPUB /oasb_data/owa1.dbf 5 0 8.00 1.00 2 0 0 0.00
PORTAL /oasb_data/portal.dbf 5 0 10.00 1.00 2 0 0 0.00
SYNCSERVER /oasb_data/mobile01.dbf 5 0 48.00 1.00 2 0 0 0.00
SYSAUX /oasb_data/sysaux01.dbf 190 0 3.00 1.77 167 0 11 8.18
SYSAUX /oasb_data/sysaux02.dbf 212 0 3.11 1.99 160 0 0 0.00
SYSTEM /oasb_data/sys1.dbf 1,149 0 3.70 2.57 181 0 146 1.51
SYSTEM /oasb_data/sys2.dbf 1,405 0 4.23 2.27 205 0 250 1.68
SYSTEM /oasb_data/sys3.dbf 1,154 0 3.68 2.56 273 0 268 0.82
SYSTEM /oasb_data/sys4.dbf 1,403 0 3.98 2.30 407 0 544 1.47
SYSTEM /oasb_data/sys5.dbf 1,189 0 5.00 2.52 374 0 1,838 0.50
SYSTEM /oasb_data/sys6.dbf 1,123 0 4.11 2.63 257 0 2,252 0.48
SYSTEM /oasb_data/sys7.dbf 1,091 0 4.39 2.65 144 0 611 0.62
SYSTEM /oasb_data/sys8.dbf 23 0 4.35 1.00 25 0 2,007 0.70
SYSTEM /oasb_data/sys9.dbf 21 0 5.71 1.14 30 0 400 3.65
TEMP /oasb_data/tmp1.dbf 3,174 1 17.31 5.74 5,843 2 33 15.76
TEMP /oasb_data/tmp2.dbf 2,318 1 31.33 6.54 4,974 1 66 35.61
TEMP /oasb_data/tmp3.dbf 2,684 1 16.44 6.68 5,927 2 23 25.65
TEMP /oasb_data/tmp4.dbf 3,386 1 18.36 6.16 6,581 2 128 27.66

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,842,435,866 904,014 2,613,741 0 0 616,525


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,283 34,725 770,319 2,052,980 29,489,355 2,052,980  
E 0 5,167 39,560 846,491 26,252,042 29,489,355 26,252,042  

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.77 503,398 1,155

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 27,413.31 2.55 0.01 100.00 0.00 102,400
E 15,360 960 36,108.96 3.66 0.01 100.00 0.00 102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 5,347,618 5,347,618 0 0
64K 128K 11,675 11,675 0 0
128K 256K 1,231 1,231 0 0
256K 512K 1,179 1,179 0 0
512K 1024K 144,836 144,836 0 0
1M 2M 334,329 334,329 0 0
2M 4M 1,690 1,690 0 0
4M 8M 34 34 0 0
8M 16M 21 21 0 0
64M 128M 14 8 6 0
128M 256M 2 0 2 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
1,920 0.13 601,732.60 11,233.98 98.00 1,197
3,840 0.25 601,732.60 11,233.98 98.00 1,194
7,680 0.50 601,732.60 11,166.60 98.00 1,166
11,520 0.75 601,732.60 11,060.88 98.00 1,110
15,360 1.00 601,732.60 577.60 100.00 1,052
18,432 1.20 601,732.60 577.60 100.00 975
21,504 1.40 601,732.60 577.60 100.00 840
24,576 1.60 601,732.60 577.60 100.00 426
27,648 1.80 601,732.60 577.60 100.00 0
30,720 2.00 601,732.60 577.60 100.00 0
46,080 3.00 601,732.60 577.60 100.00 0
61,440 4.00 601,732.60 577.60 100.00 0
92,160 6.00 601,732.60 577.60 100.00 0
122,880 8.00 601,732.60 577.60 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 327 17,250 738,440 1.00 1,900 1.15 101,392,736
2,432 0.79 645 24,465 738,687 1.00 1,653 1.00 101,416,202
2,752 0.90 963 49,956 738,690 1.00 1,650 1.00 101,416,957
3,072 1.00 1,122 64,891 738,691 1.00 1,649 1.00 101,417,114
3,392 1.10 1,161 67,563 738,691 1.00 1,649 1.00 101,417,121
3,712 1.21 1,161 67,563 738,691 1.00 1,649 1.00 101,417,121
4,032 1.31 1,161 67,563 738,691 1.00 1,649 1.00 101,417,121
4,352 1.42 1,161 67,563 738,691 1.00 1,649 1.00 101,417,121
4,672 1.52 1,161 67,563 738,691 1.00 1,649 1.00 101,417,121
4,992 1.63 1,161 67,563 738,691 1.00 1,649 1.00 101,417,121
5,312 1.73 1,161 67,563 738,691 1.00 1,649 1.00 101,417,121
5,632 1.83 1,161 67,563 738,691 1.00 1,649 1.00 101,417,121
5,952 1.94 1,161 67,563 738,691 1.00 1,649 1.00 101,417,121
6,272 2.04 1,161 67,563 738,691 1.00 1,649 1.00 101,417,121

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 380 1,280 1.00 1,649 1.00 15,156
32 0.50 24 532 1,280 1.00 1,649 1.00 15,156
48 0.75 24 532 1,280 1.00 1,649 1.00 15,156
64 1.00 24 532 1,280 1.00 1,649 1.00 15,156
80 1.25 24 532 1,280 1.00 1,649 1.00 15,156
96 1.50 24 532 1,280 1.00 1,649 1.00 15,156
112 1.75 24 532 1,280 1.00 1,649 1.00 15,156
128 2.00 24 532 1,280 1.00 1,649 1.00 15,156

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 414,157 211 1
undo block 161,756 38 0
undo header 28,463 8 0
file header block 250 7 28
1st level bmb 9,095 3 0
segment header 1,387 2 2
2nd level bmb 1,133 1 1
extent map 17 0 0
bitmap index block 9 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,477 62,995 1,482 3,972 573 144.34
TX-Transaction (row lock contention) 6,938 503 6,435 498 357 717.60
TX-Transaction (index contention) 16,722 16,722 0 13,747 57 4.16
CI-Cross-Instance Call Invocation 36,198 36,198 0 6,321 18 2.92
RO-Multiple Object Reuse (fast object reuse) 245 245 0 35 8 225.06
HW-Segment High Water Mark 232,840 232,836 3 2,542 5 1.78
TX-Transaction 1,124,329 1,124,533 0 2,399 4 1.75
TM-DML 5,302,105 5,302,311 0 2 4 1,810.50
SQ-Sequence Cache 37,640 37,640 0 3,490 3 0.89
DV-Diana Versioning 20,434 20,434 0 69 1 12.16
CU-Cursor 9,337 9,337 0 27 0 18.04
FB-Format Block 34,357 34,358 0 940 0 0.48
TX-Transaction (allocate ITL entry) 249 249 0 166 0 0.51
PS-PX Process Reservation 856 591 264 12 0 0.17

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,537,307 1,105,533 2,526 286 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
18-May 21:48 391,967 161,816 664 269 0 0 0/0/0/0/0/0
18-May 21:38 413,416 191,174 511 268 0 0 0/0/0/0/0/0
18-May 21:28 157,368 156,754 2,526 273 0 0 0/0/0/0/0/0
18-May 21:18 171,356 165,431 1,922 271 0 0 0/0/0/0/0/0
18-May 21:08 164,743 243,271 1,667 266 0 0 0/0/0/0/0/0
18-May 20:58 238,457 187,087 1,063 286 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 672,908 0.05 0.01 0 0  
FOB s.o list latch 77,894 0.02 0.00 0 0  
In memory undo latch 730,077,617 2.80 0.00 59 2,720,696 0.00
JOX SGA heap latch 526,220 0.00   0 0  
JS mem alloc latch 2 0.00   0 2 0.00
JS queue access latch 2 0.00   0 0  
JS queue state obj latch 22,080 0.00   0 0  
JS slv state obj latch 3 0.00   0 0  
KMG MMAN ready and startup request latch 1,226 0.00   0 0  
KTF sga enqueue 12 0.00   0 1,239 0.00
KWQMN job cache list latch 1,766,055 0.10 1.33 29 0  
MQL Tracking Latch 0     0 73 0.00
Memory Management Latch 18,390 0.00   0 1,226 0.00
PL/SQL warning settings 2,589,713 0.00   0 0  
SQL memory manager latch 1 0.00   0 1,223 0.00
SQL memory manager workarea list latch 3,054,550 0.00 0.00 0 0  
SWRF Alerted Metric Element list 238,984 0.00   0 0  
Shared B-Tree 2 0.00   0 0  
active checkpoint queue latch 254,412 0.00   0 0  
active service list 20,016 0.00   0 0  
begin backup scn array 943 0.00   0 0  
cache buffer handles 22,154,658 0.53 0.00 0 0  
cache buffers chains 4,474,185,516 0.71 0.00 1,120 16,698,700 1.71
cache buffers lru chain 8,713,225 0.31 0.01 1 32,146,865 0.46
channel handle pool latch 295,822 0.03 0.00 0 0  
channel operations parent latch 1,137,258 0.67 0.00 0 0  
checkpoint queue latch 9,349,099 0.01 0.00 0 2,580,210 0.01
child cursor hash table 79,105 0.01 0.00 0 0  
client/application info 1,152,033 0.01 0.00 0 0  
commit callback allocation 107,371 0.00   0 0  
compile environment latch 2,378,286 0.00   0 0  
cursor bind value capture 1,900 0.63 0.00 0 16,046 0.02
dictionary lookup 82 0.00   0 0  
dml lock allocation 10,592,341 0.20 0.00 0 0  
dummy allocation 14,575 0.19 0.00 0 0  
enqueue hash chains 16,547,830 0.04 0.00 0 23 0.00
enqueues 3,599,690 0.15 0.00 0 0  
error message lists 324 2.47 0.00 0 0  
event group latch 3,881 0.00   0 0  
file cache latch 36,108 0.01 0.00 0 0  
global KZLD latch for mem in SGA 7,138 0.00   0 0  
global ctx hash table latch 33,414 0.00   0 0  
hash table column usage latch 1,404 0.43 0.00 0 12,309,191 0.00
hash table modification latch 140 0.00   0 0  
internal temp table object number allocation latc 3 0.00   0 0  
job workq parent latch 0     0 2 0.00
job_queue_processes parameter latch 62 0.00   0 0  
ksfv messages 0     0 2 0.00
ksuosstats global area 247 0.00   0 0  
ktm global data 54,099 0.00   0 0  
kwqbsn:qxl 0     0 2 0.00
lgwr LWN SCN 675,036 0.09 0.00 0 0  
library cache 404,989,930 0.86 0.00 25 1,297 221.59
library cache load lock 5,326 0.92 0.00 0 22 0.00
library cache lock 54,559,404 0.05 0.00 0 0  
library cache lock allocation 1,271,910 0.00 0.00 0 0  
library cache pin 342,087,724 0.23 0.00 2 80 0.00
library cache pin allocation 1,402,524 0.00 0.00 0 0  
list of block allocation 411,482 0.01 0.00 0 0  
loader state object freelist 232,456 0.01 0.00 0 0  
longop free list parent 44 0.00   0 44 0.00
message pool operations parent latch 299,944 0.01 0.10 0 0  
messages 2,772,876 0.07 0.00 0 0  
mostly latch-free SCN 706,865 3.11 0.00 0 0  
multiblock read objects 44,440 0.01 0.00 0 2 0.00
ncodef allocation latch 70 0.00   0 0  
object queue header heap 483,000 0.00   0 492,823 0.00
object queue header operation 62,483,862 0.03 0.00 0 0  
object stats modification 55,025 0.04 0.00 0 0  
parallel query alloc buffer 3,368 1.22 0.00 0 0  
parallel query stats 234 10.26 0.00 0 0  
parameter list 20,160 0.01 0.00 0 0  
parameter table allocation management 14,575 0.25 0.08 0 0  
post/wait queue 671,407 0.01 0.00 0 361,044 0.02
process allocation 7,773 0.04 0.00 0 3,879 0.05
process group creation 7,737 0.00   0 0  
process queue 1,993 1.40 0.00 0 0  
process queue reference 370,742 0.03 0.00 0 29,044 23.02
query server freelists 1,676 7.88 0.00 0 0  
query server process 16 0.00   0 16 0.00
redo allocation 8,035,346 1.07 0.01 3 96,907,689 1.46
redo copy 0     0 97,057,745 0.07
redo writing 2,333,308 0.01 0.06 0 0  
row cache objects 66,632,984 0.29 0.00 1 14 0.00
rules engine statistics 32,416 0.01 0.00 0 0  
sequence cache 15,747,551 0.78 0.00 0 0  
session allocation 12,215,317 0.46 0.00 0 0  
session idle bit 69,662,840 0.03 0.01 2 0  
session switching 10,462 0.01 0.00 0 0  
session timer 1,257 0.00   0 0  
shared pool 21,992,430 0.11 0.00 0 0  
slave class 0     0 2 0.00
sort extent pool 961,463 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 597 0.00   0 0  
temporary table state object allocation 9,794 0.02 0.00 0 0  
threshold alerts latch 317 0.00   0 0  
trace latch 49 0.00   0 0  
transaction allocation 88,808 0.00 0.00 0 0  
transaction branch allocation 70 0.00   0 0  
undo global data 883,411,063 2.99 0.00 51 92 0.00
user lock 28,496 0.04 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,474,185,516 31,820,458 102,678 31,731,548 100,719 549 216
undo global data 883,411,063 26,389,114 5,963 26,383,184 5,897 33 0
In memory undo latch 730,077,617 20,427,119 5,991 20,421,161 5,925 33 0
library cache 404,989,930 3,492,442 7,615 3,484,843 7,583 16 0
library cache pin 342,087,724 786,033 1,264 784,774 1,254 5 0
row cache objects 66,632,984 192,884 102 192,782 102 0 0
sequence cache 15,747,551 123,090 47 123,043 47 0 0
cache buffer handles 22,154,658 117,217 80 117,137 80 0 0
redo allocation 8,035,346 85,681 616 85,074 598 9 0
session allocation 12,215,317 56,439 104 56,335 104 0 0
library cache lock 54,559,404 28,207 44 28,163 44 0 0
cache buffers lru chain 8,713,225 27,171 148 27,024 146 1 0
shared pool 21,992,430 24,745 50 24,695 50 0 0
session idle bit 69,662,840 22,134 171 21,964 169 1 0
mostly latch-free SCN 706,865 21,957 7 21,950 7 0 0
dml lock allocation 10,592,341 20,727 25 20,702 25 0 0
object queue header operation 62,483,862 19,984 44 19,940 44 0 0
channel operations parent latch 1,137,258 7,598 15 7,584 13 1 0
enqueue hash chains 16,547,830 6,693 15 6,679 13 1 0
enqueues 3,599,690 5,419 10 5,409 10 0 0
KWQMN job cache list latch 1,766,055 1,774 2,357 198 1,081 306 189
sort extent pool 961,463 695 2 693 2 0 0
checkpoint queue latch 9,349,099 636 2 634 2 0 0
Consistent RBA 672,908 331 3 328 3 0 0
redo writing 2,333,308 233 13 220 13 0 0
parameter table allocation management 14,575 37 3 34 3 0 0
message pool operations parent latch 299,944 29 3 26 3 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 5,666 5,839
In memory undo latch ktiTxnPoolFree 0 88 0
In memory undo latch ktiFlush: child 0 84 128
In memory undo latch ktichg: child 0 73 16
In memory undo latch kticmt: child 0 68 6
In memory undo latch ktiBRacquire 0 7 0
In memory undo latch ktbgfc 0 5 2
KWQMN job cache list latch kwqmnuji: update job item 0 2,351 2,251
KWQMN job cache list latch kwqmndej: dequeue 0 6 106
cache buffer handles kcbzgs 0 49 49
cache buffer handles kcbzfs 0 31 31
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 44,325 48,168
cache buffers chains kcbgtcr: fast path 0 17,068 9,242
cache buffers chains kcbchg: kslbegin: call CR func 0 10,850 21,707
cache buffers chains kcbgtcr: kslbegin excl 0 10,098 7,877
cache buffers chains kcbzgb: scan from tail. nowait 0 9,522 0
cache buffers chains kcbrls: kslbegin 0 2,897 7,712
cache buffers chains kcbgcur: kslbegin 0 2,382 3,156
cache buffers chains kcbgkcbcr 0 1,457 1,459
cache buffers chains kcbget: pin buffer 0 1,248 1,501
cache buffers chains kcbget: exchange rls 0 834 148
cache buffers chains kcbzwb 0 576 368
cache buffers chains kcbget: exchange 0 507 307
cache buffers chains kcbgtcr: kslbegin shared 0 203 131
cache buffers chains kcbnew: new latch again 0 171 33
cache buffers chains kcbcge 0 108 213
cache buffers chains kcbnlc 0 32 89
cache buffers chains kcbbxsv 0 18 30
cache buffers chains kcbso1: set no access 0 11 16
cache buffers chains kcbo_ivd_process 0 10 5
cache buffers chains kcb_is_private 0 9 184
cache buffers chains kcbbic2 0 7 4
cache buffers chains kcbesc: escalate 0 5 3
cache buffers chains kcb_pre_apply: kcbhq61 0 3 89
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 3 0
cache buffers chains kcbzib: finish free bufs 0 2 7
cache buffers chains kcbgtcr 0 2 0
cache buffers chains kcbbic1 0 1 15
cache buffers chains kcbzib: multi-block read: nowait 0 1 0
cache buffers chains kcbnew_1 0 1 5
cache buffers lru chain kcbzgws 0 94 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 30 0
cache buffers lru chain kcbzswcu 0 12 0
cache buffers lru chain kcbo_ivd_proc 0 4 16
cache buffers lru chain kcbbxsv: move to being written 0 2 16
cache buffers lru chain kcbzrn 0 2 1
cache buffers lru chain kcbzgb: posted for free bufs 0 1 72
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 1 3
cache buffers lru chain kcbibr 0 1 2
cache buffers lru chain kcbbic2 0 1 35
channel operations parent latch ksrchdelete() 0 5 0
channel operations parent latch ksrsconsume() 0 3 0
channel operations parent latch ksrchconnect() 0 2 7
channel operations parent latch ksrapublish() 0 2 0
channel operations parent latch ksrmfree() 0 2 0
channel operations parent latch ksrwait() 0 1 8
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 2 0
dml lock allocation ktaidm 0 14 4
dml lock allocation ktaiam 0 11 21
enqueue hash chains ksqrcl 0 8 4
enqueue hash chains ksqgtl3 0 6 10
enqueue hash chains ksqcmi: if deadlock detected 0 1 0
enqueues ksqgel: create enqueue 0 7 8
enqueues ksqdel 0 3 2
library cache kglpndl: child: before processing 0 1,601 1,057
library cache kglpnp: child 0 1,364 2,275
library cache kglpnc: child 0 1,343 2,248
library cache kglupc: child 0 1,286 753
library cache kglpndl: child: after processing 0 694 0
library cache kglobpn: child: 0 180 557
library cache kglpin: child: heap processing 0 146 213
library cache kgldte: child 0 0 86 95
library cache kglhdgn: child: 0 50 215
library cache kglpin 0 48 16
library cache kglhdgc: child: 0 25 12
library cache kglhdiv: child 0 20 0
library cache kglget: set reserved lock 0 16 53
library cache kglupd: child 0 9 0
library cache kglidp: child 0 6 1
library cache kglic 0 3 0
library cache kglhdgh: child: 0 1 0
library cache kglget: unpin heap 0 0 1 1
library cache lock kgllkdl: child: no lock handle 0 731 119
library cache lock kgllkdl: child: cleanup 0 29 27
library cache lock kgllkal: child: multiinstance 0 15 19
library cache pin kglpndl 0 338 117
library cache pin kglupc 0 309 161
library cache pin kglpnc: child 0 291 385
library cache pin kglpnp: child 0 234 396
library cache pin kglpnal: child: alloc space 0 92 205
message pool operations parent latch ksrmfree() 0 2 0
message pool operations parent latch ksrmalloc() 0 1 3
mostly latch-free SCN kcslcu3 0 7 7
mostly latch-free SCN kcs01 0 2 3
mostly latch-free SCN kcsnew_scn_rba 0 1 0
object queue header operation kcbo_ivbo 0 42 2
object queue header operation kcbw_link_q 0 2 0
parameter table allocation management ksp_param_table_alloc 0 3 3
redo allocation kcrfw_redo_gen: redo allocation 1 0 435 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 124 353
redo allocation kcrfw_redo_write: before write 0 25 102
redo allocation kcrfw_redo_gen: redo allocation 2 0 16 0
redo allocation kcrfw_redo_write: more space 0 16 163
redo writing kcrfw_post: rba scn pair 0 12 0
redo writing kcrfw_cal_target_rba 0 1 0
row cache objects kqreqd: reget 0 87 0
row cache objects kqrpre: find obj 0 12 103
row cache objects kqreqd 0 2 1
row cache objects kqrso 0 1 0
sequence cache kdnssd 0 46 0
sequence cache kdnnxt: cached seq 0 1 0
session allocation ksuprc 0 28 12
session allocation ksuxds: not user session 0 26 27
session allocation ksucri 0 25 60
session allocation ksudlc 0 18 3
session allocation ksudlp 0 3 0
session allocation ksuxds: KSUSFCLC not set 0 3 0
session allocation ksucrp 0 1 2
session idle bit ksupuc: set busy 0 96 84
session idle bit ksupuc: clear busy 0 66 76
session idle bit ksuxds 0 9 11
shared pool kghalo 0 19 19
shared pool kghupr1 0 18 27
shared pool kghfre 0 9 4
shared pool kghfrunp: alloc: wait 0 3 0
shared pool kghfrunp: clatch: wait 0 3 0
shared pool kghfrunp: clatch: nowait 0 2 0
shared pool kghalp 0 1 0
sort extent pool ktstdt: dealloc sort extent 0 1 0
sort extent pool ktstdt: return extent 0 1 0
undo global data kturimugur: child 0 5,177 2,376
undo global data ktudba: KSLBEGIN 0 758 3,517
undo global data ktudnx:child 0 15 16
undo global data ktusmasp: ktugd_tuux 0 7 7
undo global data ktufrbs: child 0 6 8

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 62,103,376 8.05
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 36,644,896 4.75
GL APPS_TS_TX_IDX GL_CODE_COMBINATIONS_U1   INDEX 35,421,552 4.59
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 24,677,328 3.20
INV APPS_TS_TX_INTERFACE MTL_TRANSACTIONS_INTERFACE   TABLE 19,134,800 2.48

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 55,404 22.25
AR APPS_ASSM_DATA RA_CUST_TRX_LINE_GL_DIST_ALL   TABLE 19,454 7.81
HR APPS_TS_TX_IDX PAY_BALANCE_CONTEXT_VALUES_PK   INDEX 15,742 6.32
GL APPS_ASSM_DATA GL_INTERFACE   TABLE 13,033 5.23
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 12,468 5.01

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
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 47,331 14.09
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 46,164 13.74
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 44,735 13.32
AR APPS_ASSM_DATA RA_CUST_TRX_LINE_GL_DIST_ALL   TABLE 36,632 10.91
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 27,669 8.24

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
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 13,168 31.62
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 11,462 27.52
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 2,171 5.21
HR APPS_TS_TX_IDX PAY_RUN_BALANCES_N3   INDEX 1,888 4.53
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,639 3.94

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits %Total
SYS SYSTEM COL$   TABLE 143 81.71
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 6 3.43
INV APPS_ASSM_IDX MTL_MATERIAL_TRANSACTIONS_N23   INDEX 4 2.29
GL APPS_ASSM_IDX GL_INTERFACE_N1   INDEX 3 1.71
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_PK   INDEX 2 1.14

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 4 0.00 0   2 1
dc_constraints 696 47.27 0   696 181
dc_free_extents 25 36.00 11 0.00 17 109
dc_global_oids 3,460,626 0.00 0   0 83
dc_histogram_data 4,765 3.23 0   16 957
dc_histogram_defs 315,823 2.33 0   4,277 28,993
dc_object_ids 7,424,906 0.01 0   61 6,258
dc_objects 173,547 0.57 0   378 9,441
dc_profiles 7,138 0.00 0   0 1
dc_rollback_segments 56,361 0.00 0   0 1,008
dc_segments 1,151,612 0.06 0   17,366 8,325
dc_sequences 46,388 0.04 0   46,388 164
dc_table_scns 67,324 0.01 0   0 14
dc_tablespace_quotas 17,260 0.11 0   17,260 57
dc_tablespaces 3,176,583 0.00 0   0 21
dc_used_extents 7 100.00 0   7 12
dc_usernames 268,683 0.00 0   0 87
dc_users 6,404,379 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 509,475 0.02 27,479,420 -0.00 0 0
CLUSTER 65 0.00 121 0.00 0 0
INDEX 11,204 0.69 11,747 1.08 0 0
JAVA DATA 284 0.00 0   0 0
PIPE 35,187 2.63 47,897 1.93 0 0
SQL AREA 3,513,520 0.16 95,142,395 0.01 3,176 304
TABLE/PROCEDURE 363,896 0.21 40,363,423 0.01 9 0
TRIGGER 22,130 0.07 1,243,197 0.00 0 0


Back to Top

 

SGA Statistics

Back to Top

SGA Memory Summary

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

Back to SGA Statistics
Back to Top

SGA breakdown difference

Pool Name Begin value End value % Diff
java free memory 51,464,704 51,464,704 0.00
java joxlod exec hp 14,966,784 14,966,784 0.00
java joxs heap 677,376 677,376 0.00
shared ASH buffers 33,554,432 33,554,432 0.00
shared FileOpenBlock 12,563,648 12,563,648 0.00
shared KGLF Frame Hea 15,112 15,112 0.00
shared KGLS heap 41,427,104 46,242,176 11.62
shared KQR L PO 14,510,776 16,097,432 10.93
shared KQR L SO 104,448 106,496 1.96
shared KQR M PO 17,109,928 20,073,448 17.32
shared KQR M SO 361,096 436,872 20.99
shared KQR S SO 11,080 11,592 4.62
shared KTI-UNDO 59,745,840 59,745,840 0.00
shared PL/SQL DIANA 29,708,328 34,699,416 16.80
shared PL/SQL MPCODE 74,271,320 80,415,712 8.27
shared PLS non-lib hp 14,760 14,760 0.00
shared QSMQUTL summar 1,312 35,384 2,596.95
shared SGA struct - SWRF Metrics 3,536,000 3,536,000 0.00
shared db_block_hash_buckets 33,554,432 33,554,432 0.00
shared enqueue resources 4,418,528 4,418,528 0.00
shared evaluation con 17,760 17,760 0.00
shared event statistics per sess 181,888,000 181,888,000 0.00
shared fixed allocation callback 1,424 1,424 0.00
shared free memory 1,086,056,656 258,169,288 -76.23
shared joxlod exec hp 968,760 968,760 0.00
shared joxlod pcod hp 174,952 174,952 0.00
shared joxlod rsrc hp 7,392 7,392 0.00
shared joxs heap 4,240 4,240 0.00
shared ktlbk state objects 4,127,200 4,127,200 0.00
shared library cache 872,563,464 1,224,976,200 40.39
shared miscellaneous 254,460,880 288,061,608 13.20
shared parameters 1,134,008 1,287,736 13.56
shared partitioning d 480,152 533,960 11.21
shared pl/sql source 16,992 16,992 0.00
shared private strands 101,713,920 101,713,920 0.00
shared procs: ksunfy 4,400,000 4,400,000 0.00
shared replication session stats 1,904,000 1,904,000 0.00
shared repository 3,002,928 3,146,688 4.79
shared row cache 8,472,848 8,472,848 0.00
shared rule set evalu 71,248 71,248 0.00
shared session parame 36,052,400 36,747,200 1.93
shared sessions 34,944,008 34,944,008 0.00
shared sql area 276,149,504 698,998,064 153.12
shared synonym source 32,208 54,328 68.68
shared table definiti 67,992 83,400 22.66
shared temporary tabl 9,689,856 11,532,424 19.02
shared transaction 12,365,800 12,365,800 0.00
shared trigger defini 135,968 149,840 10.20
shared trigger inform 2,088 2,088 0.00
shared trigger source 1,736 9,440 443.78
shared type object de 810,696 815,840 0.63
  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