|
|
|
AWR Report
WORKLOAD REPOSITORY report for
| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|
| VIS | 187584551 | VIS | 1 | 10.2.0.3.0 | NO | hpdb1 |
| Snap Id | Snap Time | Sessions | Cursors/Session |
|---|
| Begin Snap: | 1 | 15-Feb-08 17:33:37 | 2621 | 201.7 |
| End Snap: | 2 | 15-Feb-08 18:33:43 | 2632 | 241.7 |
| Elapsed: | | 60.08 (mins) | | |
| DB Time: | | 385.09 (mins) | | |
Report Summary
Cache Sizes
| Begin | End | | |
|---|
| Buffer Cache: | 18,384M | 18,304M | Std Block Size: | 8K |
| Shared Pool Size: | 2,000M | 2,080M | Log Buffer: | 14,320K |
Load Profile
| Per Second | Per Transaction |
|---|
| Redo size: | 7,943,529.02 | 38,191.53 |
| Logical reads: | 465,426.27 | 2,237.71 |
| Block changes: | 48,587.92 | 233.60 |
| Physical reads: | 111.45 | 0.54 |
| Physical writes: | 771.38 | 3.71 |
| User calls: | 6,765.27 | 32.53 |
| Parses: | 1,476.18 | 7.10 |
| Hard parses: | 1.65 | 0.01 |
| Sorts: | 1,888.60 | 9.08 |
| Logons: | 1.65 | 0.01 |
| Executes: | 18,621.11 | 89.53 |
| Transactions: | 207.99 | |
| % Blocks changed per Read: | 10.44 | Recursive Call %: | 81.83 |
| Rollback per transaction %: | 16.63 | Rows per Sort: | 13.20 |
Instance Efficiency Percentages (Target 100%)
| Buffer Nowait %: | 99.95 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.98 | In-memory Sort %: | 100.00 |
| Library Hit %: | 99.77 | Soft Parse %: | 99.89 |
| Execute to Parse %: | 92.07 | Latch Hit %: | 98.45 |
| Parse CPU to Parse Elapsd %: | 82.49 | % Non-Parse CPU: | 98.06 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 80.55 | 85.90 |
| % SQL with executions>1: | 87.02 | 89.58 |
| % Memory for SQL w/exec>1: | 73.57 | 67.54 |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|
| CPU time | | 19,163 | | 82.9 | |
| db file sequential read | 225,225 | 1,905 | 8 | 8.2 | User I/O |
| log file sync | 271,997 | 405 | 1 | 1.8 | Commit |
| db file scattered read | 15,052 | 396 | 26 | 1.7 | User I/O |
| enq: RO - fast object reuse | 151 | 363 | 2,405 | 1.6 | Application |
Main Report
Back to Top
Wait Events Statistics
Back to Top
Time Model Statistics
- Total time in database user-calls (DB Time): 23105.2s
- 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 Name | Time (s) | % of DB Time |
|---|
| sql execute elapsed time | 20,529.51 | 88.85 |
| DB CPU | 19,162.81 | 82.94 |
| PL/SQL execution elapsed time | 4,186.32 | 18.12 |
| inbound PL/SQL rpc elapsed time | 3,560.49 | 15.41 |
| Java execution elapsed time | 579.79 | 2.51 |
| parse time elapsed | 503.83 | 2.18 |
| hard parse elapsed time | 228.04 | 0.99 |
| repeated bind elapsed time | 57.88 | 0.25 |
| sequence load elapsed time | 14.80 | 0.06 |
| connection management call elapsed time | 8.59 | 0.04 |
| PL/SQL compilation elapsed time | 8.23 | 0.04 |
| hard parse (sharing criteria) elapsed time | 3.61 | 0.02 |
| hard parse (bind mismatch) elapsed time | 0.93 | 0.00 |
| failed parse elapsed time | 0.91 | 0.00 |
| DB time | 23,105.24 | |
| background elapsed time | 1,179.35 | |
| background cpu time | 413.31 | |
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 Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| User I/O | 286,114 | 0.02 | 2,602 | 9 | 0.38 |
| Application | 39,996 | 0.42 | 559 | 14 | 0.05 |
| Commit | 271,997 | 0.00 | 405 | 1 | 0.36 |
| Network | 28,134,141 | 0.00 | 351 | 0 | 37.52 |
| Concurrency | 2,360,002 | 0.22 | 328 | 0 | 3.15 |
| System I/O | 602,985 | 0.00 | 284 | 0 | 0.80 |
| Other | 119,062 | 38.26 | 85 | 1 | 0.16 |
| Configuration | 8,069 | 0.40 | 15 | 2 | 0.01 |
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)
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| db file sequential read | 225,225 | 0.00 | 1,905 | 8 | 0.30 |
| log file sync | 271,997 | 0.00 | 405 | 1 | 0.36 |
| db file scattered read | 15,052 | 0.00 | 396 | 26 | 0.02 |
| enq: RO - fast object reuse | 151 | 78.81 | 363 | 2405 | 0.00 |
| SQL*Net more data from client | 1,291,919 | 0.00 | 294 | 0 | 1.72 |
| log file parallel write | 571,839 | 0.00 | 278 | 0 | 0.76 |
| read by other session | 42,265 | 0.00 | 168 | 4 | 0.06 |
| buffer busy waits | 777,495 | 0.01 | 160 | 0 | 1.04 |
| local write wait | 1,399 | 4.50 | 133 | 95 | 0.00 |
| enq: UL - contention | 2,346 | 1.45 | 119 | 51 | 0.00 |
| enq: TX - row lock contention | 330 | 4.24 | 62 | 189 | 0.00 |
| cursor: pin S wait on X | 5,577 | 92.43 | 56 | 10 | 0.01 |
| rdbms ipc reply | 25 | 88.00 | 45 | 1798 | 0.00 |
| latch: cache buffers chains | 1,520,002 | 0.00 | 41 | 0 | 2.03 |
| enq: TX - index contention | 28,005 | 0.00 | 34 | 1 | 0.04 |
| SQL*Net message to client | 25,548,492 | 0.00 | 32 | 0 | 34.07 |
| library cache load lock | 773 | 0.00 | 27 | 35 | 0.00 |
| SQL*Net more data to client | 1,293,730 | 0.00 | 25 | 0 | 1.73 |
| PX Deq Credit: send blkd | 21,129 | 0.00 | 21 | 1 | 0.03 |
| enq: HW - contention | 3,238 | 0.00 | 10 | 3 | 0.00 |
| enq: TM - contention | 7 | 28.57 | 7 | 1071 | 0.00 |
| SQL*Net break/reset to client | 37,162 | 0.00 | 7 | 0 | 0.05 |
| control file parallel write | 1,829 | 0.00 | 6 | 3 | 0.00 |
| kksfbc child completion | 139 | 83.45 | 6 | 42 | 0.00 |
| write complete waits | 37 | 86.49 | 3 | 89 | 0.00 |
| os thread startup | 78 | 0.00 | 3 | 37 | 0.00 |
| wait list latch free | 237 | 0.00 | 3 | 11 | 0.00 |
| latch: library cache | 5,625 | 0.00 | 2 | 0 | 0.01 |
| row cache lock | 1,075 | 0.00 | 2 | 2 | 0.00 |
| latch: In memory undo latch | 17,199 | 0.00 | 2 | 0 | 0.02 |
| PX Deq: Signal ACK | 210 | 30.48 | 1 | 7 | 0.00 |
| latch: undo global data | 7,303 | 0.00 | 1 | 0 | 0.01 |
| enq: TX - contention | 2,717 | 0.00 | 1 | 0 | 0.00 |
| latch free | 2,537 | 0.00 | 1 | 0 | 0.00 |
| enq: DV - contention | 183 | 0.00 | 1 | 5 | 0.00 |
| LGWR wait for redo copy | 23,022 | 0.00 | 1 | 0 | 0.03 |
| enq: SQ - contention | 4,222 | 0.00 | 1 | 0 | 0.01 |
| latch: library cache pin | 1,659 | 0.00 | 1 | 0 | 0.00 |
| latch: session allocation | 1,314 | 0.00 | 1 | 0 | 0.00 |
| latch: object queue header operation | 7,237 | 0.00 | 1 | 0 | 0.01 |
| PX qref latch | 983 | 95.93 | 1 | 1 | 0.00 |
| buffer deadlock | 45,106 | 98.43 | 1 | 0 | 0.06 |
| latch: redo allocation | 2,057 | 0.00 | 1 | 0 | 0.00 |
| log file switch completion | 40 | 0.00 | 0 | 11 | 0.00 |
| enq: TX - allocate ITL entry | 132 | 0.00 | 0 | 2 | 0.00 |
| enq: FB - contention | 920 | 0.00 | 0 | 0 | 0.00 |
| control file sequential read | 29,305 | 0.00 | 0 | 0 | 0.04 |
| SGA: allocation forcing component growth | 21 | 66.67 | 0 | 10 | 0.00 |
| latch: row cache objects | 508 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffers lru chain | 427 | 0.00 | 0 | 0 | 0.00 |
| latch: messages | 55 | 0.00 | 0 | 3 | 0.00 |
| latch: redo writing | 400 | 0.00 | 0 | 0 | 0.00 |
| library cache pin | 1,159 | 0.00 | 0 | 0 | 0.00 |
| latch: shared pool | 274 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffer handles | 214 | 0.00 | 0 | 0 | 0.00 |
| latch: object queue header heap | 166 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache lock | 100 | 0.00 | 0 | 1 | 0.00 |
| cursor: pin S | 2,920 | 0.00 | 0 | 0 | 0.00 |
| library cache lock | 2 | 0.00 | 0 | 17 | 0.00 |
| cursor: mutex S | 201 | 0.00 | 0 | 0 | 0.00 |
| reliable message | 35 | 0.00 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 28 | 0.00 | 0 | 0 | 0.00 |
| enq: CU - contention | 2 | 0.00 | 0 | 1 | 0.00 |
| enq: PS - contention | 48 | 0.00 | 0 | 0 | 0.00 |
| direct path read | 1,464 | 0.00 | 0 | 0 | 0.00 |
| latch: parallel query alloc buffer | 6 | 0.00 | 0 | 0 | 0.00 |
| cursor: mutex X | 270 | 0.00 | 0 | 0 | 0.00 |
| log file single write | 6 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 665 | 0.00 | 0 | 0 | 0.00 |
| kkdlgon | 3 | 0.00 | 0 | 0 | 0.00 |
| log file sequential read | 6 | 0.00 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 18 | 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 | 25,548,488 | 0.00 | 5,052,173 | 198 | 34.07 |
| pipe get | 16,884 | 28.71 | 21,092 | 1249 | 0.02 |
| Streams AQ: waiting for messages in the queue | 2,390 | 100.00 | 11,664 | 4880 | 0.00 |
| PX Idle Wait | 3,279 | 76.61 | 5,167 | 1576 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 1,772 | 37.58 | 3,507 | 1979 | 0.00 |
| Streams AQ: qmn slave idle wait | 128 | 0.00 | 3,500 | 27346 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 256 | 50.00 | 3,500 | 13673 | 0.00 |
| PL/SQL lock timer | 247 | 99.19 | 2,721 | 11018 | 0.00 |
| jobq slave wait | 616 | 99.51 | 1,803 | 2927 | 0.00 |
| PX Deq: Execution Msg | 11,908 | 0.00 | 56 | 5 | 0.02 |
| PX Deq: Execute Reply | 4,587 | 0.00 | 2 | 1 | 0.01 |
| PX Deq Credit: need buffer | 3,589 | 0.00 | 2 | 1 | 0.00 |
| PX Deq: Msg Fragment | 9,333 | 0.00 | 2 | 0 | 0.01 |
| PX Deq: Table Q Normal | 8,065 | 0.00 | 1 | 0 | 0.01 |
| PX Deq: Parse Reply | 340 | 0.00 | 0 | 1 | 0.00 |
| PX Deq: Join ACK | 240 | 0.00 | 0 | 0 | 0.00 |
| class slave wait | 1 | 0.00 | 0 | 1 | 0.00 |
Back to Wait Events Statistics
Back to Top
Background Wait Events
- ordered by wait time desc, waits desc (idle events last)
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| log file parallel write | 571,838 | 0.00 | 278 | 0 | 0.76 |
| control file parallel write | 1,829 | 0.00 | 6 | 3 | 0.00 |
| db file sequential read | 1,041 | 0.00 | 2 | 2 | 0.00 |
| os thread startup | 62 | 0.00 | 2 | 37 | 0.00 |
| events in waitclass Other | 27,763 | 0.00 | 2 | 0 | 0.04 |
| db file scattered read | 68 | 0.00 | 0 | 3 | 0.00 |
| latch: redo writing | 400 | 0.00 | 0 | 0 | 0.00 |
| control file sequential read | 968 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 34 | 0.00 | 0 | 0 | 0.00 |
| direct path read | 1,464 | 0.00 | 0 | 0 | 0.00 |
| buffer busy waits | 12 | 0.00 | 0 | 0 | 0.00 |
| log file single write | 6 | 0.00 | 0 | 0 | 0.00 |
| log file sequential read | 6 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 555 | 0.00 | 0 | 0 | 0.00 |
| log file sync | 1 | 0.00 | 0 | 1 | 0.00 |
| latch: shared pool | 2 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache | 1 | 0.00 | 0 | 0 | 0.00 |
| latch: In memory undo latch | 1 | 0.00 | 0 | 0 | 0.00 |
| rdbms ipc message | 917,595 | 1.12 | 29,885 | 33 | 1.22 |
| pmon timer | 1,251 | 97.28 | 3,512 | 2807 | 0.00 |
| smon timer | 72,971 | 0.00 | 3,509 | 48 | 0.10 |
| Streams AQ: waiting for time management or cleanup tasks | 1,772 | 37.58 | 3,507 | 1979 | 0.00 |
| Streams AQ: qmn slave idle wait | 128 | 0.00 | 3,500 | 27346 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 256 | 50.00 | 3,500 | 13673 | 0.00 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
| Statistic | Total |
|---|
| BUSY_TIME | 2,095,131 |
| IDLE_TIME | 3,664,295 |
| IOWAIT_TIME | 146,130 |
| NICE_TIME | 19,424 |
| SYS_TIME | 123,525 |
| USER_TIME | 1,889,740 |
| LOAD | 4 |
| RSRC_MGR_CPU_WAIT_TIME | 0 |
| PHYSICAL_MEMORY_BYTES | 27,792 |
| NUM_CPUS | 16 |
| NUM_CPU_SOCKETS | 4 |
Back to Wait Events Statistics
Back to Top
Service Statistics
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
|---|
| SYS$USERS | 23,101.10 | 19,159.20 | 398,669 | 1,675,585,569 |
| SYS$BACKGROUND | 0.00 | 0.00 | 3,034 | 2,165,127 |
| VIS | 0.00 | 0.00 | 0 | 0 |
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 Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
|---|
| SYS$USERS |
282982 | 259898 | 2359859 | 32541 | 0 | 0 | 28120093 | 35087 |
| SYS$BACKGROUND |
3130 | 254 | 112 | 231 | 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 Id | SQL Module | SQL Text |
|---|
| 1,785 | 1,783 | 10 | 178.46 | 7.72 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 826 | 826 | 299 | 2.76 | 3.58 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 645 | 610 | 16 | 40.29 | 2.79 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 462 | 458 | 53,349 | 0.01 | 2.00 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 446 | 147 | 9,999 | 0.04 | 1.93 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 418 | 417 | 53,334 | 0.01 | 1.81 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 411 | 4 | 56 | 7.34 | 1.78 | 9k7t8q4kfcb7y |
SQL*Plus
|
begin GL.apps_ddl.apps_ddl(:dd... |
| 406 | 2 | 8 | 50.81 | 1.76 | 0smgkw5kuqj00 |
GLLEZL
|
begin ad_ddl.do_ddl(:schema, ... |
| 393 | 392 | 53,338 | 0.01 | 1.70 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 389 | 75 | 1,120 | 0.35 | 1.68 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 332 | 11 | 1,120 | 0.30 | 1.44 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 328 | 306 | 5,000 | 0.07 | 1.42 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 314 | 296 | 52,308 | 0.01 | 1.36 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 313 | 265 | 94,752 | 0.00 | 1.35 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 297 | 297 | 8 | 37.09 | 1.28 | 1nj7kuvxgpwah |
RAXTRX
|
begin ARP_TAX . SET_DEFAULT_TA... |
| 270 | 269 | 44,196 | 0.01 | 1.17 | auzgm2ap4faw2 |
JDBC Thin Client
|
(SELECT SUB.GUID SUB_GUID, DE... |
| 263 | 262 | 172,413 | 0.00 | 1.14 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 245 | 239 | 161,219 | 0.00 | 1.06 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 240 | 181 | 124,481 | 0.00 | 1.04 | 25wzrzwd46a44 |
asn.dashboard.server.DashboardAM
|
SELECT 1 FROM DUAL WHERE EXIST... |
| 233 | 102 | 10,086 | 0.02 | 1.01 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
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 Id | SQL Module | SQL Text |
|---|
| 1,783 | 1,785 | 10 | 178.27 | 7.72 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 826 | 826 | 299 | 2.76 | 3.58 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 610 | 645 | 16 | 38.10 | 2.79 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 458 | 462 | 53,349 | 0.01 | 2.00 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 417 | 418 | 53,334 | 0.01 | 1.81 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 392 | 393 | 53,338 | 0.01 | 1.70 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 306 | 328 | 5,000 | 0.06 | 1.42 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 297 | 297 | 8 | 37.08 | 1.28 | 1nj7kuvxgpwah |
RAXTRX
|
begin ARP_TAX . SET_DEFAULT_TA... |
| 296 | 314 | 52,308 | 0.01 | 1.36 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 269 | 270 | 44,196 | 0.01 | 1.17 | auzgm2ap4faw2 |
JDBC Thin Client
|
(SELECT SUB.GUID SUB_GUID, DE... |
| 265 | 313 | 94,752 | 0.00 | 1.35 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 262 | 263 | 172,413 | 0.00 | 1.14 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 239 | 245 | 161,219 | 0.00 | 1.06 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 181 | 240 | 124,481 | 0.00 | 1.04 | 25wzrzwd46a44 |
asn.dashboard.server.DashboardAM
|
SELECT 1 FROM DUAL WHERE EXIST... |
| 147 | 446 | 9,999 | 0.01 | 1.93 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 102 | 233 | 10,086 | 0.01 | 1.01 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 75 | 389 | 1,120 | 0.07 | 1.68 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 11 | 332 | 1,120 | 0.01 | 1.44 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 4 | 411 | 56 | 0.06 | 1.78 | 9k7t8q4kfcb7y |
SQL*Plus
|
begin GL.apps_ddl.apps_ddl(:dd... |
| 2 | 406 | 8 | 0.23 | 1.76 | 0smgkw5kuqj00 |
GLLEZL
|
begin ad_ddl.do_ddl(:schema, ... |
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,677,900,325
- Captured SQL account for 23.2% of Total
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 150,878,984 | 10 | 15,087,898.40 | 8.99 | 1782.70 | 1784.65 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 107,328,966 | 44,196 | 2,428.48 | 6.40 | 268.67 | 269.70 | auzgm2ap4faw2 |
JDBC Thin Client
|
(SELECT SUB.GUID SUB_GUID, DE... |
| 99,157,718 | 16 | 6,197,357.38 | 5.91 | 609.67 | 644.68 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 73,651,467 | 8 | 9,206,433.38 | 4.39 | 296.62 | 296.73 | 1nj7kuvxgpwah |
RAXTRX
|
begin ARP_TAX . SET_DEFAULT_TA... |
| 50,075,499 | 153,363 | 326.52 | 2.98 | 188.44 | 189.09 | 5kqw5535fjvw6 |
ARXTWMAI
|
SELECT NVL(RCTT.ATTRIBUTE10, ... |
| 45,664,423 | 53,349 | 855.96 | 2.72 | 458.17 | 461.80 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 40,740,264 | 299 | 136,255.06 | 2.43 | 826.19 | 826.23 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 39,303,830 | 11 | 3,573,075.45 | 2.34 | 187.35 | 188.36 | 1du9v021t8m46 |
ARGLTP
|
insert into gl_interface(creat... |
| 36,485,627 | 5,000 | 7,297.13 | 2.17 | 306.07 | 328.39 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 35,651,731 | 94,752 | 376.26 | 2.12 | 264.89 | 312.57 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 34,608,551 | 124,481 | 278.02 | 2.06 | 181.43 | 240.40 | 25wzrzwd46a44 |
asn.dashboard.server.DashboardAM
|
SELECT 1 FROM DUAL WHERE EXIST... |
| 32,279,300 | 53,338 | 605.18 | 1.92 | 392.29 | 393.46 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 31,330,523 | 161,219 | 194.34 | 1.87 | 238.65 | 244.60 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 31,321,042 | 161,208 | 194.29 | 1.87 | 224.11 | 230.04 | gf1u933c95jb5 |
INVTTMTX
|
DECLARE
l_ret_stat varchar2... |
| 26,396,650 | 9,999 | 2,639.93 | 1.57 | 147.39 | 445.56 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 25,237,182 | 11 | 2,294,289.27 | 1.50 | 125.88 | 125.96 | bp8crdjba8zgt |
ARGLTP
|
update ra_cust_trx_line_gl_dis... |
| 23,549,746 | 1,234,017 | 19.08 | 1.40 | 126.32 | 126.82 | 66tmsr3446uqn |
ap.oie.server.WebExpensesAM
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 23,140,818 | 53,334 | 433.88 | 1.38 | 416.69 | 417.79 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 20,363,655 | 3,368 | 6,046.22 | 1.21 | 121.59 | 168.68 | 8jb36w62w5hqf |
ibuSRDetailsActions.jsp
|
BEGIN IBU_REQ_PKG.UpdateServic... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 401,782
- Captured SQL account for 32.8% of Total
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 45,240 | 9,999 | 4.52 | 11.26 | 147.39 | 445.56 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 40,661 | 1,120 | 36.30 | 10.12 | 10.53 | 331.92 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 29,930 | 1,120 | 26.72 | 7.45 | 74.51 | 388.97 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 16,224 | 10,086 | 1.61 | 4.04 | 102.48 | 232.93 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 10,288 | 124,481 | 0.08 | 2.56 | 181.43 | 240.40 | 25wzrzwd46a44 |
asn.dashboard.server.DashboardAM
|
SELECT 1 FROM DUAL WHERE EXIST... |
| 8,127 | 3,368 | 2.41 | 2.02 | 121.59 | 168.68 | 8jb36w62w5hqf |
ibuSRDetailsActions.jsp
|
BEGIN IBU_REQ_PKG.UpdateServic... |
| 8,089 | 94,752 | 0.09 | 2.01 | 264.89 | 312.57 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 4,600 | 10,000 | 0.46 | 1.14 | 183.18 | 214.85 | csvvv0fmhr1yc |
PYUSLV
|
BEGIN
FFP1893_01010001.FORMULA... |
| 4,510 | 10,000 | 0.45 | 1.12 | 152.28 | 180.31 | 63t8zpm02skgh |
PYUSLV
|
SELECT DECODE(COUNT(PRR.RUN_RE... |
| 670 | 9,942 | 0.07 | 0.17 | 131.89 | 141.22 | 4ds53shhfcynn |
PYUSLV
|
declare
begin
hr_pre_pay.... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 67,130,659
- Captured SQL account for 8.7% of Total
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 1,234,017 | 639,979 | 0.52 | 0.00 | 0.00 | 66tmsr3446uqn |
ap.oie.server.WebExpensesAM
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 708,213 | 708,147 | 1.00 | 0.00 | 0.00 | cd9mbmqyf4qhp |
ap.oie.server.WebExpensesAM
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 282,568 | 282,562 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 194,356 | 155,670 | 0.80 | 0.00 | 0.00 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 172,413 | 172,406 | 1.00 | 0.00 | 0.00 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 161,220 | 161,206 | 1.00 | 0.00 | 0.00 | 6gnth2mfbs2nq |
INVTTMTX
|
declare
v_ret number := 0... |
| 161,219 | 161,205 | 1.00 | 0.00 | 0.00 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 161,208 | 161,206 | 1.00 | 0.00 | 0.00 | gf1u933c95jb5 |
INVTTMTX
|
DECLARE
l_ret_stat varchar2... |
| 153,363 | 153,356 | 1.00 | 0.00 | 0.00 | 5kqw5535fjvw6 |
ARXTWMAI
|
SELECT NVL(RCTT.ATTRIBUTE10, ... |
| 138,366 | 2,352,126 | 17.00 | 0.00 | 0.00 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 5,321,765
- Captured SQL account for 47.9% of Total
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 282,566 | 282,568 | 5.31 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 194,355 | 194,356 | 3.65 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 172,415 | 172,413 | 3.24 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 161,010 | 161,220 | 3.03 | 6gnth2mfbs2nq |
INVTTMTX
|
declare
v_ret number := 0... |
| 138,365 | 138,366 | 2.60 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
| 111,595 | 111,764 | 2.10 | fb13x9qx0ftks |
OEXOETEL
|
begin OE_STANDARD_WF.OEOL_SELE... |
| 107,802 | 107,867 | 2.03 | 1c0b7sas42w2z |
INVTTMTX
|
SELECT NVL(ITEM_COST, 0), ... |
| 94,750 | 94,752 | 1.78 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 79,231 | 79,279 | 1.49 | 76sw2a4vnc89j |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.S... |
| 76,464 | 76,471 | 1.44 | 608c0n36kaw62 |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.C... |
| 76,453 | 79,275 | 1.44 | dcvv68fju01g4 |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.E... |
| 76,452 | 76,461 | 1.44 | bf7uwg5pa3pj6 |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.V... |
| 69,997 | 69,993 | 1.32 | 97mt0g20bcfc3 |
PYUSLV
|
begin
... |
| 59,103 | 59,199 | 1.11 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 56,208 | 56,209 | 1.06 | 162ttnv4ubqun |
OEXOETEL
|
begin OE_DS_PVT.Check_PO_Appr... |
| 54,176 | 54,196 | 1.02 | gdnwgx9fcxggr |
OEXOETEL
|
begin OE_SHIPPING_WF.START_SHI... |
| 54,174 | 54,195 | 1.02 | 7mrs575bj7a41 |
OEXOETEL
|
begin OE_OEOL_SCH.BRANCH_ON_SO... |
| 54,163 | 54,209 | 1.02 | fvcbstf9s6a5r |
OEXOETEL
|
begin WF_STANDARD.WAITFORFLOW ... |
| 54,160 | 54,190 | 1.02 | bfbyqwbr4vwms |
OEXOETEL
|
begin OE_OEOL_SCH.SCHEDULE_LIN... |
| 53,395 | 53,395 | 1.00 | fr38pcatsbj6x |
INCTCW
|
SELECT
reservation_... |
| 53,323 | 53,338 | 1.00 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 53,322 | 53,355 | 1.00 | cw171rvngr1w9 |
WSHINTERFACE
|
begin OE_FLEX_COGS_PUB.GET_COS... |
| 53,319 | 53,359 | 1.00 | d0a8mm8y38yaw |
WSHFRREL
|
SELECT base.revision
... |
| 53,290 | 53,334 | 1.00 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 53,243 | 53,334 | 1.00 | gnng1rmpjxzsx |
WSHINTERFACE
|
begin OE_CLOSE_WF.CLOSE_LINE (... |
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 Id | SQL Module | SQL Text |
|---|
| 10,103,127 | 7 | 0.46 | 5d5cajabcjp4v |
RAXMTR
|
select /*+ parallel(t, 16) par... |
Back to SQL Statistics
Back to Top
|
SQL ordered by Version Count
No data exists for this section of the report.
Back to SQL Statistics
Back to Top
Complete List of SQL Text
| SQL Id | SQL Text |
|---|
| 0smgkw5kuqj00 | begin ad_ddl.do_ddl(:schema, :tappl, ad_ddl.truncate_table , :stmnt, :obj); end; |
| 0z318y6g3uagc | declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ; |
| 162ttnv4ubqun | begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end; |
| 1c0b7sas42w2z | SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3 |
| 1du9v021t8m46 |
insert into gl_interface(created_by, date_created, status, actual_flag, group_id, set_of_books_id, user_je_source_name, user_je_category_name, accounting_date, subledger_doc_sequence_id, subledger_doc_sequence_value, ussgl_transaction_code, currency_code, code_combination_id, entered_dr, entered_cr, accounted_dr, accounted_cr, reference1, reference10, reference21, reference22, reference23, reference24, reference25, reference26, reference27, reference28, reference29, reference30, request_id)select /*+ ORDERED USE_NL (l ctlgd ct ctt cust) INDEX (ctlgd, RA_CUST_TRX_LINE_GL_DIST_N5) +*/ :b0 created_by , trunc(sysdate ) date_created , :b1 status , :b2 actual_flag , :b3 group_id , :b4 sob_id , :b5 source_name , decode(ctt.type, 'CM', :b6, 'DM', :b7, 'CB', :b8, :b9) category , ctlgd.gl_date gl_date , ct.doc_sequence_id doc_seqid , ct.doc_sequence_value doc_num , ctlgd.ussgl_transaction_code ussgl , ct.invoice_currency_code currency , ctlgd.code_combination_id ccid , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null )) entered_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), decode(sign(nvl(ctlgd.amount
, 0)), (-1), null , nvl(ctlgd.amount, 0))) entered_cr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null )) acctd_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0))) acctd_cr , (:b10||to_char(:b3)) ref1 , decode(:b12, 'Y', null , ((((((l.meaning||' ')||:b13)||decode(ctt.type, 'CB', :b14, 'CM', :b15, 'DEP', :b16, 'DM', :b17, 'GUAR', :b18, 'INV', :b19, null ))||' ')||ct.trx_number)||:b20)) ref10 , to_char(:b3) ref21 , to_char(ct.customer_trx_id) ref22 , to_char(ctlgd.cust_trx_line_gl_dist_id) ref23 , ct.trx_number ref24 , cust.account_number ref25 , 'CUSTOMER' ref26 , to_char(ct.bill_to_customer_id) ref27 , decode(ctt.type, 'CM', 'CM', 'DM', 'DM', 'CB', 'CB', 'INV') ref28 , (decode(ctt.type, 'CM', 'CM_', 'DM', 'DM_', 'CB', 'CB_', 'INV_')||ctlgd.account_class) ref29 , 'RA_CUST_TRX_LINE_GL_DIST' ref30 , :b22 from ra_cust_trx_line_gl_dist ctlgd , ra_cust_trx_line_gl_dist rec , ar_lookups l , ra_customer_trx ct , ra_cust_trx_types ctt , hz_cust_accounts cust where ((((((((((((((((ctlgd.cust_trx_line_gl_dist_id+0)<:
b23 and ctlgd.gl_date between to_date((:b24||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b25||' 23:59:59'), 'DD-MON-RR HH24:MI:SS')) and ctlgd.posting_control_id=(-3)) and ctlgd.set_of_books_id=:b4) and ctlgd.account_set_flag='N') and ctlgd.customer_trx_id=ct.customer_trx_id) and l.lookup_type='AUTOGL_TYPE') and l.lookup_code=nvl(ctlgd.account_class, 'REV')) and ct.complete_flag='Y') and ct.bill_to_customer_id=cust.cust_account_id) and ct.cust_trx_type_id=ctt.cust_trx_type_id) and ctlgd.customer_trx_id=rec.customer_trx_id) and rec.account_class='REC') and rec.latest_rec_flag='Y') and rec.account_set_flag='N') and 'NOT_MFAR_TYPE'=AR_MFAR_PKG.ar_mfar_trx_post(ctlgd.customer_trx_id, :b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b12, :b13, :b20, :b14, :b15, :b17, :b16, :b18, :b19, :b24, :b25, :b23)) |
| 1nj7kuvxgpwah | begin ARP_TAX . SET_DEFAULT_TAX_CODE ( :setSql , :updSql ) ; END ; |
| 1q78dwnrrkf6c | BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END; |
| 25wzrzwd46a44 | SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 1 FROM FND_GRANTS G, WF_USER_ROLES R WHERE G.GRANTEE_KEY = R.ROLE_NAME AND R.USER_NAME IN (SELECT INCRNS.NAME FROM WF_LOCAL_ROLES SRC , WF_LOCAL_ROLES INCRNS WHERE SRC.NAME = :B4 AND SRC.PARENT_ORIG_SYSTEM = INCRNS.PARENT_ORIG_SYSTEM AND SRC.PARENT_ORIG_SYSTEM_ID = INCRNS.PARENT_ORIG_SYSTEM_ID) AND G.OBJECT_ID = :B3 AND ((:B2 = -1) OR (G.MENU_ID IN (SELECT CMF.MENU_ID FROM FND_COMPILED_MENU_FUNCTIONS CMF WHERE CMF.FUNCTION_ID = :B2 ))) AND ( G.CTX_SECGRP_ID = -1 OR G.CTX_SECGRP_ID = SYS_CONTEXT('FND', 'SECURITY_GROUP_ID')) AND ( G.CTX_RESP_ID = -1 OR G.CTX_RESP_ID = SYS_CONTEXT('FND', 'RESP_ID')) AND ( G.CTX_RESP_APPL_ID = -1 OR G.CTX_RESP_APPL_ID = SYS_CONTEXT('FND', 'RESP_APPL_ID')) AND ( G.CTX_ORG_ID = -1 OR G.CTX_ORG_ID = SYS_CONTEXT('FND', 'ORG_ID')) AND G.START_DATE <= SYSDATE AND ( G.END_DATE IS NULL OR G.END_DATE >= SYSDATE ) AND G.INSTANCE_TYPE = :B1 ) |
| 2fjd6cndjby9p |
INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID ) SELECT /*+ ORDERED */ ASS.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_ID, DIST.CODE_COMBINATION_ID, :B12 , ASS.ACCOUNT_CLASS, 'N', ROUND( (DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1 ), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1 ) ), ASS.AMOUNT ), FC.PRECISION), ROUND( ((DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1) ), ASS.AMOUNT) ) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT) / DECODE(LINES.EXTENDED_AMOUNT, 0, 1, LINES.EXTENDED_AMOUNT)) * DECODE(ASS.AMOUNT, 0, 0, 100), 4), DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), DECODE(:B10 , NULL, ROUND( NVL(HEADER.EXCHANGE_
RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ), :B11 ), ROUND( ( NVL(HEADER.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ( (DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) ) / :B10 ) * :B10 ), DECODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_DATE(ASS.GL_DATE) ), DECODE(DIST.CUSTOMER_TRX_ID, HEADER.CUSTOMER_TRX_ID, DIST.CUST_TRX_LINE_SALESREP_ID, CMSREP.CUST_TRX_LINE_SALESREP_ID), :B9 , :B8 , :B7 , SYSDATE, SYSDATE, :B6 , SYSDATE, :B6 , -3, ASS.GL_DATE, RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES FC, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE, RA_CUST_TRX_LINE_GL_DIST REC, RA_CUST_TRX_LINE_GL_DIST DIST, RA_CUST_TRX_LINE_SALESREPS CMSREP, AR_REVENUE_ASSIGNMENTS ASS WHERE HEADER.CUSTOMER_TRX_ID = :B1 AND HEADER.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = HEADER.INVOICE_CURRENCY_CODE AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINES.AUTORULE_COMPLETE_FLAG||'' = 'N' AND ASS.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND ASS.PERIOD_SET_NAME = :B5 AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID AND DECODE(HEADER.INVOICING_RULE_ID, -3, :B3 , DECODE(NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), 'Y',
:B2 , DECODE(:B4 , 'N', :B3 , DECODE(HEADER.PREVIOUS_CUSTOMER_TRX_ID, NULL, AR_REVENUE_MANAGEMENT_PVT.LINE_COLLECTIBILITY(:B1 , LINES.CUSTOMER_TRX_LINE_ID), AR_REVENUE_MANAGEMENT_PVT.CASH_BASED(HEADER.PREVIOUS_CUSTOMER_TRX_ID))))) <> :B2 AND REC.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND DIST.CUSTOMER_TRX_LINE_ID = (SELECT DECODE(COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_LINE_ID), LINES.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' AND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND DIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND DIST.ACCOUNT_SET_FLAG = 'Y' AND DIST.CUST_TRX_LINE_SALESREP_ID = CMSREP.PREV_CUST_TRX_LINE_SALESREP_ID (+) AND :B1 = CMSREP.CUSTOMER_TRX_ID (+) AND NOT EXISTS ( SELECT 'distribution exists' FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST WHERE SUBDIST.CUSTOMER_TRX_LINE_ID = ASS.CUSTOMER_TRX_LINE_ID AND SUBDIST.CUSTOMER_TRX_ID + 0 = LINES.CUSTOMER_TRX_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND SUBDIST.ORIGINAL_GL_DATE = ASS.GL_DATE ) |
| 3b3psftuyks81 | BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END; |
| 3dssuqfjsynrk |
SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_
id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) ) |
| 4ds53shhfcynn | declare
begin
hr_pre_pay.do_prepayment(:p1, :p2, :p3, :p4, :5, :p6:p6ind, :p7);
end;
|
| 4yak7x2zqz0dh | BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END; |
| 5d5cajabcjp4v |
select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("HEADER_GDF_ATTRIBUTE8"), count(distinct "HEADER_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE9"), count(distinct "HEADER_GDF_ATTRIBUTE9"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE10"), count(distinct "HEADER_GDF_ATTRIBUTE10"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE11"), count(distinct "HEADER_GDF_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE12"), count(distinct "HEADER_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb
("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE13"), count(distinct "HEADER_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE14"), count(distinct "HEADER_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE15"), count(distinct "HEADER_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_GDF_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_ATTRI
BUTE18"), 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_G
DF_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)), 1
6, 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(disti
nct "LINE_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE4"), count(distinct "LINE_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE5"), count(distinct "LINE_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE6"), count(distinct "LINE_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE7"), count(distinct "LINE_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE8"), count(distinct "LINE_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), subst
rb(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_ATTRIB
UTE14"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE15"), count(distinct "LINE_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE16"), count(distinct "LINE_GDF_ATTRIBUTE16"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE16")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE17"), count(distinct "LINE_GDF_ATTRIBUTE17"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE18"), count(distinct "LINE_GDF_ATTRIBUTE18"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE19"), count(distinct "LINE_GDF_ATTRIBUTE19"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE19")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120
), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE20"), count(distinct "LINE_GDF_ATTRIBUTE20"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), count("RESET_TRX_DATE_FLAG"), count(distinct "RESET_TRX_DATE_FLAG"), sum(sys_op_opnsize("RESET_TRX_DATE_FLAG")), substrb(dump(min("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), count("PAYMENT_SERVER_ORDER_NUM"), count(distinct "PAYMENT_SERVER_ORDER_NUM"), sum(sys_op_opnsize("PAYMENT_SERVER_ORDER_NUM")), substrb(dump(min(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), count("APPROVAL_CODE"), count(distinct "APPROVAL_CODE"), sum(sys_op_opnsize("APPROVAL_CODE")), substrb(dump(min(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), count("ADDRESS_VERIFICATION_CODE"), count(distinct "ADDRESS_VERIFICATION_CODE"), sum(sys_op_opnsize("ADDRESS_VERIFICATION_CODE")), substrb(dump(min(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120), count("WAREHOUSE_ID"), count(distinct "WAREHOUSE_ID"), sum(sys_op_opnsize("
WAREHOUSE_ID")), substrb(dump(min("WAREHOUSE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("WAREHOUSE_ID"), 16, 0, 32), 1, 120), count("TRANSLATED_DESCRIPTION"), count(distinct "TRANSLATED_DESCRIPTION"), sum(sys_op_opnsize("TRANSLATED_DESCRIPTION")), substrb(dump(min(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count("CONS_BILLING_NUMBER"), count(distinct "CONS_BILLING_NUMBER"), sum(sys_op_opnsize("CONS_BILLING_NUMBER")), substrb(dump(min("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), count("PROMISED_COMMITMENT_AMOUNT"), count(distinct "PROMISED_COMMITMENT_AMOUNT"), sum(sys_op_opnsize("PROMISED_COMMITMENT_AMOUNT")), substrb(dump(min("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), count("PAYMENT_SET_ID"), count(distinct "PAYMENT_SET_ID"), sum(sys_op_opnsize("PAYMENT_SET_ID")), substrb(dump(min("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), count("ORIGINAL_GL_DATE"), count(distinct "ORIGINAL_GL_DATE"), substrb(dump(min("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), count("CONTRACT_LINE_ID"), count(distinct "CONTRACT_LINE_ID"), sum(sys_op_opnsize("CONTRACT_LINE_ID")), substrb(dump(min("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRA
CT_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("TERRITORY_SEGMENT11"), count(distinct "TERRITORY_SEGMENT11"), sum(sys_op_opnsize("TERRITORY_SEGMENT11")), substrb(dump(min("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT12"), count(distinct "TERRITORY_SEGMENT12"), sum(sys_op_opnsize("TERRITORY_SEGMENT12")), substrb(dump(min("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT13"), count(distinct "TERRITORY_SEGMENT13"), sum(sys_op_opnsize("TERRITORY_SEGMENT13")), substrb(dump(min("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT14"), count(distinct "TERRITORY_SEGMENT14"), sum(sys_op_opnsize("TERRITORY_SEGMENT14")), substrb(dump(min("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT15"), count(distinct "TERRITORY_SEGMENT15"), sum(sys_op_opnsize("TERRITORY_SEGMENT15")), substrb(dump(min("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT16"), count(distinct "
TERRITORY_SEGMENT16"), sum(sys_op_opnsize("TERRITORY_SEGMENT16")), substrb(dump(min("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), count("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, 3
2)), 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("HEADER_ATTRIBUTE_CATEGORY"), count(distinct "HEADER_ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("HEADER_ATTRIBUTE_CATEGORY")), substrb(dump(min("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE1"), count(distinct "HEADER_ATTRIBUTE1"), sum(sys_op_opnsize("HEADER_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE2"), count(distinct "HEADER_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE3"), count(distinct "HEADER_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE4"), count(distinct "HEADER_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump
(max(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE5"), count(distinct "HEADER_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE6"), count(distinct "HEADER_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE7"), count(distinct "HEADER_ATTRIBUTE7"), sum(sys_op_opnsize("HEADER_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE8"), count(distinct "HEADER_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE9"), count(distinct "HEADER_ATTRIBUTE9"), sum(sys_op_opnsize("HEADER_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE10"), count(distinct "HEADER_ATTRIBUTE10"), sum(sys_op_opnsize("HEADER_ATTRIBUTE10")), substrb(dump(min(substrb("HEADE
R_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE11"), count(distinct "HEADER_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE12"), count(distinct "HEADER_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_ATTRIBUTE12")), substrb(dump(min(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE13"), count(distinct "HEADER_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE14"), count(distinct "HEADER_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE15"), count(distinct "HEADER_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("COMMENTS"), count(distinct "COMMENTS"), sum(sys_op
_opnsize("COMMENTS")), substrb(dump(min(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), count("INTERNAL_NOTES"), count(distinct "INTERNAL_NOTES"), sum(sys_op_opnsize("INTERNAL_NOTES")), substrb(dump(min(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), count("INITIAL_CUSTOMER_TRX_ID"), count(distinct "INITIAL_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("INITIAL_CUSTOMER_TRX_ID")), substrb(dump(min("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE_CONTEXT"), count(distinct "USSGL_TRANSACTION_CODE_CONTEXT"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE_CONTEXT")), substrb(dump(min("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE"), count(distinct "USSGL_TRANSACTION_CODE"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE")), substrb(dump(min("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), count("ACCTD_AMOUNT"), count(distinct "ACCTD_AMOUNT"), sum(sys_op_opnsize("ACCTD_AMOUNT")), 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_opnsiz
e("CUSTOMER_BANK_ACCOUNT_ID")), substrb(dump(min("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), count("CUSTOMER_BANK_ACCOUNT_NAME"), count(distinct "CUSTOMER_BANK_ACCOUNT_NAME"), sum(sys_op_opnsize("CUSTOMER_BANK_ACCOUNT_NAME")), substrb(dump(min(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), count("UOM_CODE"), count(distinct "UOM_CODE"), sum(sys_op_opnsize("UOM_CODE")), substrb(dump(min("UOM_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_CODE"), 16, 0, 32), 1, 120), count("UOM_NAME"), count(distinct "UOM_NAME"), sum(sys_op_opnsize("UOM_NAME")), substrb(dump(min("UOM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_NAME"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER_SEQUENCE_ID"), count(distinct "DOCUMENT_NUMBER_SEQUENCE_ID"), sum(sys_op_opnsize("DOCUMENT_NUMBER_SEQUENCE_ID")), substrb(dump(min("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE10"), count(distinct "LINK_TO_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE10")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE11"), count(distinct "LINK_TO_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE11")),
substrb(dump(min("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE12"), count(distinct "LINK_TO_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE12")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE13"), count(distinct "LINK_TO_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE13")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE14"), count(distinct "LINK_TO_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE14")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE15"), count(distinct "LINK_TO_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE15")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE8"), count(distinct "LINK_TO_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE8")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE9"), count(distinct "LINK_TO_LI
NE_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("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE9"), count(distinct "REFERENCE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE9")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE12"), count(distinct "INTERFACE_LINE_ATTRIBUTE12"), sum(sys_op
_opnsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE13")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE14"), count(distinct "INTERFACE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE14")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE15"), count(distinct "INTERFACE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE15")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE9"), count(distinct "INTERFACE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE9")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("VAT_TAX_ID"), count(distinct "VAT_TAX_ID"), sum(sys_op_opnsize("VAT_TAX_ID")), substrb(dump(min("VAT_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("VAT_TAX_ID"), 16, 0, 32), 1, 120), count("REASON_CODE_MEANING"), count(distinct "
REASON_CODE_MEANING"), sum(sys_op_opnsize("REASON_CODE_MEANING")), substrb(dump(min(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("LAST_PERIOD_TO_CREDIT"), count(distinct "LAST_PERIOD_TO_CREDIT"), sum(sys_op_opnsize("LAST_PERIOD_TO_CREDIT")), substrb(dump(min("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), count("PAYING_CUSTOMER_ID"), count(distinct "PAYING_CUSTOMER_ID"), sum(sys_op_opnsize("PAYING_CUSTOMER_ID")), substrb(dump(min("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("PAYING_SITE_USE_ID"), count(distinct "PAYING_SITE_USE_ID"), sum(sys_op_opnsize("PAYING_SITE_USE_ID")), substrb(dump(min("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_FLAG"), count(distinct "TAX_EXEMPT_FLAG"), sum(sys_op_opnsize("TAX_EXEMPT_FLAG")), substrb(dump(min("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE"), count(distinct "TAX_EXEMPT_REASON_CODE"), sum(sys_op_opnsize("TAX_EXEMPT_REASON_CODE")), substrb(dump(min("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE_MEANING"), count(distinct "TAX_EXEMPT_REASON_CODE_MEANING"), sum(sy
s_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_UPDA
TE_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_ATTR
IBUTE7"), 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("ORIG_SYSTEM_SHIP_CONTACT_REF"), count(distinct "ORIG_SYSTEM_SHIP_CONTACT_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t |
| 5kqw5535fjvw6 | SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID |
| 608c0n36kaw62 | begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end; |
| 63t8zpm02skgh | SELECT DECODE(COUNT(PRR.RUN_RESULT_ID), 0, 'N', 'Y') FROM PAY_RUN_RESULTS PRR, PAY_ASSIGNMENT_ACTIONS ASA, PAY_PAYROLL_ACTIONS PPA WHERE PRR.SOURCE_ID = :B3 AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.STATUS IN ('P', 'PA', 'R', 'O') AND ASA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PPA.PAYROLL_ACTION_ID = ASA.PAYROLL_ACTION_ID AND NOT EXISTS (SELECT NULL FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.SOURCE_ID = PRR.RUN_RESULT_ID AND PRR2.SOURCE_TYPE IN ('R', 'V')) AND PPA.DATE_EARNED BETWEEN :B2 AND :B1 |
| 64qc329wgjv39 |
select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char
(PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc |
| 66tmsr3446uqn | SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1 |
| 6gnth2mfbs2nq | declare
v_ret number := 0;
begin
if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) )
then
v_ret := 1;
end if;
:8 := v_ret;
end;
|
| 6h2tpcxpymqu7 | BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END; |
| 76sw2a4vnc89j | begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end; |
| 7g05xfvc5vp74 | BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END; |
| 7mrs575bj7a41 | begin OE_OEOL_SCH.BRANCH_ON_SOURCE_TYPE (:v1, :v2, :v3, :v4, :v5); end; |
| 827gtfny5uagb | begin :con := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); end; |
| 8c8cf4vtv4tx2 |
SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+)
AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) |
| 8jb36w62w5hqf | BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END; |
| 97mt0g20bcfc3 | begin
pay_US_rules.get_default_jurisdiction
(:asgact, :eeid, :defval:defvalind);
end; |
| 9k7t8q4kfcb7y | begin GL.apps_ddl.apps_ddl(:ddl_text); end; |
| 9wdrypwkpf607 | begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end; |
| a29grr748ghc4 | BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END; |
| auzgm2ap4faw2 |
(SELECT SUB.GUID SUB_GUID, DECODE(SUB.RULE_FUNCTION, NULL, DECODE(SUB.JAVA_RULE_FUNC, NULL, NULL, :B5 || SUB.JAVA_RULE_FUNC), SUB.RULE_FUNCTION) RULE_FUNC, SUB.SOURCE_TYPE SOURCE_TYPE, NVL(SUB.PHASE, 0) PHASE, SUB.RULE_DATA RULE_DATA, SUB.PRIORITY PRIORITY FROM WF_EVENT_SUBSCRIPTIONS SUB, WF_EVENTS EVT WHERE SUB.SYSTEM_GUID = :B4 AND SUB.STATUS = 'ENABLED' AND SUB.LICENSED_FLAG = 'Y' AND SUB.SOURCE_TYPE = :B3 AND ((SUB.SOURCE_AGENT_GUID IS NOT NULL AND SUB.SOURCE_AGENT_GUID = NVL(:B2 , SUB.SOURCE_AGENT_GUID)) OR SUB.SOURCE_AGENT_GUID IS NULL) AND SUB.EVENT_FILTER_GUID = EVT.GUID AND EVT.NAME IN (:B1 , 'oracle.apps.wf.event.any') AND EVT.TYPE = 'EVENT' AND EVT.STATUS = 'ENABLED' AND EVT.LICENSED_FLAG = 'Y') UNION ALL (SELECT SUB.GUID SUB_GUID, DECODE(SUB.RULE_FUNCTION, NULL, DECODE(SUB.JAVA_RULE_FUNC, NULL, NULL, :B5 || SUB.JAVA_RULE_FUNC), SUB.RULE_FUNCTION) RULE_FUNC, SUB.SOURCE_TYPE SOURCE_TYPE, NVL(SUB.PHASE, 0) PHASE, SUB.RULE_DATA RULE_DATA, SUB.PRIORITY PRIORITY FROM WF_EVENT_SUBSCRIPTIONS SUB, WF_EVENT_GROUPS EGRP, WF_EVENTS GRP, WF_EVENTS EVT WHERE SUB.SYSTEM_GUID = :B4 AND SUB.STATUS = 'ENABLED' AND SUB.LICENSED_FLAG = 'Y' AND SUB.SOURCE_TYPE = :B3 AND ((SUB.SOURCE_AGENT_GUID IS NOT NULL AND SUB.SOURCE_AGENT_GUID = NVL(:B2 , SUB.SOURCE_AGENT_GUID)) OR SUB.SOURCE_AGENT_GUID IS NULL) AND GRP.GUID = SUB.EVENT_FILTER_GUID AND GRP.TYPE = 'GROUP' AND GRP.STATUS = 'ENABLED' AND EGRP.GROUP_GUID = GRP.GUID AND EGRP.MEMBER_GUID = EVT.GUID AND EVT.NA
ME = :B1 AND EVT.TYPE = 'EVENT' AND EVT.STATUS = 'ENABLED' AND EVT.LICENSED_FLAG = 'Y') ORDER BY 4 |
| avc1jqzz04wpr | SELECT 'x' FROM DUAL |
| bf7uwg5pa3pj6 | begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end; |
| bfbyqwbr4vwms | begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end; |
| bkxrrs52m7d8p | BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END; |
| bp8crdjba8zgt | update ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b4) |
| cd9mbmqyf4qhp | UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1 |
| csvvv0fmhr1yc | BEGIN
FFP1893_01010001.FORMULA(
:N1,
:N4,
:T1,
:I1,
:D1,
:T2,
:I2,
:T7,
:I7,
:T8,
:I8,
:T5,
:I5,
:N3,
:T4,
:I4,
:N2,
:N5,
:T3,
:I3,
:T6,
:I6,
:FFERLN, :FFERCD, :FFERMT);
END; |
| cw171rvngr1w9 | begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end; |
| cwyx16zn1hpfb | select parameter, value from nls_session_parameters |
| 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 |
| dcvv68fju01g4 | begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end; |
| fb13x9qx0ftks | begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end; |
| fmfdkztk8vx23 | SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1 |
| 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 |
| fvcbstf9s6a5r | begin WF_STANDARD.WAITFORFLOW (:v1, :v2, :v3, :v4, :v5); end; |
| g8102j8yynbwz | begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end; |
| gdnwgx9fcxggr | begin OE_SHIPPING_WF.START_SHIPPING (:v1, :v2, :v3, :v4, :v5); end; |
| gf1u933c95jb5 | DECLARE
l_ret_stat varchar2(56);
BEGIN
CSI_INV_TXN_HOOK_PKG.postTransaction(
p_header_id => :1 ,
p_transaction_id => :2 ,
x_return_status => l_ret_stat );
INV_TXNSTUB_PUB.g_ret_status := l_ret_stat;
END; |
| gksvm8wmzk8w0 | begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end; |
| gnng1rmpjxzsx | begin OE_CLOSE_WF.CLOSE_LINE (:v1, :v2, :v3, :v4, :v5); end; |
Back to SQL Statistics
Back to Top
Instance Activity Statistics
Back to Top
Instance Activity Stats
| Statistic | Total | per Second | per Trans |
|---|
| CPU used by this session | 1,921,617 | 533.03 | 2.56 |
| CPU used when call started | 1,919,213 | 532.36 | 2.56 |
| CR blocks created | 13,042,256 | 3,617.74 | 17.39 |
| Cached Commit SCN referenced | 44,930 | 12.46 | 0.06 |
| Commit SCN cached | 8 | 0.00 | 0.00 |
| DB time | 6,230,958 | 1,728.38 | 8.31 |
| DBWR checkpoint buffers written | 2,734,887 | 758.62 | 3.65 |
| DBWR checkpoints | 37 | 0.01 | 0.00 |
| DBWR object drop buffers written | 28,105 | 7.80 | 0.04 |
| DBWR revisited being-written buffer | 12 | 0.00 | 0.00 |
| DBWR thread checkpoint buffers written | 1,090,563 | 302.51 | 1.45 |
| DBWR transaction table writes | 1,491 | 0.41 | 0.00 |
| DBWR undo block writes | 1,427,189 | 395.88 | 1.90 |
| DFO trees parallelized | 48 | 0.01 | 0.00 |
| IMU CR rollbacks | 25,658,956 | 7,117.44 | 34.22 |
| IMU Flushes | 243,086 | 67.43 | 0.32 |
| IMU Redo allocation size | 1,633,211,620 | 453,030.24 | 2,178.12 |
| IMU commits | 397,828 | 110.35 | 0.53 |
| IMU contention | 25,995 | 7.21 | 0.03 |
| IMU ktichg flush | 5,855 | 1.62 | 0.01 |
| IMU pool not allocated | 1,567 | 0.43 | 0.00 |
| IMU recursive-transaction flush | 1,198 | 0.33 | 0.00 |
| IMU undo allocation size | 3,613,465,960 | 1,002,325.32 | 4,819.06 |
| IMU- failed to get a private strand | 1,567 | 0.43 | 0.00 |
| PX local messages recv'd | 66,880 | 18.55 | 0.09 |
| PX local messages sent | 66,880 | 18.55 | 0.09 |
| Parallel operations downgraded 25 to 50 pct | 40 | 0.01 | 0.00 |
| Parallel operations not downgraded | 8 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 25,548,363 | 7,086.76 | 34.07 |
| active txn count during cleanout | 80,681,056 | 22,379.81 | 107.60 |
| application wait time | 55,946 | 15.52 | 0.07 |
| background checkpoints completed | 5 | 0.00 | 0.00 |
| background checkpoints started | 5 | 0.00 | 0.00 |
| background timeouts | 11,462 | 3.18 | 0.02 |
| branch node splits | 995 | 0.28 | 0.00 |
| buffer is not pinned count | 592,216,866 | 164,272.74 | 789.80 |
| buffer is pinned count | 1,271,830,720 | 352,788.19 | 1,696.16 |
| bytes received via SQL*Net from client | 5,764,442,451 | 1,598,976.35 | 7,687.69 |
| bytes sent via SQL*Net to client | 5,665,232,216 | 1,571,456.81 | 7,555.38 |
| calls to get snapshot scn: kcmgss | 75,121,093 | 20,837.55 | 100.18 |
| calls to kcmgas | 16,310,693 | 4,524.36 | 21.75 |
| calls to kcmgcs | 15,194,913 | 4,214.86 | 20.26 |
| change write time | 56,521 | 15.68 | 0.08 |
| cleanout - number of ktugct calls | 26,807,310 | 7,435.98 | 35.75 |
| cleanouts and rollbacks - consistent read gets | 11,131,075 | 3,087.61 | 14.84 |
| cleanouts only - consistent read gets | 117,528 | 32.60 | 0.16 |
| cluster key scan block gets | 763,519 | 211.79 | 1.02 |
| cluster key scans | 219,263 | 60.82 | 0.29 |
| commit batch/immediate performed | 3,435 | 0.95 | 0.00 |
| commit batch/immediate requested | 3,435 | 0.95 | 0.00 |
| commit cleanout failures: block lost | 176,261 | 48.89 | 0.24 |
| commit cleanout failures: buffer being written | 3,005 | 0.83 | 0.00 |
| commit cleanout failures: callback failure | 98,593 | 27.35 | 0.13 |
| commit cleanout failures: cannot pin | 26,605 | 7.38 | 0.04 |
| commit cleanouts | 7,024,368 | 1,948.46 | 9.37 |
| commit cleanouts successfully completed | 6,719,904 | 1,864.01 | 8.96 |
| commit immediate performed | 3,435 | 0.95 | 0.00 |
| commit immediate requested | 3,435 | 0.95 | 0.00 |
| commit txn count during cleanout | 1,069,156 | 296.57 | 1.43 |
| concurrency wait time | 32,774 | 9.09 | 0.04 |
| consistent changes | 610,445,929 | 169,329.23 | 814.11 |
| consistent gets | 1,473,725,636 | 408,791.04 | 1,965.42 |
| consistent gets - examination | 1,009,551,418 | 280,035.55 | 1,346.38 |
| consistent gets from cache | 1,473,725,640 | 408,791.04 | 1,965.42 |
| cursor authentications | 1,724 | 0.48 | 0.00 |
| data blocks consistent reads - undo records applied | 608,186,478 | 168,702.49 | 811.10 |
| db block changes | 175,163,478 | 48,587.92 | 233.60 |
| db block gets | 204,175,013 | 56,635.32 | 272.30 |
| db block gets direct | 4,068 | 1.13 | 0.01 |
| db block gets from cache | 204,170,948 | 56,634.19 | 272.29 |
| deferred (CURRENT) block cleanout applications | 1,204,973 | 334.24 | 1.61 |
| dirty buffers inspected | 6,061 | 1.68 | 0.01 |
| doubling up with imu segment | 0 | 0.00 | 0.00 |
| enqueue conversions | 7,385 | 2.05 | 0.01 |
| enqueue releases | 2,888,019 | 801.10 | 3.85 |
| enqueue requests | 2,895,609 | 803.20 | 3.86 |
| enqueue timeouts | 7,411 | 2.06 | 0.01 |
| enqueue waits | 35,587 | 9.87 | 0.05 |
| exchange deadlocks | 45,108 | 12.51 | 0.06 |
| execute count | 67,130,659 | 18,621.11 | 89.53 |
| failed probes on index block reclamation | 12,055 | 3.34 | 0.02 |
| free buffer inspected | 2,174,769 | 603.25 | 2.90 |
| free buffer requested | 16,791,441 | 4,657.71 | 22.39 |
| heap block compress | 28,055,751 | 7,782.28 | 37.42 |
| hot buffers moved to head of LRU | 818,716 | 227.10 | 1.09 |
| immediate (CR) block cleanout applications | 11,248,616 | 3,120.21 | 15.00 |
| immediate (CURRENT) block cleanout applications | 993,420 | 275.56 | 1.32 |
| index crx upgrade (found) | 23,336 | 6.47 | 0.03 |
| index crx upgrade (positioned) | 6,527,732 | 1,810.70 | 8.71 |
| index fast full scans (rowid ranges) | 1,832 | 0.51 | 0.00 |
| index fetch by key | 161,946,631 | 44,921.75 | 215.98 |
| index scans kdiixs1 | 109,555,219 | 30,389.10 | 146.11 |
| java call heap collected bytes | 1,055,350,184 | 292,739.50 | 1,407.46 |
| java call heap collected count | 13,354,020 | 3,704.22 | 17.81 |
| java call heap gc count | 3,753 | 1.04 | 0.01 |
| java call heap live object count | 1,396,579 | 387.39 | 1.86 |
| java call heap live object count max | 1,503,419 | 417.03 | 2.01 |
| java call heap live size | 337,656,776 | 93,661.30 | 450.31 |
| java call heap live size max | 358,833,480 | 99,535.43 | 478.55 |
| java call heap object count | 3,531,223 | 979.51 | 4.71 |
| java call heap object count max | 3,556,958 | 986.65 | 4.74 |
| java call heap total size | 434,765,824 | 120,598.01 | 579.82 |
| java call heap total size max | 461,504,512 | 128,014.95 | 615.48 |
| java call heap used size | 476,160,104 | 132,080.21 | 635.03 |
| java call heap used size max | 490,703,800 | 136,114.43 | 654.42 |
| leaf node 90-10 splits | 16,896 | 4.69 | 0.02 |
| leaf node splits | 219,678 | 60.94 | 0.29 |
| lob reads | 11,029 | 3.06 | 0.01 |
| lob writes | 19,467 | 5.40 | 0.03 |
| lob writes unaligned | 19,467 | 5.40 | 0.03 |
| logons cumulative | 5,944 | 1.65 | 0.01 |
| messages received | 1,026,780 | 284.81 | 1.37 |
| messages sent | 1,026,780 | 284.81 | 1.37 |
| no buffer to keep pinned count | 16 | 0.00 | 0.00 |
| no work - consistent read gets | 427,663,315 | 118,627.87 | 570.35 |
| opened cursors cumulative | 3,274,713 | 908.36 | 4.37 |
| parse count (failures) | 1,682 | 0.47 | 0.00 |
| parse count (hard) | 5,936 | 1.65 | 0.01 |
| parse count (total) | 5,321,765 | 1,476.18 | 7.10 |
| parse time cpu | 37,132 | 10.30 | 0.05 |
| parse time elapsed | 45,012 | 12.49 | 0.06 |
| physical read IO requests | 241,723 | 67.05 | 0.32 |
| physical read bytes | 3,291,406,336 | 912,990.45 | 4,389.55 |
| physical read total IO requests | 271,145 | 75.21 | 0.36 |
| physical read total bytes | 3,772,451,840 | 1,046,425.79 | 5,031.09 |
| physical read total multi block requests | 15,056 | 4.18 | 0.02 |
| physical reads | 401,782 | 111.45 | 0.54 |
| physical reads cache | 400,133 | 110.99 | 0.53 |
| physical reads cache prefetch | 159,880 | 44.35 | 0.21 |
| physical reads direct | 1,650 | 0.46 | 0.00 |
| physical reads direct temporary tablespace | 186 | 0.05 | 0.00 |
| physical reads prefetch warmup | 102,305 | 28.38 | 0.14 |
| physical write IO requests | 1,288,070 | 357.29 | 1.72 |
| physical write bytes | 22,781,108,224 | 6,319,163.31 | 30,381.78 |
| physical write total IO requests | 1,936,856 | 537.26 | 2.58 |
| physical write total bytes | 52,716,112,384 | 14,622,718.09 | 70,304.27 |
| physical write total multi block requests | 1,140,023 | 316.23 | 1.52 |
| physical writes | 2,780,897 | 771.38 | 3.71 |
| physical writes direct | 4,809 | 1.33 | 0.01 |
| physical writes direct (lob) | 236 | 0.07 | 0.00 |
| physical writes direct temporary tablespace | 3,958 | 1.10 | 0.01 |
| physical writes from cache | 2,776,088 | 770.05 | 3.70 |
| physical writes non checkpoint | 2,069,001 | 573.91 | 2.76 |
| pinned buffers inspected | 1,320 | 0.37 | 0.00 |
| prefetch clients - default | 1 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 213,373 | 59.19 | 0.28 |
| prefetched blocks aged out before use | 120 | 0.03 | 0.00 |
| process last non-idle time | 3,607 | 1.00 | 0.00 |
| queries parallelized | 48 | 0.01 | 0.00 |
| recursive calls | 109,858,341 | 30,473.18 | 146.51 |
| recursive cpu usage | 1,121,591 | 311.11 | 1.50 |
| redo blocks written | 58,291,215 | 16,169.17 | 77.74 |
| redo buffer allocation retries | 22 | 0.01 | 0.00 |
| redo entries | 90,598,685 | 25,130.82 | 120.83 |
| redo log space requests | 41 | 0.01 | 0.00 |
| redo log space wait time | 44 | 0.01 | 0.00 |
| redo ordering marks | 1,150,926 | 319.25 | 1.53 |
| redo size | 28,637,081,416 | 7,943,529.02 | 38,191.53 |
| redo subscn max counts | 2,169,484 | 601.78 | 2.89 |
| redo synch time | 41,827 | 11.60 | 0.06 |
| redo synch writes | 1,163,130 | 322.64 | 1.55 |
| redo wastage | 231,428,264 | 64,194.99 | 308.64 |
| redo write time | 33,835 | 9.39 | 0.05 |
| redo writer latching time | 79 | 0.02 | 0.00 |
| redo writes | 571,908 | 158.64 | 0.76 |
| rollback changes - undo records applied | 259,009 | 71.85 | 0.35 |
| rollbacks only - consistent read gets | 2,092,177 | 580.34 | 2.79 |
| rows fetched via callback | 94,985,527 | 26,347.67 | 126.68 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 3,562,996 | 988.33 | 4.75 |
| session logical reads | 1,677,900,325 | 465,426.27 | 2,237.71 |
| session pga memory | 7,851,048,128 | 2,177,771.81 | 10,470.47 |
| session pga memory max | 10,122,244,000 | 2,807,770.03 | 13,499.42 |
| session uga memory | ############### | 74,219,990.80 | 356,840.80 |
| session uga memory max | 41,497,908,240 | 11,510,943.92 | 55,343.24 |
| shared hash latch upgrades - no wait | 25,747,815 | 7,142.09 | 34.34 |
| shared hash latch upgrades - wait | 42,103 | 11.68 | 0.06 |
| sorts (memory) | 6,808,575 | 1,888.60 | 9.08 |
| sorts (rows) | 89,848,680 | 24,922.78 | 119.83 |
| sql area evicted | 1,372 | 0.38 | 0.00 |
| sql area purged | 1,851 | 0.51 | 0.00 |
| summed dirty queue length | 20,465 | 5.68 | 0.03 |
| switch current to new buffer | 1,112,171 | 308.50 | 1.48 |
| table fetch by rowid | 792,898,506 | 219,939.04 | 1,057.44 |
| table fetch continued row | 30,871,573 | 8,563.35 | 41.17 |
| table scan blocks gotten | 40,686,807 | 11,285.96 | 54.26 |
| table scan rows gotten | 1,192,455,185 | 330,770.52 | 1,590.30 |
| table scans (long tables) | 4,149 | 1.15 | 0.01 |
| table scans (rowid ranges) | 4,147 | 1.15 | 0.01 |
| table scans (short tables) | 3,177,900 | 881.51 | 4.24 |
| total number of times SMON posted | 72,986 | 20.25 | 0.10 |
| transaction rollbacks | 3,435 | 0.95 | 0.00 |
| transaction tables consistent read rollbacks | 77 | 0.02 | 0.00 |
| transaction tables consistent reads - undo records applied | 5,246 | 1.46 | 0.01 |
| undo change vector size | 9,949,568,396 | 2,759,872.21 | 13,269.13 |
| user I/O wait time | 260,176 | 72.17 | 0.35 |
| user calls | 24,389,362 | 6,765.27 | 32.53 |
| user commits | 625,155 | 173.41 | 0.83 |
| user rollbacks | 124,673 | 34.58 | 0.17 |
| workarea executions - onepass | 2 | 0.00 | 0.00 |
| workarea executions - optimal | 3,657,619 | 1,014.57 | 4.88 |
| write clones created in background | 1,341 | 0.37 | 0.00 |
| write clones created in foreground | 21,817 | 6.05 | 0.03 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Absolute Values
- Statistics with absolute values (should not be diffed)
| Statistic | Begin Value | End Value |
|---|
| session cursor cache count | 193,200 | 570,141 |
| opened cursors current | 528,628 | 636,074 |
| workarea memory allocated | 687 | 2,087 |
| logons current | 2,621 | 2,632 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Thread Activity
- Statistics identified by '(derived)' come from sources other than SYSSTAT
| Statistic | Total | per Hour |
|---|
| log switches (derived) | 3 | 3.00 |
Back to Instance Activity Statistics
Back to Top
IO Stats
Back to Top
Tablespace IO Stats
- ordered by IOs (Reads + Writes) desc
| Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|
| APPS_UNDOTS1 |
51 | 0 | 0.00 | 1.00 | 540,909 | 150 | 273,305 | 0.03 |
| APPS_TS_TX_DATA |
152,175 | 42 | 10.18 | 1.38 | 170,061 | 47 | 136,413 | 0.41 |
| APPS_ASSM_DATA |
8,605 | 2 | 6.60 | 6.66 | 284,046 | 79 | 51,287 | 1.18 |
| APPS_TS_TX_IDX |
65,875 | 18 | 9.20 | 1.63 | 111,812 | 31 | 65,373 | 0.58 |
| APPS_ASSM_IDX |
6,183 | 2 | 5.49 | 1.06 | 138,846 | 39 | 252,648 | 0.12 |
| APPS_TS_TX_INTERFACE |
1,074 | 0 | 2.52 | 2.21 | 20,650 | 6 | 18,234 | 0.09 |
| TEMP |
230 | 0 | 0.22 | 17.97 | 6,374 | 2 | 238 | 555.17 |
| SYSTEM |
3,754 | 1 | 6.75 | 1.57 | 2,034 | 1 | 18,716 | 0.17 |
| APPS_TS_SEED |
1,854 | 1 | 11.29 | 2.75 | 3,308 | 1 | 795 | 6.45 |
| APPS_TS_QUEUES |
1,163 | 0 | 3.80 | 1.67 | 3,330 | 1 | 261 | 2.91 |
| APPS_TS_SUMMARY |
107 | 0 | 0.09 | 1.00 | 3,751 | 1 | 2,295 | 0.02 |
| SYSAUX |
274 | 0 | 3.76 | 1.08 | 1,477 | 0 | 0 | 0.00 |
| APPS_TS_ARCHIVE |
58 | 0 | 3.28 | 1.31 | 1,394 | 0 | 42 | 2.14 |
| APPS_TS_NOLOGGING |
37 | 0 | 1.89 | 1.38 | 65 | 0 | 0 | 0.00 |
| CTXSYS |
48 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA |
24 | 0 | 0.00 | 1.00 | 15 | 0 | 0 | 0.00 |
| ODM |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| OLAP |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| OWAPUB |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| PORTAL |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| SYNCSERVER |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
Back to IO Stats
Back to Top
File IO Stats
- ordered by Tablespace, File
| Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|
| APPS_ASSM_DATA | /DB/visdata/apps_assm_data.dbf |
8,605 | 2 | 6.60 | 6.66 | 284,046 | 79 | 51,287 | 1.18 |
| APPS_ASSM_IDX | /DB/visdata/apps_assm_idx.dbf |
6,183 | 2 | 5.49 | 1.06 | 138,846 | 39 | 252,648 | 0.12 |
| APPS_TS_ARCHIVE | /DB/visdata/archive1.dbf |
23 | 0 | 3.48 | 1.30 | 1,156 | 0 | 38 | 2.37 |
| APPS_TS_ARCHIVE | /DB/visdata/archive2.dbf |
35 | 0 | 3.14 | 1.31 | 238 | 0 | 4 | 0.00 |
| APPS_TS_MEDIA | /DB/visdata/media1.dbf |
8 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /DB/visdata/media2.dbf |
8 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /DB/visdata/media3.dbf |
8 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /DB/visdata/nologging1.dbf |
8 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /DB/visdata/nologging2.dbf |
19 | 0 | 2.63 | 1.00 | 49 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /DB/visdata/nologging3.dbf |
10 | 0 | 2.00 | 2.40 | 11 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues1.dbf |
214 | 0 | 2.80 | 1.13 | 519 | 0 | 123 | 0.41 |
| APPS_TS_QUEUES | /DB/visdata/queues2.dbf |
147 | 0 | 2.65 | 1.76 | 578 | 0 | 86 | 1.05 |
| APPS_TS_QUEUES | /DB/visdata/queues3.dbf |
138 | 0 | 5.43 | 1.98 | 425 | 0 | 3 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues4.dbf |
142 | 0 | 3.52 | 1.74 | 365 | 0 | 5 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues5.dbf |
145 | 0 | 2.83 | 1.77 | 404 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues6.dbf |
131 | 0 | 3.44 | 1.98 | 467 | 0 | 1 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues7.dbf |
246 | 0 | 5.37 | 1.65 | 572 | 0 | 43 | 14.42 |
| APPS_TS_SEED | /DB/visdata/reference1.dbf |
164 | 0 | 13.05 | 3.65 | 317 | 0 | 47 | 13.19 |
| APPS_TS_SEED | /DB/visdata/reference10.dbf |
172 | 0 | 10.06 | 3.07 | 355 | 0 | 37 | 5.41 |
| APPS_TS_SEED | /DB/visdata/reference2.dbf |
185 | 0 | 8.76 | 2.37 | 312 | 0 | 31 | 5.48 |
| APPS_TS_SEED | /DB/visdata/reference3.dbf |
283 | 0 | 8.41 | 2.37 | 461 | 0 | 455 | 3.80 |
| APPS_TS_SEED | /DB/visdata/reference4.dbf |
180 | 0 | 13.17 | 2.84 | 335 | 0 | 47 | 11.49 |
| APPS_TS_SEED | /DB/visdata/reference5.dbf |
201 | 0 | 11.09 | 2.34 | 347 | 0 | 67 | 21.34 |
| APPS_TS_SEED | /DB/visdata/reference6.dbf |
180 | 0 | 14.72 | 2.79 | 346 | 0 | 32 | 5.00 |
| APPS_TS_SEED | /DB/visdata/reference7.dbf |
166 | 0 | 16.02 | 3.25 | 264 | 0 | 20 | 5.00 |
| APPS_TS_SEED | /DB/visdata/reference8.dbf |
155 | 0 | 13.10 | 2.75 | 275 | 0 | 25 | 2.80 |
| APPS_TS_SEED | /DB/visdata/reference9.dbf |
168 | 0 | 6.73 | 2.51 | 296 | 0 | 34 | 3.24 |
| APPS_TS_SUMMARY | /DB/visdata/summary1.dbf |
11 | 0 | 0.00 | 1.00 | 429 | 0 | 306 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary2.dbf |
11 | 0 | 0.00 | 1.00 | 416 | 0 | 218 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary3.dbf |
17 | 0 | 0.59 | 1.00 | 447 | 0 | 152 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary4.dbf |
13 | 0 | 0.00 | 1.00 | 408 | 0 | 195 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary5.dbf |
13 | 0 | 0.00 | 1.00 | 375 | 0 | 300 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary6.dbf |
13 | 0 | 0.00 | 1.00 | 643 | 0 | 592 | 0.05 |
| APPS_TS_SUMMARY | /DB/visdata/summary7.dbf |
16 | 0 | 0.00 | 1.00 | 530 | 0 | 309 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary8.dbf |
13 | 0 | 0.00 | 1.00 | 503 | 0 | 223 | 0.09 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data1.dbf |
2,710 | 1 | 12.55 | 1.44 | 222 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data10.dbf |
2,563 | 1 | 13.37 | 1.35 | 86 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data11.dbf |
2,496 | 1 | 11.64 | 1.34 | 87 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data12.dbf |
11,723 | 3 | 8.06 | 1.24 | 1,818 | 1 | 3,904 | 1.69 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data13.dbf |
15,426 | 4 | 12.44 | 1.50 | 2,689 | 1 | 2,904 | 1.64 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data14.dbf |
11,753 | 3 | 8.77 | 1.42 | 26,357 | 7 | 18,080 | 0.31 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data15.dbf |
8,374 | 2 | 10.40 | 1.50 | 23,755 | 7 | 18,786 | 0.39 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data16.dbf |
8,416 | 2 | 9.87 | 1.48 | 22,847 | 6 | 17,697 | 0.31 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data17.dbf |
8,445 | 2 | 10.14 | 1.50 | 22,701 | 6 | 17,243 | 0.29 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data18.dbf |
8,488 | 2 | 10.43 | 1.48 | 21,908 | 6 | 18,103 | 0.29 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data19.dbf |
8,301 | 2 | 8.60 | 1.46 | 22,294 | 6 | 18,087 | 0.23 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data2.dbf |
6,234 | 2 | 7.87 | 1.19 | 480 | 0 | 1,999 | 2.50 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data20.dbf |
8,189 | 2 | 8.78 | 1.51 | 21,940 | 6 | 18,098 | 0.22 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data21.dbf |
20,942 | 6 | 10.90 | 1.20 | 1,178 | 0 | 1,458 | 1.97 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data3.dbf |
2,652 | 1 | 12.15 | 1.45 | 269 | 0 | 6 | 8.33 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data4.dbf |
12,452 | 3 | 8.91 | 1.33 | 234 | 0 | 10 | 6.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data5.dbf |
2,605 | 1 | 9.58 | 1.27 | 230 | 0 | 4 | 10.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data6.dbf |
2,521 | 1 | 12.24 | 1.34 | 135 | 0 | 9 | 5.56 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data7.dbf |
2,562 | 1 | 9.84 | 1.37 | 326 | 0 | 20 | 5.50 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data8.dbf |
2,612 | 1 | 13.78 | 1.25 | 346 | 0 | 5 | 4.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data9.dbf |
2,711 | 1 | 13.63 | 1.46 | 159 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx1.dbf |
2,170 | 1 | 7.73 | 1.32 | 1,561 | 0 | 1,756 | 0.75 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx10.dbf |
2,098 | 1 | 9.50 | 1.32 | 1,057 | 0 | 1,663 | 0.94 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx11.dbf |
2,107 | 1 | 8.04 | 1.35 | 1,124 | 0 | 1,857 | 0.89 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx12.dbf |
6,712 | 2 | 13.70 | 2.18 | 14,333 | 4 | 1,597 | 0.46 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx13.dbf |
6,613 | 2 | 5.64 | 1.44 | 16,441 | 5 | 3,369 | 0.40 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx14.dbf |
3,456 | 1 | 10.08 | 1.82 | 9,905 | 3 | 3,486 | 0.28 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx15.dbf |
3,559 | 1 | 10.21 | 1.80 | 8,423 | 2 | 4,290 | 0.32 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx16.dbf |
3,482 | 1 | 12.11 | 1.81 | 7,308 | 2 | 3,377 | 0.33 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx17.dbf |
3,380 | 1 | 9.50 | 1.73 | 7,296 | 2 | 4,004 | 0.37 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx18.dbf |
3,395 | 1 | 8.93 | 1.73 | 7,223 | 2 | 4,516 | 0.29 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx19.dbf |
3,438 | 1 | 11.50 | 1.86 | 7,039 | 2 | 4,291 | 0.26 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx2.dbf |
2,384 | 1 | 8.02 | 1.61 | 1,169 | 0 | 2,220 | 0.43 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx20.dbf |
3,434 | 1 | 10.46 | 1.75 | 6,561 | 2 | 3,103 | 0.38 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx21.dbf |
2,328 | 1 | 11.01 | 2.04 | 8,373 | 2 | 2,216 | 1.85 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx3.dbf |
3,669 | 1 | 6.88 | 1.23 | 1,344 | 0 | 2,778 | 1.40 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx4.dbf |
2,329 | 1 | 7.17 | 1.30 | 2,444 | 1 | 3,007 | 1.21 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx5.dbf |
2,335 | 1 | 6.78 | 1.35 | 3,859 | 1 | 10,042 | 0.27 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx6.dbf |
2,338 | 1 | 7.10 | 1.41 | 2,053 | 1 | 2,815 | 0.66 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx7.dbf |
2,265 | 1 | 7.72 | 1.36 | 2,016 | 1 | 1,856 | 1.07 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx8.dbf |
2,223 | 1 | 7.99 | 1.43 | 1,089 | 0 | 1,535 | 1.18 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx9.dbf |
2,160 | 1 | 8.09 | 1.36 | 1,194 | 0 | 1,595 | 1.10 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte.dbf |
211 | 0 | 2.27 | 1.70 | 3,001 | 1 | 6,691 | 0.03 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte2.dbf |
292 | 0 | 2.47 | 2.10 | 4,175 | 1 | 4,098 | 0.28 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte3.dbf |
164 | 0 | 3.29 | 2.51 | 3,763 | 1 | 2,733 | 0.02 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte4.dbf |
129 | 0 | 2.87 | 2.63 | 3,195 | 1 | 1,837 | 0.04 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte5.dbf |
149 | 0 | 2.82 | 2.30 | 3,186 | 1 | 1,888 | 0.02 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte6.dbf |
129 | 0 | 1.40 | 2.44 | 3,330 | 1 | 987 | 0.05 |
| APPS_UNDOTS1 | /DB/visdata/undo01.dbf |
5 | 0 | 0.00 | 1.00 | 54,648 | 15 | 24,576 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo02.dbf |
5 | 0 | 0.00 | 1.00 | 54,112 | 15 | 22,625 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo03.dbf |
6 | 0 | 0.00 | 1.00 | 53,836 | 15 | 24,408 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo04.dbf |
5 | 0 | 0.00 | 1.00 | 52,077 | 14 | 26,422 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo05.dbf |
5 | 0 | 0.00 | 1.00 | 54,841 | 15 | 32,256 | 0.04 |
| APPS_UNDOTS1 | /DB/visdata/undo06.dbf |
5 | 0 | 0.00 | 1.00 | 53,406 | 15 | 25,345 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo07.dbf |
5 | 0 | 0.00 | 1.00 | 58,481 | 16 | 27,185 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo08.dbf |
5 | 0 | 0.00 | 1.00 | 53,684 | 15 | 28,234 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo09.dbf |
5 | 0 | 0.00 | 1.00 | 52,521 | 15 | 31,168 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo10.dbf |
5 | 0 | 0.00 | 1.00 | 53,303 | 15 | 31,086 | 0.03 |
| CTXSYS | /DB/visdata/ctx1.dbf |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| CTXSYS | /DB/visdata/ctx2.dbf |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| ODM | /DB/visdata/odm.dbf |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| OLAP | /DB/visdata/olap.dbf |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| OWAPUB | /DB/visdata/owa1.dbf |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| PORTAL | /DB/visdata/portal.dbf |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| SYNCSERVER | /DB/visdata/mobile01.dbf |
24 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
| SYSAUX | /DB/visdata/sysaux01.dbf |
17 | 0 | 8.82 | 1.88 | 597 | 0 | 0 | 0.00 |
| SYSAUX | /DB/visdata/sysaux02.dbf |
257 | 0 | 3.42 | 1.03 | 880 | 0 | 0 | 0.00 |
| SYSTEM | /DB/visdata/sys1.dbf |
411 | 0 | 7.10 | 1.60 | 95 | 0 | 241 | 0.29 |
| SYSTEM | /DB/visdata/sys2.dbf |
391 | 0 | 7.26 | 1.54 | 152 | 0 | 274 | 0.36 |
| SYSTEM | /DB/visdata/sys3.dbf |
479 | 0 | 4.59 | 1.53 | 187 | 0 | 99 | 2.93 |
| SYSTEM | /DB/visdata/sys4.dbf |
495 | 0 | 6.69 | 1.48 | 195 | 0 | 25 | 3.20 |
| SYSTEM | /DB/visdata/sys5.dbf |
456 | 0 | 7.70 | 1.49 | 605 | 0 | 1,033 | 0.45 |
| SYSTEM | /DB/visdata/sys6.dbf |
393 | 0 | 7.28 | 1.55 | 47 | 0 | 33 | 17.88 |
| SYSTEM | /DB/visdata/sys7.dbf |
331 | 0 | 5.05 | 1.76 | 124 | 0 | 104 | 0.38 |
| SYSTEM | /DB/visdata/sys8.dbf |
296 | 0 | 8.48 | 1.84 | 331 | 0 | 16,672 | 0.08 |
| SYSTEM | /DB/visdata/sys9.dbf |
502 | 0 | 6.99 | 1.48 | 298 | 0 | 235 | 0.85 |
| TEMP | /DB/visdata/temp1.dbf |
43 | 0 | 0.23 | 11.74 | 1,838 | 1 | 92 | 445.11 |
| TEMP | /DB/visdata/temp2.dbf |
58 | 0 | 0.52 | 33.10 | 1,390 | 0 | 41 | 537.56 |
| TEMP | /DB/visdata/temp3.dbf |
59 | 0 | 0.17 | 24.73 | 1,464 | 0 | 48 | 737.71 |
| TEMP | /DB/visdata/temp4.dbf |
70 | 0 | 0.00 | 3.57 | 1,682 | 0 | 57 | 591.75 |
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
| P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
|---|
| D | 2,263,976 | 100 | 1,660,917,174 | 400,114 | 2,776,276 | 0 | 0 | 819,685 |
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 IOs | Actual Redo Blks | Target Redo Blks | Log File Size Redo Blks | Log Ckpt Timeout Redo Blks | Log Ckpt Interval Redo Blks |
|---|
| B | 180 | 78 | 24886 | 543573 | 2064405 | 35156250 | 2064405 | |
| E | 180 | 101 | 40601 | 907881 | 7712032 | 35156250 | 7712032 | |
Back to Advisory Statistics
Back to Top
|
