|
|
|
AWR Report
WORKLOAD REPOSITORY report for
| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|
| VIS | 127695557 | VIS | 1 | 10.2.0.3.0 | NO | hpdb1 |
| Snap Id | Snap Time | Sessions | Cursors/Session |
|---|
| Begin Snap: | 56 | 21-Dec-07 07:29:58 | 5224 | 165.2 |
| End Snap: | 57 | 21-Dec-07 08:30:06 | 5196 | 173.2 |
| Elapsed: | | 60.14 (mins) | | |
| DB Time: | | 731.04 (mins) | | |
Report Summary
Cache Sizes
| Begin | End | | |
|---|
| Buffer Cache: | 16,272M | 16,240M | Std Block Size: | 8K |
| Shared Pool Size: | 3,008M | 3,040M | Log Buffer: | 16,640K |
Load Profile
| Per Second | Per Transaction |
|---|
| Redo size: | 9,749,878.59 | 28,318.58 |
| Logical reads: | 577,606.71 | 1,677.66 |
| Block changes: | 56,555.95 | 164.27 |
| Physical reads: | 153.86 | 0.45 |
| Physical writes: | 1,060.48 | 3.08 |
| User calls: | 13,734.63 | 39.89 |
| Parses: | 4,970.41 | 14.44 |
| Hard parses: | 2.55 | 0.01 |
| Sorts: | 3,613.22 | 10.49 |
| Logons: | 3.00 | 0.01 |
| Executes: | 33,426.70 | 97.09 |
| Transactions: | 344.29 | |
| % Blocks changed per Read: | 9.79 | Recursive Call %: | 81.43 |
| Rollback per transaction %: | 21.38 | Rows per Sort: | 11.98 |
Instance Efficiency Percentages (Target 100%)
| Buffer Nowait %: | 99.96 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.97 | In-memory Sort %: | 100.00 |
| Library Hit %: | 100.02 | Soft Parse %: | 99.95 |
| Execute to Parse %: | 85.13 | Latch Hit %: | 98.80 |
| Parse CPU to Parse Elapsd %: | 87.70 | % Non-Parse CPU: | 97.08 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 71.87 | 85.39 |
| % SQL with executions>1: | 81.94 | 78.98 |
| % Memory for SQL w/exec>1: | 59.00 | 50.73 |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|
| CPU time | | 40,492 | | 92.3 | |
| db file sequential read | 374,862 | 1,798 | 5 | 4.1 | User I/O |
| log file sync | 495,757 | 635 | 1 | 1.4 | Commit |
| SQL*Net more data from client | 2,055,698 | 563 | 0 | 1.3 | Network |
| log file parallel write | 924,728 | 542 | 1 | 1.2 | System I/O |
Main Report
Back to Top
Wait Events Statistics
Back to Top
Time Model Statistics
- Total time in database user-calls (DB Time): 43862.6s
- 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 |
|---|
| DB CPU | 40,491.95 | 92.32 |
| sql execute elapsed time | 38,379.14 | 87.50 |
| PL/SQL execution elapsed time | 8,824.01 | 20.12 |
| inbound PL/SQL rpc elapsed time | 8,215.17 | 18.73 |
| parse time elapsed | 1,414.13 | 3.22 |
| Java execution elapsed time | 1,403.03 | 3.20 |
| hard parse elapsed time | 635.81 | 1.45 |
| repeated bind elapsed time | 100.51 | 0.23 |
| sequence load elapsed time | 20.13 | 0.05 |
| connection management call elapsed time | 19.72 | 0.04 |
| PL/SQL compilation elapsed time | 11.06 | 0.03 |
| hard parse (sharing criteria) elapsed time | 6.40 | 0.01 |
| failed parse elapsed time | 3.11 | 0.01 |
| hard parse (bind mismatch) elapsed time | 1.50 | 0.00 |
| DB time | 43,862.61 | |
| background elapsed time | 2,034.35 | |
| background cpu time | 968.91 | |
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 | 432,387 | 0.00 | 2,004 | 5 | 0.35 |
| System I/O | 1,061,996 | 0.00 | 699 | 1 | 0.85 |
| Commit | 495,757 | 0.00 | 635 | 1 | 0.40 |
| Network | 55,857,000 | 0.00 | 627 | 0 | 44.96 |
| Concurrency | 3,255,575 | 0.16 | 584 | 0 | 2.62 |
| Application | 75,570 | 0.16 | 481 | 6 | 0.06 |
| Other | 172,798 | 28.20 | 97 | 1 | 0.14 |
| Configuration | 9,992 | 40.45 | 28 | 3 | 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 | 374,862 | 0.00 | 1,798 | 5 | 0.30 |
| log file sync | 495,757 | 0.00 | 635 | 1 | 0.40 |
| SQL*Net more data from client | 2,055,698 | 0.00 | 563 | 0 | 1.65 |
| log file parallel write | 924,728 | 0.00 | 542 | 1 | 0.74 |
| enq: TM - contention | 114 | 77.19 | 311 | 2724 | 0.00 |
| latch: cache buffers chains | 2,393,035 | 0.00 | 193 | 0 | 1.93 |
| enq: TX - index contention | 52,427 | 0.00 | 186 | 4 | 0.04 |
| db file parallel write | 133,975 | 0.00 | 147 | 1 | 0.11 |
| db file scattered read | 21,897 | 0.00 | 135 | 6 | 0.02 |
| enq: UL - contention | 2,505 | 1.12 | 111 | 44 | 0.00 |
| cursor: pin S wait on X | 5,484 | 94.00 | 97 | 18 | 0.00 |
| read by other session | 33,093 | 0.00 | 66 | 2 | 0.03 |
| buffer busy waits | 774,887 | 0.00 | 62 | 0 | 0.62 |
| SQL*Net more data to client | 1,705,279 | 0.00 | 38 | 0 | 1.37 |
| PX Deq Credit: send blkd | 23,385 | 0.00 | 37 | 2 | 0.02 |
| enq: TX - row lock contention | 483 | 1.66 | 36 | 74 | 0.00 |
| SQL*Net message to client | 52,096,023 | 0.00 | 26 | 0 | 41.93 |
| enq: TX - allocate ITL entry | 101 | 9.90 | 25 | 244 | 0.00 |
| library cache load lock | 838 | 0.00 | 24 | 28 | 0.00 |
| SQL*Net break/reset to client | 72,436 | 0.00 | 19 | 0 | 0.06 |
| rdbms ipc reply | 99 | 6.06 | 15 | 155 | 0.00 |
| kksfbc child completion | 210 | 81.90 | 10 | 46 | 0.00 |
| os thread startup | 75 | 0.00 | 8 | 110 | 0.00 |
| latch: object queue header operation | 47,829 | 0.00 | 8 | 0 | 0.04 |
| wait list latch free | 353 | 0.00 | 7 | 20 | 0.00 |
| latch: library cache | 9,613 | 0.00 | 7 | 1 | 0.01 |
| control file sequential read | 1,570 | 0.00 | 7 | 4 | 0.00 |
| enq: RO - fast object reuse | 32 | 0.00 | 5 | 158 | 0.00 |
| PX Deq: Signal ACK | 531 | 24.86 | 5 | 9 | 0.00 |
| local write wait | 1,444 | 0.00 | 4 | 3 | 0.00 |
| control file parallel write | 1,723 | 0.00 | 4 | 2 | 0.00 |
| latch: In memory undo latch | 12,031 | 0.00 | 3 | 0 | 0.01 |
| latch: undo global data | 3,316 | 0.00 | 3 | 1 | 0.00 |
| latch: cache buffers lru chain | 970 | 0.00 | 3 | 3 | 0.00 |
| enq: HW - contention | 2,693 | 0.00 | 2 | 1 | 0.00 |
| buffer deadlock | 48,439 | 99.01 | 2 | 0 | 0.04 |
| latch free | 2,107 | 0.00 | 2 | 1 | 0.00 |
| enq: TX - contention | 3,151 | 0.00 | 2 | 1 | 0.00 |
| latch: library cache pin | 2,437 | 0.00 | 2 | 1 | 0.00 |
| LGWR wait for redo copy | 31,794 | 0.00 | 1 | 0 | 0.03 |
| enq: DV - contention | 169 | 0.00 | 1 | 4 | 0.00 |
| row cache lock | 1,230 | 0.00 | 1 | 1 | 0.00 |
| latch: redo allocation | 1,859 | 0.00 | 1 | 0 | 0.00 |
| enq: SQ - contention | 3,028 | 0.00 | 1 | 0 | 0.00 |
| latch: session allocation | 1,378 | 0.00 | 1 | 0 | 0.00 |
| latch: row cache objects | 884 | 0.00 | 1 | 1 | 0.00 |
| latch: object queue header heap | 255 | 0.00 | 0 | 2 | 0.00 |
| cursor: pin S | 5,427 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache lock | 457 | 0.00 | 0 | 1 | 0.00 |
| latch: shared pool | 387 | 0.00 | 0 | 1 | 0.00 |
| enq: FB - contention | 581 | 0.00 | 0 | 0 | 0.00 |
| library cache pin | 1,439 | 0.00 | 0 | 0 | 0.00 |
| SGA: allocation forcing component growth | 7 | 71.43 | 0 | 19 | 0.00 |
| write complete waits | 6 | 16.67 | 0 | 21 | 0.00 |
| latch: messages | 146 | 0.00 | 0 | 0 | 0.00 |
| library cache lock | 4 | 0.00 | 0 | 9 | 0.00 |
| reliable message | 35 | 0.00 | 0 | 1 | 0.00 |
| enq: US - contention | 5 | 0.00 | 0 | 5 | 0.00 |
| latch: cache buffer handles | 155 | 0.00 | 0 | 0 | 0.00 |
| undo segment extension | 4,037 | 99.85 | 0 | 0 | 0.00 |
| latch: redo writing | 127 | 0.00 | 0 | 0 | 0.00 |
| PX qref latch | 503 | 89.46 | 0 | 0 | 0.00 |
| direct path read | 608 | 0.00 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 31 | 0.00 | 0 | 0 | 0.00 |
| enq: PS - contention | 39 | 0.00 | 0 | 0 | 0.00 |
| Streams AQ: qmn coordinator waiting for slave to start | 1 | 0.00 | 0 | 6 | 0.00 |
| cursor: mutex S | 193 | 0.00 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 22 | 0.00 | 0 | 0 | 0.00 |
| cursor: mutex X | 154 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 439 | 0.00 | 0 | 0 | 0.00 |
| direct path write temp | 38 | 0.00 | 0 | 0 | 0.00 |
| latch: parallel query alloc buffer | 1 | 0.00 | 0 | 0 | 0.00 |
| direct path read temp | 6 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net message from client | 52,096,046 | 0.00 | 10,054,749 | 193 | 41.93 |
| pipe get | 28,800 | 14.57 | 21,165 | 735 | 0.02 |
| Streams AQ: qmn slave idle wait | 2,246 | 0.04 | 12,111 | 5392 | 0.00 |
| Streams AQ: waiting for messages in the queue | 2,374 | 100.00 | 11,632 | 4900 | 0.00 |
| PX Idle Wait | 3,394 | 77.31 | 5,634 | 1660 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 1,645 | 31.31 | 3,518 | 2139 | 0.00 |
| PL/SQL lock timer | 272 | 100.00 | 2,993 | 11005 | 0.00 |
| jobq slave wait | 706 | 91.64 | 2,014 | 2852 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 754 | 49.47 | 1,337 | 1773 | 0.00 |
| PX Deq: Execution Msg | 12,643 | 0.00 | 137 | 11 | 0.01 |
| PX Deq: Msg Fragment | 9,038 | 0.00 | 9 | 1 | 0.01 |
| PX Deq: Table Q Normal | 8,411 | 0.00 | 5 | 1 | 0.01 |
| PX Deq: Execute Reply | 4,910 | 0.02 | 5 | 1 | 0.00 |
| PX Deq Credit: need buffer | 3,365 | 0.00 | 4 | 1 | 0.00 |
| PX Deq: Join ACK | 614 | 0.00 | 1 | 1 | 0.00 |
| PX Deq: Parse Reply | 333 | 0.00 | 0 | 1 | 0.00 |
| class slave wait | 2 | 0.00 | 0 | 3 | 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 | 924,745 | 0.00 | 542 | 1 | 0.74 |
| db file parallel write | 133,975 | 0.00 | 147 | 1 | 0.11 |
| events in waitclass Other | 59,304 | 0.00 | 7 | 0 | 0.05 |
| os thread startup | 59 | 0.00 | 6 | 110 | 0.00 |
| control file sequential read | 815 | 0.00 | 5 | 7 | 0.00 |
| db file scattered read | 1,298 | 0.00 | 5 | 4 | 0.00 |
| control file parallel write | 1,723 | 0.00 | 4 | 2 | 0.00 |
| db file sequential read | 1,127 | 0.00 | 3 | 3 | 0.00 |
| latch: redo writing | 127 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 36 | 0.00 | 0 | 0 | 0.00 |
| direct path read | 608 | 0.00 | 0 | 0 | 0.00 |
| log file sync | 3 | 0.00 | 0 | 2 | 0.00 |
| direct path write | 333 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache lock | 3 | 0.00 | 0 | 0 | 0.00 |
| buffer busy waits | 41 | 0.00 | 0 | 0 | 0.00 |
| latch: shared pool | 1 | 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 | 2,598,910 | 0.40 | 35,894 | 14 | 2.09 |
| Streams AQ: qmn slave idle wait | 1,608 | 0.00 | 8,550 | 5317 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 1,645 | 31.31 | 3,518 | 2139 | 0.00 |
| smon timer | 129,530 | 0.00 | 3,466 | 27 | 0.10 |
| pmon timer | 1,365 | 86.74 | 3,436 | 2517 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 754 | 49.47 | 1,337 | 1773 | 0.00 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
| Statistic | Total |
|---|
| AVG_BUSY_TIME | 187,751 |
| AVG_IDLE_TIME | 172,880 |
| AVG_IOWAIT_TIME | 7,391 |
| AVG_SYS_TIME | 12,994 |
| AVG_USER_TIME | 174,647 |
| BUSY_TIME | 4,508,878 |
| IDLE_TIME | 4,151,938 |
| IOWAIT_TIME | 180,067 |
| SYS_TIME | 314,552 |
| USER_TIME | 4,194,326 |
| LOAD | 0 |
| OS_CPU_WAIT_TIME | 1,167,454,200 |
| RSRC_MGR_CPU_WAIT_TIME | 0 |
| VM_IN_BYTES | 4,481,040 |
| VM_OUT_BYTES | 0 |
| PHYSICAL_MEMORY_BYTES | ############### |
| NUM_CPUS | 24 |
| NUM_CPU_SOCKETS | 24 |
Back to Wait Events Statistics
Back to Top
Service Statistics
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
|---|
| SYS$USERS | 43,864.40 | 40,493.60 | 548,769 | 2,082,617,858 |
| SYS$BACKGROUND | 0.00 | 0.00 | 6,722 | 1,750,520 |
| 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 |
428992 | 199575 | 3255421 | 57783 | 0 | 0 | 55841824 | 62679 |
| SYS$BACKGROUND |
3370 | 802 | 142 | 651 | 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 |
|---|
| 4,106 | 4,077 | 8 | 513.22 | 9.36 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 2,293 | 2,292 | 10 | 229.30 | 5.23 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 1,673 | 1,636 | 12 | 139.41 | 3.81 | 1g4jfpxpupdt6 |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 1,415 | 1,414 | 299 | 4.73 | 3.23 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 1,143 | 1,106 | 152,843 | 0.01 | 2.61 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 1,103 | 1,069 | 16 | 68.91 | 2.51 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 828 | 824 | 156,128 | 0.01 | 1.89 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 817 | 805 | 1,446 | 0.57 | 1.86 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 788 | 756 | 112,898 | 0.01 | 1.80 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 739 | 705 | 64,033 | 0.01 | 1.69 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 551 | 527 | 57,230 | 0.01 | 1.26 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 549 | 517 | 57,210 | 0.01 | 1.25 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 546 | 545 | 374,382 | 0.00 | 1.25 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 534 | 533 | 984 | 0.54 | 1.22 | 0qcpgw43yqj5r |
WSHPSRS
|
( SELECT DISTINCT WDD.SOURCE_L... |
| 527 | 517 | 6,015 | 0.09 | 1.20 | a957tvxz9w038 |
icx.por.req.server.RequisitionAM
|
BEGIN :1 := por_util_pkg.inter... |
| 475 | 457 | 57,230 | 0.01 | 1.08 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 473 | 432 | 5,000 | 0.09 | 1.08 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 452 | 451 | 11 | 41.06 | 1.03 | 1du9v021t8m46 |
ARGLTP
|
insert into gl_interface(creat... |
| 451 | 407 | 205,543 | 0.00 | 1.03 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 451 | 444 | 292,904 | 0.00 | 1.03 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
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 |
|---|
| 4,077 | 4,106 | 8 | 509.62 | 9.36 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 2,292 | 2,293 | 10 | 229.24 | 5.23 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 1,636 | 1,673 | 12 | 136.37 | 3.81 | 1g4jfpxpupdt6 |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 1,414 | 1,415 | 299 | 4.73 | 3.23 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 1,106 | 1,143 | 152,843 | 0.01 | 2.61 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 1,069 | 1,103 | 16 | 66.84 | 2.51 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 824 | 828 | 156,128 | 0.01 | 1.89 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 805 | 817 | 1,446 | 0.56 | 1.86 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 756 | 788 | 112,898 | 0.01 | 1.80 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 705 | 739 | 64,033 | 0.01 | 1.69 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 545 | 546 | 374,382 | 0.00 | 1.25 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 533 | 534 | 984 | 0.54 | 1.22 | 0qcpgw43yqj5r |
WSHPSRS
|
( SELECT DISTINCT WDD.SOURCE_L... |
| 527 | 551 | 57,230 | 0.01 | 1.26 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 517 | 527 | 6,015 | 0.09 | 1.20 | a957tvxz9w038 |
icx.por.req.server.RequisitionAM
|
BEGIN :1 := por_util_pkg.inter... |
| 517 | 549 | 57,210 | 0.01 | 1.25 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 457 | 475 | 57,230 | 0.01 | 1.08 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 451 | 452 | 11 | 41.04 | 1.03 | 1du9v021t8m46 |
ARGLTP
|
insert into gl_interface(creat... |
| 444 | 451 | 292,904 | 0.00 | 1.03 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 432 | 473 | 5,000 | 0.09 | 1.08 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 407 | 451 | 205,543 | 0.00 | 1.03 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
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: 2,084,268,988
- Captured SQL account for 22.1% of Total
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 282,649,243 | 8 | 35,331,155.38 | 13.56 | 4076.97 | 4105.74 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 170,578,875 | 10 | 17,057,887.50 | 8.18 | 2292.38 | 2293.02 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 147,890,063 | 12 | 12,324,171.92 | 7.10 | 1636.43 | 1672.95 | 1g4jfpxpupdt6 |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 112,125,556 | 16 | 7,007,847.25 | 5.38 | 1069.47 | 1102.58 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 82,394,152 | 984 | 83,733.89 | 3.95 | 532.78 | 533.68 | 0qcpgw43yqj5r |
WSHPSRS
|
( SELECT DISTINCT WDD.SOURCE_L... |
| 48,660,453 | 1,446 | 33,651.77 | 2.33 | 805.42 | 817.17 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 48,155,508 | 11 | 4,377,773.45 | 2.31 | 451.49 | 451.71 | 1du9v021t8m46 |
ARGLTP
|
insert into gl_interface(creat... |
| 48,132,541 | 299 | 160,978.40 | 2.31 | 1413.75 | 1414.98 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 46,888,601 | 64,033 | 732.26 | 2.25 | 704.81 | 739.24 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 40,136,637 | 1,592,991 | 25.20 | 1.93 | 332.31 | 350.89 | 66tmsr3446uqn |
OEXOETEL
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 39,426,070 | 57,210 | 689.15 | 1.89 | 516.55 | 549.19 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 38,859,750 | 11 | 3,532,704.55 | 1.86 | 312.02 | 312.02 | bp8crdjba8zgt |
ARGLTP
|
update ra_cust_trx_line_gl_dis... |
| 38,137,050 | 57,230 | 666.38 | 1.83 | 457.08 | 474.84 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 36,867,845 | 5,000 | 7,373.57 | 1.77 | 432.14 | 473.49 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 33,039,573 | 173,995 | 189.89 | 1.59 | 399.49 | 430.24 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 33,035,427 | 173,995 | 189.86 | 1.58 | 384.53 | 415.13 | gf1u933c95jb5 |
INVTTMTX
|
DECLARE
l_ret_stat varchar2... |
| 31,281,507 | 57,230 | 546.59 | 1.50 | 527.24 | 551.20 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 30,800,765 | 9,061,718 | 3.40 | 1.48 | 271.21 | 278.65 | c4y7jp0q2awbf |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_VALUE FR... |
| 30,461,624 | 152,843 | 199.30 | 1.46 | 1106.05 | 1143.26 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 29,948,189 | 9,075 | 3,300.08 | 1.44 | 310.89 | 311.19 | by0sg8ccaazuk |
OEXOETEL
|
UPDATE MRP_ATP_SCHEDULE_TEMP S... |
| 26,379,689 | 10,000 | 2,637.97 | 1.27 | 199.50 | 369.26 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 24,825,531 | 205,543 | 120.78 | 1.19 | 407.41 | 451.31 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 21,391,043 | 156,147 | 136.99 | 1.03 | 336.38 | 336.45 | bcym7s1bp0wxs |
OEXOETEL
|
SELECT WIA.NAME FROM WF_ITEM_A... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 555,188
- Captured SQL account for 10.3% of Total
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 54,451 | 10,000 | 5.45 | 9.81 | 199.50 | 369.26 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 36,147 | 21,635 | 1.67 | 6.51 | 241.48 | 403.63 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 11,456 | 205,543 | 0.06 | 2.06 | 407.41 | 451.31 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 2,236 | 12 | 186.33 | 0.40 | 1636.43 | 1672.95 | 1g4jfpxpupdt6 |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 1,212 | 173,995 | 0.01 | 0.22 | 102.54 | 106.44 | 25bkagv1j2xf7 |
INVTTMTX
|
INSERT INTO MTL_MATERIAL_TRAN... |
| 858 | 299 | 2.87 | 0.15 | 1413.75 | 1414.98 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 663 | 8 | 82.88 | 0.12 | 3.84 | 5.77 | 6djyj1t4djs12 |
RAXMTR
|
select /*+ parallel(t, 16) par... |
| 641 | 64,033 | 0.01 | 0.12 | 704.81 | 739.24 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 522 | 8 | 65.25 | 0.09 | 4076.97 | 4105.74 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 261 | 152,843 | 0.00 | 0.05 | 1106.05 | 1143.26 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 120,618,792
- Captured SQL account for 29.1% of Total
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 9,061,718 | 3,622,706 | 0.40 | 0.00 | 0.00 | c4y7jp0q2awbf |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_VALUE FR... |
| 7,378,622 | 5,990,697 | 0.81 | 0.00 | 0.00 | 6cjfxb1c4kx16 |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_ID, APP... |
| 3,018,708 | 3,018,500 | 1.00 | 0.00 | 0.00 | bc7t6t6jfx2n7 |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT VERSION FROM FND_CACHE_... |
| 2,817,687 | 2,817,542 | 1.00 | 0.00 | 0.00 | 9dvfguzd15kpv |
JDBC Thin Client
|
SELECT VALUE FROM V$NLS_PARAME... |
| 1,592,991 | 823,344 | 0.52 | 0.00 | 0.00 | 66tmsr3446uqn |
OEXOETEL
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 780,657 | 377,936 | 0.48 | 0.00 | 0.00 | 4g5vzcyf68n9w |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_VALUE FR... |
| 637,675 | 274,474 | 0.43 | 0.00 | 0.00 | 0wrz2kbatczjk |
CSCCCCRC
|
SELECT EXECUTE_FLAG FROM JTF_U... |
| 596,235 | 596,215 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 504,444 | 504,437 | 1.00 | 0.00 | 0.00 | 0w785m9gmw41a |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT USERENV('SESSIONID') FR... |
| 503,122 | 295,353 | 0.59 | 0.00 | 0.00 | 5as61q63aqmts |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT A.APPLICATION_SHORT_NAM... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 17,935,494
- Captured SQL account for 41.7% of Total
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 599,906 | 7,378,622 | 3.34 | 6cjfxb1c4kx16 |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_ID, APP... |
| 596,218 | 596,235 | 3.32 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 554,443 | 9,061,718 | 3.09 | c4y7jp0q2awbf |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_VALUE FR... |
| 374,377 | 374,382 | 2.09 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 346,937 | 346,944 | 1.93 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 301,279 | 504,444 | 1.68 | 0w785m9gmw41a |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT USERENV('SESSIONID') FR... |
| 299,948 | 503,120 | 1.67 | 29x3dahwzdj8b |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT U.USER_NAME, NVL(U.EMP... |
| 299,948 | 503,122 | 1.67 | 5as61q63aqmts |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT A.APPLICATION_SHORT_NAM... |
| 299,948 | 3,018,708 | 1.67 | bc7t6t6jfx2n7 |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT VERSION FROM FND_CACHE_... |
| 299,947 | 503,118 | 1.67 | 95pbs94n69z3d |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT NVL(MULTI_ORG_FLAG, 'N... |
| 299,944 | 299,949 | 1.67 | fhqzxap2n0ybj |
? @blade1.ebs.hp.com (TNS V1-V3)
|
select NAME from HR_OPERATING_... |
| 299,942 | 503,106 | 1.67 | bvyqm6268u2as |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT NODE_NAME FROM FND_NODE... |
| 289,434 | 289,436 | 1.61 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
| 205,543 | 205,543 | 1.15 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
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 |
|---|
| 11,605,288 | 8 | 0.36 | b3an778qn1q49 |
RAXMTR
|
select /*+ parallel(t, 16) par... |
| 9,221,664 | 8 | 0.29 | 610p9aymv2pcv |
RAXMTR
|
select /*+ parallel(t, 16) par... |
| 3,405,177 | 8 | 0.11 | 6djyj1t4djs12 |
RAXMTR
|
select /*+ parallel(t, 16) par... |
| 1,877,555 | 7,200 | 0.06 | 8ay7m8qubw98j |
POXBWVRP
|
select * from PO_TAX_LINES_SUM... |
Back to SQL Statistics
Back to Top
|
SQL ordered by Version Count
No data exists for this section of the report.
Back to SQL Statistics
Back to Top
Complete List of SQL Text
| SQL Id | SQL Text |
|---|
| 0qcpgw43yqj5r |
( SELECT DISTINCT WDD.SOURCE_LINE_ID, WDD.SOURCE_HEADER_ID, WDD.ORGANIZATION_ID, WDD.INVENTORY_ITEM_ID, WDD.MOVE_ORDER_LINE_ID, WDD.DELIVERY_DETAIL_ID, WDD.SHIP_MODEL_COMPLETE_FLAG, WDD.TOP_MODEL_LINE_ID, WDD.SHIP_FROM_LOCATION_ID, NULL SHIP_METHOD_CODE, WDD.SHIPMENT_PRIORITY_CODE, WDD.DATE_SCHEDULED DATE_SCHEDULED, WDD.REQUESTED_QUANTITY, WDD.REQUESTED_QUANTITY_UOM, WDD.PREFERRED_GRADE, WDD.REQUESTED_QUANTITY2, WDD.REQUESTED_QUANTITY_UOM2, WDD.PROJECT_ID, WDD.TASK_ID, WDD.SUBINVENTORY FROM_SUBINVENTORY_CODE, WDD.SUBINVENTORY TO_SUBINVENTORY_CODE, WDD.RELEASED_STATUS RELEASED_STATUS, WDD.SHIP_SET_ID SHIP_SET_ID, WDD.SOURCE_CODE SOURCE_CODE, WDD.SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER, NULL PLANNED_DEPARTURE_DATE, WDA.DELIVERY_ID, OL.END_ITEM_UNIT_NUMBER, OL.SOURCE_DOCUMENT_TYPE_ID, MSI.RESERVABLE_TYPE, WDD.LAST_UPDATE_DATE, -1 DEMAND_SOURCE_HEADER_ID, -1 OUTSTANDING_ORDER_VALUE FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA, OE_ORDER_LINES_ALL OL, MTL_SYSTEM_ITEMS MSI , MTL_CATEGORY_SETS MCS,
MTL_ITEM_CATEGORIES MIC WHERE WDD.DATE_SCHEDULED IS NOT NULL AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND NVL(WDD.REQUESTED_QUANTITY, 0) > 0 AND WDD.SOURCE_LINE_ID = OL.LINE_ID AND WDD.SOURCE_CODE = 'OE' AND WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND WDD.ORGANIZATION_ID = MSI.ORGA
NIZATION_ID AND WDD.RELEASED_STATUS IN ( 'R', 'X') AND WDD.SHIP_FROM_LOCATION_ID = :X_ship_from_loc_id AND WDD.ORGANIZATION_ID = :X_org_id AND (WDA.DELIVERY_ID IS NULL ) AND (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'N' OR (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'Y' AND EXISTS ( SELECT 1 FROM WSH_NEW_DELIVERIES WDE1
WHERE WDE1.DELIVERY_ID = WDA.DELIVERY_ID
AND ( NVL(WDE1.PLANNED_FLAG, 'N') IN ('Y', 'F' ) )) )) AND MCS.category_set_id = MIC.category_set_id AND MCS.category_set_id = :x_CategorySetID AND MIC.category_id = :x_CategoryID AND MIC.organization_id = WDD.organization_id AND MIC.inventory_item_id = WDD.inventory_item_id ) ORDER BY WDD.INVENTORY_ITEM_ID, DATE_SCHEDULED ASC, SHIPMENT_PRIORITY_CODE ASC, to_number(SOURCE_HEADER_NUMBER) ASC, SHIP_FROM_LOCATION_ID |
| 0w785m9gmw41a | SELECT USERENV('SESSIONID') FROM SYS.DUAL |
| 0wrz2kbatczjk | SELECT EXECUTE_FLAG FROM JTF_USER_HOOKS WHERE PKG_NAME = :B4 AND API_NAME = :B3 AND PROCESSING_TYPE = :B2 AND USER_HOOK_TYPE = :B1 |
| 0z318y6g3uagc | declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ; |
| 1du9v021t8m46 |
insert into gl_interface(created_by, date_created, status, actual_flag, group_id, set_of_books_id, user_je_source_name, user_je_category_name, accounting_date, subledger_doc_sequence_id, subledger_doc_sequence_value, ussgl_transaction_code, currency_code, code_combination_id, entered_dr, entered_cr, accounted_dr, accounted_cr, reference1, reference10, reference21, reference22, reference23, reference24, reference25, reference26, reference27, reference28, reference29, reference30, request_id)select /*+ ORDERED USE_NL (l ctlgd ct ctt cust) INDEX (ctlgd, RA_CUST_TRX_LINE_GL_DIST_N5) +*/ :b0 created_by , trunc(sysdate ) date_created , :b1 status , :b2 actual_flag , :b3 group_id , :b4 sob_id , :b5 source_name , decode(ctt.type, 'CM', :b6, 'DM', :b7, 'CB', :b8, :b9) category , ctlgd.gl_date gl_date , ct.doc_sequence_id doc_seqid , ct.doc_sequence_value doc_num , ctlgd.ussgl_transaction_code ussgl , ct.invoice_currency_code currency , ctlgd.code_combination_id ccid , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null )) entered_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), decode(sign(nvl(ctlgd.amount
, 0)), (-1), null , nvl(ctlgd.amount, 0))) entered_cr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null )) acctd_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0))) acctd_cr , (:b10||to_char(:b3)) ref1 , decode(:b12, 'Y', null , ((((((l.meaning||' ')||:b13)||decode(ctt.type, 'CB', :b14, 'CM', :b15, 'DEP', :b16, 'DM', :b17, 'GUAR', :b18, 'INV', :b19, null ))||' ')||ct.trx_number)||:b20)) ref10 , to_char(:b3) ref21 , to_char(ct.customer_trx_id) ref22 , to_char(ctlgd.cust_trx_line_gl_dist_id) ref23 , ct.trx_number ref24 , cust.account_number ref25 , 'CUSTOMER' ref26 , to_char(ct.bill_to_customer_id) ref27 , decode(ctt.type, 'CM', 'CM', 'DM', 'DM', 'CB', 'CB', 'INV') ref28 , (decode(ctt.type, 'CM', 'CM_', 'DM', 'DM_', 'CB', 'CB_', 'INV_')||ctlgd.account_class) ref29 , 'RA_CUST_TRX_LINE_GL_DIST' ref30 , :b22 from ra_cust_trx_line_gl_dist ctlgd , ra_cust_trx_line_gl_dist rec , ar_lookups l , ra_customer_trx ct , ra_cust_trx_types ctt , hz_cust_accounts cust where ((((((((((((((((ctlgd.cust_trx_line_gl_dist_id+0)<:
b23 and ctlgd.gl_date between to_date((:b24||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b25||' 23:59:59'), 'DD-MON-RR HH24:MI:SS')) and ctlgd.posting_control_id=(-3)) and ctlgd.set_of_books_id=:b4) and ctlgd.account_set_flag='N') and ctlgd.customer_trx_id=ct.customer_trx_id) and l.lookup_type='AUTOGL_TYPE') and l.lookup_code=nvl(ctlgd.account_class, 'REV')) and ct.complete_flag='Y') and ct.bill_to_customer_id=cust.cust_account_id) and ct.cust_trx_type_id=ctt.cust_trx_type_id) and ctlgd.customer_trx_id=rec.customer_trx_id) and rec.account_class='REC') and rec.latest_rec_flag='Y') and rec.account_set_flag='N') and 'NOT_MFAR_TYPE'=AR_MFAR_PKG.ar_mfar_trx_post(ctlgd.customer_trx_id, :b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b12, :b13, :b20, :b14, :b15, :b17, :b16, :b18, :b19, :b24, :b25, :b23)) |
| 1g4jfpxpupdt6 | BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12); END; |
| 1q78dwnrrkf6c | BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END; |
| 25bkagv1j2xf7 |
INSERT INTO MTL_MATERIAL_TRANSACTIONS (
TRANSACTION_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_ID,
PROGRAM_APPLICATION_ID,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
SUBINVENTORY_CODE,
LOCATOR_ID,
REVISION,
TRANSACTION_TYPE_ID,
TRANSACTION_ACTION_ID,
TRANSACTION_SOURCE_TYPE_ID,
TRANSACTION_SOURCE_ID,
TRANSACTION_SOURCE_NAME,
TRANSACTION_QUANTITY,
TRANSACTION_UOM,
PRIMARY_QUANTITY,
TRANSACTION_DATE,
TRANSACTION_COST,
ACTUAL_COST,
PRIOR_COST,
NEW_COST,
QUANTITY_ADJUSTED,
VARIANCE_AMOUNT,
TRANSFER_COST,
TRANSPORTATION_COST,
TRANSFER_TRANSACTION_ID,
TRANSFER_ORGANIZATION_ID,
TRANSFER_SUBINVENTORY,
TRANSFER_LOCATOR_ID ,
ACCT_PERIOD_ID,
TRANSACTION_REFERENCE,
REASON_ID,
REPETITIVE_LINE_ID,
DEPARTMENT_ID,
OPERATION_SEQ_NUM,
SHIPMENT_NUMBER,
FREIGHT_CODE,
WAYBILL_AIRBILL,
TRX_SOURCE_LINE_ID,
MOVE_ORDER_LINE_ID ,
COSTED_FLAG ,
INVOICED_FLAG ,
DISTRIBUTION_ACCOUNT_ID ,
ENCUMBRANCE_ACCOUNT ,
ENCUMBRANCE_A
MOUNT ,
COST_UPDATE_ID ,
PROJECT_ID ,
TASK_ID ,
TO_PROJECT_ID ,
TO_TASK_ID ,
LPN_ID , TRANSFER_LPN_ID,
CONTENT_LPN_ID ,
PUT_AWAY_STRATEGY_ID ,
PUT_AWAY_RULE_ID ,
PICK_STRATEGY_ID ,
PICK_RULE_ID ,
CREATED_BY ,
COST_GROUP_ID ,
TRANSFER_COST_GROUP_ID ,
TRANSACTION_SET_ID ,
PM_COST_COLLECTED ,
COST_CATEGORY_ID ,
ORGANIZATION_TYPE ,
TRANSFER_ORGANIZATION_TYPE ,
OWNING_ORGANIZATION_ID ,
OWNING_TP_TYPE ,
PLANNING_ORGANIZATION_ID ,
PLANNING_TP_TYPE ,
XFR_OWNING_ORGANIZATION_ID ,
TRANSFER_OWNING_TP_TYPE ,
XFR_PLANNING_ORGANIZATION_ID ,
TRANSFER_PLANNING_TP_TYPE ,
SECONDARY_TRANSACTION_QUANTITY ,
SECONDARY_UOM_CODE,
PICK_SLIP_NUMBER,
PICKING_LINE_ID,
VENDOR_LOT_NUMBER,
SOURCE_CODE,
SOURCE_LINE_ID,
MOVE_TRANSACTION_ID,
RCV_TRANSACTION_ID,
COMPLETION_TRANSACTION_ID,
CURRENCY_CODE,
CURRENCY_CONVERSION_RATE,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_TYPE,
MATERIAL_ACCOUNT,
MATERIAL_OVERHEAD_ACCOUNT,
RESOURCE_ACCOUNT,
OUTSIDE_PROCESSING_ACCOUNT,
OVERHEAD_ACCOUNT,
MOV
EMENT_ID,
SOURCE_PROJECT_ID,
SOURCE_TASK_ID,
PA_EXPENDITURE_ORG_ID,
EXPENDITURE_TYPE,
TRANSFER_PERCENTAGE,
ORG_COST_GROUP_ID,
COST_TYPE_ID,
VALUE_CHANGE,
PERCENTAGE_CHANGE,
EMPLOYEE_CODE,
MASTER_SCHEDULE_UPDATE_CODE,
TRX_SOURCE_DELIVERY_ID,
RECEIVING_DOCUMENT,
TRANSPORTATION_DIST_ACCOUNT,
NUMBER_OF_CONTAINERS,
RMA_LINE_ID,
CYCLE_COUNT_ID,
PHYSICAL_ADJUSTMENT_ID,
FLOW_SCHEDULE,
FINAL_COMPLETION_FLAG,
QA_COLLECTION_ID,
OVERCOMPLETION_TRANSACTION_QTY,
OVERCOMPLETION_PRIMARY_QTY,
OVERCOMPLETION_TRANSACTION_ID,
COMMON_BOM_SEQ_ID,
COMMON_ROUTING_SEQ_ID,
MVT_STAT_STATUS,
PICK_SLIP_DATE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
SHIP_TO_LOCATION_ID,
TRANSACTION_MODE,
TRANSACTION_BATCH_ID,
TRANSACTION_BATCH_SEQ,
FOB_POINT,
INTRANSIT_ACCOUNT,
TRX_FLOW_HEADER_ID,
L
OGICAL_TRX_TYPE_CODE,
ORIGINAL_TRANSACTION_TEMP_ID,
SHORTAGE_PROCESS_CODE)
VALUES(:1, SYSDATE, :2, SYSDATE, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, ROUND(:17, 5), :18, ROUND(:19, 5), nvl(:20, sysdate), :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, 'N', 'N', :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, 'NEW', :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147) |
| 29x3dahwzdj8b | SELECT U.USER_NAME, NVL(U.EMPLOYEE_ID, -1), NVL(U.CUSTOMER_ID, -1), NVL(U.SUPPLIER_ID, -1), NVL(U.PERSON_PARTY_ID, -1) FROM FND_USER U WHERE U.USER_ID = :B1 |
| 2fjd6cndjby9p |
INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID ) SELECT /*+ ORDERED */ ASS.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_ID, DIST.CODE_COMBINATION_ID, :B12 , ASS.ACCOUNT_CLASS, 'N', ROUND( (DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1 ), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1 ) ), ASS.AMOUNT ), FC.PRECISION), ROUND( ((DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1) ), ASS.AMOUNT) ) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT) / DECODE(LINES.EXTENDED_AMOUNT, 0, 1, LINES.EXTENDED_AMOUNT)) * DECODE(ASS.AMOUNT, 0, 0, 100), 4), DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), DECODE(:B10 , NULL, ROUND( NVL(HEADER.EXCHANGE_
RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ), :B11 ), ROUND( ( NVL(HEADER.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ( (DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) ) / :B10 ) * :B10 ), DECODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_DATE(ASS.GL_DATE) ), DECODE(DIST.CUSTOMER_TRX_ID, HEADER.CUSTOMER_TRX_ID, DIST.CUST_TRX_LINE_SALESREP_ID, CMSREP.CUST_TRX_LINE_SALESREP_ID), :B9 , :B8 , :B7 , SYSDATE, SYSDATE, :B6 , SYSDATE, :B6 , -3, ASS.GL_DATE, RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES FC, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE, RA_CUST_TRX_LINE_GL_DIST REC, RA_CUST_TRX_LINE_GL_DIST DIST, RA_CUST_TRX_LINE_SALESREPS CMSREP, AR_REVENUE_ASSIGNMENTS ASS WHERE HEADER.CUSTOMER_TRX_ID = :B1 AND HEADER.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = HEADER.INVOICE_CURRENCY_CODE AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINES.AUTORULE_COMPLETE_FLAG||'' = 'N' AND ASS.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND ASS.PERIOD_SET_NAME = :B5 AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID AND DECODE(HEADER.INVOICING_RULE_ID, -3, :B3 , DECODE(NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), 'Y',
:B2 , DECODE(:B4 , 'N', :B3 , DECODE(HEADER.PREVIOUS_CUSTOMER_TRX_ID, NULL, AR_REVENUE_MANAGEMENT_PVT.LINE_COLLECTIBILITY(:B1 , LINES.CUSTOMER_TRX_LINE_ID), AR_REVENUE_MANAGEMENT_PVT.CASH_BASED(HEADER.PREVIOUS_CUSTOMER_TRX_ID))))) <> :B2 AND REC.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND DIST.CUSTOMER_TRX_LINE_ID = (SELECT DECODE(COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_LINE_ID), LINES.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' AND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND DIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND DIST.ACCOUNT_SET_FLAG = 'Y' AND DIST.CUST_TRX_LINE_SALESREP_ID = CMSREP.PREV_CUST_TRX_LINE_SALESREP_ID (+) AND :B1 = CMSREP.CUSTOMER_TRX_ID (+) AND NOT EXISTS ( SELECT 'distribution exists' FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST WHERE SUBDIST.CUSTOMER_TRX_LINE_ID = ASS.CUSTOMER_TRX_LINE_ID AND SUBDIST.CUSTOMER_TRX_ID + 0 = LINES.CUSTOMER_TRX_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND SUBDIST.ORIGINAL_GL_DATE = ASS.GL_DATE ) |
| 3b3psftuyks81 | BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END; |
| 3prk3vg9u0abb | BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END; |
| 473dq7tb653mp | declare p varchar2(32767); begin p := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); :v1 := substr(p, 1, 4000); :v2 := substr(p, 4001, 4000); :v3 := substr(p, 8001, 4000); :v4 := substr(p, 12001, 4000); :v5 := substr(p, 16001, 4000); :v6 := substr(p, 20001, 4000); :v7 := substr(p, 24001, 4000); :v8 := substr(p, 28001, 4000); :v9 := substr(p, 32001, 767); :v10 := substr(p, 4001, 1); :v11 := substr(p, 8001, 1); :v12 := substr(p, 12001, 1); :v13 := substr(p, 16001, 1); :v14 := substr(p, 20001, 1); :v15 := substr(p, 24001, 1); :v16 := substr(p, 28001, 1); :v17 := substr(p, 32001, 1); end; |
| 4dqasqjrvudqn | begin dbms_session.reset_package; end; |
| 4g5vzcyf68n9w | SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 |
| 4yak7x2zqz0dh | BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END; |
| 5as61q63aqmts | SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE A.APPLICATION_ID = :B1 |
| 610p9aymv2pcv |
select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("COMMENTS"), count(distinct "COMMENTS"), sum(sys_op_opnsize("COMMENTS")), substrb(dump(min(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), count("INTERNAL_NOTES"), count(distinct "INTERNAL_NOTES"), sum(sys_op_opnsize("INTERNAL_NOTES")), substrb(dump(min(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), count("INITIAL_CUSTOMER_TRX_ID"), count(distinct "INITIAL_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("INITIAL_CUSTOMER_TRX_ID")), substrb(dump(min("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE_CONTEXT"), count(distinct "USSGL_TRANSACTION_CODE_CONTEXT"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE_CONTEXT")), substrb(dump(min("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE"), count(distinct "USSGL_TRANSACTION_CODE"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE")), substrb(dump(min("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), count("ACCTD_AMOUNT"), count(distinct "ACCTD_AMOUNT"), sum(sys_op_opnsize("ACCTD_AMOUNT")), su
bstrb(dump(min("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), count("CUSTOMER_BANK_ACCOUNT_ID"), count(distinct "CUSTOMER_BANK_ACCOUNT_ID"), sum(sys_op_opnsize("CUSTOMER_BANK_ACCOUNT_ID")), substrb(dump(min("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), count("CUSTOMER_BANK_ACCOUNT_NAME"), count(distinct "CUSTOMER_BANK_ACCOUNT_NAME"), sum(sys_op_opnsize("CUSTOMER_BANK_ACCOUNT_NAME")), substrb(dump(min(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), count("UOM_CODE"), count(distinct "UOM_CODE"), sum(sys_op_opnsize("UOM_CODE")), substrb(dump(min("UOM_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_CODE"), 16, 0, 32), 1, 120), count("UOM_NAME"), count(distinct "UOM_NAME"), sum(sys_op_opnsize("UOM_NAME")), substrb(dump(min("UOM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_NAME"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER_SEQUENCE_ID"), count(distinct "DOCUMENT_NUMBER_SEQUENCE_ID"), sum(sys_op_opnsize("DOCUMENT_NUMBER_SEQUENCE_ID")), substrb(dump(min("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE10"), count(distinct "LINK_TO_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE10")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32),
1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE11"), count(distinct "LINK_TO_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE11")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE12"), count(distinct "LINK_TO_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE12")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE13"), count(distinct "LINK_TO_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE13")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE14"), count(distinct "LINK_TO_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE14")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE15"), count(distinct "LINK_TO_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE15")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE8"), count(distinct "LINK_TO_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("LINK_TO_LINE_ATT
RIBUTE8")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE9"), count(distinct "LINK_TO_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE9")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE10"), count(distinct "REFERENCE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE10")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE11"), count(distinct "REFERENCE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE11")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE12"), count(distinct "REFERENCE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE12")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE13"), count(distinct "REFERENCE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE13")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("REFE
RENCE_LINE_ATTRIBUTE14"), count(distinct "REFERENCE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE14")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE15"), count(distinct "REFERENCE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE15")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE8"), count(distinct "REFERENCE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE8")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE9"), count(distinct "REFERENCE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE9")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE
_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE12"), count(distinct "INTERFACE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ID"), sum(sys_op_opnsize("INTERFACE_LINE_ID")), substrb(dump(min("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_CONTEXT"), count(distinct "INTERFACE_LINE_CONTEXT"), sum(sys_op_opnsize("INTERFACE_LINE_CONTEXT")), substrb(dump(min("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE1"), count(distinct "INTERFACE_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE1")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE2"), count(distinct "INTERFACE_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE2")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE3"), count(distinct "INTERFACE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE3")), substrb(du
mp(min("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE4"), count(distinct "INTERFACE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE4")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE5"), count(distinct "INTERFACE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE5")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE6"), count(distinct "INTERFACE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE6")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE7"), count(distinct "INTERFACE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE7")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE8"), count(distinct "INTERFACE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE8")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count(distinct "BATCH_SOURCE_NAME"), su
m(sys_op_opnsize("BATCH_SOURCE_NAME")), substrb(dump(min(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("SET_OF_BOOKS_ID"), count(distinct "SET_OF_BOOKS_ID"), sum(sys_op_opnsize("SET_OF_BOOKS_ID")), substrb(dump(min("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), count(distinct "LINE_TYPE"), sum(sys_op_opnsize("LINE_TYPE")), substrb(dump(min("LINE_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_TYPE"), 16, 0, 32), 1, 120), count(distinct "DESCRIPTION"), sum(sys_op_opnsize("DESCRIPTION")), substrb(dump(min(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count(distinct "CURRENCY_CODE"), sum(sys_op_opnsize("CURRENCY_CODE")), substrb(dump(min("CURRENCY_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("CURRENCY_CODE"), 16, 0, 32), 1, 120), count("AMOUNT"), count(distinct "AMOUNT"), sum(sys_op_opnsize("AMOUNT")), substrb(dump(min("AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT"), 16, 0, 32), 1, 120), count("CUST_TRX_TYPE_NAME"), count(distinct "CUST_TRX_TYPE_NAME"), sum(sys_op_opnsize("CUST_TRX_TYPE_NAME")), substrb(dump(min("CUST_TRX_TYPE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("CUST_TRX_TYPE_NAME"), 16, 0, 32), 1, 120), count("CUST_TRX_TYPE_ID"), count(distinct "CUST_TRX_TYPE_ID"), sum(sys_op_opnsize("CUST_TRX_TYPE_ID")), substrb(dump(min("CUST_TRX
_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUST_TRX_TYPE_ID"), 16, 0, 32), 1, 120), count("TERM_NAME"), count(distinct "TERM_NAME"), sum(sys_op_opnsize("TERM_NAME")), substrb(dump(min("TERM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("TERM_NAME"), 16, 0, 32), 1, 120), count("TERM_ID"), count(distinct "TERM_ID"), sum(sys_op_opnsize("TERM_ID")), substrb(dump(min("TERM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TERM_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BATCH_NAME"), count(distinct "ORIG_SYSTEM_BATCH_NAME"), sum(sys_op_opnsize("ORIG_SYSTEM_BATCH_NAME")), substrb(dump(min(substrb("ORIG_SYSTEM_BATCH_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BATCH_NAME", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_BILL_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_BILL_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_REF"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_REF")), substrb(dump(min(su
bstrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_REF"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_ID"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_SHIP_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_SHIP_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CUSTOMER_ID")), substrb(dump(min("
ORIG_SYSTEM_SHIP_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_ADDRESS_REF"), count(distinct "ORIG_SYSTEM_SHIP_ADDRESS_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_ADDRESS_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_SHIP_ADDRESS_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_ADDRESS_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CONTACT_REF"), count(distinct "ORIG_SYSTEM_SHIP_CONTACT_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CONTACT_ID"), count(distinct "ORIG_SYSTEM_SHIP_CONTACT_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_CONTACT_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SOLD_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_SOLD_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SOLD_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SOLD_CUSTOMER
_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SOLD_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_SOLD_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SOLD_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ID"), count(distinct "LINK_TO_LINE_ID"), sum(sys_op_opnsize("LINK_TO_LINE_ID")), substrb(dump(min("LINK_TO_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_CONTEXT"), count(distinct "LINK_TO_LINE_CONTEXT"), sum(sys_op_opnsize("LINK_TO_LINE_CONTEXT")), substrb(dump(min("LINK_TO_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE1"), count(distinct "LINK_TO_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE1")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE2"), count(distinct "LINK_TO_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE2")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE3"), count(distinct "LINK_TO_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE3
")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE4"), count(distinct "LINK_TO_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE4")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE5"), count(distinct "LINK_TO_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE5")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE6"), count(distinct "LINK_TO_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE6")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE7"), count(distinct "LINK_TO_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE7")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("RECEIPT_METHOD_NAME"), count(distinct "RECEIPT_METHOD_NAME"), sum(sys_op_opnsize("RECEIPT_METHOD_NAME")), substrb(dump(min("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), count("RECEIPT_METHOD_ID"), count(distinct "RECEIPT_METHOD_ID"), sum(sys_op_opnsize("RECEIPT_METHO
D_ID")), substrb(dump(min("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), count(distinct "CONVERSION_TYPE"), sum(sys_op_opnsize("CONVERSION_TYPE")), substrb(dump(min("CONVERSION_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_TYPE"), 16, 0, 32), 1, 120), count("CONVERSION_DATE"), count(distinct "CONVERSION_DATE"), substrb(dump(min("CONVERSION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_DATE"), 16, 0, 32), 1, 120), count("CONVERSION_RATE"), count(distinct "CONVERSION_RATE"), sum(sys_op_opnsize("CONVERSION_RATE")), substrb(dump(min("CONVERSION_RATE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_RATE"), 16, 0, 32), 1, 120), count("CUSTOMER_TRX_ID"), count(distinct "CUSTOMER_TRX_ID"), sum(sys_op_opnsize("CUSTOMER_TRX_ID")), substrb(dump(min("CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("TRX_DATE"), count(distinct "TRX_DATE"), substrb(dump(min("TRX_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("TRX_DATE"), 16, 0, 32), 1, 120), count("GL_DATE"), count(distinct "GL_DATE"), substrb(dump(min("GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("GL_DATE"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER"), count(distinct "DOCUMENT_NUMBER"), sum(sys_op_opnsize("DOCUMENT_NUMBER")), substrb(dump(min("DOCUMENT_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER"), 16, 0, 32), 1, 120), count("TRX_NUMBER"), count(distinct "TRX_NUMBER"), sum(sys
_op_opnsize("TRX_NUMBER")), substrb(dump(min("TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("TRX_NUMBER"), 16, 0, 32), 1, 120), count("LINE_NUMBER"), count(distinct "LINE_NUMBER"), sum(sys_op_opnsize("LINE_NUMBER")), substrb(dump(min("LINE_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_NUMBER"), 16, 0, 32), 1, 120), count("QUANTITY"), count(distinct "QUANTITY"), sum(sys_op_opnsize("QUANTITY")), substrb(dump(min("QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY"), 16, 0, 32), 1, 120), count("QUANTITY_ORDERED"), count(distinct "QUANTITY_ORDERED"), sum(sys_op_opnsize("QUANTITY_ORDERED")), substrb(dump(min("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), count("UNIT_SELLING_PRICE"), count(distinct "UNIT_SELLING_PRICE"), sum(sys_op_opnsize("UNIT_SELLING_PRICE")), substrb(dump(min("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), count("UNIT_STANDARD_PRICE"), count(distinct "UNIT_STANDARD_PRICE"), sum(sys_op_opnsize("UNIT_STANDARD_PRICE")), substrb(dump(min("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), count("PRINTING_OPTION"), count(distinct "PRINTING_OPTION"), sum(sys_op_opnsize("PRINTING_OPTION")), substrb(dump(min("PRINTING_OPTION"), 16, 0, 32), 1, 120), substrb(dump(max("PRINTING_OPTION"), 16, 0, 32), 1, 120), count("INTERFACE_STATUS"), count(distinct "INTERFACE_STATUS"), sum(sys_op_opnsi
ze("INTERFACE_STATUS")), substrb(dump(min("INTERFACE_STATUS"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_STATUS"), 16, 0, 32), 1, 120), count("REQUEST_ID"), count(distinct "REQUEST_ID"), sum(sys_op_opnsize("REQUEST_ID")), substrb(dump(min("REQUEST_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REQUEST_ID"), 16, 0, 32), 1, 120), count("RELATED_BATCH_SOURCE_NAME"), count(distinct "RELATED_BATCH_SOURCE_NAME"), sum(sys_op_opnsize("RELATED_BATCH_SOURCE_NAME")), substrb(dump(min(substrb("RELATED_BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("RELATED_BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("RELATED_TRX_NUMBER"), count(distinct "RELATED_TRX_NUMBER"), sum(sys_op_opnsize("RELATED_TRX_NUMBER")), substrb(dump(min("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), count("RELATED_CUSTOMER_TRX_ID"), count(distinct "RELATED_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("RELATED_CUSTOMER_TRX_ID")), substrb(dump(min("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("PREVIOUS_CUSTOMER_TRX_ID"), count(distinct "PREVIOUS_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("PREVIOUS_CUSTOMER_TRX_ID")), substrb(dump(min("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_ACCT_RULE"), count(distinct "CREDIT_METHOD_FOR_ACCT_RULE"), sum(sys_op_opnsize("CREDIT_MET
HOD_FOR_ACCT_RULE")), substrb(dump(min("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_INSTALLMENTS"), count(distinct "CREDIT_METHOD_FOR_INSTALLMENTS"), sum(sys_op_opnsize("CREDIT_METHOD_FOR_INSTALLMENTS")), substrb(dump(min("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 32), 1, 120), count("REASON_CODE"), count(distinct "REASON_CODE"), sum(sys_op_opnsize("REASON_CODE")), substrb(dump(min("REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_RATE"), count(distinct "TAX_RATE"), sum(sys_op_opnsize("TAX_RATE")), substrb(dump(min("TAX_RATE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_RATE"), 16, 0, 32), 1, 120), count("TAX_CODE"), count(distinct "TAX_CODE"), sum(sys_op_opnsize("TAX_CODE")), substrb(dump(min(substrb("TAX_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_CODE", 1, 32)), 16, 0, 32), 1, 120), count("TAX_PRECEDENCE"), count(distinct "TAX_PRECEDENCE"), sum(sys_op_opnsize("TAX_PRECEDENCE")), substrb(dump(min("TAX_PRECEDENCE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_PRECEDENCE"), 16, 0, 32), 1, 120), count("EXCEPTION_ID"), count(distinct "EXCEPTION_ID"), sum(sys_op_opnsize("EXCEPTION_ID")), substrb(dump(min("EXCEPTION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("EXCEPTION_ID"), 16, 0, 32), 1, 120), count("EXEMPTION_ID"), count(distinct "
EXEMPTION_ID"), sum(sys_op_opnsize("EXEMPTION_ID")), substrb(dump(min("EXEMPTION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("EXEMPTION_ID"), 16, 0, 32), 1, 120), count("SHIP_DATE_ACTUAL"), count(distinct "SHIP_DATE_ACTUAL"), substrb(dump(min("SHIP_DATE_ACTUAL"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_DATE_ACTUAL"), 16, 0, 32), 1, 120), count("FOB_POINT"), count(distinct "FOB_POINT"), sum(sys_op_opnsize("FOB_POINT")), substrb(dump(min("FOB_POINT"), 16, 0, 32), 1, 120), substrb(dump(max("FOB_POINT"), 16, 0, 32), 1, 120), count("SHIP_VIA"), count(distinct "SHIP_VIA"), sum(sys_op_opnsize("SHIP_VIA")), substrb(dump(min("SHIP_VIA"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_VIA"), 16, 0, 32), 1, 120), count("WAYBILL_NUMBER"), count(distinct "WAYBILL_NUMBER"), sum(sys_op_opnsize("WAYBILL_NUMBER")), substrb(dump(min(substrb("WAYBILL_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("WAYBILL_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("INVOICING_RULE_NAME"), count(distinct "INVOICING_RULE_NAME"), sum(sys_op_opnsize("INVOICING_RULE_NAME")), substrb(dump(min("INVOICING_RULE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICING_RULE_NAME"), 16, 0, 32), 1, 120), count("INVOICING_RULE_ID"), count(distinct "INVOICING_RULE_ID"), sum(sys_op_opnsize("INVOICING_RULE_ID")), substrb(dump(min("INVOICING_RULE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICING_RULE_ID"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_NAME"), count(distinct "ACCOUNTING_RULE_NAME"), sum(sys_
op_opnsize("ACCOUNTING_RULE_NAME")), substrb(dump(min("ACCOUNTING_RULE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_NAME"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_ID"), count(distinct "ACCOUNTING_RULE_ID"), sum(sys_op_opnsize("ACCOUNTING_RULE_ID")), substrb(dump(min("ACCOUNTING_RULE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_ID"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_DURATION"), count(distinct "ACCOUNTING_RULE_DURATION"), sum(sys_op_opnsize("ACCOUNTING_RULE_DURATION")), substrb(dump(min("ACCOUNTING_RULE_DURATION"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_DURATION"), 16, 0, 32), 1, 120), count("RULE_START_DATE"), count(distinct "RULE_START_DATE"), substrb(dump(min("RULE_START_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("RULE_START_DATE"), 16, 0, 32), 1, 120), count("PRIMARY_SALESREP_NUMBER"), count(distinct "PRIMARY_SALESREP_NUMBER"), sum(sys_op_opnsize("PRIMARY_SALESREP_NUMBER")), substrb(dump(min("PRIMARY_SALESREP_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("PRIMARY_SALESREP_NUMBER"), 16, 0, 32), 1, 120), count("PRIMARY_SALESREP_ID"), count(distinct "PRIMARY_SALESREP_ID"), sum(sys_op_opnsize("PRIMARY_SALESREP_ID")), substrb(dump(min("PRIMARY_SALESREP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PRIMARY_SALESREP_ID"), 16, 0, 32), 1, 120), count("SALES_ORDER"), count(distinct "SALES_ORDER"), sum(sys_op_opnsize("SALES_ORDER")), substrb(dump(min(substrb("SALES_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(
max(substrb("SALES_ORDER", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_LINE"), count(distinct "SALES_ORDER_LINE"), sum(sys_op_opnsize("SALES_ORDER_LINE")), substrb(dump(min("SALES_ORDER_LINE"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_LINE"), 16, 0, 32), 1, 120), count("SALES_ORDER_DATE"), count(distinct "SALES_ORDER_DATE"), substrb(dump(min("SALES_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_DATE"), 16, 0, 32), 1, 120), count("SALES_ORDER_SOURCE"), count(distinct "SALES_ORDER_SOURCE"), sum(sys_op_opnsize("SALES_ORDER_SOURCE")), substrb(dump(min(substrb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_REVISION"), count(distinct "SALES_ORDER_REVISION"), sum(sys_op_opnsize("SALES_ORDER_REVISION")), substrb(dump(min("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), count("PURCHASE_ORDER"), count(distinct "PURCHASE_ORDER"), sum(sys_op_opnsize("PURCHASE_ORDER")), substrb(dump(min(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), count("PURCHASE_ORDER_REVISION"), count(distinct "PURCHASE_ORDER_REVISION"), sum(sys_op_opnsize("PURCHASE_ORDER_REVISION")), substrb(dump(min(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), c
ount("PURCHASE_ORDER_DATE"), count(distinct "PURCHASE_ORDER_DATE"), substrb(dump(min("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), count("AGREEMENT_NAME"), count(distinct "AGREEMENT_NAME"), sum(sys_op_opnsize("AGREEMENT_NAME")), substrb(dump(min("AGREEMENT_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_NAME"), 16, 0, 32), 1, 120), count("AGREEMENT_ID"), count(distinct "AGREEMENT_ID"), sum(sys_op_opnsize("AGREEMENT_ID")), substrb(dump(min("AGREEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_ID"), 16, 0, 32), 1, 120), count("MEMO_LINE_NAME"), count(distinct "MEMO_LINE_NAME"), sum(sys_op_opnsize("MEMO_LINE_NAME")), substrb(dump(min(substrb("MEMO_LINE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MEMO_LINE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("MEMO_LINE_ID"), count(distinct "MEMO_LINE_ID"), sum(sys_op_opnsize("MEMO_LINE_ID")), substrb(dump(min("MEMO_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MEMO_LINE_ID"), 16, 0, 32), 1, 120), count("INVENTORY_ITEM_ID"), count(distinct "INVENTORY_ITEM_ID"), sum(sys_op_opnsize("INVENTORY_ITEM_ID")), substrb(dump(min("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG1"), count(distinct "MTL_SYSTEM_ITEMS_SEG1"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG1")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(subst
rb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG2"), count(distinct "MTL_SYSTEM_ITEMS_SEG2"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG2")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG3"), count(distinct "MTL_SYSTEM_ITEMS_SEG3"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG3")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG4"), count(distinct "MTL_SYSTEM_ITEMS_SEG4"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG4")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG5"), count(distinct "MTL_SYSTEM_ITEMS_SEG5"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG5")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG6"), count(distinct "MTL_SYSTEM_ITEMS_SEG6"), sum(sys_op_opnsize("?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? |
| 64qc329wgjv39 |
select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char
(PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc |
| 66tmsr3446uqn | SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1 |
| 6cjfxb1c4kx16 | SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, HIERARCHY_TYPE FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = UPPER(:B1 ) AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE |
| 6djyj1t4djs12 |
select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_SALESCREDIT_ID"), sum(sys_op_opnsize("INTERFACE_SALESCREDIT_ID")), substrb(dump(min("INTERFACE_SALESCREDIT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_SALESCREDIT_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ID"), count(distinct "INTERFACE_LINE_ID"), sum(sys_op_opnsize("INTERFACE_LINE_ID")), substrb(dump(min("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_CONTEXT"), count(distinct "INTERFACE_LINE_CONTEXT"), sum(sys_op_opnsize("INTERFACE_LINE_CONTEXT")), substrb(dump(min("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE1"), count(distinct "INTERFACE_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE1")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE2"), count(distinct "INTERFACE_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE2")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE3"), count(distinct "INTERFACE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIB
UTE3")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE4"), count(distinct "INTERFACE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE4")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE5"), count(distinct "INTERFACE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE5")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE6"), count(distinct "INTERFACE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE6")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE7"), count(distinct "INTERFACE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE7")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE8"), count(distinct "INTERFACE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE8")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("SALESREP_NUMB
ER"), count(distinct "SALESREP_NUMBER"), sum(sys_op_opnsize("SALESREP_NUMBER")), substrb(dump(min("SALESREP_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_NUMBER"), 16, 0, 32), 1, 120), count("SALESREP_ID"), count(distinct "SALESREP_ID"), sum(sys_op_opnsize("SALESREP_ID")), substrb(dump(min("SALESREP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_NAME"), count(distinct "SALES_CREDIT_TYPE_NAME"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_NAME")), substrb(dump(min("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_ID"), count(distinct "SALES_CREDIT_TYPE_ID"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_ID")), substrb(dump(min("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_AMOUNT_SPLIT"), count(distinct "SALES_CREDIT_AMOUNT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_AMOUNT_SPLIT")), substrb(dump(min("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), count("SALES_CREDIT_PERCENT_SPLIT"), count(distinct "SALES_CREDIT_PERCENT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_PERCENT_SPLIT")), substrb(dump(min("SALES_CREDIT_PERCENT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_PERCENT_SPLIT"), 16, 0, 32), 1, 120), count("INTERFACE_STATUS"), count(distinct "INTERFACE_STATUS"), sum(sys_op
_opnsize("INTERFACE_STATUS")), substrb(dump(min("INTERFACE_STATUS"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_STATUS"), 16, 0, 32), 1, 120), count("REQUEST_ID"), count(distinct "REQUEST_ID"), sum(sys_op_opnsize("REQUEST_ID")), substrb(dump(min("REQUEST_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REQUEST_ID"), 16, 0, 32), 1, 120), count("ATTRIBUTE_CATEGORY"), count(distinct "ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("ATTRIBUTE_CATEGORY")), substrb(dump(min("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("ATTRIBUTE1"), count(distinct "ATTRIBUTE1"), sum(sys_op_opnsize("ATTRIBUTE1")), substrb(dump(min(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE2"), count(distinct "ATTRIBUTE2"), sum(sys_op_opnsize("ATTRIBUTE2")), substrb(dump(min(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE3"), count(distinct "ATTRIBUTE3"), sum(sys_op_opnsize("ATTRIBUTE3")), substrb(dump(min(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE4"), count(distinct "ATTRIBUTE4"), sum(sys_op_opnsize("ATTRIBUTE4")), substrb(dump(min(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE5"), count(dist
inct "ATTRIBUTE5"), sum(sys_op_opnsize("ATTRIBUTE5")), substrb(dump(min(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE6"), count(distinct "ATTRIBUTE6"), sum(sys_op_opnsize("ATTRIBUTE6")), substrb(dump(min(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE7"), count(distinct "ATTRIBUTE7"), sum(sys_op_opnsize("ATTRIBUTE7")), substrb(dump(min(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE8"), count(distinct "ATTRIBUTE8"), sum(sys_op_opnsize("ATTRIBUTE8")), substrb(dump(min(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE9"), count(distinct "ATTRIBUTE9"), sum(sys_op_opnsize("ATTRIBUTE9")), substrb(dump(min(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE10"), count(distinct "ATTRIBUTE10"), sum(sys_op_opnsize("ATTRIBUTE10")), substrb(dump(min(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE11"), count(distinct "ATTRIBUTE11"), sum(sys_op_opnsize("ATTRIBUTE11")), substrb(dump(min(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substr
b("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE12"), count(distinct "ATTRIBUTE12"), sum(sys_op_opnsize("ATTRIBUTE12")), substrb(dump(min(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE13"), count(distinct "ATTRIBUTE13"), sum(sys_op_opnsize("ATTRIBUTE13")), substrb(dump(min(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE14"), count(distinct "ATTRIBUTE14"), sum(sys_op_opnsize("ATTRIBUTE14")), substrb(dump(min(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE15"), count(distinct "ATTRIBUTE15"), sum(sys_op_opnsize("ATTRIBUTE15")), substrb(dump(min(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1,
120), count("INTERFACE_LINE_ATTRIBUTE12"), count(distinct "INTERFACE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE13")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE14"), count(distinct "INTERFACE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE14")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE15"), count(distinct "INTERFACE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE15")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE9"), count(distinct "INTERFACE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE9")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("CREATED_BY"), count(distinct "CREATED_BY"), sum(sys_op_opnsize("CREATED_BY")), substrb(dump(min("CREATED_BY"), 16, 0, 32), 1, 120),
substrb(dump(max("CREATED_BY"), 16, 0, 32), 1, 120), count("CREATION_DATE"), count(distinct "CREATION_DATE"), substrb(dump(min("CREATION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CREATION_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATED_BY"), count(distinct "LAST_UPDATED_BY"), sum(sys_op_opnsize("LAST_UPDATED_BY")), substrb(dump(min("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), count("LAST_UPDATE_DATE"), count(distinct "LAST_UPDATE_DATE"), substrb(dump(min("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATE_LOGIN"), count(distinct "LAST_UPDATE_LOGIN"), sum(sys_op_opnsize("LAST_UPDATE_LOGIN")), substrb(dump(min("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), count("ORG_ID"), count(distinct "ORG_ID"), sum(sys_op_opnsize("ORG_ID")), substrb(dump(min("ORG_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORG_ID"), 16, 0, 32), 1, 120), count("SALESGROUP_ID"), count(distinct "SALESGROUP_ID"), sum(sys_op_opnsize("SALESGROUP_ID")), substrb(dump(min("SALESGROUP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALESGROUP_ID"), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_SALESCREDITS_ALL" sample ( 10.0000000000) t |
| 6h2tpcxpymqu7 | BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END; |
| 7g05xfvc5vp74 | BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END; |
| 8ay7m8qubw98j | select * from PO_TAX_LINES_SUMMARY_V where trx_header_id = :b1 ORDER BY trx_header_id, trx_line_id, trx_shipment_id , trx_distribution_id |
| 95pbs94n69z3d | SELECT NVL(MULTI_ORG_FLAG, 'N'), NVL(MULTI_CURRENCY_FLAG, 'N') FROM FND_PRODUCT_GROUPS |
| 9dvfguzd15kpv | SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = :B1 |
| 9sf243fdjmdmh | begin fnd_global.apps_initialize(-1, -1, -1, :1); end; |
| 9wdrypwkpf607 | begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end; |
| a29grr748ghc4 | BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END; |
| a957tvxz9w038 | BEGIN :1 := por_util_pkg.interface_START_WORKFLOW( :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102) ; END; |
| avc1jqzz04wpr | SELECT 'x' FROM DUAL |
| b3an778qn1q49 |
select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE13")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE14"), count(distinct "INTERFACE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE14")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE15"), count(distinct "INTERFACE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE15")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE9"), count(distinct "INTERFACE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE9")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("VAT_TAX_ID"), count(distinct "VAT_TAX_ID"), sum(sys_op_opnsize("VAT_TAX_ID")), substrb(dump(min("VAT_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("VAT_TAX_ID"), 16, 0, 32), 1, 120), count("REASON_CODE_MEANING"), count(distinct "REASON_CODE_MEANING"), sum(sys_o
p_opnsize("REASON_CODE_MEANING")), substrb(dump(min(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("LAST_PERIOD_TO_CREDIT"), count(distinct "LAST_PERIOD_TO_CREDIT"), sum(sys_op_opnsize("LAST_PERIOD_TO_CREDIT")), substrb(dump(min("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), count("PAYING_CUSTOMER_ID"), count(distinct "PAYING_CUSTOMER_ID"), sum(sys_op_opnsize("PAYING_CUSTOMER_ID")), substrb(dump(min("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("PAYING_SITE_USE_ID"), count(distinct "PAYING_SITE_USE_ID"), sum(sys_op_opnsize("PAYING_SITE_USE_ID")), substrb(dump(min("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_FLAG"), count(distinct "TAX_EXEMPT_FLAG"), sum(sys_op_opnsize("TAX_EXEMPT_FLAG")), substrb(dump(min("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE"), count(distinct "TAX_EXEMPT_REASON_CODE"), sum(sys_op_opnsize("TAX_EXEMPT_REASON_CODE")), substrb(dump(min("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE_MEANING"), count(distinct "TAX_EXEMPT_REASON_CODE_MEANING"), sum(sys_op_opnsize("TAX_EXEMPT_REASON_
CODE_MEANING")), substrb(dump(min(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("TAX_EXEMPT_NUMBER"), count(distinct "TAX_EXEMPT_NUMBER"), sum(sys_op_opnsize("TAX_EXEMPT_NUMBER")), substrb(dump(min(substrb("TAX_EXEMPT_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_EXEMPT_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("SALES_TAX_ID"), count(distinct "SALES_TAX_ID"), sum(sys_op_opnsize("SALES_TAX_ID")), substrb(dump(min("SALES_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_TAX_ID"), 16, 0, 32), 1, 120), count("CREATED_BY"), count(distinct "CREATED_BY"), sum(sys_op_opnsize("CREATED_BY")), substrb(dump(min("CREATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("CREATED_BY"), 16, 0, 32), 1, 120), count("CREATION_DATE"), count(distinct "CREATION_DATE"), substrb(dump(min("CREATION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CREATION_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATED_BY"), count(distinct "LAST_UPDATED_BY"), sum(sys_op_opnsize("LAST_UPDATED_BY")), substrb(dump(min("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), count("LAST_UPDATE_DATE"), count(distinct "LAST_UPDATE_DATE"), substrb(dump(min("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATE_LOGIN"), count(distinct "LAST_UPDATE_LOGIN"), sum(sys_op_opnsize("
LAST_UPDATE_LOGIN")), substrb(dump(min("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), count("LOCATION_SEGMENT_ID"), count(distinct "LOCATION_SEGMENT_ID"), sum(sys_op_opnsize("LOCATION_SEGMENT_ID")), substrb(dump(min("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), count("MOVEMENT_ID"), count(distinct "MOVEMENT_ID"), sum(sys_op_opnsize("MOVEMENT_ID")), substrb(dump(min("MOVEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MOVEMENT_ID"), 16, 0, 32), 1, 120), count("ORG_ID"), count(distinct "ORG_ID"), sum(sys_op_opnsize("ORG_ID")), substrb(dump(min("ORG_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORG_ID"), 16, 0, 32), 1, 120), count("AMOUNT_INCLUDES_TAX_FLAG"), count(distinct "AMOUNT_INCLUDES_TAX_FLAG"), sum(sys_op_opnsize("AMOUNT_INCLUDES_TAX_FLAG")), substrb(dump(min("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTR_CATEGORY"), count(distinct "HEADER_GDF_ATTR_CATEGORY"), sum(sys_op_opnsize("HEADER_GDF_ATTR_CATEGORY")), substrb(dump(min("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE1"), count(distinct "HEADER_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEA
DER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE2"), count(distinct "HEADER_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE3"), count(distinct "HEADER_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE4"), count(distinct "HEADER_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE5"), count(distinct "HEADER_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE6"), count(distinct "HEADER_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE7"), count(distinct "HEADER
_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE8"), count(distinct "HEADER_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE9"), count(distinct "HEADER_GDF_ATTRIBUTE9"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE10"), count(distinct "HEADER_GDF_ATTRIBUTE10"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE11"), count(distinct "HEADER_GDF_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE12"), count(distinct "HEADER_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("H
EADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE13"), count(distinct "HEADER_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE14"), count(distinct "HEADER_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE15"), count(distinct "HEADER_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE16"), count(distinct "HEADER_GDF_ATTRIBUTE16"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE16")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE17"), count(distinct "HEADER_GDF_ATTRIBUTE17"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("
HEADER_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE18"), count(distinct "HEADER_GDF_ATTRIBUTE18"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE19"), count(distinct "HEADER_GDF_ATTRIBUTE19"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE19")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE20"), count(distinct "HEADER_GDF_ATTRIBUTE20"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE21"), count(distinct "HEADER_GDF_ATTRIBUTE21"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE21")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE22"), count(distinct "HEADER_GDF_ATTRIBUTE22"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE22")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBU
TE23"), count(distinct "HEADER_GDF_ATTRIBUTE23"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE23")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE24"), count(distinct "HEADER_GDF_ATTRIBUTE24"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE24")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE25"), count(distinct "HEADER_GDF_ATTRIBUTE25"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE25")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE26"), count(distinct "HEADER_GDF_ATTRIBUTE26"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE26")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE26", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE26", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE27"), count(distinct "HEADER_GDF_ATTRIBUTE27"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE27")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE27", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE27", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE28"), count(distinct "HEADER_GDF_ATTRIBUTE28"), sum(sys_op_opnsize("HEADER_GDF
_ATTRIBUTE28")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE28", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE28", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE29"), count(distinct "HEADER_GDF_ATTRIBUTE29"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE29")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE29", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE29", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE30"), count(distinct "HEADER_GDF_ATTRIBUTE30"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE30")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE30", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE30", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTR_CATEGORY"), count(distinct "LINE_GDF_ATTR_CATEGORY"), sum(sys_op_opnsize("LINE_GDF_ATTR_CATEGORY")), substrb(dump(min("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE1"), count(distinct "LINE_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE2"), count(distinct "LINE_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIB
UTE2", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE3"), count(distinct "LINE_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE4"), count(distinct "LINE_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE5"), count(distinct "LINE_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE6"), count(distinct "LINE_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE7"), count(distinct "LINE_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE8"), count(distinct "LINE_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE8")), subst
rb(dump(min(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE9"), count(distinct "LINE_GDF_ATTRIBUTE9"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE10"), count(distinct "LINE_GDF_ATTRIBUTE10"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE11"), count(distinct "LINE_GDF_ATTRIBUTE11"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE12"), count(distinct "LINE_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE13"), count(distinct "LINE_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0
, 32), 1, 120), count("LINE_GDF_ATTRIBUTE14"), count(distinct "LINE_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE15"), count(distinct "LINE_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE16"), count(distinct "LINE_GDF_ATTRIBUTE16"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE16")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE17"), count(distinct "LINE_GDF_ATTRIBUTE17"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE18"), count(distinct "LINE_GDF_ATTRIBUTE18"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE19"), count(distinct "LINE_GDF_ATTRIBUTE19"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE19"))
, substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE20"), count(distinct "LINE_GDF_ATTRIBUTE20"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), count("RESET_TRX_DATE_FLAG"), count(distinct "RESET_TRX_DATE_FLAG"), sum(sys_op_opnsize("RESET_TRX_DATE_FLAG")), substrb(dump(min("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), count("PAYMENT_SERVER_ORDER_NUM"), count(distinct "PAYMENT_SERVER_ORDER_NUM"), sum(sys_op_opnsize("PAYMENT_SERVER_ORDER_NUM")), substrb(dump(min(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), count("APPROVAL_CODE"), count(distinct "APPROVAL_CODE"), sum(sys_op_opnsize("APPROVAL_CODE")), substrb(dump(min(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), count("ADDRESS_VERIFICATION_CODE"), count(distinct "ADDRESS_VERIFICATION_CODE"), sum(sys_op_opnsize("ADDRESS_VERIFICATION_CODE")), substrb(dump(min(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120
), count("WAREHOUSE_ID"), count(distinct "WAREHOUSE_ID"), sum(sys_op_opnsize("WAREHOUSE_ID")), substrb(dump(min("WAREHOUSE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("WAREHOUSE_ID"), 16, 0, 32), 1, 120), count("TRANSLATED_DESCRIPTION"), count(distinct "TRANSLATED_DESCRIPTION"), sum(sys_op_opnsize("TRANSLATED_DESCRIPTION")), substrb(dump(min(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count("CONS_BILLING_NUMBER"), count(distinct "CONS_BILLING_NUMBER"), sum(sys_op_opnsize("CONS_BILLING_NUMBER")), substrb(dump(min("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), count("PROMISED_COMMITMENT_AMOUNT"), count(distinct "PROMISED_COMMITMENT_AMOUNT"), sum(sys_op_opnsize("PROMISED_COMMITMENT_AMOUNT")), substrb(dump(min("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), count("PAYMENT_SET_ID"), count(distinct "PAYMENT_SET_ID"), sum(sys_op_opnsize("PAYMENT_SET_ID")), substrb(dump(min("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), count("ORIGINAL_GL_DATE"), count(distinct "ORIGINAL_GL_DATE"), substrb(dump(min("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), count("CONTRACT_LINE_ID"), count(distinct "CONTRACT_LINE_ID"), sum(sys_op_opnsize("CONTRACT_LINE_ID")), subst
rb(dump(min("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), count("CONTRACT_ID"), count(distinct "CONTRACT_ID"), sum(sys_op_opnsize("CONTRACT_ID")), substrb(dump(min("CONTRACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_ID"), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY1"), count(distinct "SOURCE_DATA_KEY1"), sum(sys_op_opnsize("SOURCE_DATA_KEY1")), substrb(dump(min(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY2"), count(distinct "SOURCE_DATA_KEY2"), sum(sys_op_opnsize("SOURCE_DATA_KEY2")), substrb(dump(min(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY3"), count(distinct "SOURCE_DATA_KEY3"), sum(sys_op_opnsize("SOURCE_DATA_KEY3")), substrb(dump(min(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY4"), count(distinct "SOURCE_DATA_KEY4"), sum(sys_op_opnsize("SOURCE_DATA_KEY4")), substrb(dump(min(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY5"), count(distinct "SOURCE_DATA_KEY5"), sum(sys_op_opnsize("SOURCE_DATA_KEY5")), substrb(dump(min(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 1
20), substrb(dump(max(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120), count("INVOICED_LINE_ACCTG_LEVEL"), count(distinct "INVOICED_LINE_ACCTG_LEVEL"), sum(sys_op_opnsize("INVOICED_LINE_ACCTG_LEVEL")), substrb(dump(min("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG10"), count(distinct "MTL_SYSTEM_ITEMS_SEG10"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG10")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG11"), count(distinct "MTL_SYSTEM_ITEMS_SEG11"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG11")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG11", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG12"), count(distinct "MTL_SYSTEM_ITEMS_SEG12"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG12")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG12", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG13"), count(distinct "MTL_SYSTEM_ITEMS_SEG13"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG13")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG13", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM
_ITEMS_SEG14"), count(distinct "MTL_SYSTEM_ITEMS_SEG14"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG14")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG15"), count(distinct "MTL_SYSTEM_ITEMS_SEG15"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG15")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG16"), count(distinct "MTL_SYSTEM_ITEMS_SEG16"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG16")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG17"), count(distinct "MTL_SYSTEM_ITEMS_SEG17"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG17")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG18"), count(distinct "MTL_SYSTEM_ITEMS_SEG18"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG18")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG19"), count(distinct "MTL_SYSTEM_ITEMS_SEG19"), sum(sys_op_opnsize("MT
L_SYSTEM_ITEMS_SEG19")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG20"), count(distinct "MTL_SYSTEM_ITEMS_SEG20"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG20")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ID"), count(distinct "REFERENCE_LINE_ID"), sum(sys_op_opnsize("REFERENCE_LINE_ID")), substrb(dump(min("REFERENCE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ID"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_CONTEXT"), count(distinct "REFERENCE_LINE_CONTEXT"), sum(sys_op_opnsize("REFERENCE_LINE_CONTEXT")), substrb(dump(min("REFERENCE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE1"), count(distinct "REFERENCE_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE1")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE2"), count(distinct "REFERENCE_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE2")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("REFERENCE
_LINE_ATTRIBUTE3"), count(distinct "REFERENCE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE3")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE4"), count(distinct "REFERENCE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE4")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE5"), count(distinct "REFERENCE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE5")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE6"), count(distinct "REFERENCE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE6")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE7"), count(distinct "REFERENCE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE7")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("TERRITORY_ID"), count(distinct "TERRITORY_ID"), sum(sys_op_opnsize("TERRITORY_ID")), substrb(dump(min("TERRITORY_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_ID"),
16, 0, 32), 1, 120), count("TERRITORY_SEGMENT1"), count(distinct "TERRITORY_SEGMENT1"), sum(sys_op_opnsize("TERRITORY_SEGMENT1")), substrb(dump(min("TERRITORY_SEGMENT1"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT1"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT2"), count(distinct "TERRITORY_SEGMENT2"), sum(sys_op_opnsize("TERRITORY_SEGMENT2")), substrb(dump(min("TERRITORY_SEGMENT2"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT2"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT3"), count(distinct "TERRITORY_SEGMENT3"), sum(sys_op_opnsize("TERRITORY_SEGMENT3")), substrb(dump(min("TERRITORY_SEGMENT3"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT3"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT4"), count(distinct "TERRITORY_SEGMENT4"), sum(sys_op_opnsize("TERRITORY_SEGMENT4")), substrb(dump(min("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT5"), count(distinct "TERRITORY_SEGMENT5"), sum(sys_op_opnsize("TERRITORY_SEGMENT5")), substrb(dump(min("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT6"), count(distinct "TERRITORY_SEGMENT6"), sum(sys_op_opnsize("TERRITORY_SEGMENT6")), substrb(dump(min("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT7"), count(distinct "TERRITORY_SEGMENT7"), sum(sys_op_opnsize("
TERRITORY_SEGMENT7")), substrb(dump(min("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT8"), count(distinct "TERRITORY_SEGMENT8"), sum(sys_op_opnsize("TERRITORY_SEGMENT8")), substrb(dump(min("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT9"), count(distinct "TERRITORY_SEGMENT9"), sum(sys_op_opnsize("TERRITORY_SEGMENT9")), substrb(dump(min("TERRITORY_SEGMENT9"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT9"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT10"), count(distinct "TERRITORY_SEGMENT10"), sum(sys_op_opnsize("TERRITORY_SEGMENT10")), substrb(dump(min("TERRITORY_SEGMENT10"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT10"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT11"), count(distinct "TERRITORY_SEGMENT11"), sum(sys_op_opnsize("TERRITORY_SEGMENT11")), substrb(dump(min("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT12"), count(distinct "TERRITORY_SEGMENT12"), sum(sys_op_opnsize("TERRITORY_SEGMENT12")), substrb(dump(min("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), substrb(d?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????, 1, 120), substrb(dump(max(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE2"), count(distinct "ATTRIBUTE2"), sum(sys_op_opnsize("ATTRIBUTE2")), substrb(dump(min(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE3"), count(distinct "ATTRIBUTE3"), sum(sys_op_opnsize("ATTRIBUTE3")), substrb(dump(min(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE4"), count(distinct "ATTRIBUTE4"), sum(sys_op_opnsize("ATTRIBUTE4")), substrb(dump(min(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE5"), count(distinct "ATTRIBUTE5"), sum(sys_op_opnsize("ATTRIBUTE5")), substrb(dump(min(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE6"), count(distinct "ATTRIBUTE6"), sum(sys_op_opnsize("ATTRIBUTE6"
)), substrb(dump(min(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE7"), count(distinct "ATTRIBUTE7"), sum(sys_op_opnsize("ATTRIBUTE7")), substrb(dump(min(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE8"), count(distinct "ATTRIBUTE8"), sum(sys_op_opnsize("ATTRIBUTE8")), substrb(dump(min(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE9"), count(distinct "ATTRIBUTE9"), sum(sys_op_opnsize("ATTRIBUTE9")), substrb(dump(min(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE10"), count(distinct "ATTRIBUTE10"), sum(sys_op_opnsize("ATTRIBUTE10")), substrb(dump(min(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE11"), count(distinct "ATTRIBUTE11"), sum(sys_op_opnsize("ATTRIBUTE11")), substrb(dump(min(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE12"), count(distinct "ATTRIBUTE12"), sum(sys_op_opnsize("ATTRIBUTE12")), substrb(dump(min(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120),
count("ATTRIBUTE13"), count(distinct "ATTRIBUTE13"), sum(sys_op_opnsize("ATTRIBUTE13")), substrb(dump(min(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE14"), count(distinct "ATTRIBUTE14"), sum(sys_op_opnsize("ATTRIBUTE14")), substrb(dump(min(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE15"), count(distinct "ATTRIBUTE15"), sum(sys_op_opnsize("ATTRIBUTE15")), substrb(dump(min(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE_CATEGORY"), count(distinct "HEADER_ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("HEADER_ATTRIBUTE_CATEGORY")), substrb(dump(min("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE1"), count(distinct "HEADER_ATTRIBUTE1"), sum(sys_op_opnsize("HEADER_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE2"), count(distinct "HEADER_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE3"),
count(distinct "HEADER_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE4"), count(distinct "HEADER_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE5"), count(distinct "HEADER_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE6"), count(distinct "HEADER_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE7"), count(distinct "HEADER_ATTRIBUTE7"), sum(sys_op_opnsize("HEADER_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE8"), count(distinct "HEADER_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE8", 1,
32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE9"), count(distinct "HEADER_ATTRIBUTE9"), sum(sys_op_opnsize("HEADER_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE10"), count(distinct "HEADER_ATTRIBUTE10"), sum(sys_op_opnsize("HEADER_ATTRIBUTE10")), substrb(dump(min(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE11"), count(distinct "HEADER_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE12"), count(distinct "HEADER_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_ATTRIBUTE12")), substrb(dump(min(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE13"), count(distinct "HEADER_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE14"), count(distinct "HEADER_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_ATTRIBUTE14", 1
, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE15"), count(distinct "HEADER_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t |
| bc7t6t6jfx2n7 | SELECT VERSION FROM FND_CACHE_VERSIONS WHERE NAME = :B1 |
| bcym7s1bp0wxs | SELECT WIA.NAME FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1 AND WIA.TYPE = 'EVENT' |
| bkxrrs52m7d8p | BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END; |
| bp8crdjba8zgt | update ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b4) |
| bt0w082dfrm8v | BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END; |
| bvyqm6268u2as | SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = :B1 |
| by0sg8ccaazuk |
UPDATE MRP_ATP_SCHEDULE_TEMP SET SCENARIO_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B44 , -1), SCENARIO_ID), INVENTORY_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B43 , INVENTORY_ITEM_ID), INVENTORY_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B42 , INVENTORY_ITEM_NAME), SOURCE_ORGANIZATION_ID =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B40 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B41 , NULL)), SOURCE_ORGANIZATION_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B38 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B39 , NULL)), ORDER_HEADER_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B37 , -1), NULL), DEMAND_SOURCE_TYPE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B36 , NULL), DELIVERY_LEAD_TIME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B34 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B35 , NULL)), SHIP_METHOD = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B32 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B33 , NULL)), DEMAND_CLASS = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B31 , NULL), SCHEDULED_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B29 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B30 , NULL)), AVAILABLE_QUANTITY = DECO
DE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B28 , NULL), REQUESTED_DATE_QUANTITY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B27 , NULL), GROUP_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B25 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B26 , NULL)), GROUP_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B23 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B24 , NULL)), ERROR_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B21 , DECODE(ERROR_CODE, NULL, DECODE(:B22 , 150, 0, 61, 0, 0, 0, :B51 ))), ERROR_MESSAGE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B20 , NULL), STATUS_FLAG = 2, END_PEGGING_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B18 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B19 , NULL)), SCHEDULED_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B16 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B17 , NULL)), ORGANIZATION_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B15 , NULL), REQUEST_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B14 , NULL), REQUEST_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B13 , NULL), REQ_ITEM_REQ_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B12 , NULL), REQ_ITEM_A
VAILABLE_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B11 , NULL), REQ_ITEM_AVAILABLE_DATE =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B10 , NULL), SALES_REP = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B9 , NULL), CUSTOMER_CONTACT = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B8 , NULL), COMPILE_DESIGNATOR = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), DECODE(:B50 , 4, :B7 , NULL), NULL), SUBST_FLAG = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B6 , NULL), MATCH_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B5 , NULL), MATCHED_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B4 , NULL), PLAN_ID = :B3 , FIRST_VALID_SHIP_ARRIVAL_DATE = :B2 , ATP_LEAD_TIME = DECODE(ATO_MODEL_LINE_ID, NULL, NULL, ORDER_LINE_ID, 0, :B1 ) WHERE SESSION_ID = :B49 AND STATUS_FLAG = 99 AND NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID) = :B48 AND NVL(:B47 , 2) = 2 AND NVL(SOURCE_ORGANIZATION_ID, NVL(:B45 , -1)) = NVL(:B46 , -1) |
| c4y7jp0q2awbf | SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 |
| cwyx16zn1hpfb | select parameter, value from nls_session_parameters |
| fhqzxap2n0ybj | select NAME from HR_OPERATING_UNITS where ORGANIZATION_ID = :zorg_id |
| fmfdkztk8vx23 | SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1 |
| g8102j8yynbwz | begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end; |
| gf1u933c95jb5 | DECLARE
l_ret_stat varchar2(56);
BEGIN
CSI_INV_TXN_HOOK_PKG.postTransaction(
p_header_id => :1 ,
p_transaction_id => :2 ,
x_return_status => l_ret_stat );
INV_TXNSTUB_PUB.g_ret_status := l_ret_stat;
END; |
| ghw9svn8x4vzu | BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS( :errbuf, :rc, :A0, :A1, :A2); END; |
| gksvm8wmzk8w0 | begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end; |
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 | 4,125,715 | 1,143.35 | 3.32 |
| CPU used when call started | 4,103,409 | 1,137.16 | 3.30 |
| CR blocks created | 16,670,460 | 4,619.83 | 13.42 |
| Cached Commit SCN referenced | 897,260 | 248.65 | 0.72 |
| Commit SCN cached | 465 | 0.13 | 0.00 |
| DB time | 8,489,288 | 2,352.61 | 6.83 |
| DBWR checkpoint buffers written | 3,738,614 | 1,036.07 | 3.01 |
| DBWR checkpoints | 34 | 0.01 | 0.00 |
| DBWR object drop buffers written | 57,036 | 15.81 | 0.05 |
| DBWR revisited being-written buffer | 52 | 0.01 | 0.00 |
| DBWR thread checkpoint buffers written | 581,973 | 161.28 | 0.47 |
| DBWR transaction table writes | 2,838 | 0.79 | 0.00 |
| DBWR undo block writes | 1,750,959 | 485.24 | 1.41 |
| DFO trees parallelized | 48 | 0.01 | 0.00 |
| IMU CR rollbacks | 26,002,475 | 7,205.98 | 20.93 |
| IMU Flushes | 348,840 | 96.67 | 0.28 |
| IMU Redo allocation size | 2,484,065,280 | 688,400.96 | 1,999.46 |
| IMU commits | 649,882 | 180.10 | 0.52 |
| IMU contention | 40,675 | 11.27 | 0.03 |
| IMU ktichg flush | 9,313 | 2.58 | 0.01 |
| IMU pool not allocated | 0 | 0.00 | 0.00 |
| IMU recursive-transaction flush | 1,781 | 0.49 | 0.00 |
| IMU undo allocation size | 5,743,990,600 | 1,591,813.51 | 4,623.43 |
| IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
| PX local messages recv'd | 69,933 | 19.38 | 0.06 |
| PX local messages sent | 69,933 | 19.38 | 0.06 |
| Parallel operations downgraded 25 to 50 pct | 40 | 0.01 | 0.00 |
| Parallel operations not downgraded | 8 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 1 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 52,077,783 | 14,432.15 | 41.92 |
| active txn count during cleanout | 94,511,365 | 26,191.63 | 76.07 |
| application wait time | 48,106 | 13.33 | 0.04 |
| background checkpoints completed | 3 | 0.00 | 0.00 |
| background checkpoints started | 2 | 0.00 | 0.00 |
| background timeouts | 13,770 | 3.82 | 0.01 |
| branch node splits | 870 | 0.24 | 0.00 |
| buffer is not pinned count | 630,203,141 | 174,646.16 | 507.26 |
| buffer is pinned count | 1,145,055,345 | 317,325.48 | 921.67 |
| bytes received via SQL*Net from client | 9,707,645,911 | 2,690,248.47 | 7,813.84 |
| bytes sent via SQL*Net to client | 9,251,604,084 | 2,563,867.07 | 7,446.77 |
| calls to get snapshot scn: kcmgss | 134,318,154 | 37,223.15 | 108.11 |
| calls to kcmgas | 21,007,523 | 5,821.75 | 16.91 |
| calls to kcmgcs | 10,634,384 | 2,947.07 | 8.56 |
| change write time | 81,587 | 22.61 | 0.07 |
| cleanout - number of ktugct calls | 25,554,226 | 7,081.76 | 20.57 |
| cleanouts and rollbacks - consistent read gets | 14,546,539 | 4,031.24 | 11.71 |
| cleanouts only - consistent read gets | 174,895 | 48.47 | 0.14 |
| cluster key scan block gets | 1,476,850 | 409.27 | 1.19 |
| cluster key scans | 170,291 | 47.19 | 0.14 |
| commit batch performed | 0 | 0.00 | 0.00 |
| commit batch requested | 0 | 0.00 | 0.00 |
| commit batch/immediate performed | 5,414 | 1.50 | 0.00 |
| commit batch/immediate requested | 5,414 | 1.50 | 0.00 |
| commit cleanout failures: block lost | 297,906 | 82.56 | 0.24 |
| commit cleanout failures: buffer being written | 1,474 | 0.41 | 0.00 |
| commit cleanout failures: callback failure | 113,384 | 31.42 | 0.09 |
| commit cleanout failures: cannot pin | 38,588 | 10.69 | 0.03 |
| commit cleanouts | 10,069,709 | 2,790.59 | 8.11 |
| commit cleanouts successfully completed | 9,618,357 | 2,665.50 | 7.74 |
| commit immediate performed | 5,414 | 1.50 | 0.00 |
| commit immediate requested | 5,414 | 1.50 | 0.00 |
| commit txn count during cleanout | 1,455,745 | 403.43 | 1.17 |
| concurrency wait time | 58,433 | 16.19 | 0.05 |
| consistent changes | 731,821,136 | 202,807.22 | 589.05 |
| consistent gets | 1,858,241,344 | 514,968.40 | 1,495.73 |
| consistent gets - examination | 1,270,704,202 | 352,146.14 | 1,022.81 |
| consistent gets from cache | 1,858,241,326 | 514,968.40 | 1,495.73 |
| cursor authentications | 2,031 | 0.56 | 0.00 |
| data blocks consistent reads - undo records applied | 726,840,790 | 201,427.03 | 585.05 |
| db block changes | 204,079,698 | 56,555.95 | 164.27 |
| db block gets | 226,026,982 | 62,638.13 | 181.93 |
| db block gets direct | 4,329 | 1.20 | 0.00 |
| db block gets from cache | 226,022,659 | 62,636.93 | 181.93 |
| deferred (CURRENT) block cleanout applications | 1,617,264 | 448.19 | 1.30 |
| dirty buffers inspected | 11,562 | 3.20 | 0.01 |
| doubling up with imu segment | 0 | 0.00 | 0.00 |
| enqueue conversions | 11,112 | 3.08 | 0.01 |
| enqueue releases | 5,022,057 | 1,391.75 | 4.04 |
| enqueue requests | 5,030,086 | 1,393.97 | 4.05 |
| enqueue timeouts | 7,899 | 2.19 | 0.01 |
| enqueue waits | 57,848 | 16.03 | 0.05 |
| exchange deadlocks | 48,440 | 13.42 | 0.04 |
| execute count | 120,618,792 | 33,426.70 | 97.09 |
| failed probes on index block reclamation | 8,003 | 2.22 | 0.01 |
| free buffer inspected | 3,671,675 | 1,017.52 | 2.96 |
| free buffer requested | 21,578,987 | 5,980.11 | 17.37 |
| heap block compress | 28,787,446 | 7,977.77 | 23.17 |
| hot buffers moved to head of LRU | 1,574,375 | 436.30 | 1.27 |
| immediate (CR) block cleanout applications | 14,721,446 | 4,079.71 | 11.85 |
| immediate (CURRENT) block cleanout applications | 1,329,734 | 368.50 | 1.07 |
| index crx upgrade (found) | 51,814 | 14.36 | 0.04 |
| index crx upgrade (positioned) | 12,867,696 | 3,565.98 | 10.36 |
| index fast full scans (rowid ranges) | 1,680 | 0.47 | 0.00 |
| index fetch by key | 203,108,329 | 56,286.75 | 163.49 |
| index scans kdiixs1 | 152,787,516 | 42,341.51 | 122.98 |
| java call heap collected bytes | 1,311,309,240 | 363,398.88 | 1,055.49 |
| java call heap collected count | 16,290,686 | 4,514.59 | 13.11 |
| java call heap gc count | 5,250 | 1.45 | 0.00 |
| java call heap live object count | 1,634,014 | 452.83 | 1.32 |
| java call heap live object count max | 1,633,569 | 452.71 | 1.31 |
| java call heap live size | 509,852,192 | 141,293.69 | 410.39 |
| java call heap live size max | 510,115,544 | 141,366.67 | 410.60 |
| java call heap object count | 3,585,045 | 993.51 | 2.89 |
| java call heap object count max | 3,591,484 | 995.30 | 2.89 |
| java call heap total size | 687,821,824 | 190,613.83 | 553.64 |
| java call heap total size max | 687,548,160 | 190,537.99 | 553.42 |
| java call heap used size | 638,171,392 | 176,854.37 | 513.67 |
| java call heap used size max | 639,148,376 | 177,125.12 | 514.46 |
| leaf node 90-10 splits | 21,496 | 5.96 | 0.02 |
| leaf node splits | 251,262 | 69.63 | 0.20 |
| lob reads | 23,815 | 6.60 | 0.02 |
| lob writes | 41,091 | 11.39 | 0.03 |
| lob writes unaligned | 41,091 | 11.39 | 0.03 |
| logons cumulative | 10,839 | 3.00 | 0.01 |
| messages received | 2,849,643 | 789.71 | 2.29 |
| messages sent | 2,849,643 | 789.71 | 2.29 |
| no buffer to keep pinned count | 16 | 0.00 | 0.00 |
| no work - consistent read gets | 531,974,806 | 147,424.45 | 428.20 |
| opened cursors cumulative | 13,683,746 | 3,792.13 | 11.01 |
| parse count (failures) | 3,605 | 1.00 | 0.00 |
| parse count (hard) | 9,192 | 2.55 | 0.01 |
| parse count (total) | 17,935,494 | 4,970.41 | 14.44 |
| parse time cpu | 118,138 | 32.74 | 0.10 |
| parse time elapsed | 134,713 | 37.33 | 0.11 |
| physical read IO requests | 397,303 | 110.10 | 0.32 |
| physical read bytes | 4,548,100,096 | 1,260,400.25 | 3,660.84 |
| physical read total IO requests | 398,984 | 110.57 | 0.32 |
| physical read total bytes | 4,574,732,288 | 1,267,780.74 | 3,682.28 |
| physical read total multi block requests | 21,845 | 6.05 | 0.02 |
| physical reads | 555,188 | 153.86 | 0.45 |
| physical reads cache | 554,394 | 153.64 | 0.45 |
| physical reads cache prefetch | 157,705 | 43.70 | 0.13 |
| physical reads direct | 794 | 0.22 | 0.00 |
| physical reads direct temporary tablespace | 186 | 0.05 | 0.00 |
| physical reads prefetch warmup | 111,133 | 30.80 | 0.09 |
| physical write IO requests | 1,317,978 | 365.25 | 1.06 |
| physical write bytes | 31,348,432,896 | 8,687,489.67 | 25,232.87 |
| physical write total IO requests | 2,825,127 | 782.92 | 2.27 |
| physical write total bytes | 68,032,442,368 | 18,853,610.38 | 54,760.43 |
| physical write total multi block requests | 1,791,907 | 496.59 | 1.44 |
| physical writes | 3,826,713 | 1,060.48 | 3.08 |
| physical writes direct | 4,848 | 1.34 | 0.00 |
| physical writes direct (lob) | 218 | 0.06 | 0.00 |
| physical writes direct temporary tablespace | 4,185 | 1.16 | 0.00 |
| physical writes from cache | 3,821,865 | 1,059.14 | 3.08 |
| physical writes non checkpoint | 2,525,271 | 699.82 | 2.03 |
| pinned buffers inspected | 4,592 | 1.27 | 0.00 |
| prefetch warmup blocks aged out before use | 324,838 | 90.02 | 0.26 |
| prefetched blocks aged out before use | 45 | 0.01 | 0.00 |
| process last non-idle time | 3,610 | 1.00 | 0.00 |
| queries parallelized | 48 | 0.01 | 0.00 |
| recursive aborts on index block reclamation | 8 | 0.00 | 0.00 |
| recursive calls | 217,257,879 | 60,207.97 | 174.87 |
| recursive cpu usage | 2,326,806 | 644.82 | 1.87 |
| redo blocks written | 35,741,396 | 9,904.90 | 28.77 |
| redo buffer allocation retries | 0 | 0.00 | 0.00 |
| redo entries | 104,714,350 | 29,019.15 | 84.29 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 1,278,630 | 354.34 | 1.03 |
| redo size | 35,182,017,664 | 9,749,878.59 | 28,318.58 |
| redo subscn max counts | 2,660,016 | 737.16 | 2.14 |
| redo synch time | 65,191 | 18.07 | 0.05 |
| redo synch writes | 2,983,625 | 826.84 | 2.40 |
| redo wastage | 826,272,480 | 228,982.22 | 665.08 |
| redo write time | 56,140 | 15.56 | 0.05 |
| redo writer latching time | 120 | 0.03 | 0.00 |
| redo writes | 924,663 | 256.25 | 0.74 |
| rollback changes - undo records applied | 197,994 | 54.87 | 0.16 |
| rollbacks only - consistent read gets | 2,252,258 | 624.16 | 1.81 |
| rows fetched via callback | 105,197,215 | 29,152.96 | 84.67 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 7,712,963 | 2,137.47 | 6.21 |
| session logical reads | 2,084,268,988 | 577,606.71 | 1,677.66 |
| session pga memory | 7,239,739,096 | 2,006,325.44 | 5,827.38 |
| session pga memory max | 9,813,890,840 | 2,719,691.78 | 7,899.36 |
| session uga memory | ############### | 71,648,852.54 | 208,104.55 |
| session uga memory max | 77,315,301,432 | 21,426,139.05 | 62,232.36 |
| shared hash latch upgrades - no wait | 35,773,838 | 9,913.89 | 28.79 |
| shared hash latch upgrades - wait | 75,647 | 20.96 | 0.06 |
| sorts (memory) | 13,038,165 | 3,613.22 | 10.49 |
| sorts (rows) | 156,206,663 | 43,289.05 | 125.73 |
| sql area evicted | 840 | 0.23 | 0.00 |
| sql area purged | 3,774 | 1.05 | 0.00 |
| summed dirty queue length | 232,992 | 64.57 | 0.19 |
| switch current to new buffer | 1,521,764 | 421.72 | 1.22 |
| table fetch by rowid | 722,803,209 | 200,308.11 | 581.80 |
| table fetch continued row | 37,200,004 | 10,309.12 | 29.94 |
| table scan blocks gotten | 103,591,924 | 28,708.09 | 83.38 |
| table scan rows gotten | 5,276,641,571 | 1,462,298.59 | 4,247.26 |
| table scans (long tables) | 4,670 | 1.29 | 0.00 |
| table scans (rowid ranges) | 4,668 | 1.29 | 0.00 |
| table scans (short tables) | 7,184,792 | 1,991.10 | 5.78 |
| total number of times SMON posted | 129,495 | 35.89 | 0.10 |
| transaction rollbacks | 5,414 | 1.50 | 0.00 |
| transaction tables consistent read rollbacks | 127 | 0.04 | 0.00 |
| transaction tables consistent reads - undo records applied | 6,956 | 1.93 | 0.01 |
| undo change vector size | 12,429,558,656 | 3,444,563.33 | 10,004.76 |
| user I/O wait time | 200,396 | 55.54 | 0.16 |
| user calls | 49,560,825 | 13,734.63 | 39.89 |
| user commits | 976,767 | 270.69 | 0.79 |
| user rollbacks | 265,598 | 73.60 | 0.21 |
| workarea executions - onepass | 2 | 0.00 | 0.00 |
| workarea executions - optimal | 8,206,325 | 2,274.19 | 6.61 |
| write clones created in background | 1,433 | 0.40 | 0.00 |
| write clones created in foreground | 13,047 | 3.62 | 0.01 |
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 | 471,483 | 1,309,594 |
| opened cursors current | 863,226 | 900,004 |
| workarea memory allocated | 4,679 | 2,112 |
| logons current | 5,224 | 5,196 |
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) | 0 | 0.00 |
Back to Instance Activity Statistics
Back to Top
IO Stats
Back to Top
Tablespace IO Stats
- ordered by IOs (Reads + Writes) desc
| Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|
| APPS_UNDOTS1 |
100 | 0 | 6.90 | 1.00 | 411,627 | 114 | 261,453 | 0.05 |
| APPS_TS_TX_IDX |
138,677 | 38 | 5.50 | 1.45 | 217,565 | 60 | 86,987 | 0.31 |
| APPS_TS_TX_DATA |
169,115 | 47 | 4.95 | 1.31 | 172,898 | 48 | 110,490 | 0.29 |
| APPS_ASSM_DATA |
33,074 | 9 | 2.62 | 1.98 | 283,019 | 78 | 52,225 | 0.37 |
| APPS_ASSM_IDX |
39,850 | 11 | 4.07 | 1.00 | 145,945 | 40 | 282,114 | 0.11 |
| APPS_TS_TX_INTERFACE |
820 | 0 | 6.33 | 2.24 | 30,813 | 9 | 3,182 | 0.10 |
| APPS_TS_QUEUES |
3,447 | 1 | 8.09 | 1.50 | 24,025 | 7 | 104 | 0.48 |
| SYSTEM |
7,709 | 2 | 4.98 | 1.51 | 5,298 | 1 | 7,302 | 0.47 |
| TEMP |
971 | 0 | 4.20 | 4.77 | 10,172 | 3 | 88 | 6.59 |
| APPS_TS_SEED |
2,537 | 1 | 7.67 | 1.47 | 4,459 | 1 | 834 | 3.25 |
| APPS_TS_SUMMARY |
61 | 0 | 9.02 | 1.00 | 4,653 | 1 | 2,888 | 0.05 |
| CTXSYS |
199 | 0 | 6.78 | 1.28 | 4,496 | 1 | 0 | 0.00 |
| APPS_TS_ARCHIVE |
65 | 0 | 8.15 | 1.00 | 2,163 | 1 | 146 | 5.00 |
| SYSAUX |
536 | 0 | 3.19 | 1.85 | 636 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING |
32 | 0 | 4.06 | 1.44 | 67 | 0 | 2 | 0.00 |
| APPS_TS_MEDIA |
9 | 0 | 10.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| ODM |
7 | 0 | 4.29 | 1.00 | 3 | 0 | 0 | 0.00 |
| OLAP |
7 | 0 | 1.43 | 1.00 | 3 | 0 | 0 | 0.00 |
| OWAPUB |
7 | 0 | 5.71 | 1.00 | 3 | 0 | 0 | 0.00 |
| PORTAL |
7 | 0 | 4.29 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYNCSERVER |
7 | 0 | 2.86 | 1.00 | 3 | 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 | /oracle/visdata/apps_assm_data.dbf |
33,074 | 9 | 2.62 | 1.98 | 283,019 | 78 | 52,225 | 0.37 |
| APPS_ASSM_IDX | /oracle/visdata/apps_assm_idx.dbf |
39,850 | 11 | 4.07 | 1.00 | 145,945 | 40 | 282,114 | 0.11 |
| APPS_TS_ARCHIVE | /oasb_data/archive1.dbf |
18 | 0 | 15.00 | 1.00 | 1,183 | 0 | 50 | 4.40 |
| APPS_TS_ARCHIVE | /oasb_data/archive2.dbf |
47 | 0 | 5.53 | 1.00 | 980 | 0 | 96 | 5.31 |
| APPS_TS_MEDIA | /oasb_data/media1.dbf |
3 | 0 | 13.33 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oasb_data/media2.dbf |
3 | 0 | 6.67 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oasb_data/media3.dbf |
3 | 0 | 10.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /oasb_data/nologging1.dbf |
16 | 0 | 6.88 | 1.88 | 61 | 0 | 2 | 0.00 |
| APPS_TS_NOLOGGING | /oasb_data/nologging2.dbf |
8 | 0 | 1.25 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /oasb_data/nologging3.dbf |
8 | 0 | 1.25 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /oasb_data/queues1.dbf |
465 | 0 | 8.22 | 1.50 | 3,152 | 1 | 1 | 0.00 |
| APPS_TS_QUEUES | /oasb_data/queues2.dbf |
537 | 0 | 7.23 | 1.51 | 3,869 | 1 | 12 | 0.83 |
| APPS_TS_QUEUES | /oasb_data/queues3.dbf |
477 | 0 | 8.99 | 1.51 | 3,676 | 1 | 55 | 0.73 |
| APPS_TS_QUEUES | /oasb_data/queues4.dbf |
456 | 0 | 9.93 | 1.41 | 3,271 | 1 | 14 | 0.00 |
| APPS_TS_QUEUES | /oasb_data/queues5.dbf |
495 | 0 | 7.64 | 1.65 | 3,327 | 1 | 15 | 0.00 |
| APPS_TS_QUEUES | /oasb_data/queues6.dbf |
514 | 0 | 7.67 | 1.51 | 3,542 | 1 | 7 | 0.00 |
| APPS_TS_QUEUES | /oasb_data/queues7.dbf |
503 | 0 | 7.24 | 1.42 | 3,188 | 1 | 0 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference1.dbf |
216 | 0 | 6.57 | 1.91 | 372 | 0 | 167 | 3.35 |
| APPS_TS_SEED | /oasb_data/reference10.dbf |
181 | 0 | 9.61 | 1.46 | 305 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference2.dbf |
360 | 0 | 5.42 | 1.52 | 351 | 0 | 568 | 3.75 |
| APPS_TS_SEED | /oasb_data/reference3.dbf |
238 | 0 | 8.19 | 1.50 | 500 | 0 | 6 | 3.33 |
| APPS_TS_SEED | /oasb_data/reference4.dbf |
263 | 0 | 8.21 | 1.26 | 470 | 0 | 90 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference5.dbf |
254 | 0 | 7.99 | 1.59 | 477 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference6.dbf |
260 | 0 | 7.50 | 1.65 | 545 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference7.dbf |
255 | 0 | 8.78 | 1.25 | 470 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference8.dbf |
277 | 0 | 7.47 | 1.24 | 458 | 0 | 3 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference9.dbf |
233 | 0 | 8.33 | 1.43 | 511 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /oasb_data/summary1.dbf |
20 | 0 | 8.00 | 1.00 | 534 | 0 | 318 | 0.00 |
| APPS_TS_SUMMARY | /oasb_data/summary2.dbf |
4 | 0 | 5.00 | 1.00 | 84 | 0 | 27 | 0.00 |
| APPS_TS_SUMMARY | /oasb_data/summary3.dbf |
4 | 0 | 20.00 | 1.00 | 965 | 0 | 305 | 0.00 |
| APPS_TS_SUMMARY | /oasb_data/summary4.dbf |
5 | 0 | 10.00 | 1.00 | 788 | 0 | 474 | 0.08 |
| APPS_TS_SUMMARY | /oasb_data/summary5.dbf |
4 | 0 | 15.00 | 1.00 | 627 | 0 | 819 | 0.01 |
| APPS_TS_SUMMARY | /oasb_data/summary6.dbf |
8 | 0 | 8.75 | 1.00 | 561 | 0 | 361 | 0.22 |
| APPS_TS_SUMMARY | /oasb_data/summary7.dbf |
8 | 0 | 6.25 | 1.00 | 572 | 0 | 232 | 0.09 |
| APPS_TS_SUMMARY | /oasb_data/summary8.dbf |
8 | 0 | 7.50 | 1.00 | 522 | 0 | 352 | 0.00 |
| APPS_TS_TX_DATA | /oasb_data/tx_data1.dbf |
586 | 0 | 5.67 | 1.82 | 7,392 | 2 | 4,933 | 0.45 |
| APPS_TS_TX_DATA | /oasb_data/tx_data10.dbf |
411 | 0 | 3.70 | 1.69 | 7,625 | 2 | 5,178 | 0.39 |
| APPS_TS_TX_DATA | /oasb_data/tx_data11.dbf |
615 | 0 | 4.07 | 1.70 | 8,225 | 2 | 5,943 | 0.56 |
| APPS_TS_TX_DATA | /oasb_data/tx_data12.dbf |
15,462 | 4 | 4.93 | 1.31 | 8,777 | 2 | 5,623 | 0.26 |
| APPS_TS_TX_DATA | /oasb_data/tx_data13.dbf |
15,498 | 4 | 5.13 | 1.27 | 8,761 | 2 | 5,227 | 0.08 |
| APPS_TS_TX_DATA | /oasb_data/tx_data14.dbf |
15,476 | 4 | 4.96 | 1.30 | 8,937 | 2 | 5,489 | 0.06 |
| APPS_TS_TX_DATA | /oasb_data/tx_data15.dbf |
15,288 | 4 | 5.14 | 1.29 | 9,212 | 3 | 5,831 | 0.07 |
| APPS_TS_TX_DATA | /oasb_data/tx_data16.dbf |
15,425 | 4 | 5.05 | 1.30 | 9,229 | 3 | 5,905 | 0.15 |
| APPS_TS_TX_DATA | /oasb_data/tx_data17.dbf |
15,593 | 4 | 5.05 | 1.28 | 9,023 | 3 | 3,983 | 0.18 |
| APPS_TS_TX_DATA | /oasb_data/tx_data18.dbf |
15,318 | 4 | 4.92 | 1.29 | 9,009 | 2 | 4,499 | 0.15 |
| APPS_TS_TX_DATA | /oasb_data/tx_data19.dbf |
15,300 | 4 | 5.08 | 1.28 | 8,549 | 2 | 5,054 | 0.18 |
| APPS_TS_TX_DATA | /oasb_data/tx_data2.dbf |
642 | 0 | 3.32 | 2.19 | 7,897 | 2 | 5,561 | 0.49 |
| APPS_TS_TX_DATA | /oasb_data/tx_data20.dbf |
15,440 | 4 | 4.92 | 1.29 | 8,654 | 2 | 5,017 | 0.12 |
| APPS_TS_TX_DATA | /oasb_data/tx_data21.dbf |
15,273 | 4 | 5.17 | 1.28 | 8,795 | 2 | 5,677 | 0.18 |
| APPS_TS_TX_DATA | /oasb_data/tx_data3.dbf |
1,044 | 0 | 3.14 | 1.68 | 7,750 | 2 | 5,476 | 0.53 |
| APPS_TS_TX_DATA | /oasb_data/tx_data4.dbf |
1,250 | 0 | 2.98 | 1.61 | 8,051 | 2 | 4,531 | 0.34 |
| APPS_TS_TX_DATA | /oasb_data/tx_data5.dbf |
3,628 | 1 | 4.98 | 1.32 | 7,319 | 2 | 4,558 | 0.38 |
| APPS_TS_TX_DATA | /oasb_data/tx_data6.dbf |
1,293 | 0 | 3.34 | 1.59 | 7,515 | 2 | 4,690 | 0.40 |
| APPS_TS_TX_DATA | /oasb_data/tx_data7.dbf |
3,406 | 1 | 4.43 | 1.24 | 7,059 | 2 | 4,842 | 0.53 |
| APPS_TS_TX_DATA | /oasb_data/tx_data8.dbf |
1,029 | 0 | 3.29 | 1.59 | 8,113 | 2 | 6,704 | 0.31 |
| APPS_TS_TX_DATA | /oasb_data/tx_data9.dbf |
1,138 | 0 | 3.15 | 1.54 | 7,006 | 2 | 5,769 | 0.29 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx1.dbf |
571 | 0 | 4.69 | 1.00 | 4,920 | 1 | 2,344 | 0.49 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx10.dbf |
641 | 0 | 5.77 | 1.06 | 13,176 | 4 | 1,768 | 0.55 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx11.dbf |
1,073 | 0 | 4.67 | 1.10 | 11,075 | 3 | 3,167 | 1.12 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx12.dbf |
12,652 | 4 | 5.39 | 1.51 | 13,587 | 4 | 5,647 | 0.15 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx13.dbf |
12,768 | 4 | 5.52 | 1.48 | 12,894 | 4 | 5,938 | 0.21 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx14.dbf |
12,700 | 4 | 5.50 | 1.38 | 12,445 | 3 | 5,169 | 0.20 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx15.dbf |
12,725 | 4 | 5.49 | 1.35 | 12,170 | 3 | 5,916 | 0.22 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx16.dbf |
12,675 | 4 | 5.38 | 1.44 | 11,592 | 3 | 5,000 | 0.18 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx17.dbf |
12,548 | 3 | 5.52 | 1.39 | 11,997 | 3 | 4,891 | 0.16 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx18.dbf |
12,395 | 3 | 5.48 | 1.51 | 11,403 | 3 | 4,990 | 0.19 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx19.dbf |
12,539 | 3 | 5.64 | 1.55 | 11,798 | 3 | 4,993 | 0.17 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx2.dbf |
736 | 0 | 4.99 | 1.07 | 8,973 | 2 | 7,865 | 0.39 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx20.dbf |
12,268 | 3 | 5.49 | 1.53 | 11,202 | 3 | 5,612 | 0.17 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx21.dbf |
12,414 | 3 | 5.62 | 1.50 | 11,036 | 3 | 5,603 | 0.15 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx3.dbf |
1,123 | 0 | 5.26 | 1.25 | 10,241 | 3 | 1,972 | 0.61 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx4.dbf |
1,591 | 0 | 5.21 | 1.36 | 9,133 | 3 | 2,089 | 0.65 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx5.dbf |
1,524 | 0 | 6.10 | 1.37 | 8,360 | 2 | 2,182 | 0.60 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx6.dbf |
1,508 | 0 | 5.58 | 1.41 | 8,235 | 2 | 1,944 | 0.35 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx7.dbf |
1,454 | 0 | 5.79 | 1.41 | 7,540 | 2 | 3,306 | 0.41 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx8.dbf |
1,384 | 0 | 5.53 | 1.39 | 8,778 | 2 | 3,807 | 0.42 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx9.dbf |
1,388 | 0 | 5.94 | 1.38 | 7,010 | 2 | 2,784 | 0.39 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte.dbf |
468 | 0 | 5.34 | 2.53 | 7,240 | 2 | 819 | 0.32 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte2.dbf |
79 | 0 | 8.99 | 1.80 | 5,113 | 1 | 555 | 0.07 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte3.dbf |
53 | 0 | 6.98 | 1.96 | 4,698 | 1 | 527 | 0.02 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte4.dbf |
74 | 0 | 7.30 | 1.74 | 4,861 | 1 | 557 | 0.02 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte5.dbf |
63 | 0 | 6.83 | 2.05 | 4,402 | 1 | 434 | 0.02 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte6.dbf |
83 | 0 | 7.71 | 1.82 | 4,499 | 1 | 290 | 0.00 |
| APPS_UNDOTS1 | /oasb_data/undo01.dbf |
3 | 0 | 10.00 | 1.00 | 39,067 | 11 | 23,108 | 0.04 |
| APPS_UNDOTS1 | /oasb_data/undo02.dbf |
5 | 0 | 8.00 | 1.00 | 41,658 | 12 | 26,757 | 0.04 |
| APPS_UNDOTS1 | /oasb_data/undo03.dbf |
3 | 0 | 13.33 | 1.00 | 38,343 | 11 | 27,853 | 0.04 |
| APPS_UNDOTS1 | /oasb_data/undo04.dbf |
8 | 0 | 10.00 | 1.00 | 40,546 | 11 | 32,879 | 0.10 |
| APPS_UNDOTS1 | /oasb_data/undo05.dbf |
13 | 0 | 9.23 | 1.00 | 40,910 | 11 | 29,676 | 0.05 |
| APPS_UNDOTS1 | /oasb_data/undo06.dbf |
15 | 0 | 7.33 | 1.00 | 40,259 | 11 | 28,465 | 0.05 |
| APPS_UNDOTS1 | /oasb_data/undo07.dbf |
19 | 0 | 5.26 | 1.00 | 41,709 | 12 | 23,405 | 0.05 |
| APPS_UNDOTS1 | /oasb_data/undo08.dbf |
12 | 0 | 6.67 | 1.00 | 44,106 | 12 | 23,824 | 0.07 |
| APPS_UNDOTS1 | /oasb_data/undo09.dbf |
12 | 0 | 4.17 | 1.00 | 43,585 | 12 | 24,349 | 0.05 |
| APPS_UNDOTS1 | /oracle/visdata/undo10.dbf |
10 | 0 | 4.00 | 1.00 | 41,444 | 11 | 21,137 | 0.05 |
| CTXSYS | /oasb_data/ctx1.dbf |
68 | 0 | 5.88 | 1.71 | 522 | 0 | 0 | 0.00 |
| CTXSYS | /oasb_data/ctx2.dbf |
131 | 0 | 7.25 | 1.06 | 3,974 | 1 | 0 | 0.00 |
| ODM | /oasb_data/odm.dbf |
7 | 0 | 4.29 | 1.00 | 3 | 0 | 0 | 0.00 |
| OLAP | /oasb_data/olap.dbf |
7 | 0 | 1.43 | 1.00 | 3 | 0 | 0 | 0.00 |
| OWAPUB | /oasb_data/owa1.dbf |
7 | 0 | 5.71 | 1.00 | 3 | 0 | 0 | 0.00 |
| PORTAL | /oasb_data/portal.dbf |
7 | 0 | 4.29 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYNCSERVER | /oasb_data/mobile01.dbf |
7 | 0 | 2.86 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYSAUX | /oasb_data/sysaux01.dbf |
190 | 0 | 3.26 | 1.74 | 76 | 0 | 0 | 0.00 |
| SYSAUX | /oasb_data/sysaux02.dbf |
346 | 0 | 3.15 | 1.90 | 560 | 0 | 0 | 0.00 |
| SYSTEM | /oasb_data/sys1.dbf |
999 | 0 | 5.24 | 1.67 | 501 | 0 | 76 | 3.42 |
| SYSTEM | /oasb_data/sys2.dbf |
1,186 | 0 | 5.02 | 1.48 | 584 | 0 | 139 | 4.53 |
| SYSTEM | /oasb_data/sys3.dbf |
1,035 | 0 | 4.71 | 1.48 | 725 | 0 | 156 | 3.59 |
| SYSTEM | /oasb_data/sys4.dbf |
1,208 | 0 | 5.07 | 1.41 | 869 | 0 | 142 | 3.87 |
| SYSTEM | /oasb_data/sys5.dbf |
1,075 | 0 | 4.79 | 1.51 | 954 | 0 | 77 | 3.77 |
| SYSTEM | /oasb_data/sys6.dbf |
1,097 | 0 | 4.95 | 1.53 | 821 | 0 | 292 | 1.20 |
| SYSTEM | /oasb_data/sys7.dbf |
979 | 0 | 5.10 | 1.58 | 541 | 0 | 80 | 2.38 |
| SYSTEM | /oasb_data/sys8.dbf |
78 | 0 | 4.62 | 1.00 | 108 | 0 | 4,946 | 0.08 |
| SYSTEM | /oasb_data/sys9.dbf |
52 | 0 | 5.00 | 1.08 | 195 | 0 | 1,394 | 0.11 |
| TEMP | /oracle/visdata/temp1.dbf |
179 | 0 | 4.02 | 3.41 | 2,509 | 1 | 47 | 5.74 |
| TEMP | /oracle/visdata/temp2.dbf |
230 | 0 | 4.87 | 4.73 | 2,534 | 1 | 21 | 4.76 |
| TEMP | /oracle/visdata/temp3.dbf |
443 | 0 | 3.45 | 6.35 | 2,651 | 1 | 12 | 15.00 |
| TEMP | /oracle/visdata/temp4.dbf |
119 | 0 | 5.97 | 1.00 | 2,478 | 1 | 8 | 3.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,008,685 | 100 | 2,082,171,005 | 554,536 | 3,822,412 | 0 | 0 | 807,944 |
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 | 135 | 55790 | 671243 | 2493918 | 47178000 | 2493918 | |
| E | 180 | 154 | 74108 | 868901 | 5728448 | 47178000 | 5728448 | |
Back to Advisory Statistics
Back to Top
|
