WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
VIS 189753083 VIS 1 10.2.0.3.0 NO oracle16.engr.sgi.com

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 1 14-Oct-07 17:13:19 5521 202.2
End Snap: 2 14-Oct-07 18:14:17 5523 245.2
Elapsed:   60.96 (mins)    
DB Time:   1,148.40 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 8,000M 8,000M Std Block Size: 8K
Shared Pool Size: 3,008M 3,008M Log Buffer: 30,736K

Load Profile

  Per Second Per Transaction
Redo size: 8,771,198.34 25,345.28
Logical reads: 632,303.36 1,827.11
Block changes: 55,279.85 159.74
Physical reads: 400.26 1.16
Physical writes: 841.77 2.43
User calls: 12,531.64 36.21
Parses: 2,774.27 8.02
Hard parses: 2.69 0.01
Sorts: 3,077.10 8.89
Logons: 3.37 0.01
Executes: 29,268.95 84.58
Transactions: 346.07  

% Blocks changed per Read: 8.74 Recursive Call %: 79.20
Rollback per transaction %: 21.56 Rows per Sort: 10.63

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96 Redo NoWait %: 100.00
Buffer Hit %: 99.95 In-memory Sort %: 100.00
Library Hit %: 100.06 Soft Parse %: 99.90
Execute to Parse %: 90.52 Latch Hit %: 98.14
Parse CPU to Parse Elapsd %: 84.27 % Non-Parse CPU: 98.12

Shared Pool Statistics

  Begin End
Memory Usage %: 79.25 98.05
% SQL with executions>1: 73.79 82.95
% Memory for SQL w/exec>1: 64.08 57.01

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   61,227   88.9  
db file sequential read 913,724 2,736 3 4.0 User I/O
log file sync 514,377 1,188 2 1.7 Commit
log file parallel write 897,603 316 0 .5 System I/O
latch: cache buffers chains 373,107 235 1 .3 Concurrency

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
sql execute elapsed time 61,635.03 89.45
DB CPU 61,226.62 88.86
inbound PL/SQL rpc elapsed time 12,210.39 17.72
PL/SQL execution elapsed time 9,695.60 14.07
Java execution elapsed time 3,013.42 4.37
parse time elapsed 1,451.19 2.11
hard parse elapsed time 674.92 0.98
repeated bind elapsed time 160.55 0.23
connection management call elapsed time 40.82 0.06
sequence load elapsed time 39.94 0.06
PL/SQL compilation elapsed time 9.89 0.01
hard parse (sharing criteria) elapsed time 8.81 0.01
failed parse elapsed time 4.15 0.01
hard parse (bind mismatch) elapsed time 1.39 0.00
DB time 68,904.11  
background elapsed time 1,176.47  
background cpu time 729.76  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
User I/O 1,113,123 0.00 2,941 3 0.88
Commit 514,377 0.00 1,188 2 0.41
Concurrency 1,389,922 0.77 888 1 1.10
System I/O 1,193,641 0.00 430 0 0.94
Application 85,998 0.08 312 4 0.07
Network 52,985,827 0.00 301 0 41.86
Other 224,536 16.89 277 1 0.18
Configuration 85,981 0.00 214 2 0.07

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
db file sequential read 913,724 0.00 2,736 3 0.72
log file sync 514,377 0.00 1,188 2 0.41
log file parallel write 897,603 0.00 316 0 0.71
latch: cache buffers chains 373,107 0.00 235 1 0.29
latch: In memory undo latch 60,285 0.00 204 3 0.05
enq: HW - contention 66,188 0.00 204 3 0.05
latch: undo global data 41,676 0.00 189 5 0.03
read by other session 176,465 0.00 175 1 0.14
enq: UL - contention 3,025 1.39 167 55 0.00
SQL*Net more data from client 2,666,614 0.00 140 0 2.11
cursor: pin S wait on X 11,316 95.03 116 10 0.01
db file parallel write 292,640 0.00 112 0 0.23
buffer busy waits 854,086 0.00 97 0 0.67
SQL*Net more data to client 2,105,298 0.00 93 0 1.66
enq: TX - row lock contention 1,255 2.07 90 72 0.00
latch: library cache 31,260 0.00 82 3 0.02
SQL*Net message to client 48,213,915 0.00 69 0 38.09
latch: library cache pin 15,009 0.00 50 3 0.01
enq: TX - index contention 30,128 0.00 44 1 0.02
SQL*Net break/reset to client 81,656 0.00 35 0 0.06
db file scattered read 10,619 0.00 25 2 0.01
library cache load lock 776 0.00 20 26 0.00
latch: row cache objects 9,725 0.00 18 2 0.01
latch: redo allocation 11,234 0.00 16 1 0.01
enq: KO - fast object checkpoint 26 3.85 15 570 0.00
latch free 2,896 0.00 12 4 0.00
library cache lock 332 0.00 10 32 0.00
LGWR wait for redo copy 38,718 0.49 10 0 0.03
latch: session allocation 8,055 0.00 10 1 0.01
latch: cache buffers lru chain 5,070 0.00 7 1 0.00
kksfbc child completion 156 78.21 6 39 0.00
enq: SQ - contention 18,702 0.00 6 0 0.01
enq: TX - contention 9,281 0.00 6 1 0.01
enq: RO - fast object reuse 32 0.00 6 177 0.00
cursor: pin S 55,857 0.00 5 0 0.04
local write wait 3,998 0.00 5 1 0.00
library cache pin 739 0.00 5 6 0.00
buffer deadlock 38,193 98.27 3 0 0.03
enq: FB - contention 5,158 0.00 3 1 0.00
enq: TX - allocate ITL entry 943 0.00 3 3 0.00
latch: library cache lock 1,052 0.00 3 2 0.00
enq: DV - contention 167 0.00 2 15 0.00
latch: cache buffer handles 3,317 0.00 2 1 0.00
wait list latch free 523 0.00 2 3 0.00
latch: object queue header operation 2,608 0.00 2 1 0.00
control file parallel write 1,773 0.00 1 1 0.00
latch: shared pool 935 0.00 1 2 0.00
os thread startup 10 0.00 1 107 0.00
log file switch completion 77 0.00 1 13 0.00
row cache lock 913 0.00 1 1 0.00
PX Deq Credit: send blkd 863 0.00 1 1 0.00
latch: enqueue hash chains 166 0.00 1 3 0.00
PX Deq: Signal ACK 51 29.41 1 10 0.00
control file sequential read 1,617 0.00 0 0 0.00
latch: redo writing 66 0.00 0 3 0.00
enq: US - contention 67 0.00 0 2 0.00
L1 validation 12 66.67 0 7 0.00
latch: checkpoint queue latch 59 0.00 0 1 0.00
enq: TQ - TM contention 121 0.00 0 1 0.00
direct path read 7,917 0.00 0 0 0.01
enq: TM - contention 4 0.00 0 16 0.00
enq: TQ - DDL contention 72 0.00 0 1 0.00
reliable message 56 0.00 0 1 0.00
cursor: mutex S 168 0.00 0 0 0.00
PX qref latch 83 72.29 0 1 0.00
db file parallel read 2 0.00 0 15 0.00
latch: messages 44 0.00 0 1 0.00
cursor: mutex X 81 0.00 0 0 0.00
latch: object queue header heap 18 0.00 0 1 0.00
enq: PS - contention 12 0.00 0 1 0.00
write complete waits 5 0.00 0 2 0.00
log file sequential read 4 0.00 0 1 0.00
direct path write 349 0.00 0 0 0.00
log file single write 4 0.00 0 0 0.00
latch: parallel query alloc buffer 3 0.00 0 0 0.00
direct path write temp 37 0.00 0 0 0.00
direct path read temp 12 0.00 0 0 0.00
SQL*Net message from client 48,213,849 0.00 11,379,224 236 38.09
pipe get 43,343 47.36 60,436 1394 0.03
Streams AQ: waiting for messages in the queue 7,278 100.00 35,555 4885 0.01
PL/SQL lock timer 322 99.69 3,595 11164 0.00
jobq slave wait 1,218 94.99 3,564 2926 0.00
Streams AQ: qmn slave idle wait 130 0.00 3,555 27349 0.00
Streams AQ: qmn coordinator idle wait 260 50.00 3,555 13674 0.00
Streams AQ: waiting for time management or cleanup tasks 271 5.54 3,529 13023 0.00
PX Idle Wait 1,274 94.19 2,390 1876 0.00
PX Deq: Execution Msg 1,111 0.72 37 33 0.00
PX Deq: Execute Reply 3,575 0.00 8 2 0.00
PX Deq: Parse Reply 60 0.00 3 58 0.00
PX Deq: Msg Fragment 995 0.00 0 0 0.00
PX Deq Credit: need buffer 1,182 0.00 0 0 0.00
PX Deq: Table Q Normal 476 0.00 0 0 0.00
PX Deq: Join ACK 61 0.00 0 1 0.00
class slave wait 1 0.00 0 2 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 897,553 0.00 316 0 0.71
db file parallel write 292,640 0.00 112 0 0.23
events in waitclass Other 44,625 0.42 15 0 0.04
db file scattered read 959 0.00 5 5 0.00
db file sequential read 662 0.00 2 3 0.00
control file parallel write 1,773 0.00 1 1 0.00
os thread startup 2 0.00 0 155 0.00
control file sequential read 854 0.00 0 0 0.00
latch: redo writing 59 0.00 0 3 0.00
direct path read 720 0.00 0 0 0.00
latch: cache buffers chains 3 0.00 0 8 0.00
latch: library cache 3 0.00 0 2 0.00
log file sequential read 4 0.00 0 1 0.00
log file sync 2 0.00 0 1 0.00
direct path write 220 0.00 0 0 0.00
latch: shared pool 3 0.00 0 0 0.00
log file single write 4 0.00 0 0 0.00
latch: In memory undo latch 2 0.00 0 0 0.00
buffer busy waits 4 0.00 0 0 0.00
rdbms ipc message 888,768 1.18 30,917 35 0.70
Streams AQ: qmn slave idle wait 130 0.00 3,555 27349 0.00
Streams AQ: qmn coordinator idle wait 260 50.00 3,555 13674 0.00
pmon timer 2,336 95.80 3,530 1511 0.00
smon timer 166,366 0.00 3,530 21 0.13
Streams AQ: waiting for time management or cleanup tasks 271 5.54 3,529 13023 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 69,331,850
IDLE_TIME 50,499,022
IOWAIT_TIME 1,696,903
NICE_TIME 0
SYS_TIME 4,658,568
USER_TIME 61,354,019
LOAD 16
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 296,736
NUM_CPUS 32
NUM_CPU_SOCKETS 16

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
VIS 68,782.50 61,130.10 1,359,648 2,306,902,017
SYS$USERS 160.70 138.90 81,626 6,687,579
SYS$BACKGROUND 0.00 0.00 21,054 373,822

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 1088199 291421 1389523 88736 0 0 52966472 30091
SYS$USERS 22350 1938 389 4 0 0 89 0
SYS$BACKGROUND 2582 745 17 34 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
7,468 7,243 285,451 0.03 10.84 60t2tt1564j0k   SELECT SUBSTRB(MACHINE, 1, 60)...
4,445 4,169 7,308 0.61 6.45 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
4,101 3,868 112,799 0.04 5.95 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,558 2,461 75,104 0.03 3.71 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA...
2,513 2,272 289 8.69 3.65 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,941 1,915 14 138.66 2.82 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,856 1,803 10 185.64 2.69 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,726 1,460 16 107.88 2.51 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
1,683 1,458 157,307 0.01 2.44 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
1,655 1,374 49,999 0.03 2.40 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
1,292 1,255 39,339 0.03 1.87 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
1,138 1,028 16 71.13 1.65 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
1,126 1,032 205,828 0.01 1.63 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
1,073 1,069 8 134.16 1.56 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
982 940 1,224 0.80 1.42 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
928 845 16 58.01 1.35 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
862 809 258,868 0.00 1.25 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
813 788 21,227 0.04 1.18 8h16w67202y4g   begin fnd_global.initialize(:s...
795 750 64,146 0.01 1.15 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
745 61 2,427 0.31 1.08 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
742 252 2,427 0.31 1.08 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
730 599 96 7.61 1.06 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
697 679 363,954 0.00 1.01 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...

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
7,243 7,468 285,451 0.03 10.84 60t2tt1564j0k   SELECT SUBSTRB(MACHINE, 1, 60)...
4,169 4,445 7,308 0.57 6.45 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
3,868 4,101 112,799 0.03 5.95 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,461 2,558 75,104 0.03 3.71 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA...
2,272 2,513 289 7.86 3.65 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,915 1,941 14 136.78 2.82 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,803 1,856 10 180.32 2.69 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,460 1,726 16 91.28 2.51 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
1,458 1,683 157,307 0.01 2.44 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
1,374 1,655 49,999 0.03 2.40 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
1,255 1,292 39,339 0.03 1.87 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
1,069 1,073 8 133.57 1.56 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
1,032 1,126 205,828 0.01 1.63 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
1,028 1,138 16 64.23 1.65 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
940 982 1,224 0.77 1.42 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
845 928 16 52.81 1.35 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
809 862 258,868 0.00 1.25 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
788 813 21,227 0.04 1.18 8h16w67202y4g   begin fnd_global.initialize(:s...
750 795 64,146 0.01 1.15 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
679 697 363,954 0.00 1.01 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
599 730 96 6.24 1.06 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
252 742 2,427 0.10 1.08 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
61 745 2,427 0.03 1.08 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
125,576,284 14 8,969,734.57 5.43 1914.98 1941.28 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
116,783,535 16 7,298,970.94 5.05 1460.42 1726.15 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
113,712,884 49,999 2,274.30 4.92 1373.84 1655.16 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
106,134,860 157,307 674.70 4.59 1458.01 1683.02 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
104,205,151 8 13,025,643.88 4.51 1068.55 1073.32 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
94,278,241 205,828 458.04 4.08 1032.31 1125.91 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
93,493,150 16 5,843,321.88 4.04 1027.71 1138.09 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
92,916,462 258,868 358.93 4.02 809.50 862.25 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
76,069,608 10 7,606,960.80 3.29 1803.19 1856.38 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
54,726,072 10 5,472,607.20 2.37 642.39 653.90 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
53,839,267 16 3,364,954.19 2.33 844.95 928.24 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
48,331,076 289 167,235.56 2.09 2271.58 2512.63 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
47,464,972 1,224 38,778.57 2.05 939.59 981.76 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
40,772,482 96 424,713.35 1.76 598.85 730.43 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
39,062,787 174,381 224.01 1.69 613.05 625.85 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
39,037,834 174,377 223.87 1.69 594.95 606.80 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
37,754,729 64,146 588.57 1.63 749.96 794.63 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
34,942,016 57,314 609.66 1.51 631.93 644.41 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
28,343,853 7,308 3,878.47 1.23 4169.16 4445.14 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
26,380,148 458,962 57.48 1.14 239.83 242.41 91hakq9n36htp   SELECT TEXT_VALUE FROM WF_ITEM...

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
209,126 2,427 86.17 14.29 61.11 745.02 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
161,625 8 20,203.13 11.04 12.69 35.98 g6yx4z6m66xtq RAXMTR select /*+ parallel(t, 8) para...
147,938 2,427 60.96 10.11 252.32 742.10 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
107,705 6 17,950.83 7.36 7.40 28.97 4099q0gjjdwah RAXMTR select /*+ parallel(t, 8) para...
24,824 10 2,482.40 1.70 1803.19 1856.38 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
19,045 125,714 0.15 1.30 56.26 63.57 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
16,871 7,314 2.31 1.15 523.56 594.56 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
15,860 205,828 0.08 1.08 1032.31 1125.91 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
15,445 258,868 0.06 1.06 809.50 862.25 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
14,636 289 50.64 1.00 2271.58 2512.63 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...

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
610,679 610,635 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
458,962 439,146 0.96 0.00 0.00 91hakq9n36htp   SELECT TEXT_VALUE FROM WF_ITEM...
400,390 315,720 0.79 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
393,149 389,422 0.99 0.00 0.00 0b85w9vv0hbt1   UPDATE WF_ITEM_ATTRIBUTE_VALUE...
363,954 363,928 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
298,363 5,072,075 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
285,451 285,346 1.00 0.03 0.03 60t2tt1564j0k   SELECT SUBSTRB(MACHINE, 1, 60)...
265,742 265,742 1.00 0.00 0.00 2rg930brttdn3 ap.oie.server.WebExpensesAM INSERT INTO WF_NOTIFICATION_AT...
258,868 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
205,828 205,827 1.00 0.01 0.01 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
610,647 610,679 6.02 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
400,346 400,390 3.95 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
363,943 363,954 3.59 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
298,359 298,363 2.94 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
205,828 205,828 2.03 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
174,387 174,389 1.72 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
125,711 125,714 1.24 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
122,169 122,170 1.20 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
117,075 117,076 1.15 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
112,963 112,964 1.11 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
101,951 101,952 1.00 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
17,381,357 8 0.55 g6yx4z6m66xtq RAXMTR select /*+ parallel(t, 8) para...
7,228,895 6 0.23 4099q0gjjdwah RAXMTR select /*+ parallel(t, 8) para...
1,051,610 20,414 0.03 1fvcx62k23ph5 OEXOETEL SELECT /*+ ORDERED USE_NL(qpq ...

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
0b85w9vv0hbt1 UPDATE WF_ITEM_ATTRIBUTE_VALUES SET TEXT_VALUE = :B4 WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
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 ;
162ttnv4ubqun begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); 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)select /*+ 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 , decode(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 , cust.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))
1fvcx62k23ph5 SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n4) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOU RCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.QUALIFIER_ATTR_VALUE = QPLATQ.VALUE_FROM AND QPQ.COMPARISON_OPERATOR_CODE = '=' AND QPQ.LIST_LINE_ID = -1 AND QPQ.SEARCH_IND = 1 AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AND NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 ))) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ .ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n6) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPR EQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = :B14 AND QPQ.QUALIFIER_DATATYPE = :B13 AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND FND_NUMBER.CANONICAL_TO_NUMBER(DECODE(QPQ.QUALIFIER_DATATYPE, :B13 , QPLATQ.VALUE_FROM, NULL)) BETWEEN QPQ.QUAL_ATTR_VALUE_FROM_NUMBER AND QPQ.QUAL_ATTR_VALUE_TO_NUMBER AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AND NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 )) ) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.STAR T_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = :B14 AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND QPQ.QUALIFIER_DATATYPE IN (:B17 , :B16 , :B15 ) AND QPLATQ.VALUE_FROM BETWEEN QPQ.QUALIFIER_ATTR_VALUE AND QPQ.QUALIFIER_ATTR_VALUE_TO AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AN D NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 ))) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTI VE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =' AND QPQ.QUALIFIER_ATTR_VALUE <> QPLATQ.VALUE_FROM AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 B ETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AND NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 ))) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE
1nj7kuvxgpwah begin ARP_TAX . SET_DEFAULT_TAX_CODE ( :setSql , :updSql ) ; END ;
25wzrzwd46a44 SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 1 FROM FND_GRANTS G, WF_USER_ROLES R WHERE G.GRANTEE_KEY = R.ROLE_NAME AND R.USER_NAME IN (SELECT INCRNS.NAME FROM WF_LOCAL_ROLES SRC , WF_LOCAL_ROLES INCRNS WHERE SRC.NAME = :B4 AND SRC.PARENT_ORIG_SYSTEM = INCRNS.PARENT_ORIG_SYSTEM AND SRC.PARENT_ORIG_SYSTEM_ID = INCRNS.PARENT_ORIG_SYSTEM_ID) AND G.OBJECT_ID = :B3 AND ((:B2 = -1) OR (G.MENU_ID IN (SELECT CMF.MENU_ID FROM FND_COMPILED_MENU_FUNCTIONS CMF WHERE CMF.FUNCTION_ID = :B2 ))) AND ( G.CTX_SECGRP_ID = -1 OR G.CTX_SECGRP_ID = SYS_CONTEXT('FND', 'SECURITY_GROUP_ID')) AND ( G.CTX_RESP_ID = -1 OR G.CTX_RESP_ID = SYS_CONTEXT('FND', 'RESP_ID')) AND ( G.CTX_RESP_APPL_ID = -1 OR G.CTX_RESP_APPL_ID = SYS_CONTEXT('FND', 'RESP_APPL_ID')) AND ( G.CTX_ORG_ID = -1 OR G.CTX_ORG_ID = SYS_CONTEXT('FND', 'ORG_ID')) AND G.START_DATE <= SYSDATE AND ( G.END_DATE IS NULL OR G.END_DATE >= SYSDATE ) AND G.INSTANCE_TYPE = :B1 )
2rg930brttdn3 INSERT INTO WF_NOTIFICATION_ATTRIBUTES ( NOTIFICATION_ID, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE, EVENT_VALUE ) VALUES ( :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
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_salesrep_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_retval: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;
3cb7xm8ykx1qh begin :1 := POR_UTIL_PKG.submitreq(:2, :3, :4, :5, :6); 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 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 ) )
3prk3vg9u0abb BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
4099q0gjjdwah select /*+ parallel(t, 8) parallel_index(t, 8) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("LAST_UPDATED_BY"), count(distinct "LAST_UPDATED_BY"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("HEADER_GDF_ATTR_CATEGORY")), substrb(dump(min("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE1"), count(distinct "HEADER_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("HEADER_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("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(sys_op_opnsize("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(sys_op_opnsize("HEADER_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(sys_op_opnsize("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 "HEADER_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("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(sys_op_opnsize("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("HEADER_GDF_ATTRIBUTE10"), count(distinct "HEADER_GDF_ATTRIBUTE10"), sum(sys_op_opn size("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(sys_op_opnsize("HEADER_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE12"), count(distinct "HEADER_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("HEADER_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE1 5", 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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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"), count(distinct "HEADER_GDF_ATTRIBUTE19"), sum(sys_op_opnsize("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(sys_op_opnsize("HEADER_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE 20", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE21"), count(distinct "HEADER_GDF_ATTRIBUTE21"), sum(sys_op_opnsize("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(sys_op_opnsize("HEADER_GDF_ATTRIBUTE22")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE23"), count(distinct "HEADER_GDF_ATTRIBUTE23"), sum(sys_op_opnsize("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(sys_op_opnsize("HEADER_GDF_ATTRIBUTE24")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE24", 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(sys_op_opnsize("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(distin ct "HEADER_GDF_ATTRIBUTE26"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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("HEADER_GDF_ATTRIBUTE30"), count(distinct "HEADER_GDF_ATTRIBUTE30"), sum(sys_op_opnsize("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(sys_op_opnsize("LINE_GDF_ATTR_CATEGORY")), sub strb(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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("LINE_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE5"), count(distinct "LINE_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("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(sys_op_opnsize("LINE_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE7"), count(distinct "LINE_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("LINE_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE10", 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(sys_op_opnsize("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(sys_op_opnsize("LINE_GDF_ATTRIBUTE12")), substrb(dump(min(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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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_ATTRIBUTE16"), sum(sys_op_opnsize("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"), cou nt(distinct "LINE_GDF_ATTRIBUTE17"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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), count("LINE_GDF_ATTRIBUTE20"), count(distinct "LINE_GDF_ATTRIBUTE20"), sum(sys_op_opnsize("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(sys_op_opnsize("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("PAYMENT_SERVER_ORDER_NUM"), count(distinct "PAYMENT_SERVER_ORDER_NUM"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("WAREHOUSE_ID")), substrb(dump(min("WAREHOUSE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("WAREHOUSE_ID"), 16, 0, 32), 1, 120), count("TRANSLATED_DESCRIPTION"), count(distinct "TRANSLATED_DESCRIPTION"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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("REFERENCE_LINE_ATTRIBUTE4"), count(distinct "REFERENCE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE4")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE5"), count(distinct "REFERENCE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("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(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE6")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE7"), count(distinct "REFERENCE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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_SEGM ENT4"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("TERRITORY_SEGMENT16")), substrb(dump(min("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), count("T ERRITORY_SEGMENT17"), count(distinct "TERRITORY_SEGMENT17"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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 "ATTRIBUTE2"), sum(sys_op_opnsize("ATTRIBUTE2")), substrb(dump(min(s ubstrb("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(sys_op_opnsize("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(sys_op_opnsize("ATTRIBUTE4")), substrb(dump(min(substrb("ATTRIBUTE4", 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(sys_op_opnsize("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(sys_op_opnsize("ATTRIBUTE6")), substrb(dump(min(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE7"), count(distinct "ATTRIBUTE7"), sum(sys_op_opnsize("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(sys_op_opnsize("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(distinct "ATTRIBUTE9"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("ATTRIBUTE11")), substrb(dump(min(substrb("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("HEADER_ATTRIBUTE5")), substrb(dump(min(substrb("HE ADER_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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("HEADER_ATTRIBUTE10")⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀ ∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀ ∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀 Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㄀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㄀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀 吀吀刀䤀䈀唀吀䔀㄀㄀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㄀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㄀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㈀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㈀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㈀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㈀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㈀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㌀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㌀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㌀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㌀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㌀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㐀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㐀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㐀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㐀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀ ㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㐀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㔀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㔀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㔀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㔀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㔀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䌀伀䴀䴀䔀一吀匀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䌀伀䴀䴀䔀一吀匀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䌀伀䴀䴀䔀一吀匀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䌀伀䴀䴀䔀一吀匀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䌀伀䴀䴀䔀一吀匀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀ 洀愀砀⠀猀甀戀猀琀爀戀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE"), count(distinct "USSGL_TRANSACTION_CODE"), sum(sys_op_opnsize("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(sys_op_opnsize("ACCTD_AMOUNT")), substrb(dump(min("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), count("CUSTOME R_BANK_ACCOUNT_ID"), count(distinct "CUSTOMER_BANK_ACCOUNT_ID"), sum(sys_op_opnsize("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(sys_op_opnsize("CUSTOMER_BANK_ACCOUNT_NAME")), substrb(dump(min(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32) , 1, 120), substrb(dump(max(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), count("UOM_CODE"), count(distinct "UOM_CODE"), sum(sys_op_opnsize("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(sys_op_opnsize("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_NUMBER_SEQUENCE_ID"), sum(sys_op_opnsize("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(sys_op_opnsize("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(distinct "LINK_TO_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("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(sys_op_opnsize("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"), count(distinct "LINK_TO_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE10")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE1 0"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE11"), count(distinct "REFERENCE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE14")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE15"), count(distinct "REFERENCE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("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(dis tinct "REFERENCE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE8")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE9"), count(distinct "REFERENCE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("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(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("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(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("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(sys_op_opnsize("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) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t
473dq7tb653mp declare p varchar2(32767); begin p := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); :v1 := substr(p, 1, 4000); :v2 := substr(p, 4001, 4000); :v3 := substr(p, 8001, 4000); :v4 := substr(p, 12001, 4000); :v5 := substr(p, 16001, 4000); :v6 := substr(p, 20001, 4000); :v7 := substr(p, 24001, 4000); :v8 := substr(p, 28001, 4000); :v9 := substr(p, 32001, 767); :v10 := substr(p, 4001, 1); :v11 := substr(p, 8001, 1); :v12 := substr(p, 12001, 1); :v13 := substr(p, 16001, 1); :v14 := substr(p, 20001, 1); :v15 := substr(p, 24001, 1); :v16 := substr(p, 28001, 1); :v17 := substr(p, 32001, 1); end;
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 ;
60t2tt1564j0k SELECT SUBSTRB(MACHINE, 1, 60), PROCESS, PROGRAM FROM V$SESSION WHERE AUDSID = :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;
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.interface_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.translated_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, decode(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, null, 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.line_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'
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_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 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 )
8camsgjsr9zya begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
8h16w67202y4g begin fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :l); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :m); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end;
8jb36w62w5hqf BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
91hakq9n36htp SELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
9sf243fdjmdmh begin fnd_global.apps_initialize(-1, -1, -1, :1); end;
a29grr748ghc4 BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
avc1jqzz04wpr SELECT 'x' FROM DUAL
bkxrrs52m7d8p BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
cwyx16zn1hpfb select parameter, value from nls_session_parameters
fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fkxdmd0h7xg54 select item, item_id, item_description, inventory_item_id, item_identifier_type, decode(item_identifier_type, 'INT', :1, 'CUST', :2, item_identifier_type) item_identifier_type_meaning, inventory_item, Address, cust_address, item_definition_level from oe_items_v where ( UPPER(ITEM) LIKE :3 AND (ITEM LIKE :4 OR ITEM LIKE :5 OR ITEM LIKE :6 OR ITEM LIKE :7)) AND ( (sold_to_org_id = :8 or sold_to_org_id is null) and (item_status ='ACTIVE' or item_status IS NULL) and (cross_ref_status = 'ACTIVE' or cross_ref_status IS NULL) ) order by item
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
g6yx4z6m66xtq select /*+ parallel(t, 8) parallel_index(t, 8) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_LINE_ATTRIBUTE15"), count(distinct "INTERFACE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("TAX_EXEMPT_REASON_CODE_MEANING")), substrb(dump(min(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("TAX_EXEMPT_NUMBER"), count(distinct "TAX_EXEMPT_NUMBER"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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("CUST_TRX_TYPE_NAME"), count(distinct "CUST_TRX_TYPE_NAME"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("ORIG_SYSTEM_BILL_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(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(sys_op_opnsize("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(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_REF")), substrb(dump(min(substrb("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(sys_op_opnsize("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_CONTACT_REF"), sum(sys_op_opnsize("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(sys_op_opnsize("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), count("ORIG_SYSTEM_SHIP_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_SHIP_CUSTOMER_REF"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("ORIG_SYSTEM_SHIP_ADDRESS_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(sys_op_opnsize("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"), count(distinct "ORIG_SYSTEM_SHIP_CONTACT_ID"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(distin ct "LINK_TO_LINE_CONTEXT"), sum(sys_op_opnsize("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(sys_op_opnsize("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), count("LINK_TO_LINE_ATTRIBUTE2"), count(distinct "LINK_TO_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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("LINK_TO_L INE_ATTRIBUTE6"), count(distinct "LINK_TO_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("CONVERSION_TYPE")), substrb(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(sys_op_opnsize("CONVERSION_RATE")), substrb(dump(min("CONVERSION_RATE"), 16, 0, 32), 1, 120), substrb(dum p(max("CONVERSION_RATE"), 16, 0, 32), 1, 120), count("CUSTOMER_TRX_ID"), count(distinct "CUSTOMER_TRX_ID"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("LINE_NUMBER")), substrb(dump(min("LINE_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_NUMBER"), 16, 0, 32), 1, 120), count("QUANTITY"), count(distinct "QUANTITY"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("PRINTING_OPTION")), 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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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"), coun t(distinct "RELATED_TRX_NUMBER"), sum(sys_op_opnsize("RELATED_TRX_NUMBER")), substrb(dump(min("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), count("RELATED_CUSTOMER_TRX_ID"), count(distinct "RELATED_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("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(sys_op_opnsize("PREVIOUS_CUSTOMER_TRX_ID")), substrb(dump(min("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_ACCT_RULE"), count(distinct "CREDIT_METHOD_FOR_ACCT_RULE"), sum(sys_op_opnsize("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(sys_op_opnsize("CREDIT_METHOD_FOR_INSTALLMENTS")), substrb(dump(min("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 32), 1, 120), count("REASON_CODE"), count(distinct "REASON_CODE"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("FOB_POINT")), substrb(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(sys_op_opnsize("SHIP_VIA")), substrb(dump(min("SHIP_VIA"), 16, 0, 32), 1, 120), subst rb(dump(max("SHIP_VIA"), 16, 0, 32), 1, 120), count("WAYBILL_NUMBER"), count(distinct "WAYBILL_NUMBER"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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("RUL E_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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("SALES_ORDER")), substrb(dump(min(substrb("SALES_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SALES_ORDER", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_LINE"), count(distinct "SALES_ORDER_LINE"), sum(sys_op_opnsize("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(sys_op_opnsize("SALES_ORDER_SOURCE")), substrb(dump(min(substrb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(sub strb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_REVISION"), count(distinct "SALES_ORDER_REVISION"), sum(sys_op_opnsize("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(sys_op_opnsize("PURCHASE_ORDER")), 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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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"), su m(sys_op_opnsize("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(sys_op_opnsize("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 "INVENTORY_ITEM_ID"), sum(sys_op_opnsize("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(sys_op_opnsize("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_ITEMS_SEG2"), sum(sys_op_opnsize("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(sys_op_opnsize("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_ITEMS_SEG4"), count(distinct "MTL _SYSTEM_ITEMS_SEG4"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG7")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG7", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG8"), count(distinct "MTL_SYSTEM_ITEMS_SEG8"), sum(sys_op_opnsize("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(sys_op_opnsize("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), count("MTL_SYSTEM_ITEMS_SEG10"), count(distinct "MTL_SYSTEM_ITEMS_SEG10"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG13")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_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(sys_op_opnsize("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_I TEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG15"), count(distinct "MTL_SYSTEM_ITEMS_SEG15"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_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(sys_op_opnsize("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 "MTL_SYSTEM_ITEMS_SEG17"), sum(sys_op_opnsize("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(sys_op_opnsize("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), count("MTL_SYSTEM_ITEMS_SEG19"), count(distinct "MTL_SYSTEM_ITEMS_SEG19"), sum(sys_op_opnsize("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"), coun t(distinct "MTL_SYSTEM_ITEMS_SEG20"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG20")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ID"), count(distinct "REFERENCE_LINE_ID"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE2")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE3"), count(distinct "REFERENCE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE3")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUT E3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ID"), sum(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("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(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE4")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LIN E_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE5"), count(distinct "INTERFACE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("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(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE6")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE7"), count(distinct "INTERFACE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("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(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE8")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count(distinct "BATCH_SOURCE_NAME"), sum(sys_op_opnsize("BATCH_SOURCE_NAME")), substrb(dump(min(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䈀䄀吀䌀䠀开匀伀唀刀䌀䔀开一䄀䴀䔀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ猀甀洀⠀猀礀 猀开漀瀀开漀瀀渀猀椀稀攀⠀∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀匀䔀吀开 伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䰀䤀一䔀开吀夀倀䔀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䰀䤀一䔀开吀夀倀䔀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䰀䤀一䔀开吀夀倀䔀∀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䰀䤀一䔀开吀夀倀䔀∀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䄀䴀伀唀一吀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䄀䴀伀唀一吀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䄀䴀伀唀一吀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䄀䴀伀唀一吀∀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䄀䴀伀唀一吀∀⤀Ⰰ㄀㘀Ⰰ Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀ ⤀ 昀爀漀洀 ∀䄀刀∀⸀∀刀䄀开䤀一吀䔀刀䘀䄀䌀䔀开䰀䤀一䔀匀开䄀䰀䰀∀ 猀愀洀瀀氀攀 ⠀ ㄀ ⸀          ⤀ 琀
g8102j8yynbwz begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
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;
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'

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 6,230,425 1,703.52 4.92
CPU used when call started 6,214,277 1,699.10 4.91
CR blocks created 14,457,335 3,952.91 11.42
Cached Commit SCN referenced 1,659,260 453.67 1.31
Commit SCN cached 16 0.00 0.00
DB time 17,795,210 4,865.55 14.06
DBWR checkpoint buffers written 1,774,577 485.20 1.40
DBWR checkpoints 58 0.02 0.00
DBWR object drop buffers written 58,888 16.10 0.05
DBWR parallel query checkpoint buffers written 84,956 23.23 0.07
DBWR revisited being-written buffer 563 0.15 0.00
DBWR transaction table writes 1,588 0.43 0.00
DBWR undo block writes 1,648,989 450.86 1.30
DFO trees parallelized 10 0.00 0.00
IMU CR rollbacks 33,718,437 9,219.26 26.64
IMU Flushes 374,061 102.28 0.30
IMU Redo allocation size 2,546,151,372 696,166.03 2,011.64
IMU commits 645,829 176.58 0.51
IMU contention 45,192 12.36 0.04
IMU ktichg flush 12,696 3.47 0.01
IMU pool not allocated 2,903 0.79 0.00
IMU recursive-transaction flush 1,814 0.50 0.00
IMU undo allocation size 5,769,058,528 1,577,369.91 4,557.97
IMU- failed to get a private strand 2,903 0.79 0.00
PX local messages recv'd 9,177 2.51 0.01
PX local messages sent 9,177 2.51 0.01
Parallel operations downgraded 25 to 50 pct 6 0.00 0.00
Parallel operations downgraded 50 to 75 pct 2 0.00 0.00
Parallel operations downgraded to serial 31 0.01 0.00
Parallel operations not downgraded 2 0.00 0.00
SQL*Net roundtrips to/from client 48,142,494 13,163.07 38.04
active txn count during cleanout 94,731,674 25,901.43 74.84
application wait time 31,190 8.53 0.02
background checkpoints completed 2 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 11,547 3.16 0.01
branch node splits 1,055 0.29 0.00
buffer is not pinned count 742,740,572 203,079.35 586.82
buffer is pinned count 1,219,740,558 333,500.18 963.68
bytes received via SQL*Net from client 11,374,139,153 3,109,905.16 8,986.39
bytes sent via SQL*Net to client 10,089,895,799 2,758,768.70 7,971.75
calls to get snapshot scn: kcmgss 120,670,408 32,993.58 95.34
calls to kcmgas 18,921,506 5,173.50 14.95
calls to kcmgcs 1,721,425 470.67 1.36
change write time 112,987 30.89 0.09
cleanout - number of ktugct calls 15,836,389 4,329.97 12.51
cleanouts and rollbacks - consistent read gets 13,430,327 3,672.11 10.61
cleanouts only - consistent read gets 165,736 45.32 0.13
cluster key scan block gets 952,895 260.54 0.75
cluster key scans 194,942 53.30 0.15
commit batch/immediate performed 5,979 1.63 0.00
commit batch/immediate requested 5,979 1.63 0.00
commit cleanout failures: block lost 275,552 75.34 0.22
commit cleanout failures: buffer being written 139 0.04 0.00
commit cleanout failures: callback failure 142,790 39.04 0.11
commit cleanout failures: cannot pin 43,734 11.96 0.03
commit cleanouts 10,506,670 2,872.72 8.30
commit cleanouts successfully completed 10,044,443 2,746.34 7.94
commit immediate performed 5,979 1.63 0.00
commit immediate requested 5,979 1.63 0.00
commit txn count during cleanout 1,585,412 433.48 1.25
concurrency wait time 88,741 24.26 0.07
consistent changes 896,297,448 245,064.71 708.14
consistent gets 2,098,860,305 573,868.18 1,658.25
consistent gets - examination 1,366,089,883 373,514.86 1,079.31
consistent gets direct 168,644 46.11 0.13
consistent gets from cache 2,098,691,180 573,821.93 1,658.12
current blocks converted for CR 317 0.09 0.00
cursor authentications 1,963 0.54 0.00
data blocks consistent reads - undo records applied 891,167,326 243,662.03 704.09
db block changes 202,180,032 55,279.85 159.74
db block gets 213,699,808 58,429.58 168.84
db block gets direct 61,866 16.92 0.05
db block gets from cache 213,637,960 58,412.67 168.79
deferred (CURRENT) block cleanout applications 1,847,215 505.06 1.46
dirty buffers inspected 709,485 193.99 0.56
doubling up with imu segment 0 0.00 0.00
enqueue conversions 9,862 2.70 0.01
enqueue releases 5,063,166 1,384.37 4.00
enqueue requests 5,065,925 1,385.12 4.00
enqueue timeouts 2,492 0.68 0.00
enqueue waits 122,726 33.56 0.10
exchange deadlocks 38,189 10.44 0.03
execute count 107,048,010 29,268.95 84.58
failed probes on index block reclamation 1,207 0.33 0.00
free buffer inspected 6,039,066 1,651.20 4.77
free buffer requested 20,151,130 5,509.70 15.92
heap block compress 9,250,209 2,529.18 7.31
hot buffers moved to head of LRU 2,946,175 805.54 2.33
immediate (CR) block cleanout applications 13,596,164 3,717.45 10.74
immediate (CURRENT) block cleanout applications 1,183,223 323.52 0.93
index crx upgrade (found) 90,825 24.83 0.07
index crx upgrade (positioned) 10,882,806 2,975.57 8.60
index fast full scans (full) 8 0.00 0.00
index fast full scans (rowid ranges) 47 0.01 0.00
index fetch by key 166,920,234 45,639.15 131.88
index scans kdiixs1 164,965,587 45,104.72 130.33
java call heap collected bytes 1,493,135,336 408,251.49 1,179.68
java call heap collected count 18,155,789 4,964.14 14.34
java call heap gc count 4,761 1.30 0.00
java call heap live object count 1,448,954 396.17 1.14
java call heap live object count max 1,449,466 396.31 1.15
java call heap live size 349,596,480 95,586.30 276.21
java call heap live size max 349,678,528 95,608.74 276.27
java call heap object count 3,643,383 996.17 2.88
java call heap object count max 3,639,743 995.17 2.88
java call heap total size 450,756,608 123,245.40 356.13
java call heap total size max 450,756,608 123,245.40 356.13
java call heap used size 489,994,288 133,973.72 387.13
java call heap used size max 489,861,848 133,937.51 387.03
leaf node 90-10 splits 23,992 6.56 0.02
leaf node splits 259,164 70.86 0.20
lob reads 23,687 6.48 0.02
lob writes 49,953 13.66 0.04
lob writes unaligned 49,953 13.66 0.04
logons cumulative 12,309 3.37 0.01
messages received 1,193,675 326.37 0.94
messages sent 1,193,676 326.37 0.94
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 683,461,471 186,871.32 539.98
opened cursors cumulative 6,786,537 1,855.57 5.36
parse count (failures) 4,001 1.09 0.00
parse count (hard) 9,844 2.69 0.01
parse count (total) 10,146,579 2,774.27 8.02
parse time cpu 115,096 31.47 0.09
parse time elapsed 136,575 37.34 0.11
physical read IO requests 934,174 255.42 0.74
physical read bytes 11,992,391,680 3,278,947.12 9,474.86
physical read total IO requests 935,870 255.88 0.74
physical read total bytes 12,019,320,832 3,286,310.06 9,496.13
physical read total multi block requests 17,763 4.86 0.01
physical reads 1,463,914 400.26 1.16
physical reads cache 1,085,918 296.91 0.86
physical reads cache prefetch 159,818 43.70 0.13
physical reads direct 377,998 103.35 0.30
physical reads direct temporary tablespace 372 0.10 0.00
physical reads prefetch warmup 15,297 4.18 0.01
physical write IO requests 1,089,695 297.94 0.86
physical write bytes 25,220,440,064 6,895,746.19 19,925.97
physical write total IO requests 2,674,804 731.34 2.11
physical write total bytes 58,886,108,160 16,100,577.75 46,524.28
physical write total multi block requests 1,793,922 490.49 1.42
physical writes 3,078,667 841.77 2.43
physical writes direct 62,458 17.08 0.05
physical writes direct (lob) 248 0.07 0.00
physical writes direct temporary tablespace 4,291 1.17 0.00
physical writes from cache 3,016,209 824.69 2.38
physical writes non checkpoint 2,650,910 724.81 2.09
pinned buffers inspected 7,875 2.15 0.01
prefetch clients - default 1 0.00 0.00
prefetch warmup blocks aged out before use 233,114 63.74 0.18
prefetched blocks aged out before use 139 0.04 0.00
process last non-idle time 3,657 1.00 0.00
queries parallelized 10 0.00 0.00
recursive aborts on index block reclamation 10 0.00 0.00
recursive calls 174,501,121 47,711.91 137.87
recursive cpu usage 3,706,680 1,013.48 2.93
redo blocks written 65,588,826 17,933.23 51.82
redo buffer allocation retries 44 0.01 0.00
redo entries 103,358,037 28,260.05 81.66
redo log space requests 77 0.02 0.00
redo log space wait time 117 0.03 0.00
redo ordering marks 1,079,881 295.26 0.85
redo size 32,079,701,864 8,771,198.34 25,345.28
redo subscn max counts 2,457,092 671.82 1.94
redo synch time 121,956 33.35 0.10
redo synch writes 2,437,290 666.40 1.93
redo wastage 404,297,888 110,542.70 319.42
redo write time 35,741 9.77 0.03
redo writer latching time 976 0.27 0.00
redo writes 896,739 245.19 0.71
rollback changes - undo records applied 279,332 76.37 0.22
rollbacks only - consistent read gets 1,112,764 304.25 0.88
rows fetched via callback 102,064,822 27,906.46 80.64
session connect time 0 0.00 0.00
session cursor cache hits 5,977,088 1,634.25 4.72
session logical reads 2,312,580,606 632,303.36 1,827.11
session pga memory 13,064,375,352 3,572,047.77 10,321.80
session pga memory max 14,124,742,456 3,861,972.22 11,159.57
session uga memory ############### 75,861,827.80 219,210.58
session uga memory max 89,506,417,744 24,472,750.59 70,716.54
shared hash latch upgrades - no wait 34,095,082 9,322.24 26.94
shared hash latch upgrades - wait 131,124 35.85 0.10
sorts (memory) 11,254,154 3,077.10 8.89
sorts (rows) 119,659,574 32,717.19 94.54
sql area evicted 829 0.23 0.00
sql area purged 4,110 1.12 0.00
summed dirty queue length 3,823,180 1,045.33 3.02
switch current to new buffer 1,832,610 501.07 1.45
table fetch by rowid 836,992,430 228,849.59 661.28
table fetch continued row 22,582,397 6,174.46 17.84
table scan blocks gotten 79,759,208 21,807.68 63.02
table scan rows gotten 4,553,075,767 1,244,897.19 3,597.26
table scans (direct read) 416 0.11 0.00
table scans (long tables) 622 0.17 0.00
table scans (rowid ranges) 578 0.16 0.00
table scans (short tables) 6,373,758 1,742.71 5.04
total number of times SMON posted 165,999 45.39 0.13
transaction rollbacks 5,979 1.63 0.00
transaction tables consistent read rollbacks 209 0.06 0.00
transaction tables consistent reads - undo records applied 18,663 5.10 0.01
undo change vector size 11,549,412,056 3,157,828.10 9,124.87
user I/O wait time 294,730 80.58 0.23
user calls 45,833,123 12,531.64 36.21
user commits 992,790 271.45 0.78
user rollbacks 272,917 74.62 0.22
workarea executions - onepass 4 0.00 0.00
workarea executions - optimal 6,367,888 1,741.10 5.03
write clones created in background 3,764 1.03 0.00
write clones created in foreground 961 0.26 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 329,593 1,266,302
opened cursors current 1,116,381 1,354,361
workarea memory allocated 579 4,251
logons current 5,521 5,523

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 2 1.97

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_TS_TX_DATA 581,133 159 3.16 1.13 110,421 30 165,495 0.22
APPS_UNDOTS1 17,175 5 0.45 1.00 592,574 162 354,918 0.07
APPS_TS_TX_IDX 239,360 65 3.13 1.04 127,185 35 107,043 0.29
APPS_TS_TX_INTERFACE 12,630 3 2.61 30.53 122,626 34 58,007 0.30
APPS_ASSM_DATA 38,275 10 0.82 2.26 49,227 13 186,041 0.72
APPS_ASSM_IDX 20,811 6 1.92 1.00 54,266 15 144,189 0.19
TEMP 3,961 1 3.03 2.07 23,663 6 132 6.82
SYSTEM 8,614 2 3.59 3.23 3,133 1 12,753 0.39
APPS_TS_SEED 8,227 2 4.22 1.12 2,548 1 1,005 2.57
CTXSYS 632 0 4.05 1.10 1,855 1 2 0.00
APPS_TS_QUEUES 307 0 4.04 1.20 745 0 409 1.59
SYSAUX 481 0 2.31 1.27 493 0 0 0.00
APPS_TS_ARCHIVE 232 0 3.41 1.00 543 0 236 4.32
APPS_TS_SUMMARY 100 0 4.60 1.00 249 0 138 0.43
APPS_TS_NOLOGGING 47 0 4.68 1.30 111 0 7 2.86
APPS_TS_MEDIA 6 0 5.00 1.00 6 0 0 0.00
ODM 10 0 2.00 1.00 2 0 0 0.00
OLAP 10 0 5.00 1.00 2 0 0 0.00
OWAPUB 10 0 2.00 1.00 2 0 0 0.00
PORTAL 10 0 4.00 1.00 2 0 0 0.00
SYNCSERVER 10 0 2.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/11.5.10/oracle/data/apps_assm_data.dbf 38,275 10 0.82 2.26 49,227 13 186,041 0.72
APPS_ASSM_IDX /OASB/11.5.10/oracle/data/apps_assm_idx.dbf 20,811 6 1.92 1.00 54,266 15 144,189 0.19
APPS_TS_ARCHIVE /OASB/11.5.10/oracle/data/archive1.dbf 81 0 3.46 1.00 241 0 118 3.56
APPS_TS_ARCHIVE /OASB/11.5.10/oracle/data/archive2.dbf 151 0 3.38 1.00 302 0 118 5.08
APPS_TS_MEDIA /OASB/11.5.10/oracle/data/media1.dbf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /OASB/11.5.10/oracle/data/media2.dbf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /OASB/11.5.10/oracle/data/media3.dbf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_NOLOGGING /OASB/11.5.10/oracle/data/nologging1.dbf 21 0 4.76 1.67 60 0 7 2.86
APPS_TS_NOLOGGING /OASB/11.5.10/oracle/data/nologging2.dbf 22 0 4.55 1.00 42 0 0 0.00
APPS_TS_NOLOGGING /OASB/11.5.10/oracle/data/nologging3.dbf 4 0 5.00 1.00 9 0 0 0.00
APPS_TS_QUEUES /OASB/11.5.10/oracle/data/queues1.dbf 28 0 3.93 1.00 91 0 6 0.00
APPS_TS_QUEUES /OASB/11.5.10/oracle/data/queues2.dbf 95 0 4.00 1.38 163 0 212 2.78
APPS_TS_QUEUES /OASB/11.5.10/oracle/data/queues3.dbf 71 0 2.68 1.07 156 0 109 0.28
APPS_TS_QUEUES /OASB/11.5.10/oracle/data/queues4.dbf 38 0 3.95 1.16 91 0 57 0.53
APPS_TS_QUEUES /OASB/11.5.10/oracle/data/queues5.dbf 21 0 6.19 1.10 63 0 1 0.00
APPS_TS_QUEUES /OASB/11.5.10/oracle/data/queues6.dbf 20 0 5.50 1.10 65 0 4 0.00
APPS_TS_QUEUES /OASB/11.5.10/oracle/data/queues7.dbf 34 0 5.00 1.32 116 0 20 0.00
APPS_TS_SEED /OASB/11.5.10/oracle/data/reference1.dbf 517 0 4.45 1.21 236 0 214 2.52
APPS_TS_SEED /OASB/11.5.10/oracle/data/reference10.dbf 540 0 4.19 1.08 172 0 0 0.00
APPS_TS_SEED /OASB/11.5.10/oracle/data/reference2.dbf 669 0 4.25 1.22 267 0 704 2.78
APPS_TS_SEED /OASB/11.5.10/oracle/data/reference3.dbf 947 0 4.05 1.11 293 0 10 3.00
APPS_TS_SEED /OASB/11.5.10/oracle/data/reference4.dbf 945 0 4.16 1.10 275 0 45 0.67
APPS_TS_SEED /OASB/11.5.10/oracle/data/reference5.dbf 902 0 4.35 1.07 247 0 1 0.00
APPS_TS_SEED /OASB/11.5.10/oracle/data/reference6.dbf 919 0 4.53 1.14 279 0 10 0.00
APPS_TS_SEED /OASB/11.5.10/oracle/data/reference7.dbf 923 0 4.31 1.12 248 0 2 0.00
APPS_TS_SEED /OASB/11.5.10/oracle/data/reference8.dbf 942 0 4.20 1.07 288 0 11 1.82
APPS_TS_SEED /OASB/11.5.10/oracle/data/reference9.dbf 923 0 3.86 1.14 243 0 8 0.00
APPS_TS_SUMMARY /OASB/11.5.10/oracle/data/summary1.dbf 7 0 2.86 1.00 29 0 0 0.00
APPS_TS_SUMMARY /OASB/11.5.10/oracle/data/summary2.dbf 7 0 1.43 1.00 34 0 69 0.29
APPS_TS_SUMMARY /OASB/11.5.10/oracle/data/summary3.dbf 8 0 3.75 1.00 29 0 20 1.00
APPS_TS_SUMMARY /OASB/11.5.10/oracle/data/summary4.dbf 9 0 2.22 1.00 23 0 18 0.00
APPS_TS_SUMMARY /OASB/11.5.10/oracle/data/summary5.dbf 6 0 8.33 1.00 25 0 0 0.00
APPS_TS_SUMMARY /OASB/11.5.10/oracle/data/summary6.dbf 27 0 4.81 1.00 44 0 1 0.00
APPS_TS_SUMMARY /OASB/11.5.10/oracle/data/summary7.dbf 31 0 5.16 1.00 46 0 29 0.69
APPS_TS_SUMMARY /OASB/11.5.10/oracle/data/summary8.dbf 5 0 8.00 1.00 19 0 1 0.00
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data1.dbf 2,041 1 2.64 1.52 2,059 1 6,298 0.33
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data10.dbf 1,905 1 2.72 1.39 1,998 1 5,993 0.25
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data11.dbf 2,113 1 2.81 1.44 2,169 1 6,975 0.41
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data12.dbf 52,303 14 3.07 1.09 8,132 2 6,419 0.09
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data13.dbf 52,618 14 3.37 1.09 7,949 2 6,803 0.10
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data14.dbf 55,253 15 3.25 1.09 9,613 3 39,838 0.10
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data15.dbf 52,136 14 2.98 1.09 8,083 2 6,507 0.27
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data16.dbf 52,147 14 3.07 1.09 7,994 2 6,867 0.27
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data17.dbf 52,037 14 3.04 1.09 8,002 2 4,898 0.08
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data18.dbf 51,721 14 3.09 1.10 7,948 2 5,471 0.12
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data19.dbf 51,858 14 3.07 1.09 7,910 2 6,040 0.10
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data2.dbf 2,206 1 2.45 2.22 2,406 1 6,683 0.38
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data20.dbf 51,846 14 3.28 1.09 7,725 2 5,083 0.15
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data21.dbf 51,967 14 3.40 1.09 7,903 2 5,991 0.08
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data3.dbf 2,796 1 2.70 2.11 2,959 1 6,759 0.43
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data4.dbf 3,538 1 2.74 1.81 3,029 1 6,357 0.36
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data5.dbf 16,210 4 3.48 1.22 3,195 1 6,160 0.38
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data6.dbf 4,736 1 3.14 1.66 3,103 1 6,933 0.27
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data7.dbf 15,710 4 3.52 1.20 2,907 1 6,155 0.41
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data8.dbf 2,611 1 2.35 1.96 2,459 1 6,360 0.26
APPS_TS_TX_DATA /OASB/11.5.10/oracle/data/tx_data9.dbf 3,381 1 2.55 1.90 2,878 1 6,905 0.27
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx1.dbf 1,620 0 3.46 1.02 2,147 1 2,513 0.43
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx10.dbf 2,094 1 3.36 1.03 4,792 1 2,269 0.33
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx11.dbf 2,214 1 3.03 1.02 3,733 1 3,132 1.18
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx12.dbf 20,516 6 3.08 1.03 9,074 2 7,019 0.22
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx13.dbf 20,302 6 3.04 1.04 8,741 2 6,480 0.23
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx14.dbf 24,059 7 2.93 1.03 13,423 4 9,539 0.18
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx15.dbf 19,846 5 3.10 1.05 8,578 2 6,300 0.37
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx16.dbf 19,835 5 3.18 1.04 8,406 2 5,364 0.15
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx17.dbf 19,977 5 3.07 1.04 8,267 2 5,839 0.23
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx18.dbf 19,735 5 3.15 1.04 8,299 2 5,659 0.15
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx19.dbf 19,994 5 3.08 1.05 8,586 2 5,998 0.20
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx2.dbf 1,824 0 3.17 1.02 3,608 1 9,168 0.20
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx20.dbf 19,626 5 3.09 1.05 8,268 2 7,595 0.23
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx21.dbf 19,892 5 3.14 1.04 8,326 2 7,039 0.24
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx3.dbf 2,944 1 3.18 1.03 4,033 1 3,268 0.43
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx4.dbf 4,381 1 3.40 1.02 3,806 1 2,522 0.52
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx5.dbf 4,280 1 3.51 1.01 3,189 1 2,578 0.45
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx6.dbf 4,214 1 3.54 1.03 3,002 1 2,873 0.42
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx7.dbf 4,113 1 3.40 1.03 2,705 1 3,910 0.37
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx8.dbf 3,790 1 3.41 1.03 3,452 1 4,026 0.30
APPS_TS_TX_IDX /OASB/11.5.10/oracle/data/tx_idx9.dbf 4,104 1 3.46 1.03 2,750 1 3,952 0.19
APPS_TS_TX_INTERFACE /OASB/11.5.10/oracle/data/ts_tx_inte.dbf 1,507 0 2.10 13.08 4,753 1 5,489 0.14
APPS_TS_TX_INTERFACE /OASB/11.5.10/oracle/data/ts_tx_inte2.dbf 2,391 1 2.86 30.65 23,699 6 10,581 0.40
APPS_TS_TX_INTERFACE /OASB/11.5.10/oracle/data/ts_tx_inte3.dbf 2,282 1 2.85 32.13 23,639 6 12,540 0.30
APPS_TS_TX_INTERFACE /OASB/11.5.10/oracle/data/ts_tx_inte4.dbf 2,287 1 2.89 31.92 23,432 6 10,347 0.29
APPS_TS_TX_INTERFACE /OASB/11.5.10/oracle/data/ts_tx_inte5.dbf 1,996 1 2.46 36.75 23,517 6 9,315 0.28
APPS_TS_TX_INTERFACE /OASB/11.5.10/oracle/data/ts_tx_inte6.dbf 2,167 1 2.27 33.64 23,586 6 9,735 0.30
APPS_UNDOTS1 /OASB/11.5.10/oracle/data/undo01.dbf 460 0 0.30 1.00 21,852 6 34,038 0.07
APPS_UNDOTS1 /OASB/11.5.10/oracle/data/undo02.dbf 256 0 0.27 1.00 21,075 6 32,329 0.07
APPS_UNDOTS1 /OASB/11.5.10/oracle/data/undo03.dbf 220 0 0.27 1.00 20,963 6 34,018 0.06
APPS_UNDOTS1 /OASB/11.5.10/oracle/data/undo04.dbf 24 0 0.83 1.00 21,191 6 36,342 0.06
APPS_UNDOTS1 /OASB/11.5.10/oracle/data/undo05.dbf 3,102 1 0.47 1.00 109,287 30 45,047 0.09
APPS_UNDOTS1 /OASB/11.5.10/oracle/data/undo06.dbf 2,595 1 0.45 1.00 104,308 29 45,382 0.07
APPS_UNDOTS1 /OASB/11.5.10/oracle/data/undo07.dbf 3,063 1 0.44 1.00 96,609 26 43,551 0.06
APPS_UNDOTS1 /OASB/11.5.10/oracle/data/undo08.dbf 4,215 1 0.52 1.00 100,013 27 43,657 0.07
APPS_UNDOTS1 /OASB/11.5.10/oracle/data/undo09.dbf 3,240 1 0.38 1.00 97,276 27 40,554 0.08
CTXSYS /OASB/11.5.10/oracle/data/ctx1.dbf 159 0 3.65 1.16 244 0 1 0.00
CTXSYS /OASB/11.5.10/oracle/data/ctx2.dbf 473 0 4.19 1.07 1,611 0 1 0.00
ODM /OASB/11.5.10/oracle/data/odm.dbf 10 0 2.00 1.00 2 0 0 0.00
OLAP /OASB/11.5.10/oracle/data/olap.dbf 10 0 5.00 1.00 2 0 0 0.00
OWAPUB /OASB/11.5.10/oracle/data/owa1.dbf 10 0 2.00 1.00 2 0 0 0.00
PORTAL /OASB/11.5.10/oracle/data/portal.dbf 10 0 4.00 1.00 2 0 0 0.00
SYNCSERVER /OASB/11.5.10/oracle/data/mobile01.dbf 10 0 2.00 1.00 2 0 0 0.00
SYSAUX /OASB/11.5.10/oracle/data/sysaux01.dbf 330 0 2.21 1.35 280 0 0 0.00
SYSAUX /OASB/11.5.10/oracle/data/sysaux02.dbf 151 0 2.52 1.07 213 0 0 0.00
SYSTEM /OASB/11.5.10/oracle/data/sys1.dbf 1,246 0 3.35 3.32 349 0 535 1.08
SYSTEM /OASB/11.5.10/oracle/data/sys2.dbf 1,281 0 3.71 3.25 408 0 456 1.97
SYSTEM /OASB/11.5.10/oracle/data/sys3.dbf 1,159 0 3.75 3.41 364 0 482 1.16
SYSTEM /OASB/11.5.10/oracle/data/sys4.dbf 1,273 0 3.90 3.17 624 0 629 1.00
SYSTEM /OASB/11.5.10/oracle/data/sys5.dbf 1,439 0 3.37 2.90 561 0 604 1.06
SYSTEM /OASB/11.5.10/oracle/data/sys6.dbf 1,284 0 3.58 3.17 405 0 1,159 0.50
SYSTEM /OASB/11.5.10/oracle/data/sys7.dbf 878 0 3.51 3.70 341 0 2,168 0.28
SYSTEM /OASB/11.5.10/oracle/data/sys8.dbf 26 0 2.31 1.00 37 0 6,633 0.07
SYSTEM /OASB/11.5.10/oracle/data/sys9.dbf 28 0 2.86 1.00 44 0 87 0.46
TEMP /OASB/11.5.10/oracle/data/tmp1.dbf 884 0 3.01 1.63 4,474 1 0  
TEMP /OASB/11.5.10/oracle/data/tmp2.dbf 1,198 0 3.07 1.90 7,238 2 99 7.58
TEMP /OASB/11.5.10/oracle/data/tmp3.dbf 964 0 3.30 1.51 6,814 2 13 3.85
TEMP /OASB/11.5.10/oracle/data/tmp4.dbf 915 0 2.72 3.31 5,137 1 20 5.00

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 989,500 100 2,308,672,770 1,084,605 3,016,065 0 0 1,030,460


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 99 55908 1304628 4040791 73728000 4040791  
E 0 123 72972 1667174 19367113 73728000 19367113  

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
100.00 629,161 11

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 12,000 750 44,139.69 3.63 0.01 100.00 0.00 1,048,576
E 12,000 750 57,593.84 2.17 0.00 100.00 0.00 1,048,576

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,736,919 5,736,919 0 0
64K 128K 11,855 11,855 0 0
128K 256K 1,122 1,122 0 0
256K 512K 594 594 0 0
512K 1024K 196,754 196,754 0 0
1M 2M 422,586 422,586 0 0
2M 4M 22 18 4 0
4M 8M 40 40 0 0
8M 16M 2 2 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 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,500 0.13 792,348.28 13,834.93 98.00 1,354
3,000 0.25 792,348.28 13,714.67 98.00 1,340
6,000 0.50 792,348.28 13,592.51 98.00 1,315
9,000 0.75 792,348.28 13,452.97 98.00 1,293
12,000 1.00 792,348.28 5.45 100.00 1,278
14,400 1.20 792,348.28 5.45 100.00 1,258
16,800 1.40 792,348.28 5.45 100.00 1,233
19,200 1.60 792,348.28 5.45 100.00 1,215
21,600 1.80 792,348.28 5.45 100.00 1,195
24,000 2.00 792,348.28 5.45 100.00 1,157
36,000 3.00 792,348.28 5.45 100.00 820
48,000 4.00 792,348.28 0.00 100.00 0
72,000 6.00 792,348.28 0.00 100.00 0
96,000 8.00 792,348.28 0.00 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,416 0.80 343 13,387 1,490,701 1.00 2,647 1.18 91,906,888
2,720 0.90 627 17,973 1,491,106 1.00 2,242 1.00 91,925,052
3,024 1.00 929 20,712 1,491,108 1.00 2,240 1.00 91,925,463
3,328 1.10 1,185 30,739 1,491,108 1.00 2,240 1.00 91,925,614
3,632 1.20 1,191 31,400 1,491,108 1.00 2,240 1.00 91,925,614
3,936 1.30 1,191 31,400 1,491,108 1.00 2,240 1.00 91,925,614
4,240 1.40 1,191 31,400 1,491,108 1.00 2,240 1.00 91,925,614
4,544 1.50 1,191 31,400 1,491,108 1.00 2,240 1.00 91,925,614
4,848 1.60 1,191 31,400 1,491,108 1.00 2,240 1.00 91,925,614
5,152 1.70 1,191 31,400 1,491,108 1.00 2,240 1.00 91,925,614
5,456 1.80 1,191 31,400 1,491,108 1.00 2,240 1.00 91,925,614
5,760 1.90 1,191 31,400 1,491,108 1.00 2,240 1.00 91,925,614
6,064 2.01 1,191 31,400 1,491,108 1.00 2,240 1.00 91,925,614

Back to Advisory Statistics
Back to Top

 

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

 

Streams Pool Advisory

No data exists for this section of the report.

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
48 0.18 12 327 785 1.00 2,242 1.00 10,425
80 0.29 12 327 785 1.00 2,242 1.00 10,425
112 0.41 12 327 785 1.00 2,242 1.00 10,425
144 0.53 12 327 785 1.00 2,242 1.00 10,425
176 0.65 12 327 785 1.00 2,242 1.00 10,425
208 0.76 12 327 785 1.00 2,242 1.00 10,425
240 0.88 12 327 785 1.00 2,242 1.00 10,425
272 1.00 12 327 785 1.00 2,242 1.00 10,425
304 1.12 12 327 785 1.00 2,242 1.00 10,425
336 1.24 12 327 785 1.00 2,242 1.00 10,425
368 1.35 12 327 785 1.00 2,242 1.00 10,425
400 1.47 12 327 785 1.00 2,242 1.00 10,425
432 1.59 12 327 785 1.00 2,242 1.00 10,425
464 1.71 12 327 785 1.00 2,242 1.00 10,425
496 1.82 12 327 785 1.00 2,242 1.00 10,425
528 1.94 12 327 785 1.00 2,242 1.00 10,425

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 646,435 251 0
undo block 315,326 19 0
undo header 39,576 6 0
1st level bmb 22,677 3 0
file header block 129 1 7
segment header 6,080 1 0
2nd level bmb 264 0 0
extent map 7 0 0
bitmap index block 3 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)
HW-Segment High Water Mark 364,856 364,814 42 64,719 210 3.24
UL-User-defined 70,767 69,899 868 2,869 171 59.46
TX-Transaction (row lock contention) 2,407 1,155 1,252 1,072 92 86.04
TX-Transaction (index contention) 33,294 33,294 0 26,004 45 1.74
KO-Multiple Object Checkpoint (fast object checkpoint) 216 216 0 22 15 689.36
SQ-Sequence Cache 75,919 75,919 0 16,352 6 0.37
TX-Transaction 1,400,337 1,400,378 0 6,727 6 0.89
RO-Multiple Object Reuse (fast object reuse) 288 288 0 32 6 181.63
FB-Format Block 42,590 42,590 0 3,685 3 0.80
TX-Transaction (allocate ITL entry) 1,128 1,128 0 829 3 3.20
DV-Diana Versioning 32,221 32,221 0 158 3 15.96
US-Undo Segment 13,558 13,558 0 52 0 1.85
TQ-Queue table enqueue (TM contention) 292 292 0 121 0 0.72
TQ-Queue table enqueue (DDL contention) 480 480 0 72 0 0.93
TM-DML 2,269,978 2,270,031 0 3 0 22.00
PS-PX Process Reservation 640 312 328 10 0 1.10

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,657.42 1,397,513 2,670 424   0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
14-Oct 18:10 230,257 199,697 664 400 108 0/0 0/0/0/0/0/0
14-Oct 18:00 488,005 235,618 2,670 394 111 0/0 0/0/0/0/0/0
14-Oct 17:50 284,843 247,494 2,504 417 143 0/0 0/0/0/0/0/0
14-Oct 17:40 192,031 186,588 1,900 416 170 0/0 0/0/0/0/0/0
14-Oct 17:30 181,421 283,745 1,901 396 192 0/0 0/0/0/0/0/0
14-Oct 17:20 280,859 244,371 1,261 424 230 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
ASM db client latch 2,527 0.00   0 0  
AWR Alerted Metric Element list 354,577 0.00   0 0  
Consistent RBA 898,843 0.07 0.00 0 0  
FOB s.o list latch 114,002 0.03 0.13 0 0  
In memory undo latch 659,550,927 2.16 0.00 204 1,301,259 0.00
JOX SGA heap latch 1,945,817 0.00   0 0  
JS mem alloc latch 0     0 2 0.00
JS queue state obj latch 21,930 0.00   0 0  
JS slv state obj latch 3 0.00   0 0  
KMG MMAN ready and startup request latch 1,218 0.00   0 0  
KTF sga latch 12 0.00   0 1,231 0.00
KWQMN job cache list latch 6,123 0.18 0.91 0 0  
MQL Tracking Latch 0     0 73 0.00
Memory Management Latch 0     0 1,218 0.00
OS process 21,936 0.00   0 0  
OS process allocation 15,835 0.01 0.00 0 0  
OS process: request allocation 14,577 0.01 0.00 0 0  
PL/SQL warning settings 4,677,400 0.00   0 0  
SGA IO buffer pool latch 50,614 0.00 0.00 0 50,718 0.00
SQL memory manager latch 1 0.00   0 1,209 0.00
SQL memory manager workarea list latch 7,386,182 0.01 0.02 0 0  
Shared B-Tree 131 0.00   0 0  
active checkpoint queue latch 298,220 0.00 0.00 0 2 0.00
active service list 56,351 0.04 0.05 0 2,328 0.00
alert log latch 0     0 2 0.00
begin backup scn array 5,669 0.00   0 0  
cache buffer handles 25,857,250 3.75 0.00 2 0  
cache buffers chains 5,511,042,986 2.16 0.00 235 19,084,877 3.81
cache buffers lru chain 10,900,629 0.70 0.07 7 33,883,374 0.76
cache table scan latch 8,095 0.01 0.00 0 8,095 0.00
channel handle pool latch 437,403 0.08 0.02 0 0  
channel operations parent latch 1,847,151 0.85 0.00 0 0  
checkpoint queue latch 18,192,831 0.02 0.02 0 2,994,449 0.03
client/application info 1,809,691 0.00 0.00 0 0  
commit callback allocation 89,393 0.00 1.00 0 0  
compile environment latch 3,213,233 0.00   0 0  
dictionary lookup 76 0.00   0 0  
dml lock allocation 4,521,148 0.55 0.02 4 0  
dummy allocation 24,664 0.01 0.00 0 0  
enqueue hash chains 10,314,142 0.25 0.01 1 855 1.40
enqueues 5,849,518 0.40 0.02 2 0  
error message lists 185 0.00   0 0  
event group latch 7,285 0.00   0 0  
file cache latch 30,371 0.00 0.00 0 0  
global KZLD latch for mem in SGA 12,195 0.00   0 0  
global ctx hash table latch 24,896 0.00   0 0  
hash table column usage latch 1,906 0.05 0.00 0 16,513,920 0.00
hash table modification latch 133 0.00   0 2 0.00
internal temp table object number allocation latc 3 0.00   0 0  
job workq parent latch 0     0 124 0.00
job_queue_processes free list latch 0     0 2 0.00
job_queue_processes parameter latch 123 0.00   0 0  
kks stats 24,337 0.02 0.00 0 0  
ksuosstats global area 246 0.00   0 0  
ktm global data 166,226 0.00   0 0  
kwqbsn:qsga 131 0.00   0 0  
lgwr LWN SCN 899,951 0.21 0.00 0 0  
library cache 362,690,608 0.62 0.01 82 14,441 0.66
library cache load lock 6,097 1.02 0.00 0 11 0.00
library cache lock 64,012,379 0.15 0.01 3 8 0.00
library cache lock allocation 1,856,706 0.01 0.03 0 0  
library cache pin 224,900,457 0.45 0.01 50 20 0.00
library cache pin allocation 612,160 0.00 0.05 0 0  
list of block allocation 532,431 0.05 0.07 0 0  
loader state object freelist 336,670 0.01 0.00 0 0  
longop free list parent 41 0.00   0 41 0.00
message pool operations parent latch 440,718 0.14 0.01 0 0  
messages 3,444,046 0.09 0.01 0 0  
mostly latch-free SCN 1,051,496 13.82 0.00 0 0  
multiblock read objects 24,246 0.02 0.00 0 2 0.00
ncodef allocation latch 204 0.00   0 0  
object queue header heap 5,246,093 0.02 0.02 0 493,088 0.16
object queue header operation 55,344,563 0.13 0.03 2 0  
object stats modification 430,243 0.07 0.03 0 4 0.00
parallel query alloc buffer 1,848 1.24 0.13 0 0  
parallel query stats 168 6.55 0.09 0 0  
parameter list 37,893 0.00 0.00 0 0  
parameter table allocation management 27,059 0.16 0.65 0 0  
post/wait queue 1,582,601 0.05 0.00 0 516,025 0.05
process allocation 14,618 0.76 1.21 1 7,283 0.03
process group creation 14,577 0.00   0 0  
process queue 1,039 0.38 0.00 0 0  
process queue reference 181,942 0.10 0.00 0 11,902 0.70
qmn task queue latch 524 0.00   0 0  
query server freelists 859 6.87 0.00 0 0  
query server process 8 87.50 1.00 2 8 0.00
redo allocation 6,685,051 11.19 0.02 16 102,609,677 5.48
redo copy 0     0 103,366,114 0.06
redo writing 3,730,170 0.03 0.07 0 0  
resmgr group change latch 866,830 0.00   0 0  
resmgr:actses active list 36,798 0.79 0.99 1 0  
resmgr:actses change group 36,608 0.00   0 0  
resmgr:free threads list 24,661 0.01 0.67 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 137,053,098 0.77 0.01 18 3,748 0.35
rules engine aggregate statistics 51,106 0.03 0.00 0 0  
rules engine evaluation context statistics 0     0 2 0.00
rules engine rule set statistics 153,317 0.02 0.00 0 0  
rules engine rule statistics 51,105 0.00   0 0  
sequence cache 16,829,711 1.08 0.00 1 0  
session allocation 19,473,930 1.22 0.03 10 0  
session idle bit 94,963,788 0.02 0.02 1 0  
session state list latch 73,431 0.26 0.98 0 0  
session switching 15,884 0.01 0.00 0 0  
session timer 2,328 0.00   0 0  
shared pool 7,388,321 0.30 0.04 1 0  
shared pool sim alloc 371 0.00   0 0  
shared pool simulator 1,607,163 0.00 0.04 0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,495,492 0.29 0.02 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 862 0.00   0 0  
temporary table state object allocation 14,348 0.00   0 0  
threshold alerts latch 584 0.00   0 0  
trace latch 53 0.00   0 0  
transaction allocation 131,945 0.00 0.00 0 0  
transaction branch allocation 204 0.00   0 0  
undo global data 1,077,999,874 1.47 0.00 189 6,507 0.12
user lock 48,856 0.03 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 5,511,042,986 118,786,468 373,060 118,594,655 0 0 0
undo global data 1,077,999,874 15,800,410 41,676 15,765,540 0 0 0
In memory undo latch 659,550,927 14,264,342 60,283 14,212,399 0 0 0
library cache 362,690,608 2,239,487 31,220 2,210,329 0 0 0
row cache objects 137,053,098 1,060,935 9,268 1,052,072 0 0 0
library cache pin 224,900,457 1,011,470 15,007 997,394 0 0 0
cache buffer handles 25,857,250 968,869 3,317 965,813 0 0 0
redo allocation 6,685,051 748,340 11,234 738,020 0 0 0
session allocation 19,473,930 238,144 8,052 230,732 0 0 0
sequence cache 16,829,711 182,503 413 182,113 0 0 0
mostly latch-free SCN 1,051,496 145,329 348 145,006 0 0 0
library cache lock 64,012,379 95,119 1,046 94,098 0 0 0
cache buffers lru chain 10,900,629 76,045 5,070 71,211 0 0 0
object queue header operation 55,344,563 73,996 2,585 71,568 0 0 0
enqueue hash chains 10,314,142 25,583 166 25,428 0 0 0
dml lock allocation 4,521,148 25,039 548 24,522 0 0 0
enqueues 5,849,518 23,551 464 23,098 0 0 0
shared pool 7,388,321 22,418 933 21,530 0 0 0
session idle bit 94,963,788 15,955 298 15,669 0 0 0
channel operations parent latch 1,847,151 15,614 17 15,599 0 0 0
sort extent pool 1,495,492 4,270 69 4,203 0 0 0
checkpoint queue latch 18,192,831 3,401 59 3,345 0 0 0
messages 3,444,046 3,226 44 3,186 0 0 0
lgwr LWN SCN 899,951 1,874 5 1,869 0 0 0
redo writing 3,730,170 994 66 935 0 0 0
SQL memory manager workarea list latch 7,386,182 962 23 940 0 0 0
object queue header heap 5,246,093 890 17 875 0 0 0
post/wait queue 1,582,601 757 2 755 0 0 0
message pool operations parent latch 440,718 613 5 608 0 0 0
channel handle pool latch 437,403 338 7 332 0 0 0
resmgr:actses active list 36,798 290 288 8 0 0 0
object stats modification 430,243 284 8 276 0 0 0
list of block allocation 532,431 254 17 240 0 0 0
session state list latch 73,431 189 185 6 0 0 0
library cache lock allocation 1,856,706 152 5 147 0 0 0
process allocation 14,618 111 134 3 0 0 0
shared pool simulator 1,607,163 69 3 66 0 0 0
parameter table allocation management 27,059 43 28 16 0 0 0
FOB s.o list latch 114,002 32 4 28 0 0 0
parallel query alloc buffer 1,848 23 3 20 0 0 0
active service list 56,351 21 1 20 0 0 0
library cache pin allocation 612,160 19 1 18 0 0 0
KWQMN job cache list latch 6,123 11 10 1 0 0 0
parallel query stats 168 11 1 10 0 0 0
query server process 8 7 7 0 0 0 0
resmgr:free threads list 24,661 3 2 1 0 0 0
commit callback allocation 89,393 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
FOB s.o list latch ksfd_allfob 0 3 4
FOB s.o list latch ksfd_fobd 0 1 0
In memory undo latch kturbk 0 45,647 48,395
In memory undo latch ktiFlush: child 0 10,833 3,946
In memory undo latch kticmt: child 0 2,389 903
In memory undo latch ktichg: child 0 906 6,648
In memory undo latch ktiTxnPoolFree 0 421 2
In memory undo latch ktbgfc 0 51 388
In memory undo latch ktiBRacquire 0 34 0
In memory undo latch ktuswr 0 1 0
KWQMN job cache list latch kwqmnuji: update job item 0 10 4
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 12 4
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 11 19
active service list ksws_event: ksws event 0 1 0
cache buffer handles kcbzgs 0 1,924 1,815
cache buffer handles kcbzfs 0 1,393 1,502
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 549,721 651,303
cache buffers chains kcbgtcr: kslbegin excl 0 328,043 276,691
cache buffers chains kcbgtcr: fast path 0 310,486 10,685
cache buffers chains kcbrls: kslbegin 0 284,937 341,570
cache buffers chains kcbchg: kslbegin: call CR func 0 94,766 340,365
cache buffers chains kcbzgb: scan from tail. nowait 0 45,462 0
cache buffers chains kcbget: pin buffer 0 20,383 3,957
cache buffers chains kcbgcur: kslbegin 0 20,271 8,306
cache buffers chains kcbzwb 0 5,265 2,439
cache buffers chains kcbget: exchange rls 0 2,482 1,445
cache buffers chains kcbget: exchange 0 2,012 2,784
cache buffers chains kcbcge 0 315 3,481
cache buffers chains kcb_is_private 0 127 264
cache buffers chains kcbnlc 0 101 381
cache buffers chains kcbso1: set no access 0 42 66
cache buffers chains kcbgtcr: kslbegin shared 0 33 13
cache buffers chains kcbesc: escalate 0 29 4
cache buffers chains kcbzib: finish free bufs 0 20 36
cache buffers chains kcbnew: new latch again 0 13 2
cache buffers chains kcb_pre_apply: kcbhq61 0 8 660
cache buffers chains kcb_post_apply: kcbhq62 0 7 22
cache buffers chains kcbbic2 0 6 1
cache buffers chains kcb_post_apply: kcbhq63 0 1 7
cache buffers chains kcbbxsv 0 1 1
cache buffers lru chain kcbzgws 0 3,292 0
cache buffers lru chain kcbzgb: posted for free bufs 0 647 2,040
cache buffers lru chain kcbzswcu 0 427 392
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 298 0
cache buffers lru chain kcbo_link_q 0 236 37
cache buffers lru chain kcbbxsv: move to being written 0 75 1,124
cache buffers lru chain kcbbic2 0 36 1,080
cache buffers lru chain kcbbwlru 0 32 221
cache buffers lru chain kcbo_ivd_proc 0 21 259
cache buffers lru chain kcbzar: KSLNBEGIN 0 1 0
channel handle pool latch ksrchconnect() 0 6 3
channel handle pool latch ksrchdelete() 0 2 9
channel operations parent latch ksrchdelete() 0 20 3
channel operations parent latch ksrapublish() 0 14 0
channel operations parent latch ksrchconnect() 0 6 6
channel operations parent latch ksrmfree() 0 2 10
channel operations parent latch ksrwait() 0 2 20
channel operations parent latch ksrsconsume() 0 1 8
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 42 1
checkpoint queue latch kcbswcu: Switch buffers 0 15 15
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 2 36
commit callback allocation ktcccod 0 1 0
dml lock allocation ktaiam 0 393 383
dml lock allocation ktaidm 0 155 165
enqueue hash chains ksqgtl3 0 75 77
enqueue hash chains ksqrcl 0 53 60
enqueue hash chains ksqcmi: kslgpl 0 18 9
enqueue hash chains ksqcmi: if deadlock detected 0 12 1
enqueue hash chains ksqcmi: get hash chain latch after wait 0 7 19
enqueue hash chains ksqcnl 0 1 0
enqueues ksqies 0 197 283
enqueues ksqgel: create enqueue 0 166 123
enqueues ksqdel 0 97 57
enqueues ksqgtl2 0 3 0
lgwr LWN SCN kcs023 0 68 0
library cache kglpnp: child 0 12,344 14,294
library cache kglpndl: child: after processing 0 11,493 1,482
library cache kglobpn: child: 0 2,438 4,550
library cache kglpndl: child: before processing 0 2,115 8,844
library cache kglLockCursor 0 854 985
library cache kglScanDependency 0 415 0
library cache kglpin 0 358 154
library cache kglhdgn: child: 0 307 420
library cache kgldte: child 0 0 302 394
library cache kgldti: 2child 0 46 16
library cache kglic 0 34 0
library cache kglhdgc: child: 0 17 8
library cache kglivl: child 0 8 0
library cache kglhdiv: child 0 7 0
library cache kglobld 0 4 1
library cache kgldrp: child 0 2 0
library cache kgldtld: 2child 0 2 0
library cache kglukp: child 0 2 1
library cache kglupd: child 0 2 0
library cache kglget: unpin heap 0 0 1 5
library cache kglini: child 0 1 0
library cache kglpin: child: KGLMX 0 1 0
library cache kglrtl 0 1 0
library cache lock kgllkdl: child: cleanup 0 639 568
library cache lock kgllkal: child: multiinstance 0 407 478
library cache lock kgllkdl: child: no lock handle 0 189 56
library cache lock allocation kgllkget 0 5 4
library cache pin kglpndl 0 7,306 5,625
library cache pin kglpnp: child 0 6,709 7,527
library cache pin kglpnal: child: alloc space 0 992 1,855
library cache pin allocation kglpnget 0 1 1
list of block allocation ktlabl 0 15 16
list of block allocation ktlbbl 0 2 1
message pool operations parent latch ksrmalloc() 0 6 2
message pool operations parent latch ksrmfree() 0 1 5
messages ksaamb: after wakeup 0 40 21
messages ksarcv 0 3 23
messages ksarcv: after wait 0 1 0
mostly latch-free SCN kcslcu3 0 280 353
mostly latch-free SCN kcs024 0 5 0
object queue header heap kcbo_link_q:reget 0 10 7
object queue header heap kcbw_link_q:alloc 0 5 10
object queue header heap kcbw_unlink_q 0 2 0
object queue header operation kcbo_ivbo 0 5,705 1,676
object queue header operation kcbw_unlink_q 0 782 1,131
object queue header operation kcbw_link_q 0 551 554
object queue header operation kcbo_switch_cq 0 76 630
object queue header operation kcbo_write_q 0 48 0
object queue header operation kcbo_service_ockpt 0 43 0
object queue header operation kcbo_switch_q_bg 0 35 286
object queue header operation kcbo_link_q:reget 0 21 82
object queue header operation kcbo_swap_buf 0 21 110
object queue header operation kcbo_swap_buf_bg 0 10 2,167
object queue header operation kcbo_switch_mq_bg 0 9 899
object stats modification ksoslinelm 0 8 7
parallel query alloc buffer kxfpbfre 0 2 2
parallel query alloc buffer kxfpbalo 0 1 1
parallel query stats kxfprst: KSLBEGIN:1 0 1 1
parameter table allocation management ksp_param_table_free 0 28 27
post/wait queue ksliwat:add:nowait 0 1 0
post/wait queue ksliwat:remove 0 1 0
process allocation ksucrp 0 100 0
process allocation ksuapc 0 25 55
process allocation ksufap: active procs 0 6 6
process allocation ksudlp 0 1 71
query server process kxfpg1srv 0 7 7
redo allocation kcrfw_redo_gen: redo allocation 1 0 7,855 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 2,008 8,959
redo allocation kcrfw_redo_gen: redo allocation 2 0 909 0
redo allocation kcrfw_redo_write: before write 0 243 1,087
redo allocation kcrfw_redo_write: more space 0 219 1,188
redo writing kcrfw_post: rba scn pair 0 32 0
redo writing kcrfw_post: after write 0 19 3
redo writing kcrfws: in loop 0 7 7
redo writing kcrfwcr 0 4 54
redo writing kcrfw_cal_target_rba 0 3 1
redo writing kcrfwfl: stop redo 0 1 1
resmgr:actses active list kgskchclass 0 287 105
resmgr:actses active list kgskactladd 0 1 151
resmgr:free threads list kgskthrcreate 0 1 2
resmgr:free threads list kgskthrsod 0 1 0
row cache objects kqreqd: reget 0 6,150 524
row cache objects kqrpre: find obj 0 2,040 6,224
row cache objects kqreqd 0 971 2,473
row cache objects kqrso 0 80 28
row cache objects kqrpiv 0 7 15
row cache objects kqrpup 0 1 0
sequence cache kdnssd 0 331 27
sequence cache kdnnxt: cached seq 0 46 16
sequence cache kdnss 0 36 368
session allocation ksuxds: KSUSFCLC not set 0 3,790 38
session allocation ksuprc 0 1,255 1,536
session allocation ksucri 0 1,073 2,843
session allocation ksuxds: not user session 0 938 1,421
session allocation ksudlc 0 781 2,132
session allocation ksudlp 0 160 10
session allocation ksursi 0 10 19
session allocation kxfpqidqr 0 8 17
session allocation kxfprdp 0 7 3
session allocation ksucrp 0 3 10
session allocation ksuxds: KSUSFCLC set 0 3 0
session allocation ksusroll 0 2 1
session idle bit ksupuc: set busy 0 277 115
session idle bit ksupuc: clear busy 0 135 300
session idle bit ksuxds 0 26 23
session state list latch kpseqd 0 179 0
session state list latch kpscad 0 5 1
session state list latch kpscdl 0 1 57
shared pool kghalo 0 535 312
shared pool kghfrunp: clatch: nowait 0 279 0
shared pool kghupr1 0 232 397
shared pool kghfre 0 131 191
shared pool kghalp 0 19 29
shared pool kghfrunp: clatch: wait 0 17 10
shared pool kghfrunp: alloc: wait 0 13 0
shared pool kghasp 0 1 4
shared pool kghfrh 0 1 1
shared pool simulator kglsim_unpin_simhp 0 3 3
sort extent pool ktstdt: dealloc sort extent 0 51 6
sort extent pool ktstdt: return extent 0 6 5
sort extent pool ktstaddextent1 0 4 1
sort extent pool ktstcrtobj 0 3 0
sort extent pool ktstsmonmsg 0 3 66
sort extent pool ktstallobj1 0 2 4
undo global data kturimugur: child 0 34,683 28,427
undo global data ktudba: KSLBEGIN 0 4,167 13,071
undo global data ktusmasp: ktugd_tuux 0 2,340 24
undo global data ktumof: KSLBEGIN 0 111 1
undo global data ktudnx:child 0 106 57
undo global data ktucof: at start 0 93 0
undo global data ktufrbs: child 0 90 68
undo global data ktusmupst: KSLBEGIN 0 46 0
undo global data ktubnd:child 0 38 14
undo global data ktusm_begin_fu 0 1 0
undo global data ktuswr: other segs 0 1 0

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
GL APPS_TS_TX_IDX GL_CODE_COMBINATIONS_U1   INDEX 50,607,472 2.19
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 43,285,120 1.87
APPLSYS APPS_TS_TX_IDX FND_GRANTS_N9   INDEX 40,490,160 1.75
QP APPS_TS_TX_IDX QP_LIST_LINES_N5   INDEX 40,449,568 1.75
INV APPS_TS_TX_IDX MTL_SYSTEM_ITEMS_B_N1   INDEX 28,285,568 1.22

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 379,859 25.95
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 37,586 2.57
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 14,175 0.97
AR APPS_ASSM_DATA RA_CUST_TRX_LINE_GL_DIST_ALL   TABLE 13,208 0.90
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 12,746 0.87

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 5,483 21.20
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 2,005 7.75
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,755 6.78
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_PK   INDEX 1,696 6.56
APPLSYS APPS_TS_TX_DATA FND_CONCURRENT_REQUESTS   TABLE 1,516 5.86

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
SYS SYSTEM COL$   TABLE 803 93.92
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 21 2.46
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N1   INDEX 8 0.94
GL APPS_ASSM_IDX GL_INTERFACE_N4   INDEX 4 0.47
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 4 0.47

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 117,456 26.65
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 94,067 21.34
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 24,728 5.61
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_N2   INDEX 20,476 4.65
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 19,944 4.53

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 5 0.00 0   2 1
dc_constraints 648 47.07 0   648 169
dc_global_oids 7,970,878 0.00 0   0 69
dc_histogram_data 7,119 3.24 0   0 1,478
dc_histogram_defs 470,408 1.81 0   4,042 15,101
dc_object_grants 151,604 0.03 0   0 469
dc_object_ids 13,315,950 0.01 0   57 3,892
dc_objects 237,702 0.37 0   824 2,482
dc_profiles 12,254 0.00 0   0 1
dc_rollback_segments 36,454 0.02 0   21 426
dc_segments 386,764 0.23 0   21,434 4,749
dc_sequences 73,039 0.04 0   73,039 147
dc_table_scns 67,643 0.01 0   0 8
dc_tablespace_quotas 21,281 0.09 0   254 56
dc_tablespaces 6,250,159 0.00 0   0 22
dc_usernames 589,803 0.00 0   0 87
dc_users 17,280,514 0.00 0   0 104
kqlsubheap_object 8 25.00 0   0 2
outstanding_alerts 257 0.00 0   1 41


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 773,154 0.01 43,065,231 -0.03 2 0
CLUSTER 61 0.00 151 0.00 0 0
INDEX 15,820 0.35 16,426 0.57 9 0
JAVA DATA 594 0.00 0   0 0
PIPE 56,759 2.42 79,428 1.72 0 0
SQL AREA 4,824 96.46 116,961,263 -0.08 4,596 316
TABLE/PROCEDURE 457,503 0.13 59,018,826 -0.06 388 0
TRIGGER 31,652 0.05 1,413,838 0.00 1 0


Back to Top

 

Memory Statistics

Back to Top

Process Memory Summary

  Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc
B Other 35,551.48   10.51 6.37 37 37 3,382 3,382
  SQL 3,416.64 1,734.06 1.01 0.65 4 21 3,376 3,375
  Freeable 2,862.63 0.00 1.05 0.60 9   2,724 2,724
  PL/SQL 2,272.80 211.40 0.67 0.87 3 3 3,382 3,382
  JAVA 273.08 271.74 2.28 0.29 5 7 120 120
E Other 46,264.70   13.79 7.87 41 41 3,355 3,355
  SQL 4,262.58 2,220.52 1.27 0.73 4 21 3,349 3,348
  Freeable 4,007.19 0.00 1.36 0.75 9   2,948 2,948
  PL/SQL 2,815.16 239.28 0.84 0.94 3 3 3,355 3,355
  JAVA 273.07 271.74 2.28 0.29 5 7 120 120

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 8,388,608,000  
Fixed Size 2,065,832  
Redo Buffers 31,473,664  
Variable Size 3,422,567,000  

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 239.87 239.87 0.00
java joxlod exec hp 15.51 15.51 0.00
shared ASH buffers 50.00 50.00 0.00
shared CCursor 41.65 54.23 30.19
shared KGLS heap 48.47   -100.00
shared KTI-UNDO 53.19 53.19 0.00
shared PCursor   33.34  
shared PL/SQL DIANA 43.59 41.92 -3.84
shared PL/SQL MPCODE 74.87 76.75 2.52
shared db_block_hash_buckets 240.00 240.00 0.00
shared event statistics per sess 63.28 63.28 0.00
shared free memory 624.03 58.55 -90.62
shared library cache 840.57 1,087.19 29.34
shared parameter table block 60.46 60.69 0.38
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 368.85 691.20 87.39
shared trace buffer 52.63 53.44 1.54
  buffer_cache 8,000.00 8,000.00 0.00
  fixed_sga 1.97 1.97 0.00
  log_buffer 30.02 30.02 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

 

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Resource Limit Stats

Resource Name Current Utilization Maximum Utilization Initial Allocation Limit
processes 3,355 3,421 3600 3600


Back to Top

 

init.ora Parameters

Parameter Name Begin value End value (if different)
O7_DICTIONARY_ACCESSIBILITY FALSE   
_b_tree_bitmap_plans FALSE   
_db_block_hash_latches 1048576   
_fast_full_scan_enabled FALSE   
_kks_use_mutex_pin TRUE   
_like_with_bind_as_equality TRUE   
_sort_elimination_cost_ratio 5   
_spin_count 20000   
_sqlexec_progression_cost 2147483647   
_swrf_mmon_dbfus FALSE   
_swrf_mmon_flush FALSE   
_system_trig_enabled TRUE   
background_dump_dest /data1/app/admin/VIS/bdump   
compatible 10.2.0.3   
control_files /OASB/11.5.10/oracle/data/cntrl01.dbf, /OASB/11.5.10/oracle/data/cntrl02.dbf, /OASB/11.5.10/oracle/data/cntrl03.dbf   
core_dump_dest /data1/app/admin/VIS/cdump   
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 8388608000   
db_files 130   
db_name VIS   
db_writer_processes 1   
dml_locks 10000   
java_pool_size 268435456   
job_queue_processes 10   
lock_sga TRUE   
log_buffer 30519296   
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   
optimizer_secure_view_merging FALSE   
parallel_max_servers 8   
pga_aggregate_target 12582912000   
plsql_optimize_level 2   
processes 3600   
replication_dependency_tracking FALSE   
session_cached_cursors 500   
sessions 7200   
shared_pool_reserved_size 41943040   
shared_pool_size 3154116608   
timed_statistics TRUE   
trace_enabled FALSE   
undo_management AUTO   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /data1/app/admin/VIS/udump   
utl_file_dir /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report