Oracle
Sitefinder
    WorldwideChange Country, Oracle Worldwide Web Sites
Secure Search

AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
VIS200195696VIS1110.2.0.3.0YEShprac1.ebs.hp.com

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:108-Mar-08 07:49:591900 149.3
End Snap:208-Mar-08 08:50:081877 157.4
Elapsed:  60.16 (mins)  
DB Time:  398.18 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 22,480M 22,464MStd Block Size: 8K
Shared Pool Size: 3,008M 3,024MLog Buffer: 30,696K

Load Profile

Per SecondPer Transaction
Redo size: 8,410,885.89 51,046.05
Logical reads: 398,665.10 2,419.52
Block changes: 51,136.22 310.35
Physical reads: 46.07 0.28
Physical writes: 834.30 5.06
User calls: 4,409.64 26.76
Parses: 2,361.66 14.33
Hard parses: 1.20 0.01
Sorts: 2,445.26 14.84
Logons: 2.30 0.01
Executes: 20,348.34 123.50
Transactions: 164.77 

% Blocks changed per Read: 12.83Recursive Call %: 89.05
Rollback per transaction %: 8.51Rows per Sort: 8.95

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95Redo NoWait %: 100.00
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 99.80Soft Parse %: 99.95
Execute to Parse %: 88.39Latch Hit %: 98.90
Parse CPU to Parse Elapsd %: 87.37% Non-Parse CPU: 97.19

Shared Pool Statistics

BeginEnd
Memory Usage %: 71.13 78.64
% SQL with executions>1: 82.02 79.70
% Memory for SQL w/exec>1: 54.48 44.85

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  21,366  89.4 
gc buffer busy 30,512 500 16 2.1Cluster
log file sync 184,651 409 2 1.7Commit
log file parallel write 529,127 281 1 1.2System I/O
db file sequential read 76,685 254 3 1.1User I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 81.89 0.50
Global Cache blocks served: 116.16 0.70
GCS/GES messages received: 651.44 3.95
GCS/GES messages sent: 695.37 4.22
DBWR Fusion writes: 9.34 0.06
Estd Interconnect traffic (KB) 1,847.45 

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 99.97
Buffer access - remote cache %: 0.02
Buffer access - disk %: 0.01

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1
Avg global cache cr block receive time (ms): 0.9
Avg global cache current block receive time (ms): 0.7
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 15.0
Avg global cache cr block flush time (ms): 1.5
Avg global cache current block pin time (ms): 4,267.9
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 1.4
Avg global cache current block flush time (ms): 32.6

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): -1,852.5
Avg message sent queue time on ksxp (ms): 0.2
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 24.84
% of indirect sent messages: 32.67
% of flow controlled messages: 42.49

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 23891s
  • Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
  • Ordered by % or DB time desc, Statistic name
Statistic NameTime (s)% of DB Time
DB CPU 21,365.87 89.43
sql execute elapsed time 20,556.77 86.04
PL/SQL execution elapsed time 5,397.21 22.59
inbound PL/SQL rpc elapsed time 5,310.42 22.23
parse time elapsed 742.41 3.11
Java execution elapsed time 665.41 2.79
hard parse elapsed time 452.10 1.89
sequence load elapsed time 43.21 0.18
repeated bind elapsed time 38.84 0.16
connection management call elapsed time 15.23 0.06
PL/SQL compilation elapsed time 4.84 0.02
hard parse (sharing criteria) elapsed time 4.42 0.02
hard parse (bind mismatch) elapsed time 1.16 0.00
DB time 23,890.99  
background elapsed time 1,381.12  
background cpu time 759.41  

Back to Wait Events Statistics
Back to Top

Wait Class

  • s - second
  • cs - centisecond - 100th of a second
  • ms - millisecond - 1000th of a second
  • us - microsecond - 1000000th of a second
  • ordered by wait time desc, waits desc
Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Cluster 687,623 0.06 810 1 1.16
Commit 184,651 0.00 409 2 0.31
System I/O 762,367 0.00 396 1 1.28
Other 1,263,149 47.53 387 0 2.12
User I/O 101,412 0.00 368 4 0.17
Concurrency 1,899,307 0.29 326 0 3.19
Application 43,198 1.03 268 6 0.07
Network 20,238,432 0.00 106 0 34.03
Configuration 48,133 12.99 60 1 0.08

Back to Wait Events Statistics
Back to Top

Wait Events

  • s - second
  • cs - centisecond - 100th of a second
  • ms - millisecond - 1000th of a second
  • us - microsecond - 1000000th of a second
  • ordered by wait time desc, waits desc (idle events last)
EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
gc buffer busy 30,512 1.35 500 16 0.05
log file sync 184,651 0.00 409 2 0.31
log file parallel write 529,127 0.00 281 1 0.89
db file sequential read 76,685 0.00 254 3 0.13
enq: TX - row lock contention 1,111 24.21 135 122 0.00
enq: UL - contention 33,561 0.49 122 4 0.06
db file parallel write 222,170 0.00 107 0 0.37
wait for scn ack 329,129 0.00 95 0 0.55
gc cr block busy 31,663 0.00 80 3 0.05
gc cr block 2-way 146,774 0.00 72 0 0.25
db file scattered read 11,427 0.00 71 6 0.02
latch: cache buffers chains 1,058,740 0.00 69 0 1.78
enq: TX - index contention 31,315 0.05 69 2 0.05
gcs log flush sync 67,040 16.51 62 1 0.11
cursor: pin S wait on X 5,796 94.81 60 10 0.01
buffer busy waits 693,019 0.00 59 0 1.17
SQL*Net more data from client 1,945,167 0.00 56 0 3.27
enq: HW - contention 34,057 0.00 55 2 0.06
read by other session 12,258 0.00 40 3 0.02
DFS lock handle 14,320 0.46 40 3 0.02
gc current block 2-way 75,781 0.00 36 0 0.13
row cache lock 86,224 0.00 35 0 0.14
cr request retry 54 83.33 34 634 0.00
enq: FB - contention 20,946 0.08 33 2 0.04
enq: TX - contention 3,357 0.39 30 9 0.01
gc current multi block request 254,266 0.00 30 0 0.43
gc current grant busy 34,252 0.00 28 1 0.06
SQL*Net more data to client 1,539,385 0.00 27 0 2.59
global enqueue expand wait 2,543 84.00 24 9 0.00
SQL*Net message to client 16,753,880 0.00 24 0 28.17
gc cr multi block request 45,772 0.00 17 0 0.08
library cache load lock 732 0.00 15 21 0.00
gc current block busy 1,356 0.00 15 11 0.00
gc current grant 2-way 33,586 0.00 12 0 0.06
gc cr grant 2-way 33,203 0.00 11 0 0.06
enq: RO - fast object reuse 100 11.00 8 80 0.00
gcs drm freeze in enter server mode 31 12.90 8 254 0.00
enq: US - contention 10,440 0.00 7 1 0.02
control file sequential read 9,355 0.00 7 1 0.02
latch: library cache 10,305 0.00 7 1 0.02
latch: object queue header operation 14,735 0.00 6 0 0.02
gc recovery quiesce 12 50.00 6 489 0.00
library cache lock 4,354 0.02 5 1 0.01
kksfbc child completion 103 84.47 4 42 0.00
enq: SQ - contention 7,567 0.00 4 1 0.01
PX Deq Credit: send blkd 13,689 40.02 4 0 0.02
name-service call wait 68 0.00 4 59 0.00
SQL*Net break/reset to client 8,332 0.00 3 0 0.01
ksxr poll remote instances 273,781 58.91 3 0 0.46
latch: undo global data 7,595 0.00 3 0 0.01
enq: DV - contention 1,170 0.00 3 2 0.00
PX Deq: Signal ACK 587 39.18 3 5 0.00
PX Deq: reap credit 151,357 81.91 3 0 0.25
LGWR wait for redo copy 35,329 0.00 3 0 0.06
wait list latch free 228 0.00 3 11 0.00
reliable message 637 0.00 2 4 0.00
library cache pin 3,838 0.00 2 1 0.01
latch: library cache pin 3,515 0.00 2 1 0.01
control file parallel write 1,715 0.00 2 1 0.00
os thread startup 22 0.00 2 102 0.00
buffer deadlock 38,835 98.66 2 0 0.07
gc quiesce wait 3 66.67 2 652 0.00
direct path read 426 0.00 2 4 0.00
latch: redo allocation 3,151 0.00 2 1 0.01
latch: cache buffers lru chain 1,102 0.00 2 1 0.00
latch free 2,757 0.00 1 0 0.00
enq: WF - contention 11 18.18 1 104 0.00
PX qref latch 170,692 99.89 1 0 0.29
latch: session allocation 1,319 0.00 1 1 0.00
CGS wait for IPC msg 87,206 99.83 1 0 0.15
enq: TX - allocate ITL entry 148 0.00 1 5 0.00
enq: PS - contention 1,192 0.00 1 1 0.00
latch: ges resource hash list 1,970 0.00 1 0 0.00
gc remaster 11 0.00 1 53 0.00
local write wait 216 0.00 1 2 0.00
rdbms ipc reply 1,177 0.00 0 0 0.00
gc cr block congested 203 0.00 0 2 0.00
latch: row cache objects 709 0.00 0 0 0.00
gc current retry 23 0.00 0 11 0.00
gc current split 9 0.00 0 29 0.00
latch: library cache lock 347 0.00 0 1 0.00
latch: gcs resource hash 452 0.00 0 0 0.00
db file parallel read 12 0.00 0 11 0.00
enq: TT - contention 175 0.00 0 1 0.00
enq: CF - contention 144 0.00 0 1 0.00
cursor: pin S 4,143 0.00 0 0 0.01
latch: redo writing 94 0.00 0 1 0.00
latch: messages 452 0.00 0 0 0.00
latch: object queue header heap 119 0.00 0 1 0.00
latch: enqueue hash chains 100 0.00 0 1 0.00
gc current block congested 55 0.00 0 2 0.00
ges global resource directory to be frozen 7 100.00 0 11 0.00
latch: KCL gc element parent latch 217 0.00 0 0 0.00
gc cr grant congested 45 0.00 0 1 0.00
enq: TO - contention 88 0.00 0 1 0.00
latch: shared pool 166 0.00 0 0 0.00
gc current grant congested 39 0.00 0 1 0.00
latch: cache buffer handles 255 0.00 0 0 0.00
write complete waits 5 0.00 0 10 0.00
IPC send completion sync 242 28.51 0 0 0.00
enq: TM - contention 94 0.00 0 1 0.00
enq: TS - contention 15 0.00 0 2 0.00
kjbdrmcvtq lmon drm quiesce: ping completion 7 42.86 0 4 0.00
latch: checkpoint queue latch 49 0.00 0 1 0.00
gc cr failure 55 0.00 0 0 0.00
SGA: allocation forcing component growth 2 50.00 0 11 0.00
latch: parallel query alloc buffer 10 0.00 0 2 0.00
undo segment extension 6,256 99.92 0 0 0.01
enq: TA - contention 25 0.00 0 0 0.00
enq: KM - contention 11 0.00 0 1 0.00
enq: MD - contention 10 0.00 0 1 0.00
cursor: mutex S 129 0.00 0 0 0.00
cursor: mutex X 96 0.00 0 0 0.00
enq: MW - contention 2 0.00 0 4 0.00
enq: CU - contention 3 0.00 0 2 0.00
lock deadlock retry 8 100.00 0 1 0.00
enq: ST - contention 6 0.00 0 1 0.00
KJC: Wait for msg sends to complete 35 0.00 0 0 0.00
direct path write 344 0.00 0 0 0.00
ges2 LMON to wake up LMD - mrcvr 9 0.00 0 0 0.00
lock escalate retry 13 61.54 0 0 0.00
gc cr disk read 3 0.00 0 0 0.00
enq: DR - contention 2 0.00 0 0 0.00
enq: DL - contention 3 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
SQL*Net message from client 16,753,905 0.00 3,494,303 209 28.17
pipe get 29,507 14.40 21,078 714 0.05
Streams AQ: waiting for messages in the queue 2,806 98.08 15,187 5412 0.00
gcs remote message 2,347,746 73.23 13,792 6 3.95
PX Idle Wait 3,907 82.19 8,291 2122 0.01
Streams AQ: qmn coordinator idle wait 268 47.76 3,531 13175 0.00
DIAG idle wait 17,866 0.00 3,523 197 0.03
Streams AQ: qmn slave idle wait 140 0.00 3,519 25138 0.00
ges remote message 284,709 57.95 3,503 12 0.48
Streams AQ: waiting for time management or cleanup tasks 1 100.00 2,936 2935724 0.00
PL/SQL lock timer 228 96.49 2,476 10858 0.00
PX Deq: Execution Msg 15,953 8.88 304 19 0.03
PX Deq: Parse Reply 1,018 16.60 13 13 0.00
PX Deq: Msg Fragment 8,959 0.12 12 1 0.02
PX Deq: Execute Reply 11,678 29.49 11 1 0.02
PX Deq: Table Q Normal 8,589 30.12 5 1 0.01
PX Deq: Join ACK 1,251 38.85 1 0 0.00
PX Deq Credit: need buffer 1,301 36.74 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 268 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

  • ordered by wait time desc, waits desc (idle events last)
EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 529,129 0.00 281 1 0.89
events in waitclass Other 816,323 31.81 172 0 1.37
db file parallel write 222,143 0.00 107 0 0.37
control file sequential read 7,394 0.00 6 1 0.01
control file parallel write 1,715 0.00 2 1 0.00
direct path read 426 0.00 2 4 0.00
enq: HW - contention 1,224 0.00 1 0 0.00
row cache lock 265 0.00 0 1 0.00
latch: redo writing 94 0.00 0 1 0.00
gc current block 2-way 154 0.00 0 0 0.00
gc cr block 2-way 171 0.00 0 0 0.00
buffer busy waits 102 0.98 0 0 0.00
library cache lock 86 0.00 0 1 0.00
latch: cache buffers chains 189 0.00 0 0 0.00
gc current grant busy 27 0.00 0 1 0.00
enq: RO - fast object reuse 17 0.00 0 1 0.00
db file sequential read 2 0.00 0 4 0.00
enq: TM - contention 12 0.00 0 0 0.00
latch: row cache objects 17 0.00 0 0 0.00
direct path write 242 0.00 0 0 0.00
enq: ST - contention 1 0.00 0 2 0.00
gc cr multi block request 6 0.00 0 0 0.00
gc current grant 2-way 7 0.00 0 0 0.00
latch: shared pool 7 0.00 0 0 0.00
rdbms ipc message 1,342,845 4.63 37,486 28 2.26
gcs remote message 2,347,698 73.23 13,792 6 3.95
Streams AQ: qmn coordinator idle wait 268 47.76 3,531 13175 0.00
DIAG idle wait 17,865 0.00 3,523 197 0.03
Streams AQ: qmn slave idle wait 140 0.00 3,519 25138 0.00
pmon timer 2,596 98.65 3,518 1355 0.00
ges remote message 284,700 57.94 3,503 12 0.48
smon timer 152,857 0.00 3,494 23 0.26
Streams AQ: waiting for time management or cleanup tasks 1 100.00 2,936 2935724 0.00
PX Deq: Parse Reply 30 40.00 0 1 0.00
PX Deq: Join ACK 28 42.86 0 1 0.00
PX Deq: Execute Reply 24 25.00 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 268 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 2,356,136
IDLE_TIME 3,275,525
IOWAIT_TIME 60,003
NICE_TIME 0
SYS_TIME 162,470
USER_TIME 2,144,559
LOAD 4
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 19,811,724
NUM_CPUS 16
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

  • ordered by DB Time
Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
VIS 23,775.50 21,304.20 125,974 1,434,120,789
SYS$USERS 114.30 60.50 39,992 3,734,084
SYS$BACKGROUND 0.00 0.00 428 1,041,240

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

  • Wait Class info for services in the Service Statistics section.
  • Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
  • Time Waited (Wt Time) in centisecond (100th of a second)
Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
VIS 94361 35301 1889250 32324 0 0 20219039 10590
SYS$USERS 6385 1295 9353 212 0 0 5699 2
SYS$BACKGROUND 670 173 711 35 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
2,011 1,942 10 201.06 8.42 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,104 1,050 302 3.65 4.62 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
740 649 16 46.28 3.10 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
660 594 1,441 0.46 2.76 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
487 481 6,015 0.08 2.04 a957tvxz9w038 icx.por.req.server.RequisitionAM BEGIN :1 := por_util_pkg.inter...
471 459 57,198 0.01 1.97 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
424 409 57,207 0.01 1.77 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
407 356 5,000 0.08 1.70 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
381 355 63,648 0.01 1.59 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
372 359 57,182 0.01 1.56 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
360 356 64,368 0.01 1.51 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
326 318 8 40.73 1.36 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
318 159 10,000 0.03 1.33 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
292 285 9 32.47 1.22 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
241 240 157,435 0.00 1.01 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
1,942 2,011 10 194.22 8.42 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,050 1,104 302 3.48 4.62 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
649 740 16 40.57 3.10 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
594 660 1,441 0.41 2.76 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
481 487 6,015 0.08 2.04 a957tvxz9w038 icx.por.req.server.RequisitionAM BEGIN :1 := por_util_pkg.inter...
459 471 57,198 0.01 1.97 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
409 424 57,207 0.01 1.77 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
359 372 57,182 0.01 1.56 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
356 407 5,000 0.07 1.70 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
356 360 64,368 0.01 1.51 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
355 381 63,648 0.01 1.59 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
318 326 8 39.73 1.36 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
285 292 9 31.67 1.22 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
240 241 157,435 0.00 1.01 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
159 318 10,000 0.02 1.33 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • Total Buffer Gets: 1,438,983,277
  • Captured SQL account for 22.4% of Total
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
173,123,758 10 17,312,375.80 12.03 1942.16 2010.55 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
81,343,316 16 5,083,957.25 5.65 649.19 740.47 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
53,265,714 8 6,658,214.25 3.70 225.87 231.61 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
46,275,612 302 153,230.50 3.22 1050.40 1103.77 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
45,656,177 9 5,072,908.56 3.17 285.01 292.25 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
45,212,690 59 766,316.78 3.14 160.24 160.70 3n8tvc1tsqua0 WSHINTERFACES SELECT DISTINCT WTS.STOP_ID FR...
38,063,631 9 4,229,292.33 2.65 200.30 201.44 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
37,850,809 57,207 661.65 2.63 408.91 423.50 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
36,589,386 5,000 7,317.88 2.54 356.23 406.72 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
27,271,765 1,441 18,925.58 1.90 594.21 660.16 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
26,405,432 10,000 2,640.54 1.84 159.04 317.76 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
23,264,416 57,198 406.73 1.62 459.24 470.53 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
22,456,750 57,182 392.72 1.56 358.90 372.28 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
20,545,952 153,884 133.52 1.43 151.83 152.18 bcym7s1bp0wxs OEXOETEL SELECT WIA.NAME FROM WF_ITEM_A...
17,290,303 8 2,161,287.88 1.20 317.82 325.83 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
17,023,866 63,648 267.47 1.18 355.20 380.85 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
15,336,157 70,608 217.20 1.07 127.07 225.48 3vy5h9xkfv1s5 OEXOETEL INSERT INTO WF_ITEM_ATTRIBUTE_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 166,293
  • Captured SQL account for 28.1% of Total
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
45,453 10,000 4.55 27.33 159.04 317.76 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
381 8 47.63 0.23 2.98 4.55 gux0k2wpv33y8 RAXMTR select /*+ parallel(t, 16) par...
312 69,999 0.00 0.19 17.30 18.50 97mt0g20bcfc3 PYUSLV begin ...
189 397 0.48 0.11 1.33 1.53 azfadzhfxbxj3 ARXTWMAI SELECT ROW_ID, APBA_INACTIVE_D...
188 8 23.50 0.11 317.82 325.83 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
132 9 14.67 0.08 285.01 292.25 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
102 267,796 0.00 0.06 18.30 18.64 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
101 171,605 0.00 0.06 97.18 98.80 25bkagv1j2xf7 WSHFRREL INSERT INTO MTL_MATERIAL_TRAN...
88 57,736 0.00 0.05 5.11 5.17 a40f9h91scg23 icx.por.req.server.RequisitionAM select to_char(CODE_COMBINATIO...
76 16 4.75 0.05 649.19 740.47 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

  • Total Executions: 73,447,417
  • Captured SQL account for 17.3% of Total
Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
2,692,250 1,939,565 0.72 0.00 0.00 6cjfxb1c4kx16 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_ID, APP...
2,401,287 989,446 0.41 0.00 0.00 c4y7jp0q2awbf ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
1,039,392 1,039,374 1.00 0.00 0.00 bc7t6t6jfx2n7 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT VERSION FROM FND_CACHE_...
887,681 887,664 1.00 0.00 0.00 cd9mbmqyf4qhp OEXOETEL UPDATE WF_ITEM_ACTIVITY_STATUS...
830,513 830,302 1.00 0.00 0.00 gnhmcahkmrnzs OEXOETEL INSERT INTO WF_ITEM_ACTIVITY_S...
267,796 212,641 0.79 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
230,267 226,625 0.98 0.00 0.00 0b85w9vv0hbt1 ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ATTRIBUTE_VALUE...
213,012 212,997 1.00 0.00 0.00 9bbak9qpg1c7x OEXOETEL INSERT INTO WF_ITEM_ATTRIBUTE_...
192,910 192,908 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
174,573 174,570 1.00 0.00 0.00 0w785m9gmw41a ? @blade1.ebs.hp.com (TNS V1-V3) SELECT USERENV('SESSIONID') FR...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

  • Total Parse Calls: 8,524,422
  • Captured SQL account for 38.9% of Total
Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
267,795 267,796 3.14 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
192,910 192,910 2.26 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
171,364 171,551 2.01 6gnth2mfbs2nq WSHFRREL declare v_ret number := 0...
159,911 2,692,250 1.88 6cjfxb1c4kx16 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_ID, APP...
157,435 157,435 1.85 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
155,096 2,401,287 1.82 c4y7jp0q2awbf ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
138,849 138,850 1.63 b38b6kx0rztph ap.oie.server.WebExpensesAM select M.ERROR_MESSAGE from ...
121,087 121,598 1.42 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
114,297 114,406 1.34 1c0b7sas42w2z WSHFRREL SELECT NVL(ITEM_COST, 0), ...
101,292 101,343 1.19 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
95,316 101,347 1.12 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
95,314 95,330 1.12 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
95,309 95,326 1.12 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
89,476 89,477 1.05 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

  • Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
11,342,138 8 0.36 9pqmabwh0shda RAXMTR select /*+ parallel(t, 16) par...
9,452,366 8 0.30 8321yku30qgwp RAXMTR select /*+ parallel(t, 16) par...
3,405,153 8 0.11 gux0k2wpv33y8 RAXMTR select /*+ parallel(t, 16) par...
1,123,554 171,605 0.04 25bkagv1j2xf7 WSHFRREL INSERT INTO MTL_MATERIAL_TRAN...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

  • Only Statements with Version Count greater than 20 are displayed
Version Count Executions SQL IdSQL ModuleSQL Text
21 6 5jxwda6s8nvc7   select tablespace_id, rfno, ...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
76.87 62.30 123.40 49.19 82,267 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
41.54 6.29 660.16 594.21 1,441 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
37.08 16.44 225.48 127.07 70,608 3vy5h9xkfv1s5 OEXOETEL INSERT INTO WF_ITEM_ATTRIBUTE_...
24.10 3.26 740.47 649.19 16 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
19.88 5.22 380.85 355.20 63,648 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
16.76 8.42 199.10 159.95 830,513 gnhmcahkmrnzs OEXOETEL INSERT INTO WF_ITEM_ACTIVITY_S...
15.68 1.42 1,103.77 1,050.40 302 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
12.23 0.61 2,010.55 1,942.16 10 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
10.88 5.92 183.94 165.94 171,551 6gnth2mfbs2nq WSHFRREL declare v_ret number := 0...
10.38 2.79 372.28 358.90 57,182 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
9.39 4.99 188.18 173.86 57,163 bfbyqwbr4vwms OEXOETEL begin OE_OEOL_SCH.SCHEDULE_LIN...
8.88 2.80 317.76 159.04 10,000 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
7.30 4.22 173.01 158.89 22,014 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
6.92 3.24 213.69 205.87 57,215 gzkhp7cph992f INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
6.79 1.60 423.50 408.91 57,207 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
6.73 1.43 470.53 459.24 57,198 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
4.70 2.13 220.58 201.23 1,202 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
3.18 2.09 152.54 141.12 887,681 cd9mbmqyf4qhp OEXOETEL UPDATE WF_ITEM_ACTIVITY_STATUS...
2.85 11.60 24.59 24.27 1,039,392 bc7t6t6jfx2n7 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT VERSION FROM FND_CACHE_...
2.73 2.76 98.80 97.18 171,605 25bkagv1j2xf7 WSHFRREL INSERT INTO MTL_MATERIAL_TRAN...
2.61 25.88 10.06 7.74 4,330 9hypmc3t618sc OEXOETEL SELECT ORDERED_ITEM, ORDERED_Q...
2.58 11.77 21.94 13.89 213,012 9bbak9qpg1c7x OEXOETEL INSERT INTO WF_ITEM_ATTRIBUTE_...
2.29 0.78 292.25 285.01 9 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
2.15 5.95 36.19 34.18 57,192 d0a8mm8y38yaw WSHFRREL SELECT base.revision ...
1.37 0.34 406.72 356.23 5,000 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
1.12 0.31 360.20 355.83 64,368 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
1.03 8.12 12.63 11.64 230,267 0b85w9vv0hbt1 ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ATTRIBUTE_VALUE...
0.43 0.13 325.83 317.82 8 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
0.38 0.24 160.74 150.65 18,812 8h16w67202y4g ? @blade1.ebs.hp.com (TNS V1-V3) begin fnd_global.initialize(:s...
0.36 0.07 486.51 480.60 6,015 a957tvxz9w038 icx.por.req.server.RequisitionAM BEGIN :1 := por_util_pkg.inter...
0.29 0.16 180.21 179.41 57,195 gnng1rmpjxzsx WSHINTERFACE begin OE_CLOSE_WF.CLOSE_LINE (...
0.16 0.40 38.90 37.94 242 3c086a4sm741b ARXAGE select decode ( UPPER ( : p_or...
0.15 0.24 61.10 60.54 240 2fr5f5xzmffd8 POXPRPOP SELECT decode ( : P_sortby , ...
0.13 0.63 20.21 20.08 57,194 cw171rvngr1w9 WSHINTERFACE begin OE_FLEX_COGS_PUB.GET_COS...
0.12 0.67 18.50 17.30 69,999 97mt0g20bcfc3 PYUSLV begin ...
0.11 13.36 0.84 0.32 9 cbvr877xhfjvx PYUSLV SELECT PPT.CATEGORY, UPPER(TR...
0.10 2.22 4.55 2.98 8 gux0k2wpv33y8 RAXMTR select /*+ parallel(t, 16) par...
0.09 0.05 201.44 200.30 9 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
0.09 0.49 18.64 18.30 267,796 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
0.08 1.78 4.26 4.20 70,592 gbc00q72n5n3m OEXOETEL UPDATE WF_ITEMS SET END_DATE =...
0.07 0.05 160.70 160.24 59 3n8tvc1tsqua0 WSHINTERFACES SELECT DISTINCT WTS.STOP_ID FR...
0.05 0.52 10.37 10.34 57,215 fr38pcatsbj6x INCTCW SELECT reservation_...
0.04 0.55 7.03 6.78 19,998 f87337d0g8ps6 PYUSLV SELECT DISTINCT SIT_EXISTS FRO...
0.04 0.05 70.83 70.20 2,401,287 c4y7jp0q2awbf ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
0.04 0.02 231.61 225.87 8 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
0.03 0.14 25.15 25.13 121,598 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
0.03 2.28 1.27 1.06 35,000 fcwn4vnv96315 PYUSLV SELECT STATE_CODE FROM PAY_US_...
0.03 1.88 1.53 1.33 397 azfadzhfxbxj3 ARXTWMAI SELECT ROW_ID, APBA_INACTIVE_D...
0.02 1.37 1.34 1.27 2,503 14w9t0dd89367 FNDRSRUN INSERT INTO FND_CONCURRENT_REQ...
0.01 0.16 8.75 6.24 8 8321yku30qgwp RAXMTR select /*+ parallel(t, 16) par...
0.01 0.05 11.48 11.48 173,236 29x3dahwzdj8b ? @blade1.ebs.hp.com (TNS V1-V3) SELECT U.USER_NAME, NVL(U.EMP...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0b85w9vv0hbt1UPDATE WF_ITEM_ATTRIBUTE_VALUES SET TEXT_VALUE = :B4 WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
0w785m9gmw41aSELECT USERENV('SESSIONID') FROM SYS.DUAL
0z318y6g3uagcdeclare 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 ;
14w9t0dd89367 INSERT INTO FND_CONCURRENT_REQUESTS ( REQUEST_ID, SECURITY_GROUP_ID, PHASE_CODE, STATUS_CODE, PRIORITY, PARENT_REQUEST_ID, PRIORITY_REQUEST_ID, DESCRIPTION, REQ_INFORMATION, IS_SUB_REQUEST, HAS_SUB_REQUEST, UPDATE_PROTECTED, HOLD_FLAG, ENFORCE_SERIALITY_FLAG, SINGLE_THREAD_FLAG, ARGUMENT_INPUT_METHOD_CODE, IMPLICIT_CODE, REQUEST_DATE, REQUESTED_START_DATE, REQUESTED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ORACLE_ID, CONC_LOGIN_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID, NLS_LANGUAGE, NLS_TERRITORY, NLS_NUMERIC_CHARACTERS, PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID, QUEUE_METHOD_CODE, REQUEST_CLASS_APPLICATION_ID, CONCURRENT_REQUEST_CLASS_ID, PRINT_GROUP, PRINTER, PRINT_STYLE, NUMBER_OF_COPIES, SAVE_OUTPUT_FLAG, CRM_THRSHLD, RESUBMIT_TIME, RESUBMIT_INTERVAL, RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL_TYPE_CODE, RESUBMIT_END_DATE, RESUBMITTED, CRITICAL, REQUEST_TYPE, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, STALE_DATE, CANCEL_OR_HOLD, OUTPUT_FILE_TYPE, NLS_COMPLIANT, CD_ID, REQUEST_LIMIT, INCREMENT_DATES, ENABLE_TRACE, OPS_INSTANCE, ARGUMENT_TEXT, NUMBER_OF_ARGUMENTS, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10, ARGUMENT11, ARGUMENT12, ARGUMENT13, ARGUMENT14, ARGUMENT15, ARGUMENT16, ARGUMENT17, ARGUMENT18, ARGUMENT19, ARGUMENT20, ARGUMENT21, ARGUMENT22, ARGUMENT23, ARGUMENT24, ARGUMENT25) SELECT :B73 , :B72 , :B71 , DECODE (:B70 , 'A', 'A', 'Z', 'Z', DECODE(FCP.QUEUE_METHOD_CODE, 'B', 'Q', DECODE (:B52 , 'Y', 'Q', DECODE(:B33 , 'Y', 'Q', 'I')))), DECODE (FCP.QUEUE_CONTROL_FLAG, 'Y', 0, DECODE (:B69 , NULL, 50, :B69 )), DECODE (:B61 , 0, NULL, :B61 ), :B68 , :B67 , NULL, :B66 , 'N', :B65 , :B64 , 'Y', :B52 , 'S', :B63 , SYSDATE, DECODE (:B62 , '', (SYSDATE - :B60 ), GREATEST (:B62 , DECODE (:B61 , 0, (SYSDATE - :B60 ), FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001')))), :B59 , SYSDATE, :B59 , :B58 , ORACLE_ID, :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , FA.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_ID, DECODE(:B33 , 'Y', 'B', DECODE(:B52 , 'N', FCP.QUEUE_METHOD_CODE, 'B')), FCP.CLASS_APPLICATION_ID, FCP.CONCURRENT_CLASS_ID, :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , DECODE (:B45 , '', NULL, TO_CHAR (FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001' || :B45 ), 'HH24:MI:SS')), DECODE (:B44 , '', NULL, :B44 ), :B43 , :B42 , :B41 , 'N', :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , FCP.OUTPUT_FILE_TYPE, FCP.NLS_COMPLIANT, :B34 , :B33 , :B32 , FCP.ENABLE_TRACE, :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 FROM FND_APPLICATION FA, FND_CONCURRENT_PROGRAMS FCP, FND_ORACLE_USERID WHERE ORACLE_USERNAME = :B3 AND FCP.ENABLED_FLA G = 'Y' AND (FCP.APPLICATION_ID = FA.APPLICATION_ID AND CONCURRENT_PROGRAM_NAME = UPPER (:B2 )) AND FA.APPLICATION_SHORT_NAME = UPPER (:B1 )
162ttnv4ubqun begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1du9v021t8m46 insert into gl_interface(created_by, date_created, status, actual_flag, group_id, set_of_books_id, user_je_source_name, user_je_category_name, accounting_date, subledger_doc_sequence_id, subledger_doc_sequence_value, ussgl_transaction_code, currency_code, code_combination_id, entered_dr, entered_cr, accounted_dr, accounted_cr, reference1, reference10, reference21, reference22, reference23, reference24, reference25, reference26, reference27, reference28, reference29, reference30, request_id)select /*+ ORDERED USE_NL (l ctlgd ct ctt cust) INDEX (ctlgd, RA_CUST_TRX_LINE_GL_DIST_N5) +*/ :b0 created_by , trunc(sysdate ) date_created , :b1 status , :b2 actual_flag , :b3 group_id , :b4 sob_id , :b5 source_name , decode(ctt.type, 'CM', :b6, 'DM', :b7, 'CB', :b8, :b9) category , ctlgd.gl_date gl_date , ct.doc_sequence_id doc_seqid , ct.doc_sequence_value doc_num , ctlgd.ussgl_transaction_code ussgl , ct.invoice_currency_code currency , ctlgd.code_combination_id ccid , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null )) entered_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), decode(sign(nvl(ctlgd.amount , 0)), (-1), null , nvl(ctlgd.amount, 0))) entered_cr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null )) acctd_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0))) acctd_cr , (:b10||to_char(:b3)) ref1 , decode(:b12, 'Y', null , ((((((l.meaning||' ')||:b13)||decode(ctt.type, 'CB', :b14, 'CM', :b15, 'DEP', :b16, 'DM', :b17, 'GUAR', :b18, 'INV', :b19, null ))||' ')||ct.trx_number)||:b20)) ref10 , to_char(:b3) ref21 , to_char(ct.customer_trx_id) ref22 , to_char(ctlgd.cust_trx_line_gl_dist_id) ref23 , ct.trx_number ref24 , cust.account_number ref25 , 'CUSTOMER' ref26 , to_char(ct.bill_to_customer_id) ref27 , decode(ctt.type, 'CM', 'CM', 'DM', 'DM', 'CB', 'CB', 'INV') ref28 , (decode(ctt.type, 'CM', 'CM_', 'DM', 'DM_', 'CB', 'CB_', 'INV_')||ctlgd.account_class) ref29 , 'RA_CUST_TRX_LINE_GL_DIST' ref30 , :b22 from ra_cust_trx_line_gl_dist ctlgd , ra_cust_trx_line_gl_dist rec , ar_lookups l , ra_customer_trx ct , ra_cust_trx_types ctt , hz_cust_accounts cust where ((((((((((((((((ctlgd.cust_trx_line_gl_dist_id+0)<: b23 and ctlgd.gl_date between to_date((:b24||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b25||' 23:59:59'), 'DD-MON-RR HH24:MI:SS')) and ctlgd.posting_control_id=(-3)) and ctlgd.set_of_books_id=:b4) and ctlgd.account_set_flag='N') and ctlgd.customer_trx_id=ct.customer_trx_id) and l.lookup_type='AUTOGL_TYPE') and l.lookup_code=nvl(ctlgd.account_class, 'REV')) and ct.complete_flag='Y') and ct.bill_to_customer_id=cust.cust_account_id) and ct.cust_trx_type_id=ctt.cust_trx_type_id) and ctlgd.customer_trx_id=rec.customer_trx_id) and rec.account_class='REC') and rec.latest_rec_flag='Y') and rec.account_set_flag='N') and 'NOT_MFAR_TYPE'=AR_MFAR_PKG.ar_mfar_trx_post(ctlgd.customer_trx_id, :b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b12, :b13, :b20, :b14, :b15, :b17, :b16, :b18, :b19, :b24, :b25, :b23))
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)
29x3dahwzdj8bSELECT 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 )
2fr5f5xzmffd8 SELECT decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_last_name ) , decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_first_name ) , decode ( : po_num_type , 'NUMERIC' , null , poh . po_num ) , decode ( : po_num_type , 'NUMERIC' , decode ( rtrim ( poh . po_num , '0123456789' ) , NULL , to_number ( poh . po_num ) , - 1 ) , null ) , poh . po_type poh_po_type , por . release_type poh_release_type , poh . po_num || decode ( poh . po_type , 'RELEASE' , '-' || por . release_num , null ) poh_po_num , poh . po_num security_poh_po_num , por . release_num security_por_po_num , poh . revision_num poh_revision_num , poh . vendor_name poh_vendor_name , poh . vendor_address_line1 poh_vendor_address_line1 , poh . vendor_address_line2 poh_vendor_address_line2 , poh . vendor_address_line3 poh_vendor_address_line3 , decode ( poh . vendor_city , null , poh . vendor_state || ' ' || poh . vendor_postal_code , poh . vendor_city || ', ' || poh . vendor_state || ' ' || poh . vendor_postal_code ) poh_vendor_adr_info , poh . vendor_country poh_vendor_country , poh . customer_num poh_customer , poh . vendor_num poh_vendor_num , poh . creation_date poh_creation_date , poh . revised_date poh_revised_date , substr ( substr ( poh . document_buyer_first_name , 1 , 1 ) || ' ' || poh . document_buyer_last_name , 1 , 12 ) poh_buyer , substr ( trim ( substr ( poh . archive_buyer_first_name , 1 , 1 ) || ' ' || poh . archive_buyer_l ast_name ) , 1 , 12 ) poh_archive_buyer , poh . document_buyer_agent_id poh_agent_id , poh . payment_terms poh_payment_terms , poh . ship_via poh_ship_via , poh . fob poh_fob , poh . freight_terms poh_freight_terms , substr ( poh . vendor_contact_first_name , 1 , 1 ) || ' ' || substr ( poh . vendor_contact_last_name , 1 , 10 ) poh_vendor_contact_name , poh . vendor_phone poh_vendor_phone , poh . vendor_contact_phone poh_vendor_contact_phone , poh . note_to_vendor poh_note_to_vendor , poh . printed_date poh_printed_date , poh . amount_agreed poh_amount_agreed , poh . cancel_flag poh_cancel_flag , poh . confirming_order_flag poh_confirming_order_flag , poh . acceptance_required_flag poh_acceptance_req_flag , poh . acceptance_due_date poh_acceptance_due_date , poh . currency_code poh_currency_code , poh . currency_code C_CURRENCY , poh . currency_name poh_currency_name , poh . currency_conversion_rate poh_currency_conversion_rate , poh . bill_to_location_id poh_bill_to_location , poh . ship_to_location_id poh_ship_to_location , poh . po_header_id poh_po_header_id , poh . po_release_id poh_po_release_id , poh . po_type poh_po_type , poh . approved_flag poh_approved_flag , poh . print_count poh_print_count , poh . effective_date poh_effective_date , poh . expiration_date poh_expiration_date , nvl ( poh . po_release_id , - 1 ) poh_join_release_id , poh . vendor_site_id poh_vendor_site_id , poh . vendor_id poh_vendor_id FROM po_headers_print poh , po_releases por WHERE poh . po_release_id = por . po_release_id (+) AND ( nvl ( por . release_num , - 1 ) BETWEEN nvl ( : P_release_num_from , nvl ( por . release_num , - 1 ) ) AND nvl ( : P_release_num_to , nvl ( por . release_num , - 1 ) ) OR poh . po_type != 'RELEASE' ) AND poh . document_buyer_agent_id = nvl ( : P_agent_id , poh . document_buyer_agent_id ) AND ( poh . release_date is NULL OR trunc ( poh . release_date ) BETWEEN nvl ( : P_date_from , trunc ( poh . release_date ) ) AND nvl ( : P_date_to , trunc ( poh . release_date ) + 1 ) ) AND nvl ( poh . approved_flag , 'N' ) = nvl ( : P_approved_flag , nvl ( poh . approved_flag , 'N' ) ) AND ( ( nvl ( : P_print_releases , 'Y' ) = 'Y' ) or ( nvl ( : P_print_releases , 'Y' ) = 'N' and poh . po_type != 'RELEASE' ) ) AND nvl ( poh . consigned_consumption_flag , 'N' ) <> 'Y' AND nvl ( por . consigned_consumption_flag , 'N' ) <> 'Y' AND :P_SINGLE_PO_PRINT != 1 AND :P_PO_NUM_TYPE = 'NUMERIC' AND decode(rtrim(poh.po_num, '0123456789'), NULL, to_number(poh.po_num), -1) BETWEEN decode(rtrim(nvl(:P_po_num_from, poh.po_num), '0123456789'), NULL, to_number(nvl(:P_po_num_from, poh.po_num)), -1) AND decode(rtrim(nvl(:P_po_num_to, poh.po_num), '0123456789'), NULL, to_number(nvl(:P_po_num_to, poh.po_num)), -1) AND nvl(poh.print_count, 0) = 0 AND NOT EXISTS (SELECT 'X' from ECE_TP_DETAILS ETD, ECE_TP_HEADERS ETH, PO_VENDOR_SITES E_PVS WHERE E_PVS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID AND ETH.TP_HEADER_ID = E_PVS.TP_HEADER_ID AND ETD.TP_HEADER_ID = ETH.TP_HEADER_ID AND ETD.EDI_FLAG = 'Y' AND ETD.DOCUMENT_ID = 'POO' AND ETD.DOCUMENT_TYPE = POH.PO_TYPE ) and 1=1 ORDER BY 1 , 2 , 3 , 4
3c086a4sm741b select decode ( UPPER ( : p_order_by ) , 'CUSTOMER' , NULL , types . cust_trx_type_id ) dummy_id , decode ( UPPER ( : p_order_by ) , 'CUSTOMER' , NULL , types . name ) dummy_type , rtrim ( rpad ( substrb ( party . party_name , 1 , 50 ) , 36 ) ) customer_name , cust_acct . cust_account_id customer_id , cust_acct . account_number customer_number , types . name type , ps . payment_schedule_id payment_sched_id , ps . class class , ps . due_date due_date , decode ( : rp_convert_flag , 'Y' , ps . acctd_amount_due_remaining , ps . amount_due_remaining ) amt_due_remaining , ps . amount_due_original amt_due_original , ceil ( : P_AS_OF_DATE - ps . due_date ) days_past_due , ps . amount_adjusted amount_adjusted , ps . amount_applied amount_applied , ps . amount_credited amount_credited , ps . gl_date gl_date , decode ( ps . invoice_currency_code , : Functional_Currency , NULL , decode ( ps . exchange_rate , NULL , '*' , NULL ) ) data_converted , nvl ( ps . exchange_rate , 1 ) ps_exchange_rate , decode ( : rp_bucket_line_type_0 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp _bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b0 , decode ( : rp_bucket_line_type_1 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b1 , decode ( : rp_bucket_line_type_2 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b2 , decode ( : rp_bucket_line_type_3 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b3 , cc.SEGMENT1 bal_segment_value , rtrim ( rpad ( nvl ( substrb ( par ty . party_name , 1 , 50 ) , : rp_unid_phrase ) , 36 ) ) customer_name_dsp from ra_cust_trx_types_all types , hz_cust_accounts cust_acct , hz_parties party , AR_PAYMENT_SCHEDULES_ALL ps , RA_CUST_TRX_LINE_GL_DIST_ALL gld , gl_code_combinations cc where TRUNC ( ps.gl_date ) <= : p_as_of_date and ps.customer_id = cust_acct.cust_account_id and cust_acct.party_id = party.party_id and cust_acct.account_number >= : p_customer_number_low and cust_acct.account_number <= : p_customer_number_high and ps.cust_trx_type_id = types.cust_trx_type_id and nvl ( ps.org_id , - 99 ) = nvl ( types.org_id , - 99 ) and ps.gl_date_closed > : P_AS_OF_DATE and ps.customer_trx_id + 0 = gld.customer_trx_id and gld.account_class = 'REC' and gld.latest_rec_flag = 'Y' and gld.code_combination_id = cc.code_combination_id AND NVL ( PS.ORG_ID , : p_reporting_entity_id ) = : p_reporting_entity_id AND NVL ( TYPES.ORG_ID , : p_reporting_entity_id ) = : p_reporting_entity_id AND NVL ( GLD.ORG_ID , : p_reporting_entity_id ) = : p_reporting_entity_id UNION ALL select decode ( UPPER ( : p_order_by ) , 'CUSTOMER' , NULL , - 999 ) dummy_id , decode ( UPPER ( : p_order_by ) , 'CUSTOMER' , NULL , decode ( app . applied_payment_schedule_id , - 4 , : c_claim_meaning , : c_payment_meaning ) ) dummy_type , rtrim ( rpad ( substrb ( party . party_name , 1 , 50 ) , 36 ) ) customer_name , nvl ( cust_acct . cust_account_id , - 999 ) customer_id , cust_acct . account_number customer_ number , decode ( : p_order_by , 'XXX' , NULL , decode ( app . applied_payment_schedule_id , - 4 , : c_claim_meaning , : c_payment_meaning ) ) type , ps . payment_schedule_id payment_sched_id , ps . class class , ps . due_date due_date , - sum ( decode ( : rp_convert_flag , 'Y' , app . acctd_amount_applied_from , app . amount_applied ) ) amt_due_remaining , ps . amount_due_original amt_due_original , ceil ( : P_AS_OF_DATE - ps . due_date ) days_past_due , ps . amount_adjusted amount_adjusted , ps . amount_applied amount_applied , ps . amount_credited amount_credited , ps . gl_date gl_date , decode ( ps . invoice_currency_code , : Functional_Currency , NULL , decode ( ps . exchange_rate , NULL , '*' , NULL ) ) data_converted , nvl ( ps . exchange_rate , 1 ) ps_exchange_rate , decode ( : rp_bucket_line_type_0 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b0 , decode ( : rp_bucket_line_type_1 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b1 , decode ( : rp_bucket_line_type_2 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_2 , c eil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b2 , decode ( : rp_bucket_line_type_3 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b3 , cc.SEGMENT1 bal_segment_value , rtrim ( rpad ( nvl ( substrb ( party . party_name , 1 , 50 ) , : rp_unid_phrase ) , 36 ) ) customer_name_dsp from AR_PAYMENT_SCHEDULES_ALL ps , AR_RECEIVABLE_APPLICATIONS_ALL app , gl_code_combinations cc , hz_cust_accounts cust_acct , hz_parti es party where app.gl_date + 0 <= : P_AS_OF_DATE and ps.customer_id = cust_acct.cust_account_id (+) and cust_acct.party_id = party.party_id (+) and nvl ( cust_acct.account_number , : pd_customer_number_low ) >= : p_customer_number_low and nvl ( cust_acct.account_number , : pd_customer_number_low ) <= : p_customer_number_high and ps.cash_receipt_id + 0 = app.cash_receipt_id and app.code_combination_id = cc.code_combination_id and app.status in ( 'ACC' , 'UNAPP' , 'UNID' , 'OTHER ACC' ) and nvl ( app.confirmed_flag , 'Y' ) = 'Y' and ps.gl_date_closed > : P_AS_OF_DATE and ( ( app.reversal_gl_date is not null AND ps.gl_date <= : P_AS_OF_DATE ) OR app.reversal_gl_date is null ) and nvl ( ps.receipt_confirmed_flag , 'Y' ) = 'Y' AND NVL ( PS.ORG_ID , : p_reporting_entity_id ) = : p_reporting_entity_id AND NVL ( APP.ORG_ID , : p_reporting_entity_id ) = : p_reporting_entity_id group by party.party_name , cust_acct.account_number , cust_acct.cust_account_id , ps.payment_schedule_id , app.applied_payment_schedule_id , ps.due_date , ps.amount_due_original , ps.amount_adjusted , ps.amount_applied , ps.amount_credited , ps.gl_date , ps.amount_in_dispute , ps.amount_adjusted_pending , ps.invoice_currency_code , ps.exchange_rate , ps.class , cc.SEGMENT1 , decode ( app.status , 'UNID' , 'UNID' , 'UNAPP' ) UNION ALL select decode ( UPPER ( : p_order_by ) , 'CUSTOMER' , NULL , - 999 ) , decode ( UPPER ( : p_order_by ) , 'CUSTOMER' , NULL , : c_risk_meaning ) dummy_type , rtrim ( rpad ( substrb ( party . party_name , 1 , 50 ) , 36 ) ) customer_name , nvl ( cust_acct . cust_account_id , - 999 ) customer_id , cust_acct . account_number customer_number , : c_risk_meaning type , ps . payment_schedule_id payment_sched_id , : c_risk_meaning class , ps . due_date due_date , decode ( : rp_convert_flag , 'Y' , crh . acctd_amount , crh . amount ) amt_due_remaining , ps . amount_due_original amt_due_original , ceil ( : P_AS_OF_DATE - ps . due_date ) days_past_due , ps . amount_adjusted amount_adjusted , ps . amount_applied amount_applied , ps . amount_credited amount_credited , crh . gl_date gl_date , decode ( ps . invoice_currency_code , : Functional_Currency , NULL , decode ( ps . exchange_rate , NULL , '*' , NULL ) ) data_converted , nvl ( ps . exchange_rate , 1 ) ps_exchange_rate , decode ( : rp_bucket_line_type_0 , 'DISPUTE_ONLY' , 0 , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) ) b0 , decode ( : rp_bucket_line_type_1 , 'DISPUTE_ONLY' , 0 , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) ) b1 , decode ( : rp_bucket_line_type _2 , 'DISPUTE_ONLY' , 0 , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) ) b2 , decode ( : rp_bucket_line_type_3 , 'DISPUTE_ONLY' , 0 , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , decode ( greatest ( : rp_bucket_days_from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) ) b3 , cc.SEGMENT1 bal_segment_value , rtrim ( rpad ( nvl ( substrb ( party . party_name , 1 , 50 ) , : rp_unid_phrase ) , 36 ) ) customer_name_dsp from hz_cust_accounts cust_acct , hz_parties party , AR_PAYMENT_SCHEDULES_ALL ps , AR_CASH_RECEIPTS_ALL cr , AR_CASH_RECEIPT_HISTORY_ALL crh , gl_code_combinations cc where crh.gl_date + 0 <= : P_AS_OF_DATE and upper ( : p_risk_option ) != 'NONE' and ps.customer_id = cust_acct.cust_account_id (+) and cust_acct.party_id = party.party_id (+) and cust_acct.account_number >= : p_customer_number_low and cust_acct.account_number <= : p_customer_number_high and ps.cash_receipt_id = cr.cash_receipt_id and cr.cash_receipt_id = crh.cash_receipt_id and crh.account_code_combination_id = cc.code_combination_id and ( crh.current_record_flag = 'Y' or crh.reversal_gl_date > : p_as_of_date ) and crh.status not in ( decode ( crh.factor_flag , 'Y' , 'RISK_ELIMINATED' , 'N' , 'CLEARED' ) , 'REVERSED' ) and 0 = ( select nvl ( sum ( ra.amount_applied ) , 0 ) from AR_RECEIVABLE_APPLICATIONS_ALL ra where ra.cash_receipt_id = cr.cash_receipt_id and ra.status = 'ACTIVITY' and applied_payment_schedule_id = - 2 and ra.gl_date <= to_date ( : p_as_of_date ) ) AND NVL ( PS.ORG_ID , : p_reporting_entity_id ) = : p_reporting_entity_id AND NVL ( CR.ORG_ID , : p_reporting_entity_id ) = : p_reporting_entity_id AND NVL ( CRH.ORG_ID , : p_reporting_entity_id ) = : p_reporting_entity_id UNION ALL select decode ( UPPER ( : p_order_by ) , 'CUSTOMER' , NULL , types . cust_trx_type_id ) dummy_id , decode ( UPPER ( : p_order_by ) , 'CUSTOMER' , NULL , types . name ) dummy_type , rtrim ( rpad ( substrb ( party . party_name , 1 , 50 ) , 36 ) ) customer_name , cust_acct . cust_account_id customer_id , cust_acct . account_number customer_number , types . name type , ps . payment_schedule_id payment_sched_id , ps . class class , ps . due_date due_date , decode ( : rp_convert_flag , 'Y' , ps . acctd_amount_due_remaining , ps . amount_due_remaining ) amt_due_remaining , ps . amount_due_original amt_due_original , ceil ( : P_AS_OF_DATE - ps . due_date ) days_past_due , ps . amount_adjusted amount_adjusted , ps . amount_applied amount_applied , ps . amount_credited amount_credited , ps . gl_date gl_date , decode ( ps . invoice_currency_code , : Functional_Currency , NULL , decode ( ps . exchange_rate , NULL , '*' , NULL ) ) data_converted , nvl ( ps . exchange_rate , 1 ) ps_exchange_rate , decode ( : rp_bucket_line_type_0 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b0 , decode ( : rp_bucket_line_type_1 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b1 , decode ( : rp_bucket_line_type_2 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b2 , decode ( : rp_bucket_line_type_3 , 'DISPUTE_ONLY' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 0 , 1 ) , 'PENDADJ_ONLY' , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 'DISPUTE_PENDADJ' , decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 0 , 1 ) , 1 ) , decode ( greatest ( : rp_bucket_days_ from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , 1 , 0 ) * decode ( nvl ( ps . amount_in_dispute , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'DISPUTE_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) * decode ( nvl ( ps . amount_adjusted_pending , 0 ) , 0 , 1 , decode ( : rp_bucket_category , 'PENDADJ_ONLY' , 0 , 'DISPUTE_PENDADJ' , 0 , 1 ) ) ) b3 , cc.SEGMENT1 bal_segment_value , rtrim ( rpad ( nvl ( substrb ( party . party_name , 1 , 50 ) , : rp_unid_phrase ) , 36 ) ) customer_name_dsp from ra_cust_trx_types_all types , hz_cust_accounts cust_acct , hz_parties party , AR_PAYMENT_SCHEDULES_ALL ps , ar_transaction_history_all th , AR_DISTRIBUTIONS_ALL dist , gl_code_combinations cc where TRUNC ( ps.gl_date ) <= : p_as_of_date and ps.class = 'BR' and ps.customer_id = cust_acct.cust_account_id and cust_acct.party_id = party.party_id and cust_acct.account_number >= : p_customer_number_low and cust_acct.account_number <= : p_customer_number_high and ps.cust_trx_type_id = types.cust_trx_type_id and nvl ( ps.org_id , - 99 ) = nvl ( types.org_id , - 99 ) and ps.gl_date_closed > : P_AS_OF_DATE and ps.customer_trx_id + 0 = th.customer_trx_id and th.transaction_history_id = dist.source_id and dist.source_table = 'TH' and th.transaction_history_id = ( select max ( transaction_history_id ) from ar_transaction_history_all th2 , AR_DISTRIBUTIONS_ALL dist2 where th2.transaction_history_id = dist2.source_id and dist2.source_table = 'TH' and th2.gl_date <= to_date ( : p_as_of_date ) and dist2.amount_dr is not null and th2.customer_trx_id = ps.customer_trx_id ) and dist.amount_dr is not null and dist.source_table_secondary is NULL and dist.code_combination_id = cc.code_combination_id AND NVL ( PS.ORG_ID , : p_reporting_entity_id ) = : p_reporting_entity_id AND NVL ( TYPES.ORG_ID , : p_reporting_entity_id ) = : p_reporting_entity_id ORDER BY 23 ASC, 2 ASC, 3 ASC, 4 ASC, 5 ASC , 23 , 3 , 5
3cb7xm8ykx1qh begin :1 := POR_UTIL_PKG.submitreq(:2, :3, :4, :5, :6); end;
3n8tvc1tsqua0SELECT 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
3vy5h9xkfv1s5INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE ) SELECT :B1 , :B2 , WIA.NAME, WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1
4yak7x2zqz0dhBEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5jxwda6s8nvc7select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))
5qyckzm5v1qmjbegin :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 ;
608c0n36kaw62begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
64qc329wgjv39 select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_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
6cjfxb1c4kx16SELECT 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
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;
6h2tpcxpymqu7BEGIN :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;
76sw2a4vnc89jbegin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7g05xfvc5vp74BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END;
8321yku30qgwp select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), 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_METHOD_FOR_ACCT_RULE")), substrb(dump(min("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_I NSTALLMENTS"), 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("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(sy s_op_opnsize("WAREHOUSE_ID")), substrb(dump(min("WAREHOUSE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("WAREHOUSE_ID"), 16, 0, 32), 1, 120), count("TRANSLATED_DESCRIPTION"), count(distinct "TRANSLATED_DESCRIPTION"), sum(sys_op_opnsize("TRANSLATED_DESCRIPTION")), substrb(dump(min(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count("CONS_BILLING_NUMBER"), count(distinct "CONS_BILLING_NUMBER"), sum(sys_op_opnsize("CONS_BILLING_NUMBER")), substrb(dump(min("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), count("PROMISED_COMMITMENT_AMOUNT"), count(distinct "PROMISED_COMMITMENT_AMOUNT"), sum(sys_op_opnsize("PROMISED_COMMITMENT_AMOUNT")), substrb(dump(min("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), count("PAYMENT_SET_ID"), count(distinct "PAYMENT_SET_ID"), sum(sys_op_opnsize("PAYMENT_SET_ID")), substrb(dump(min("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), count("ORIGINAL_GL_DATE"), count(distinct "ORIGINAL_GL_DATE"), substrb(dump(min("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), count("CONTRACT_LINE_ID"), count(distinct "CONTRACT_LINE_ID"), sum(sys_op_opnsize("CONTRACT_LINE_ID")), substrb(dump(min("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), substrb(du mp(max("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), count("CONTRACT_ID"), count(distinct "CONTRACT_ID"), sum(sys_op_opnsize("CONTRACT_ID")), substrb(dump(min("CONTRACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_ID"), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY1"), count(distinct "SOURCE_DATA_KEY1"), sum(sys_op_opnsize("SOURCE_DATA_KEY1")), substrb(dump(min(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY2"), count(distinct "SOURCE_DATA_KEY2"), sum(sys_op_opnsize("SOURCE_DATA_KEY2")), substrb(dump(min(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY3"), count(distinct "SOURCE_DATA_KEY3"), sum(sys_op_opnsize("SOURCE_DATA_KEY3")), substrb(dump(min(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY4"), count(distinct "SOURCE_DATA_KEY4"), sum(sys_op_opnsize("SOURCE_DATA_KEY4")), substrb(dump(min(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY5"), count(distinct "SOURCE_DATA_KEY5"), sum(sys_op_opnsize("SOURCE_DATA_KEY5")), substrb(dump(min(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0 , 32), 1, 120), count("INVOICED_LINE_ACCTG_LEVEL"), count(distinct "INVOICED_LINE_ACCTG_LEVEL"), sum(sys_op_opnsize("INVOICED_LINE_ACCTG_LEVEL")), substrb(dump(min("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER_SEQUENCE_ID"), count(distinct "DOCUMENT_NUMBER_SEQUENCE_ID"), sum(sys_op_opnsize("DOCUMENT_NUMBER_SEQUENCE_ID")), substrb(dump(min("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE10"), count(distinct "LINK_TO_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE10")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE11"), count(distinct "LINK_TO_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE11")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE12"), count(distinct "LINK_TO_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE12")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE13"), count(distinct "LINK_TO_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE13")), substrb(dump(min("LINK_TO_ LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE14"), count(distinct "LINK_TO_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE14")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE15"), count(distinct "LINK_TO_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE15")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE8"), count(distinct "LINK_TO_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE8")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE9"), count(distinct "LINK_TO_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE9")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE10"), count(distinct "REFERENCE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE10")), substrb(dump(min("REFERENCE_LINE_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("REFERENCE_LINE_ATTRIBUTE14"), count(distinct "REFERENCE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE14")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE15"), count(distinct "REFERENCE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE15")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE8"), count(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("REFER ENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE9"), count(distinct "REFERENCE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE9")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE12"), count(distinct "INTERFACE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE13")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE14"), count(distinct "INTERFACE_LINE_ATTRIBUTE14"), sum(sys_op_opnsiz e("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_op_opnsize("REASON_CODE_MEANING")), substrb(dump(min(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("LAST_PERIOD_TO_CREDIT"), count(distinct "LAST_PERIOD_TO_CREDIT"), sum(sys_op_opnsize("LAST_PERIOD_TO_CREDIT")), substrb(dump(min("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), count("PAYING_CUSTOMER_ID"), count(distinct "PAYING_CUSTOMER_ID"), sum(sys_op_opn size("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("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE2"), count(distinct "HEADER_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE3"), count(distinct "HEADER_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE4"), count(distinct "HEADER_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE5"), count(distinct "HEADER_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE6"), count(distinct "HEADER_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE7"), count(distinct "HEADER_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE8"), count(distinct "HEADER_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_G DF_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("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE13"), count(distinct "HEADER_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE14"), count(distinct "HEADER_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("HEADE R_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_ATTRIBUTE23"), count(distinct "HEADER_GDF_ATTRIBUTE23"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE23")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE24"), count(distinct "HEADER_GDF_ATTRIBUTE24"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE24")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32) ), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE25"), count(distinct "HEADER_GDF_ATTRIBUTE25"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE25")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE26"), count(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_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE3"), count(distinct "LINE_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE4"), count(distinct "LINE_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(subst rb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE5"), count(distinct "LINE_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE6"), count(distinct "LINE_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE7"), count(distinct "LINE_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE8"), count(distinct "LINE_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE9"), count(distinct "LINE_GDF_ATTRIBUTE9"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE10"), count(distinct "LINE_GDF_ATTRIBUTE10"), sum(sys_op_opnsize("LINE_GDF _ATTRIBUTE10")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE11"), count(distinct "LINE_GDF_ATTRIBUTE11"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE12"), count(distinct "LINE_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE13"), count(distinct "LINE_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE14"), count(distinct "LINE_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 12????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????b("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t
8camsgjsr9zya begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
8h16w67202y4gbegin fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :l); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :m); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end;
8vmj377jqyqwqBEGIN 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;
97mt0g20bcfc3 begin pay_US_rules.get_default_jurisdiction (:asgact, :eeid, :defval:defvalind); end;
9bbak9qpg1c7xINSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE ) VALUES ( :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
9hypmc3t618sc SELECT ORDERED_ITEM, ORDERED_QUANTITY, ORDER_QUANTITY_UOM, ORDERED_QUANTITY2, ORDERED_QUANTITY_UOM2, PREFERRED_GRADE, LINE_NUMBER, COMPONENT_NUMBER, REQUEST_DATE, SCHEDULE_SHIP_DATE, LINE_TYPE, CANCELLED_QUANTITY, SHIPPED_QUANTITY, PROMISE_DATE, PRICING_QUANTITY, PRICING_QUANTITY_UOM, SHIP_FROM, SOLD_TO, CUSTOMER_NUMBER, CUST_PO_NUMBER, CUSTOMER_LINE_NUMBER, CUSTOMER_SHIPMENT_NUMBER, DEMAND_BUCKET_TYPE_CODE, RLA_SCHEDULE_TYPE_CODE, CUSTOMER_DOCK_CODE, CUST_MODEL_SERIAL_NUMBER, CUSTOMER_PRODUCTION_LINE, CUST_PRODUCTION_SEQ_NUM, CUSTOMER_JOB, END_ITEM_UNIT_NUMBER, TAX_CODE, BLANKET_NUMBER, BLANKET_LINE_NUMBER, BLANKET_VERSION_NUMBER, PRICE_LIST, PRICING_DATE, SHIPMENT_NUMBER, TERMS, UNIT_LIST_PRICE, ORIGINAL_LIST_PRICE, ITEM_TYPE_CODE, OPTION_NUMBER, VISIBLE_DEMAND_FLAG, SCHEDULE_ARRIVAL_DATE, PLANNING_PRIORITY, ORIGINAL_ORDERED_ITEM, ORIGINAL_INVENTORY_ITEM_ID, ORIGINAL_ORDERED_ITEM_ID, item_relationship_type, LATE_DEMAND_PENALTY_FACTOR, ORIGINAL_ITEM_IDENTIFIER_TYPE, ITEM_SUBSTITUTION_TYPE_CODE, OVERRIDE_ATP_DATE_CODE, FIRM_DEMAND_FLAG, ITEM_IDENTIFIER_TYPE, UNIT_SELLING_PRICE, UNIT_COST, CUSTOMER_ITEM_NET_PRICE, CUSTOMER_PAYMENT_TERM_ID, CALCULATE_PRICE_FLAG, TAX_EXEMPT_NUMBER, TAX_DATE, TAX_VALUE, TAX_POINT_CODE, ACCOUNTING_RULE, ACCOUNTING_RULE_DURATION, INVOICING_RULE, SUBINVENTORY, FULFILLED_QUANTITY, INVOICED_QUANTITY, SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS, USER_ITEM_DESCRIPTION, SHIP_FROM_LOCATION, SHIP_TO, SHIP_TO_LOCATION, SHIP_TO_CONTACT, SHIP_TO_ADDRESS1, SHI P_TO_ADDRESS2, SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4, SHIP_TO_ADDRESS5, SHIPPING_QUANTITY_UOM, SHIPPING_QUANTITY, DELIVERY_LEAD_TIME, INVOICE_TO, INVOICE_TO_LOCATION, INVOICE_TO_CONTACT, INVOICE_TO_ADDRESS1, INVOICE_TO_ADDRESS2, INVOICE_TO_ADDRESS3, INVOICE_TO_ADDRESS4, INVOICE_TO_ADDRESS5, ITEM_REVISION, ROUNDING_FACTOR, SPLIT_BY, SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW, ORDER_NUMBER, VERSION_NUMBER, ORDER_TYPE, ORDERED_DATE, OVER_SHIP_REASON, first_ack_code, FIRST_ACK_DATE, last_ack_code, LAST_ACK_DATE, SERVICE_TXN_REASON_CODE, SERVICE_TXN_COMMENTS, SERVICE_COTERMINATE_FLAG, SERVICE_DURATION, SERVICE_PERIOD, SERVICE_START_DATE, SERVICE_END_DATE, UNIT_SELLING_PERCENT, SERVICE_NUMBER, SERVICE_REFERENCE_TYPE_CODE, UNIT_LIST_PERCENT, UNIT_PERCENT_BASE_PRICE, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_CONTACT_ID, END_CUSTOMER_ID, IB_OWNER, IB_INSTALLED_AT_LOCATION, IB_CURRENT_LOCATION, EARLIEST_ACCEPTABLE_DATE, LATEST_ACCEPTABLE_DATE, ACTUAL_SHIPMENT_DATE, OVER_SHIP_RESOLVED_FLAG, ACTUAL_ARRIVAL_DATE, DEP_PLAN_REQUIRED_FLAG, AUTHORIZED_TO_SHIP_FLAG, COMMITMENT_ID, LOCK_CONTROL, ORDER_SOURCE_ID, TAX_EXEMPT_REASON_CODE, FULFILLED_FLAG, FULFILLMENT_METHOD_CODE, TAX_EXEMPT_FLAG, TAX_RATE, FREIGHT_TERMS_CODE, SHIPMENT_PRIORITY_CODE, SHIPPING_METHOD_CODE, FOB_POINT_CODE, INVOICE_INTERFACE_STATUS_CODE, SHIP_MODEL_COMPLETE_FLAG, SOURCE_DOCUMENT_TYPE_ID, SOURCE_DOCUMENT_ID, SOURCE_DOCUMENT_LINE_ID, ROW_ID, HEADER_ROW_ID, REFERENCE_HEADER_ID, REFERENCE_LINE_ID, REFERENCE_CUSTOMER_TRX_LINE_ID, CREDIT_INVOICE_LINE_ID, LINE_ID, ORG_ID, HEADER_ID, LINE_TYPE_ID, LINE_SET_ID, CONFIG_HEADER_ID, CONFIG_REV_NBR, SHIP_FROM_ORG_ID, SHIP_TO_ORG_ID, DELIVER_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, SOLD_FROM_ORG_ID, SHIP_TO_CONTACT_ID, DELIVER_TO_CONTACT_ID, INTMED_SHIP_TO_CONTACT_ID, INVOICE_TO_CONTACT_ID, INVENTORY_ITEM_ID, SERVICE_REFERENCE_LINE_ID, SERVICE_REFERENCE_SYSTEM_ID, PRICE_LIST_ID, AGREEMENT_ID, PAYMENT_TERM_ID, INVOICING_RULE_ID, ACCOUNTING_RULE_ID, SPLIT_FROM_LINE_ID, VEH_CUS_ITEM_CUM_KEY_ID, SALESREP_ID, RETURN_REASON_CODE, ARRIVAL_SET_ID, SHIP_SET_ID, ORDERED_ITEM_ID, OVER_SHIP_REASON_CODE, CONTEXT, SCHEDULE_STATUS_CODE, FLOW_STATUS_CODE, SOURCE_TYPE_CODE, DEMAND_CLASS_CODE, TRANSACTION_PHASE_CODE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20, INDUSTRY_CONTEXT, INDUSTRY_ATTRIBUTE1, INDUSTRY_ATTRIBUTE2, INDUSTRY_ATTRIBUTE3, INDUSTRY_ATTR IBUTE4, INDUSTRY_ATTRIBUTE5, INDUSTRY_ATTRIBUTE6, INDUSTRY_ATTRIBUTE7, INDUSTRY_ATTRIBUTE8, INDUSTRY_ATTRIBUTE9, INDUSTRY_ATTRIBUTE10, INDUSTRY_ATTRIBUTE11, INDUSTRY_ATTRIBUTE13, INDUSTRY_ATTRIBUTE12, INDUSTRY_ATTRIBUTE14, INDUSTRY_ATTRIBUTE15, INDUSTRY_ATTRIBUTE16, INDUSTRY_ATTRIBUTE17, INDUSTRY_ATTRIBUTE18, INDUSTRY_ATTRIBUTE19, INDUSTRY_ATTRIBUTE20, INDUSTRY_ATTRIBUTE21, INDUSTRY_ATTRIBUTE22, INDUSTRY_ATTRIBUTE23, INDUSTRY_ATTRIBUTE24, INDUSTRY_ATTRIBUTE25, INDUSTRY_ATTRIBUTE26, INDUSTRY_ATTRIBUTE27, INDUSTRY_ATTRIBUTE28, INDUSTRY_ATTRIBUTE29, INDUSTRY_ATTRIBUTE30, RETURN_CONTEXT, RETURN_ATTRIBUTE1, RETURN_ATTRIBUTE2, RETURN_ATTRIBUTE3, RETURN_ATTRIBUTE4, RETURN_ATTRIBUTE5, RETURN_ATTRIBUTE6, RETURN_ATTRIBUTE7, RETURN_ATTRIBUTE8, RETURN_ATTRIBUTE9, RETURN_ATTRIBUTE10, RETURN_ATTRIBUTE11, RETURN_ATTRIBUTE12, RETURN_ATTRIBUTE13, RETURN_ATTRIBUTE14, RETURN_ATTRIBUTE15, TP_CONTEXT, TP_ATTRIBUTE1, TP_ATTRIBUTE2, TP_ATTRIBUTE3, TP_ATTRIBUTE4, TP_ATTRIBUTE5, TP_ATTRIBUTE6, TP_ATTRIBUTE7, TP_ATTRIBUTE8, TP_ATTRIBUTE9, TP_ATTRIBUTE10, TP_ATTRIBUTE11, TP_ATTRIBUTE12, TP_ATTRIBUTE13, TP_ATTRIBUTE14, TP_ATTRIBUTE15, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID, COMPONENT_SEQUENCE_ID, CONFIGURATION_ID, TOP_MODEL_LINE_ID, LINK_TO_LINE_ID, CONFIG_DISPLAY_SEQUENCE, COMPONENT_CODE, SORT_ORDER, SOLD_TO_ORG_ID, FREIGHT_CARRIER_CODE, PROJECT_ID, TASK_ID, LINE_CATEGORY_CODE, MODEL_REMNANT_FL AG, CUSTOMER_TRX_LINE_ID, OPTION_FLAG, BOOKED_FLAG, OPEN_FLAG, CANCELLED_FLAG, ORIG_SYS_DOCUMENT_REF, ORIG_SYS_LINE_REF, ORIG_SYS_SHIPMENT_REF, SHIPPING_INTERFACED_FLAG, ATO_LINE_ID, AUTO_SELECTED_QUANTITY, EXPLOSION_DATE, MODEL_GROUP_NUMBER FROM OE_ORDER_LINES_V WHERE (HEADER_ID=:1) order by line_number, shipment_number, nvl(option_number, -1), nvl(component_number, -1), nvl(service_number, -1)
9pqmabwh0shda select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), 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), count("PURCHASE_ORDER_DATE"), count(distinct "PURCHASE_ORDER_DATE"), substrb(dump(min("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), count("AGREEMENT_NAME"), count(distinct "AGREEMENT_NAME"), sum(sys_op_opnsize("AGREEMENT_NAME")), substrb(dump(min("AGREEMENT_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_NAME"), 16, 0, 32), 1, 120), count("AGREEMENT_ID"), count(distinct "AGREEMENT_ID"), sum(sys_op_opnsize("AGREEMENT_ID")), substrb(dump(min("AGREEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_ID"), 16, 0, 32), 1, 120), count("MEMO_LINE_NAME"), count(distinct "MEMO_LINE_NAME"), 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("INVE NTORY_ITEM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG1"), count(distinct "MTL_SYSTEM_ITEMS_SEG1"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG1")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG2"), count(distinct "MTL_SYSTEM_ITEMS_SEG2"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG2")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG3"), count(distinct "MTL_SYSTEM_ITEMS_SEG3"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG3")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG4"), count(distinct "MTL_SYSTEM_ITEMS_SEG4"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG4")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG5"), count(distinct "MTL_SYSTEM_ITEMS_SEG5"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG5")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), count(" MTL_SYSTEM_ITEMS_SEG6"), count(distinct "MTL_SYSTEM_ITEMS_SEG6"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG6")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG6", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG7"), count(distinct "MTL_SYSTEM_ITEMS_SEG7"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG7")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG7", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG8"), count(distinct "MTL_SYSTEM_ITEMS_SEG8"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG8")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG8", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG9"), count(distinct "MTL_SYSTEM_ITEMS_SEG9"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG9")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG9", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG10"), count(distinct "MTL_SYSTEM_ITEMS_SEG10"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG10")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG11"), count(distinct "MTL_SYSTEM_ITEMS_SEG11"), sum(sys_op_opnsize("MTL_SYSTEM_I TEMS_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("MTL_SYSTEM_ITEMS_SEG19")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG20"), count(distinct "MTL_SYSTEM_ITEMS_SEG20"), sum(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(d istinct "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("REF ERENCE_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_SEGM ENT4"), 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(dump(max("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT13"), count(distinct "TERRITORY_SEGMENT13"), sum(sys_op_opnsize("TERRITORY_SEGMENT13")), substrb(dump(min("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT14"), count(distinct "TERRITORY_SEGMENT14"), sum(sys_op_opnsize("TERRITORY_SEGMENT14")), substrb(dump(min("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT15"), count(distinct "TERRITORY_SEGMENT15"), sum(sys_op_opnsize("TERRITORY_SEGMENT15")), substrb(dump(min("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT16"), count(distinct "TERRITORY_SEGMENT16"), sum(sys_op_opnsize("TERRITORY_SEGMENT16")), substrb(dump(min("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGM ENT16"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT17"), count(distinct "TERRITORY_SEGMENT17"), sum(sys_op_opnsize("TERRITORY_SEGMENT17")), substrb(dump(min("TERRITORY_SEGMENT17"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT17"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT18"), count(distinct "TERRITORY_SEGMENT18"), sum(sys_op_opnsize("TERRITORY_SEGMENT18")), substrb(dump(min("TERRITORY_SEGMENT18"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT18"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT19"), count(distinct "TERRITORY_SEGMENT19"), sum(sys_op_opnsize("TERRITORY_SEGMENT19")), substrb(dump(min("TERRITORY_SEGMENT19"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT19"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT20"), count(distinct "TERRITORY_SEGMENT20"), sum(sys_op_opnsize("TERRITORY_SEGMENT20")), substrb(dump(min("TERRITORY_SEGMENT20"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT20"), 16, 0, 32), 1, 120), count("ATTRIBUTE_CATEGORY"), count(distinct "ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("ATTRIBUTE_CATEGORY")), substrb(dump(min("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("ATTRIBUTE1"), count(distinct "ATTRIBUTE1"), sum(sys_op_opnsize("ATTRIBUTE1")), substrb(dump(min(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE2"), count(distinct "ATTRIBUTE2"), sum(sys_op_opns ize("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_ATTRI BUTE5")), 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(dis tinct "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), 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), coun t("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")), substrb(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, 1 20), 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("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_AT TRIBUTE2")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE3"), count(distinct "INTERFACE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE3")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE4"), count(distinct "INTERFACE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE4")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_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"), sum(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(s ys_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(dum p(min("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_REF"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_REF"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_ID"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_S????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????strb(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_AT TRIBUTE2"), 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_METHOD_ID")), substrb(dump(min("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), count(distinct "CONVERSION_TYPE"), sum(sys_op_opnsize("CONVERSION_TYPE")), substrb(dump(min("CONVERSION_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_TYPE"), 16, 0, 32), 1, 120), count("CONVERSION_DATE"), count(distinct "CONVERSION_DATE"), substrb(dump(min("CONVERSION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_DATE"), 16, 0, 32), 1, 120), count("CONVERSION_RATE"), count(distinct "CONVERSION_RATE"), sum(sys_op_opnsize("CONVERSION_RATE")), substrb(dump(min("CONVERSION_RATE"), 16, 0, 32), 1, 120), substrb(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("DOC UMENT_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER"), 16, 0, 32), 1, 120), count("TRX_NUMBER"), count(distinct "TRX_NUMBER"), sum(sys_op_opnsize("TRX_NUMBER")), substrb(dump(min("TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("TRX_NUMBER"), 16, 0, 32), 1, 120), count("LINE_NUMBER"), count(distinct "LINE_NUMBER"), sum(sys_op_opnsize("LINE_NUMBER")), substrb(dump(min("LINE_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_NUMBER"), 16, 0, 32), 1, 120), count("QUANTITY"), count(distinct "QUANTITY"), sum(sys_op_opnsize("QUANTITY")), substrb(dump(min("QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY"), 16, 0, 32), 1, 120), count("QUANTITY_ORDERED"), count(distinct "QUANTITY_ORDERED"), sum(sys_op_opnsize("QUANTITY_ORDERED")), substrb(dump(min("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), count("UNIT_SELLING_PRICE"), count(distinct "UNIT_SELLING_PRICE"), sum(sys_op_opnsize("UNIT_SELLING_PRICE")), substrb(dump(min("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), count("UNIT_STANDARD_PRICE"), count(distinct "UNIT_STANDARD_PRICE"), sum(sys_op_opnsize("UNIT_STANDARD_PRICE")), substrb(dump(min("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), count("PRINTING_OPTION"), count(distinct "PRINTING_OPTION"), sum(sys_op_opnsize("PRINTING_OPTION")), substrb(dump(min("PRINTING_OPTION"), 16, 0 , 32), 1, 120), substrb(dump(max("PRINTING_OPTION"), 16, 0, 32), 1, 120), count("INTERFACE_STATUS"), count(distinct "INTERFACE_STATUS"), sum(sys_op_opnsize("INTERFACE_STATUS")), substrb(dump(min("INTERFACE_STATUS"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_STATUS"), 16, 0, 32), 1, 120), count("REQUEST_ID"), count(distinct "REQUEST_ID"), sum(sys_op_opnsize("REQUEST_ID")), substrb(dump(min("REQUEST_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REQUEST_ID"), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t
9sf243fdjmdmhbegin fnd_global.apps_initialize(-1, -1, -1, :1); end;
9wdrypwkpf607begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
a40f9h91scg23select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2
a957tvxz9w038BEGIN :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;
avc1jqzz04wprSELECT 'x' FROM DUAL
azfadzhfxbxj3 SELECT ROW_ID, APBA_INACTIVE_DATE, DEFAULT_TAX_EXEMPT_FLAG, BS_BATCH_SOURCE_NAME, TRX_NUMBER, RA_BILLING_NUMBER, SOA_AGREEMENT_NAME, RAB_BATCH_NAME, RAC_BILL_TO_CUSTOMER_NAME, RAC_BILL_TO_CUSTOMER_NUM, RAA_BILL_TO_CONCAT_ADDRESS, RAA_BILL_TO_ADDRESS1, RAA_BILL_TO_ADDRESS2, RAA_BILL_TO_ADDRESS3, RAA_BILL_TO_ADDRESS3_DB, RAA_BILL_TO_CITY, FT_BILL_TO_COUNTRY, RAA_BILL_TO_COUNTY, RAA_BILL_TO_POSTAL_CODE, RAA_BILL_TO_PROVINCE, RAA_BILL_TO_STATE, RACO_BILL_TO_CONTACT_NAME, BILL_TO_TAXPAYER_ID, SU_BILL_TO_LOCATION, OF_SHIP_VIA_NAME, CTT_CLASS, COMMENTS, END_DATE_COMMITMENT, START_DATE_COMMITMENT, COMPLETE_FLAG, CT_RELATED_TRX_NUMBER, APBA_BANK_ACCOUNT_NAME, APBA_BANK_ACCOUNT_NUM, APB_CUSTOMER_BANK_BRANCH_NAME, APB_CUSTOMER_BANK_NAME, CUSTOMER_REFERENCE, CUSTOMER_REFERENCE_DATE, INVOICE_CURRENCY_CODE, AL_DEFAULT_TAX_EXEMPT_FLAG, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, PS_DISPUTE_AMOUNT, PS_DISPUTE_DATE, DOC_SEQUENCE_VALUE, TERM_DUE_DATE, EXCHANGE_DATE, EXCHANGE_RATE, GDCT_USER_EXCHANGE_RATE_TYPE, AL_FOB_MEANING, FINANCE_CHARGES, GD_GL_DATE, INVOICING_RULE_ID, CT_MODEL_TRX_NUMBER, PRINTING_ORIGINAL_DATE, CT_INVOICE_FOR_CB, PURCHASE_ORDER_DATE, PURCHASE_ORDER_REVISION, SU_PAYING_CUSTOMER_LOCATION, RAC_PAYING_CUSTOMER_NAME, RAC_PAYING_CUSTOMER_NUM, ARM_RECEIPT_METHOD_NAME, PRINTING_COUNT, PRINTING_LAST_PRINTED, PRINTING_OPT ION, PURCHASE_ORDER, CT_REFERENCE, RAA_CONCAT_REMIT_TO_ADDRESS, RAA_REMIT_TO_ADDRESS1, RAA_REMIT_TO_ADDRESS2, RAA_REMIT_TO_ADDRESS3, RAA_REMIT_TO_ADDRESS3_DB, RAA_REMIT_TO_CITY, RAA_REMIT_TO_COUNTY, RAA_REMIT_TO_STATE, RAA_REMIT_TO_PROVINCE, RAA_REMIT_TO_POSTAL_CODE, FT_REMIT_TO_COUNTRY, CREDIT_METHOD_FOR_RULES, RAS_PRIMARY_SALESREP_NAME, RAS_PRIMARY_SALESREP_NUM, SHIP_DATE_ACTUAL, RAA_SHIP_TO_CONCAT_ADDRESS, RAA_SHIP_TO_ADDRESS1, RAA_SHIP_TO_ADDRESS2, RAA_SHIP_TO_ADDRESS3, RAA_SHIP_TO_ADDRESS3_DB, RAA_SHIP_TO_CITY, RAA_SHIP_TO_COUNTY, RAA_SHIP_TO_STATE, RAA_SHIP_TO_PROVINCE, RAA_SHIP_TO_POSTAL_CODE, FT_SHIP_TO_COUNTRY, RAC_SHIP_TO_CUSTOMER_NAME, RACO_SHIP_TO_CONTACT_NAME, RAC_SHIP_TO_CUSTOMER_NUM, SU_SHIP_TO_LOCATION, SHIP_TO_TAXPAYER_ID, RAC_SOLD_TO_CUSTOMER_NAME, RAC_SOLD_TO_CUSTOMER_NUM, INTERNAL_NOTES, CREDIT_METHOD_FOR_INSTALLMENTS, STATUS_TRX, RAT_TERM_NAME, DEFAULT_USSGL_TRANSACTION_CODE, TRX_DATE, INTERFACE_HEADER_CONTEXT, INTERFACE_HEADER_ATTRIBUTE1, INTERFACE_HEADER_ATTRIBUTE2, INTERFACE_HEADER_ATTRIBUTE3, INTERFACE_HEADER_ATTRIBUTE4, INTERFACE_HEADER_ATTRIBUTE5, INTERFACE_HEADER_ATTRIBUTE6, INTERFACE_HEADER_ATTRIBUTE7, INTERFACE_HEADER_ATTRIBUTE8, INTERFACE_HEADER_ATTRIBUTE9, INTERFACE_HEADER_ATTRIBUTE10, INTERFACE_HEADER_ATTRIBUTE11, INTERFACE_HEADER_ATTRIBUTE12, INTERFACE_HEADER_ATTRIBUTE13, INTERFACE_HEADER_ATTRIBUTE14, INTERFACE_HEADER_ATTRIBUTE15, CTT_TYPE_NAME, WAYBILL_NUMBER, CUSTOMER_TRX_ID, PREVIOUS_CUSTOMER_TRX_ID, INITIAL_CUSTOMER_TRX_ID, RELATED_BATCH_ SOURCE_ID, RELATED_CUSTOMER_TRX_ID, CUST_TRX_TYPE_ID, BATCH_ID, BATCH_SOURCE_ID, REASON_CODE, TERM_ID, PRIMARY_SALESREP_ID, AGREEMENT_ID, RECEIPT_METHOD_ID, SHIP_VIA, FOB_POINT, CUSTOMER_BANK_ACCOUNT_ID, RECURRED_FROM_TRX_NUMBER, SOLD_TO_CUSTOMER_ID, SOLD_TO_SITE_USE_ID, SOLD_TO_CONTACT_ID, BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID, BILL_TO_CONTACT_ID, SHIP_TO_CUSTOMER_ID, SHIP_TO_SITE_USE_ID, SHIP_TO_CONTACT_ID, REMIT_TO_ADDRESS_ID, CREATED_FROM, PRINTING_PENDING, LAST_PRINTED_SEQUENCE_NUM, EXCHANGE_RATE_TYPE, TERRITORY_ID, DOC_SEQUENCE_ID, PAYING_CUSTOMER_ID, PAYING_SITE_USE_ID, DH_MAX_DISPUTE_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, BS_AUTO_TRX_NUMBERING_FLAG, BS_BATCH_SOURCE_TYPE, REV_RECOG_RUN_FLAG, CTT_OPEN_RECEIVABLES_FLAG, CTT_ALLOW_FREIGHT_FLAG, CTT_POST_TO_GL_FLAG, CTT_CREATION_SIGN, CTT_ALLOW_OVERAPPLICATION_FLAG, CTT_NATURAL_APP_ONLY_FLAG, CTT_TAX_CALCULATION_FLAG, CTT_DEFAULT_STATUS, CTT_DEFAULT_TERM, CTT_DEFAULT_PRINTING_OPTION, RAA_BILL_TO_ADDRESS_ID, RAA_SHIP_TO_ADDRESS_ID, ARC_CREATION_METHOD_CODE, ARM_PAYMENT_TYPE_CODE, RAT_TERM_IN_USE_FLAG, RULES_FLAG, ACTIVITY_FLAG, PRINTED_FLAG, POSTED_FLAG, CM_AGAINST_TRX_FLAG, SELECTED_FOR_PAYMENT_FLAG, OVERRIDE_TERMS, COMMITMENTS_EXIST_FLAG, AGREEMENTS_EXIST_FLAG, ATCHMT_FLAG, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATT RIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY, ORIG_SYSTEM_BATCH_NAME, OLD_TRX_NUMBER, BS_COPY_DOC_NUMBER_FLAG FROM RA_CUSTOMER_TRX_PARTIAL_V WHERE NVL(:1 , 0) = NVL(of_organization_id, NVL(:2, 0)) and (CUSTOMER_TRX_ID=:3) order by CUSTOMER_TRX_ID
b38b6kx0rztphselect M.ERROR_MESSAGE from FND_FLEX_VALUE_RULE_USAGES U, FND_FLEX_VALUE_RULES_VL M where U.FLEX_VALUE_RULE_ID = M.FLEX_VALUE_RULE_ID and U.APPLICATION_ID = :FND_BIND1 and U.RESPONSIBILITY_ID = :FND_BIND2 and U.FLEX_VALUE_SET_ID = :FND_BIND3 and (exists (select null from FND_FLEX_VALUE_RULE_LINES L where 1 = 1 and (:FND_BIND4 between nvl(L.FLEX_VALUE_LOW, :FND_BIND5) and nvl(L.FLEX_VALUE_HIGH, :FND_BIND6)) and L.FLEX_VALUE_RULE_ID = U.FLEX_VALUE_RULE_ID and L.INCLUDE_EXCLUDE_INDICATOR = 'E') or not exists (select null from FND_FLEX_VALUE_RULE_LINES L where 1 = 1 and (:FND_BIND7 between nvl(L.FLEX_VALUE_LOW, :FND_BIND8) and nvl(L.FLEX_VALUE_HIGH, :FND_BIND9)) and L.FLEX_VALUE_RULE_ID = U.FLEX_VALUE_RULE_ID and L.INCLUDE_EXCLUDE_INDICATOR = 'I'))
bc7t6t6jfx2n7SELECT VERSION FROM FND_CACHE_VERSIONS WHERE NAME = :B1
bcym7s1bp0wxsSELECT WIA.NAME FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1 AND WIA.TYPE = 'EVENT'
bf7uwg5pa3pj6begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bfbyqwbr4vwmsbegin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
bkxrrs52m7d8pBEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
bp8crdjba8zgtupdate 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)
bt0w082dfrm8vBEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
c4y7jp0q2awbfSELECT 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
cbvr877xhfjvxSELECT PPT.CATEGORY, UPPER(TRANSLATE(PBT.BALANCE_NAME, ' ', '_') || PBD.DATABASE_ITEM_SUFFIX), PBT.CURRENCY_CODE, HR_PRE_PAY.SET_CASH_RULE(PPT.CATEGORY, OPM.PMETH_INFORMATION1), OPM.CURRENCY_CODE, PP.DEFAULT_PAYMENT_METHOD_ID, PPA.EFFECTIVE_DATE, PP.NEGATIVE_PAY_ALLOWED_FLAG, PPA.PAYROLL_ID, PPA.BUSINESS_GROUP_ID FROM PAY_BALANCE_DIMENSIONS PBD, PAY_BALANCE_TYPES PBT, PAY_DEFINED_BALANCES PDB, PAY_PAYMENT_TYPES PPT, PAY_ALL_PAYROLLS_F PP, PAY_ORG_PAYMENT_METHODS_F OPM, PAY_PAYROLL_ACTIONS PPA WHERE PPA.PAYROLL_ACTION_ID = :B1 AND PPA.PAYROLL_ID = PP.PAYROLL_ID AND PP.DEFAULT_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND OPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID AND OPM.DEFINED_BALANCE_ID = PDB.DEFINED_BALANCE_ID AND PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID AND PDB.BALANCE_DIMENSION_ID = PBD.BALANCE_DIMENSION_ID AND PBD.PAYMENTS_FLAG = 'Y' AND PBT.ASSIGNMENT_REMUNERATION_FLAG = 'Y' AND PPA.EFFECTIVE_DATE BETWEEN PP.EFFECTIVE_START_DATE AND PP.EFFECTIVE_END_DATE AND PPA.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE
cd9mbmqyf4qhpUPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
cw171rvngr1w9begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end;
d0a8mm8y38yaw SELECT base.revision , base.lot_number , base.lot_expiration_date , base.subinventory_code , base.locator_id , base.cost_group_id , base.date_received , base.primary_quantity , msi.picking_order FROM ( SELECT x.organization_id , x.inventory_item_id , x.revision , x.lot_number , lot.expiration_date lot_expiration_date , x.subinventory_code , sub.reservable_type , x.locator_id , x.cost_group_id , x.date_received date_received , x.primary_quantity primary_quantity , NULL lpn_id , x.project_id project_id , x.task_id task_id FROM (SELECT moq.organization_id , moq.inventory_item_id , moq.revision , moq.lot_number , moq.subinventory_code , moq.locator_id , moq.cost_group_id , min(NVL(moq.orig_date_received, moq.date_received)) date_received , sum(moq.primary_transaction_quantity) primary_quantity , moq.project_id , moq.task_id FROM MTL_ONHAND_QUANTITIES_DETAIL moq WHERE moq.organization_id = :n1 AND moq.inventory_item_id = :n2 GROUP BY moq.organization_id, moq.inventory_item_id , moq.revision, moq.lot_number , moq.subinventory_code, moq.locator_id , moq.cost_group_id , moq.project_id , moq.task_id ) x , mtl_seconda ry_inventories sub , mtl_lot_numbers lot WHERE x.primary_quantity > 0 AND x.organization_id = sub.organization_id AND x.subinventory_code = sub.secondary_inventory_name AND NVL(sub.disable_date, sysdate+1) > sysdate AND x.organization_id = lot.organization_id (+) AND x.inventory_item_id = lot.inventory_item_id (+) AND x.lot_number = lot.lot_number (+) ) base , mtl_secondary_inventories msi where 1=1 AND NVL(base.reservable_type, 2) = 1 AND base.subinventory_code = msi.secondary_inventory_name AND base.organization_id = msi.organization_id AND ((base.locator_id IS NULL) OR (base.locator_id IS NOT NULL AND (EXISTS ( SELECT inventory_location_id FROM mtl_item_locations WHERE inventory_location_id = base.locator_id AND organization_id = base.organization_id AND project_id IS NULL AND task_id IS NULL)))) order by msi.picking_order , base.date_received
dcvv68fju01g4begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
f87337d0g8ps6SELECT DISTINCT SIT_EXISTS FROM PAY_US_STATE_TAX_INFO_F WHERE STATE_CODE = SUBSTR(:B2 , 1, 2) AND TO_DATE(:B1 , 'dd-mm-yyyy') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
fb13x9qx0ftksbegin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fcwn4vnv96315SELECT STATE_CODE FROM PAY_US_STATES WHERE STATE_ABBREV = :B1
fmfdkztk8vx23SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
fr38pcatsbj6x SELECT reservation_id , primary_reservation_quantity - NVL(detailed_quantity, 0) FROM mtl_reservations WHERE demand_source_header_id = :demand_source_header_id AND demand_source_line_id = :demand_source_line_id AND demand_source_type_id = :demand_source_type_id AND supply_source_type_id = :supply_source_type_id AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision) AND (:lpn_id = :l_ miss_num OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id))) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name) AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0 ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE
g8102j8yynbwzbegin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gbc00q72n5n3mUPDATE WF_ITEMS SET END_DATE = TO_DATE(NULL) WHERE ITEM_TYPE = :B2 AND ITEM_KEY = :B1
gksvm8wmzk8w0begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;
gnhmcahkmrnzsINSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )
gnng1rmpjxzsxbegin OE_CLOSE_WF.CLOSE_LINE (:v1, :v2, :v3, :v4, :v5); end;
gux0k2wpv33y8 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_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), 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_ATTRIBUTE3")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE4"), count(distinct "INTERFACE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE4")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_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("INTERF ACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("SALESREP_NUMBER"), 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(du mp(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(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("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) from "AR"."RA_INTERFACE_SALESCREDITS_ALL" sample ( 10.0000000000) t
gzkhp7cph992fBEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6); END;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 2,116,714 586.43 3.56
CPU used when call started 2,118,111 586.81 3.56
CR blocks created 10,842,214 3,003.80 18.23
Cached Commit SCN referenced 14,658,088 4,060.97 24.65
Commit SCN cached 17,786 4.93 0.03
DB time 6,498,799 1,800.47 10.93
DBWR checkpoint buffers written 2,905,104 804.85 4.88
DBWR checkpoints 34 0.01 0.00
DBWR fusion writes 33,716 9.34 0.06
DBWR object drop buffers written 57,616 15.96 0.10
DBWR thread checkpoint buffers written 727,302 201.50 1.22
DBWR transaction table writes 2,676 0.74 0.00
DBWR undo block writes 1,577,808 437.13 2.65
DFO trees parallelized 78 0.02 0.00
PX local messages recv'd 36,938 10.23 0.06
PX local messages sent 36,938 10.23 0.06
PX remote messages recv'd 34,394 9.53 0.06
PX remote messages sent 25,165 6.97 0.04
Parallel operations not downgraded 78 0.02 0.00
RowCR - row contention 50,170 13.90 0.08
RowCR attempts 15,332,427 4,247.79 25.78
RowCR hits 15,048,503 4,169.13 25.30
SMON posted for undo segment shrink 2 0.00 0.00
SQL*Net roundtrips to/from client 16,742,560 4,638.47 28.15
active txn count during cleanout 63,418,597 17,569.89 106.63
application wait time 26,796 7.42 0.05
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 12,716 3.52 0.02
branch node splits 1,059 0.29 0.00
buffer is not pinned count 480,632,181 133,157.40 808.14
buffer is pinned count 763,815,487 211,612.31 1,284.28
bytes received via SQL*Net from client 6,775,514,249 1,877,131.66 11,392.40
bytes sent via SQL*Net to client 4,789,694,476 1,326,967.49 8,053.43
calls to get snapshot scn: kcmgss 84,360,942 23,371.89 141.85
calls to kcmgas 14,796,901 4,099.43 24.88
calls to kcmgcs 12,348,585 3,421.13 20.76
change write time 72,618 20.12 0.12
cleanout - number of ktugct calls 21,854,129 6,054.61 36.75
cleanouts and rollbacks - consistent read gets 8,879,160 2,459.94 14.93
cleanouts only - consistent read gets 163,380 45.26 0.27
cluster key scan block gets 730,945 202.51 1.23
cluster key scans 167,623 46.44 0.28
cluster wait time 81,011 22.44 0.14
commit batch/immediate performed 4,302 1.19 0.01
commit batch/immediate requested 4,302 1.19 0.01
commit cleanout failures: block lost 240,738 66.70 0.40
commit cleanout failures: buffer being written 291 0.08 0.00
commit cleanout failures: callback failure 111,680 30.94 0.19
commit cleanout failures: cannot pin 18,904 5.24 0.03
commit cleanouts 6,519,522 1,806.21 10.96
commit cleanouts successfully completed 6,147,909 1,703.26 10.34
commit immediate performed 4,302 1.19 0.01
commit immediate requested 4,302 1.19 0.01
commit txn count during cleanout 1,185,495 328.44 1.99
concurrency wait time 32,563 9.02 0.05
consistent changes 405,230,938 112,267.76 681.36
consistent gets 1,226,181,595 339,709.17 2,061.71
consistent gets - examination 823,027,289 228,016.73 1,383.84
consistent gets from cache 1,225,909,279 339,633.72 2,061.25
current blocks converted for CR 1 0.00 0.00
cursor authentications 1,478 0.41 0.00
data blocks consistent reads - undo records applied 401,125,058 111,130.24 674.45
db block changes 184,576,401 51,136.22 310.35
db block gets 212,802,048 58,956.04 357.81
db block gets direct 3,923 1.09 0.01
db block gets from cache 212,798,118 58,954.95 357.80
deferred (CURRENT) block cleanout applications 1,031,632 285.81 1.73
dirty buffers inspected 4,591 1.27 0.01
enqueue conversions 12,235 3.39 0.02
enqueue releases 2,888,648 800.29 4.86
enqueue requests 2,897,413 802.72 4.87
enqueue timeouts 8,725 2.42 0.01
enqueue waits 129,125 35.77 0.22
exchange deadlocks 39,132 10.84 0.07
execute count 73,447,417 20,348.34 123.50
failed probes on index block reclamation 14,533 4.03 0.02
free buffer inspected 1,366,540 378.59 2.30
free buffer requested 15,900,147 4,405.08 26.73
gc CPU used by this session 42,124 11.67 0.07
gc cr block build time 967 0.27 0.00
gc cr block flush time 6,716 1.86 0.01
gc cr block receive time 17,387 4.82 0.03
gc cr block send time 1,055 0.29 0.00
gc cr blocks received 193,574 53.63 0.33
gc cr blocks served 305,563 84.66 0.51
gc current block flush time 5,227 1.45 0.01
gc current block pin time 48,530,828 13,445.29 81.60
gc current block receive time 7,201 2.00 0.01
gc current block send time 411 0.11 0.00
gc current blocks received 102,016 28.26 0.17
gc current blocks served 113,712 31.50 0.19
gc local grants 1,942,143 538.06 3.27
gc remote grants 396,977 109.98 0.67
gcs messages sent 2,249,200 623.13 3.78
ges messages sent 260,744 72.24 0.44
global enqueue get time 61,268 16.97 0.10
global enqueue gets async 91,549 25.36 0.15
global enqueue gets sync 8,346,788 2,312.45 14.03
global enqueue releases 8,270,343 2,291.27 13.91
heap block compress 25,700,041 7,120.10 43.21
hot buffers moved to head of LRU 281,729 78.05 0.47
immediate (CR) block cleanout applications 9,042,570 2,505.21 15.20
immediate (CURRENT) block cleanout applications 1,020,734 282.79 1.72
index crx upgrade (found) 47,159 13.07 0.08
index crx upgrade (positioned) 8,357,865 2,315.52 14.05
index fast full scans (rowid ranges) 3,132 0.87 0.01
index fetch by key 163,420,004 45,274.92 274.78
index scans kdiixs1 99,330,030 27,519.02 167.01
java call heap collected bytes 1,183,078,936 327,767.73 1,989.24
java call heap collected count 15,137,009 4,193.65 25.45
java call heap gc count 3,871 1.07 0.01
java call heap live object count 1,706,324 472.73 2.87
java call heap live object count max 1,650,535 457.27 2.78
java call heap live size 551,033,440 152,661.82 926.51
java call heap live size max 539,433,328 149,448.05 907.01
java call heap object count 3,932,009 1,089.35 6.61
java call heap object count max 3,927,185 1,088.01 6.60
java call heap total size 753,532,928 208,763.57 1,267.00
java call heap total size max 737,804,288 204,406.00 1,240.55
java call heap used size 694,955,656 192,534.95 1,168.50
java call heap used size max 687,557,160 190,485.22 1,156.06
leaf node 90-10 splits 18,302 5.07 0.03
leaf node splits 246,714 68.35 0.41
lob reads 12,024 3.33 0.02
lob writes 9,936 2.75 0.02
lob writes unaligned 9,936 2.75 0.02
logons cumulative 8,309 2.30 0.01
messages received 1,593,238 441.40 2.68
messages sent 1,593,142 441.37 2.68
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 347,839,237 96,367.60 584.86
opened cursors cumulative 5,249,322 1,454.31 8.83
parse count (failures) 0 0.00 0.00
parse count (hard) 4,328 1.20 0.01
parse count (total) 8,524,422 2,361.66 14.33
parse time cpu 60,138 16.66 0.10
parse time elapsed 68,835 19.07 0.12
physical read IO requests 88,447 24.50 0.15
physical read bytes 1,359,855,616 376,743.07 2,286.47
physical read total IO requests 97,972 27.14 0.16
physical read total bytes 1,514,102,784 419,476.69 2,545.82
physical read total multi block requests 11,433 3.17 0.02
physical reads 166,293 46.07 0.28
physical reads cache 165,386 45.82 0.28
physical reads cache prefetch 77,490 21.47 0.13
physical reads direct 612 0.17 0.00
physical reads direct temporary tablespace 186 0.05 0.00
physical reads prefetch warmup 36,743 10.18 0.06
physical write IO requests 1,033,215 286.25 1.74
physical write bytes 24,669,356,032 6,834,555.67 41,479.23
physical write total IO requests 1,780,266 493.22 2.99
physical write total bytes 56,366,712,832 15,616,193.48 94,775.39
physical write total multi block requests 1,095,262 303.44 1.84
physical writes 3,011,396 834.30 5.06
physical writes direct 4,351 1.21 0.01
physical writes direct (lob) 216 0.06 0.00
physical writes direct temporary tablespace 3,829 1.06 0.01
physical writes from cache 3,007,045 833.09 5.06
physical writes non checkpoint 2,273,435 629.85 3.82
pinned buffers inspected 466 0.13 0.00
prefetch warmup blocks aged out before use 11,530 3.19 0.02
prefetched blocks aged out before use 16 0.00 0.00
process last non-idle time 3,610 1.00 0.01
queries parallelized 78 0.02 0.00
recursive aborts on index block reclamation 1 0.00 0.00
recursive calls 129,375,784 35,843.09 217.53
recursive cpu usage 1,264,957 350.45 2.13
redo blocks written 61,744,316 17,106.04 103.82
redo entries 97,357,399 26,972.51 163.70
redo ordering marks 1,176,630 325.98 1.98
redo size 30,359,126,272 8,410,885.89 51,046.05
redo subscn max counts 215,138 59.60 0.36
redo synch time 41,929 11.62 0.07
redo synch writes 788,188 218.36 1.33
redo wastage 220,121,660 60,983.91 370.11
redo write time 36,105 10.00 0.06
redo writer latching time 286 0.08 0.00
redo writes 529,206 146.61 0.89
rollback changes - undo records applied 247,328 68.52 0.42
rollbacks only - consistent read gets 2,131,288 590.47 3.58
rows fetched via callback 82,637,177 22,894.33 138.95
session connect time 0 0.00 0.00
session cursor cache hits 4,765,220 1,320.19 8.01
session logical reads 1,438,983,277 398,665.10 2,419.52
session pga memory 2,586,365,296 716,543.13 4,348.73
session pga memory max 4,495,737,744 1,245,527.85 7,559.16
session uga memory 1,257,924,200 348,503.34 2,115.08
session uga memory max 64,674,558,432 17,917,851.99 108,744.26
shared hash latch upgrades - no wait 34,191,177 9,472.54 57.49
shared hash latch upgrades - wait 72,835 20.18 0.12
sorts (memory) 8,826,159 2,445.26 14.84
sorts (rows) 79,016,723 21,891.30 132.86
sql area evicted 628 0.17 0.00
sql area purged 169 0.05 0.00
summed dirty queue length 75,043 20.79 0.13
switch current to new buffer 1,337,668 370.60 2.25
table fetch by rowid 490,391,096 135,861.08 824.55
table fetch continued row 33,382,230 9,248.43 56.13
table scan blocks gotten 54,204,408 15,017.13 91.14
table scan rows gotten 4,363,603,176 1,208,920.44 7,336.99
table scans (long tables) 4,560 1.26 0.01
table scans (rowid ranges) 4,558 1.26 0.01
table scans (short tables) 4,867,031 1,348.39 8.18
total number of times SMON posted 152,827 42.34 0.26
transaction lock background get time 0 0.00 0.00
transaction lock background gets 26 0.01 0.00
transaction lock foreground requests 26 0.01 0.00
transaction lock foreground wait time 5 0.00 0.00
transaction rollbacks 4,302 1.19 0.01
transaction tables consistent read rollbacks 62 0.02 0.00
transaction tables consistent reads - undo records applied 3,055 0.85 0.01
undo change vector size 10,791,527,264 2,989,753.51 18,144.95
user I/O wait time 36,744 10.18 0.06
user calls 15,916,611 4,409.64 26.76
user commits 544,124 150.75 0.91
user rollbacks 50,616 14.02 0.09
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 5,084,036 1,408.51 8.55
write clones created in background 220 0.06 0.00
write clones created in foreground 3,254 0.90 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

  • Statistics with absolute values (should not be diffed)
StatisticBegin ValueEnd Value
session cursor cache count 266,511 871,564
opened cursors current 283,680 295,384
workarea memory allocated 0 610
logons current 1,900 1,877

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

  • Statistics identified by '(derived)' come from sources other than SYSSTAT
StatisticTotalper Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

  • ordered by IOs (Reads + Writes) desc
TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_UNDOTS1 20 0 458.00 1.00 441,562 122 192,192 0.05
APPS_TS_TX_DATA 36,274 10 4.19 1.56 153,108 42 137,132 0.58
APPS_ASSM_DATA 13,534 4 2.72 4.11 159,865 44 59,611 0.38
APPS_ASSM_IDX 5,676 2 2.50 1.10 122,540 34 234,747 0.13
APPS_TS_TX_IDX 28,510 8 4.09 1.35 97,747 27 75,735 2.23
APPS_TS_TX_INTERFACE 335 0 11.25 3.39 33,113 9 4,573 0.15
APPS_TS_SUMMARY 32 0 110.63 1.00 6,844 2 2,326 0.09
APPS_TS_QUEUES 42 0 129.76 1.57 6,652 2 385 48.81
SYSTEM 3,023 1 13.73 1.00 2,696 1 23,548 0.72
TEMP 493 0 3.20 7.79 4,838 1 0 0.00
APPS_TS_SEED 287 0 20.66 2.99 1,741 0 782 3.18
APPS_TS_ARCHIVE 26 0 63.46 2.50 1,956 1 207 7.58
SYSAUX 223 0 18.12 1.00 431 0 0 0.00
APPS_TS_NOLOGGING 18 0 125.00 1.00 37 0 0 0.00
APPS_UNDOTS2 20 0 407.00 1.00 20 0 2,995 55.33
CTXSYS 12 0 20.83 1.00 4 0 0 0.00
APPS_TS_MEDIA 6 0 525.00 1.00 6 0 0 0.00
ODM 6 0 243.33 1.00 2 0 0 0.00
OLAP 6 0 13.33 1.00 2 0 0 0.00
OWAPUB 6 0 13.33 1.00 2 0 0 0.00
PORTAL 6 0 11.67 1.00 2 0 0 0.00
SYNCSERVER 6 0 188.33 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

  • ordered by Tablespace, File
TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_ASSM_DATA /oracle/visdata/apps_assm_data.dbf 13,534 4 2.72 4.11 159,865 44 59,611 0.38
APPS_ASSM_IDX /oracle/visdata/apps_assm_idx.dbf 5,676 2 2.50 1.10 122,540 34 234,747 0.13
APPS_TS_ARCHIVE /oracle/visdata/archive1.dbf 19 0 44.74 3.05 182 0 69 16.67
APPS_TS_ARCHIVE /oracle/visdata/archive2.dbf 7 0 114.29 1.00 1,774 0 138 3.04
APPS_TS_MEDIA /oracle/visdata/media1.dbf 2 0 380.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /oracle/visdata/media2.dbf 2 0 820.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /oracle/visdata/media3.dbf 2 0 375.00 1.00 2 0 0 0.00
APPS_TS_NOLOGGING /oracle/visdata/nologging1.dbf 2 0 365.00 1.00 2 0 0 0.00
APPS_TS_NOLOGGING /oracle/visdata/nologging2.dbf 13 0 60.77 1.00 26 0 0 0.00
APPS_TS_NOLOGGING /oracle/visdata/nologging3.dbf 3 0 243.33 1.00 9 0 0 0.00
APPS_TS_QUEUES /oracle/visdata/queues1.dbf 2 0 360.00 1.00 746 0 12 0.83
APPS_TS_QUEUES /oracle/visdata/queues2.dbf 30 0 28.00 1.80 1,381 0 96 29.58
APPS_TS_QUEUES /oracle/visdata/queues3.dbf 2 0 685.00 1.00 913 0 118 39.58
APPS_TS_QUEUES /oracle/visdata/queues4.dbf 2 0 365.00 1.00 978 0 99 46.57
APPS_TS_QUEUES /oracle/visdata/queues5.dbf 2 0 345.00 1.00 957 0 6 0.00
APPS_TS_QUEUES /oracle/visdata/queues6.dbf 2 0 345.00 1.00 953 0 45 147.78
APPS_TS_QUEUES /oracle/visdata/queues7.dbf 2 0 205.00 1.00 724 0 9 1.11
APPS_TS_SEED /oracle/visdata/reference1.dbf 6 0 73.33 3.00 164 0 21 5.24
APPS_TS_SEED /oracle/visdata/reference10.dbf 8 0 51.25 2.88 175 0 25 5.60
APPS_TS_SEED /oracle/visdata/reference2.dbf 50 0 13.40 2.74 255 0 278 2.81
APPS_TS_SEED /oracle/visdata/reference3.dbf 75 0 21.33 3.76 235 0 202 3.71
APPS_TS_SEED /oracle/visdata/reference4.dbf 24 0 24.17 3.25 122 0 66 1.52
APPS_TS_SEED /oracle/visdata/reference5.dbf 17 0 27.06 3.24 171 0 18 3.89
APPS_TS_SEED /oracle/visdata/reference6.dbf 28 0 15.00 1.96 105 0 34 0.88
APPS_TS_SEED /oracle/visdata/reference7.dbf 29 0 15.17 2.00 161 0 24 2.08
APPS_TS_SEED /oracle/visdata/reference8.dbf 16 0 26.88 3.38 194 0 41 2.93
APPS_TS_SEED /oracle/visdata/reference9.dbf 34 0 14.12 2.91 159 0 73 4.66
APPS_TS_SUMMARY /oracle/visdata/summary1.dbf 4 0 95.00 1.00 933 0 177 0.06
APPS_TS_SUMMARY /oracle/visdata/summary2.dbf 4 0 85.00 1.00 963 0 425 0.07
APPS_TS_SUMMARY /oracle/visdata/summary3.dbf 4 0 85.00 1.00 661 0 285 0.04
APPS_TS_SUMMARY /oracle/visdata/summary4.dbf 4 0 300.00 1.00 676 0 209 0.10
APPS_TS_SUMMARY /oracle/visdata/summary5.dbf 4 0 82.50 1.00 710 0 249 0.20
APPS_TS_SUMMARY /oracle/visdata/summary6.dbf 4 0 80.00 1.00 1,054 0 413 0.07
APPS_TS_SUMMARY /oracle/visdata/summary7.dbf 4 0 80.00 1.00 996 0 359 0.17
APPS_TS_SUMMARY /oracle/visdata/summary8.dbf 4 0 77.50 1.00 851 0 209 0.05
APPS_TS_TX_DATA /oracle/visdata/tx_data1.dbf 4 0 82.50 1.00 2 0 1 0.00
APPS_TS_TX_DATA /oracle/visdata/tx_data10.dbf 209 0 6.94 3.19 1,419 0 2,198 3.72
APPS_TS_TX_DATA /oracle/visdata/tx_data11.dbf 35 0 26.57 5.23 561 0 1,454 5.69
APPS_TS_TX_DATA /oracle/visdata/tx_data12.dbf 3,101 1 4.00 1.62 16,096 4 13,992 0.48
APPS_TS_TX_DATA /oracle/visdata/tx_data13.dbf 3,031 1 4.18 1.64 15,673 4 13,961 0.38
APPS_TS_TX_DATA /oracle/visdata/tx_data14.dbf 3,003 1 4.36 1.63 15,916 4 13,157 0.41
APPS_TS_TX_DATA /oracle/visdata/tx_data15.dbf 3,057 1 4.02 1.66 15,004 4 12,886 0.50
APPS_TS_TX_DATA /oracle/visdata/tx_data16.dbf 2,985 1 4.34 1.65 14,785 4 12,876 0.36
APPS_TS_TX_DATA /oracle/visdata/tx_data17.dbf 3,017 1 4.19 1.66 14,227 4 12,333 0.58
APPS_TS_TX_DATA /oracle/visdata/tx_data18.dbf 2,965 1 4.25 1.60 14,588 4 13,363 0.37
APPS_TS_TX_DATA /oracle/visdata/tx_data19.dbf 3,001 1 4.61 1.56 14,125 4 13,542 0.47
APPS_TS_TX_DATA /oracle/visdata/tx_data2.dbf 1,378 0 4.05 1.13 401 0 40 6.50
APPS_TS_TX_DATA /oracle/visdata/tx_data20.dbf 2,976 1 3.90 1.56 14,612 4 13,744 0.77
APPS_TS_TX_DATA /oracle/visdata/tx_data21.dbf 2,989 1 3.98 1.58 14,171 4 13,471 0.34
APPS_TS_TX_DATA /oracle/visdata/tx_data3.dbf 875 0 3.62 1.22 381 0 32 3.44
APPS_TS_TX_DATA /oracle/visdata/tx_data4.dbf 896 0 3.95 1.21 329 0 19 8.95
APPS_TS_TX_DATA /oracle/visdata/tx_data5.dbf 1,375 0 4.08 1.19 418 0 33 4.55
APPS_TS_TX_DATA /oracle/visdata/tx_data6.dbf 4 0 55.00 1.00 14 0 1 0.00
APPS_TS_TX_DATA /oracle/visdata/tx_data7.dbf 1,365 0 3.55 1.14 373 0 28 3.57
APPS_TS_TX_DATA /oracle/visdata/tx_data8.dbf 4 0 55.00 1.00 9 0 0 0.00
APPS_TS_TX_DATA /oracle/visdata/tx_data9.dbf 4 0 57.50 1.00 4 0 1 10.00
APPS_TS_TX_IDX /oracle/visdata/tx_idx1.dbf 1,299 0 3.83 1.21 248 0 226 3.63
APPS_TS_TX_IDX /oracle/visdata/tx_idx10.dbf 672 0 5.30 2.82 1,814 1 344 2.65
APPS_TS_TX_IDX /oracle/visdata/tx_idx11.dbf 1,661 0 3.80 1.42 902 0 879 3.08
APPS_TS_TX_IDX /oracle/visdata/tx_idx12.dbf 1,693 0 4.22 1.39 13,442 4 18,226 2.66
APPS_TS_TX_IDX /oracle/visdata/tx_idx13.dbf 1,505 0 4.11 1.35 10,423 3 6,417 0.50
APPS_TS_TX_IDX /oracle/visdata/tx_idx14.dbf 1,455 0 4.00 1.41 9,357 3 5,318 0.54
APPS_TS_TX_IDX /oracle/visdata/tx_idx15.dbf 1,448 0 3.72 1.32 8,849 2 6,247 0.57
APPS_TS_TX_IDX /oracle/visdata/tx_idx16.dbf 1,408 0 3.84 1.35 8,852 2 7,561 5.10
APPS_TS_TX_IDX /oracle/visdata/tx_idx17.dbf 1,341 0 3.86 1.29 9,185 3 6,183 3.07
APPS_TS_TX_IDX /oracle/visdata/tx_idx18.dbf 1,306 0 7.04 1.27 8,290 2 6,884 5.41
APPS_TS_TX_IDX /oracle/visdata/tx_idx19.dbf 1,318 0 4.04 1.31 8,132 2 5,124 0.41
APPS_TS_TX_IDX /oracle/visdata/tx_idx2.dbf 1,349 0 4.00 1.39 684 0 353 2.80
APPS_TS_TX_IDX /oracle/visdata/tx_idx20.dbf 1,341 0 3.80 1.27 7,667 2 3,935 0.36
APPS_TS_TX_IDX /oracle/visdata/tx_idx21.dbf 1,336 0 5.16 1.38 7,192 2 5,092 0.41
APPS_TS_TX_IDX /oracle/visdata/tx_idx3.dbf 1,357 0 3.89 1.30 458 0 451 2.24
APPS_TS_TX_IDX /oracle/visdata/tx_idx4.dbf 1,371 0 3.33 1.27 418 0 845 1.08
APPS_TS_TX_IDX /oracle/visdata/tx_idx5.dbf 1,332 0 3.85 1.25 559 0 539 1.22
APPS_TS_TX_IDX /oracle/visdata/tx_idx6.dbf 1,315 0 3.57 1.23 311 0 178 2.19
APPS_TS_TX_IDX /oracle/visdata/tx_idx7.dbf 1,359 0 3.77 1.26 411 0 282 3.55
APPS_TS_TX_IDX /oracle/visdata/tx_idx8.dbf 1,332 0 3.78 1.24 365 0 397 1.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx9.dbf 1,312 0 3.80 1.23 188 0 254 2.68
APPS_TS_TX_INTERFACE /oracle/visdata/ts_tx_inte.dbf 42 0 7.38 4.24 5,243 1 776 0.24
APPS_TS_TX_INTERFACE /oracle/visdata/ts_tx_inte2.dbf 54 0 8.70 3.37 5,319 1 751 0.13
APPS_TS_TX_INTERFACE /oracle/visdata/ts_tx_inte3.dbf 33 0 10.61 4.39 5,359 1 538 0.07
APPS_TS_TX_INTERFACE /oracle/visdata/ts_tx_inte4.dbf 48 0 36.67 2.56 5,344 1 690 0.12
APPS_TS_TX_INTERFACE /oracle/visdata/ts_tx_inte5.dbf 102 0 5.59 3.04 6,103 2 944 0.04
APPS_TS_TX_INTERFACE /oracle/visdata/ts_tx_inte6.dbf 56 0 5.54 3.54 5,745 2 874 0.29
APPS_UNDOTS1 /oracle/visdata/undo101.dbf 2 0 430.00 1.00 46,271 13 16,417 0.04
APPS_UNDOTS1 /oracle/visdata/undo102.dbf 2 0 755.00 1.00 41,014 11 14,597 0.06
APPS_UNDOTS1 /oracle/visdata/undo103.dbf 2 0 425.00 1.00 44,516 12 24,102 0.06
APPS_UNDOTS1 /oracle/visdata/undo104.dbf 2 0 425.00 1.00 39,636 11 16,529 0.05
APPS_UNDOTS1 /oracle/visdata/undo105.dbf 2 0 425.00 1.00 45,216 13 20,471 0.05
APPS_UNDOTS1 /oracle/visdata/undo106.dbf 2 0 420.00 1.00 46,066 13 16,862 0.07
APPS_UNDOTS1 /oracle/visdata/undo107.dbf 2 0 420.00 1.00 41,326 11 19,410 0.06
APPS_UNDOTS1 /oracle/visdata/undo108.dbf 2 0 435.00 1.00 45,474 13 14,756 0.05
APPS_UNDOTS1 /oracle/visdata/undo109.dbf 2 0 415.00 1.00 45,567 13 19,205 0.05
APPS_UNDOTS1 /oracle/visdata/undo110.dbf 2 0 430.00 1.00 46,476 13 29,843 0.05
APPS_UNDOTS2 /oracle/visdata/undo201.dbf 2 0 410.00 1.00 2 0 418 25.05
APPS_UNDOTS2 /oracle/visdata/undo202.dbf 2 0 475.00 1.00 2 0 471 46.96
APPS_UNDOTS2 /oracle/visdata/undo203.dbf 2 0 400.00 1.00 2 0 11 0.91
APPS_UNDOTS2 /oracle/visdata/undo204.dbf 2 0 400.00 1.00 2 0 279 54.27
APPS_UNDOTS2 /oracle/visdata/undo205.dbf 2 0 400.00 1.00 2 0 278 88.09
APPS_UNDOTS2 /oracle/visdata/undo206.dbf 2 0 395.00 1.00 2 0 785 57.81
APPS_UNDOTS2 /oracle/visdata/undo207.dbf 2 0 395.00 1.00 2 0 212 94.67
APPS_UNDOTS2 /oracle/visdata/undo208.dbf 2 0 395.00 1.00 2 0 15 2.00
APPS_UNDOTS2 /oracle/visdata/undo209.dbf 2 0 390.00 1.00 2 0 303 0.33
APPS_UNDOTS2 /oracle/visdata/undo210.dbf 2 0 410.00 1.00 2 0 223 125.11
CTXSYS /oracle/visdata/ctx1.dbf 6 0 28.33 1.00 2 0 0 0.00
CTXSYS /oracle/visdata/ctx2.dbf 6 0 13.33 1.00 2 0 0 0.00
ODM /oracle/visdata/odm.dbf 6 0 243.33 1.00 2 0 0 0.00
OLAP /oracle/visdata/olap.dbf 6 0 13.33 1.00 2 0 0 0.00
OWAPUB /oracle/visdata/owa1.dbf 6 0 13.33 1.00 2 0 0 0.00
PORTAL /oracle/visdata/portal.dbf 6 0 11.67 1.00 2 0 0 0.00
SYNCSERVER /oracle/visdata/mobile01.dbf 6 0 188.33 1.00 2 0 0 0.00
SYSAUX /oracle/visdata/sysaux01.dbf 221 0 10.18 1.00 336 0 0 0.00
SYSAUX /oracle/visdata/sysaux02.dbf 2 0 895.00 1.00 95 0 0 0.00
SYSTEM /oracle/visdata/sys1.dbf 347 0 13.78 1.00 251 0 1,929 0.15
SYSTEM /oracle/visdata/sys2.dbf 381 0 12.99 1.00 327 0 11,133 0.71
SYSTEM /oracle/visdata/sys3.dbf 352 0 13.86 1.00 393 0 10,081 0.15
SYSTEM /oracle/visdata/sys4.dbf 375 0 12.93 1.00 493 0 46 1.52
SYSTEM /oracle/visdata/sys5.dbf 338 0 14.76 1.00 315 0 190 0.42
SYSTEM /oracle/visdata/sys6.dbf 290 0 17.55 1.00 141 0 25 0.80
SYSTEM /oracle/visdata/sys7.dbf 291 0 15.19 1.00 172 0 31 0.65
SYSTEM /oracle/visdata/sys8.dbf 367 0 12.83 1.00 351 0 72 97.64
SYSTEM /oracle/visdata/sys9.dbf 282 0 10.11 1.00 253 0 41 0.24
TEMP /oracle/visdata/temp1.dbf 7 0 4.29 1.00 1,257 0 0  
TEMP /oracle/visdata/temp2.dbf 62 0 2.58 7.45 1,253 0 0  
TEMP /oracle/visdata/temp3.dbf 414 0 3.12 7.69 1,135 0 0  
TEMP /oracle/visdata/temp4.dbf 10 0 10.00 19.00 1,193 0 0  

Back to IO Stats
Back to Top

Buffer Pool Statistics

  • Standard block size Pools D: default, K: keep, R: recycle
  • Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,694,276 100 1,425,844,599 165,437 3,007,045 0 0 734,287


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

  • B: Begin snapshot, E: End snapshot
Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 180 85 34228 823965 3018088 94355190 3018088  
E 180 113 49928 1162501 8826147 94355190 8826147  

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 % - percentage of W/A (WorkArea) data processed only in-memory
PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 116,206 6

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  • B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
  • Auto PGA Target - actual workarea memory target
  • W/A PGA Used - amount of memory used for all Workareas (manual + auto)
  • %PGA W/A Mem - percentage of PGA memory allocated to workareas
  • %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
  • %Man W/A Mem - percentage of workarea memory under manual control
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 MemGlobal Mem Bound(K)
B 20,480 8,129 18,091.80 0.00 0.00 0.00 0.00 1,048,576
E 20,480 7,472 18,700.76 0.00 0.00 0.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

  • Optimal Executions are purely in-memory operations
Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 4,945,842 4,945,842 0 0
64K 128K 11,136 11,136 0 0
128K 256K 1,001 1,001 0 0
256K 512K 752 752 0 0
512K 1024K 113,263 113,263 0 0
1M 2M 8,384 8,384 0 0
2M 4M 58 56 2 0
4M 8M 12 12 0 0
8M 16M 6 6 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

  • When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0
PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
2,560 0.13 158,556.71 6,742.99 96.00 702
5,120 0.25 158,556.71 6,663.16 96.00 668
10,240 0.50 158,556.71 6,431.11 96.00 600
15,360 0.75 158,556.71 2.78 100.00 0
20,480 1.00 158,556.71 2.78 100.00 0
24,576 1.20 158,556.71 0.00 100.00 0
28,672 1.40 158,556.71 0.00 100.00 0
32,768 1.60 158,556.71 0.00 100.00 0
36,864 1.80 158,556.71 0.00 100.00 0
40,960 2.00 158,556.71 0.00 100.00 0
61,440 3.00 158,556.71 0.00 100.00 0
81,920 4.00 158,556.71 0.00 100.00 0
122,880 6.00 158,556.71 0.00 100.00 0
163,840 8.00 158,556.71 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

  • SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
  • Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.
Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
2,112 0.70 346 12,228 2,385,922 1.00 1,548 1.21 127,408,191
2,416 0.80 639 16,203 2,386,187 1.00 1,283 1.00 127,421,839
2,720 0.90 866 23,001 2,386,188 1.00 1,282 1.00 127,422,073
3,024 1.00 869 23,447 2,386,188 1.00 1,282 1.00 127,422,075
3,328 1.10 869 23,447 2,386,188 1.00 1,282 1.00 127,422,075
3,632 1.20 869 23,447 2,386,188 1.00 1,282 1.00 127,422,075
3,936 1.30 869 23,447 2,386,188 1.00 1,282 1.00 127,422,075
4,240 1.40 869 23,447 2,386,188 1.00 1,282 1.00 127,422,075
4,544 1.50 869 23,447 2,386,188 1.00 1,282 1.00 127,422,075
4,848 1.60 869 23,447 2,386,188 1.00 1,282 1.00 127,422,075
5,152 1.70 869 23,447 2,386,188 1.00 1,282 1.00 127,422,075
5,456 1.80 869 23,447 2,386,188 1.00 1,282 1.00 127,422,075
5,760 1.90 869 23,447 2,386,188 1.00 1,282 1.00 127,422,075
6,064 2.01 869 23,447 2,386,188 1.00 1,282 1.00 127,422,075

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
6,400 0.25 29,186  
12,800 0.50 29,186  
19,200 0.75 29,186  
25,600 1.00 29,180  
32,000 1.25 29,187  
38,400 1.50 29,187  
44,800 1.75 29,191  
51,200 2.00 29,191  

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
16 0.25 7 253 64 1.00 1,283 1.00 9,120
32 0.50 7 253 64 1.00 1,283 1.00 9,120
48 0.75 7 253 64 1.00 1,283 1.00 9,120
64 1.00 7 253 64 1.00 1,283 1.00 9,120
80 1.25 7 253 64 1.00 1,283 1.00 9,120
96 1.50 7 253 64 1.00 1,283 1.00 9,120
112 1.75 7 253 64 1.00 1,283 1.00 9,120
128 2.00 7 253 64 1.00 1,283 1.00 9,120

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 530,667 311 1
undo header 70,964 171 2
1st level bmb 5,421 13 2
segment header 1,986 9 4
2nd level bmb 901 9 10
undo block 124,219 6 0
extent map 9 0 1
file header block 37 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 7,823 786 7,034 775 138 178.43
UL-User-defined 67,248 66,203 1,045 32,002 128 3.99
TX-Transaction (index contention) 32,199 30,856 0 27,784 71 2.57
HW-Segment High Water Mark 235,533 235,528 2 29,971 58 1.93
FB-Format Block 35,581 35,581 0 17,188 35 2.04
TX-Transaction 890,958 891,002 0 2,533 31 12.27
RO-Multiple Object Reuse (fast object reuse) 288 288 0 80 8 101.88
US-Undo Segment 15,641 15,630 0 9,928 8 0.78
SQ-Sequence Cache 33,100 33,100 0 5,916 4 0.75
DV-Diana Versioning 32,338 32,338 0 1,113 3 2.69
WF-AWR Flush 13 13 0 8 1 145.00
TX-Transaction (allocate ITL entry) 169 169 0 131 1 4.89
PS-PX Process Reservation 5,725 5,081 640 1,174 1 0.54
CF-Controlfile Transaction 8,168 8,166 2 131 0 1.30
TT-Tablespace 174,930 174,931 0 164 0 0.55
TO-Temp Object 38,584 38,584 0 74 0 0.95
TM-DML 1,070,211 1,070,139 0 83 0 0.60
TS-Temporary Segment 69 69 0 13 0 2.31
KM-Scheduler 175,997 175,997 0 9 0 2.22
ST-Space Transaction 6 6 0 6 0 3.33
TA-Instance Undo 24 24 0 24 0 0.42
MW-MWIN Schedule 2 2 0 2 0 5.00
MD-Materialized View Log DDL 16 16 0 10 0 0.00
CU-Cursor 4,060 4,060 0 2 0 0.00
DL-Direct Loader Index Creation 32 32 0 2 0 0.00
DR-Distributed Recovery 2 2 0 2 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
2 1,577.57 886,541 2,665 270 192.2/475.75 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
08-Mar 08:44 212,695 113,593 185 256 202 0/0 0/0/0/0/0/0
08-Mar 08:34 48,317 54,549 251 251 209 0/0 0/0/0/0/0/0
08-Mar 08:24 488,741 157,623 2,566 255 192 0/0 0/0/0/0/0/0
08-Mar 08:14 321,078 169,608 2,665 259 259 0/0 0/0/0/0/0/0
08-Mar 08:04 235,942 211,764 2,061 260 342 0/0 0/0/0/0/0/0
08-Mar 07:54 270,799 179,404 2,057 270 476 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 2,845 0.00   0 0  
AWR Alerted Metric Element list 126,132 0.00   0 0  
Consistent RBA 529,468 0.01 0.43 0 0  
FOB s.o list latch 56,932 0.01 0.00 0 0  
JOX SGA heap latch 1,929,306 0.00   0 0  
JS broadcast add buf latch 824 0.00   0 0  
JS broadcast drop buf latch 824 0.00   0 0  
JS broadcast load blnc latch 721 0.00   0 0  
JS mem alloc latch 12 0.00   0 2 0.00
JS queue access latch 12 0.00   0 0  
JS queue state obj latch 21,630 0.00   0 0  
KCL gc element parent latch 13,578,265 0.02 0.08 0 29,586 0.02
KJC destination ctx free list 0     0 2 0.00
KJC message pool free list 927,700 0.05 0.02 0 88,952 0.04
KJC receiver ctx free list 0     0 2 0.00
KJCT flow control latch 3,351,487 0.05 0.02 0 0  
KMG MMAN ready and startup request latch 1,204 0.00   0 0  
KMG resize request state object freelist 2 0.00   0 0  
KSXR large replies 242 0.00   0 0  
KTF sga latch 24 0.00   0 1,215 0.00
KWQMN job cache list latch 8,909 0.02 0.00 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 22 4.55 0.00 0 1,203 0.00
NLS data objects 23 0.00   0 0  
OS process 15,225 0.00   0 0  
OS process allocation 11,333 0.04 0.00 0 0  
OS process: request allocation 10,042 0.02 0.00 0 0  
PL/SQL warning settings 3,446,718 0.00   0 0  
SGA IO buffer pool latch 57,334 0.00   0 70,292 0.00
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 4,006,193 0.01 0.01 0 0  
Shared B-Tree 128 0.00   0 0  
active checkpoint queue latch 507,798 0.00   0 2 0.00
active service list 42,661 0.48 0.02 0 2,591 0.00
alert log latch 0     0 2 0.00
begin backup scn array 129 0.00   0 0  
buffer pool 2 0.00   0 0  
business card 156 0.00   0 0  
cache buffer handles 19,114,957 1.83 0.00 0 0  
cache buffers chains 3,303,987,802 1.25 0.03 69 17,083,928 1.45
cache buffers lru chain 11,455,916 0.45 0.02 2 27,691,490 0.70
cache table scan latch 0     0 5,950 0.05
channel handle pool latch 300,365 0.08 0.03 0 0  
channel operations parent latch 9,528,564 0.37 0.00 0 0  
checkpoint queue latch 21,029,222 0.02 0.01 0 3,132,893 0.05
client/application info 1,079,420 0.00 0.00 0 0  
commit callback allocation 34,435 0.00   0 0  
compile environment latch 1,099,837 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 2,124,052 0.27 0.01 0 0  
dummy allocation 16,685 0.80 0.00 0 0  
enqueue hash chains 9,621,717 0.20 0.01 0 1,406 0.07
enqueues 2,902,540 0.16 0.01 0 0  
error message lists 3,002 1.40 0.00 0 0  
event group latch 5,011 0.00   0 0  
file cache latch 24,737 0.00 0.00 0 0  
gcs drop object freelist 789 0.25 0.00 0 0  
gcs opaque info freelist 265,530 0.01 0.00 0 0  
gcs partitioned table hash 13,114,780 0.00   0 0  
gcs remaster request queue 20 0.00   0 0  
gcs remastering latch 1,910,836 0.00 9.54 0 0  
gcs resource freelist 579,351 0.01 0.00 0 141,600 0.00
gcs resource hash 10,173,475 0.03 0.14 0 725 0.14
gcs resource scan list 1,451 0.00   0 0  
gcs shadows freelist 63,323 0.00   0 217,006 0.00
ges caches resource lists 1,703,803 0.05 0.01 0 270,454 0.12
ges deadlock list 134,670 0.00 0.00 0 44 0.00
ges domain table 16,310,057 0.00 0.00 0 0  
ges enqueue table freelist 16,642,598 0.07 0.00 0 0  
ges group table 24,200,227 0.03 0.00 0 0  
ges process hash list 62,225 0.00   0 0  
ges process parent latch 33,398,483 0.00   0 0  
ges process table freelist 10,042 0.01 0.00 0 0  
ges resource hash list 24,012,553 0.53 0.02 1 308,302 0.19
ges resource scan list 83,022 0.04 0.00 0 0  
ges resource table freelist 426,348 0.01 0.06 0 34 0.00
ges synchronous data 96 6.25 0.00 0 56,940 0.01
ges timeout list 50,948 0.01 0.00 0 47,080 0.00
global KZLD latch for mem in SGA 7,631 0.00   0 0  
global ctx hash table latch 480 0.00   0 0  
hash table column usage latch 1,248 0.48 0.00 0 15,731,788 0.00
hash table modification latch 137 0.00   0 2 0.00
internal temp table object number allocation latc 3 0.00   0 0  
job_queue_processes parameter latch 60 0.00   0 0  
kks stats 16,009 0.02 0.00 0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 152,844 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 536,557 0.11 0.01 0 0  
library cache 253,581,358 0.50 0.01 7 9,784 0.61
library cache load lock 6,761 0.83 0.07 0 8 0.00
library cache lock 59,279,116 0.11 0.01 0 0  
library cache lock allocation 1,966,572 0.01 0.02 0 0  
library cache pin 152,593,328 0.25 0.01 2 5 0.00
library cache pin allocation 1,010,781 0.01 0.02 0 0  
list of block allocation 414,299 0.01 0.04 0 0  
loader state object freelist 228,638 0.01 0.00 0 0  
longop free list parent 35 0.00   0 35 0.00
message pool operations parent latch 453,625 0.15 0.02 0 0  
messages 4,864,495 0.15 0.06