WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
VIS 127695557 VIS 1 10.2.0.3.0 NO hpdb1

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 56 29-Dec-07 07:20:58 3769 164.4
End Snap: 57 29-Dec-07 08:21:06 3736 172.4
Elapsed:   60.12 (mins)    
DB Time:   559.43 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 16,272M 16,272M Std Block Size: 8K
Shared Pool Size: 3,008M 3,008M Log Buffer: 16,640K

Load Profile

  Per Second Per Transaction
Redo size: 9,116,279.74 34,132.18
Logical reads: 495,659.51 1,855.79
Block changes: 52,311.09 195.86
Physical reads: 135.99 0.51
Physical writes: 1,031.89 3.86
User calls: 9,804.05 36.71
Parses: 3,637.28 13.62
Hard parses: 2.04 0.01
Sorts: 2,819.52 10.56
Logons: 2.28 0.01
Executes: 26,269.99 98.36
Transactions: 267.09  

% Blocks changed per Read: 10.55 Recursive Call %: 82.72
Rollback per transaction %: 19.33 Rows per Sort: 12.24

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95 Redo NoWait %: 100.00
Buffer Hit %: 99.97 In-memory Sort %: 100.00
Library Hit %: 100.01 Soft Parse %: 99.94
Execute to Parse %: 86.15 Latch Hit %: 98.69
Parse CPU to Parse Elapsd %: 86.67 % Non-Parse CPU: 97.51

Shared Pool Statistics

  Begin End
Memory Usage %: 62.35 81.95
% SQL with executions>1: 83.93 84.46
% Memory for SQL w/exec>1: 64.23 64.47

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   31,045   92.5  
db file sequential read 319,443 1,426 4 4.2 User I/O
log file parallel write 743,335 478 1 1.4 System I/O
log file sync 361,742 422 1 1.3 Commit
SQL*Net more data from client 1,493,651 387 0 1.2 Network

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
DB CPU 31,045.30 92.49
sql execute elapsed time 30,051.58 89.53
PL/SQL execution elapsed time 6,215.81 18.52
inbound PL/SQL rpc elapsed time 5,107.61 15.22
Java execution elapsed time 1,309.64 3.90
parse time elapsed 942.83 2.81
hard parse elapsed time 447.91 1.33
repeated bind elapsed time 61.13 0.18
sequence load elapsed time 15.20 0.05
connection management call elapsed time 13.44 0.04
PL/SQL compilation elapsed time 9.15 0.03
hard parse (sharing criteria) elapsed time 6.43 0.02
failed parse elapsed time 1.96 0.01
hard parse (bind mismatch) elapsed time 1.43 0.00
DB time 33,565.60  
background elapsed time 1,619.12  
background cpu time 726.85  

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 386,323 0.00 1,621 4 0.40
System I/O 865,539 0.00 616 1 0.90
Application 55,126 0.23 468 8 0.06
Network 40,026,336 0.00 432 0 41.54
Commit 361,742 0.00 422 1 0.38
Concurrency 3,073,286 0.11 345 0 3.19
Other 131,406 38.67 75 1 0.14
Configuration 5,396 0.00 2 0 0.01

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 319,443 0.00 1,426 4 0.33
log file parallel write 743,335 0.00 478 1 0.77
log file sync 361,742 0.00 422 1 0.38
SQL*Net more data from client 1,493,651 0.00 387 0 1.55
enq: TM - contention 112 78.57 314 2799 0.00
enq: TX - index contention 50,747 0.00 175 3 0.05
db file parallel write 118,907 0.00 132 1 0.12
db file scattered read 20,337 0.00 121 6 0.02
enq: UL - contention 2,564 1.21 112 44 0.00
read by other session 44,307 0.00 73 2 0.05
cursor: pin S wait on X 3,577 94.10 63 18 0.00
latch: cache buffers chains 2,212,868 0.00 41 0 2.30
PX Deq Credit: send blkd 22,551 0.00 36 2 0.02
buffer busy waits 787,731 0.00 34 0 0.82
SQL*Net more data to client 1,357,298 0.00 29 0 1.41
enq: TX - row lock contention 308 1.95 25 81 0.00
library cache load lock 792 0.00 23 29 0.00
SQL*Net message to client 37,175,387 0.00 16 0 38.58
rdbms ipc reply 9 66.67 14 1560 0.00
kksfbc child completion 218 86.24 11 48 0.00
SQL*Net break/reset to client 52,110 0.00 10 0 0.05
enq: RO - fast object reuse 32 0.00 8 240 0.00
os thread startup 76 0.00 5 70 0.00
wait list latch free 213 0.00 4 21 0.00
PX Deq: Signal ACK 374 21.39 4 10 0.00
control file sequential read 1,567 0.00 4 2 0.00
control file parallel write 1,730 0.00 2 1 0.00
latch: library cache 3,379 0.00 2 0 0.00
enq: TX - contention 2,973 0.00 2 1 0.00
enq: HW - contention 2,502 0.00 1 0 0.00
latch: object queue header operation 19,584 0.00 1 0 0.02
local write wait 1,143 0.00 1 1 0.00
latch free 1,891 0.00 1 1 0.00
latch: In memory undo latch 9,485 0.00 1 0 0.01
enq: DV - contention 164 0.00 1 4 0.00
LGWR wait for redo copy 25,226 0.00 1 0 0.03
enq: SQ - contention 2,769 0.00 0 0 0.00
latch: cache buffers lru chain 137 0.00 0 3 0.00
row cache lock 1,383 0.00 0 0 0.00
buffer deadlock 49,675 99.28 0 0 0.05
latch: library cache pin 805 0.00 0 0 0.00
latch: undo global data 2,610 0.00 0 0 0.00
enq: FB - contention 692 0.00 0 0 0.00
library cache pin 1,537 0.00 0 0 0.00
latch: redo allocation 1,057 0.00 0 0 0.00
latch: session allocation 617 0.00 0 0 0.00
latch: row cache objects 287 0.00 0 0 0.00
latch: cache buffer handles 147 0.00 0 0 0.00
library cache lock 6 0.00 0 8 0.00
cursor: pin S 1,744 0.00 0 0 0.00
latch: library cache lock 96 0.00 0 0 0.00
write complete waits 5 0.00 0 8 0.00
reliable message 36 0.00 0 1 0.00
enq: TX - allocate ITL entry 47 0.00 0 1 0.00
latch: object queue header heap 26 0.00 0 1 0.00
direct path read 608 0.00 0 0 0.00
latch: shared pool 98 0.00 0 0 0.00
latch: messages 101 0.00 0 0 0.00
latch: redo writing 73 0.00 0 0 0.00
enq: PS - contention 41 0.00 0 0 0.00
latch: checkpoint queue latch 12 0.00 0 1 0.00
PX qref latch 1,277 95.54 0 0 0.00
enq: US - contention 1 0.00 0 3 0.00
latch: parallel query alloc buffer 14 0.00 0 0 0.00
cursor: mutex S 142 0.00 0 0 0.00
latch: enqueue hash chains 15 0.00 0 0 0.00
cursor: mutex X 277 0.00 0 0 0.00
direct path write 441 0.00 0 0 0.00
direct path write temp 38 0.00 0 0 0.00
direct path read temp 6 0.00 0 0 0.00
cursor: pin X 1 0.00 0 0 0.00
SQL*Net message from client 37,175,381 0.00 7,343,850 198 38.58
pipe get 21,693 20.79 21,113 973 0.02
Streams AQ: waiting for messages in the queue 2,386 100.00 11,688 4898 0.00
Streams AQ: qmn slave idle wait 1,938 0.00 10,540 5439 0.00
PX Idle Wait 3,395 77.29 5,563 1639 0.00
Streams AQ: qmn coordinator idle wait 1,657 31.02 3,513 2120 0.00
Streams AQ: waiting for time management or cleanup tasks 2,329 38.60 3,504 1505 0.00
PL/SQL lock timer 267 99.63 2,935 10991 0.00
jobq slave wait 705 91.63 2,022 2868 0.00
PX Deq: Execution Msg 12,136 0.00 107 9 0.01
PX Deq: Execute Reply 4,905 0.00 4 1 0.01
PX Deq Credit: need buffer 3,329 0.00 4 1 0.00
PX Deq: Msg Fragment 9,211 0.00 3 0 0.01
PX Deq: Table Q Normal 6,349 0.00 2 0 0.01
PX Deq: Join ACK 597 0.00 0 0 0.00
PX Deq: Parse Reply 385 0.00 0 1 0.00
class slave wait 1 0.00 0 5 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 743,326 0.00 478 1 0.77
db file parallel write 118,900 0.00 132 1 0.12
os thread startup 60 0.00 4 71 0.00
control file sequential read 821 0.00 3 4 0.00
control file parallel write 1,730 0.00 2 1 0.00
events in waitclass Other 37,098 0.00 2 0 0.04
db file sequential read 46 0.00 0 6 0.00
db file scattered read 2 0.00 0 20 0.00
direct path read 608 0.00 0 0 0.00
latch: redo writing 73 0.00 0 0 0.00
latch: cache buffers chains 27 0.00 0 0 0.00
log file sync 2 0.00 0 2 0.00
latch: library cache pin 1 0.00 0 1 0.00
buffer busy waits 9 0.00 0 0 0.00
direct path write 333 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
rdbms ipc message 2,076,251 0.53 37,016 18 2.15
Streams AQ: qmn slave idle wait 1,938 0.00 10,540 5439 0.00
Streams AQ: qmn coordinator idle wait 1,657 31.02 3,513 2120 0.00
Streams AQ: waiting for time management or cleanup tasks 2,329 38.60 3,504 1505 0.00
smon timer 85,885 0.00 3,491 41 0.09
pmon timer 1,370 86.93 3,463 2528 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
AVG_BUSY_TIME 142,119
AVG_IDLE_TIME 218,330
AVG_IOWAIT_TIME 7,024
AVG_SYS_TIME 8,423
AVG_USER_TIME 133,586
BUSY_TIME 3,413,689
IDLE_TIME 5,242,955
IOWAIT_TIME 171,104
SYS_TIME 204,985
USER_TIME 3,208,704
LOAD 0
OS_CPU_WAIT_TIME 76,609,000
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 1,204,224
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES ###############
NUM_CPUS 24
NUM_CPU_SOCKETS 24

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
SYS$USERS 33,569.30 31,048.70 490,255 1,785,739,588
SYS$BACKGROUND 0.00 0.00 677 2,499,189
VIS 0.00 0.00 0 0

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
SYS$USERS 385318 162035 3073177 34064 0 0 40015000 43156
SYS$BACKGROUND 991 36 98 425 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
3,848 3,847 8 481.05 11.47 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
2,179 2,179 10 217.93 6.49 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,459 1,471 12 121.57 4.35 1g4jfpxpupdt6 OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,301 1,300 296 4.39 3.87 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,088 1,073 16 67.98 3.24 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
723 709 106,886 0.01 2.15 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
526 526 984 0.53 1.57 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
524 522 110,188 0.00 1.56 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
497 482 78,281 0.01 1.48 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
490 465 55,040 0.01 1.46 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
466 461 61,304 0.01 1.39 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
455 447 55,038 0.01 1.35 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
453 430 5,000 0.09 1.35 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
436 434 11 39.62 1.30 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
418 417 1,008 0.42 1.25 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
410 400 55,040 0.01 1.22 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
381 368 166,808 0.00 1.13 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
380 378 8 47.55 1.13 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
368 355 166,806 0.00 1.10 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
365 194 10,000 0.04 1.09 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
355 355 260,426 0.00 1.06 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
343 337 4,215 0.08 1.02 a957tvxz9w038 icx.por.req.server.RequisitionAM BEGIN :1 := por_util_pkg.inter...

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
3,847 3,848 8 480.84 11.47 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
2,179 2,179 10 217.93 6.49 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,471 1,459 12 122.55 4.35 1g4jfpxpupdt6 OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,300 1,301 296 4.39 3.87 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,073 1,088 16 67.09 3.24 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
709 723 106,886 0.01 2.15 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
526 526 984 0.53 1.57 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
522 524 110,188 0.00 1.56 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
482 497 78,281 0.01 1.48 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
465 490 55,040 0.01 1.46 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
461 466 61,304 0.01 1.39 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
447 455 55,038 0.01 1.35 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
434 436 11 39.50 1.30 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
430 453 5,000 0.09 1.35 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
417 418 1,008 0.41 1.25 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
400 410 55,040 0.01 1.22 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
378 380 8 47.22 1.13 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
368 381 166,808 0.00 1.13 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
355 355 260,426 0.00 1.06 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
355 368 166,806 0.00 1.10 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
337 343 4,215 0.08 1.02 a957tvxz9w038 icx.por.req.server.RequisitionAM BEGIN :1 := por_util_pkg.inter...
194 365 10,000 0.02 1.09 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...

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
276,879,733 8 34,609,966.63 15.48 3846.73 3848.41 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
170,415,893 10 17,041,589.30 9.53 2179.31 2179.31 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
134,580,785 12 11,215,065.42 7.53 1470.64 1458.84 1g4jfpxpupdt6 OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
113,081,924 16 7,067,620.25 6.32 1073.43 1087.73 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
81,840,784 984 83,171.53 4.58 525.77 526.13 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
48,521,318 11 4,411,028.91 2.71 434.47 435.78 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
46,128,592 296 155,839.84 2.58 1300.21 1300.50 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
45,778,385 61 750,465.33 2.56 272.76 272.77 3n8tvc1tsqua0 WSHINTERFACES SELECT DISTINCT WTS.STOP_ID FR...
37,670,670 55,040 684.42 2.11 464.79 489.73 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
36,855,937 5,000 7,371.19 2.06 429.72 452.95 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
35,537,179 11 3,230,652.64 1.99 273.21 273.21 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
34,622,309 1,390,918 24.89 1.94 279.15 280.99 66tmsr3446uqn OEXOETEL SELECT WIAS.ACTIVITY_STATUS, ...
34,379,840 55,040 624.63 1.92 400.17 409.84 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
34,299,076 8 4,287,384.50 1.92 261.73 261.73 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
31,946,456 155,046 206.05 1.79 215.28 215.30 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
31,901,063 166,808 191.24 1.78 367.73 380.83 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
31,898,347 166,806 191.23 1.78 354.67 367.66 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
30,827,266 61,304 502.86 1.72 461.06 465.95 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
27,389,000 8 3,423,625.00 1.53 238.48 238.48 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
26,383,807 10,000 2,638.38 1.48 193.59 364.57 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
25,144,735 55,038 456.86 1.41 446.52 454.77 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
21,647,871 12,017 1,801.44 1.21 134.56 144.39 by2f4fw8tac6r ARXTWMAI UPDATE RA_CUST_TRX_LINE_GL_DIS...
21,579,493 6,344,528 3.40 1.21 170.56 172.62 c4y7jp0q2awbf ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
21,295,354 106,886 199.23 1.19 709.00 722.94 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
19,692,517 143,773 136.97 1.10 291.38 291.47 bcym7s1bp0wxs OEXOETEL SELECT WIA.NAME FROM WF_ITEM_A...
18,523,046 8 2,315,380.75 1.04 377.79 380.39 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
54,436 10,000 5.44 11.10 193.59 364.57 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
29,924 15,147 1.98 6.10 158.08 269.51 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
28,394 119,997 0.24 5.79 174.17 297.96 5qtxtsar19v4k PYUSLV insert into pay_run_result_val...
9,406 143,875 0.07 1.92 268.97 300.59 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
2,280 12 190.00 0.46 1470.64 1458.84 1g4jfpxpupdt6 OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
863 166,810 0.01 0.18 90.45 92.84 25bkagv1j2xf7 INVTTMTX INSERT INTO MTL_MATERIAL_TRAN...
668 296 2.26 0.14 1300.21 1300.50 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
661 8 82.63 0.13 3.72 5.61 6djyj1t4djs12 RAXMTR select /*+ parallel(t, 16) par...
570 8 71.25 0.12 3846.73 3848.41 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
482 61,304 0.01 0.10 461.06 465.95 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...

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
6,344,528 2,547,221 0.40 0.00 0.00 c4y7jp0q2awbf ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
5,150,821 4,174,989 0.81 0.00 0.00 6cjfxb1c4kx16 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_ID, APP...
2,116,200 2,116,119 1.00 0.00 0.00 bc7t6t6jfx2n7 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT VERSION FROM FND_CACHE_...
1,944,127 1,943,939 1.00 0.00 0.00 9dvfguzd15kpv JDBC Thin Client SELECT VALUE FROM V$NLS_PARAME...
1,390,918 720,158 0.52 0.00 0.00 66tmsr3446uqn OEXOETEL SELECT WIAS.ACTIVITY_STATUS, ...
545,420 264,406 0.48 0.00 0.00 4g5vzcyf68n9w ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
419,119 419,117 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
353,639 353,640 1.00 0.00 0.00 0w785m9gmw41a ? @blade1.ebs.hp.com (TNS V1-V3) SELECT USERENV('SESSIONID') FR...
352,701 206,708 0.59 0.00 0.00 5as61q63aqmts ? @blade1.ebs.hp.com (TNS V1-V3) SELECT A.APPLICATION_SHORT_NAM...
352,701 188,531 0.53 0.00 0.00 bvyqm6268u2as ? @blade1.ebs.hp.com (TNS V1-V3) SELECT NODE_NAME FROM FND_NODE...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
422,061 5,150,821 3.22 6cjfxb1c4kx16 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_ID, APP...
419,112 419,119 3.19 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
390,250 6,344,528 2.97 c4y7jp0q2awbf ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
260,679 260,677 1.99 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
260,426 260,426 1.98 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
211,975 353,639 1.62 0w785m9gmw41a ? @blade1.ebs.hp.com (TNS V1-V3) SELECT USERENV('SESSIONID') FR...
211,028 352,700 1.61 29x3dahwzdj8b ? @blade1.ebs.hp.com (TNS V1-V3) SELECT U.USER_NAME, NVL(U.EMP...
211,028 352,701 1.61 5as61q63aqmts ? @blade1.ebs.hp.com (TNS V1-V3) SELECT A.APPLICATION_SHORT_NAM...
211,028 352,686 1.61 95pbs94n69z3d ? @blade1.ebs.hp.com (TNS V1-V3) SELECT NVL(MULTI_ORG_FLAG, 'N...
211,027 2,116,200 1.61 bc7t6t6jfx2n7 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT VERSION FROM FND_CACHE_...
211,025 352,701 1.61 bvyqm6268u2as ? @blade1.ebs.hp.com (TNS V1-V3) SELECT NODE_NAME FROM FND_NODE...
211,025 211,028 1.61 fhqzxap2n0ybj ? @blade1.ebs.hp.com (TNS V1-V3) select NAME from HR_OPERATING_...
203,143 203,144 1.55 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
166,810 166,810 1.27 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
143,875 143,875 1.10 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
11,605,288 8 0.37 b3an778qn1q49 RAXMTR select /*+ parallel(t, 16) par...
9,221,664 8 0.29 610p9aymv2pcv RAXMTR select /*+ parallel(t, 16) par...
3,405,169 8 0.11 6djyj1t4djs12 RAXMTR select /*+ parallel(t, 16) par...
1,344,532 3,024 0.04 gz467g1c3hf9v qotSCopHdrUpd.jsp SELECT /*+ ORDERED USE_NL(QPQ ...
1,223,298 12,017 0.04 by2f4fw8tac6r ARXTWMAI UPDATE RA_CUST_TRX_LINE_GL_DIS...

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
0qcpgw43yqj5r ( SELECT DISTINCT WDD.SOURCE_LINE_ID, WDD.SOURCE_HEADER_ID, WDD.ORGANIZATION_ID, WDD.INVENTORY_ITEM_ID, WDD.MOVE_ORDER_LINE_ID, WDD.DELIVERY_DETAIL_ID, WDD.SHIP_MODEL_COMPLETE_FLAG, WDD.TOP_MODEL_LINE_ID, WDD.SHIP_FROM_LOCATION_ID, NULL SHIP_METHOD_CODE, WDD.SHIPMENT_PRIORITY_CODE, WDD.DATE_SCHEDULED DATE_SCHEDULED, WDD.REQUESTED_QUANTITY, WDD.REQUESTED_QUANTITY_UOM, WDD.PREFERRED_GRADE, WDD.REQUESTED_QUANTITY2, WDD.REQUESTED_QUANTITY_UOM2, WDD.PROJECT_ID, WDD.TASK_ID, WDD.SUBINVENTORY FROM_SUBINVENTORY_CODE, WDD.SUBINVENTORY TO_SUBINVENTORY_CODE, WDD.RELEASED_STATUS RELEASED_STATUS, WDD.SHIP_SET_ID SHIP_SET_ID, WDD.SOURCE_CODE SOURCE_CODE, WDD.SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER, NULL PLANNED_DEPARTURE_DATE, WDA.DELIVERY_ID, OL.END_ITEM_UNIT_NUMBER, OL.SOURCE_DOCUMENT_TYPE_ID, MSI.RESERVABLE_TYPE, WDD.LAST_UPDATE_DATE, -1 DEMAND_SOURCE_HEADER_ID, -1 OUTSTANDING_ORDER_VALUE FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA, OE_ORDER_LINES_ALL OL, MTL_SYSTEM_ITEMS MSI , MTL_CATEGORY_SETS MCS, MTL_ITEM_CATEGORIES MIC WHERE WDD.DATE_SCHEDULED IS NOT NULL AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND NVL(WDD.REQUESTED_QUANTITY, 0) > 0 AND WDD.SOURCE_LINE_ID = OL.LINE_ID AND WDD.SOURCE_CODE = 'OE' AND WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND WDD.ORGANIZATION_ID = MSI.ORGA NIZATION_ID AND WDD.RELEASED_STATUS IN ( 'R', 'X') AND WDD.SHIP_FROM_LOCATION_ID = :X_ship_from_loc_id AND WDD.ORGANIZATION_ID = :X_org_id AND (WDA.DELIVERY_ID IS NULL ) AND (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'N' OR (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'Y' AND EXISTS ( SELECT 1 FROM WSH_NEW_DELIVERIES WDE1 WHERE WDE1.DELIVERY_ID = WDA.DELIVERY_ID AND ( NVL(WDE1.PLANNED_FLAG, 'N') IN ('Y', 'F' ) )) )) AND MCS.category_set_id = MIC.category_set_id AND MCS.category_set_id = :x_CategorySetID AND MIC.category_id = :x_CategoryID AND MIC.organization_id = WDD.organization_id AND MIC.inventory_item_id = WDD.inventory_item_id ) ORDER BY WDD.INVENTORY_ITEM_ID, DATE_SCHEDULED ASC, SHIPMENT_PRIORITY_CODE ASC, to_number(SOURCE_HEADER_NUMBER) ASC, SHIP_FROM_LOCATION_ID
0w785m9gmw41a SELECT USERENV('SESSIONID') FROM SYS.DUAL
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 ;
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))
1g4jfpxpupdt6 BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12); END;
1nj7kuvxgpwah begin ARP_TAX . SET_DEFAULT_TAX_CODE ( :setSql , :updSql ) ; END ;
1q78dwnrrkf6c BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END;
25bkagv1j2xf7 INSERT INTO MTL_MATERIAL_TRANSACTIONS ( TRANSACTION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, REVISION, TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_NAME, TRANSACTION_QUANTITY, TRANSACTION_UOM, PRIMARY_QUANTITY, TRANSACTION_DATE, TRANSACTION_COST, ACTUAL_COST, PRIOR_COST, NEW_COST, QUANTITY_ADJUSTED, VARIANCE_AMOUNT, TRANSFER_COST, TRANSPORTATION_COST, TRANSFER_TRANSACTION_ID, TRANSFER_ORGANIZATION_ID, TRANSFER_SUBINVENTORY, TRANSFER_LOCATOR_ID , ACCT_PERIOD_ID, TRANSACTION_REFERENCE, REASON_ID, REPETITIVE_LINE_ID, DEPARTMENT_ID, OPERATION_SEQ_NUM, SHIPMENT_NUMBER, FREIGHT_CODE, WAYBILL_AIRBILL, TRX_SOURCE_LINE_ID, MOVE_ORDER_LINE_ID , COSTED_FLAG , INVOICED_FLAG , DISTRIBUTION_ACCOUNT_ID , ENCUMBRANCE_ACCOUNT , ENCUMBRANCE_A MOUNT , COST_UPDATE_ID , PROJECT_ID , TASK_ID , TO_PROJECT_ID , TO_TASK_ID , LPN_ID , TRANSFER_LPN_ID, CONTENT_LPN_ID , PUT_AWAY_STRATEGY_ID , PUT_AWAY_RULE_ID , PICK_STRATEGY_ID , PICK_RULE_ID , CREATED_BY , COST_GROUP_ID , TRANSFER_COST_GROUP_ID , TRANSACTION_SET_ID , PM_COST_COLLECTED , COST_CATEGORY_ID , ORGANIZATION_TYPE , TRANSFER_ORGANIZATION_TYPE , OWNING_ORGANIZATION_ID , OWNING_TP_TYPE , PLANNING_ORGANIZATION_ID , PLANNING_TP_TYPE , XFR_OWNING_ORGANIZATION_ID , TRANSFER_OWNING_TP_TYPE , XFR_PLANNING_ORGANIZATION_ID , TRANSFER_PLANNING_TP_TYPE , SECONDARY_TRANSACTION_QUANTITY , SECONDARY_UOM_CODE, PICK_SLIP_NUMBER, PICKING_LINE_ID, VENDOR_LOT_NUMBER, SOURCE_CODE, SOURCE_LINE_ID, MOVE_TRANSACTION_ID, RCV_TRANSACTION_ID, COMPLETION_TRANSACTION_ID, CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT, MOV EMENT_ID, SOURCE_PROJECT_ID, SOURCE_TASK_ID, PA_EXPENDITURE_ORG_ID, EXPENDITURE_TYPE, TRANSFER_PERCENTAGE, ORG_COST_GROUP_ID, COST_TYPE_ID, VALUE_CHANGE, PERCENTAGE_CHANGE, EMPLOYEE_CODE, MASTER_SCHEDULE_UPDATE_CODE, TRX_SOURCE_DELIVERY_ID, RECEIVING_DOCUMENT, TRANSPORTATION_DIST_ACCOUNT, NUMBER_OF_CONTAINERS, RMA_LINE_ID, CYCLE_COUNT_ID, PHYSICAL_ADJUSTMENT_ID, FLOW_SCHEDULE, FINAL_COMPLETION_FLAG, QA_COLLECTION_ID, OVERCOMPLETION_TRANSACTION_QTY, OVERCOMPLETION_PRIMARY_QTY, OVERCOMPLETION_TRANSACTION_ID, COMMON_BOM_SEQ_ID, COMMON_ROUTING_SEQ_ID, MVT_STAT_STATUS, PICK_SLIP_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SHIP_TO_LOCATION_ID, TRANSACTION_MODE, TRANSACTION_BATCH_ID, TRANSACTION_BATCH_SEQ, FOB_POINT, INTRANSIT_ACCOUNT, TRX_FLOW_HEADER_ID, L OGICAL_TRX_TYPE_CODE, ORIGINAL_TRANSACTION_TEMP_ID, SHORTAGE_PROCESS_CODE) VALUES(:1, SYSDATE, :2, SYSDATE, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, ROUND(:17, 5), :18, ROUND(:19, 5), nvl(:20, sysdate), :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, 'N', 'N', :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, 'NEW', :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147)
29x3dahwzdj8b SELECT U.USER_NAME, NVL(U.EMPLOYEE_ID, -1), NVL(U.CUSTOMER_ID, -1), NVL(U.SUPPLIER_ID, -1), NVL(U.PERSON_PARTY_ID, -1) FROM FND_USER U WHERE U.USER_ID = :B1
2fjd6cndjby9p INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID ) SELECT /*+ ORDERED */ ASS.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_ID, DIST.CODE_COMBINATION_ID, :B12 , ASS.ACCOUNT_CLASS, 'N', ROUND( (DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1 ), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1 ) ), ASS.AMOUNT ), FC.PRECISION), ROUND( ((DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1) ), ASS.AMOUNT) ) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT) / DECODE(LINES.EXTENDED_AMOUNT, 0, 1, LINES.EXTENDED_AMOUNT)) * DECODE(ASS.AMOUNT, 0, 0, 100), 4), DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), DECODE(:B10 , NULL, ROUND( NVL(HEADER.EXCHANGE_ RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ), :B11 ), ROUND( ( NVL(HEADER.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ( (DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) ) / :B10 ) * :B10 ), DECODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_DATE(ASS.GL_DATE) ), DECODE(DIST.CUSTOMER_TRX_ID, HEADER.CUSTOMER_TRX_ID, DIST.CUST_TRX_LINE_SALESREP_ID, CMSREP.CUST_TRX_LINE_SALESREP_ID), :B9 , :B8 , :B7 , SYSDATE, SYSDATE, :B6 , SYSDATE, :B6 , -3, ASS.GL_DATE, RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES FC, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE, RA_CUST_TRX_LINE_GL_DIST REC, RA_CUST_TRX_LINE_GL_DIST DIST, RA_CUST_TRX_LINE_SALESREPS CMSREP, AR_REVENUE_ASSIGNMENTS ASS WHERE HEADER.CUSTOMER_TRX_ID = :B1 AND HEADER.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = HEADER.INVOICE_CURRENCY_CODE AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINES.AUTORULE_COMPLETE_FLAG||'' = 'N' AND ASS.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND ASS.PERIOD_SET_NAME = :B5 AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID AND DECODE(HEADER.INVOICING_RULE_ID, -3, :B3 , DECODE(NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), 'Y', :B2 , DECODE(:B4 , 'N', :B3 , DECODE(HEADER.PREVIOUS_CUSTOMER_TRX_ID, NULL, AR_REVENUE_MANAGEMENT_PVT.LINE_COLLECTIBILITY(:B1 , LINES.CUSTOMER_TRX_LINE_ID), AR_REVENUE_MANAGEMENT_PVT.CASH_BASED(HEADER.PREVIOUS_CUSTOMER_TRX_ID))))) <> :B2 AND REC.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND DIST.CUSTOMER_TRX_LINE_ID = (SELECT DECODE(COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_LINE_ID), LINES.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' AND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND DIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND DIST.ACCOUNT_SET_FLAG = 'Y' AND DIST.CUST_TRX_LINE_SALESREP_ID = CMSREP.PREV_CUST_TRX_LINE_SALESREP_ID (+) AND :B1 = CMSREP.CUSTOMER_TRX_ID (+) AND NOT EXISTS ( SELECT 'distribution exists' FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST WHERE SUBDIST.CUSTOMER_TRX_LINE_ID = ASS.CUSTOMER_TRX_LINE_ID AND SUBDIST.CUSTOMER_TRX_ID + 0 = LINES.CUSTOMER_TRX_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND SUBDIST.ORIGINAL_GL_DATE = ASS.GL_DATE )
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3n8tvc1tsqua0 SELECT DISTINCT WTS.STOP_ID FROM WSH_TRIP_STOPS WTS, WSH_TRIP_STOPS WTS2, WSH_DELIVERY_LEGS WDL, WSH_DELIVERY_LEGS WDL2, WSH_DELIVERY_ASSIGNMENTS WDA, WSH_DELIVERY_ASSIGNMENTS WDA2, WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_DETAILS WDD2 WHERE WTS.BATCH_ID = :B1 AND WTS.STOP_ID = WDL.PICK_UP_STOP_ID AND WDA.DELIVERY_ID = WDL.DELIVERY_ID AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND WDD.SOURCE_CODE = 'OE' AND NVL(WDD.OE_INTERFACED_FLAG, 'N') <> 'Y' AND WDD.RELEASED_STATUS <> 'D' AND WTS2.BATCH_ID = :B1 AND WTS2.STOP_ID = WDL2.PICK_UP_STOP_ID AND WDA2.DELIVERY_ID = WDL2.DELIVERY_ID AND WDA2.DELIVERY_DETAIL_ID = WDD2.DELIVERY_DETAIL_ID AND WDD2.SOURCE_LINE_ID = WDD.SOURCE_LINE_ID AND WDD2.SOURCE_CODE = 'OE' AND NVL(WDD2.OE_INTERFACED_FLAG, 'N') <> 'Y' AND WDD2.RELEASED_STATUS <> 'D' AND WTS2.STOP_ID <> WTS.STOP_ID
3prk3vg9u0abb BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
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;
4g5vzcyf68n9w SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1
4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5as61q63aqmts SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE A.APPLICATION_ID = :B1
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
5qtxtsar19v4k insert into pay_run_result_values(input_value_id, run_result_id, result_value, formula_result_flag) values (:b1, :b2, :b3:b4, :b5:b6)
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 ;
610p9aymv2pcv select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("COMMENTS"), count(distinct "COMMENTS"), sum(sys_op_opnsize("COMMENTS")), substrb(dump(min(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), count("INTERNAL_NOTES"), count(distinct "INTERNAL_NOTES"), sum(sys_op_opnsize("INTERNAL_NOTES")), substrb(dump(min(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), count("INITIAL_CUSTOMER_TRX_ID"), count(distinct "INITIAL_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("INITIAL_CUSTOMER_TRX_ID")), substrb(dump(min("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE_CONTEXT"), count(distinct "USSGL_TRANSACTION_CODE_CONTEXT"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE_CONTEXT")), substrb(dump(min("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE"), count(distinct "USSGL_TRANSACTION_CODE"), sum(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")), su bstrb(dump(min("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), count("CUSTOMER_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_ATT RIBUTE8")), 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_ATTRIBUTE10"), 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("REFE RENCE_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(distinct "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_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(du mp(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_LINE_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"), su m(sys_op_opnsize("BATCH_SOURCE_NAME")), substrb(dump(min(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("SET_OF_BOOKS_ID"), count(distinct "SET_OF_BOOKS_ID"), sum(sys_op_opnsize("SET_OF_BOOKS_ID")), substrb(dump(min("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), count(distinct "LINE_TYPE"), sum(sys_op_opnsize("LINE_TYPE")), substrb(dump(min("LINE_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_TYPE"), 16, 0, 32), 1, 120), count(distinct "DESCRIPTION"), sum(sys_op_opnsize("DESCRIPTION")), substrb(dump(min(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count(distinct "CURRENCY_CODE"), sum(sys_op_opnsize("CURRENCY_CODE")), substrb(dump(min("CURRENCY_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("CURRENCY_CODE"), 16, 0, 32), 1, 120), count("AMOUNT"), count(distinct "AMOUNT"), sum(sys_op_opnsize("AMOUNT")), substrb(dump(min("AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT"), 16, 0, 32), 1, 120), count("CUST_TRX_TYPE_NAME"), count(distinct "CUST_TRX_TYPE_NAME"), sum(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(su bstrb("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(distinct "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_LINE_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_METHO D_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(dump(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_opnsi ze("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"), count(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_MET HOD_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), substrb(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("RULE_START_DATE"), count(distinct "RULE_START_DATE"), substrb(dump(min("RULE_START_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("RULE_START_DATE"), 16, 0, 32), 1, 120), count("PRIMARY_SALESREP_NUMBER"), count(distinct "PRIMARY_SALESREP_NUMBER"), sum(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(substrb("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), c ount("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"), sum(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(subst rb("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("????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
64qc329wgjv39 select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6cjfxb1c4kx16 SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, HIERARCHY_TYPE FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = UPPER(:B1 ) AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
6djyj1t4djs12 select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_SALESCREDIT_ID"), sum(sys_op_opnsize("INTERFACE_SALESCREDIT_ID")), substrb(dump(min("INTERFACE_SALESCREDIT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_SALESCREDIT_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ID"), count(distinct "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_ATTRIB UTE3")), 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_LINE_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("SALESREP_NUMB ER"), count(distinct "SALESREP_NUMBER"), sum(sys_op_opnsize("SALESREP_NUMBER")), substrb(dump(min("SALESREP_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_NUMBER"), 16, 0, 32), 1, 120), count("SALESREP_ID"), count(distinct "SALESREP_ID"), sum(sys_op_opnsize("SALESREP_ID")), substrb(dump(min("SALESREP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_NAME"), count(distinct "SALES_CREDIT_TYPE_NAME"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_NAME")), substrb(dump(min("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_ID"), count(distinct "SALES_CREDIT_TYPE_ID"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_ID")), substrb(dump(min("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_AMOUNT_SPLIT"), count(distinct "SALES_CREDIT_AMOUNT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_AMOUNT_SPLIT")), substrb(dump(min("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), count("SALES_CREDIT_PERCENT_SPLIT"), count(distinct "SALES_CREDIT_PERCENT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_PERCENT_SPLIT")), substrb(dump(min("SALES_CREDIT_PERCENT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_PERCENT_SPLIT"), 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("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(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE3"), count(distinct "ATTRIBUTE3"), sum(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(dist inct "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(substr b("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("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), 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("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("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("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("SALESGROUP_ID"), count(distinct "SALESGROUP_ID"), sum(sys_op_opnsize("SALESGROUP_ID")), substrb(dump(min("SALESGROUP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALESGROUP_ID"), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_SALESCREDITS_ALL" sample ( 10.0000000000) t
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;
7g05xfvc5vp74 BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END;
8vmj377jqyqwq BEGIN WSH_BATCH_PROCESS.CONFIRM_DELIVERY_SRS( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14, :A15, :A16, :A17, :A18, :A19, :A20, :A21, :A22); END;
95pbs94n69z3d SELECT NVL(MULTI_ORG_FLAG, 'N'), NVL(MULTI_CURRENCY_FLAG, 'N') FROM FND_PRODUCT_GROUPS
9dvfguzd15kpv SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = :B1
9sf243fdjmdmh begin fnd_global.apps_initialize(-1, -1, -1, :1); end;
9wdrypwkpf607 begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4 BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
a957tvxz9w038 BEGIN :1 := por_util_pkg.interface_START_WORKFLOW( :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102) ; END;
avc1jqzz04wpr SELECT 'x' FROM DUAL
b3an778qn1q49 select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), 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), 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_o p_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("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("HEA DER_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_opnsize("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("H EADER_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_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE16"), count(distinct "HEADER_GDF_ATTRIBUTE16"), sum(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_ATTRIBUTE20", 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_ATTRIBU TE23"), 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(distinct "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")), substrb(dump(min("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE1"), count(distinct "LINE_GDF_ATTRIBUTE1"), sum(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_ATTRIB UTE2", 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")), subst rb(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"), count(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")), subst rb(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, 1 20), 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("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_ITEMS_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("MT L_SYSTEM_ITEMS_SEG19")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG20"), count(distinct "MTL_SYSTEM_ITEMS_SEG20"), sum(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_ATTRIBUTE3"), 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_SEGMENT4"), 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(d????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????, 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(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE3"), count(distinct "ATTRIBUTE3"), sum(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("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE6"), count(distinct "HEADER_ATTRIBUTE6"), sum(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")), substrb(dump(min(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE11"), count(distinct "HEADER_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE12"), count(distinct "HEADER_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_ATTRIBUTE12")), substrb(dump(min(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE13"), count(distinct "HEADER_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE14"), count(distinct "HEADER_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_ATTRIBUTE14", 1 , 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE15"), count(distinct "HEADER_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t
bc7t6t6jfx2n7 SELECT VERSION FROM FND_CACHE_VERSIONS WHERE NAME = :B1
bcym7s1bp0wxs SELECT WIA.NAME FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1 AND WIA.TYPE = 'EVENT'
bkxrrs52m7d8p BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
bp8crdjba8zgt update ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b4)
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
bvyqm6268u2as SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = :B1
by2f4fw8tac6r UPDATE RA_CUST_TRX_LINE_GL_DIST LGD SET (AMOUNT, ACCTD_AMOUNT) = (SELECT NVL(LGD.AMOUNT, 0) - ( SUM(LGD2.AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) ) ), NVL(LGD.ACCTD_AMOUNT, 0) - ( SUM(LGD2.ACCTD_AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD2, RA_CUSTOMER_TRX_LINES CTL, RA_CUSTOMER_TRX CT, RA_CUST_TRX_LINE_GL_DIST REC1 WHERE REC1.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC1.ACCOUNT_CLASS = 'REC' AND REC1.LATEST_REC_FLAG = 'Y' AND CT.CUSTOMER_TRX_ID = REC1.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.ACCOUNT_CLASS = LGD.ACCOUNT_CLASS AND LGD2.ACCOUNT_SET_FLAG = 'N' AND NVL(LGD2.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD .GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), REC1.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, CT.EXCHANGE_RATE ), PERCENT = (SELECT DECODE(LGD.ACCOUNT_CLASS || LGD.ACCOUNT_SET_FLAG, 'SUSPENSEN', LGD.PERCENT, 'UNBILLN', LGD.PERCENT, 'UNEARNN', LGD.PERCENT, NVL(LGD.PERCENT, 0) - ( SUM(NVL(LGD4.PERCENT, 0)) - DECODE(REC2.GL_DATE, NVL(LGD.GL_DATE, REC2.GL_DATE), 100, 0) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD4, RA_CUST_TRX_LINE_GL_DIST REC2 WHERE REC2.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC2.ACCOUNT_CLASS = 'REC' AND REC2.LATEST_REC_FLAG = 'Y' AND LGD4.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD4.ACCOUNT_SET_FLAG = LGD.ACCOUNT_SET_FLAG AND DECODE(LGD4.ACCOUNT_SET_FLAG, 'Y', LGD4.ACCOUNT_CLASS, LGD.ACCOUNT_CLASS) = LGD.ACCOUNT_CLASS AND NVL(LGD4.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD.GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY REC2.GL_DATE, LGD.GL_DATE ), LAST_UPDATED_BY = :B1 , LAST_UPDATE_DATE = SYSDATE WHERE CUST_TRX_LINE_GL_DIST_ID IN (SELECT MIN(DECODE(LGD3.GL_POSTED_DATE, NULL, LGD3.CUST_TRX_LINE_GL_DIST_ID, NULL) ) FROM RA_CUSTOMER_TRX_LINES CTL, RA_CUST_TRX_LINE_GL_DIST LGD3, RA_CUST_TRX_LINE_GL_DIST REC3, RA_CUSTOMER_TRX T WHERE T.CUSTOMER_TRX_ID = :B5 AND REC3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND REC3.ACCOUNT_CLASS = 'REC' AND REC3.LATEST_REC_FLAG = 'Y' AND LGD3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND LGD3.ACCOUNT_S ET_FLAG = 'N' AND CTL.CUSTOMER_TRX_LINE_ID = LGD3.CUSTOMER_TRX_LINE_ID AND ( CTL.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL.LINE_TYPE = 'LINE' AND CTL.ACCOUNTING_RULE_ID IS NULL) ) AND NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) = DECODE(:B4 , 'INV', -1, 'REGULAR_CM', T.PREVIOUS_CUSTOMER_TRX_ID, NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), LGD3.GL_DATE, REC3.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, T.EXCHANGE_RATE HAVING ( SUM(NVL(LGD3.AMOUNT, 0)) <> DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) OR SUM(NVL(LGD3.ACCTD_AMOUNT, 0)) <> DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) UNION SELECT TO_NUMBER( MIN(DECODE(LGD5.GL_POSTED_DATE||LGD5.ACCOUNT_CLASS|| LGD5.ACCOUNT_SET_FLAG, 'REVN', LGD 5.CUST_TRX_LINE_GL_DIST_ID, 'REVY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNEARNY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNBILLY', LGD5.CUST_TRX_LINE_GL_DIST_ID, NULL ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST REC5, RA_CUST_TRX_LINE_GL_DIST LGD5, RA_CUSTOMER_TRX_LINES CTL2 WHERE CTL2.CUSTOMER_TRX_ID = :B5 AND REC5.CUSTOMER_TRX_ID = LGD5.CUSTOMER_TRX_ID AND REC5.ACCOUNT_CLASS = 'REC' AND REC5.LATEST_REC_FLAG = 'Y' AND LGD5.CUSTOMER_TRX_LINE_ID = CTL2.CUSTOMER_TRX_LINE_ID AND ( CTL2.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL2.LINE_TYPE = 'LINE' AND (CTL2.ACCOUNTING_RULE_ID IS NULL OR LGD5.ACCOUNT_SET_FLAG = 'Y') ) ) GROUP BY LGD5.CUSTOMER_TRX_LINE_ID, LGD5.GL_DATE, REC5.GL_DATE, LGD5.ACCOUNT_SET_FLAG, DECODE(LGD5.ACCOUNT_SET_FLAG, 'N', NULL, LGD5.ACCOUNT_CLASS) HAVING SUM(NVL(LGD5.PERCENT, 0)) <> DECODE( NVL(LGD5.GL_DATE, REC5.GL_DATE), REC5.GL_DATE, 100, 0) )
c4y7jp0q2awbf SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1
cwyx16zn1hpfb select parameter, value from nls_session_parameters
fhqzxap2n0ybj select NAME from HR_OPERATING_UNITS where ORGANIZATION_ID = :zorg_id
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
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;
ghw9svn8x4vzu BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS( :errbuf, :rc, :A0, :A1, :A2); END;
gksvm8wmzk8w0 begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;
gz467g1c3hf9v SELECT /*+ ORDERED USE_NL(QPQ QPLAT_Q QPLAT_PROD QPA QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) l_list_qual_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, NULL PRICING_ATTRIBUTE_CONTEXT, NULL PRICING_ATTRIBUTE, NULL PRICING_ATTR_VALUE_FROM, NULL PRICING_SETUP_VALUE_FROM, NULL PRICING_SETUP_VALUE_TO, NULL PRICING_ATTRIBUTE_LEVEL, NULL PRICING_ATTRIBUTE_TYPE, NULL PRICING_OPERATOR_TYPE, QPLAT_Q.CONTEXT QUALIFIER_ATTRIBUTE_CONTEXT, QPLAT_Q.ATTRIBUTE QUALIFIER_ATTRIBUTE, QPLAT_Q.VALUE_FROM QUALIFIER_ATTR_VALUE_FROM, QPLAT_Q.PRICING_ATTR_FLAG QUALIFIER_PRICING_ATTR_FLAG, QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO, QPQ.QUALIFIER_PRECEDENCE QUALIFIER_PRECEDENCE, QPQ.QUALIFIER_DATATYPE QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VAL UE SETUP_VALUE_FROM, QPQ.QUALIFIER_ATTR_VALUE_TO SETUP_VALUE_TO, QPQ.COMPARISON_OPERATOR_CODE QUALIFIER_OPERATOR_TYPE, NULL PRICING_ATTRIBUTE_DATATYPE, DECODE(QPQ.LIST_LINE_ID, -1, 'HQ', 'LQ') QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_QUALIFIERS QPQ, QP_NPREQ_LINE_ATTRS_TMP QPLAT_Q, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B14 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFF ECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_Q.ATTRIBUTE_TYPE = :B6 AND (QPQ.QUALIFIER_CONTEXT <> :B5 OR QPQ.QUALIFIER_ATTRIBUTE <> :B4 ) AND QPLAT_Q.CONTEXT = QPQ.QUALIFIER_CONTEXT AND QPLAT_Q.ATTRIBUTE = QPQ.QUALIFIER_ATTRIBUTE AND QPQ.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPQ.ACTIVE_FLAG = :B3 AND ((QPLAT_Q.VALUE_FROM = QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = '=') OR (QPLAT_Q.VALUE_FROM <> QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =') OR QPQ.COMPARISON_OPERATOR_CODE = :B2 ) AND QPLAT_Q.LINE_INDEX = QPLINES.LINE_INDEX AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(QPQ.START_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(QPQ.END_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND QPLAT_PROD.LINE_INDEX = QPLAT_Q.LINE_INDEX AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_Q. PRICING_STATUS_CODE = :B1 AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPQ QPLAT_Q QPLAT_PROD QPA QPLAT_PRIC QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line _attrs_tmp_N2) l_list_qual_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, QPLAT_PRIC.CONTEXT PRICING_ATTRIBUTE_CONTEXT, QPLAT_PRIC.ATTRIBUTE PRICING_ATTRIBUTE, QPLAT_PRIC.VALUE_FROM PRICING_ATTR_VALUE_FROM, QPA.PRICING_ATTR_VALUE_FROM PRICING_SETUP_VALUE_FROM, QPA.PRICING_ATTR_VALUE_TO PRICING_SETUP_VALUE_TO, QPLAT_PRIC.ATTRIBUTE_LEVEL PRICING_ATTRIBUTE_LEVEL, QPLAT_PRIC.ATTRIBUTE_TYPE PRICING_ATTRIBUTE_TYPE, QPA.COMPARISON_OPERATOR_CODE PRICING_OPERATOR_TYPE, QPLAT_Q.CONTEXT QUALIFIER_ATTRIBUTE_CONTEXT, QPLAT_Q.ATTRIBUTE QUALIFIER_ATTRIBUTE, QPLAT_Q.VALUE_FROM QUALIFIER_ATTR_VALUE_FROM, QPLAT_Q.PRICING_ATTR_FLAG QUALIFIER_PRICING_ATTR_FLAG, QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO, QPQ.QUALIFIER_PRECEDENCE QUALIFIER_PRECEDENCE, QPQ.QUALIFIER_DATATYPE QUALIFIER_DATATYPE, QPQ.QUALIFIER_AT TR_VALUE SETUP_VALUE_FROM, QPQ.QUALIFIER_ATTR_VALUE_TO SETUP_VALUE_TO, QPQ.COMPARISON_OPERATOR_CODE QUALIFIER_OPERATOR_TYPE, QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE, DECODE(QPQ.LIST_LINE_ID, -1, 'HQ', 'LQ') QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_QUALIFIERS QPQ, QP_NPREQ_LINE_ATTRS_TMP QPLAT_Q, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PRIC, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B17 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B3 AND QPLINES.PRICING_ATTRS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PRIC.CONTEXT = QPA.PRICING_ATTRIBUTE_CONTEXT AND QPLAT_PRIC.ATTRIBUTE = QPA.PRICING_ATTRIBUTE AND (QPLAT_PRIC.VALUE_FROM = QPA.PRICING_ATTR_VALUE_FROM OR QPA.COMPARISON_OPERATOR_CODE IN ('NOT =', :B2 )) AND QPLAT_PRIC.ATTRIBUTE_TYPE = :B16 AND QPLAT_PRIC. PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX AND QPH.LIST_HEADER_ID = QPL.LIST_HEAD ER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_Q.ATTRIBUTE_TYPE = :B6 AND (QPQ.QUALIFIER_CONTEXT <> :B5 OR QPQ.QUALIFIER_ATTRIBUTE <> :B4 ) AND QPLAT_Q.CONTEXT = QPQ.QUALIFIER_CONTEXT AND QPLAT_Q.ATTRIBUTE = QPQ.QUALIFIER_ATTRIBUTE AND QPQ.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPQ.ACTIVE_FLAG = :B3 AND ((QPLAT_Q.VALUE_FROM = QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = '=') OR (QPLAT_Q.VALUE_FROM <> QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =') OR QPQ.COMPARISON_OPERATOR_CODE = :B2 ) AND QPLAT_Q.LINE_INDEX = QPLINES.LINE_INDEX AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(QPQ.START_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND NVL( QPQ.END_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_Q.PRICING_STATUS_CODE = :B1 AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) l_list_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, NULL PRICING_ATTRIBUTE_CONTEXT, NULL PRICING_ATTRIBUTE, NULL PRICING_ATTR_VALUE_FROM, NULL PRICING_SETUP_VALUE_FROM, NULL PRICING_SETUP_VALUE_TO, NULL PRICING_ATTRIBUTE_LEVEL, NULL PRICING_ATTRIBUTE_TYPE, NULL PRICING_OPERATOR_TYPE, NULL QUALIFIER_ATTRIBUTE_CONTEXT, NULL QUALIFIER_ATTRIBUTE, NULL QUALIFIER_ATTR_VALUE_FROM, NULL QUALIFIER_PRICING_ATTR_FLAG, -9999 QUALIFIER_GROUPING_NO, 5000 QUALIFIER_PRECEDENCE, NULL QUALIFIER_DATATYPE, NULL SETUP_VALUE_FROM, NULL SETUP_VALUE_TO, NULL QUALIFIER_OPERATOR_TYPE, NULL PRICING_ATTRIBUTE_DATATYPE, NULL QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B18 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B10 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFE CTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line_attrs_tmp_N2) l_list_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, QPLAT_PRIC.CONTEXT PRICING_ATTRIBUTE_CONTEXT, QPLAT_PRIC.ATTRIBUTE PRICING_ATTRIBUTE, QPLAT_PRIC.VALUE_FROM PRICING_ATTR_VALUE_FROM, QPA.PRICING_ATTR_VALUE_FROM PRICING_SETUP_VALUE_FROM, QPA.PRICING_ATTR_VALUE_ TO PRICING_SETUP_VALUE_TO, QPLAT_PRIC.ATTRIBUTE_LEVEL PRICING_ATTRIBUTE_LEVEL, QPLAT_PRIC.ATTRIBUTE_TYPE PRICING_ATTRIBUTE_TYPE, QPA.COMPARISON_OPERATOR_CODE PRICING_OPERATOR_TYPE, NULL QUALIFIER_ATTRIBUTE_CONTEXT, NULL QUALIFIER_ATTRIBUTE, NULL QUALIFIER_ATTR_VALUE_FROM, NULL QUALIFIER_PRICING_ATTR_FLAG, -9999 QUALIFIER_GROUPING_NO, 5000 QUALIFIER_PRECEDENCE, NULL QUALIFIER_DATATYPE, NULL SETUP_VALUE_FROM, NULL SETUP_VALUE_TO, NULL QUALIFIER_OPERATOR_TYPE, QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE, NULL QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PRIC, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B19 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B10 AND QPLINES.PRICING_ATTRS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.CONTEXT = QPA.PRICING_ATTRIBUTE_CONTEXT AND QPLAT_PRIC.ATTRIBUTE = QP A.PRICING_ATTRIBUTE AND (QPLAT_PRIC.VALUE_FROM = QPA.PRICING_ATTR_VALUE_FROM OR QPA.COMPARISON_OPERATOR_CODE IN ('NOT =', :B2 )) AND QPLAT_PRIC.ATTRIBUTE_TYPE = :B16 AND QPLAT_PRIC. PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX AND QPH.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) ORDER BY 1, 2

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 3,162,003 876.51 3.28
CPU used when call started 3,146,898 872.32 3.27
CR blocks created 14,262,907 3,953.70 14.80
Cached Commit SCN referenced 879,328 243.75 0.91
Commit SCN cached 398 0.11 0.00
DB time 7,365,538 2,041.74 7.64
DBWR checkpoint buffers written 3,640,487 1,009.15 3.78
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 57,510 15.94 0.06
DBWR revisited being-written buffer 43 0.01 0.00
DBWR thread checkpoint buffers written 485,648 134.62 0.50
DBWR transaction table writes 3,095 0.86 0.00
DBWR undo block writes 1,634,515 453.09 1.70
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 18,654,916 5,171.17 19.36
IMU Flushes 286,457 79.41 0.30
IMU Redo allocation size 2,064,832,176 572,374.59 2,143.02
IMU commits 508,910 141.07 0.53
IMU contention 32,351 8.97 0.03
IMU ktichg flush 6,757 1.87 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,345 0.37 0.00
IMU undo allocation size 4,528,375,048 1,255,272.39 4,699.85
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 68,888 19.10 0.07
PX local messages sent 68,888 19.10 0.07
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 37,159,508 10,300.67 38.57
active txn count during cleanout 66,575,065 18,454.71 69.10
application wait time 46,792 12.97 0.05
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,796 3.82 0.01
branch node splits 800 0.22 0.00
buffer is not pinned count 553,072,344 153,312.49 574.02
buffer is pinned count 974,183,858 270,045.23 1,011.07
bytes received via SQL*Net from client 7,037,639,020 1,950,844.14 7,304.14
bytes sent via SQL*Net to client 6,899,388,871 1,912,520.99 7,160.65
calls to get snapshot scn: kcmgss 105,672,680 29,292.63 109.67
calls to kcmgas 18,094,639 5,015.86 18.78
calls to kcmgcs 9,756,485 2,704.51 10.13
change write time 72,491 20.09 0.08
cleanout - number of ktugct calls 22,481,562 6,231.92 23.33
cleanouts and rollbacks - consistent read gets 12,305,011 3,410.97 12.77
cleanouts only - consistent read gets 147,559 40.90 0.15
cluster key scan block gets 1,414,149 392.00 1.47
cluster key scans 162,267 44.98 0.17
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 4,905 1.36 0.01
commit batch/immediate requested 4,905 1.36 0.01
commit cleanout failures: block lost 239,442 66.37 0.25
commit cleanout failures: buffer being written 1,303 0.36 0.00
commit cleanout failures: callback failure 104,590 28.99 0.11
commit cleanout failures: cannot pin 33,691 9.34 0.03
commit cleanouts 8,536,507 2,366.33 8.86
commit cleanouts successfully completed 8,157,481 2,261.27 8.47
commit immediate performed 4,905 1.36 0.01
commit immediate requested 4,905 1.36 0.01
commit txn count during cleanout 1,284,673 356.11 1.33
concurrency wait time 34,488 9.56 0.04
consistent changes 623,989,449 172,970.82 647.62
consistent gets 1,577,715,134 437,345.01 1,637.46
consistent gets - examination 1,078,951,460 299,086.97 1,119.81
consistent gets from cache 1,577,715,146 437,345.02 1,637.46
cursor authentications 1,915 0.53 0.00
data blocks consistent reads - undo records applied 620,384,366 171,971.48 643.88
db block changes 188,711,423 52,311.09 195.86
db block gets 210,367,963 58,314.32 218.33
db block gets direct 4,213 1.17 0.00
db block gets from cache 210,363,750 58,313.15 218.33
deferred (CURRENT) block cleanout applications 1,366,872 378.90 1.42
dirty buffers inspected 8,671 2.40 0.01
enqueue conversions 8,971 2.49 0.01
enqueue releases 3,923,845 1,087.70 4.07
enqueue requests 3,933,746 1,090.44 4.08
enqueue timeouts 9,824 2.72 0.01
enqueue waits 56,138 15.56 0.06
exchange deadlocks 49,675 13.77 0.05
execute count 94,768,567 26,269.99 98.36
failed probes on index block reclamation 8,187 2.27 0.01
free buffer inspected 3,116,084 863.78 3.23
free buffer requested 18,614,128 5,159.86 19.32
heap block compress 25,660,756 7,113.20 26.63
hot buffers moved to head of LRU 1,359,473 376.85 1.41
immediate (CR) block cleanout applications 12,452,574 3,451.87 12.92
immediate (CURRENT) block cleanout applications 1,211,942 335.95 1.26
index crx upgrade (found) 53,357 14.79 0.06
index crx upgrade (positioned) 9,956,497 2,759.96 10.33
index fast full scans (rowid ranges) 1,632 0.45 0.00
index fetch by key 176,971,827 49,056.86 183.67
index scans kdiixs1 126,191,618 34,980.51 130.97
java call heap collected bytes 1,121,173,384 310,790.95 1,163.63
java call heap collected count 14,238,242 3,946.86 14.78
java call heap gc count 4,780 1.33 0.00
java call heap live object count 1,607,933 445.72 1.67
java call heap live object count max 1,604,090 444.66 1.66
java call heap live size 499,176,184 138,372.39 518.08
java call heap live size max 498,660,784 138,229.52 517.54
java call heap object count 3,509,772 972.91 3.64
java call heap object count max 3,514,941 974.35 3.65
java call heap total size 673,258,752 186,628.34 698.75
java call heap total size max 672,202,496 186,335.54 697.66
java call heap used size 624,511,296 173,115.47 648.16
java call heap used size max 624,819,672 173,200.95 648.48
leaf node 90-10 splits 19,472 5.40 0.02
leaf node splits 232,165 64.36 0.24
lob reads 16,778 4.65 0.02
lob writes 28,889 8.01 0.03
lob writes unaligned 28,889 8.01 0.03
logons cumulative 8,215 2.28 0.01
messages received 2,293,330 635.71 2.38
messages sent 2,293,331 635.71 2.38
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 452,956,427 125,560.20 470.11
opened cursors cumulative 9,837,365 2,726.93 10.21
parse count (failures) 2,526 0.70 0.00
parse count (hard) 7,359 2.04 0.01
parse count (total) 13,121,447 3,637.28 13.62
parse time cpu 77,258 21.42 0.08
parse time elapsed 89,143 24.71 0.09
physical read IO requests 340,281 94.33 0.35
physical read bytes 4,018,774,016 1,114,010.21 4,170.96
physical read total IO requests 341,959 94.79 0.35
physical read total bytes 4,045,357,056 1,121,379.07 4,198.55
physical read total multi block requests 20,286 5.62 0.02
physical reads 490,573 135.99 0.51
physical reads cache 489,779 135.77 0.51
physical reads cache prefetch 150,112 41.61 0.16
physical reads direct 794 0.22 0.00
physical reads direct temporary tablespace 186 0.05 0.00
physical reads prefetch warmup 107,414 29.78 0.11
physical write IO requests 1,162,846 322.34 1.21
physical write bytes 30,494,818,304 8,453,209.58 31,649.59
physical write total IO requests 2,348,628 651.04 2.44
physical write total bytes 64,666,554,368 17,925,666.30 67,115.32
physical write total multi block requests 1,458,391 404.27 1.51
physical writes 3,722,512 1,031.89 3.86
physical writes direct 4,732 1.31 0.00
physical writes direct (lob) 221 0.06 0.00
physical writes direct temporary tablespace 4,091 1.13 0.00
physical writes from cache 3,717,780 1,030.57 3.86
physical writes non checkpoint 2,358,692 653.83 2.45
pinned buffers inspected 3,788 1.05 0.00
prefetch warmup blocks aged out before use 289,319 80.20 0.30
prefetched blocks aged out before use 45 0.01 0.00
process last non-idle time 3,606 1.00 0.00
queries parallelized 48 0.01 0.00
recursive aborts on index block reclamation 92 0.03 0.00
recursive calls 169,331,072 46,938.83 175.74
recursive cpu usage 1,796,273 497.93 1.86
redo blocks written 33,287,715 9,227.40 34.55
redo entries 97,047,157 26,901.62 100.72
redo ordering marks 1,259,507 349.14 1.31
redo size 32,886,833,304 9,116,279.74 34,132.18
redo subscn max counts 2,556,874 708.77 2.65
redo synch time 43,711 12.12 0.05
redo synch writes 2,097,404 581.40 2.18
redo wastage 649,281,184 179,981.72 673.87
redo write time 49,594 13.75 0.05
redo writer latching time 66 0.02 0.00
redo writes 743,308 206.05 0.77
rollback changes - undo records applied 244,432 67.76 0.25
rollbacks only - consistent read gets 2,086,365 578.34 2.17
rows fetched via callback 91,270,024 25,300.19 94.73
session connect time 0 0.00 0.00
session cursor cache hits 5,887,606 1,632.05 6.11
session logical reads 1,788,083,751 495,659.51 1,855.79
session pga memory 5,348,260,600 1,482,545.90 5,550.79
session pga memory max 7,632,475,704 2,115,733.76 7,921.50
session uga memory ############### 72,396,288.37 271,058.28
session uga memory max 57,115,869,064 15,832,604.96 59,278.71
shared hash latch upgrades - no wait 30,714,817 8,514.19 31.88
shared hash latch upgrades - wait 77,293 21.43 0.08
sorts (memory) 10,171,381 2,819.52 10.56
sorts (rows) 124,487,938 34,508.24 129.20
sql area evicted 240 0.07 0.00
sql area purged 2,695 0.75 0.00
summed dirty queue length 205,676 57.01 0.21
switch current to new buffer 1,321,512 366.33 1.37
table fetch by rowid 617,454,065 171,159.20 640.84
table fetch continued row 32,711,308 9,067.62 33.95
table scan blocks gotten 80,523,033 22,321.11 83.57
table scan rows gotten 4,445,848,469 1,232,395.89 4,614.20
table scans (long tables) 4,648 1.29 0.00
table scans (rowid ranges) 4,646 1.29 0.00
table scans (short tables) 5,239,268 1,452.33 5.44
total number of times SMON posted 85,840 23.79 0.09
transaction rollbacks 4,905 1.36 0.01
transaction tables consistent read rollbacks 120 0.03 0.00
transaction tables consistent reads - undo records applied 6,139 1.70 0.01
undo change vector size 11,549,591,632 3,201,564.20 11,986.95
user I/O wait time 162,056 44.92 0.17
user calls 35,367,946 9,804.05 36.71
user commits 777,260 215.46 0.81
user rollbacks 186,254 51.63 0.19
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 6,075,057 1,684.01 6.31
write clones created in background 1,146 0.32 0.00
write clones created in foreground 14,300 3.96 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 359,869 976,957
opened cursors current 619,735 644,155
workarea memory allocated 1,429 94
logons current 3,769 3,736

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_UNDOTS1 66 0 7.88 1.00 386,641 107 255,655 0.02
APPS_TS_TX_DATA 139,571 39 4.66 1.32 181,267 50 108,864 0.24
APPS_TS_TX_IDX 118,206 33 5.17 1.54 181,322 50 84,703 0.29
APPS_ASSM_DATA 32,075 9 2.44 2.02 185,445 51 69,951 0.35
APPS_ASSM_IDX 39,413 11 3.90 1.00 152,809 42 298,785 0.07
APPS_TS_TX_INTERFACE 656 0 6.28 2.87 28,631 8 2,770 0.04
APPS_TS_QUEUES 2,207 1 7.91 1.69 19,183 5 171 0.29
SYSTEM 4,179 1 5.47 1.09 5,309 1 7,475 0.46
TEMP 831 0 2.59 5.25 7,119 2 16 2.50
APPS_TS_SEED 2,196 1 7.42 1.80 4,068 1 864 2.86
APPS_TS_SUMMARY 59 0 5.93 1.00 4,444 1 2,535 0.01
CTXSYS 162 0 6.60 1.81 3,851 1 1 0.00
APPS_TS_ARCHIVE 57 0 7.02 1.42 1,951 1 118 3.90
SYSAUX 535 0 2.73 1.85 726 0 0 0.00
APPS_TS_NOLOGGING 32 0 1.25 1.44 59 0 0 0.00
APPS_TS_MEDIA 9 0 0.00 1.00 9 0 0 0.00
ODM 7 0 10.00 1.00 3 0 0 0.00
OLAP 7 0 8.57 1.00 3 0 0 0.00
OWAPUB 7 0 5.71 1.00 3 0 0 0.00
PORTAL 7 0 0.00 1.00 3 0 0 0.00
SYNCSERVER 7 0 0.00 1.00 3 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 /oracle/visdata/apps_assm_data.dbf 32,075 9 2.44 2.02 185,445 51 69,951 0.35
APPS_ASSM_IDX /oracle/visdata/apps_assm_idx.dbf 39,413 11 3.90 1.00 152,809 42 298,785 0.07
APPS_TS_ARCHIVE /oasb_data/archive1.dbf 17 0 7.65 1.00 967 0 55 4.00
APPS_TS_ARCHIVE /oasb_data/archive2.dbf 40 0 6.75 1.60 984 0 63 3.81
APPS_TS_MEDIA /oasb_data/media1.dbf 3 0 0.00 1.00 3 0 0 0.00
APPS_TS_MEDIA /oasb_data/media2.dbf 3 0 0.00 1.00 3 0 0 0.00
APPS_TS_MEDIA /oasb_data/media3.dbf 3 0 0.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging1.dbf 16 0 2.50 1.88 53 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging2.dbf 8 0 0.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging3.dbf 8 0 0.00 1.00 3 0 0 0.00
APPS_TS_QUEUES /oasb_data/queues1.dbf 293 0 9.01 1.61 2,625 1 2 0.00
APPS_TS_QUEUES /oasb_data/queues2.dbf 361 0 6.93 1.65 3,088 1 33 0.61
APPS_TS_QUEUES /oasb_data/queues3.dbf 330 0 7.03 1.81 2,812 1 58 0.00
APPS_TS_QUEUES /oasb_data/queues4.dbf 288 0 7.85 1.71 2,664 1 72 0.42
APPS_TS_QUEUES /oasb_data/queues5.dbf 313 0 7.12 1.80 2,636 1 4 0.00
APPS_TS_QUEUES /oasb_data/queues6.dbf 318 0 9.03 1.54 2,709 1 1 0.00
APPS_TS_QUEUES /oasb_data/queues7.dbf 304 0 8.68 1.68 2,649 1 1 0.00
APPS_TS_SEED /oasb_data/reference1.dbf 172 0 7.33 2.19 346 0 196 2.70
APPS_TS_SEED /oasb_data/reference10.dbf 157 0 7.13 1.67 297 0 0 0.00
APPS_TS_SEED /oasb_data/reference2.dbf 275 0 5.49 1.84 352 0 606 3.02
APPS_TS_SEED /oasb_data/reference3.dbf 231 0 7.79 1.82 462 0 11 5.45
APPS_TS_SEED /oasb_data/reference4.dbf 225 0 7.96 1.70 408 0 51 0.98
APPS_TS_SEED /oasb_data/reference5.dbf 216 0 7.59 1.87 340 0 0 0.00
APPS_TS_SEED /oasb_data/reference6.dbf 234 0 7.48 1.75 519 0 0 0.00
APPS_TS_SEED /oasb_data/reference7.dbf 240 0 7.54 1.86 465 0 0 0.00
APPS_TS_SEED /oasb_data/reference8.dbf 229 0 8.03 1.47 453 0 0 0.00
APPS_TS_SEED /oasb_data/reference9.dbf 217 0 8.16 1.90 426 0 0 0.00
APPS_TS_SUMMARY /oasb_data/summary1.dbf 13 0 8.46 1.00 554 0 276 0.00
APPS_TS_SUMMARY /oasb_data/summary2.dbf 5 0 0.00 1.00 199 0 5 0.00
APPS_TS_SUMMARY /oasb_data/summary3.dbf 5 0 14.00 1.00 1,106 0 283 0.07
APPS_TS_SUMMARY /oasb_data/summary4.dbf 4 0 2.50 1.00 579 0 206 0.00
APPS_TS_SUMMARY /oasb_data/summary5.dbf 4 0 15.00 1.00 547 0 974 0.00
APPS_TS_SUMMARY /oasb_data/summary6.dbf 8 0 5.00 1.00 488 0 299 0.00
APPS_TS_SUMMARY /oasb_data/summary7.dbf 8 0 2.50 1.00 482 0 253 0.04
APPS_TS_SUMMARY /oasb_data/summary8.dbf 12 0 3.33 1.00 489 0 239 0.00
APPS_TS_TX_DATA /oasb_data/tx_data1.dbf 536 0 3.75 2.03 7,792 2 4,772 0.32
APPS_TS_TX_DATA /oasb_data/tx_data10.dbf 372 0 3.52 1.80 8,179 2 4,654 0.38
APPS_TS_TX_DATA /oasb_data/tx_data11.dbf 579 0 3.32 1.78 8,155 2 5,688 0.37
APPS_TS_TX_DATA /oasb_data/tx_data12.dbf 12,693 4 4.73 1.30 9,551 3 4,743 0.09
APPS_TS_TX_DATA /oasb_data/tx_data13.dbf 12,710 4 4.90 1.29 9,644 3 5,336 0.24
APPS_TS_TX_DATA /oasb_data/tx_data14.dbf 12,716 4 4.58 1.30 9,125 3 6,214 0.03
APPS_TS_TX_DATA /oasb_data/tx_data15.dbf 12,501 3 4.73 1.30 9,474 3 5,603 0.07
APPS_TS_TX_DATA /oasb_data/tx_data16.dbf 12,528 3 4.70 1.29 9,592 3 5,111 0.04
APPS_TS_TX_DATA /oasb_data/tx_data17.dbf 12,613 3 4.68 1.28 9,311 3 4,140 0.08
APPS_TS_TX_DATA /oasb_data/tx_data18.dbf 12,694 4 4.77 1.30 8,848 2 3,944 0.12
APPS_TS_TX_DATA /oasb_data/tx_data19.dbf 12,530 3 4.89 1.29 8,654 2 4,927 0.06
APPS_TS_TX_DATA /oasb_data/tx_data2.dbf 624 0 3.29 2.20 8,028 2 5,004 0.61
APPS_TS_TX_DATA /oasb_data/tx_data20.dbf 12,623 3 4.74 1.32 8,996 2 4,208 0.07
APPS_TS_TX_DATA /oasb_data/tx_data21.dbf 12,582 3 4.83 1.27 9,062 3 3,482 0.10
APPS_TS_TX_DATA /oasb_data/tx_data3.dbf 1,122 0 3.15 1.57 8,339 2 5,392 0.40
APPS_TS_TX_DATA /oasb_data/tx_data4.dbf 1,153 0 2.80 1.65 8,342 2 4,240 0.34
APPS_TS_TX_DATA /oasb_data/tx_data5.dbf 2,904 1 5.01 1.43 8,025 2 4,958 0.35
APPS_TS_TX_DATA /oasb_data/tx_data6.dbf 1,217 0 3.37 1.61 7,882 2 6,154 0.41
APPS_TS_TX_DATA /oasb_data/tx_data7.dbf 2,787 1 4.45 1.27 7,911 2 6,435 0.31
APPS_TS_TX_DATA /oasb_data/tx_data8.dbf 997 0 3.00 1.64 8,570 2 7,453 0.32
APPS_TS_TX_DATA /oasb_data/tx_data9.dbf 1,090 0 2.34 1.58 7,787 2 6,406 0.26
APPS_TS_TX_IDX /oasb_data/tx_idx1.dbf 561 0 5.15 1.20 4,369 1 2,566 1.43
APPS_TS_TX_IDX /oasb_data/tx_idx10.dbf 578 0 4.81 1.19 12,200 3 2,041 0.37
APPS_TS_TX_IDX /oasb_data/tx_idx11.dbf 1,006 0 4.57 1.07 9,159 3 3,110 0.92
APPS_TS_TX_IDX /oasb_data/tx_idx12.dbf 10,774 3 5.09 1.62 10,613 3 5,618 0.14
APPS_TS_TX_IDX /oasb_data/tx_idx13.dbf 10,863 3 4.96 1.59 10,376 3 5,792 0.09
APPS_TS_TX_IDX /oasb_data/tx_idx14.dbf 10,810 3 5.11 1.47 10,391 3 4,347 0.13
APPS_TS_TX_IDX /oasb_data/tx_idx15.dbf 10,814 3 5.06 1.45 10,043 3 5,941 0.15
APPS_TS_TX_IDX /oasb_data/tx_idx16.dbf 10,757 3 5.11 1.51 9,539 3 5,557 0.14
APPS_TS_TX_IDX /oasb_data/tx_idx17.dbf 10,670 3 5.26 1.44 9,592 3 3,433 0.10
APPS_TS_TX_IDX /oasb_data/tx_idx18.dbf 10,518 3 5.20 1.64 9,460 3 4,977 0.09
APPS_TS_TX_IDX /oasb_data/tx_idx19.dbf 10,717 3 5.26 1.65 9,530 3 4,294 0.14
APPS_TS_TX_IDX /oasb_data/tx_idx2.dbf 678 0 5.15 1.10 7,954 2 8,827 0.32
APPS_TS_TX_IDX /oasb_data/tx_idx20.dbf 10,395 3 5.17 1.65 8,965 2 5,211 0.31
APPS_TS_TX_IDX /oasb_data/tx_idx21.dbf 10,531 3 5.34 1.62 9,160 3 5,760 0.12
APPS_TS_TX_IDX /oasb_data/tx_idx3.dbf 1,028 0 4.55 1.31 8,964 2 1,856 0.57
APPS_TS_TX_IDX /oasb_data/tx_idx4.dbf 1,369 0 5.81 1.49 7,575 2 1,924 0.45
APPS_TS_TX_IDX /oasb_data/tx_idx5.dbf 1,270 0 5.39 1.47 7,154 2 2,046 0.41
APPS_TS_TX_IDX /oasb_data/tx_idx6.dbf 1,259 0 5.36 1.50 6,863 2 1,975 0.55
APPS_TS_TX_IDX /oasb_data/tx_idx7.dbf 1,267 0 5.61 1.57 6,352 2 3,155 0.42
APPS_TS_TX_IDX /oasb_data/tx_idx8.dbf 1,141 0 5.57 1.42 7,376 2 3,431 0.40
APPS_TS_TX_IDX /oasb_data/tx_idx9.dbf 1,200 0 5.48 1.43 5,687 2 2,842 0.24
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte.dbf 295 0 7.15 3.97 6,389 2 778 0.05
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte2.dbf 77 0 4.81 1.91 4,614 1 516 0.06
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte3.dbf 61 0 5.25 2.11 4,538 1 360 0.03
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte4.dbf 76 0 5.13 1.79 4,612 1 487 0.00
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte5.dbf 68 0 6.47 2.10 4,145 1 310 0.00
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte6.dbf 79 0 6.20 1.95 4,333 1 319 0.09
APPS_UNDOTS1 /oasb_data/undo01.dbf 3 0 30.00 1.00 37,138 10 25,409 0.02
APPS_UNDOTS1 /oasb_data/undo02.dbf 3 0 6.67 1.00 40,560 11 23,926 0.02
APPS_UNDOTS1 /oasb_data/undo03.dbf 3 0 33.33 1.00 41,709 12 26,853 0.02
APPS_UNDOTS1 /oasb_data/undo04.dbf 5 0 8.00 1.00 41,106 11 28,384 0.04
APPS_UNDOTS1 /oasb_data/undo05.dbf 7 0 15.71 1.00 41,388 11 24,377 0.01
APPS_UNDOTS1 /oasb_data/undo06.dbf 10 0 3.00 1.00 36,909 10 29,611 0.02
APPS_UNDOTS1 /oasb_data/undo07.dbf 8 0 5.00 1.00 40,302 11 24,370 0.02
APPS_UNDOTS1 /oasb_data/undo08.dbf 9 0 4.44 1.00 37,851 10 27,108 0.03
APPS_UNDOTS1 /oasb_data/undo09.dbf 10 0 3.00 1.00 36,107 10 25,597 0.02
APPS_UNDOTS1 /oracle/visdata/undo10.dbf 8 0 2.50 1.00 33,571 9 20,020 0.02
CTXSYS /oasb_data/ctx1.dbf 55 0 4.91 2.16 459 0 0 0.00
CTXSYS /oasb_data/ctx2.dbf 107 0 7.48 1.63 3,392 1 1 0.00
ODM /oasb_data/odm.dbf 7 0 10.00 1.00 3 0 0 0.00
OLAP /oasb_data/olap.dbf 7 0 8.57 1.00 3 0 0 0.00
OWAPUB /oasb_data/owa1.dbf 7 0 5.71 1.00 3 0 0 0.00
PORTAL /oasb_data/portal.dbf 7 0 0.00 1.00 3 0 0 0.00
SYNCSERVER /oasb_data/mobile01.dbf 7 0 0.00 1.00 3 0 0 0.00
SYSAUX /oasb_data/sysaux01.dbf 194 0 3.04 1.78 104 0 0 0.00
SYSAUX /oasb_data/sysaux02.dbf 341 0 2.55 1.89 622 0 0 0.00
SYSTEM /oasb_data/sys1.dbf 557 0 5.40 1.30 463 0 58 2.24
SYSTEM /oasb_data/sys2.dbf 672 0 5.34 1.06 596 0 133 2.86
SYSTEM /oasb_data/sys3.dbf 548 0 4.91 1.03 767 0 105 6.10
SYSTEM /oasb_data/sys4.dbf 696 0 5.36 1.04 857 0 169 5.09
SYSTEM /oasb_data/sys5.dbf 524 0 5.92 1.08 950 0 53 5.09
SYSTEM /oasb_data/sys6.dbf 564 0 5.78 1.11 817 0 79 5.70
SYSTEM /oasb_data/sys7.dbf 513 0 5.63 1.04 537 0 51 6.67
SYSTEM /oasb_data/sys8.dbf 60 0 5.00 1.00 126 0 4,230 0.04
SYSTEM /oasb_data/sys9.dbf 45 0 6.22 1.00 196 0 2,597 0.07
TEMP /oracle/visdata/temp1.dbf 134 0 3.96 4.16 1,649 0 0  
TEMP /oracle/visdata/temp2.dbf 197 0 3.10 6.23 1,881 1 8 0.00
TEMP /oracle/visdata/temp3.dbf 392 0 1.94 5.25 2,109 1 8 5.00
TEMP /oracle/visdata/temp4.dbf 108 0 2.31 4.84 1,480 0 0  

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 2,012,643 100 1,786,389,648 490,028 3,717,712 0 0 831,994


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 180 108 40282 459479 1818719 47178000 1818719  
E 180 125 57335 652696 4889894 47178000 4889894  

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 458,101 5

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 20,480 1,280 30,291.52 0.17 0.00 100.00 0.00 1,048,576
E 20,480 1,280 33,203.38 0.09 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,605,512 5,605,512 0 0
64K 128K 11,697 11,697 0 0
128K 256K 1,414 1,414 0 0
256K 512K 871 871 0 0
512K 1024K 183,796 183,796 0 0
1M 2M 272,098 272,098 0 0
2M 4M 78 76 2 0
4M 8M 20 20 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
2,560 0.13 660,935.83 8,772.11 99.00 1,135
5,120 0.25 660,935.83 8,670.83 99.00 1,093
10,240 0.50 660,935.83 8,526.85 99.00 1,028
15,360 0.75 660,935.83 8,384.54 99.00 971
20,480 1.00 660,935.83 2.73 100.00 869
24,576 1.20 660,935.83 0.00 100.00 1
28,672 1.40 660,935.83 0.00 100.00 0
32,768 1.60 660,935.83 0.00 100.00 0
36,864 1.80 660,935.83 0.00 100.00 0
40,960 2.00 660,935.83 0.00 100.00 0
61,440 3.00 660,935.83 0.00 100.00 0
81,920 4.00 660,935.83 0.00 100.00 0
122,880 6.00 660,935.83 0.00 100.00 0
163,840 8.00 660,935.83 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
1,504 0.50 359 15,404 5,229,196 1.00 3,424 1.94 172,406,965
1,808 0.60 617 19,098 5,230,852 1.00 1,768 1.00 172,470,102
2,112 0.70 918 22,471 5,230,857 1.00 1,763 1.00 172,470,845
2,416 0.80 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
2,720 0.90 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
3,024 1.00 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
3,328 1.10 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
3,632 1.20 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
3,936 1.30 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
4,240 1.40 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
4,544 1.50 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
4,848 1.60 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
5,152 1.70 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
5,456 1.80 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
5,760 1.90 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060
6,064 2.01 1,131 32,100 5,230,858 1.00 1,762 1.00 172,471,060

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
4,864 0.25 42,073  
9,728 0.50 42,073  
14,592 0.75 42,073  
19,456 1.00 42,071  
24,320 1.25 42,079  
29,184 1.50 42,079  
34,048 1.75 42,081  

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB) Size Factor Est Spill Count Est Spill Time (s) Est Unspill Count Est Unspill Time (s)
16 0.50 0 0 0 0
32 1.00 0 0 0 0
48 1.50 0 0 0 0
64 2.00 0 0 0 0
80 2.50 0 0 0 0
96 3.00 0 0 0 0
112 3.50 0 0 0 0
128 4.00 0 0 0 0
144 4.50 0 0 0 0
160 5.00 0 0 0 0
176 5.50 0 0 0 0
192 6.00 0 0 0 0
208 6.50 0 0 0 0
224 7.00 0 0 0 0
240 7.50 0 0 0 0
256 8.00 0 0 0 0
272 8.50 0 0 0 0
288 9.00 0 0 0 0
304 9.50 0 0 0 0
320 10.00 0 0 0 0

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
32 0.33 10 286 264 1.00 1,763 1.00 8,284
48 0.50 10 286 264 1.00 1,763 1.00 8,284
64 0.67 10 286 264 1.00 1,763 1.00 8,284
80 0.83 10 286 264 1.00 1,763 1.00 8,284
96 1.00 10 286 264 1.00 1,763 1.00 8,284
112 1.17 10 286 264 1.00 1,763 1.00 8,284
128 1.33 10 286 264 1.00 1,763 1.00 8,284
144 1.50 10 286 264 1.00 1,763 1.00 8,284
160 1.67 10 286 264 1.00 1,763 1.00 8,284
176 1.83 10 286 264 1.00 1,763 1.00 8,284
192 2.00 10 286 264 1.00 1,763 1.00 8,284
208 2.17 10 286 264 1.00 1,763 1.00 8,284

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 568,871 104 0
undo block 211,604 4 0
undo header 44,055 2 0
segment header 3,148 0 0
1st level bmb 4,111 0 0
file header block 16 0 3
2nd level bmb 205 0 0
extent map 4 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)
TM-DML 1,661,909 1,661,915 0 24 321 13,376.75
TX-Transaction (index contention) 49,148 49,148 0 46,256 180 3.89
UL-User-defined 66,385 65,573 812 2,505 115 45.82
TX-Transaction (row lock contention) 8,649 281 8,368 266 26 96.43
RO-Multiple Object Reuse (fast object reuse) 288 288 0 32 8 245.78
TX-Transaction 1,146,570 1,146,571 0 2,007 2 0.78
HW-Segment High Water Mark 232,001 231,998 3 2,113 1 0.61
DV-Diana Versioning 22,862 22,862 0 143 1 5.27
SQ-Sequence Cache 37,399 37,399 0 2,208 1 0.23
FB-Format Block 31,766 31,766 0 501 0 0.30
TX-Transaction (allocate ITL entry) 114 114 0 44 0 0.84
PS-PX Process Reservation 3,728 3,088 640 38 0 0.11
US-Undo Segment 20,072 20,072 0 1 0 3.00

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,645.89 1,146,985 2,652 281   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
29-Dec 08:19 187,121 160,590 642 278 191 0/0 0/0/0/0/0/0
29-Dec 08:09 99,713 116,092 653 275 192 0/0 0/0/0/0/0/0
29-Dec 07:59 505,367 209,956 503 274 182 0/0 0/0/0/0/0/0
29-Dec 07:49 324,126 192,130 2,294 275 242 0/0 0/0/0/0/0/0
29-Dec 07:39 213,950 212,306 2,652 278 311 0/0 0/0/0/0/0/0
29-Dec 07:29 315,614 255,911 2,174 281 386 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,450 0.00   0 0  
AWR Alerted Metric Element list 244,611 0.00   0 0  
Consistent RBA 743,821 0.05 0.00 0 0  
FOB s.o list latch 54,228 0.02 0.18 0 0  
In memory undo latch 592,964,066 1.81 0.00 1 1,041,035 0.00
JOX SGA heap latch 1,878,086 0.00   0 0  
JS queue state obj latch 21,120 0.00   0 0  
JS slv state obj latch 175 0.00   0 0  
KMG MMAN ready and startup request latch 1,199 0.00   0 0  
KTF sga latch 12 0.00   0 1,215 0.00
KWQMN job cache list latch 12,049 0.03 1.00 0 0  
KWQP Prop Status 453 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 0     0 1,199 0.00
Memory Queue 2 0.00   0 0  
OS process 12,675 0.00   0 0  
OS process allocation 9,617 0.01 0.00 0 0  
OS process: request allocation 8,113 0.00   0 0  
PL/SQL warning settings 4,179,869 0.00   0 0  
SGA IO buffer pool latch 71,290 0.06 0.00 0 83,746 0.34
SQL memory manager latch 1 0.00   0 1,192 0.00
SQL memory manager workarea list latch 5,382,745 0.01 0.00 0 0  
Shared B-Tree 2,353 0.00   0 0  
active checkpoint queue latch 1,552,783 3.37 0.00 0 0  
active service list 42,447 0.36 0.00 0 1,330 0.00
begin backup scn array 195 0.00   0 0  
bq:time manger info latch 129 0.00   0 0  
bufq statistics 2 0.00   0 0  
cache buffer handles 21,792,185 2.33 0.00 0 0  
cache buffers chains 4,186,207,342 1.45 0.04 41 15,802,785 2.53
cache buffers lru chain 10,979,011 0.48 0.00 0 32,373,506 0.55
cache table scan latch 0     0 6,426 0.09
channel handle pool latch 314,033 0.08 0.01 0 0  
channel operations parent latch 1,272,605 0.95 0.01 0 0  
checkpoint queue latch 30,761,035 0.02 0.00 0 3,774,537 0.06
client/application info 2,020,361 0.00 0.00 0 0  
commit callback allocation 63,112 0.00   0 0  
compile environment latch 2,633,181 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 3,311,116 0.26 0.00 0 0  
dummy allocation 16,500 0.42 0.00 0 0  
enqueue hash chains 7,933,231 0.29 0.00 0 828 0.12
enqueues 4,798,527 0.26 0.00 0 0  
error message lists 1,584 1.83 0.00 0 0  
event group latch 4,041 0.00   0 0  
file cache latch 21,937 0.01 0.00 0 0  
global KZLD latch for mem in SGA 7,329 0.00   0 0  
global ctx hash table latch 17,199 0.00   0 0  
hash table column usage latch 1,689 0.00   0 11,362,541 0.00
hash table modification latch 141 0.00   0 0  
internal temp table object number allocation latc 3 0.00   0 0  
job workq parent latch 0     0 120 0.00
job_queue_processes parameter latch 119 0.00   0 0  
kks stats 9,929 0.02 0.00 0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 85,858 0.00   0 0  
kwqbsn:qsga 2,221 0.00   0 0  
lgwr LWN SCN 746,958 0.22 0.00 0 0  
library cache 334,958,768 0.73 0.00 2 3,671 0.71
library cache load lock 5,814 1.65 0.00 0 12 0.00
library cache lock 90,760,568 0.11 0.00 0 0  
library cache lock allocation 4,075,245 0.02 0.00 0 0  
library cache pin 195,886,656 0.30 0.00 0 21 0.00
library cache pin allocation 2,537,913 0.01 0.00 0 0  
list of block allocation 444,467 0.02 0.00 0 0  
loader state object freelist 242,216 0.01 0.00 0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 35 0.00   0 35 0.00
message pool operations parent latch 318,342 0.25 0.00 0 0  
messages 6,890,830 0.99 0.00 0 0  
mostly latch-free SCN 846,322 10.60 0.00 0 0  
multiblock read objects 44,404 0.00 0.00 0 0  
ncodef allocation latch 222 0.00   0 0  
object queue header heap 6,515,727 0.02 0.02 0 306,058 0.05
object queue header operation 42,005,487 0.12 0.37 1 0  
object stats modification 310,983 0.05 0.00 0 0  
parallel query alloc buffer 23,516 5.09 0.01 0 0  
parallel query stats 912 10.86 0.00 0 0  
parameter table allocation management 18,267 3.17 0.83 0 0  
post/wait queue 916,137 0.07 0.00 0 362,071 0.02
process allocation 8,162 0.17 0.93 0 4,040 0.02
process group creation 8,114 0.01 0.00 0 0  
process queue 15,146 2.03 0.00 0 0  
process queue reference 1,353,221 0.04 0.00 0 101,838 1.25
qmn task queue latch 4,799 22.32 0.90 0 0  
query server freelists 13,488 28.50 0.00 0 0  
query server process 16 0.00   0 16 0.00
redo allocation 5,245,853 8.05 0.00 0 96,579,693 4.27
redo copy 0     0 97,047,790 0.04
redo writing 4,324,983 3.81 0.00 0 0  
resmgr group change latch 905,143 0.00   0 0  
resmgr:actses active list 23,741 0.56 0.96 0 0  
resmgr:actses change group 22,646 0.00   0 0  
resmgr:free threads list 16,496 0.73 0.03 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 91,637,232 0.89 0.00 0 10 0.00
rules engine aggregate statistics 30,535 0.02 0.00 0 0  
rules engine rule set statistics 99,443 0.01 0.00 0 0  
rules engine rule statistics 38,273 0.00   0 0  
sequence cache 15,841,807 0.83 0.00 0 0  
session allocation 17,286,681 0.67 0.01 0 0  
session idle bit 73,363,316 0.02 0.00 0 0  
session state list latch 45,520 0.20 0.09 0 0  
session switching 10,860 0.00   0 0  
session timer 1,330 0.00   0 0  
shared pool 6,300,868 0.22 0.01 0 0  
shared pool sim alloc 342 0.00   0 0  
shared pool simulator 1,714,040 0.01 0.01 0 0  
sim partition latch 1 0.00   0 21,788 0.13
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,042,766 0.15 0.01 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 112 0.00   0 0  
temp lob duration state obj allocation 387 0.00   0 0  
temporary table state object allocation 9,754 0.00   0 0  
threshold alerts latch 582 0.00   0 0  
trace latch 8 0.00   0 0  
transaction allocation 91,157 0.00 0.00 0 0  
transaction branch allocation 222 0.00   0 0  
undo global data 738,990,678 1.09 0.00 0 63,808 0.29
user lock 29,502 0.01 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 4,186,207,342 60,797,762 2,212,793 58,874,761 0 0 0
In memory undo latch 592,964,066 10,726,100 9,483 10,718,098 0 0 0
undo global data 738,990,678 8,045,437 2,610 8,043,037 0 0 0
library cache 334,958,768 2,436,050 3,380 2,432,935 0 0 0
row cache objects 91,637,232 813,073 287 812,794 0 0 0
library cache pin 195,886,656 596,515 805 595,744 0 0 0
cache buffer handles 21,792,185 506,925 147 506,792 0 0 0
redo allocation 5,245,853 422,246 1,057 421,245 0 0 0
redo writing 4,324,983 164,926 73 164,853 0 0 0
sequence cache 15,841,807 131,657 50 131,608 0 0 0
session allocation 17,286,681 115,562 617 114,982 0 0 0
library cache lock 90,760,568 102,482 96 102,386 0 0 0
mostly latch-free SCN 846,322 89,683 39 89,647 0 0 0
messages 6,890,830 68,183 101 68,083 0 0 0
cache buffers lru chain 10,979,011 52,630 137 52,498 0 0 0
object queue header operation 42,005,487 52,403 19,582 33,503 0 0 0
active checkpoint queue latch 1,552,783 52,283 25 52,258 0 0 0
enqueue hash chains 7,933,231 23,121 15 23,106 0 0 0
shared pool 6,300,868 14,072 98 13,976 0 0 0
enqueues 4,798,527 12,464 24 12,440 0 0 0
channel operations parent latch 1,272,605 12,044 72 11,976 0 0 0
session idle bit 73,363,316 11,792 32 11,760 0 0 0
dml lock allocation 3,311,116 8,611 27 8,585 0 0 0
checkpoint queue latch 30,761,035 7,496 12 7,485 0 0 0
query server freelists 13,488 3,844 10 3,834 0 0 0
lgwr LWN SCN 746,958 1,614 1 1,613 0 0 0
sort extent pool 1,042,766 1,583 8 1,578 0 0 0
object queue header heap 6,515,727 1,221 26 1,195 0 0 0
parallel query alloc buffer 23,516 1,197 14 1,183 0 0 0
qmn task queue latch 4,799 1,071 961 135 0 0 0
message pool operations parent latch 318,342 796 3 793 0 0 0
library cache lock allocation 4,075,245 766 1 765 0 0 0
post/wait queue 916,137 619 1 618 0 0 0
parameter table allocation management 18,267 579 478 213 0 0 0
SQL memory manager workarea list latch 5,382,745 422 1 421 0 0 0
library cache pin allocation 2,537,913 259 1 258 0 0 0
channel handle pool latch 314,033 240 3 237 0 0 0
resmgr:actses active list 23,741 134 128 8 0 0 0
resmgr:free threads list 16,496 120 4 116 0 0 0
session state list latch 45,520 90 8 82 0 0 0
shared pool simulator 1,714,040 89 1 88 0 0 0
process allocation 8,162 14 13 1 0 0 0
FOB s.o list latch 54,228 11 2 9 0 0 0
KWQMN job cache list latch 12,049 4 4 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 2 2
In memory undo latch ktiFlush: child 0 5,733 1,544
In memory undo latch kturbk 0 2,910 4,278
In memory undo latch kticmt: child 0 474 255
In memory undo latch ktichg: child 0 326 3,220
In memory undo latch ktiTxnPoolFree 0 29 0
In memory undo latch ktbgfc 0 10 195
In memory undo latch ktiBRacquire 0 1 0
KWQMN job cache list latch kwqmnuji: update job item 0 4 4
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 1 0
active checkpoint queue latch kcbbacq: scan active checkpoints 0 25 25
active service list ksws_event: ksws event 0 1 1
cache buffer handles kcbzgs 0 75 82
cache buffer handles kcbzfs 0 72 65
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,764,457 2,290,237
cache buffers chains kcbgtcr: fast path 0 956,873 63,105
cache buffers chains kcbchg: kslbegin: call CR func 0 881,731 1,447,437
cache buffers chains kcbgtcr: kslbegin excl 0 587,076 375,379
cache buffers chains kcbrls: kslbegin 0 337,369 451,108
cache buffers chains kcbzgb: scan from tail. nowait 0 59,192 0
cache buffers chains kcbgcur: kslbegin 0 40,419 20,516
cache buffers chains kcbget: pin buffer 0 29,126 13,003
cache buffers chains kcbget: exchange rls 0 11,509 11,382
cache buffers chains kcbzwb 0 10,054 6,272
cache buffers chains kcbget: exchange 0 8,334 13,030
cache buffers chains kcbcge 0 4,744 13,302
cache buffers chains kcbnlc 0 2,395 2,462
cache buffers chains kcbso1: set no access 0 1,273 188
cache buffers chains kcb_is_private 0 412 3,769
cache buffers chains kcbgtcr: kslbegin shared 0 175 131
cache buffers chains kcbesc: escalate 0 164 121
cache buffers chains kcbnew: new latch again 0 131 7
cache buffers chains kcbbxsv 0 61 16
cache buffers chains kcbbic2 0 34 16
cache buffers chains kcbzib: exchange rls 0 25 41
cache buffers chains kcbgkcbcr 0 12 39
cache buffers chains kcb_pre_apply: kcbhq61 0 11 1,003
cache buffers chains kcbzib: multi-block read: nowait 0 11 0
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 6 0
cache buffers chains kcb_post_apply: kcbhq62 0 5 184
cache buffers chains kcb_post_apply: kcbhq63 0 5 169
cache buffers chains kcbzib: finish free bufs 0 3 10
cache buffers lru chain kcbzgws 0 89 0
cache buffers lru chain kcbbxsv: move to being written 0 17 37
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 12 0
cache buffers lru chain kcbo_link_q 0 7 1
cache buffers lru chain kcbbic2 0 6 26
cache buffers lru chain kcbzgb: posted for free bufs 0 3 36
cache buffers lru chain kcbzswcu 0 3 7
channel handle pool latch ksrchconnect() 0 13 11
channel operations parent latch ksrchdelete() 0 138 65
channel operations parent latch ksrapublish() 0 44 28
channel operations parent latch ksrsconsume() 0 27 22
channel operations parent latch ksrwait() 0 17 20
channel operations parent latch ksrchconnect() 0 13 36
channel operations parent latch ksrmfree() 0 3 71
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 6 4
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 4 5
checkpoint queue latch kcbkubc 0 1 2
checkpoint queue latch kcbswcu: Switch buffers 0 1 1
client/application info kqp327i 0 1 1
dml lock allocation ktaiam 0 23 14
dml lock allocation ktaidm 0 4 13
enqueue hash chains ksqgtl3 0 8 5
enqueue hash chains ksqrcl 0 7 9
enqueues ksqgel: create enqueue 0 13 4
enqueues ksqdel 0 7 5
enqueues ksqies 0 4 15
event range base latch No latch 0 960 961
lgwr LWN SCN kcs023 0 9 1
library cache kglpndl: child: after processing 0 1,116 71
library cache kglpnp: child 0 910 1,104
library cache kglobpn: child: 0 393 665
library cache kglScanDependency 0 303 0
library cache kglpin 0 196 70
library cache kglpndl: child: before processing 0 187 1,125
library cache kglLockCursor 0 121 184
library cache kglhdgn: child: 0 40 64
library cache kgldte: child 0 0 29 62
library cache kglic 0 21 0
library cache kglhdgc: child: 0 18 13
library cache kglivl: child 0 8 0
library cache kgldti: 2child 0 3 1
library cache kglupd: child 0 2 0
library cache kgldtld: 2child 0 1 1
library cache kglhdiv: child 0 1 0
library cache kglobld 0 1 3
library cache kglrtl 0 1 0
library cache lock kgllkdl: child: cleanup 0 56 49
library cache lock kgllkal: child: multiinstance 0 40 47
library cache lock kgllkdl: child: no lock handle 0 29 17
library cache lock allocation kgllkget 0 1 0
library cache pin kglpndl 0 366 356
library cache pin kglpnp: child 0 344 296
library cache pin kglpnal: child: alloc space 0 95 153
library cache pin allocation kglpnget 0 1 1
message pool operations parent latch ksrmalloc() 0 3 4
message pool operations parent latch ksrmfree() 0 1 2
messages ksarcv: after wait 0 54 34
messages ksarcv 0 28 57
messages ksaamb: after wakeup 0 19 10
mostly latch-free SCN kcslcu3 0 30 39
mostly latch-free SCN kcs024 0 1 0
object queue header heap kcbo_link_q:reget 0 22 2
object queue header heap kcbw_link_q:alloc 0 4 24
object queue header operation kcbo_ivbo 0 20,943 5,313
object queue header operation kcbw_link_q 0 2,214 1,697
object queue header operation kcbw_unlink_q 0 579 2,417
object queue header operation kcbo_switch_cq 0 109 1,774
object queue header operation kcbo_switch_q_bg 0 108 1,380
object queue header operation kcbo_switch_mq_bg 0 58 1,684
object queue header operation kcbo_swap_buf_bg 0 24 9,503
object queue header operation kcbo_write_q 0 16 0
object queue header operation kcbo_link_q:reget 0 10 89
object queue header operation kcbo_swap_buf 0 6 375
object queue header operation kcbo_service_ockpt 0 5 0
parallel query alloc buffer kxfpbfre 0 12 12
parallel query alloc buffer kxfpbalo 0 2 2
parameter table allocation management ksp_param_table_free 0 478 478
post/wait queue ksliwat:add:nowait 0 1 0
process allocation ksucrp 0 12 0
process allocation ksudlp 0 1 4
query server freelists kxfpobrmf 0 10 10
redo allocation kcrfw_redo_gen: redo allocation 1 0 687 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 283 783
redo allocation kcrfw_redo_gen: redo allocation 2 0 57 0
redo allocation kcrfw_redo_write: before write 0 18 130
redo allocation kcrfw_redo_write: more space 0 12 176
redo writing kcrfwcr 0 63 51
redo writing kcrfw_post: rba scn pair 0 8 0
redo writing kcrfw_cal_target_rba 0 1 6
redo writing kcrfw_post: after write 0 1 16
resmgr:actses active list kgskchclass 0 128 60
resmgr:free threads list kgskthrcreate 0 2 2
resmgr:free threads list kgskthrsod 0 2 3
row cache objects kqreqd: reget 0 225 16
row cache objects kqrpre: find obj 0 35 224
row cache objects kqreqd 0 24 47
row cache objects kqrso 0 3 0
sequence cache kdnssd 0 35 2
sequence cache kdnnxt: cached seq 0 11 4
sequence cache kdnss 0 4 44
session allocation ksuxds: KSUSFCLC not set 0 327 26
session allocation ksucri 0 61 99
session allocation ksuprc 0 52 86
session allocation ksursi 0 39 105
session allocation ksudlc 0 38 129
session allocation kxfpqidqr 0 36 69
session allocation ksuxds: not user session 0 31 85
session allocation kxfprdp 0 26 17
session allocation ksudlp 0 5 0
session allocation ksucrp 0 1 0
session allocation ksusin 0 1 1
session idle bit ksupuc: set busy 0 51 13
session idle bit ksupuc: clear busy 0 24 60
session idle bit ksuxds 0 1 3
session state list latch kpseqd 0 8 0
shared pool kghalo 0 63 55
shared pool kghupr1 0 25 24
shared pool kghfre 0 10 19
shared pool simulator kglsim_unpin_simhp 0 1 1
sort extent pool ktstdt: return extent 0 5 6
sort extent pool ktstdt: dealloc sort extent 0 3 0
undo global data kturimugur: child 0 2,295 1,827
undo global data ktudba: KSLBEGIN 0 280 778
undo global data ktucof: at start 0 27 0
undo global data ktufrbs: child 0 3 2
undo global data ktubnd:child 0 2 1
undo global data ktudnx:child 0 1 3
undo global data ktusmasp: ktugd_tuux 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
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 64,249,872 3.59
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 51,009,840 2.85
APPLSYS APPS_TS_TX_IDX FND_PROFILE_OPTION_VALUES_U1   INDEX 21,801,472 1.22
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 21,378,240 1.20
APPLSYS APPS_TS_SEED WF_ITEM_ATTRIBUTES   TABLE 21,070,832 1.18

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 35,241 7.18
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 13,670 2.79
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 12,439 2.54
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_N50   INDEX 8,739 1.78
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 7,114 1.45

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
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 16,516 24.11
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 9,368 13.67
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_N50   INDEX 9,045 13.20
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 8,852 12.92
HR APPS_ASSM_IDX PAY_RUN_RESULTS_N50   INDEX 4,239 6.19

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 19 34.55
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 17 30.91
GL APPS_ASSM_IDX GL_INTERFACE_N2   INDEX 6 10.91
GL APPS_ASSM_IDX GL_INTERFACE_N5   INDEX 3 5.45
GL APPS_ASSM_IDX GL_INTERFACE_N1   INDEX 2 3.64

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
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 202,807 41.22
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 62,945 12.79
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 31,008 6.30
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 21,348 4.34
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_N50   INDEX 18,901 3.84

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 4 0.00 0   2 1
dc_constraints 648 47.07 0   648 169
dc_free_extents 35 37.14 8 0.00 12 9
dc_global_oids 5,296,544 0.00 0   0 88
dc_histogram_data 183,089 0.63 0   0 6,233
dc_histogram_defs 320,122 2.42 0   4,042 27,342
dc_object_grants 51,509 0.05 0   0 248
dc_object_ids 8,849,205 0.01 0   57 6,579
dc_objects 183,295 0.52 0   345 8,958
dc_profiles 7,385 0.00 0   0 1
dc_rollback_segments 49,657 0.00 0   14 838
dc_segments 282,213 0.24 0   16,715 7,477
dc_sequences 47,513 0.04 0   47,513 166
dc_table_scns 64,852 0.01 0   0 14
dc_tablespace_quotas 16,611 0.09 0   215 55
dc_tablespaces 4,517,288 0.00 0   0 22
dc_used_extents 4 100.00 0   4 4
dc_usernames 420,610 0.00 0   0 92
dc_users 10,772,657 0.00 0   0 117
kqlsubheap_object 6 33.33 0   0 2
outstanding_alerts 256 0.00 0   0 41


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 1,308,058 0.01 35,708,223 -0.01 0 0
CLUSTER 56 0.00 154 0.00 0 0
INDEX 11,181 0.49 11,993 0.70 0 0
JAVA DATA 606 0.00 0   0 0
PIPE 36,252 2.55 52,491 1.76 0 0
SQL AREA 5,158 95.29 105,055,464 -0.01 2,527 312
TABLE/PROCEDURE 566,299 0.15 49,970,439 -0.01 8 0
TRIGGER 21,877 0.08 1,252,894 0.00 0 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 24,084.54   10.67 6.15 28 31 2,257 2,257
  Freeable 2,415.25 0.00 1.26 0.67 9   1,923 1,923
  SQL 1,897.85 943.01 0.84 0.52 4 22 2,250 2,248
  PL/SQL 1,678.28 134.63 0.74 0.94 3 3 2,257 2,257
  JAVA 215.87 214.94 2.57 0.52 5 7 84 84
E Other 26,517.10   11.92 6.47 38 38 2,224 2,224
  Freeable 2,601.94 0.00 1.34 0.79 14   1,937 1,937
  SQL 2,003.32 1,011.76 0.90 0.52 5 22 2,216 2,213
  PL/SQL 1,879.34 141.08 0.85 0.97 3 3 2,224 2,224
  JAVA 203.35 202.41 2.42 0.41 5 7 84 84

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 17,062,428,672  
Fixed Size 2,229,152  
Redo Buffers 17,039,360  
Variable Size 3,319,397,472  

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 80.97 80.97 0.00
java joxlod exec hp 14.40 14.40 0.00
large PX msg pool 0.49 0.49 0.00
large free memory 15.51 15.51 0.00
shared ASH buffers 40.50 40.50 0.00
shared CCursor 41.32 64.06 55.03
shared KGLS heap 48.80 54.61 11.91
shared KTI-UNDO 57.62 57.62 0.00
shared PCursor   35.02  
shared PL/SQL MPCODE 68.83 75.31 9.41
shared event statistics per sess 68.55 68.55 0.00
shared free memory 1,132.59 542.99 -52.06
shared library cache 527.87 580.19 9.91
shared parameter table block 41.44 41.05 -0.93
shared sql area 405.29 861.33 112.52
shared trace buffer 35.69 35.81 0.35
streams free memory 31.99 31.99 0.00
  buffer_cache 16,272.00 16,272.00 0.00
  fixed_sga 2.13 2.13 0.00
  log_buffer 16.25 16.25 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session Type CPU Time User I/O Time Sys I/O Time
QMON Slaves 20,218,888 239,046 0
QMON Coordinator 1,340,422 0 0

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

Queue Schema and Name Incoming per second Outgoing per second Spilled per second Diff Pct Spilled
APPLSYS.WF_CONTROL 0 0 0 0

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

Ruleset Name Evals Fast Evals SQL Execs CPU Time Elapsed Time
APPLSYS.WF_DEFERRED_R 21,660 0 0 141 151
APPLSYS.WF_DEFERRED_QUEUE_M_R 7,737 0 7,737 98 116
APPLSYS.WF_JAVA_DEFERRED_R 1,126 0 0 5 12
SYS.ALERT_QUE_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

Parameter Name Begin value End value (if different)
O7_DICTIONARY_ACCESSIBILITY FALSE   
_b_tree_bitmap_plans FALSE   
_fast_full_scan_enabled FALSE   
_like_with_bind_as_equality TRUE   
_sort_elimination_cost_ratio 5   
_sqlexec_progression_cost 2147483647   
_swrf_mmon_dbfus FALSE   
_swrf_mmon_flush FALSE   
_system_trig_enabled TRUE   
aq_tm_processes 1   
background_dump_dest /oracle/visdb/10.2.0/admin/VIS/bdump   
compatible 10.2.0.3   
control_files /oracle/visdata/cntrl01.dbf, /oracle/visdata/cntrl02.dbf, /oracle/visdata/cntrl03.dbf   
core_dump_dest /oracle/visdb/10.2.0/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_file_multiblock_read_count 8   
db_files 130   
db_name VIS   
db_writer_processes 3   
dml_locks 10000   
fast_start_mttr_target 180   
filesystemio_options setall   
hpux_sched_noage 178   
java_pool_size 67108864   
job_queue_processes 2   
lock_sga TRUE   
log_buffer 16777216   
log_checkpoint_timeout 1200   
log_checkpoints_to_alert TRUE   
max_dump_file_size unlimited   
nls_comp binary   
nls_date_format DD-MON-RR   
nls_language american   
nls_length_semantics BYTE   
nls_numeric_characters .,   
nls_sort binary   
nls_territory america   
olap_page_pool_size 4194304   
open_cursors 1000   
optimizer_secure_view_merging FALSE   
parallel_max_servers 16   
pga_aggregate_target 21474836480   
plsql_code_type INTERPRETED   
plsql_native_library_dir /oracle/visdb/10.2.0/native   
plsql_native_library_subdir_count 300   
plsql_optimize_level 2   
processes 3900   
remote_login_passwordfile EXCLUSIVE   
replication_dependency_tracking FALSE   
session_cached_cursors 500   
sessions 7800   
sga_target 20401094656   
shared_pool_reserved_size 314572800   
shared_pool_size 3154116608   
timed_statistics TRUE   
trace_enabled FALSE   
undo_management AUTO   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /oracle/visdb/10.2.0/admin/VIS/udump   
utl_file_dir /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report