|
|
|
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 | 27-Dec-07 17:46:59 | 4740 | 165.7 |
| End Snap: | 57 | 27-Dec-07 18:47:06 | 4706 | 173.8 |
| Elapsed: | | 60.13 (mins) | | |
| DB Time: | | 654.40 (mins) | | |
Report Summary
Cache Sizes
| Begin | End | | |
|---|
| Buffer Cache: | 16,272M | 16,272M | Std Block Size: | 8K |
| Shared Pool Size: | 3,008M | 3,008M | Log Buffer: | 16,640K |
Load Profile
| Per Second | Per Transaction |
|---|
| Redo size: | 9,551,197.40 | 29,947.68 |
| Logical reads: | 539,578.07 | 1,691.84 |
| Block changes: | 55,164.58 | 172.97 |
| Physical reads: | 152.85 | 0.48 |
| Physical writes: | 1,010.36 | 3.17 |
| User calls: | 12,417.84 | 38.94 |
| Parses: | 4,531.33 | 14.21 |
| Hard parses: | 2.35 | 0.01 |
| Sorts: | 3,382.50 | 10.61 |
| Logons: | 2.77 | 0.01 |
| Executes: | 31,049.68 | 97.36 |
| Transactions: | 318.93 | |
| % Blocks changed per Read: | 10.22 | Recursive Call %: | 81.80 |
| Rollback per transaction %: | 20.78 | Rows per Sort: | 11.89 |
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.41 | Latch Hit %: | 98.58 |
| Parse CPU to Parse Elapsd %: | 88.06 | % Non-Parse CPU: | 97.22 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 68.44 | 84.91 |
| % SQL with executions>1: | 82.56 | 80.20 |
| % Memory for SQL w/exec>1: | 60.22 | 54.33 |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|
| CPU time | | 36,116 | | 92.0 | |
| db file sequential read | 365,581 | 1,755 | 5 | 4.5 | User I/O |
| log file sync | 455,003 | 538 | 1 | 1.4 | Commit |
| log file parallel write | 867,343 | 516 | 1 | 1.3 | System I/O |
| SQL*Net more data from client | 1,871,620 | 508 | 0 | 1.3 | Network |
Main Report
Back to Top
Wait Events Statistics
Back to Top
Time Model Statistics
- Total time in database user-calls (DB Time): 39263.7s
- 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 | 36,116.23 | 91.98 |
| sql execute elapsed time | 34,637.93 | 88.22 |
| PL/SQL execution elapsed time | 7,650.56 | 19.49 |
| inbound PL/SQL rpc elapsed time | 7,061.29 | 17.98 |
| Java execution elapsed time | 1,370.99 | 3.49 |
| parse time elapsed | 1,202.28 | 3.06 |
| hard parse elapsed time | 569.11 | 1.45 |
| repeated bind elapsed time | 81.33 | 0.21 |
| sequence load elapsed time | 17.87 | 0.05 |
| connection management call elapsed time | 16.74 | 0.04 |
| PL/SQL compilation elapsed time | 10.97 | 0.03 |
| hard parse (sharing criteria) elapsed time | 6.25 | 0.02 |
| failed parse elapsed time | 2.59 | 0.01 |
| hard parse (bind mismatch) elapsed time | 1.39 | 0.00 |
| DB time | 39,263.72 | |
| background elapsed time | 1,845.55 | |
| background cpu time | 870.13 | |
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 | 417,686 | 0.00 | 1,970 | 5 | 0.36 |
| System I/O | 982,000 | 0.00 | 639 | 1 | 0.85 |
| Network | 50,555,476 | 0.00 | 563 | 0 | 43.94 |
| Commit | 455,003 | 0.00 | 538 | 1 | 0.40 |
| Application | 68,516 | 0.20 | 515 | 8 | 0.06 |
| Concurrency | 3,700,005 | 0.11 | 483 | 0 | 3.22 |
| Other | 149,351 | 34.20 | 92 | 1 | 0.13 |
| Configuration | 5,738 | 0.00 | 2 | 0 | 0.00 |
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 | 365,581 | 0.00 | 1,755 | 5 | 0.32 |
| log file sync | 455,003 | 0.00 | 538 | 1 | 0.40 |
| log file parallel write | 867,343 | 0.00 | 516 | 1 | 0.75 |
| SQL*Net more data from client | 1,871,620 | 0.00 | 508 | 0 | 1.63 |
| enq: TM - contention | 116 | 78.45 | 323 | 2783 | 0.00 |
| enq: TX - index contention | 53,530 | 0.00 | 173 | 3 | 0.05 |
| db file scattered read | 26,473 | 0.00 | 155 | 6 | 0.02 |
| latch: cache buffers chains | 2,819,429 | 0.00 | 139 | 0 | 2.45 |
| enq: UL - contention | 2,211 | 1.58 | 121 | 55 | 0.00 |
| db file parallel write | 111,352 | 0.00 | 115 | 1 | 0.10 |
| cursor: pin S wait on X | 4,444 | 93.77 | 78 | 17 | 0.00 |
| read by other session | 23,327 | 0.00 | 56 | 2 | 0.02 |
| buffer busy waits | 799,267 | 0.00 | 51 | 0 | 0.69 |
| enq: TX - row lock contention | 456 | 2.41 | 45 | 99 | 0.00 |
| SQL*Net more data to client | 1,590,172 | 0.00 | 35 | 0 | 1.38 |
| PX Deq Credit: send blkd | 22,666 | 0.00 | 34 | 2 | 0.02 |
| library cache load lock | 927 | 0.00 | 28 | 31 | 0.00 |
| SQL*Net message to client | 47,093,684 | 0.00 | 20 | 0 | 40.93 |
| rdbms ipc reply | 9 | 77.78 | 16 | 1759 | 0.00 |
| SQL*Net break/reset to client | 65,700 | 0.00 | 14 | 0 | 0.06 |
| enq: RO - fast object reuse | 33 | 3.03 | 12 | 357 | 0.00 |
| kksfbc child completion | 189 | 84.66 | 9 | 47 | 0.00 |
| wait list latch free | 393 | 0.00 | 8 | 20 | 0.00 |
| os thread startup | 77 | 0.00 | 6 | 73 | 0.00 |
| control file sequential read | 1,576 | 0.00 | 5 | 3 | 0.00 |
| Streams AQ: qmn coordinator waiting for slave to start | 2 | 50.00 | 5 | 2453 | 0.00 |
| PX Deq: Signal ACK | 421 | 23.52 | 4 | 10 | 0.00 |
| local write wait | 1,213 | 0.00 | 4 | 3 | 0.00 |
| latch: library cache | 6,011 | 0.00 | 3 | 1 | 0.01 |
| latch: object queue header operation | 27,620 | 0.00 | 3 | 0 | 0.02 |
| latch: undo global data | 3,322 | 0.00 | 3 | 1 | 0.00 |
| control file parallel write | 1,729 | 0.00 | 3 | 2 | 0.00 |
| enq: TX - contention | 3,311 | 0.00 | 2 | 1 | 0.00 |
| enq: DV - contention | 230 | 0.00 | 2 | 7 | 0.00 |
| latch free | 2,160 | 0.00 | 2 | 1 | 0.00 |
| latch: In memory undo latch | 10,422 | 0.00 | 1 | 0 | 0.01 |
| buffer deadlock | 48,666 | 99.30 | 1 | 0 | 0.04 |
| library cache lock | 13 | 0.00 | 1 | 94 | 0.00 |
| enq: HW - contention | 2,410 | 0.00 | 1 | 0 | 0.00 |
| latch: cache buffers lru chain | 372 | 0.00 | 1 | 3 | 0.00 |
| LGWR wait for redo copy | 30,871 | 0.01 | 1 | 0 | 0.03 |
| latch: library cache pin | 1,561 | 0.00 | 1 | 1 | 0.00 |
| enq: SQ - contention | 3,000 | 0.00 | 1 | 0 | 0.00 |
| latch: redo allocation | 1,655 | 0.00 | 1 | 0 | 0.00 |
| enq: TX - allocate ITL entry | 238 | 0.00 | 1 | 2 | 0.00 |
| row cache lock | 1,060 | 0.00 | 0 | 0 | 0.00 |
| latch: row cache objects | 579 | 0.00 | 0 | 1 | 0.00 |
| cursor: pin S | 2,716 | 0.00 | 0 | 0 | 0.00 |
| latch: session allocation | 935 | 0.00 | 0 | 0 | 0.00 |
| enq: FB - contention | 758 | 0.00 | 0 | 0 | 0.00 |
| library cache pin | 1,698 | 0.00 | 0 | 0 | 0.00 |
| latch: object queue header heap | 78 | 0.00 | 0 | 1 | 0.00 |
| latch: shared pool | 349 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache lock | 185 | 0.00 | 0 | 0 | 0.00 |
| direct path read | 608 | 0.00 | 0 | 0 | 0.00 |
| latch: messages | 119 | 0.00 | 0 | 0 | 0.00 |
| reliable message | 36 | 0.00 | 0 | 1 | 0.00 |
| enq: CU - contention | 4 | 0.00 | 0 | 7 | 0.00 |
| latch: cache buffer handles | 216 | 0.00 | 0 | 0 | 0.00 |
| L1 validation | 1 | 100.00 | 0 | 22 | 0.00 |
| write complete waits | 5 | 0.00 | 0 | 4 | 0.00 |
| PX qref latch | 2,523 | 98.22 | 0 | 0 | 0.00 |
| cursor: pin X | 1 | 100.00 | 0 | 12 | 0.00 |
| latch: redo writing | 85 | 0.00 | 0 | 0 | 0.00 |
| enq: PS - contention | 40 | 0.00 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 10 | 0.00 | 0 | 1 | 0.00 |
| cursor: mutex S | 138 | 0.00 | 0 | 0 | 0.00 |
| cursor: mutex X | 315 | 0.00 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 20 | 0.00 | 0 | 0 | 0.00 |
| latch: parallel query alloc buffer | 6 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 440 | 0.00 | 0 | 0 | 0.00 |
| enq: US - contention | 1 | 0.00 | 0 | 0 | 0.00 |
| direct path write temp | 38 | 0.00 | 0 | 0 | 0.00 |
| direct path read temp | 6 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net message from client | 47,093,712 | 0.00 | 9,091,630 | 193 | 40.93 |
| pipe get | 26,901 | 16.14 | 21,176 | 787 | 0.02 |
| Streams AQ: qmn slave idle wait | 2,305 | 0.04 | 12,755 | 5534 | 0.00 |
| Streams AQ: waiting for messages in the queue | 2,386 | 100.00 | 11,692 | 4900 | 0.00 |
| PX Idle Wait | 3,398 | 77.22 | 5,668 | 1668 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 1,650 | 31.94 | 3,514 | 2130 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 2,629 | 41.12 | 3,496 | 1330 | 0.00 |
| PL/SQL lock timer | 272 | 99.63 | 2,985 | 10973 | 0.00 |
| jobq slave wait | 708 | 91.81 | 2,035 | 2874 | 0.00 |
| PX Deq: Execution Msg | 12,527 | 0.00 | 120 | 10 | 0.01 |
| PX Deq: Msg Fragment | 9,091 | 0.00 | 4 | 0 | 0.01 |
| PX Deq: Execute Reply | 4,812 | 0.00 | 4 | 1 | 0.00 |
| PX Deq Credit: need buffer | 3,399 | 0.00 | 4 | 1 | 0.00 |
| PX Deq: Table Q Normal | 7,783 | 0.00 | 3 | 0 | 0.01 |
| PX Deq: Join ACK | 569 | 0.00 | 0 | 1 | 0.00 |
| PX Deq: Parse Reply | 325 | 0.00 | 0 | 1 | 0.00 |
| class slave wait | 3 | 0.00 | 0 | 2 | 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 | 867,347 | 0.00 | 516 | 1 | 0.75 |
| db file parallel write | 111,352 | 0.00 | 115 | 1 | 0.10 |
| events in waitclass Other | 45,668 | 0.01 | 8 | 0 | 0.04 |
| db file scattered read | 1,193 | 0.00 | 5 | 4 | 0.00 |
| control file sequential read | 821 | 0.00 | 5 | 6 | 0.00 |
| os thread startup | 61 | 0.00 | 4 | 74 | 0.00 |
| db file sequential read | 1,114 | 0.00 | 4 | 3 | 0.00 |
| control file parallel write | 1,729 | 0.00 | 3 | 2 | 0.00 |
| direct path read | 608 | 0.00 | 0 | 0 | 0.00 |
| latch: redo writing | 85 | 0.00 | 0 | 0 | 0.00 |
| buffer busy waits | 11 | 0.00 | 0 | 1 | 0.00 |
| latch: cache buffers chains | 25 | 0.00 | 0 | 0 | 0.00 |
| log file sync | 2 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 333 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache | 1 | 0.00 | 0 | 0 | 0.00 |
| rdbms ipc message | 2,175,416 | 0.50 | 36,834 | 17 | 1.89 |
| Streams AQ: qmn slave idle wait | 1,867 | 0.00 | 10,226 | 5477 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 1,650 | 31.94 | 3,514 | 2130 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 2,629 | 41.12 | 3,496 | 1330 | 0.00 |
| smon timer | 102,733 | 0.00 | 3,474 | 34 | 0.09 |
| pmon timer | 1,452 | 80.37 | 3,419 | 2355 | 0.00 |
| class slave wait | 1 | 0.00 | 0 | 2 | 0.00 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
| Statistic | Total |
|---|
| AVG_BUSY_TIME | 166,547 |
| AVG_IDLE_TIME | 194,006 |
| AVG_IOWAIT_TIME | 7,875 |
| AVG_SYS_TIME | 10,699 |
| AVG_USER_TIME | 155,735 |
| BUSY_TIME | 3,999,849 |
| IDLE_TIME | 4,658,935 |
| IOWAIT_TIME | 191,727 |
| SYS_TIME | 259,534 |
| USER_TIME | 3,740,315 |
| LOAD | 0 |
| OS_CPU_WAIT_TIME | 138,852,100 |
| RSRC_MGR_CPU_WAIT_TIME | 0 |
| VM_IN_BYTES | 413,688 |
| 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 | 39,279.50 | 36,125.90 | 545,456 | 1,944,265,005 |
| SYS$BACKGROUND | 0.00 | 0.00 | 6,336 | 2,979,455 |
| 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 |
414438 | 196142 | 3699969 | 47823 | 0 | 0 | 50540188 | 56252 |
| SYS$BACKGROUND |
3250 | 876 | 98 | 450 | 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 |
|---|
| 3,897 | 3,888 | 8 | 487.14 | 9.93 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 2,211 | 2,216 | 10 | 221.06 | 5.63 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 1,498 | 1,484 | 12 | 124.82 | 3.81 | 1g4jfpxpupdt6 |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 1,350 | 1,348 | 299 | 4.52 | 3.44 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 1,082 | 1,066 | 16 | 67.65 | 2.76 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 958 | 934 | 137,477 | 0.01 | 2.44 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 690 | 687 | 140,771 | 0.00 | 1.76 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 657 | 636 | 101,266 | 0.01 | 1.67 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 609 | 603 | 1,296 | 0.47 | 1.55 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 595 | 586 | 63,101 | 0.01 | 1.51 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 533 | 532 | 984 | 0.54 | 1.36 | 0qcpgw43yqj5r |
WSHPSRS
|
( SELECT DISTINCT WDD.SOURCE_L... |
| 494 | 479 | 56,480 | 0.01 | 1.26 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 487 | 463 | 56,500 | 0.01 | 1.24 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 472 | 471 | 338,128 | 0.00 | 1.20 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 448 | 440 | 5,405 | 0.08 | 1.14 | a957tvxz9w038 |
icx.por.req.server.RequisitionAM
|
BEGIN :1 := por_util_pkg.inter... |
| 447 | 446 | 11 | 40.60 | 1.14 | 1du9v021t8m46 |
ARGLTP
|
insert into gl_interface(creat... |
| 445 | 422 | 5,000 | 0.09 | 1.13 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 442 | 427 | 56,476 | 0.01 | 1.13 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 415 | 394 | 171,683 | 0.00 | 1.06 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 414 | 404 | 8 | 51.80 | 1.06 | 8vmj377jqyqwq |
WSHASCSRS
|
BEGIN WSH_BATCH_PROCESS.CONFIR... |
| 402 | 380 | 171,685 | 0.00 | 1.02 | gf1u933c95jb5 |
INVTTMTX
|
DECLARE
l_ret_stat varchar2... |
| 395 | 355 | 185,008 | 0.00 | 1.00 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
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 |
|---|
| 3,888 | 3,897 | 8 | 486.02 | 9.93 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 2,216 | 2,211 | 10 | 221.62 | 5.63 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 1,484 | 1,498 | 12 | 123.65 | 3.81 | 1g4jfpxpupdt6 |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 1,348 | 1,350 | 299 | 4.51 | 3.44 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 1,066 | 1,082 | 16 | 66.62 | 2.76 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 934 | 958 | 137,477 | 0.01 | 2.44 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 687 | 690 | 140,771 | 0.00 | 1.76 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 636 | 657 | 101,266 | 0.01 | 1.67 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 603 | 609 | 1,296 | 0.47 | 1.55 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 586 | 595 | 63,101 | 0.01 | 1.51 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 532 | 533 | 984 | 0.54 | 1.36 | 0qcpgw43yqj5r |
WSHPSRS
|
( SELECT DISTINCT WDD.SOURCE_L... |
| 479 | 494 | 56,480 | 0.01 | 1.26 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 471 | 472 | 338,128 | 0.00 | 1.20 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 463 | 487 | 56,500 | 0.01 | 1.24 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 446 | 447 | 11 | 40.57 | 1.14 | 1du9v021t8m46 |
ARGLTP
|
insert into gl_interface(creat... |
| 440 | 448 | 5,405 | 0.08 | 1.14 | a957tvxz9w038 |
icx.por.req.server.RequisitionAM
|
BEGIN :1 := por_util_pkg.inter... |
| 427 | 442 | 56,476 | 0.01 | 1.13 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 422 | 445 | 5,000 | 0.08 | 1.13 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 404 | 414 | 8 | 50.45 | 1.06 | 8vmj377jqyqwq |
WSHASCSRS
|
BEGIN WSH_BATCH_PROCESS.CONFIR... |
| 394 | 415 | 171,683 | 0.00 | 1.06 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 380 | 402 | 171,685 | 0.00 | 1.02 | gf1u933c95jb5 |
INVTTMTX
|
DECLARE
l_ret_stat varchar2... |
| 355 | 395 | 185,008 | 0.00 | 1.00 | 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: 1,946,676,812
- Captured SQL account for 24.2% of Total
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 276,115,411 | 8 | 34,514,426.38 | 14.18 | 3888.20 | 3897.12 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 170,656,737 | 10 | 17,065,673.70 | 8.77 | 2216.17 | 2210.59 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 134,957,197 | 12 | 11,246,433.08 | 6.93 | 1483.83 | 1497.84 | 1g4jfpxpupdt6 |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 114,754,452 | 16 | 7,172,153.25 | 5.89 | 1065.99 | 1082.46 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 82,233,640 | 984 | 83,570.77 | 4.22 | 532.48 | 532.89 | 0qcpgw43yqj5r |
WSHPSRS
|
( SELECT DISTINCT WDD.SOURCE_L... |
| 48,840,959 | 11 | 4,440,087.18 | 2.51 | 446.30 | 446.60 | 1du9v021t8m46 |
ARGLTP
|
insert into gl_interface(creat... |
| 47,508,766 | 299 | 158,892.19 | 2.44 | 1348.23 | 1350.00 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 45,569,532 | 60 | 759,492.20 | 2.34 | 275.55 | 275.56 | 3n8tvc1tsqua0 |
WSHINTERFACES
|
SELECT DISTINCT WTS.STOP_ID FR... |
| 39,989,961 | 1,525,131 | 26.22 | 2.05 | 325.29 | 343.11 | 66tmsr3446uqn |
OEXOETEL
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 39,676,939 | 63,101 | 628.78 | 2.04 | 586.23 | 594.73 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 37,035,121 | 5,000 | 7,407.02 | 1.90 | 421.67 | 444.66 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 36,867,036 | 56,476 | 652.79 | 1.89 | 427.39 | 441.73 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 36,771,039 | 56,500 | 650.81 | 1.89 | 463.11 | 486.64 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 33,104,249 | 11 | 3,009,477.18 | 1.70 | 264.57 | 264.85 | bp8crdjba8zgt |
ARGLTP
|
update ra_cust_trx_line_gl_dis... |
| 32,976,352 | 171,683 | 192.08 | 1.69 | 394.03 | 415.29 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 32,974,932 | 171,685 | 192.07 | 1.69 | 380.50 | 401.65 | gf1u933c95jb5 |
INVTTMTX
|
DECLARE
l_ret_stat varchar2... |
| 32,164,270 | 1,296 | 24,818.11 | 1.65 | 602.98 | 609.38 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 28,407,357 | 56,480 | 502.96 | 1.46 | 479.41 | 494.16 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 27,703,036 | 8,146,376 | 3.40 | 1.42 | 225.18 | 230.43 | c4y7jp0q2awbf |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_VALUE FR... |
| 27,390,224 | 137,477 | 199.23 | 1.41 | 934.17 | 958.33 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 26,384,544 | 10,000 | 2,638.45 | 1.36 | 197.15 | 361.31 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 22,335,099 | 185,008 | 120.73 | 1.15 | 355.23 | 394.57 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 20,808,793 | 151,978 | 136.92 | 1.07 | 314.78 | 314.85 | bcym7s1bp0wxs |
OEXOETEL
|
SELECT WIA.NAME FROM WF_ITEM_A... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 551,452
- Captured SQL account for 23.5% of Total
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 54,454 | 10,000 | 5.45 | 9.87 | 197.15 | 361.31 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 43,999 | 2,166 | 20.31 | 7.98 | 178.30 | 354.59 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 29,147 | 19,482 | 1.50 | 5.29 | 207.27 | 341.29 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 28,495 | 119,999 | 0.24 | 5.17 | 181.88 | 318.83 | 5qtxtsar19v4k |
PYUSLV
|
insert into pay_run_result_val... |
| 10,269 | 185,008 | 0.06 | 1.86 | 355.23 | 394.57 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 2,120 | 12 | 176.67 | 0.38 | 1483.83 | 1497.84 | 1g4jfpxpupdt6 |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 1,087 | 171,685 | 0.01 | 0.20 | 95.00 | 98.48 | 25bkagv1j2xf7 |
INVTTMTX
|
INSERT INTO MTL_MATERIAL_TRAN... |
| 702 | 63,101 | 0.01 | 0.13 | 586.23 | 594.73 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 668 | 299 | 2.23 | 0.12 | 1348.23 | 1350.00 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 665 | 8 | 83.13 | 0.12 | 4.01 | 5.90 | 6djyj1t4djs12 |
RAXMTR
|
select /*+ parallel(t, 16) par... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 112,020,295
- Captured SQL account for 28.4% of Total
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 8,146,376 | 3,263,810 | 0.40 | 0.00 | 0.00 | c4y7jp0q2awbf |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_VALUE FR... |
| 6,620,799 | 5,378,102 | 0.81 | 0.00 | 0.00 | 6cjfxb1c4kx16 |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_ID, APP... |
| 2,716,298 | 2,716,159 | 1.00 | 0.00 | 0.00 | bc7t6t6jfx2n7 |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT VERSION FROM FND_CACHE_... |
| 2,527,534 | 2,527,219 | 1.00 | 0.00 | 0.00 | 9dvfguzd15kpv |
JDBC Thin Client
|
SELECT VALUE FROM V$NLS_PARAME... |
| 1,525,131 | 788,577 | 0.52 | 0.00 | 0.00 | 66tmsr3446uqn |
OEXOETEL
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 700,686 | 339,727 | 0.48 | 0.00 | 0.00 | 4g5vzcyf68n9w |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_VALUE FR... |
| 573,713 | 246,905 | 0.43 | 0.00 | 0.00 | 0wrz2kbatczjk |
CSCCCCRC
|
SELECT EXECUTE_FLAG FROM JTF_U... |
| 536,981 | 536,970 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 453,941 | 453,925 | 1.00 | 0.00 | 0.00 | 0w785m9gmw41a |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT USERENV('SESSIONID') FR... |
| 452,721 | 265,618 | 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: 16,348,027
- Captured SQL account for 41.7% of Total
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 540,413 | 6,620,799 | 3.31 | 6cjfxb1c4kx16 |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_ID, APP... |
| 536,977 | 536,981 | 3.28 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 499,569 | 8,146,376 | 3.06 | c4y7jp0q2awbf |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_VALUE FR... |
| 338,135 | 338,128 | 2.07 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 317,878 | 317,875 | 1.94 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 271,425 | 453,941 | 1.66 | 0w785m9gmw41a |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT USERENV('SESSIONID') FR... |
| 270,205 | 452,721 | 1.65 | 5as61q63aqmts |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT A.APPLICATION_SHORT_NAM... |
| 270,204 | 2,716,298 | 1.65 | bc7t6t6jfx2n7 |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT VERSION FROM FND_CACHE_... |
| 270,203 | 452,718 | 1.65 | 29x3dahwzdj8b |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT U.USER_NAME, NVL(U.EMP... |
| 270,203 | 452,718 | 1.65 | 95pbs94n69z3d |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT NVL(MULTI_ORG_FLAG, 'N... |
| 270,202 | 270,205 | 1.65 | fhqzxap2n0ybj |
? @blade1.ebs.hp.com (TNS V1-V3)
|
select NAME from HR_OPERATING_... |
| 270,201 | 452,714 | 1.65 | bvyqm6268u2as |
? @blade1.ebs.hp.com (TNS V1-V3)
|
SELECT NODE_NAME FROM FND_NODE... |
| 260,599 | 260,599 | 1.59 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
| 185,009 | 185,008 | 1.13 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 171,685 | 171,685 | 1.05 | 6gnth2mfbs2nq |
INVTTMTX
|
declare
v_ret number := 0... |
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.37 | b3an778qn1q49 |
RAXMTR
|
select /*+ parallel(t, 16) par... |
| 9,221,664 | 8 | 0.29 | 610p9aymv2pcv |
RAXMTR
|
select /*+ parallel(t, 16) par... |
| 3,405,153 | 8 | 0.11 | 6djyj1t4djs12 |
RAXMTR
|
select /*+ parallel(t, 16) par... |
| 1,077,898 | 25,971 | 0.03 | dzt4ys8ynkyrj |
CSCCCCRC
|
INSERT INTO CS_INCIDENTS_AUDIT... |
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; |
| 3n8tvc1tsqua0 | SELECT DISTINCT WTS.STOP_ID FROM WSH_TRIP_STOPS WTS, WSH_TRIP_STOPS WTS2, WSH_DELIVERY_LEGS WDL, WSH_DELIVERY_LEGS WDL2, WSH_DELIVERY_ASSIGNMENTS WDA, WSH_DELIVERY_ASSIGNMENTS WDA2, WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_DETAILS WDD2 WHERE WTS.BATCH_ID = :B1 AND WTS.STOP_ID = WDL.PICK_UP_STOP_ID AND WDA.DELIVERY_ID = WDL.DELIVERY_ID AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND WDD.SOURCE_CODE = 'OE' AND NVL(WDD.OE_INTERFACED_FLAG, 'N') <> 'Y' AND WDD.RELEASED_STATUS <> 'D' AND WTS2.BATCH_ID = :B1 AND WTS2.STOP_ID = WDL2.PICK_UP_STOP_ID AND WDA2.DELIVERY_ID = WDL2.DELIVERY_ID AND WDA2.DELIVERY_DETAIL_ID = WDD2.DELIVERY_DETAIL_ID AND WDD2.SOURCE_LINE_ID = WDD.SOURCE_LINE_ID AND WDD2.SOURCE_CODE = 'OE' AND NVL(WDD2.OE_INTERFACED_FLAG, 'N') <> 'Y' AND WDD2.RELEASED_STATUS <> 'D' AND WTS2.STOP_ID <> WTS.STOP_ID |
| 3prk3vg9u0abb | BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END; |
| 473dq7tb653mp | declare p varchar2(32767); begin p := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); :v1 := substr(p, 1, 4000); :v2 := substr(p, 4001, 4000); :v3 := substr(p, 8001, 4000); :v4 := substr(p, 12001, 4000); :v5 := substr(p, 16001, 4000); :v6 := substr(p, 20001, 4000); :v7 := substr(p, 24001, 4000); :v8 := substr(p, 28001, 4000); :v9 := substr(p, 32001, 767); :v10 := substr(p, 4001, 1); :v11 := substr(p, 8001, 1); :v12 := substr(p, 12001, 1); :v13 := substr(p, 16001, 1); :v14 := substr(p, 20001, 1); :v15 := substr(p, 24001, 1); :v16 := substr(p, 28001, 1); :v17 := substr(p, 32001, 1); end; |
| 4g5vzcyf68n9w | SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 |
| 4yak7x2zqz0dh | BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END; |
| 5as61q63aqmts | SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE A.APPLICATION_ID = :B1 |
| 5qtxtsar19v4k | insert into pay_run_result_values(input_value_id, run_result_id, result_value, formula_result_flag) values (:b1, :b2, :b3:b4, :b5:b6) |
| 610p9aymv2pcv |
select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("COMMENTS"), count(distinct "COMMENTS"), sum(sys_op_opnsize("COMMENTS")), substrb(dump(min(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), count("INTERNAL_NOTES"), count(distinct "INTERNAL_NOTES"), sum(sys_op_opnsize("INTERNAL_NOTES")), substrb(dump(min(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), count("INITIAL_CUSTOMER_TRX_ID"), count(distinct "INITIAL_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("INITIAL_CUSTOMER_TRX_ID")), substrb(dump(min("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE_CONTEXT"), count(distinct "USSGL_TRANSACTION_CODE_CONTEXT"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE_CONTEXT")), substrb(dump(min("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE"), count(distinct "USSGL_TRANSACTION_CODE"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE")), substrb(dump(min("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), count("ACCTD_AMOUNT"), count(distinct "ACCTD_AMOUNT"), sum(sys_op_opnsize("ACCTD_AMOUNT")), su
bstrb(dump(min("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), count("CUSTOMER_BANK_ACCOUNT_ID"), count(distinct "CUSTOMER_BANK_ACCOUNT_ID"), sum(sys_op_opnsize("CUSTOMER_BANK_ACCOUNT_ID")), substrb(dump(min("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), count("CUSTOMER_BANK_ACCOUNT_NAME"), count(distinct "CUSTOMER_BANK_ACCOUNT_NAME"), sum(sys_op_opnsize("CUSTOMER_BANK_ACCOUNT_NAME")), substrb(dump(min(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), count("UOM_CODE"), count(distinct "UOM_CODE"), sum(sys_op_opnsize("UOM_CODE")), substrb(dump(min("UOM_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_CODE"), 16, 0, 32), 1, 120), count("UOM_NAME"), count(distinct "UOM_NAME"), sum(sys_op_opnsize("UOM_NAME")), substrb(dump(min("UOM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_NAME"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER_SEQUENCE_ID"), count(distinct "DOCUMENT_NUMBER_SEQUENCE_ID"), sum(sys_op_opnsize("DOCUMENT_NUMBER_SEQUENCE_ID")), substrb(dump(min("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE10"), count(distinct "LINK_TO_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE10")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32),
1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE11"), count(distinct "LINK_TO_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE11")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE12"), count(distinct "LINK_TO_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE12")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE13"), count(distinct "LINK_TO_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE13")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE14"), count(distinct "LINK_TO_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE14")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE15"), count(distinct "LINK_TO_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE15")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE8"), count(distinct "LINK_TO_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("LINK_TO_LINE_ATT
RIBUTE8")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE9"), count(distinct "LINK_TO_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE9")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE10"), count(distinct "REFERENCE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE10")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE11"), count(distinct "REFERENCE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE11")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE12"), count(distinct "REFERENCE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE12")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE13"), count(distinct "REFERENCE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE13")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("REFE
RENCE_LINE_ATTRIBUTE14"), count(distinct "REFERENCE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE14")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE15"), count(distinct "REFERENCE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE15")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE8"), count(distinct "REFERENCE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE8")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE9"), count(distinct "REFERENCE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE9")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE
_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE12"), count(distinct "INTERFACE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ID"), sum(sys_op_opnsize("INTERFACE_LINE_ID")), substrb(dump(min("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_CONTEXT"), count(distinct "INTERFACE_LINE_CONTEXT"), sum(sys_op_opnsize("INTERFACE_LINE_CONTEXT")), substrb(dump(min("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE1"), count(distinct "INTERFACE_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE1")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE2"), count(distinct "INTERFACE_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE2")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE3"), count(distinct "INTERFACE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE3")), substrb(du
mp(min("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE4"), count(distinct "INTERFACE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE4")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE5"), count(distinct "INTERFACE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE5")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE6"), count(distinct "INTERFACE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE6")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE7"), count(distinct "INTERFACE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE7")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE8"), count(distinct "INTERFACE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE8")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count(distinct "BATCH_SOURCE_NAME"), su
m(sys_op_opnsize("BATCH_SOURCE_NAME")), substrb(dump(min(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("SET_OF_BOOKS_ID"), count(distinct "SET_OF_BOOKS_ID"), sum(sys_op_opnsize("SET_OF_BOOKS_ID")), substrb(dump(min("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), count(distinct "LINE_TYPE"), sum(sys_op_opnsize("LINE_TYPE")), substrb(dump(min("LINE_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_TYPE"), 16, 0, 32), 1, 120), count(distinct "DESCRIPTION"), sum(sys_op_opnsize("DESCRIPTION")), substrb(dump(min(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count(distinct "CURRENCY_CODE"), sum(sys_op_opnsize("CURRENCY_CODE")), substrb(dump(min("CURRENCY_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("CURRENCY_CODE"), 16, 0, 32), 1, 120), count("AMOUNT"), count(distinct "AMOUNT"), sum(sys_op_opnsize("AMOUNT")), substrb(dump(min("AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT"), 16, 0, 32), 1, 120), count("CUST_TRX_TYPE_NAME"), count(distinct "CUST_TRX_TYPE_NAME"), sum(sys_op_opnsize("CUST_TRX_TYPE_NAME")), substrb(dump(min("CUST_TRX_TYPE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("CUST_TRX_TYPE_NAME"), 16, 0, 32), 1, 120), count("CUST_TRX_TYPE_ID"), count(distinct "CUST_TRX_TYPE_ID"), sum(sys_op_opnsize("CUST_TRX_TYPE_ID")), substrb(dump(min("CUST_TRX
_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUST_TRX_TYPE_ID"), 16, 0, 32), 1, 120), count("TERM_NAME"), count(distinct "TERM_NAME"), sum(sys_op_opnsize("TERM_NAME")), substrb(dump(min("TERM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("TERM_NAME"), 16, 0, 32), 1, 120), count("TERM_ID"), count(distinct "TERM_ID"), sum(sys_op_opnsize("TERM_ID")), substrb(dump(min("TERM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TERM_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BATCH_NAME"), count(distinct "ORIG_SYSTEM_BATCH_NAME"), sum(sys_op_opnsize("ORIG_SYSTEM_BATCH_NAME")), substrb(dump(min(substrb("ORIG_SYSTEM_BATCH_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BATCH_NAME", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_BILL_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_BILL_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_REF"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_REF")), substrb(dump(min(su
bstrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_REF"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_ID"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_SHIP_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_SHIP_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CUSTOMER_ID")), substrb(dump(min("
ORIG_SYSTEM_SHIP_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_ADDRESS_REF"), count(distinct "ORIG_SYSTEM_SHIP_ADDRESS_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_ADDRESS_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_SHIP_ADDRESS_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_ADDRESS_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CONTACT_REF"), count(distinct "ORIG_SYSTEM_SHIP_CONTACT_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CONTACT_ID"), count(distinct "ORIG_SYSTEM_SHIP_CONTACT_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_CONTACT_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SOLD_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_SOLD_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SOLD_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SOLD_CUSTOMER
_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SOLD_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_SOLD_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SOLD_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ID"), count(distinct "LINK_TO_LINE_ID"), sum(sys_op_opnsize("LINK_TO_LINE_ID")), substrb(dump(min("LINK_TO_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_CONTEXT"), count(distinct "LINK_TO_LINE_CONTEXT"), sum(sys_op_opnsize("LINK_TO_LINE_CONTEXT")), substrb(dump(min("LINK_TO_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE1"), count(distinct "LINK_TO_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE1")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE2"), count(distinct "LINK_TO_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE2")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE3"), count(distinct "LINK_TO_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE3
")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE4"), count(distinct "LINK_TO_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE4")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE5"), count(distinct "LINK_TO_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE5")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE6"), count(distinct "LINK_TO_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE6")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE7"), count(distinct "LINK_TO_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE7")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("RECEIPT_METHOD_NAME"), count(distinct "RECEIPT_METHOD_NAME"), sum(sys_op_opnsize("RECEIPT_METHOD_NAME")), substrb(dump(min("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), count("RECEIPT_METHOD_ID"), count(distinct "RECEIPT_METHOD_ID"), sum(sys_op_opnsize("RECEIPT_METHO
D_ID")), substrb(dump(min("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), count(distinct "CONVERSION_TYPE"), sum(sys_op_opnsize("CONVERSION_TYPE")), substrb(dump(min("CONVERSION_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_TYPE"), 16, 0, 32), 1, 120), count("CONVERSION_DATE"), count(distinct "CONVERSION_DATE"), substrb(dump(min("CONVERSION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_DATE"), 16, 0, 32), 1, 120), count("CONVERSION_RATE"), count(distinct "CONVERSION_RATE"), sum(sys_op_opnsize("CONVERSION_RATE")), substrb(dump(min("CONVERSION_RATE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_RATE"), 16, 0, 32), 1, 120), count("CUSTOMER_TRX_ID"), count(distinct "CUSTOMER_TRX_ID"), sum(sys_op_opnsize("CUSTOMER_TRX_ID")), substrb(dump(min("CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("TRX_DATE"), count(distinct "TRX_DATE"), substrb(dump(min("TRX_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("TRX_DATE"), 16, 0, 32), 1, 120), count("GL_DATE"), count(distinct "GL_DATE"), substrb(dump(min("GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("GL_DATE"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER"), count(distinct "DOCUMENT_NUMBER"), sum(sys_op_opnsize("DOCUMENT_NUMBER")), substrb(dump(min("DOCUMENT_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER"), 16, 0, 32), 1, 120), count("TRX_NUMBER"), count(distinct "TRX_NUMBER"), sum(sys
_op_opnsize("TRX_NUMBER")), substrb(dump(min("TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("TRX_NUMBER"), 16, 0, 32), 1, 120), count("LINE_NUMBER"), count(distinct "LINE_NUMBER"), sum(sys_op_opnsize("LINE_NUMBER")), substrb(dump(min("LINE_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_NUMBER"), 16, 0, 32), 1, 120), count("QUANTITY"), count(distinct "QUANTITY"), sum(sys_op_opnsize("QUANTITY")), substrb(dump(min("QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY"), 16, 0, 32), 1, 120), count("QUANTITY_ORDERED"), count(distinct "QUANTITY_ORDERED"), sum(sys_op_opnsize("QUANTITY_ORDERED")), substrb(dump(min("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), count("UNIT_SELLING_PRICE"), count(distinct "UNIT_SELLING_PRICE"), sum(sys_op_opnsize("UNIT_SELLING_PRICE")), substrb(dump(min("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), count("UNIT_STANDARD_PRICE"), count(distinct "UNIT_STANDARD_PRICE"), sum(sys_op_opnsize("UNIT_STANDARD_PRICE")), substrb(dump(min("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), count("PRINTING_OPTION"), count(distinct "PRINTING_OPTION"), sum(sys_op_opnsize("PRINTING_OPTION")), substrb(dump(min("PRINTING_OPTION"), 16, 0, 32), 1, 120), substrb(dump(max("PRINTING_OPTION"), 16, 0, 32), 1, 120), count("INTERFACE_STATUS"), count(distinct "INTERFACE_STATUS"), sum(sys_op_opnsi
ze("INTERFACE_STATUS")), substrb(dump(min("INTERFACE_STATUS"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_STATUS"), 16, 0, 32), 1, 120), count("REQUEST_ID"), count(distinct "REQUEST_ID"), sum(sys_op_opnsize("REQUEST_ID")), substrb(dump(min("REQUEST_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REQUEST_ID"), 16, 0, 32), 1, 120), count("RELATED_BATCH_SOURCE_NAME"), count(distinct "RELATED_BATCH_SOURCE_NAME"), sum(sys_op_opnsize("RELATED_BATCH_SOURCE_NAME")), substrb(dump(min(substrb("RELATED_BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("RELATED_BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("RELATED_TRX_NUMBER"), count(distinct "RELATED_TRX_NUMBER"), sum(sys_op_opnsize("RELATED_TRX_NUMBER")), substrb(dump(min("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), count("RELATED_CUSTOMER_TRX_ID"), count(distinct "RELATED_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("RELATED_CUSTOMER_TRX_ID")), substrb(dump(min("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("PREVIOUS_CUSTOMER_TRX_ID"), count(distinct "PREVIOUS_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("PREVIOUS_CUSTOMER_TRX_ID")), substrb(dump(min("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_ACCT_RULE"), count(distinct "CREDIT_METHOD_FOR_ACCT_RULE"), sum(sys_op_opnsize("CREDIT_MET
HOD_FOR_ACCT_RULE")), substrb(dump(min("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_INSTALLMENTS"), count(distinct "CREDIT_METHOD_FOR_INSTALLMENTS"), sum(sys_op_opnsize("CREDIT_METHOD_FOR_INSTALLMENTS")), substrb(dump(min("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 32), 1, 120), count("REASON_CODE"), count(distinct "REASON_CODE"), sum(sys_op_opnsize("REASON_CODE")), substrb(dump(min("REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_RATE"), count(distinct "TAX_RATE"), sum(sys_op_opnsize("TAX_RATE")), substrb(dump(min("TAX_RATE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_RATE"), 16, 0, 32), 1, 120), count("TAX_CODE"), count(distinct "TAX_CODE"), sum(sys_op_opnsize("TAX_CODE")), substrb(dump(min(substrb("TAX_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_CODE", 1, 32)), 16, 0, 32), 1, 120), count("TAX_PRECEDENCE"), count(distinct "TAX_PRECEDENCE"), sum(sys_op_opnsize("TAX_PRECEDENCE")), substrb(dump(min("TAX_PRECEDENCE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_PRECEDENCE"), 16, 0, 32), 1, 120), count("EXCEPTION_ID"), count(distinct "EXCEPTION_ID"), sum(sys_op_opnsize("EXCEPTION_ID")), substrb(dump(min("EXCEPTION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("EXCEPTION_ID"), 16, 0, 32), 1, 120), count("EXEMPTION_ID"), count(distinct "
EXEMPTION_ID"), sum(sys_op_opnsize("EXEMPTION_ID")), substrb(dump(min("EXEMPTION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("EXEMPTION_ID"), 16, 0, 32), 1, 120), count("SHIP_DATE_ACTUAL"), count(distinct "SHIP_DATE_ACTUAL"), substrb(dump(min("SHIP_DATE_ACTUAL"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_DATE_ACTUAL"), 16, 0, 32), 1, 120), count("FOB_POINT"), count(distinct "FOB_POINT"), sum(sys_op_opnsize("FOB_POINT")), substrb(dump(min("FOB_POINT"), 16, 0, 32), 1, 120), substrb(dump(max("FOB_POINT"), 16, 0, 32), 1, 120), count("SHIP_VIA"), count(distinct "SHIP_VIA"), sum(sys_op_opnsize("SHIP_VIA")), substrb(dump(min("SHIP_VIA"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_VIA"), 16, 0, 32), 1, 120), count("WAYBILL_NUMBER"), count(distinct "WAYBILL_NUMBER"), sum(sys_op_opnsize("WAYBILL_NUMBER")), substrb(dump(min(substrb("WAYBILL_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("WAYBILL_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("INVOICING_RULE_NAME"), count(distinct "INVOICING_RULE_NAME"), sum(sys_op_opnsize("INVOICING_RULE_NAME")), substrb(dump(min("INVOICING_RULE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICING_RULE_NAME"), 16, 0, 32), 1, 120), count("INVOICING_RULE_ID"), count(distinct "INVOICING_RULE_ID"), sum(sys_op_opnsize("INVOICING_RULE_ID")), substrb(dump(min("INVOICING_RULE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICING_RULE_ID"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_NAME"), count(distinct "ACCOUNTING_RULE_NAME"), sum(sys_
op_opnsize("ACCOUNTING_RULE_NAME")), substrb(dump(min("ACCOUNTING_RULE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_NAME"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_ID"), count(distinct "ACCOUNTING_RULE_ID"), sum(sys_op_opnsize("ACCOUNTING_RULE_ID")), substrb(dump(min("ACCOUNTING_RULE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_ID"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_DURATION"), count(distinct "ACCOUNTING_RULE_DURATION"), sum(sys_op_opnsize("ACCOUNTING_RULE_DURATION")), substrb(dump(min("ACCOUNTING_RULE_DURATION"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_DURATION"), 16, 0, 32), 1, 120), count("RULE_START_DATE"), count(distinct "RULE_START_DATE"), substrb(dump(min("RULE_START_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("RULE_START_DATE"), 16, 0, 32), 1, 120), count("PRIMARY_SALESREP_NUMBER"), count(distinct "PRIMARY_SALESREP_NUMBER"), sum(sys_op_opnsize("PRIMARY_SALESREP_NUMBER")), substrb(dump(min("PRIMARY_SALESREP_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("PRIMARY_SALESREP_NUMBER"), 16, 0, 32), 1, 120), count("PRIMARY_SALESREP_ID"), count(distinct "PRIMARY_SALESREP_ID"), sum(sys_op_opnsize("PRIMARY_SALESREP_ID")), substrb(dump(min("PRIMARY_SALESREP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PRIMARY_SALESREP_ID"), 16, 0, 32), 1, 120), count("SALES_ORDER"), count(distinct "SALES_ORDER"), sum(sys_op_opnsize("SALES_ORDER")), substrb(dump(min(substrb("SALES_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(
max(substrb("SALES_ORDER", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_LINE"), count(distinct "SALES_ORDER_LINE"), sum(sys_op_opnsize("SALES_ORDER_LINE")), substrb(dump(min("SALES_ORDER_LINE"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_LINE"), 16, 0, 32), 1, 120), count("SALES_ORDER_DATE"), count(distinct "SALES_ORDER_DATE"), substrb(dump(min("SALES_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_DATE"), 16, 0, 32), 1, 120), count("SALES_ORDER_SOURCE"), count(distinct "SALES_ORDER_SOURCE"), sum(sys_op_opnsize("SALES_ORDER_SOURCE")), substrb(dump(min(substrb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_REVISION"), count(distinct "SALES_ORDER_REVISION"), sum(sys_op_opnsize("SALES_ORDER_REVISION")), substrb(dump(min("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), count("PURCHASE_ORDER"), count(distinct "PURCHASE_ORDER"), sum(sys_op_opnsize("PURCHASE_ORDER")), substrb(dump(min(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), count("PURCHASE_ORDER_REVISION"), count(distinct "PURCHASE_ORDER_REVISION"), sum(sys_op_opnsize("PURCHASE_ORDER_REVISION")), substrb(dump(min(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), c
ount("PURCHASE_ORDER_DATE"), count(distinct "PURCHASE_ORDER_DATE"), substrb(dump(min("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), count("AGREEMENT_NAME"), count(distinct "AGREEMENT_NAME"), sum(sys_op_opnsize("AGREEMENT_NAME")), substrb(dump(min("AGREEMENT_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_NAME"), 16, 0, 32), 1, 120), count("AGREEMENT_ID"), count(distinct "AGREEMENT_ID"), sum(sys_op_opnsize("AGREEMENT_ID")), substrb(dump(min("AGREEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_ID"), 16, 0, 32), 1, 120), count("MEMO_LINE_NAME"), count(distinct "MEMO_LINE_NAME"), sum(sys_op_opnsize("MEMO_LINE_NAME")), substrb(dump(min(substrb("MEMO_LINE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MEMO_LINE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("MEMO_LINE_ID"), count(distinct "MEMO_LINE_ID"), sum(sys_op_opnsize("MEMO_LINE_ID")), substrb(dump(min("MEMO_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MEMO_LINE_ID"), 16, 0, 32), 1, 120), count("INVENTORY_ITEM_ID"), count(distinct "INVENTORY_ITEM_ID"), sum(sys_op_opnsize("INVENTORY_ITEM_ID")), substrb(dump(min("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG1"), count(distinct "MTL_SYSTEM_ITEMS_SEG1"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG1")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(subst
rb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG2"), count(distinct "MTL_SYSTEM_ITEMS_SEG2"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG2")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG3"), count(distinct "MTL_SYSTEM_ITEMS_SEG3"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG3")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG4"), count(distinct "MTL_SYSTEM_ITEMS_SEG4"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG4")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG5"), count(distinct "MTL_SYSTEM_ITEMS_SEG5"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG5")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG6"), count(distinct "MTL_SYSTEM_ITEMS_SEG6"), sum(sys_op_opnsize("?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? |
| 64qc329wgjv39 |
select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char
(PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc |
| 66tmsr3446uqn | SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1 |
| 6cjfxb1c4kx16 | SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, HIERARCHY_TYPE FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = UPPER(:B1 ) AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE |
| 6djyj1t4djs12 |
select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_SALESCREDIT_ID"), sum(sys_op_opnsize("INTERFACE_SALESCREDIT_ID")), substrb(dump(min("INTERFACE_SALESCREDIT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_SALESCREDIT_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ID"), count(distinct "INTERFACE_LINE_ID"), sum(sys_op_opnsize("INTERFACE_LINE_ID")), substrb(dump(min("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_CONTEXT"), count(distinct "INTERFACE_LINE_CONTEXT"), sum(sys_op_opnsize("INTERFACE_LINE_CONTEXT")), substrb(dump(min("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE1"), count(distinct "INTERFACE_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE1")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE2"), count(distinct "INTERFACE_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE2")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE3"), count(distinct "INTERFACE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIB
UTE3")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE4"), count(distinct "INTERFACE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE4")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE5"), count(distinct "INTERFACE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE5")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE6"), count(distinct "INTERFACE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE6")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE7"), count(distinct "INTERFACE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE7")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE8"), count(distinct "INTERFACE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE8")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("SALESREP_NUMB
ER"), count(distinct "SALESREP_NUMBER"), sum(sys_op_opnsize("SALESREP_NUMBER")), substrb(dump(min("SALESREP_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_NUMBER"), 16, 0, 32), 1, 120), count("SALESREP_ID"), count(distinct "SALESREP_ID"), sum(sys_op_opnsize("SALESREP_ID")), substrb(dump(min("SALESREP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_NAME"), count(distinct "SALES_CREDIT_TYPE_NAME"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_NAME")), substrb(dump(min("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_ID"), count(distinct "SALES_CREDIT_TYPE_ID"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_ID")), substrb(dump(min("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_AMOUNT_SPLIT"), count(distinct "SALES_CREDIT_AMOUNT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_AMOUNT_SPLIT")), substrb(dump(min("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), count("SALES_CREDIT_PERCENT_SPLIT"), count(distinct "SALES_CREDIT_PERCENT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_PERCENT_SPLIT")), substrb(dump(min("SALES_CREDIT_PERCENT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_PERCENT_SPLIT"), 16, 0, 32), 1, 120), count("INTERFACE_STATUS"), count(distinct "INTERFACE_STATUS"), sum(sys_op
_opnsize("INTERFACE_STATUS")), substrb(dump(min("INTERFACE_STATUS"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_STATUS"), 16, 0, 32), 1, 120), count("REQUEST_ID"), count(distinct "REQUEST_ID"), sum(sys_op_opnsize("REQUEST_ID")), substrb(dump(min("REQUEST_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REQUEST_ID"), 16, 0, 32), 1, 120), count("ATTRIBUTE_CATEGORY"), count(distinct "ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("ATTRIBUTE_CATEGORY")), substrb(dump(min("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("ATTRIBUTE1"), count(distinct "ATTRIBUTE1"), sum(sys_op_opnsize("ATTRIBUTE1")), substrb(dump(min(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE2"), count(distinct "ATTRIBUTE2"), sum(sys_op_opnsize("ATTRIBUTE2")), substrb(dump(min(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE3"), count(distinct "ATTRIBUTE3"), sum(sys_op_opnsize("ATTRIBUTE3")), substrb(dump(min(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE4"), count(distinct "ATTRIBUTE4"), sum(sys_op_opnsize("ATTRIBUTE4")), substrb(dump(min(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE5"), count(dist
inct "ATTRIBUTE5"), sum(sys_op_opnsize("ATTRIBUTE5")), substrb(dump(min(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE6"), count(distinct "ATTRIBUTE6"), sum(sys_op_opnsize("ATTRIBUTE6")), substrb(dump(min(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE7"), count(distinct "ATTRIBUTE7"), sum(sys_op_opnsize("ATTRIBUTE7")), substrb(dump(min(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE8"), count(distinct "ATTRIBUTE8"), sum(sys_op_opnsize("ATTRIBUTE8")), substrb(dump(min(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE9"), count(distinct "ATTRIBUTE9"), sum(sys_op_opnsize("ATTRIBUTE9")), substrb(dump(min(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE10"), count(distinct "ATTRIBUTE10"), sum(sys_op_opnsize("ATTRIBUTE10")), substrb(dump(min(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE11"), count(distinct "ATTRIBUTE11"), sum(sys_op_opnsize("ATTRIBUTE11")), substrb(dump(min(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substr
b("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE12"), count(distinct "ATTRIBUTE12"), sum(sys_op_opnsize("ATTRIBUTE12")), substrb(dump(min(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE13"), count(distinct "ATTRIBUTE13"), sum(sys_op_opnsize("ATTRIBUTE13")), substrb(dump(min(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE14"), count(distinct "ATTRIBUTE14"), sum(sys_op_opnsize("ATTRIBUTE14")), substrb(dump(min(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE15"), count(distinct "ATTRIBUTE15"), sum(sys_op_opnsize("ATTRIBUTE15")), substrb(dump(min(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1,
120), count("INTERFACE_LINE_ATTRIBUTE12"), count(distinct "INTERFACE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE13")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE14"), count(distinct "INTERFACE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE14")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE15"), count(distinct "INTERFACE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE15")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE9"), count(distinct "INTERFACE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE9")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("CREATED_BY"), count(distinct "CREATED_BY"), sum(sys_op_opnsize("CREATED_BY")), substrb(dump(min("CREATED_BY"), 16, 0, 32), 1, 120),
substrb(dump(max("CREATED_BY"), 16, 0, 32), 1, 120), count("CREATION_DATE"), count(distinct "CREATION_DATE"), substrb(dump(min("CREATION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CREATION_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATED_BY"), count(distinct "LAST_UPDATED_BY"), sum(sys_op_opnsize("LAST_UPDATED_BY")), substrb(dump(min("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), count("LAST_UPDATE_DATE"), count(distinct "LAST_UPDATE_DATE"), substrb(dump(min("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATE_LOGIN"), count(distinct "LAST_UPDATE_LOGIN"), sum(sys_op_opnsize("LAST_UPDATE_LOGIN")), substrb(dump(min("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), count("ORG_ID"), count(distinct "ORG_ID"), sum(sys_op_opnsize("ORG_ID")), substrb(dump(min("ORG_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORG_ID"), 16, 0, 32), 1, 120), count("SALESGROUP_ID"), count(distinct "SALESGROUP_ID"), sum(sys_op_opnsize("SALESGROUP_ID")), substrb(dump(min("SALESGROUP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALESGROUP_ID"), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_SALESCREDITS_ALL" sample ( 10.0000000000) t |
| 6gnth2mfbs2nq | declare
v_ret number := 0;
begin
if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) )
then
v_ret := 1;
end if;
:8 := v_ret;
end;
|
| 6h2tpcxpymqu7 | BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END; |
| 7g05xfvc5vp74 | BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END; |
| 8c8cf4vtv4tx2 |
SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+)
AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) |
| 8vmj377jqyqwq | BEGIN WSH_BATCH_PROCESS.CONFIRM_DELIVERY_SRS( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14, :A15, :A16, :A17, :A18, :A19, :A20, :A21, :A22); END; |
| 95pbs94n69z3d | SELECT NVL(MULTI_ORG_FLAG, 'N'), NVL(MULTI_CURRENCY_FLAG, 'N') FROM FND_PRODUCT_GROUPS |
| 9dvfguzd15kpv | SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = :B1 |
| 9sf243fdjmdmh | begin fnd_global.apps_initialize(-1, -1, -1, :1); end; |
| 9wdrypwkpf607 | begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end; |
| a29grr748ghc4 | BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END; |
| a957tvxz9w038 | BEGIN :1 := por_util_pkg.interface_START_WORKFLOW( :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102) ; END; |
| avc1jqzz04wpr | SELECT 'x' FROM DUAL |
| b3an778qn1q49 |
select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE13")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE14"), count(distinct "INTERFACE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE14")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE15"), count(distinct "INTERFACE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE15")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE9"), count(distinct "INTERFACE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE9")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("VAT_TAX_ID"), count(distinct "VAT_TAX_ID"), sum(sys_op_opnsize("VAT_TAX_ID")), substrb(dump(min("VAT_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("VAT_TAX_ID"), 16, 0, 32), 1, 120), count("REASON_CODE_MEANING"), count(distinct "REASON_CODE_MEANING"), sum(sys_o
p_opnsize("REASON_CODE_MEANING")), substrb(dump(min(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("LAST_PERIOD_TO_CREDIT"), count(distinct "LAST_PERIOD_TO_CREDIT"), sum(sys_op_opnsize("LAST_PERIOD_TO_CREDIT")), substrb(dump(min("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), count("PAYING_CUSTOMER_ID"), count(distinct "PAYING_CUSTOMER_ID"), sum(sys_op_opnsize("PAYING_CUSTOMER_ID")), substrb(dump(min("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("PAYING_SITE_USE_ID"), count(distinct "PAYING_SITE_USE_ID"), sum(sys_op_opnsize("PAYING_SITE_USE_ID")), substrb(dump(min("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_FLAG"), count(distinct "TAX_EXEMPT_FLAG"), sum(sys_op_opnsize("TAX_EXEMPT_FLAG")), substrb(dump(min("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE"), count(distinct "TAX_EXEMPT_REASON_CODE"), sum(sys_op_opnsize("TAX_EXEMPT_REASON_CODE")), substrb(dump(min("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE_MEANING"), count(distinct "TAX_EXEMPT_REASON_CODE_MEANING"), sum(sys_op_opnsize("TAX_EXEMPT_REASON_
CODE_MEANING")), substrb(dump(min(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("TAX_EXEMPT_NUMBER"), count(distinct "TAX_EXEMPT_NUMBER"), sum(sys_op_opnsize("TAX_EXEMPT_NUMBER")), substrb(dump(min(substrb("TAX_EXEMPT_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_EXEMPT_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("SALES_TAX_ID"), count(distinct "SALES_TAX_ID"), sum(sys_op_opnsize("SALES_TAX_ID")), substrb(dump(min("SALES_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_TAX_ID"), 16, 0, 32), 1, 120), count("CREATED_BY"), count(distinct "CREATED_BY"), sum(sys_op_opnsize("CREATED_BY")), substrb(dump(min("CREATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("CREATED_BY"), 16, 0, 32), 1, 120), count("CREATION_DATE"), count(distinct "CREATION_DATE"), substrb(dump(min("CREATION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CREATION_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATED_BY"), count(distinct "LAST_UPDATED_BY"), sum(sys_op_opnsize("LAST_UPDATED_BY")), substrb(dump(min("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), count("LAST_UPDATE_DATE"), count(distinct "LAST_UPDATE_DATE"), substrb(dump(min("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATE_LOGIN"), count(distinct "LAST_UPDATE_LOGIN"), sum(sys_op_opnsize("
LAST_UPDATE_LOGIN")), substrb(dump(min("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), count("LOCATION_SEGMENT_ID"), count(distinct "LOCATION_SEGMENT_ID"), sum(sys_op_opnsize("LOCATION_SEGMENT_ID")), substrb(dump(min("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), count("MOVEMENT_ID"), count(distinct "MOVEMENT_ID"), sum(sys_op_opnsize("MOVEMENT_ID")), substrb(dump(min("MOVEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MOVEMENT_ID"), 16, 0, 32), 1, 120), count("ORG_ID"), count(distinct "ORG_ID"), sum(sys_op_opnsize("ORG_ID")), substrb(dump(min("ORG_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORG_ID"), 16, 0, 32), 1, 120), count("AMOUNT_INCLUDES_TAX_FLAG"), count(distinct "AMOUNT_INCLUDES_TAX_FLAG"), sum(sys_op_opnsize("AMOUNT_INCLUDES_TAX_FLAG")), substrb(dump(min("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTR_CATEGORY"), count(distinct "HEADER_GDF_ATTR_CATEGORY"), sum(sys_op_opnsize("HEADER_GDF_ATTR_CATEGORY")), substrb(dump(min("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE1"), count(distinct "HEADER_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEA
DER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE2"), count(distinct "HEADER_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE3"), count(distinct "HEADER_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE4"), count(distinct "HEADER_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE5"), count(distinct "HEADER_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE6"), count(distinct "HEADER_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE7"), count(distinct "HEADER
_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE8"), count(distinct "HEADER_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE9"), count(distinct "HEADER_GDF_ATTRIBUTE9"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE10"), count(distinct "HEADER_GDF_ATTRIBUTE10"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE11"), count(distinct "HEADER_GDF_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE12"), count(distinct "HEADER_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("H
EADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE13"), count(distinct "HEADER_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE14"), count(distinct "HEADER_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE15"), count(distinct "HEADER_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE16"), count(distinct "HEADER_GDF_ATTRIBUTE16"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE16")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE17"), count(distinct "HEADER_GDF_ATTRIBUTE17"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("
HEADER_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE18"), count(distinct "HEADER_GDF_ATTRIBUTE18"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE19"), count(distinct "HEADER_GDF_ATTRIBUTE19"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE19")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE20"), count(distinct "HEADER_GDF_ATTRIBUTE20"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE21"), count(distinct "HEADER_GDF_ATTRIBUTE21"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE21")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE22"), count(distinct "HEADER_GDF_ATTRIBUTE22"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE22")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBU
TE23"), count(distinct "HEADER_GDF_ATTRIBUTE23"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE23")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE24"), count(distinct "HEADER_GDF_ATTRIBUTE24"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE24")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE25"), count(distinct "HEADER_GDF_ATTRIBUTE25"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE25")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE26"), count(distinct "HEADER_GDF_ATTRIBUTE26"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE26")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE26", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE26", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE27"), count(distinct "HEADER_GDF_ATTRIBUTE27"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE27")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE27", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE27", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE28"), count(distinct "HEADER_GDF_ATTRIBUTE28"), sum(sys_op_opnsize("HEADER_GDF
_ATTRIBUTE28")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE28", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE28", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE29"), count(distinct "HEADER_GDF_ATTRIBUTE29"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE29")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE29", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE29", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE30"), count(distinct "HEADER_GDF_ATTRIBUTE30"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE30")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE30", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE30", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTR_CATEGORY"), count(distinct "LINE_GDF_ATTR_CATEGORY"), sum(sys_op_opnsize("LINE_GDF_ATTR_CATEGORY")), substrb(dump(min("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE1"), count(distinct "LINE_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE2"), count(distinct "LINE_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIB
UTE2", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE3"), count(distinct "LINE_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE4"), count(distinct "LINE_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE5"), count(distinct "LINE_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE6"), count(distinct "LINE_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE7"), count(distinct "LINE_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE8"), count(distinct "LINE_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE8")), subst
rb(dump(min(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE9"), count(distinct "LINE_GDF_ATTRIBUTE9"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE10"), count(distinct "LINE_GDF_ATTRIBUTE10"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE11"), count(distinct "LINE_GDF_ATTRIBUTE11"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE12"), count(distinct "LINE_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE13"), count(distinct "LINE_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0
, 32), 1, 120), count("LINE_GDF_ATTRIBUTE14"), count(distinct "LINE_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE15"), count(distinct "LINE_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE16"), count(distinct "LINE_GDF_ATTRIBUTE16"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE16")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE17"), count(distinct "LINE_GDF_ATTRIBUTE17"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE18"), count(distinct "LINE_GDF_ATTRIBUTE18"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE19"), count(distinct "LINE_GDF_ATTRIBUTE19"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE19"))
, substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE20"), count(distinct "LINE_GDF_ATTRIBUTE20"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), count("RESET_TRX_DATE_FLAG"), count(distinct "RESET_TRX_DATE_FLAG"), sum(sys_op_opnsize("RESET_TRX_DATE_FLAG")), substrb(dump(min("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), count("PAYMENT_SERVER_ORDER_NUM"), count(distinct "PAYMENT_SERVER_ORDER_NUM"), sum(sys_op_opnsize("PAYMENT_SERVER_ORDER_NUM")), substrb(dump(min(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), count("APPROVAL_CODE"), count(distinct "APPROVAL_CODE"), sum(sys_op_opnsize("APPROVAL_CODE")), substrb(dump(min(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), count("ADDRESS_VERIFICATION_CODE"), count(distinct "ADDRESS_VERIFICATION_CODE"), sum(sys_op_opnsize("ADDRESS_VERIFICATION_CODE")), substrb(dump(min(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120
), count("WAREHOUSE_ID"), count(distinct "WAREHOUSE_ID"), sum(sys_op_opnsize("WAREHOUSE_ID")), substrb(dump(min("WAREHOUSE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("WAREHOUSE_ID"), 16, 0, 32), 1, 120), count("TRANSLATED_DESCRIPTION"), count(distinct "TRANSLATED_DESCRIPTION"), sum(sys_op_opnsize("TRANSLATED_DESCRIPTION")), substrb(dump(min(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count("CONS_BILLING_NUMBER"), count(distinct "CONS_BILLING_NUMBER"), sum(sys_op_opnsize("CONS_BILLING_NUMBER")), substrb(dump(min("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), count("PROMISED_COMMITMENT_AMOUNT"), count(distinct "PROMISED_COMMITMENT_AMOUNT"), sum(sys_op_opnsize("PROMISED_COMMITMENT_AMOUNT")), substrb(dump(min("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), count("PAYMENT_SET_ID"), count(distinct "PAYMENT_SET_ID"), sum(sys_op_opnsize("PAYMENT_SET_ID")), substrb(dump(min("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), count("ORIGINAL_GL_DATE"), count(distinct "ORIGINAL_GL_DATE"), substrb(dump(min("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), count("CONTRACT_LINE_ID"), count(distinct "CONTRACT_LINE_ID"), sum(sys_op_opnsize("CONTRACT_LINE_ID")), subst
rb(dump(min("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), count("CONTRACT_ID"), count(distinct "CONTRACT_ID"), sum(sys_op_opnsize("CONTRACT_ID")), substrb(dump(min("CONTRACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_ID"), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY1"), count(distinct "SOURCE_DATA_KEY1"), sum(sys_op_opnsize("SOURCE_DATA_KEY1")), substrb(dump(min(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY2"), count(distinct "SOURCE_DATA_KEY2"), sum(sys_op_opnsize("SOURCE_DATA_KEY2")), substrb(dump(min(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY3"), count(distinct "SOURCE_DATA_KEY3"), sum(sys_op_opnsize("SOURCE_DATA_KEY3")), substrb(dump(min(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY4"), count(distinct "SOURCE_DATA_KEY4"), sum(sys_op_opnsize("SOURCE_DATA_KEY4")), substrb(dump(min(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY5"), count(distinct "SOURCE_DATA_KEY5"), sum(sys_op_opnsize("SOURCE_DATA_KEY5")), substrb(dump(min(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 1
20), substrb(dump(max(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120), count("INVOICED_LINE_ACCTG_LEVEL"), count(distinct "INVOICED_LINE_ACCTG_LEVEL"), sum(sys_op_opnsize("INVOICED_LINE_ACCTG_LEVEL")), substrb(dump(min("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG10"), count(distinct "MTL_SYSTEM_ITEMS_SEG10"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG10")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG11"), count(distinct "MTL_SYSTEM_ITEMS_SEG11"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG11")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG11", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG12"), count(distinct "MTL_SYSTEM_ITEMS_SEG12"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG12")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG12", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG13"), count(distinct "MTL_SYSTEM_ITEMS_SEG13"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG13")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG13", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM
_ITEMS_SEG14"), count(distinct "MTL_SYSTEM_ITEMS_SEG14"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG14")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG15"), count(distinct "MTL_SYSTEM_ITEMS_SEG15"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG15")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG16"), count(distinct "MTL_SYSTEM_ITEMS_SEG16"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG16")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG17"), count(distinct "MTL_SYSTEM_ITEMS_SEG17"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG17")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG18"), count(distinct "MTL_SYSTEM_ITEMS_SEG18"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG18")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG19"), count(distinct "MTL_SYSTEM_ITEMS_SEG19"), sum(sys_op_opnsize("MT
L_SYSTEM_ITEMS_SEG19")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG20"), count(distinct "MTL_SYSTEM_ITEMS_SEG20"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG20")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ID"), count(distinct "REFERENCE_LINE_ID"), sum(sys_op_opnsize("REFERENCE_LINE_ID")), substrb(dump(min("REFERENCE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ID"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_CONTEXT"), count(distinct "REFERENCE_LINE_CONTEXT"), sum(sys_op_opnsize("REFERENCE_LINE_CONTEXT")), substrb(dump(min("REFERENCE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE1"), count(distinct "REFERENCE_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE1")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE2"), count(distinct "REFERENCE_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE2")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("REFERENCE
_LINE_ATTRIBUTE3"), count(distinct "REFERENCE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE3")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE4"), count(distinct "REFERENCE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE4")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE5"), count(distinct "REFERENCE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE5")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE6"), count(distinct "REFERENCE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE6")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE7"), count(distinct "REFERENCE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE7")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("TERRITORY_ID"), count(distinct "TERRITORY_ID"), sum(sys_op_opnsize("TERRITORY_ID")), substrb(dump(min("TERRITORY_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_ID"),
16, 0, 32), 1, 120), count("TERRITORY_SEGMENT1"), count(distinct "TERRITORY_SEGMENT1"), sum(sys_op_opnsize("TERRITORY_SEGMENT1")), substrb(dump(min("TERRITORY_SEGMENT1"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT1"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT2"), count(distinct "TERRITORY_SEGMENT2"), sum(sys_op_opnsize("TERRITORY_SEGMENT2")), substrb(dump(min("TERRITORY_SEGMENT2"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT2"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT3"), count(distinct "TERRITORY_SEGMENT3"), sum(sys_op_opnsize("TERRITORY_SEGMENT3")), substrb(dump(min("TERRITORY_SEGMENT3"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT3"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT4"), count(distinct "TERRITORY_SEGMENT4"), sum(sys_op_opnsize("TERRITORY_SEGMENT4")), substrb(dump(min("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT5"), count(distinct "TERRITORY_SEGMENT5"), sum(sys_op_opnsize("TERRITORY_SEGMENT5")), substrb(dump(min("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT6"), count(distinct "TERRITORY_SEGMENT6"), sum(sys_op_opnsize("TERRITORY_SEGMENT6")), substrb(dump(min("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT7"), count(distinct "TERRITORY_SEGMENT7"), sum(sys_op_opnsize("
TERRITORY_SEGMENT7")), substrb(dump(min("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT8"), count(distinct "TERRITORY_SEGMENT8"), sum(sys_op_opnsize("TERRITORY_SEGMENT8")), substrb(dump(min("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT9"), count(distinct "TERRITORY_SEGMENT9"), sum(sys_op_opnsize("TERRITORY_SEGMENT9")), substrb(dump(min("TERRITORY_SEGMENT9"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT9"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT10"), count(distinct "TERRITORY_SEGMENT10"), sum(sys_op_opnsize("TERRITORY_SEGMENT10")), substrb(dump(min("TERRITORY_SEGMENT10"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT10"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT11"), count(distinct "TERRITORY_SEGMENT11"), sum(sys_op_opnsize("TERRITORY_SEGMENT11")), substrb(dump(min("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT12"), count(distinct "TERRITORY_SEGMENT12"), sum(sys_op_opnsize("TERRITORY_SEGMENT12")), substrb(dump(min("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), substrb(d?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????, 1, 120), substrb(dump(max(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE2"), count(distinct "ATTRIBUTE2"), sum(sys_op_opnsize("ATTRIBUTE2")), substrb(dump(min(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE3"), count(distinct "ATTRIBUTE3"), sum(sys_op_opnsize("ATTRIBUTE3")), substrb(dump(min(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE4"), count(distinct "ATTRIBUTE4"), sum(sys_op_opnsize("ATTRIBUTE4")), substrb(dump(min(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE5"), count(distinct "ATTRIBUTE5"), sum(sys_op_opnsize("ATTRIBUTE5")), substrb(dump(min(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE6"), count(distinct "ATTRIBUTE6"), sum(sys_op_opnsize("ATTRIBUTE6"
)), substrb(dump(min(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE7"), count(distinct "ATTRIBUTE7"), sum(sys_op_opnsize("ATTRIBUTE7")), substrb(dump(min(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE8"), count(distinct "ATTRIBUTE8"), sum(sys_op_opnsize("ATTRIBUTE8")), substrb(dump(min(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE9"), count(distinct "ATTRIBUTE9"), sum(sys_op_opnsize("ATTRIBUTE9")), substrb(dump(min(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE10"), count(distinct "ATTRIBUTE10"), sum(sys_op_opnsize("ATTRIBUTE10")), substrb(dump(min(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE11"), count(distinct "ATTRIBUTE11"), sum(sys_op_opnsize("ATTRIBUTE11")), substrb(dump(min(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE12"), count(distinct "ATTRIBUTE12"), sum(sys_op_opnsize("ATTRIBUTE12")), substrb(dump(min(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120),
count("ATTRIBUTE13"), count(distinct "ATTRIBUTE13"), sum(sys_op_opnsize("ATTRIBUTE13")), substrb(dump(min(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE14"), count(distinct "ATTRIBUTE14"), sum(sys_op_opnsize("ATTRIBUTE14")), substrb(dump(min(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE15"), count(distinct "ATTRIBUTE15"), sum(sys_op_opnsize("ATTRIBUTE15")), substrb(dump(min(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE_CATEGORY"), count(distinct "HEADER_ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("HEADER_ATTRIBUTE_CATEGORY")), substrb(dump(min("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE1"), count(distinct "HEADER_ATTRIBUTE1"), sum(sys_op_opnsize("HEADER_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE2"), count(distinct "HEADER_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE3"),
count(distinct "HEADER_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE4"), count(distinct "HEADER_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE5"), count(distinct "HEADER_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE6"), count(distinct "HEADER_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE7"), count(distinct "HEADER_ATTRIBUTE7"), sum(sys_op_opnsize("HEADER_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE8"), count(distinct "HEADER_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE8", 1,
32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE9"), count(distinct "HEADER_ATTRIBUTE9"), sum(sys_op_opnsize("HEADER_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE10"), count(distinct "HEADER_ATTRIBUTE10"), sum(sys_op_opnsize("HEADER_ATTRIBUTE10")), substrb(dump(min(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE11"), count(distinct "HEADER_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE12"), count(distinct "HEADER_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_ATTRIBUTE12")), substrb(dump(min(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE13"), count(distinct "HEADER_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE14"), count(distinct "HEADER_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_ATTRIBUTE14", 1
, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE15"), count(distinct "HEADER_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t |
| bc7t6t6jfx2n7 | SELECT VERSION FROM FND_CACHE_VERSIONS WHERE NAME = :B1 |
| bcym7s1bp0wxs | SELECT WIA.NAME FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1 AND WIA.TYPE = 'EVENT' |
| bkxrrs52m7d8p | BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END; |
| bp8crdjba8zgt | update ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b4) |
| bt0w082dfrm8v | BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END; |
| bvyqm6268u2as | SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = :B1 |
| 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 |
| dzt4ys8ynkyrj |
INSERT INTO CS_INCIDENTS_AUDIT_B ( INCIDENT_AUDIT_ID , INCIDENT_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , CREATION_TIME , INCIDENT_STATUS_ID , OLD_INCIDENT_STATUS_ID , CHANGE_INCIDENT_STATUS_FLAG , INCIDENT_TYPE_ID , OLD_INCIDENT_TYPE_ID , CHANGE_INCIDENT_TYPE_FLAG , INCIDENT_URGENCY_ID , OLD_INCIDENT_URGENCY_ID , CHANGE_INCIDENT_URGENCY_FLAG , INCIDENT_SEVERITY_ID , OLD_INCIDENT_SEVERITY_ID , CHANGE_INCIDENT_SEVERITY_FLAG, INCIDENT_OWNER_ID , OLD_INCIDENT_OWNER_ID , CHANGE_INCIDENT_OWNER_FLAG , CREATE_MANUAL_ACTION , ACTION_ID , EXPECTED_RESOLUTION_DATE , OLD_EXPECTED_RESOLUTION_DATE , CHANGE_RESOLUTION_FLAG , NEW_WORKFLOW_FLAG , WORKFLOW_PROCESS_NAME , WORKFLOW_PROCESS_ITEMKEY , GROUP_ID, OLD_GROUP_ID, CHANGE_GROUP_FLAG, GROUP_TYPE, OLD_GROUP_TYPE, CHANGE_GROUP_TYPE_FLAG, INV_PLATFORM_ORG_ID, OLD_INV_PLATFORM_ORG_ID, CHANGE_PLATFORM_ORG_ID_FLAG, OWNER_ASSIGNED_TIME, OLD_OWNER_ASSIGNED_TIME, CHANGE_ASSIGNED_TIME_FLAG, OBLIGATION_DATE, OLD_OBLIGATION_DATE, CHANGE_OBLIGATION_FLAG, SITE_ID, OLD_SITE_ID, CHANGE_SITE_FLAG, BILL_TO_CONTACT_ID, OLD_BILL_TO_CONTACT_ID, CHANGE_BILL_TO_FLAG, SHIP_TO_CONTACT_ID, OLD_SHIP_TO_CONTACT_ID, CHANGE_SHIP_TO_FLAG, CLOSE_DATE, OLD_CLOSE_DATE, CHANGE_CLOSE_DATE_FLAG, CUSTOMER_PRODUCT_ID, OLD_CUSTOMER_PRODUCT_ID, CHANGE_CUSTOMER_PRODUCT_FLAG, PLATFORM_ID, OLD_PLATFORM_ID, CHANGE_PLATFORM_ID_FLAG, PRODUCT_REVISION, OLD_PRODUCT_REVISION
, CHANGE_PRODUCT_REVISION_FLAG, COMPONENT_VERSION, OLD_COMPONENT_VERSION, CHANGE_COMP_VER_FLAG, SUBCOMPONENT_VERSION, OLD_SUBCOMPONENT_VERSION, CHANGE_SUBCOMP_VER_FLAG, CP_COMPONENT_ID, OLD_CP_COMPONENT_ID, CHANGE_CP_COMPONENT_ID_FLAG, CP_COMPONENT_VERSION_ID, OLD_CP_COMPONENT_VERSION_ID, CHANGE_CP_COMP_VER_ID_FLAG, CP_SUBCOMPONENT_ID, OLD_CP_SUBCOMPONENT_ID, CHANGE_CP_SUBCOMPONENT_ID_FLAG, CP_SUBCOMPONENT_VERSION_ID, OLD_CP_SUBCOMPONENT_VERSION_ID, CHANGE_CP_SUBCOMP_VER_ID_FLAG, CP_REVISION_ID, OLD_CP_REVISION_ID, CHANGE_CP_REVISION_ID_FLAG, INV_ITEM_REVISION, OLD_INV_ITEM_REVISION, CHANGE_INV_ITEM_REVISION, INV_COMPONENT_ID, OLD_INV_COMPONENT_ID, CHANGE_INV_COMPONENT_ID, INV_COMPONENT_VERSION, OLD_INV_COMPONENT_VERSION, CHANGE_INV_COMPONENT_VERSION, INV_SUBCOMPONENT_ID, OLD_INV_SUBCOMPONENT_ID, CHANGE_INV_SUBCOMPONENT_ID, INV_SUBCOMPONENT_VERSION, OLD_INV_SUBCOMPONENT_VERSION, CHANGE_INV_SUBCOMP_VERSION, TERRITORY_ID, OLD_TERRITORY_ID, CHANGE_TERRITORY_ID_FLAG, RESOURCE_TYPE, OLD_RESOURCE_TYPE, CHANGE_RESOURCE_TYPE_FLAG, OBJECT_VERSION_NUMBER, AUDIT_FIELD, INVENTORY_ITEM_ID , OLD_INVENTORY_ITEM_ID, CHANGE_INVENTORY_ITEM_FLAG, INV_ORGANIZATION_ID, OLD_INV_ORGANIZATION_ID, CHANGE_INV_ORGANIZATION_FLAG, STATUS_FLAG , OLD_STATUS_FLAG , CHANGE_STATUS_FLAG , INCIDENT_DATE, OLD_INCIDENT_DATE, CHANGE_INCIDENT_DATE_FLAG, PLATFORM_VERSION_ID, OLD_PLATFORM_VERSION_ID, CHANGE_PLAT_VER_ID_FLAG, LANGUAGE_ID, OLD_LANGUAGE_ID,
CHANGE_LANGUAGE_ID_FLAG, UPGRADE_FLAG_FOR_CREATE , OLD_INCIDENT_NUMBER , INCIDENT_NUMBER , OLD_CUSTOMER_ID , CUSTOMER_ID , OLD_BILL_TO_SITE_USE_ID , BILL_TO_SITE_USE_ID , OLD_EMPLOYEE_ID , EMPLOYEE_ID , OLD_SHIP_TO_SITE_USE_ID , SHIP_TO_SITE_USE_ID , OLD_PROBLEM_CODE , PROBLEM_CODE , OLD_ACTUAL_RESOLUTION_DATE , ACTUAL_RESOLUTION_DATE , OLD_INSTALL_SITE_USE_ID , INSTALL_SITE_USE_ID , OLD_CURRENT_SERIAL_NUMBER , CURRENT_SERIAL_NUMBER , OLD_SYSTEM_ID , SYSTEM_ID , OLD_INCIDENT_ATTRIBUTE_1 , INCIDENT_ATTRIBUTE_1 , OLD_INCIDENT_ATTRIBUTE_2 , INCIDENT_ATTRIBUTE_2 , OLD_INCIDENT_ATTRIBUTE_3 , INCIDENT_ATTRIBUTE_3 , OLD_INCIDENT_ATTRIBUTE_4 , INCIDENT_ATTRIBUTE_4 , OLD_INCIDENT_ATTRIBUTE_5 , INCIDENT_ATTRIBUTE_5 , OLD_INCIDENT_ATTRIBUTE_6 , INCIDENT_ATTRIBUTE_6 , OLD_INCIDENT_ATTRIBUTE_7 , INCIDENT_ATTRIBUTE_7 , OLD_INCIDENT_ATTRIBUTE_8 , INCIDENT_ATTRIBUTE_8 , OLD_INCIDENT_ATTRIBUTE_9 , INCIDENT_ATTRIBUTE_9 , OLD_INCIDENT_ATTRIBUTE_10 , INCIDENT_ATTRIBUTE_10 , OLD_INCIDENT_ATTRIBUTE_11 , INCIDENT_ATTRIBUTE_11 , OLD_INCIDENT_ATTRIBUTE_12 , INCIDENT_ATTRIBUTE_12 , OLD_INCIDENT_ATTRIBUTE_13 , INCIDENT_ATTRIBUTE_13 , OLD_INCIDENT_ATTRIBUTE_14 , INCIDENT_ATTRIBUTE_14 , OLD_INCIDENT_ATTRIBUTE_15 , INCIDENT_ATTRIBUTE_15 , OLD_INCIDENT_CONTEXT , INCIDENT_CONTEXT , OLD_RESOLUTION_CODE , RESOLUTION_CODE , OLD_ORIGINAL_ORDER_NUMBER , ORIGINAL_ORDER_NUMBER , OLD_ORG_ID , ORG_ID , OLD_PURCHASE_ORDER_NUMBER , PURCHASE_ORDER_NUMBER , O
LD_PUBLISH_FLAG , PUBLISH_FLAG , OLD_QA_COLLECTION_ID , QA_COLLECTION_ID , OLD_CONTRACT_ID , CONTRACT_ID , OLD_CONTRACT_NUMBER , CONTRACT_NUMBER , OLD_CONTRACT_SERVICE_ID , CONTRACT_SERVICE_ID , OLD_TIME_ZONE_ID , TIME_ZONE_ID , OLD_ACCOUNT_ID , ACCOUNT_ID , OLD_TIME_DIFFERENCE , TIME_DIFFERENCE , OLD_CUSTOMER_PO_NUMBER , CUSTOMER_PO_NUMBER , OLD_CUSTOMER_TICKET_NUMBER , CUSTOMER_TICKET_NUMBER , OLD_CUSTOMER_SITE_ID , CUSTOMER_SITE_ID , OLD_CALLER_TYPE , CALLER_TYPE , OLD_SECURITY_GROUP_ID , OLD_ORIG_SYSTEM_REFERENCE , ORIG_SYSTEM_REFERENCE , OLD_ORIG_SYSTEM_REFERENCE_ID , ORIG_SYSTEM_REFERENCE_ID , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , OLD_PROJECT_NUMBER , PROJECT_NUMBER , OLD_PLATFORM_VERSION , PLATFORM_VERSION , OLD_DB_VERSION , DB_VERSION , OLD_CUST_PREF_LANG_ID , CUST_PREF_LANG_ID , OLD_TIER , TIER , OLD_CATEGORY_ID , CATEGORY_ID , OLD_OPERATING_SYSTEM , OPERATING_SYSTEM , OLD_OPERATING_SYSTEM_VERSION , OPERATING_SYSTEM_VERSION , OLD_DATABASE , DATABASE , OLD_GROUP_TERRITORY_ID , GROUP_TERRITORY_ID , OLD_COMM_PREF_CODE , COMM_PREF_CODE , OLD_LAST_UPDATE_CHANNEL , LAST_UPDATE_CHANNEL , OLD_CUST_PREF_LANG_CODE , CUST_PREF_LANG_CODE , OLD_ERROR_CODE , ERROR_CODE , OLD_CATEGORY_SET_ID , CATEGORY_SET_ID , OLD_EXTERNAL_REFERENCE , EXTERNAL_REFERENCE , OLD_INCIDENT_OCCURRED_DATE , INCIDENT_OCCURRED_DATE , OLD_INCIDENT_RESOLVED_DATE , INCIDENT_RESOLVED_DATE , OLD_INC_RESPONDED
_BY_DATE , INC_RESPONDED_BY_DATE , OLD_INCIDENT_LOCATION_ID , INCIDENT_LOCATION_ID , OLD_INCIDENT_ADDRESS , INCIDENT_ADDRESS , OLD_INCIDENT_CITY , INCIDENT_CITY , OLD_INCIDENT_STATE , INCIDENT_STATE , OLD_INCIDENT_COUNTRY , INCIDENT_COUNTRY , OLD_INCIDENT_PROVINCE , INCIDENT_PROVINCE , OLD_INCIDENT_POSTAL_CODE , INCIDENT_POSTAL_CODE , OLD_INCIDENT_COUNTY , INCIDENT_COUNTY , OLD_SR_CREATION_CHANNEL , SR_CREATION_CHANNEL , OLD_DEF_DEFECT_ID , DEF_DEFECT_ID , OLD_DEF_DEFECT_ID2 , DEF_DEFECT_ID2 , OLD_EXTERNAL_ATTRIBUTE_1 , EXTERNAL_ATTRIBUTE_1 , OLD_EXTERNAL_ATTRIBUTE_2 , EXTERNAL_ATTRIBUTE_2 , OLD_EXTERNAL_ATTRIBUTE_3 , EXTERNAL_ATTRIBUTE_3 , OLD_EXTERNAL_ATTRIBUTE_4 , EXTERNAL_ATTRIBUTE_4 , OLD_EXTERNAL_ATTRIBUTE_5 , EXTERNAL_ATTRIBUTE_5 , OLD_EXTERNAL_ATTRIBUTE_6 , EXTERNAL_ATTRIBUTE_6 , OLD_EXTERNAL_ATTRIBUTE_7 , EXTERNAL_ATTRIBUTE_7 , OLD_EXTERNAL_ATTRIBUTE_8 , EXTERNAL_ATTRIBUTE_8 , OLD_EXTERNAL_ATTRIBUTE_9 , EXTERNAL_ATTRIBUTE_9 , OLD_EXTERNAL_ATTRIBUTE_10 , EXTERNAL_ATTRIBUTE_10 , OLD_EXTERNAL_ATTRIBUTE_11 , EXTERNAL_ATTRIBUTE_11 , OLD_EXTERNAL_ATTRIBUTE_12 , EXTERNAL_ATTRIBUTE_12 , OLD_EXTERNAL_ATTRIBUTE_13 , EXTERNAL_ATTRIBUTE_13 , OLD_EXTERNAL_ATTRIBUTE_14 , EXTERNAL_ATTRIBUTE_14 , OLD_EXTERNAL_ATTRIBUTE_15 , EXTERNAL_ATTRIBUTE_15 , OLD_EXTERNAL_CONTEXT , EXTERNAL_CONTEXT , OLD_LAST_UPDATE_PROGRAM_CODE , LAST_UPDATE_PROGRAM_CODE , OLD_CREATION_PROGRAM_CODE , CREATION_PROGRAM_CODE , OLD_COVERAGE_TYPE , COVERA
GE_TYPE , OLD_BILL_TO_ACCOUNT_ID , BILL_TO_ACCOUNT_ID , OLD_SHIP_TO_ACCOUNT_ID , SHIP_TO_ACCOUNT_ID , OLD_CUSTOMER_EMAIL_ID , CUSTOMER_EMAIL_ID , OLD_CUSTOMER_PHONE_ID , CUSTOMER_PHONE_ID , OLD_BILL_TO_PARTY_ID , BILL_TO_PARTY_ID , OLD_SHIP_TO_PARTY_ID , SHIP_TO_PARTY_ID , OLD_BILL_TO_SITE_ID , BILL_TO_SITE_ID , OLD_SHIP_TO_SITE_ID , SHIP_TO_SITE_ID , OLD_PROGRAM_LOGIN_ID , PROGRAM_LOGIN_ID , OLD_INCIDENT_POINT_OF_INTEREST , INCIDENT_POINT_OF_INTEREST , OLD_INCIDENT_CROSS_STREET , INCIDENT_CROSS_STREET , OLD_INCIDENT_DIRECTION_QUALIF , INCIDENT_DIRECTION_QUALIF , OLD_INCIDENT_DISTANCE_QUALIF , INCIDENT_DISTANCE_QUALIF , OLD_INCIDENT_DISTANCE_QUAL_UOM , INCIDENT_DISTANCE_QUAL_UOM , OLD_INCIDENT_ADDRESS2 , INCIDENT_ADDRESS2 , OLD_INCIDENT_ADDRESS3 , INCIDENT_ADDRESS3 , OLD_INCIDENT_ADDRESS4 , INCIDENT_ADDRESS4 , OLD_INCIDENT_ADDRESS_STYLE , INCIDENT_ADDRESS_STYLE , OLD_INCIDENT_ADDR_LNS_PHONETIC , INCIDENT_ADDR_LNS_PHONETIC , OLD_INCIDENT_PO_BOX_NUMBER , INCIDENT_PO_BOX_NUMBER , OLD_INCIDENT_HOUSE_NUMBER , INCIDENT_HOUSE_NUMBER , OLD_INCIDENT_STREET_SUFFIX , INCIDENT_STREET_SUFFIX , OLD_INCIDENT_STREET , INCIDENT_STREET , OLD_INCIDENT_STREET_NUMBER , INCIDENT_STREET_NUMBER , OLD_INCIDENT_FLOOR , INCIDENT_FLOOR , OLD_INCIDENT_SUITE , INCIDENT_SUITE , OLD_INCIDENT_POSTAL_PLUS4_CODE , INCIDENT_POSTAL_PLUS4_CODE , OLD_INCIDENT_POSITION , INCIDENT_POSITION , OLD_INCIDENT_LOC_DIRECTIONS , INCIDENT_LOC_DIRECTIONS , OLD_INCIDEN
T_LOC_DESCRIPTION , INCIDENT_LOC_DESCRIPTION , OLD_INSTALL_SITE_ID , INSTALL_SITE_ID , INCIDENT_LAST_MODIFIED_DATE , UPDATED_ENTITY_CODE , UPDATED_ENTITY_ID , ENTITY_ACTIVITY_CODE , OLD_TIER_VERSION , TIER_VERSION , OLD_INC_OBJECT_VERSION_NUMBER , INC_OBJECT_VERSION_NUMBER , OLD_INC_REQUEST_ID , INC_REQUEST_ID , OLD_INC_PROGRAM_APPLICATION_ID , INC_PROGRAM_APPLICATION_ID , OLD_INC_PROGRAM_ID , INC_PROGRAM_ID , OLD_INC_PROGRAM_UPDATE_DATE , INC_PROGRAM_UPDATE_DATE , OLD_OWNING_DEPARTMENT_ID , OWNING_DEPARTMENT_ID , OLD_ITEM_SERIAL_NUMBER , ITEM_SERIAL_NUMBER , OLD_INCIDENT_LOCATION_TYPE , INCIDENT_LOCATION_TYPE , OLD_UNASSIGNED_INDICATOR , UNASSIGNED_INDICATOR ) VALUES( :B403 , :B402 , :B401 , :B400 , :B401 , :B400 , :B399 , TO_CHAR(:B398 , 'HH24:MI:SS'), :B397 , :B396 , :B395 , :B394 , :B393 , :B392 , :B391 , :B390 , :B389 , :B388 , :B387 , :B386 , :B385 , :B384 , :B383 , :B382 , :B381 , :B380 , :B379 , :B378 , :B377 , :B376 , :B375 , :B374 , :B373 , :B372 , :B371 , :B370 , :B369 , :B368 , :B367 , :B366 , :B365 , :B364 , :B363 , :B362 , :B361 , :B360 , :B359 , :B358 , :B357 , :B356 , :B355 , :B354 , :B353 , :B352 , :B351 , :B350 , :B349 , :B348 , :B347 , :B346 , :B345 , :B344 , :B343 , :B342 , :B341 , :B340 , :B339 , :B338 , :B337 , :B336 , :B335 , :B334 , :B333 , :B332 , :B331 , :B330 , :B329 , :B328 , :B327 , :B326 , :B325 , :B324 , :B323 , :B322 , :B321 , :B320 ,
:B319 , :B318 , :B317 , :B316 , :B315 , :B314 , :B313 , :B312 , :B311 , :B310 , :B309 , :B308 , :B307 , :B306 , :B305 , :B304 , :B303 , :B302 , :B301 , :B300 , :B299 , :B298 , :B297 , 1, '', :B296 , :B295 , :B294 , :B293 , :B292 , :B291 , :B290 , :B289 , :B288 , :B287 , :B286 , :B285 , :B284 , :B283 , :B282 , :B281 , :B280 , :B279 , :B278 , :B277 , :B276 , :B275 , :B274 , :B273 , :B272 , :B271 , :B270 , :B269 , :B268 , :B267 , :B266 , :B265 , :B264 , :B263 , :B262 , :B261 , :B260 , :B259 , :B258 , :B257 , :B256 , :B255 , :B254 , :B253 , :B252 , :B251 , :B250 , :B249 , :B248 , :B247 , :B246 , :B245 , :B244 , :B243 , :B242 , :B241 , :B240 , :B239 , :B238 , :B237 , :B236 , :B235 , :B234 , :B233 , :B232 , :B231 , :B230 , :B229 , :B228 , :B227 , :B226 , :B225 , :B224 , :B223 , :B222 , :B221 , :B220 , :B219 , :B218 , :B217 , :B216 , :B215 , :B214 , :B213 , :B212 , :B211 , :B210 , :B209 , :B208 , :B207 , :B206 , :B205 , :B204 , :B203 , :B202 , :B201 , :B200 , :B199 , :B198 , :B197 , :B196 , :B195 , :B194 , :B193 , :B192 , :B191 , :B190 , :B189 , :B188 , :B187 , :B186 , :B185 , :B184 , :B183 , :B182 , :B181 , :B180 , :B179 , :B178 , :B177 , :B176 , :B175 , :B174 , :B173 , :B172 , :B171 , :B170 , :B169 , :B168 , :B167 , :B166 , :B165 , :B164 , :B163 , :B162 , :B161 , :B160 , :B159 , :B158 , :B157 , :B156 , :B155 , :B15
4 , :B153 , :B152 , :B151 , :B150 , :B149 , :B148 , :B147 , :B146 , :B145 , :B144 , :B143 , :B142 , :B141 , :B140 , :B139 , :B138 , :B137 , :B136 , :B135 , :B134 , :B133 , :B132 , :B131 , :B130 , :B129 , :B128 , :B127 , :B126 , :B125 , :B124 , :B123 , :B122 , :B121 , :B120 , :B119 , :B118 , :B117 , :B116 , :B115 , :B114 , :B113 , :B112 , :B111 , :B110 , :B109 , :B108 , :B107 , :B106 , :B105 , :B104 , :B103 , :B102 , :B101 , :B100 , :B99 , :B98 , :B97 , :B96 , :B95 , :B94 , :B93 , :B92 , :B91 , :B90 , :B89 , :B88 , :B87 , :B86 , :B85 , :B84 , :B83 , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) RETURNING INCIDENT_AUDIT_ID INTO :O0
|
| 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 | 3,679,326 | 1,019.83 | 3.20 |
| CPU used when call started | 3,660,214 | 1,014.53 | 3.18 |
| CR blocks created | 15,937,697 | 4,417.60 | 13.85 |
| Cached Commit SCN referenced | 891,889 | 247.21 | 0.78 |
| Commit SCN cached | 465 | 0.13 | 0.00 |
| DB time | 7,994,338 | 2,215.86 | 6.95 |
| DBWR checkpoint buffers written | 3,555,652 | 985.55 | 3.09 |
| DBWR checkpoints | 34 | 0.01 | 0.00 |
| DBWR object drop buffers written | 57,489 | 15.93 | 0.05 |
| DBWR revisited being-written buffer | 85 | 0.02 | 0.00 |
| DBWR thread checkpoint buffers written | 517,326 | 143.39 | 0.45 |
| DBWR transaction table writes | 3,340 | 0.93 | 0.00 |
| DBWR undo block writes | 1,715,288 | 475.44 | 1.49 |
| DFO trees parallelized | 48 | 0.01 | 0.00 |
| IMU CR rollbacks | 27,503,521 | 7,623.40 | 23.90 |
| IMU Flushes | 328,222 | 90.98 | 0.29 |
| IMU Redo allocation size | 2,366,117,080 | 655,838.13 | 2,056.37 |
| IMU commits | 604,013 | 167.42 | 0.52 |
| IMU contention | 37,942 | 10.52 | 0.03 |
| IMU ktichg flush | 8,544 | 2.37 | 0.01 |
| IMU pool not allocated | 0 | 0.00 | 0.00 |
| IMU recursive-transaction flush | 1,668 | 0.46 | 0.00 |
| IMU undo allocation size | 5,342,639,592 | 1,480,867.88 | 4,643.25 |
| IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
| PX local messages recv'd | 69,457 | 19.25 | 0.06 |
| PX local messages sent | 69,457 | 19.25 | 0.06 |
| Parallel operations downgraded 25 to 50 pct | 40 | 0.01 | 0.00 |
| Parallel operations not downgraded | 8 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 47,076,322 | 13,048.57 | 40.91 |
| active txn count during cleanout | 83,297,222 | 23,088.25 | 72.39 |
| application wait time | 51,193 | 14.19 | 0.04 |
| background checkpoints completed | 3 | 0.00 | 0.00 |
| background checkpoints started | 2 | 0.00 | 0.00 |
| background timeouts | 13,777 | 3.82 | 0.01 |
| branch node splits | 845 | 0.23 | 0.00 |
| buffer is not pinned count | 604,835,445 | 167,647.73 | 525.66 |
| buffer is pinned count | 1,104,162,503 | 306,050.74 | 959.62 |
| bytes received via SQL*Net from client | 8,827,271,773 | 2,446,734.99 | 7,671.71 |
| bytes sent via SQL*Net to client | 8,463,520,403 | 2,345,910.72 | 7,355.58 |
| calls to get snapshot scn: kcmgss | 124,783,175 | 34,587.28 | 108.45 |
| calls to kcmgas | 20,123,283 | 5,577.75 | 17.49 |
| calls to kcmgcs | 9,780,418 | 2,710.93 | 8.50 |
| change write time | 77,768 | 21.56 | 0.07 |
| cleanout - number of ktugct calls | 23,949,821 | 6,638.39 | 20.81 |
| cleanouts and rollbacks - consistent read gets | 13,773,837 | 3,817.82 | 11.97 |
| cleanouts only - consistent read gets | 166,659 | 46.19 | 0.14 |
| cluster key scan block gets | 1,465,256 | 406.14 | 1.27 |
| cluster key scans | 168,926 | 46.82 | 0.15 |
| commit batch performed | 0 | 0.00 | 0.00 |
| commit batch requested | 0 | 0.00 | 0.00 |
| commit batch/immediate performed | 5,569 | 1.54 | 0.00 |
| commit batch/immediate requested | 5,569 | 1.54 | 0.00 |
| commit cleanout failures: block lost | 278,448 | 77.18 | 0.24 |
| commit cleanout failures: buffer being written | 1,807 | 0.50 | 0.00 |
| commit cleanout failures: callback failure | 110,527 | 30.64 | 0.10 |
| commit cleanout failures: cannot pin | 36,406 | 10.09 | 0.03 |
| commit cleanouts | 9,578,732 | 2,655.02 | 8.32 |
| commit cleanouts successfully completed | 9,151,544 | 2,536.62 | 7.95 |
| commit immediate performed | 5,569 | 1.54 | 0.00 |
| commit immediate requested | 5,569 | 1.54 | 0.00 |
| commit txn count during cleanout | 1,417,782 | 392.98 | 1.23 |
| concurrency wait time | 48,282 | 13.38 | 0.04 |
| consistent changes | 663,234,818 | 183,834.81 | 576.41 |
| consistent gets | 1,726,547,427 | 478,562.81 | 1,500.53 |
| consistent gets - examination | 1,166,823,394 | 323,419.02 | 1,014.08 |
| consistent gets from cache | 1,726,547,383 | 478,562.80 | 1,500.53 |
| cursor authentications | 1,967 | 0.55 | 0.00 |
| data blocks consistent reads - undo records applied | 658,708,070 | 182,580.09 | 572.48 |
| db block changes | 199,021,431 | 55,164.58 | 172.97 |
| db block gets | 220,124,791 | 61,013.99 | 191.31 |
| db block gets direct | 4,285 | 1.19 | 0.00 |
| db block gets from cache | 220,120,506 | 61,012.80 | 191.30 |
| deferred (CURRENT) block cleanout applications | 1,525,545 | 422.85 | 1.33 |
| dirty buffers inspected | 10,997 | 3.05 | 0.01 |
| enqueue conversions | 10,406 | 2.88 | 0.01 |
| enqueue releases | 4,666,710 | 1,293.51 | 4.06 |
| enqueue requests | 4,677,012 | 1,296.37 | 4.06 |
| enqueue timeouts | 10,237 | 2.84 | 0.01 |
| enqueue waits | 58,115 | 16.11 | 0.05 |
| exchange deadlocks | 48,657 | 13.49 | 0.04 |
| execute count | 112,020,295 | 31,049.68 | 97.36 |
| failed probes on index block reclamation | 9,373 | 2.60 | 0.01 |
| free buffer inspected | 3,613,282 | 1,001.53 | 3.14 |
| free buffer requested | 20,696,993 | 5,736.77 | 17.99 |
| heap block compress | 26,612,790 | 7,376.51 | 23.13 |
| hot buffers moved to head of LRU | 1,597,393 | 442.76 | 1.39 |
| immediate (CR) block cleanout applications | 13,940,497 | 3,864.01 | 12.12 |
| immediate (CURRENT) block cleanout applications | 1,290,317 | 357.65 | 1.12 |
| index crx upgrade (found) | 61,817 | 17.13 | 0.05 |
| index crx upgrade (positioned) | 11,889,375 | 3,295.49 | 10.33 |
| index fast full scans (rowid ranges) | 1,648 | 0.46 | 0.00 |
| index fetch by key | 193,738,004 | 53,700.12 | 168.38 |
| index scans kdiixs1 | 143,608,228 | 39,805.20 | 124.81 |
| java call heap collected bytes | 1,234,039,392 | 342,049.89 | 1,072.49 |
| java call heap collected count | 15,462,001 | 4,285.74 | 13.44 |
| java call heap gc count | 5,068 | 1.40 | 0.00 |
| java call heap live object count | 1,633,233 | 452.70 | 1.42 |
| java call heap live object count max | 1,630,520 | 451.95 | 1.42 |
| java call heap live size | 507,185,400 | 140,581.18 | 440.79 |
| java call heap live size max | 506,888,808 | 140,498.97 | 440.53 |
| java call heap object count | 3,562,582 | 987.47 | 3.10 |
| java call heap object count max | 3,565,783 | 988.36 | 3.10 |
| java call heap total size | 683,885,824 | 189,558.84 | 594.36 |
| java call heap total size max | 683,090,432 | 189,338.37 | 593.67 |
| java call heap used size | 634,020,224 | 175,737.14 | 551.02 |
| java call heap used size max | 634,341,984 | 175,826.32 | 551.30 |
| leaf node 90-10 splits | 20,614 | 5.71 | 0.02 |
| leaf node splits | 245,776 | 68.12 | 0.21 |
| lob reads | 21,557 | 5.98 | 0.02 |
| lob writes | 37,058 | 10.27 | 0.03 |
| lob writes unaligned | 37,058 | 10.27 | 0.03 |
| logons cumulative | 9,996 | 2.77 | 0.01 |
| messages received | 2,395,159 | 663.89 | 2.08 |
| messages sent | 2,395,159 | 663.89 | 2.08 |
| no buffer to keep pinned count | 16 | 0.00 | 0.00 |
| no work - consistent read gets | 507,287,515 | 140,609.48 | 440.88 |
| opened cursors cumulative | 12,412,865 | 3,440.59 | 10.79 |
| parse count (failures) | 3,243 | 0.90 | 0.00 |
| parse count (hard) | 8,471 | 2.35 | 0.01 |
| parse count (total) | 16,348,027 | 4,531.33 | 14.21 |
| parse time cpu | 100,332 | 27.81 | 0.09 |
| parse time elapsed | 113,939 | 31.58 | 0.10 |
| physical read IO requests | 392,576 | 108.81 | 0.34 |
| physical read bytes | 4,517,494,784 | 1,252,155.01 | 3,926.12 |
| physical read total IO requests | 394,263 | 109.28 | 0.34 |
| physical read total bytes | 4,544,225,280 | 1,259,564.14 | 3,949.35 |
| physical read total multi block requests | 26,421 | 7.32 | 0.02 |
| physical reads | 551,452 | 152.85 | 0.48 |
| physical reads cache | 550,658 | 152.63 | 0.48 |
| physical reads cache prefetch | 158,696 | 43.99 | 0.14 |
| physical reads direct | 794 | 0.22 | 0.00 |
| physical reads direct temporary tablespace | 186 | 0.05 | 0.00 |
| physical reads prefetch warmup | 113,841 | 31.55 | 0.10 |
| physical write IO requests | 1,383,080 | 383.36 | 1.20 |
| physical write bytes | 29,861,101,568 | 8,276,872.39 | 25,952.05 |
| physical write total IO requests | 2,719,927 | 753.91 | 2.36 |
| physical write total bytes | 65,746,881,536 | 18,223,659.54 | 57,140.10 |
| physical write total multi block requests | 1,663,123 | 460.98 | 1.45 |
| physical writes | 3,645,154 | 1,010.36 | 3.17 |
| physical writes direct | 4,804 | 1.33 | 0.00 |
| physical writes direct (lob) | 218 | 0.06 | 0.00 |
| physical writes direct temporary tablespace | 4,153 | 1.15 | 0.00 |
| physical writes from cache | 3,640,350 | 1,009.03 | 3.16 |
| physical writes non checkpoint | 2,471,743 | 685.12 | 2.15 |
| pinned buffers inspected | 4,492 | 1.25 | 0.00 |
| prefetch warmup blocks aged out before use | 306,342 | 84.91 | 0.27 |
| prefetched blocks aged out before use | 45 | 0.01 | 0.00 |
| process last non-idle time | 3,606 | 1.00 | 0.00 |
| queries parallelized | 48 | 0.01 | 0.00 |
| recursive aborts on index block reclamation | 2 | 0.00 | 0.00 |
| recursive calls | 201,297,374 | 55,795.42 | 174.95 |
| recursive cpu usage | 2,063,672 | 572.01 | 1.79 |
| redo blocks written | 34,961,177 | 9,690.51 | 30.38 |
| redo buffer allocation retries | 0 | 0.00 | 0.00 |
| redo entries | 102,140,485 | 28,311.20 | 88.77 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 1,283,056 | 355.64 | 1.12 |
| redo size | 34,458,580,744 | 9,551,197.40 | 29,947.68 |
| redo subscn max counts | 2,556,167 | 708.52 | 2.22 |
| redo synch time | 55,233 | 15.31 | 0.05 |
| redo synch writes | 2,692,642 | 746.34 | 2.34 |
| redo wastage | 763,633,792 | 211,663.31 | 663.67 |
| redo write time | 53,634 | 14.87 | 0.05 |
| redo writer latching time | 90 | 0.02 | 0.00 |
| redo writes | 867,351 | 240.41 | 0.75 |
| rollback changes - undo records applied | 247,574 | 68.62 | 0.22 |
| rollbacks only - consistent read gets | 2,333,213 | 646.72 | 2.03 |
| rows fetched via callback | 100,093,891 | 27,743.93 | 86.99 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 7,109,044 | 1,970.48 | 6.18 |
| session logical reads | 1,946,676,812 | 539,578.07 | 1,691.84 |
| session pga memory | 6,392,002,664 | 1,771,729.36 | 5,555.24 |
| session pga memory max | 8,707,344,680 | 2,413,493.71 | 7,567.48 |
| session uga memory | ############### | 71,486,193.66 | 224,144.23 |
| session uga memory max | 70,544,248,456 | 19,553,389.25 | 61,309.45 |
| shared hash latch upgrades - no wait | 34,116,163 | 9,456.29 | 29.65 |
| shared hash latch upgrades - wait | 86,109 | 23.87 | 0.07 |
| sorts (memory) | 12,203,293 | 3,382.50 | 10.61 |
| sorts (rows) | 145,144,897 | 40,231.13 | 126.14 |
| sql area evicted | 714 | 0.20 | 0.00 |
| sql area purged | 3,412 | 0.95 | 0.00 |
| summed dirty queue length | 285,199 | 79.05 | 0.25 |
| switch current to new buffer | 1,451,255 | 402.26 | 1.26 |
| table fetch by rowid | 698,310,882 | 193,557.16 | 606.90 |
| table fetch continued row | 32,774,346 | 9,084.36 | 28.48 |
| table scan blocks gotten | 95,551,842 | 26,484.97 | 83.04 |
| table scan rows gotten | 4,988,928,267 | 1,382,826.50 | 4,335.84 |
| table scans (long tables) | 4,642 | 1.29 | 0.00 |
| table scans (rowid ranges) | 4,640 | 1.29 | 0.00 |
| table scans (short tables) | 6,532,275 | 1,810.61 | 5.68 |
| total number of times SMON posted | 102,471 | 28.40 | 0.09 |
| transaction rollbacks | 5,569 | 1.54 | 0.00 |
| transaction tables consistent read rollbacks | 138 | 0.04 | 0.00 |
| transaction tables consistent reads - undo records applied | 6,301 | 1.75 | 0.01 |
| undo change vector size | 12,150,718,224 | 3,367,924.79 | 10,560.09 |
| user I/O wait time | 197,020 | 54.61 | 0.17 |
| user calls | 44,800,794 | 12,417.84 | 38.94 |
| user commits | 911,546 | 252.66 | 0.79 |
| user rollbacks | 239,080 | 66.27 | 0.21 |
| workarea executions - onepass | 2 | 0.00 | 0.00 |
| workarea executions - optimal | 7,464,516 | 2,069.01 | 6.49 |
| write clones created in background | 1,219 | 0.34 | 0.00 |
| write clones created in foreground | 17,959 | 4.98 | 0.02 |
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 | 426,435 | 1,195,346 |
| opened cursors current | 785,547 | 817,820 |
| workarea memory allocated | 4,977 | 1,141 |
| logons current | 4,740 | 4,706 |
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 |
64 | 0 | 5.47 | 1.00 | 491,869 | 136 | 259,175 | 0.04 |
| APPS_TS_TX_DATA |
183,337 | 51 | 4.85 | 1.30 | 223,367 | 62 | 104,693 | 0.30 |
| APPS_TS_TX_IDX |
131,028 | 36 | 5.31 | 1.38 | 222,930 | 62 | 82,503 | 0.31 |
| APPS_ASSM_DATA |
22,257 | 6 | 3.25 | 2.95 | 212,119 | 59 | 53,967 | 0.04 |
| APPS_ASSM_IDX |
39,535 | 11 | 4.14 | 1.01 | 141,888 | 39 | 307,012 | 0.09 |
| APPS_TS_TX_INTERFACE |
723 | 0 | 6.80 | 2.75 | 35,967 | 10 | 2,953 | 0.06 |
| APPS_TS_QUEUES |
3,022 | 1 | 8.40 | 1.50 | 22,822 | 6 | 96 | 1.04 |
| SYSTEM |
8,126 | 2 | 5.28 | 1.44 | 5,526 | 2 | 8,418 | 0.73 |
| TEMP |
973 | 0 | 3.51 | 4.71 | 9,020 | 3 | 68 | 32.50 |
| APPS_TS_SEED |
2,615 | 1 | 7.73 | 1.52 | 4,359 | 1 | 1,396 | 2.15 |
| APPS_TS_SUMMARY |
56 | 0 | 5.89 | 1.00 | 5,802 | 2 | 2,237 | 0.04 |
| CTXSYS |
202 | 0 | 6.83 | 1.32 | 4,540 | 1 | 0 | 0.00 |
| APPS_TS_ARCHIVE |
64 | 0 | 7.50 | 1.50 | 2,132 | 1 | 120 | 5.08 |
| SYSAUX |
498 | 0 | 3.31 | 1.93 | 675 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING |
34 | 0 | 3.53 | 1.35 | 68 | 0 | 39 | 7.44 |
| APPS_TS_MEDIA |
9 | 0 | 5.56 | 1.00 | 9 | 0 | 0 | 0.00 |
| ODM |
7 | 0 | 4.29 | 1.00 | 3 | 0 | 0 | 0.00 |
| OLAP |
7 | 0 | 4.29 | 1.00 | 3 | 0 | 0 | 0.00 |
| OWAPUB |
7 | 0 | 5.71 | 1.00 | 3 | 0 | 0 | 0.00 |
| PORTAL |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYNCSERVER |
7 | 0 | 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 |
22,257 | 6 | 3.25 | 2.95 | 212,119 | 59 | 53,967 | 0.04 |
| APPS_ASSM_IDX | /oracle/visdata/apps_assm_idx.dbf |
39,535 | 11 | 4.14 | 1.01 | 141,888 | 39 | 307,012 | 0.09 |
| APPS_TS_ARCHIVE | /oasb_data/archive1.dbf |
17 | 0 | 7.06 | 1.53 | 1,025 | 0 | 59 | 5.76 |
| APPS_TS_ARCHIVE | /oasb_data/archive2.dbf |
47 | 0 | 7.66 | 1.49 | 1,107 | 0 | 61 | 4.43 |
| APPS_TS_MEDIA | /oasb_data/media1.dbf |
3 | 0 | 3.33 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oasb_data/media2.dbf |
3 | 0 | 13.33 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oasb_data/media3.dbf |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /oasb_data/nologging1.dbf |
18 | 0 | 5.56 | 1.67 | 62 | 0 | 39 | 7.44 |
| 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 |
418 | 0 | 7.30 | 1.37 | 2,864 | 1 | 4 | 10.00 |
| APPS_TS_QUEUES | /oasb_data/queues2.dbf |
477 | 0 | 9.35 | 1.59 | 3,764 | 1 | 15 | 0.00 |
| APPS_TS_QUEUES | /oasb_data/queues3.dbf |
440 | 0 | 8.16 | 1.47 | 3,340 | 1 | 13 | 0.77 |
| APPS_TS_QUEUES | /oasb_data/queues4.dbf |
418 | 0 | 7.32 | 1.47 | 3,362 | 1 | 57 | 0.53 |
| APPS_TS_QUEUES | /oasb_data/queues5.dbf |
448 | 0 | 8.19 | 1.57 | 3,056 | 1 | 1 | 0.00 |
| APPS_TS_QUEUES | /oasb_data/queues6.dbf |
402 | 0 | 7.99 | 1.54 | 3,224 | 1 | 5 | 0.00 |
| APPS_TS_QUEUES | /oasb_data/queues7.dbf |
419 | 0 | 10.38 | 1.52 | 3,212 | 1 | 1 | 20.00 |
| APPS_TS_SEED | /oasb_data/reference1.dbf |
217 | 0 | 9.17 | 1.69 | 355 | 0 | 460 | 1.41 |
| APPS_TS_SEED | /oasb_data/reference10.dbf |
187 | 0 | 7.17 | 1.52 | 318 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference2.dbf |
304 | 0 | 6.15 | 1.54 | 328 | 0 | 852 | 2.70 |
| APPS_TS_SEED | /oasb_data/reference3.dbf |
280 | 0 | 7.96 | 1.56 | 500 | 0 | 19 | 1.58 |
| APPS_TS_SEED | /oasb_data/reference4.dbf |
259 | 0 | 8.38 | 1.54 | 422 | 0 | 65 | 0.31 |
| APPS_TS_SEED | /oasb_data/reference5.dbf |
265 | 0 | 7.96 | 1.66 | 394 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference6.dbf |
292 | 0 | 7.95 | 1.52 | 590 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference7.dbf |
276 | 0 | 7.39 | 1.42 | 469 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference8.dbf |
273 | 0 | 8.06 | 1.35 | 465 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /oasb_data/reference9.dbf |
262 | 0 | 7.44 | 1.44 | 518 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /oasb_data/summary1.dbf |
13 | 0 | 9.23 | 1.00 | 782 | 0 | 251 | 0.08 |
| APPS_TS_SUMMARY | /oasb_data/summary2.dbf |
4 | 0 | 5.00 | 1.00 | 166 | 0 | 7 | 0.00 |
| APPS_TS_SUMMARY | /oasb_data/summary3.dbf |
4 | 0 | 15.00 | 1.00 | 1,089 | 0 | 277 | 0.00 |
| APPS_TS_SUMMARY | /oasb_data/summary4.dbf |
6 | 0 | 1.67 | 1.00 | 919 | 0 | 246 | 0.00 |
| APPS_TS_SUMMARY | /oasb_data/summary5.dbf |
4 | 0 | 5.00 | 1.00 | 768 | 0 | 792 | 0.00 |
| APPS_TS_SUMMARY | /oasb_data/summary6.dbf |
8 | 0 | 6.25 | 1.00 | 645 | 0 | 235 | 0.09 |
| APPS_TS_SUMMARY | /oasb_data/summary7.dbf |
9 | 0 | 2.22 | 1.00 | 694 | 0 | 279 | 0.11 |
| APPS_TS_SUMMARY | /oasb_data/summary8.dbf |
8 | 0 | 3.75 | 1.00 | 739 | 0 | 150 | 0.13 |
| APPS_TS_TX_DATA | /oasb_data/tx_data1.dbf |
523 | 0 | 4.51 | 1.90 | 9,656 | 3 | 5,118 | 0.32 |
| APPS_TS_TX_DATA | /oasb_data/tx_data10.dbf |
398 | 0 | 3.82 | 1.55 | 10,104 | 3 | 4,032 | 0.41 |
| APPS_TS_TX_DATA | /oasb_data/tx_data11.dbf |
577 | 0 | 3.19 | 1.63 | 10,447 | 3 | 5,255 | 0.47 |
| APPS_TS_TX_DATA | /oasb_data/tx_data12.dbf |
16,687 | 5 | 4.71 | 1.27 | 11,271 | 3 | 4,458 | 0.33 |
| APPS_TS_TX_DATA | /oasb_data/tx_data13.dbf |
16,741 | 5 | 4.91 | 1.27 | 11,469 | 3 | 4,584 | 0.08 |
| APPS_TS_TX_DATA | /oasb_data/tx_data14.dbf |
16,630 | 5 | 4.98 | 1.28 | 11,347 | 3 | 4,954 | 0.06 |
| APPS_TS_TX_DATA | /oasb_data/tx_data15.dbf |
16,600 | 5 | 4.97 | 1.28 | 11,567 | 3 | 4,882 | 0.06 |
| APPS_TS_TX_DATA | /oasb_data/tx_data16.dbf |
16,594 | 5 | 4.97 | 1.27 | 11,620 | 3 | 4,347 | 0.08 |
| APPS_TS_TX_DATA | /oasb_data/tx_data17.dbf |
16,660 | 5 | 4.83 | 1.27 | 11,201 | 3 | 4,283 | 0.16 |
| APPS_TS_TX_DATA | /oasb_data/tx_data18.dbf |
16,705 | 5 | 4.95 | 1.28 | 10,677 | 3 | 4,935 | 0.09 |
| APPS_TS_TX_DATA | /oasb_data/tx_data19.dbf |
16,458 | 5 | 5.10 | 1.28 | 10,906 | 3 | 4,866 | 0.07 |
| APPS_TS_TX_DATA | /oasb_data/tx_data2.dbf |
616 | 0 | 3.33 | 2.09 | 9,947 | 3 | 4,995 | 0.69 |
| APPS_TS_TX_DATA | /oasb_data/tx_data20.dbf |
16,674 | 5 | 4.92 | 1.30 | 10,999 | 3 | 4,693 | 0.20 |
| APPS_TS_TX_DATA | /oasb_data/tx_data21.dbf |
16,594 | 5 | 4.93 | 1.29 | 11,065 | 3 | 4,061 | 0.18 |
| APPS_TS_TX_DATA | /oasb_data/tx_data3.dbf |
1,017 | 0 | 2.81 | 1.62 | 10,464 | 3 | 5,242 | 0.55 |
| APPS_TS_TX_DATA | /oasb_data/tx_data4.dbf |
1,262 | 0 | 3.09 | 1.54 | 10,549 | 3 | 4,906 | 0.45 |
| APPS_TS_TX_DATA | /oasb_data/tx_data5.dbf |
4,586 | 1 | 5.07 | 1.38 | 9,974 | 3 | 5,405 | 0.36 |
| APPS_TS_TX_DATA | /oasb_data/tx_data6.dbf |
1,434 | 0 | 3.38 | 1.47 | 9,872 | 3 | 4,894 | 0.44 |
| APPS_TS_TX_DATA | /oasb_data/tx_data7.dbf |
4,420 | 1 | 4.86 | 1.32 | 9,792 | 3 | 5,855 | 0.35 |
| APPS_TS_TX_DATA | /oasb_data/tx_data8.dbf |
990 | 0 | 3.40 | 1.54 | 10,803 | 3 | 7,439 | 0.34 |
| APPS_TS_TX_DATA | /oasb_data/tx_data9.dbf |
1,171 | 0 | 2.50 | 1.47 | 9,637 | 3 | 5,489 | 0.38 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx1.dbf |
552 | 0 | 4.55 | 1.22 | 5,517 | 2 | 2,086 | 0.40 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx10.dbf |
683 | 0 | 5.27 | 1.19 | 13,660 | 4 | 1,530 | 0.46 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx11.dbf |
1,085 | 0 | 4.83 | 1.12 | 11,188 | 3 | 3,365 | 1.11 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx12.dbf |
12,036 | 3 | 5.15 | 1.40 | 13,539 | 4 | 5,771 | 0.12 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx13.dbf |
12,038 | 3 | 5.14 | 1.38 | 12,611 | 3 | 5,212 | 0.16 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx14.dbf |
11,859 | 3 | 5.38 | 1.34 | 12,309 | 3 | 4,624 | 0.29 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx15.dbf |
11,940 | 3 | 5.35 | 1.32 | 12,521 | 3 | 4,743 | 0.11 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx16.dbf |
11,766 | 3 | 5.18 | 1.36 | 11,434 | 3 | 4,542 | 0.14 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx17.dbf |
11,822 | 3 | 5.21 | 1.33 | 11,693 | 3 | 4,250 | 0.18 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx18.dbf |
11,617 | 3 | 5.42 | 1.42 | 11,376 | 3 | 4,099 | 0.09 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx19.dbf |
11,802 | 3 | 5.48 | 1.45 | 11,904 | 3 | 5,231 | 0.10 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx2.dbf |
696 | 0 | 4.24 | 1.16 | 9,576 | 3 | 8,378 | 0.39 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx20.dbf |
11,570 | 3 | 5.30 | 1.44 | 11,296 | 3 | 4,940 | 0.23 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx21.dbf |
11,773 | 3 | 5.60 | 1.42 | 11,198 | 3 | 5,823 | 0.09 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx3.dbf |
1,137 | 0 | 5.05 | 1.27 | 10,888 | 3 | 1,922 | 1.10 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx4.dbf |
1,561 | 0 | 5.19 | 1.32 | 9,734 | 3 | 1,993 | 1.11 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx5.dbf |
1,542 | 0 | 5.76 | 1.27 | 8,701 | 2 | 1,917 | 0.71 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx6.dbf |
1,496 | 0 | 5.16 | 1.42 | 8,644 | 2 | 2,170 | 0.30 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx7.dbf |
1,435 | 0 | 5.46 | 1.29 | 8,160 | 2 | 3,199 | 0.45 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx8.dbf |
1,321 | 0 | 5.40 | 1.33 | 9,539 | 3 | 3,536 | 0.40 |
| APPS_TS_TX_IDX | /oasb_data/tx_idx9.dbf |
1,297 | 0 | 5.57 | 1.42 | 7,442 | 2 | 3,172 | 0.22 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte.dbf |
312 | 0 | 6.70 | 3.83 | 7,819 | 2 | 836 | 0.10 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte2.dbf |
89 | 0 | 5.84 | 1.98 | 5,861 | 2 | 572 | 0.07 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte3.dbf |
76 | 0 | 7.63 | 1.97 | 5,701 | 2 | 420 | 0.00 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte4.dbf |
75 | 0 | 7.73 | 1.87 | 5,625 | 2 | 470 | 0.09 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte5.dbf |
70 | 0 | 6.57 | 2.19 | 5,474 | 2 | 238 | 0.00 |
| APPS_TS_TX_INTERFACE | /oasb_data/ts_tx_inte6.dbf |
101 | 0 | 6.83 | 1.75 | 5,487 | 2 | 417 | 0.05 |
| APPS_UNDOTS1 | /oasb_data/undo01.dbf |
4 | 0 | 15.00 | 1.00 | 47,116 | 13 | 25,443 | 0.08 |
| APPS_UNDOTS1 | /oasb_data/undo02.dbf |
3 | 0 | 6.67 | 1.00 | 48,236 | 13 | 27,652 | 0.06 |
| APPS_UNDOTS1 | /oasb_data/undo03.dbf |
3 | 0 | 6.67 | 1.00 | 47,628 | 13 | 29,515 | 0.03 |
| APPS_UNDOTS1 | /oasb_data/undo04.dbf |
4 | 0 | 15.00 | 1.00 | 50,748 | 14 | 27,733 | 0.03 |
| APPS_UNDOTS1 | /oasb_data/undo05.dbf |
8 | 0 | 5.00 | 1.00 | 52,002 | 14 | 22,567 | 0.03 |
| APPS_UNDOTS1 | /oasb_data/undo06.dbf |
8 | 0 | 1.25 | 1.00 | 53,536 | 15 | 32,672 | 0.04 |
| APPS_UNDOTS1 | /oasb_data/undo07.dbf |
9 | 0 | 3.33 | 1.00 | 50,981 | 14 | 25,606 | 0.04 |
| APPS_UNDOTS1 | /oasb_data/undo08.dbf |
8 | 0 | 3.75 | 1.00 | 48,818 | 14 | 26,162 | 0.04 |
| APPS_UNDOTS1 | /oasb_data/undo09.dbf |
9 | 0 | 6.67 | 1.00 | 47,583 | 13 | 22,770 | 0.04 |
| APPS_UNDOTS1 | /oracle/visdata/undo10.dbf |
8 | 0 | 2.50 | 1.00 | 45,221 | 13 | 19,055 | 0.02 |
| CTXSYS | /oasb_data/ctx1.dbf |
79 | 0 | 6.84 | 1.38 | 541 | 0 | 0 | 0.00 |
| CTXSYS | /oasb_data/ctx2.dbf |
123 | 0 | 6.83 | 1.28 | 3,999 | 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 | 4.29 | 1.00 | 3 | 0 | 0 | 0.00 |
| OWAPUB | /oasb_data/owa1.dbf |
7 | 0 | 5.71 | 1.00 | 3 | 0 | 0 | 0.00 |
| PORTAL | /oasb_data/portal.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYNCSERVER | /oasb_data/mobile01.dbf |
7 | 0 | 2.86 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYSAUX | /oasb_data/sysaux01.dbf |
183 | 0 | 3.06 | 1.76 | 93 | 0 | 0 | 0.00 |
| SYSAUX | /oasb_data/sysaux02.dbf |
315 | 0 | 3.46 | 2.03 | 582 | 0 | 0 | 0.00 |
| SYSTEM | /oasb_data/sys1.dbf |
1,091 | 0 | 5.57 | 1.58 | 512 | 0 | 217 | 2.44 |
| SYSTEM | /oasb_data/sys2.dbf |
1,230 | 0 | 5.15 | 1.43 | 633 | 0 | 278 | 3.63 |
| SYSTEM | /oasb_data/sys3.dbf |
1,094 | 0 | 5.19 | 1.40 | 782 | 0 | 323 | 3.68 |
| SYSTEM | /oasb_data/sys4.dbf |
1,246 | 0 | 5.61 | 1.37 | 917 | 0 | 297 | 2.66 |
| SYSTEM | /oasb_data/sys5.dbf |
1,133 | 0 | 5.07 | 1.44 | 1,003 | 0 | 187 | 2.67 |
| SYSTEM | /oasb_data/sys6.dbf |
1,137 | 0 | 4.98 | 1.46 | 830 | 0 | 223 | 3.63 |
| SYSTEM | /oasb_data/sys7.dbf |
1,081 | 0 | 5.44 | 1.48 | 566 | 0 | 300 | 3.03 |
| SYSTEM | /oasb_data/sys8.dbf |
62 | 0 | 4.52 | 1.00 | 77 | 0 | 4,894 | 0.06 |
| SYSTEM | /oasb_data/sys9.dbf |
52 | 0 | 4.42 | 1.08 | 206 | 0 | 1,699 | 0.06 |
| TEMP | /oracle/visdata/temp1.dbf |
174 | 0 | 3.33 | 3.51 | 2,428 | 1 | 4 | 0.00 |
| TEMP | /oracle/visdata/temp2.dbf |
259 | 0 | 2.82 | 4.27 | 2,096 | 1 | 23 | 13.91 |
| TEMP | /oracle/visdata/temp3.dbf |
168 | 0 | 4.76 | 4.61 | 1,824 | 1 | 12 | 56.67 |
| TEMP | /oracle/visdata/temp4.dbf |
372 | 0 | 3.52 | 5.63 | 2,672 | 1 | 29 | 41.72 |
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,012,643 | 100 | 1,944,829,389 | 550,809 | 3,640,248 | 0 | 0 | 822,340 |
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 | 120 | 51139 | 606284 | 2295709 | 47178000 | 2295709 | |
| E | 180 | 139 | 69215 | 806741 | 5688423 | 47178000 | 5688423 | |
Back to Advisory Statistics
Back to Top
|
