|
|
|
AWR Report
WORKLOAD REPOSITORY report for
| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|
| VIS | 189723706 | VIS | 1 | 10.2.0.3.0 | NO | oracle16.engr.sgi.com |
| Snap Id | Snap Time | Sessions | Cursors/Session |
|---|
| Begin Snap: | 1 | 14-Oct-07 12:08:04 | 5013 | 199.7 |
| End Snap: | 2 | 14-Oct-07 13:09:03 | 5041 | 246.6 |
| Elapsed: | | 60.99 (mins) | | |
| DB Time: | | 1,021.50 (mins) | | |
Report Summary
Cache Sizes
| Begin | End | | |
|---|
| Buffer Cache: | 8,000M | 8,000M | Std Block Size: | 8K |
| Shared Pool Size: | 3,008M | 3,008M | Log Buffer: | 30,736K |
Load Profile
| Per Second | Per Transaction |
|---|
| Redo size: | 8,573,728.99 | 26,709.87 |
| Logical reads: | 583,772.42 | 1,818.64 |
| Block changes: | 53,880.37 | 167.85 |
| Physical reads: | 408.02 | 1.27 |
| Physical writes: | 829.84 | 2.59 |
| User calls: | 11,369.46 | 35.42 |
| Parses: | 2,563.73 | 7.99 |
| Hard parses: | 2.54 | 0.01 |
| Sorts: | 2,893.81 | 9.02 |
| Logons: | 3.13 | 0.01 |
| Executes: | 27,311.56 | 85.08 |
| Transactions: | 320.99 | |
| % Blocks changed per Read: | 9.23 | Recursive Call %: | 79.68 |
| Rollback per transaction %: | 21.05 | Rows per Sort: | 10.64 |
Instance Efficiency Percentages (Target 100%)
| Buffer Nowait %: | 99.95 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.95 | In-memory Sort %: | 100.00 |
| Library Hit %: | 100.05 | Soft Parse %: | 99.90 |
| Execute to Parse %: | 90.61 | Latch Hit %: | 98.19 |
| Parse CPU to Parse Elapsd %: | 85.17 | % Non-Parse CPU: | 98.16 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 75.01 | 97.80 |
| % SQL with executions>1: | 74.39 | 79.40 |
| % Memory for SQL w/exec>1: | 66.69 | 50.55 |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|
| CPU time | | 55,639 | | 90.8 | |
| db file sequential read | 883,610 | 2,587 | 3 | 4.2 | User I/O |
| log file sync | 463,185 | 805 | 2 | 1.3 | Commit |
| log file parallel write | 860,185 | 271 | 0 | .4 | System I/O |
| enq: HW - contention | 64,681 | 209 | 3 | .3 | Configuration |
Main Report
Back to Top
Wait Events Statistics
Back to Top
Time Model Statistics
- Total time in database user-calls (DB Time): 61289.9s
- 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 | 55,639.49 | 90.78 |
| sql execute elapsed time | 55,155.19 | 89.99 |
| inbound PL/SQL rpc elapsed time | 10,319.46 | 16.84 |
| PL/SQL execution elapsed time | 8,683.82 | 14.17 |
| Java execution elapsed time | 2,867.44 | 4.68 |
| parse time elapsed | 1,279.70 | 2.09 |
| hard parse elapsed time | 594.97 | 0.97 |
| repeated bind elapsed time | 142.93 | 0.23 |
| sequence load elapsed time | 36.98 | 0.06 |
| connection management call elapsed time | 36.42 | 0.06 |
| PL/SQL compilation elapsed time | 9.04 | 0.01 |
| hard parse (sharing criteria) elapsed time | 3.93 | 0.01 |
| failed parse elapsed time | 3.61 | 0.01 |
| hard parse (bind mismatch) elapsed time | 1.28 | 0.00 |
| DB time | 61,289.92 | |
| background elapsed time | 1,079.91 | |
| background cpu time | 704.28 | |
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 | 1,082,755 | 0.00 | 2,792 | 3 | 0.92 |
| Commit | 463,185 | 0.00 | 805 | 2 | 0.39 |
| Concurrency | 1,327,157 | 0.75 | 426 | 0 | 1.13 |
| System I/O | 1,141,508 | 0.00 | 371 | 0 | 0.97 |
| Application | 79,990 | 0.09 | 315 | 4 | 0.07 |
| Network | 48,133,693 | 0.00 | 255 | 0 | 40.97 |
| Configuration | 83,406 | 0.00 | 218 | 3 | 0.07 |
| Other | 209,889 | 17.26 | 105 | 0 | 0.18 |
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 | 883,610 | 0.00 | 2,587 | 3 | 0.75 |
| log file sync | 463,185 | 0.00 | 805 | 2 | 0.39 |
| log file parallel write | 860,185 | 0.00 | 271 | 0 | 0.73 |
| enq: HW - contention | 64,681 | 0.00 | 209 | 3 | 0.06 |
| read by other session | 174,267 | 0.00 | 171 | 1 | 0.15 |
| enq: UL - contention | 3,173 | 1.32 | 166 | 52 | 0.00 |
| SQL*Net more data from client | 2,421,475 | 0.00 | 110 | 0 | 2.06 |
| cursor: pin S wait on X | 10,504 | 94.20 | 107 | 10 | 0.01 |
| latch: cache buffers chains | 335,062 | 0.00 | 106 | 0 | 0.29 |
| db file parallel write | 277,942 | 0.00 | 98 | 0 | 0.24 |
| enq: TX - row lock contention | 1,013 | 2.96 | 98 | 96 | 0.00 |
| SQL*Net more data to client | 1,964,465 | 0.00 | 84 | 0 | 1.67 |
| buffer busy waits | 876,203 | 0.00 | 77 | 0 | 0.75 |
| SQL*Net message to client | 43,747,753 | 0.00 | 61 | 0 | 37.24 |
| latch: undo global data | 47,282 | 0.00 | 52 | 1 | 0.04 |
| enq: TX - index contention | 30,749 | 0.00 | 38 | 1 | 0.03 |
| latch: library cache | 22,691 | 0.00 | 33 | 1 | 0.02 |
| db file scattered read | 11,859 | 0.00 | 30 | 3 | 0.01 |
| SQL*Net break/reset to client | 75,742 | 0.00 | 28 | 0 | 0.06 |
| library cache load lock | 806 | 0.00 | 20 | 25 | 0.00 |
| latch: In memory undo latch | 29,356 | 0.00 | 16 | 1 | 0.02 |
| enq: KO - fast object checkpoint | 26 | 7.69 | 16 | 609 | 0.00 |
| latch: library cache pin | 10,319 | 0.00 | 16 | 2 | 0.01 |
| latch: redo allocation | 8,697 | 0.00 | 8 | 1 | 0.01 |
| latch: row cache objects | 8,019 | 0.00 | 7 | 1 | 0.01 |
| LGWR wait for redo copy | 36,939 | 0.20 | 6 | 0 | 0.03 |
| kksfbc child completion | 141 | 81.56 | 6 | 41 | 0.00 |
| enq: RO - fast object reuse | 29 | 0.00 | 5 | 188 | 0.00 |
| latch free | 2,229 | 0.00 | 5 | 2 | 0.00 |
| enq: SQ - contention | 17,998 | 0.00 | 5 | 0 | 0.02 |
| enq: TX - contention | 7,705 | 0.00 | 5 | 1 | 0.01 |
| latch: cache buffers lru chain | 4,816 | 0.00 | 5 | 1 | 0.00 |
| local write wait | 3,909 | 0.00 | 4 | 1 | 0.00 |
| latch: session allocation | 6,250 | 0.00 | 4 | 1 | 0.01 |
| buffer deadlock | 36,456 | 98.27 | 3 | 0 | 0.03 |
| enq: TM - contention | 7 | 0.00 | 2 | 346 | 0.00 |
| enq: DV - contention | 180 | 0.00 | 2 | 13 | 0.00 |
| enq: FB - contention | 4,670 | 0.00 | 2 | 1 | 0.00 |
| cursor: pin S | 46,656 | 0.00 | 2 | 0 | 0.04 |
| library cache lock | 57 | 0.00 | 2 | 27 | 0.00 |
| enq: TX - allocate ITL entry | 608 | 0.00 | 1 | 2 | 0.00 |
| control file parallel write | 1,775 | 0.00 | 1 | 1 | 0.00 |
| PX Deq Credit: send blkd | 1,707 | 0.00 | 1 | 1 | 0.00 |
| log file switch completion | 84 | 0.00 | 1 | 16 | 0.00 |
| latch: object queue header operation | 2,558 | 0.00 | 1 | 0 | 0.00 |
| os thread startup | 11 | 0.00 | 1 | 101 | 0.00 |
| latch: cache buffer handles | 2,519 | 0.00 | 1 | 0 | 0.00 |
| write complete waits | 6 | 16.67 | 1 | 164 | 0.00 |
| row cache lock | 1,185 | 0.00 | 1 | 1 | 0.00 |
| latch: library cache lock | 827 | 0.00 | 1 | 1 | 0.00 |
| PX Deq: Signal ACK | 69 | 36.23 | 1 | 12 | 0.00 |
| latch: shared pool | 749 | 0.00 | 1 | 1 | 0.00 |
| wait list latch free | 273 | 0.00 | 1 | 2 | 0.00 |
| control file sequential read | 1,598 | 0.00 | 0 | 0 | 0.00 |
| library cache pin | 238 | 0.00 | 0 | 2 | 0.00 |
| latch: enqueue hash chains | 155 | 0.00 | 0 | 2 | 0.00 |
| latch: redo writing | 29 | 0.00 | 0 | 3 | 0.00 |
| enq: TQ - TM contention | 137 | 0.00 | 0 | 1 | 0.00 |
| direct path read | 8,714 | 0.00 | 0 | 0 | 0.01 |
| enq: CU - contention | 8 | 0.00 | 0 | 9 | 0.00 |
| reliable message | 53 | 0.00 | 0 | 1 | 0.00 |
| cursor: mutex S | 166 | 0.00 | 0 | 0 | 0.00 |
| L1 validation | 6 | 66.67 | 0 | 7 | 0.00 |
| enq: TQ - DDL contention | 72 | 0.00 | 0 | 0 | 0.00 |
| PX qref latch | 207 | 86.96 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 40 | 0.00 | 0 | 0 | 0.00 |
| latch: messages | 41 | 0.00 | 0 | 0 | 0.00 |
| cursor: mutex X | 215 | 0.00 | 0 | 0 | 0.00 |
| cursor: pin X | 1 | 100.00 | 0 | 10 | 0.00 |
| log file sequential read | 4 | 0.00 | 0 | 1 | 0.00 |
| enq: PS - contention | 13 | 0.00 | 0 | 0 | 0.00 |
| db file parallel read | 1 | 0.00 | 0 | 4 | 0.00 |
| latch: object queue header heap | 9 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 359 | 0.00 | 0 | 0 | 0.00 |
| log file single write | 4 | 0.00 | 0 | 0 | 0.00 |
| direct path write temp | 30 | 0.00 | 0 | 0 | 0.00 |
| direct path read temp | 6 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net message from client | 43,747,776 | 0.00 | 10,236,348 | 234 | 37.24 |
| pipe get | 37,876 | 49.79 | 55,834 | 1474 | 0.03 |
| Streams AQ: waiting for messages in the queue | 7,284 | 99.97 | 35,545 | 4880 | 0.01 |
| jobq slave wait | 1,240 | 95.16 | 3,628 | 2926 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 270 | 5.56 | 3,602 | 13341 | 0.00 |
| Streams AQ: qmn slave idle wait | 130 | 0.00 | 3,532 | 27170 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 260 | 50.00 | 3,532 | 13584 | 0.00 |
| PL/SQL lock timer | 315 | 98.73 | 3,494 | 11091 | 0.00 |
| PX Idle Wait | 1,296 | 92.59 | 2,384 | 1839 | 0.00 |
| PX Deq: Execution Msg | 1,365 | 0.29 | 30 | 22 | 0.00 |
| PX Deq: Execute Reply | 5,035 | 0.00 | 9 | 2 | 0.00 |
| PX Deq: Parse Reply | 67 | 0.00 | 1 | 16 | 0.00 |
| PX Deq Credit: need buffer | 1,859 | 0.00 | 1 | 0 | 0.00 |
| PX Deq: Msg Fragment | 1,268 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Table Q Normal | 1,236 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Join ACK | 74 | 0.00 | 0 | 1 | 0.00 |
| class slave wait | 1 | 0.00 | 0 | 1 | 0.00 |
Back to Wait Events Statistics
Back to Top
Background Wait Events
- ordered by wait time desc, waits desc (idle events last)
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| log file parallel write | 860,158 | 0.00 | 271 | 0 | 0.73 |
| db file parallel write | 277,942 | 0.00 | 98 | 0 | 0.24 |
| events in waitclass Other | 41,683 | 0.18 | 9 | 0 | 0.04 |
| db file scattered read | 836 | 0.00 | 4 | 5 | 0.00 |
| db file sequential read | 738 | 0.00 | 2 | 2 | 0.00 |
| control file parallel write | 1,775 | 0.00 | 1 | 1 | 0.00 |
| control file sequential read | 854 | 0.00 | 0 | 0 | 0.00 |
| os thread startup | 3 | 0.00 | 0 | 85 | 0.00 |
| latch: redo writing | 29 | 0.00 | 0 | 3 | 0.00 |
| direct path read | 720 | 0.00 | 0 | 0 | 0.00 |
| log file sequential read | 4 | 0.00 | 0 | 1 | 0.00 |
| direct path write | 220 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 4 | 0.00 | 0 | 0 | 0.00 |
| log file single write | 4 | 0.00 | 0 | 0 | 0.00 |
| latch: shared pool | 2 | 0.00 | 0 | 0 | 0.00 |
| log file sync | 1 | 0.00 | 0 | 0 | 0.00 |
| buffer busy waits | 4 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache | 1 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache lock | 1 | 0.00 | 0 | 0 | 0.00 |
| rdbms ipc message | 854,238 | 1.23 | 30,736 | 36 | 0.73 |
| Streams AQ: waiting for time management or cleanup tasks | 270 | 5.56 | 3,602 | 13341 | 0.00 |
| smon timer | 155,884 | 0.00 | 3,537 | 23 | 0.13 |
| pmon timer | 2,360 | 96.31 | 3,535 | 1498 | 0.00 |
| Streams AQ: qmn slave idle wait | 130 | 0.00 | 3,532 | 27170 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 260 | 50.00 | 3,532 | 13584 | 0.00 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
| Statistic | Total |
|---|
| BUSY_TIME | 63,134,768 |
| IDLE_TIME | 56,770,957 |
| IOWAIT_TIME | 1,705,015 |
| NICE_TIME | 0 |
| SYS_TIME | 4,249,773 |
| USER_TIME | 55,938,692 |
| LOAD | 15 |
| RSRC_MGR_CPU_WAIT_TIME | 0 |
| PHYSICAL_MEMORY_BYTES | 30,400 |
| NUM_CPUS | 32 |
| NUM_CPU_SOCKETS | 16 |
Back to Wait Events Statistics
Back to Top
Service Statistics
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
|---|
| VIS | 61,156.80 | 55,526.30 | 1,388,902 | 2,129,505,477 |
| SYS$USERS | 171.90 | 149.90 | 86,196 | 7,189,390 |
| SYS$BACKGROUND | 0.00 | 0.00 | 21,286 | 397,086 |
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 |
|---|
| VIS |
1058190 | 276683 | 1326674 | 42548 | 0 | 0 | 48110667 | 25503 |
| SYS$USERS |
22021 | 1939 | 459 | 7 | 0 | 0 | 89 | 0 |
| SYS$BACKGROUND |
2535 | 619 | 15 | 25 | 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 |
|---|
| 6,613 | 6,439 | 257,642 | 0.03 | 10.79 | 60t2tt1564j0k |
|
SELECT SUBSTRB(MACHINE, 1, 60)... |
| 4,863 | 4,859 | 8 | 607.91 | 7.93 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 3,910 | 3,730 | 6,593 | 0.59 | 6.38 | fkxdmd0h7xg54 |
OEXOETEL
|
select item, item_id, item_d... |
| 3,601 | 3,438 | 101,935 | 0.04 | 5.87 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 2,265 | 2,178 | 285 | 7.95 | 3.70 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 2,256 | 2,185 | 67,795 | 0.03 | 3.68 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 1,941 | 1,916 | 14 | 138.63 | 3.17 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 1,820 | 1,778 | 10 | 182.04 | 2.97 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 1,439 | 1,368 | 156,586 | 0.01 | 2.35 | 5kqw5535fjvw6 |
ARXTWMAI
|
SELECT NVL(RCTT.ATTRIBUTE10, ... |
| 1,251 | 1,224 | 16 | 78.17 | 2.04 | 1nj7kuvxgpwah |
RAXTRX
|
begin ARP_TAX . SET_DEFAULT_TA... |
| 1,191 | 1,143 | 49,999 | 0.02 | 1.94 | gk43kd7q5mak4 |
RAXTRX
|
update ra_customer_trx_lines l... |
| 1,154 | 1,125 | 35,708 | 0.03 | 1.88 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 1,087 | 1,090 | 8 | 135.82 | 1.77 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 1,003 | 993 | 16 | 62.68 | 1.64 | 5qyckzm5v1qmj |
RAXTRX
|
begin :return_value:i_return_v... |
| 984 | 908 | 185,916 | 0.01 | 1.61 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 853 | 828 | 1,092 | 0.78 | 1.39 | 3cb7xm8ykx1qh |
icx.por.req.server.RequisitionAM
|
begin :1 := POR_UTIL_PKG.subm... |
| 831 | 799 | 16 | 51.94 | 1.36 | 815ygd4pc1bpd |
RAXTRX
|
INSERT INTO RA_CUSTOMER_TRX_LI... |
| 753 | 711 | 233,835 | 0.00 | 1.23 | 25wzrzwd46a44 |
asn.dashboard.server.DashboardAM
|
SELECT 1 FROM DUAL WHERE EXIST... |
| 720 | 702 | 19,185 | 0.04 | 1.17 | 8h16w67202y4g |
|
begin fnd_global.initialize(:s... |
| 718 | 232 | 2,196 | 0.33 | 1.17 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 715 | 56 | 2,196 | 0.33 | 1.17 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 686 | 658 | 63,257 | 0.01 | 1.12 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 641 | 633 | 10 | 64.07 | 1.05 | 1du9v021t8m46 |
ARGLTP
|
insert into gl_interface(creat... |
| 640 | 630 | 56,594 | 0.01 | 1.04 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 614 | 601 | 327,760 | 0.00 | 1.00 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
Back to SQL Statistics
Back to Top
SQL ordered by CPU Time
- Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
- % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100
| CPU Time (s) | Elapsed Time (s) | Executions | CPU per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
|---|
| 6,439 | 6,613 | 257,642 | 0.02 | 10.79 | 60t2tt1564j0k |
|
SELECT SUBSTRB(MACHINE, 1, 60)... |
| 4,859 | 4,863 | 8 | 607.35 | 7.93 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 3,730 | 3,910 | 6,593 | 0.57 | 6.38 | fkxdmd0h7xg54 |
OEXOETEL
|
select item, item_id, item_d... |
| 3,438 | 3,601 | 101,935 | 0.03 | 5.87 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 2,185 | 2,256 | 67,795 | 0.03 | 3.68 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 2,178 | 2,265 | 285 | 7.64 | 3.70 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 1,916 | 1,941 | 14 | 136.86 | 3.17 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 1,778 | 1,820 | 10 | 177.85 | 2.97 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 1,368 | 1,439 | 156,586 | 0.01 | 2.35 | 5kqw5535fjvw6 |
ARXTWMAI
|
SELECT NVL(RCTT.ATTRIBUTE10, ... |
| 1,224 | 1,251 | 16 | 76.50 | 2.04 | 1nj7kuvxgpwah |
RAXTRX
|
begin ARP_TAX . SET_DEFAULT_TA... |
| 1,143 | 1,191 | 49,999 | 0.02 | 1.94 | gk43kd7q5mak4 |
RAXTRX
|
update ra_customer_trx_lines l... |
| 1,125 | 1,154 | 35,708 | 0.03 | 1.88 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 1,090 | 1,087 | 8 | 136.22 | 1.77 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 993 | 1,003 | 16 | 62.09 | 1.64 | 5qyckzm5v1qmj |
RAXTRX
|
begin :return_value:i_return_v... |
| 908 | 984 | 185,916 | 0.00 | 1.61 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 828 | 853 | 1,092 | 0.76 | 1.39 | 3cb7xm8ykx1qh |
icx.por.req.server.RequisitionAM
|
begin :1 := POR_UTIL_PKG.subm... |
| 799 | 831 | 16 | 49.91 | 1.36 | 815ygd4pc1bpd |
RAXTRX
|
INSERT INTO RA_CUSTOMER_TRX_LI... |
| 711 | 753 | 233,835 | 0.00 | 1.23 | 25wzrzwd46a44 |
asn.dashboard.server.DashboardAM
|
SELECT 1 FROM DUAL WHERE EXIST... |
| 702 | 720 | 19,185 | 0.04 | 1.17 | 8h16w67202y4g |
|
begin fnd_global.initialize(:s... |
| 658 | 686 | 63,257 | 0.01 | 1.12 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 633 | 641 | 10 | 63.34 | 1.05 | 1du9v021t8m46 |
ARGLTP
|
insert into gl_interface(creat... |
| 630 | 640 | 56,594 | 0.01 | 1.04 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 601 | 614 | 327,760 | 0.00 | 1.00 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 232 | 718 | 2,196 | 0.11 | 1.17 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 56 | 715 | 2,196 | 0.03 | 1.17 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
Back to SQL Statistics
Back to Top
SQL ordered by Gets
- Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
- Total Buffer Gets: 2,136,414,396
- Captured SQL account for 26.3% of Total
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 226,563,038 | 8 | 28,320,379.75 | 10.60 | 4858.78 | 4863.24 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 123,929,819 | 14 | 8,852,129.93 | 5.80 | 1916.10 | 1940.86 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 105,681,309 | 8 | 13,210,163.63 | 4.95 | 1089.77 | 1086.60 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 96,080,096 | 16 | 6,005,006.00 | 4.50 | 1224.07 | 1250.67 | 1nj7kuvxgpwah |
RAXTRX
|
begin ARP_TAX . SET_DEFAULT_TA... |
| 95,826,404 | 156,586 | 611.97 | 4.49 | 1367.78 | 1439.32 | 5kqw5535fjvw6 |
ARXTWMAI
|
SELECT NVL(RCTT.ATTRIBUTE10, ... |
| 93,025,308 | 49,999 | 1,860.54 | 4.35 | 1143.45 | 1190.57 | gk43kd7q5mak4 |
RAXTRX
|
update ra_customer_trx_lines l... |
| 86,492,971 | 16 | 5,405,810.69 | 4.05 | 993.45 | 1002.84 | 5qyckzm5v1qmj |
RAXTRX
|
begin :return_value:i_return_v... |
| 85,152,375 | 185,916 | 458.02 | 3.99 | 907.99 | 984.13 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 83,928,005 | 233,835 | 358.92 | 3.93 | 711.07 | 753.42 | 25wzrzwd46a44 |
asn.dashboard.server.DashboardAM
|
SELECT 1 FROM DUAL WHERE EXIST... |
| 77,388,771 | 10 | 7,738,877.10 | 3.62 | 1778.50 | 1820.40 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 54,180,638 | 10 | 5,418,063.80 | 2.54 | 633.36 | 640.68 | 1du9v021t8m46 |
ARGLTP
|
insert into gl_interface(creat... |
| 48,862,769 | 16 | 3,053,923.06 | 2.29 | 798.59 | 831.04 | 815ygd4pc1bpd |
RAXTRX
|
INSERT INTO RA_CUSTOMER_TRX_LI... |
| 48,208,533 | 285 | 169,152.75 | 2.26 | 2178.10 | 2265.01 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 43,742,841 | 5,000 | 8,748.57 | 2.05 | 550.38 | 555.75 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 42,849,911 | 1,092 | 39,239.85 | 2.01 | 828.14 | 853.31 | 3cb7xm8ykx1qh |
icx.por.req.server.RequisitionAM
|
begin :1 := POR_UTIL_PKG.subm... |
| 41,053,487 | 96 | 427,640.49 | 1.92 | 578.99 | 596.31 | 37f1qguwxw0sk |
RAXTRX
|
begin IF ( :v_msg_level:i_msg_... |
| 37,676,993 | 171,893 | 219.19 | 1.76 | 541.56 | 546.56 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 37,676,142 | 171,891 | 219.19 | 1.76 | 524.69 | 529.41 | gf1u933c95jb5 |
INVTTMTX
|
DECLARE
l_ret_stat varchar2... |
| 36,859,758 | 56,594 | 651.30 | 1.73 | 630.20 | 640.31 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 33,014,938 | 63,257 | 521.92 | 1.55 | 658.12 | 686.38 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 25,566,489 | 6,593 | 3,877.82 | 1.20 | 3730.33 | 3909.50 | fkxdmd0h7xg54 |
OEXOETEL
|
select item, item_id, item_d... |
| 24,611,612 | 418,114 | 58.86 | 1.15 | 224.74 | 226.26 | 91hakq9n36htp |
|
SELECT TEXT_VALUE FROM WF_ITEM... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 1,493,210
- Captured SQL account for 43.1% of Total
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 212,964 | 8 | 26,620.50 | 14.26 | 9.00 | 32.30 | 4099q0gjjdwah |
RAXMTR
|
select /*+ parallel(t, 8) para... |
| 199,486 | 2,196 | 90.84 | 13.36 | 55.98 | 715.09 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 146,850 | 2,196 | 66.87 | 9.83 | 231.64 | 718.45 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 53,325 | 8 | 6,665.63 | 3.57 | 8.86 | 19.70 | g6yx4z6m66xtq |
RAXMTR
|
select /*+ parallel(t, 8) para... |
| 20,930 | 10 | 2,093.00 | 1.40 | 1778.50 | 1820.40 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 16,636 | 123,265 | 0.13 | 1.11 | 49.53 | 54.68 | fb13x9qx0ftks |
OEXOETEL
|
begin OE_STANDARD_WF.OEOL_SELE... |
| 16,455 | 285 | 57.74 | 1.10 | 2178.10 | 2265.01 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 14,778 | 185,916 | 0.08 | 0.99 | 907.99 | 984.13 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 14,446 | 233,835 | 0.06 | 0.97 | 711.07 | 753.42 | 25wzrzwd46a44 |
asn.dashboard.server.DashboardAM
|
SELECT 1 FROM DUAL WHERE EXIST... |
| 5,823 | 171,895 | 0.03 | 0.39 | 144.74 | 150.10 | 25bkagv1j2xf7 |
INVTTMTX
|
INSERT INTO MTL_MATERIAL_TRAN... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 99,951,299
- Captured SQL account for 6.8% of Total
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 553,050 | 553,001 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 418,114 | 399,309 | 0.96 | 0.00 | 0.00 | 91hakq9n36htp |
|
SELECT TEXT_VALUE FROM WF_ITEM... |
| 371,237 | 294,960 | 0.79 | 0.00 | 0.00 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 361,925 | 358,586 | 0.99 | 0.00 | 0.00 | 0b85w9vv0hbt1 |
|
UPDATE WF_ITEM_ATTRIBUTE_VALUE... |
| 327,760 | 327,755 | 1.00 | 0.00 | 0.00 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 270,358 | 4,595,954 | 17.00 | 0.00 | 0.00 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
| 260,870 | 260,866 | 1.00 | 0.00 | 0.00 | 9bbak9qpg1c7x |
OEXOETEL
|
INSERT INTO WF_ITEM_ATTRIBUTE_... |
| 257,642 | 257,613 | 1.00 | 0.02 | 0.03 | 60t2tt1564j0k |
|
SELECT SUBSTRB(MACHINE, 1, 60)... |
| 233,835 | 0 | 0.00 | 0.00 | 0.00 | 25wzrzwd46a44 |
asn.dashboard.server.DashboardAM
|
SELECT 1 FROM DUAL WHERE EXIST... |
| 185,916 | 185,908 | 1.00 | 0.00 | 0.01 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 9,382,404
- Captured SQL account for 39.9% of Total
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 553,022 | 553,050 | 5.89 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 370,994 | 371,237 | 3.95 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 327,749 | 327,760 | 3.49 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 270,355 | 270,358 | 2.88 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
| 185,917 | 185,916 | 1.98 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 171,895 | 171,895 | 1.83 | 6gnth2mfbs2nq |
INVTTMTX
|
declare
v_ret number := 0... |
| 123,263 | 123,265 | 1.31 | fb13x9qx0ftks |
OEXOETEL
|
begin OE_STANDARD_WF.OEOL_SELE... |
| 115,299 | 115,300 | 1.23 | 1c0b7sas42w2z |
INVTTMTX
|
SELECT NVL(ITEM_COST, 0), ... |
| 110,242 | 110,248 | 1.17 | 162ttnv4ubqun |
OEXOETEL
|
begin OE_DS_PVT.Check_PO_Appr... |
| 101,912 | 101,913 | 1.09 | 8camsgjsr9zya |
OEXOETEL
|
begin OE_TRANSACTION_TYPES_PK... |
| 97,683 | 97,683 | 1.04 | 76sw2a4vnc89j |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.S... |
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 |
|---|
| 4,677,535 | 8 | 0.15 | 9jhgwwcwnt5ak |
RAXMTR
|
select /*+ parallel(t, 8) para... |
| 4,659,501 | 8 | 0.15 | g6yx4z6m66xtq |
RAXMTR
|
select /*+ parallel(t, 8) para... |
| 4,353,935 | 8 | 0.14 | 4099q0gjjdwah |
RAXMTR
|
select /*+ parallel(t, 8) para... |
| 1,051,610 | 18,440 | 0.03 | 1fvcx62k23ph5 |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(qpq ... |
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 |
|---|
| 0b85w9vv0hbt1 | UPDATE WF_ITEM_ATTRIBUTE_VALUES SET TEXT_VALUE = :B4 WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :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 ; |
| 162ttnv4ubqun | begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end; |
| 1c0b7sas42w2z | SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3 |
| 1du9v021t8m46 |
insert into gl_interface(created_by, date_created, status, actual_flag, group_id, set_of_books_id, user_je_source_name, user_je_category_name, accounting_date, subledger_doc_sequence_id, subledger_doc_sequence_value, ussgl_transaction_code, currency_code, code_combination_id, entered_dr, entered_cr, accounted_dr, accounted_cr, reference1, reference10, reference21, reference22, reference23, reference24, reference25, reference26, reference27, reference28, reference29, reference30, request_id)select /*+ ORDERED USE_NL (l ctlgd ct ctt cust) INDEX (ctlgd, RA_CUST_TRX_LINE_GL_DIST_N5) +*/ :b0 created_by , trunc(sysdate ) date_created , :b1 status , :b2 actual_flag , :b3 group_id , :b4 sob_id , :b5 source_name , decode(ctt.type, 'CM', :b6, 'DM', :b7, 'CB', :b8, :b9) category , ctlgd.gl_date gl_date , ct.doc_sequence_id doc_seqid , ct.doc_sequence_value doc_num , ctlgd.ussgl_transaction_code ussgl , ct.invoice_currency_code currency , ctlgd.code_combination_id ccid , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null )) entered_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), decode(sign(nvl(ctlgd.amount
, 0)), (-1), null , nvl(ctlgd.amount, 0))) entered_cr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null )) acctd_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0))) acctd_cr , (:b10||to_char(:b3)) ref1 , decode(:b12, 'Y', null , ((((((l.meaning||' ')||:b13)||decode(ctt.type, 'CB', :b14, 'CM', :b15, 'DEP', :b16, 'DM', :b17, 'GUAR', :b18, 'INV', :b19, null ))||' ')||ct.trx_number)||:b20)) ref10 , to_char(:b3) ref21 , to_char(ct.customer_trx_id) ref22 , to_char(ctlgd.cust_trx_line_gl_dist_id) ref23 , ct.trx_number ref24 , cust.account_number ref25 , 'CUSTOMER' ref26 , to_char(ct.bill_to_customer_id) ref27 , decode(ctt.type, 'CM', 'CM', 'DM', 'DM', 'CB', 'CB', 'INV') ref28 , (decode(ctt.type, 'CM', 'CM_', 'DM', 'DM_', 'CB', 'CB_', 'INV_')||ctlgd.account_class) ref29 , 'RA_CUST_TRX_LINE_GL_DIST' ref30 , :b22 from ra_cust_trx_line_gl_dist ctlgd , ra_cust_trx_line_gl_dist rec , ar_lookups l , ra_customer_trx ct , ra_cust_trx_types ctt , hz_cust_accounts cust where ((((((((((((((((ctlgd.cust_trx_line_gl_dist_id+0)<:
b23 and ctlgd.gl_date between to_date((:b24||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b25||' 23:59:59'), 'DD-MON-RR HH24:MI:SS')) and ctlgd.posting_control_id=(-3)) and ctlgd.set_of_books_id=:b4) and ctlgd.account_set_flag='N') and ctlgd.customer_trx_id=ct.customer_trx_id) and l.lookup_type='AUTOGL_TYPE') and l.lookup_code=nvl(ctlgd.account_class, 'REV')) and ct.complete_flag='Y') and ct.bill_to_customer_id=cust.cust_account_id) and ct.cust_trx_type_id=ctt.cust_trx_type_id) and ctlgd.customer_trx_id=rec.customer_trx_id) and rec.account_class='REC') and rec.latest_rec_flag='Y') and rec.account_set_flag='N') and 'NOT_MFAR_TYPE'=AR_MFAR_PKG.ar_mfar_trx_post(ctlgd.customer_trx_id, :b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b12, :b13, :b20, :b14, :b15, :b17, :b16, :b18, :b19, :b24, :b25, :b23)) |
| 1fvcx62k23ph5 |
SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n4) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOU
RCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.QUALIFIER_ATTR_VALUE = QPLATQ.VALUE_FROM AND QPQ.COMPARISON_OPERATOR_CODE = '=' AND QPQ.LIST_LINE_ID = -1 AND QPQ.SEARCH_IND = 1 AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AND NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 ))) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ
.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n6) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPR
EQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = :B14 AND QPQ.QUALIFIER_DATATYPE = :B13 AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND FND_NUMBER.CANONICAL_TO_NUMBER(DECODE(QPQ.QUALIFIER_DATATYPE, :B13 , QPLATQ.VALUE_FROM, NULL)) BETWEEN QPQ.QUAL_ATTR_VALUE_FROM_NUMBER AND QPQ.QUAL_ATTR_VALUE_TO_NUMBER AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AND NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 ))
) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.STAR
T_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = :B14 AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND QPQ.QUALIFIER_DATATYPE IN (:B17 , :B16 , :B15 ) AND QPLATQ.VALUE_FROM BETWEEN QPQ.QUALIFIER_ATTR_VALUE AND QPQ.QUALIFIER_ATTR_VALUE_TO AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AN
D NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 ))) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTI
VE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =' AND QPQ.QUALIFIER_ATTR_VALUE <> QPLATQ.VALUE_FROM AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 B
ETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AND NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 ))) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE |
| 1nj7kuvxgpwah | begin ARP_TAX . SET_DEFAULT_TAX_CODE ( :setSql , :updSql ) ; 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) |
| 25wzrzwd46a44 | SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 1 FROM FND_GRANTS G, WF_USER_ROLES R WHERE G.GRANTEE_KEY = R.ROLE_NAME AND R.USER_NAME IN (SELECT INCRNS.NAME FROM WF_LOCAL_ROLES SRC , WF_LOCAL_ROLES INCRNS WHERE SRC.NAME = :B4 AND SRC.PARENT_ORIG_SYSTEM = INCRNS.PARENT_ORIG_SYSTEM AND SRC.PARENT_ORIG_SYSTEM_ID = INCRNS.PARENT_ORIG_SYSTEM_ID) AND G.OBJECT_ID = :B3 AND ((:B2 = -1) OR (G.MENU_ID IN (SELECT CMF.MENU_ID FROM FND_COMPILED_MENU_FUNCTIONS CMF WHERE CMF.FUNCTION_ID = :B2 ))) AND ( G.CTX_SECGRP_ID = -1 OR G.CTX_SECGRP_ID = SYS_CONTEXT('FND', 'SECURITY_GROUP_ID')) AND ( G.CTX_RESP_ID = -1 OR G.CTX_RESP_ID = SYS_CONTEXT('FND', 'RESP_ID')) AND ( G.CTX_RESP_APPL_ID = -1 OR G.CTX_RESP_APPL_ID = SYS_CONTEXT('FND', 'RESP_APPL_ID')) AND ( G.CTX_ORG_ID = -1 OR G.CTX_ORG_ID = SYS_CONTEXT('FND', 'ORG_ID')) AND G.START_DATE <= SYSDATE AND ( G.END_DATE IS NULL OR G.END_DATE >= SYSDATE ) AND G.INSTANCE_TYPE = :B1 ) |
| 2fjd6cndjby9p |
INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID ) SELECT /*+ ORDERED */ ASS.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_ID, DIST.CODE_COMBINATION_ID, :B12 , ASS.ACCOUNT_CLASS, 'N', ROUND( (DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1 ), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1 ) ), ASS.AMOUNT ), FC.PRECISION), ROUND( ((DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1) ), ASS.AMOUNT) ) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT) / DECODE(LINES.EXTENDED_AMOUNT, 0, 1, LINES.EXTENDED_AMOUNT)) * DECODE(ASS.AMOUNT, 0, 0, 100), 4), DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), DECODE(:B10 , NULL, ROUND( NVL(HEADER.EXCHANGE_
RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ), :B11 ), ROUND( ( NVL(HEADER.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ( (DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) ) / :B10 ) * :B10 ), DECODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_DATE(ASS.GL_DATE) ), DECODE(DIST.CUSTOMER_TRX_ID, HEADER.CUSTOMER_TRX_ID, DIST.CUST_TRX_LINE_SALESREP_ID, CMSREP.CUST_TRX_LINE_SALESREP_ID), :B9 , :B8 , :B7 , SYSDATE, SYSDATE, :B6 , SYSDATE, :B6 , -3, ASS.GL_DATE, RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES FC, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE, RA_CUST_TRX_LINE_GL_DIST REC, RA_CUST_TRX_LINE_GL_DIST DIST, RA_CUST_TRX_LINE_SALESREPS CMSREP, AR_REVENUE_ASSIGNMENTS ASS WHERE HEADER.CUSTOMER_TRX_ID = :B1 AND HEADER.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = HEADER.INVOICE_CURRENCY_CODE AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINES.AUTORULE_COMPLETE_FLAG||'' = 'N' AND ASS.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND ASS.PERIOD_SET_NAME = :B5 AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID AND DECODE(HEADER.INVOICING_RULE_ID, -3, :B3 , DECODE(NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), 'Y',
:B2 , DECODE(:B4 , 'N', :B3 , DECODE(HEADER.PREVIOUS_CUSTOMER_TRX_ID, NULL, AR_REVENUE_MANAGEMENT_PVT.LINE_COLLECTIBILITY(:B1 , LINES.CUSTOMER_TRX_LINE_ID), AR_REVENUE_MANAGEMENT_PVT.CASH_BASED(HEADER.PREVIOUS_CUSTOMER_TRX_ID))))) <> :B2 AND REC.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND DIST.CUSTOMER_TRX_LINE_ID = (SELECT DECODE(COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_LINE_ID), LINES.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' AND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND DIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND DIST.ACCOUNT_SET_FLAG = 'Y' AND DIST.CUST_TRX_LINE_SALESREP_ID = CMSREP.PREV_CUST_TRX_LINE_SALESREP_ID (+) AND :B1 = CMSREP.CUSTOMER_TRX_ID (+) AND NOT EXISTS ( SELECT 'distribution exists' FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST WHERE SUBDIST.CUSTOMER_TRX_LINE_ID = ASS.CUSTOMER_TRX_LINE_ID AND SUBDIST.CUSTOMER_TRX_ID + 0 = LINES.CUSTOMER_TRX_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND SUBDIST.ORIGINAL_GL_DATE = ASS.GL_DATE ) |
| 37f1qguwxw0sk |
begin IF ( :v_msg_level:i_msg_level > 0 ) THEN arp_util . enable_debug ( 1000000 ) ; arp_global . msg_level := :v_msg_level:i_msg_level ; END IF ; arp_auto_accounting . g_error_buffer := NULL ; :v_num_failed_dist_rows:i_num_failed_dist_rows := 0 ; :v_coa_id:i_coa_id := arp_standard . gl_chart_of_accounts_id ; :v_retval:i_retval := 1 ; arp_auto_accounting . do_autoaccounting ( :v_mode:i_vmode , :v_account_class , :v_trx_id:i_trx_id , :v_line_id:i_line_id , :v_line_salesrep_id:i_line_salesrep_id , :v_request_id:i_request_id , :v_gl_date , :v_orig_gl_date , :v_total_trx_amount:i_total_trx_amount , :v_passed_ccid:i_passed_ccid , :v_force_acct_set_no , :v_cust_trx_type_id:i_cust_trx_type_id , :v_primary_salesrep_id:i_primary_salesrep_id , :v_inv_item_id:i_inv_item_id , :v_memo_line_id:i_memo_line_id , :v_ccid:i_ccid , :v_concat_segments:i_concat_segments , :v_num_failed_dist_rows:i_num_failed_dist_rows ) ; IF ( :v_mode:i_vmode = 'G' AND :v_ccid:i_ccid = -1 ) THEN :v_retval:i_retval := 0 ; END IF ; EXCEPTION WHEN arp_auto_accounting . no_ccid THEN :v_retval:i_retval := 0 ; WHEN NO_DATA_FOUND THEN NULL ; WHEN OTHERS THEN arp_util . debug ( 'arcdaa()' ) ; arp_util . debug ( SQLERRM ) ; :v_errorbuf:i_errorbuf := arp_auto_accounting . g_error_buffer ; :v_sqlcode:i_sqlcode := SQLCODE ; END ;
|
| 3b3psftuyks81 | BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END; |
| 3cb7xm8ykx1qh | begin :1 := POR_UTIL_PKG.submitreq(:2, :3, :4, :5, :6); end; |
| 3dssuqfjsynrk |
SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_
id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) ) |
| 3prk3vg9u0abb | BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END; |
| 4099q0gjjdwah |
select /*+ parallel(t, 8) parallel_index(t, 8) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("LAST_UPDATED_BY"), count(distinct "LAST_UPDATED_BY"), sum(sys_op_opnsize("LAST_UPDATED_BY")), substrb(dump(min("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), count("LAST_UPDATE_DATE"), count(distinct "LAST_UPDATE_DATE"), substrb(dump(min("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATE_LOGIN"), count(distinct "LAST_UPDATE_LOGIN"), sum(sys_op_opnsize("LAST_UPDATE_LOGIN")), substrb(dump(min("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), count("LOCATION_SEGMENT_ID"), count(distinct "LOCATION_SEGMENT_ID"), sum(sys_op_opnsize("LOCATION_SEGMENT_ID")), substrb(dump(min("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), count("MOVEMENT_ID"), count(distinct "MOVEMENT_ID"), sum(sys_op_opnsize("MOVEMENT_ID")), substrb(dump(min("MOVEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MOVEMENT_ID"), 16, 0, 32), 1, 120), count("ORG_ID"), count(distinct "ORG_ID"), sum(sys_op_opnsize("ORG_ID")), substrb(dump(min("ORG_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORG_ID"), 16, 0, 32), 1, 120), count("AMOUNT_INCLUDES_TAX_FLAG"), count(distinct "AMOUNT_INCLUDES_TAX_FLAG"), sum(sys_op_opnsize("AMOUNT_INCLUDES_TAX_FLAG"
)), substrb(dump(min("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTR_CATEGORY"), count(distinct "HEADER_GDF_ATTR_CATEGORY"), sum(sys_op_opnsize("HEADER_GDF_ATTR_CATEGORY")), substrb(dump(min("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE1"), count(distinct "HEADER_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE2"), count(distinct "HEADER_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE3"), count(distinct "HEADER_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE4"), count(distinct "HEADER_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0
, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE5"), count(distinct "HEADER_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE6"), count(distinct "HEADER_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE7"), count(distinct "HEADER_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE8"), count(distinct "HEADER_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_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_opn
size("HEADER_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE11"), count(distinct "HEADER_GDF_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE12"), count(distinct "HEADER_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE13"), count(distinct "HEADER_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE14"), count(distinct "HEADER_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE15"), count(distinct "HEADER_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE1
5", 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_ATTRIBUTE
20", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE21"), count(distinct "HEADER_GDF_ATTRIBUTE21"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE21")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE22"), count(distinct "HEADER_GDF_ATTRIBUTE22"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE22")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE23"), count(distinct "HEADER_GDF_ATTRIBUTE23"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE23")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE24"), count(distinct "HEADER_GDF_ATTRIBUTE24"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE24")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE25"), count(distinct "HEADER_GDF_ATTRIBUTE25"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE25")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE26"), count(distin
ct "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")), sub
strb(dump(min("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE1"), count(distinct "LINE_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE2"), count(distinct "LINE_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE3"), count(distinct "LINE_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE4"), count(distinct "LINE_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE5"), count(distinct "LINE_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE6")
, count(distinct "LINE_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE7"), count(distinct "LINE_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE8"), count(distinct "LINE_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), 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"), cou
nt(distinct "LINE_GDF_ATTRIBUTE17"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE18"), count(distinct "LINE_GDF_ATTRIBUTE18"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE19"), count(distinct "LINE_GDF_ATTRIBUTE19"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE19")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE20"), count(distinct "LINE_GDF_ATTRIBUTE20"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), count("RESET_TRX_DATE_FLAG"), count(distinct "RESET_TRX_DATE_FLAG"), sum(sys_op_opnsize("RESET_TRX_DATE_FLAG")), substrb(dump(min("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), count("PAYMENT_SERVER_ORDER_NUM"), count(distinct "PAYMENT_SERVER_ORDER_NUM"), sum(sys_op_opnsize("PAYMENT_SERVER_ORDER_NUM")), substrb(dump(min(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32),
1, 120), substrb(dump(max(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), count("APPROVAL_CODE"), count(distinct "APPROVAL_CODE"), sum(sys_op_opnsize("APPROVAL_CODE")), substrb(dump(min(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), count("ADDRESS_VERIFICATION_CODE"), count(distinct "ADDRESS_VERIFICATION_CODE"), sum(sys_op_opnsize("ADDRESS_VERIFICATION_CODE")), substrb(dump(min(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120), count("WAREHOUSE_ID"), count(distinct "WAREHOUSE_ID"), sum(sys_op_opnsize("WAREHOUSE_ID")), substrb(dump(min("WAREHOUSE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("WAREHOUSE_ID"), 16, 0, 32), 1, 120), count("TRANSLATED_DESCRIPTION"), count(distinct "TRANSLATED_DESCRIPTION"), sum(sys_op_opnsize("TRANSLATED_DESCRIPTION")), substrb(dump(min(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count("CONS_BILLING_NUMBER"), count(distinct "CONS_BILLING_NUMBER"), sum(sys_op_opnsize("CONS_BILLING_NUMBER")), substrb(dump(min("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), count("PROMISED_COMMITMENT_AMOUNT"), count(distinct "PROMISED_COMMITMENT_AMOUNT"), sum(sys_op_opnsize("PROMISED_COMMITMENT_AMOUNT")), substrb(dump
(min("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), count("PAYMENT_SET_ID"), count(distinct "PAYMENT_SET_ID"), sum(sys_op_opnsize("PAYMENT_SET_ID")), substrb(dump(min("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), count("ORIGINAL_GL_DATE"), count(distinct "ORIGINAL_GL_DATE"), substrb(dump(min("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), count("CONTRACT_LINE_ID"), count(distinct "CONTRACT_LINE_ID"), sum(sys_op_opnsize("CONTRACT_LINE_ID")), substrb(dump(min("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), count("CONTRACT_ID"), count(distinct "CONTRACT_ID"), sum(sys_op_opnsize("CONTRACT_ID")), substrb(dump(min("CONTRACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_ID"), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY1"), count(distinct "SOURCE_DATA_KEY1"), sum(sys_op_opnsize("SOURCE_DATA_KEY1")), substrb(dump(min(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY2"), count(distinct "SOURCE_DATA_KEY2"), sum(sys_op_opnsize("SOURCE_DATA_KEY2")), substrb(dump(min(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY3"), count(distinct "SOURCE_DATA
_KEY3"), sum(sys_op_opnsize("SOURCE_DATA_KEY3")), substrb(dump(min(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY4"), count(distinct "SOURCE_DATA_KEY4"), sum(sys_op_opnsize("SOURCE_DATA_KEY4")), substrb(dump(min(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY5"), count(distinct "SOURCE_DATA_KEY5"), sum(sys_op_opnsize("SOURCE_DATA_KEY5")), substrb(dump(min(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120), count("INVOICED_LINE_ACCTG_LEVEL"), count(distinct "INVOICED_LINE_ACCTG_LEVEL"), sum(sys_op_opnsize("INVOICED_LINE_ACCTG_LEVEL")), substrb(dump(min("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), count("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_SEGM
ENT4"), sum(sys_op_opnsize("TERRITORY_SEGMENT4")), substrb(dump(min("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT5"), count(distinct "TERRITORY_SEGMENT5"), sum(sys_op_opnsize("TERRITORY_SEGMENT5")), substrb(dump(min("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT6"), count(distinct "TERRITORY_SEGMENT6"), sum(sys_op_opnsize("TERRITORY_SEGMENT6")), substrb(dump(min("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT7"), count(distinct "TERRITORY_SEGMENT7"), sum(sys_op_opnsize("TERRITORY_SEGMENT7")), substrb(dump(min("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT8"), count(distinct "TERRITORY_SEGMENT8"), sum(sys_op_opnsize("TERRITORY_SEGMENT8")), substrb(dump(min("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT9"), count(distinct "TERRITORY_SEGMENT9"), sum(sys_op_opnsize("TERRITORY_SEGMENT9")), substrb(dump(min("TERRITORY_SEGMENT9"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT9"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT10"), count(distinct "TERRITORY_SEGMENT10"), sum(sys_op_opnsize("TERRITORY_SEGMENT10")), substrb(dump(min("TERRITORY_SEGMENT10"), 16, 0, 32), 1
, 120), substrb(dump(max("TERRITORY_SEGMENT10"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT11"), count(distinct "TERRITORY_SEGMENT11"), sum(sys_op_opnsize("TERRITORY_SEGMENT11")), substrb(dump(min("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT12"), count(distinct "TERRITORY_SEGMENT12"), sum(sys_op_opnsize("TERRITORY_SEGMENT12")), substrb(dump(min("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT13"), count(distinct "TERRITORY_SEGMENT13"), sum(sys_op_opnsize("TERRITORY_SEGMENT13")), substrb(dump(min("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT14"), count(distinct "TERRITORY_SEGMENT14"), sum(sys_op_opnsize("TERRITORY_SEGMENT14")), substrb(dump(min("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT15"), count(distinct "TERRITORY_SEGMENT15"), sum(sys_op_opnsize("TERRITORY_SEGMENT15")), substrb(dump(min("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT16"), count(distinct "TERRITORY_SEGMENT16"), sum(sys_op_opnsize("TERRITORY_SEGMENT16")), substrb(dump(min("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), count("T
ERRITORY_SEGMENT17"), count(distinct "TERRITORY_SEGMENT17"), sum(sys_op_opnsize("TERRITORY_SEGMENT17")), substrb(dump(min("TERRITORY_SEGMENT17"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT17"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT18"), count(distinct "TERRITORY_SEGMENT18"), sum(sys_op_opnsize("TERRITORY_SEGMENT18")), substrb(dump(min("TERRITORY_SEGMENT18"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT18"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT19"), count(distinct "TERRITORY_SEGMENT19"), sum(sys_op_opnsize("TERRITORY_SEGMENT19")), substrb(dump(min("TERRITORY_SEGMENT19"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT19"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT20"), count(distinct "TERRITORY_SEGMENT20"), sum(sys_op_opnsize("TERRITORY_SEGMENT20")), substrb(dump(min("TERRITORY_SEGMENT20"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT20"), 16, 0, 32), 1, 120), count("ATTRIBUTE_CATEGORY"), count(distinct "ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("ATTRIBUTE_CATEGORY")), substrb(dump(min("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("ATTRIBUTE1"), count(distinct "ATTRIBUTE1"), sum(sys_op_opnsize("ATTRIBUTE1")), substrb(dump(min(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE2"), count(distinct "ATTRIBUTE2"), sum(sys_op_opnsize("ATTRIBUTE2")), substrb(dump(min(s
ubstrb("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("HE
ADER_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")⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀 ∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀 ∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀
Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀
吀吀刀䤀䈀唀吀䔀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㈀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㈀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㈀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㈀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㈀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㌀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㌀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㌀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㌀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㌀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㐀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㐀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㐀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㐀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀
㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㐀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㔀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㔀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㔀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㔀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㔀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䌀伀䴀䴀䔀一吀匀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䌀伀䴀䴀䔀一吀匀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䌀伀䴀䴀䔀一吀匀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䌀伀䴀䴀䔀一吀匀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䌀伀䴀䴀䔀一吀匀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀
洀愀砀⠀猀甀戀猀琀爀戀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE"), count(distinct "USSGL_TRANSACTION_CODE"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE")), substrb(dump(min("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), count("ACCTD_AMOUNT"), count(distinct "ACCTD_AMOUNT"), sum(sys_op_opnsize("ACCTD_AMOUNT")), substrb(dump(min("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), count("CUSTOME
R_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_ATTRIBUTE8")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE9"), count(distinct "LINK_TO_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE9")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE10"), count(distinct "REFERENCE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE10")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE1
0"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE11"), count(distinct "REFERENCE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE11")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE12"), count(distinct "REFERENCE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE12")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE13"), count(distinct "REFERENCE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE13")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE14"), count(distinct "REFERENCE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE14")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE15"), count(distinct "REFERENCE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE15")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE8"), count(dis
tinct "REFERENCE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE8")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE9"), count(distinct "REFERENCE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE9")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE12"), count(distinct "INTERFACE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE13")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1
, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE14"), count(distinct "INTERFACE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE14")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t |
| 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; |
| 4yak7x2zqz0dh | BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END; |
| 5kqw5535fjvw6 | SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID |
| 5qyckzm5v1qmj | begin :return_value:i_return_value := arp_rounding . correct_dist_rounding_errors ( :request_id , NULL , NULL , :rows_processed:i_rows_processed , :error_msg:i_error_msg , NULL , NULL , :trx_class , 'N' , :debug_mode , arp_global . sysparam . trx_header_level_rounding , 'N' ) ; END ; |
| 60t2tt1564j0k | SELECT SUBSTRB(MACHINE, 1, 60), PROCESS, PROGRAM FROM V$SESSION WHERE AUDSID = :B1 |
| 6gnth2mfbs2nq | declare
v_ret number := 0;
begin
if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) )
then
v_ret := 1;
end if;
:8 := v_ret;
end;
|
| 6h2tpcxpymqu7 | BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END; |
| 76sw2a4vnc89j | begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end; |
| 7g05xfvc5vp74 | BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END; |
| 815ygd4pc1bpd |
INSERT INTO RA_CUSTOMER_TRX_LINES (
customer_trx_line_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
customer_trx_id,
interface_line_attribute1,
interface_line_attribute2,
interface_line_attribute3,
interface_line_attribute4,
interface_line_attribute5,
interface_line_attribute6,
interface_line_attribute7,
interface_line_attribute8,
interface_line_attribute9,
interface_line_attribute10,
interface_line_attribute11,
interface_line_attribute12,
interface_line_attribute13,
interface_line_attribute14,
interface_line_attribute15,
interface_line_context,
line_number,
set_of_books_id,
reason_code,
inventory_item_id,
description,
translated_description,
previous_customer_trx_id,
previous_customer_trx_line_id,
initial_customer_trx_line_id,
quantity_ordered,
quantity_credited,
quantity_invoiced,
unit_standard_price,
unit_selling_price,
amount_includes_tax_flag,
uom_code,
sales_order,
sales_order_line,
sales_order_date,
sales_order_source,
sales_order_revision,
accounting_rule_id,
accounting_rule_duration,
line_type,
rule_start_date,
extended_amount,
taxable_amount,
revenue_amount,
link_to_cust_trx_line_id,
sales_tax_id,
location_segment_id,
vat_tax_id,
tax_precedence,
tax_rate,
item_exception_rate_id,
tax_exemption_id,
memo_line_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribut
e11,
attribute12,
attribute13,
attribute14,
attribute15,
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
request_id,
program_application_id,
program_id,
program_update_date,
default_ussgl_transaction_code,
autorule_complete_flag,
last_period_to_credit,
tax_exempt_flag,
tax_exempt_reason_code,
tax_exempt_number,
movement_id,
payment_set_id,
warehouse_id,
contract_line_id,
invoiced_line_acctg_level,
source_data_key1,
source_data_key2,
source_data_key3,
source_data_key4,
source_data_key5)
SELECT
l.interface_line_id,
sysdate,
:b1,
sysdate,
:b2,
:b3,
l.customer_trx_id,
l.interface_line_attribute1,
l.interface_line_attribute2,
l.interface_line_attribute3,
l.interface_line_attribute4,
l.interface_line_attribute5,
l.interface_line_attribute6,
l.interface_line_attribute7,
l.interface_line_attribute8,
l.interface_line_attribute9,
l.interface_line_attribute10,
l.interface_line_attribute11,
l.interface_line_attribute12,
l.interface_line_attribute13,
l.interface_line_attribute14,
l.interface_line_attribute15,
substr(decode(l.interface_line_context, 'Global Dat
a Elements', null,
l.interface_line_context), 1, 30),
l.line_number,
l.set_of_books_id,
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.reason_code, null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.inventory_item_id, null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.description, null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.translated_description, null),
null,
null,
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.reference_line_id, null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.quantity_ordered, null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', decode(t.type, 'CM', l.quantity, null), null),
decode(l.line_type, 'LINE', decode(t.type, 'CM', null, nvl(l.quantity, 1)),
'CHARGES', 1, null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.unit_standard_price, null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', nvl(l.unit_selling_price,
decode(t.type, 'CM',
decode(l.credit_method_for_acct_rule,
'UNIT', l.amount/l.quantity, null),
decode(l.quantity, 0, l.amount,
null, l.amount,
ROUND(l.amount/l.quantity, 15)))), null),
l.amount_includes_tax_flag,
decode(l.line_type, 'LINE', l.uom_code, 'CHARGES', null, null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.sales_order, null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', ltrim(l.sales_order_line) , null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.sales_order_date , null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.sales_order_source , null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.sales_order_revision , null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.accounting_rule_id, null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', decode(l.accounting_rule_id, null, null, decode(r.type, 'A', r.occurrences, l.accounting_rule_duration)), null),
l.line_type,
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', decode(l.accounting_rule_id, null, null, l.rule_start_date), null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE',
decode(l.quantity * l.unit_selling_pr
ice, null, nvl(l.amount, 0),
decode(c.minimum_accountable_unit, null,
round(l.quantity * l.unit_selling_price,
c.precision),
round(l.quantity * l.unit_selling_price /
c.minimum_accountable_unit)*
c.minimum_accountable_unit)),
'TAX',
decode(l.amount, null,
decode(l.tax_precedence, null,
decode(parent.quantity * parent.unit_selling_price,
null,
decode(c.minimum_accountable_unit, null,
round(nvl(parent.amount, 0) *
(nvl(l.tax_rate, 0)/100),
c.precision),
round(nvl(parent.amount, 0) *
(nvl(l.tax_rate, 0)/100)/
c.minimum_accountable_unit) *
c.minimum_accountable_unit),
decode(c.minimum_accountable_unit, null,
round(parent.quantity *
parent.unit_selling_price *
(nvl(l.tax_rate, 0)/100),
c.precision),
round(parent.quantity *
parent.unit_selling_price *
(nvl(l.tax_rate, 0)/100)/
c.minimum_accountable_unit) *
c.minimum_accountable_unit)),
0),
nvl(l.amount, 0)),
nvl(l.amount, 0)),
decode(l.line_type, 'TAX',
decode(l.tax_precedence, null,
decode(parent.quantity * parent.unit_selling_price,
null,
decode(c.minimum_accountable_unit, null,
round(nvl(parent.amount, 0),
c.precision),
round(nvl(parent.amount, 0) /
c.minimum_accountable_unit) *
c.minimum_accountable_unit),
decode(c.minimum_accountable_unit, null,
round(parent.quantity *
parent.unit_selling_price ,
c.precision),
round(parent.quantity *
parent.unit_selling_price /
c.minimum_accountable_
unit) *
c.minimum_accountable_unit)),
0),
null),
decode(l.line_type, 'LINE', nvl(l.amount, 0), 'CHARGES', null, null),
decode(l.line_type, 'TAX', l.link_to_line_id,
'FREIGHT', l.link_to_line_id, null),
decode(l.line_type, 'TAX', l.sales_tax_id, null),
decode(l.line_type, 'TAX', l.location_segment_id, null),
decode(l.line_type, 'TAX', l.vat_tax_id,
'LINE', l.vat_tax_id, null),
decode(l.line_type, 'TAX', l.tax_precedence, null),
decode(l.line_type, 'TAX', l.tax_rate, null),
decode(l.line_type, 'TAX', l.exception_id, null),
decode(l.line_type, 'TAX', l.exemption_id, null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', l.memo_line_id, null),
l.attribute_category,
rtrim(l.attribute1),
rtrim(l.attribute2),
rtrim(l.attribute3),
rtrim(l.attribute4),
rtrim(l.attribute5),
rtrim(l.attribute6),
rtrim(l.attribute7),
rtrim(l.attribute8),
rtrim(l.attribute9),
rtrim(l.attribute10),
rtrim(l.attribute11),
rtrim(l.attribute12),
rtrim(l.attribute13),
rtrim(l.attribute14),
rtrim(l.attribute15),
l.line_gdf_attr_category,
l.line_gdf_attribute1,
l.line_gdf_attribute2,
l.line_gdf_attribute3,
l.line_gdf_attribute4,
l.line_gdf_attribute5,
l.line_gdf_attribute6,
l.line_gdf_attribute7,
l.line_gdf_attribute8,
l.line_gdf_attribute9,
l.line_gdf_attribute10,
l.line_gdf_attribute11,
l.line_gdf_attribute12,
l.line_gdf_attribute1
3,
l.line_gdf_attribute14,
l.line_gdf_attribute15,
l.line_gdf_attribute16,
l.line_gdf_attribute17,
l.line_gdf_attribute18,
l.line_gdf_attribute19,
l.line_gdf_attribute20,
:b4,
:b5,
:b6,
sysdate,
l.ussgl_transaction_code,
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', decode(l.accounting_rule_id, null, null, 'N'), null),
decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type),
'LINE', decode(l.credit_method_for_acct_rule, 'UNIT', null, null),
null),
decode(l.line_type, 'LINE', l.tax_exempt_flag, null),
decode(l.line_type,
'LINE', decode(l.tax_exempt_flag,
'E', l.tax_exempt_reason_code, null), null),
decode(l.line_type,
'LINE', decode(l.tax_exempt_flag,
'E', l.tax_exempt_number, null), null),
l.movement_id,
l.payment_set_id,
l.warehouse_id,
l.contract_line_id,
l.invoiced_line_acctg_level,
l.source_data_key1,
l.source_data_key2,
l.source_data_key3,
l.source_data_key4,
l.source_data_key5
FROM FND_CURRENCIES C,
RA_CUST_TRX_TYPES t,
RA_RULES r,
RA_INTERFACE_LINES_GT parent,
RA_INTERFACE_LINES_GT l
WHERE l.request_id = :b7
AND l.currency_code = c.currency_code
AND l.cust_trx_type_id = t.cust_trx_type_id
AND l.accounting_rule_id = r.rule_id(+)
AND l.customer_trx_id is not null
AND l.link_to_line_id = parent.interface_line_id(+)
AND nvl(l.interface_status, '~') != 'P'
|
| 8c30hkqv9n7cr | BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); 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 ) |
| 8camsgjsr9zya | begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end; |
| 8h16w67202y4g | begin fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :l); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :m); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end; |
| 91hakq9n36htp | SELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1 |
| 9bbak9qpg1c7x | INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE ) VALUES ( :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) |
| 9jhgwwcwnt5ak |
select /*+ parallel(t, 8) parallel_index(t, 8) 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_ATTRIBUT
E3")), 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_NUMBER
"), count(distinct "SALESREP_NUMBER"), sum(sys_op_opnsize("SALESREP_NUMBER")), substrb(dump(min("SALESREP_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_NUMBER"), 16, 0, 32), 1, 120), count("SALESREP_ID"), count(distinct "SALESREP_ID"), sum(sys_op_opnsize("SALESREP_ID")), substrb(dump(min("SALESREP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_NAME"), count(distinct "SALES_CREDIT_TYPE_NAME"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_NAME")), substrb(dump(min("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_ID"), count(distinct "SALES_CREDIT_TYPE_ID"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_ID")), substrb(dump(min("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_AMOUNT_SPLIT"), count(distinct "SALES_CREDIT_AMOUNT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_AMOUNT_SPLIT")), substrb(dump(min("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), count("SALES_CREDIT_PERCENT_SPLIT"), count(distinct "SALES_CREDIT_PERCENT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_PERCENT_SPLIT")), substrb(dump(min("SALES_CREDIT_PERCENT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_PERCENT_SPLIT"), 16, 0, 32), 1, 120), count("INTERFACE_STATUS"), count(distinct "INTERFACE_STATUS"), sum(sys_op_o
pnsize("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(distin
ct "ATTRIBUTE5"), sum(sys_op_opnsize("ATTRIBUTE5")), substrb(dump(min(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE6"), count(distinct "ATTRIBUTE6"), sum(sys_op_opnsize("ATTRIBUTE6")), substrb(dump(min(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE7"), count(distinct "ATTRIBUTE7"), sum(sys_op_opnsize("ATTRIBUTE7")), substrb(dump(min(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE8"), count(distinct "ATTRIBUTE8"), sum(sys_op_opnsize("ATTRIBUTE8")), substrb(dump(min(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE9"), count(distinct "ATTRIBUTE9"), sum(sys_op_opnsize("ATTRIBUTE9")), substrb(dump(min(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE10"), count(distinct "ATTRIBUTE10"), sum(sys_op_opnsize("ATTRIBUTE10")), substrb(dump(min(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE11"), count(distinct "ATTRIBUTE11"), sum(sys_op_opnsize("ATTRIBUTE11")), substrb(dump(min(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb(
"ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE12"), count(distinct "ATTRIBUTE12"), sum(sys_op_opnsize("ATTRIBUTE12")), substrb(dump(min(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE13"), count(distinct "ATTRIBUTE13"), sum(sys_op_opnsize("ATTRIBUTE13")), substrb(dump(min(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE14"), count(distinct "ATTRIBUTE14"), sum(sys_op_opnsize("ATTRIBUTE14")), substrb(dump(min(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE15"), count(distinct "ATTRIBUTE15"), sum(sys_op_opnsize("ATTRIBUTE15")), substrb(dump(min(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 1
20), 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), s
ubstrb(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 |
| 9sf243fdjmdmh | begin fnd_global.apps_initialize(-1, -1, -1, :1); end; |
| a29grr748ghc4 | BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END; |
| avc1jqzz04wpr | SELECT 'x' FROM DUAL |
| bkxrrs52m7d8p | BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END; |
| cwyx16zn1hpfb | select parameter, value from nls_session_parameters |
| fb13x9qx0ftks | begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end; |
| fkxdmd0h7xg54 | select item, item_id, item_description, inventory_item_id, item_identifier_type, decode(item_identifier_type, 'INT', :1, 'CUST', :2, item_identifier_type) item_identifier_type_meaning, inventory_item, Address, cust_address, item_definition_level from oe_items_v where ( UPPER(ITEM) LIKE :3 AND (ITEM LIKE :4 OR ITEM LIKE :5 OR ITEM LIKE :6 OR ITEM LIKE :7)) AND ( (sold_to_org_id = :8 or sold_to_org_id is null) and (item_status ='ACTIVE' or item_status IS NULL) and (cross_ref_status = 'ACTIVE' or cross_ref_status IS NULL) ) order by item |
| 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 |
| g6yx4z6m66xtq |
select /*+ parallel(t, 8) parallel_index(t, 8) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_LINE_ATTRIBUTE15"), count(distinct "INTERFACE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE15")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE9"), count(distinct "INTERFACE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE9")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("VAT_TAX_ID"), count(distinct "VAT_TAX_ID"), sum(sys_op_opnsize("VAT_TAX_ID")), substrb(dump(min("VAT_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("VAT_TAX_ID"), 16, 0, 32), 1, 120), count("REASON_CODE_MEANING"), count(distinct "REASON_CODE_MEANING"), sum(sys_op_opnsize("REASON_CODE_MEANING")), substrb(dump(min(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("LAST_PERIOD_TO_CREDIT"), count(distinct "LAST_PERIOD_TO_CREDIT"), sum(sys_op_opnsize("LAST_PERIOD_TO_CREDIT")), substrb(dump(min("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), count("PAYING_CUSTOMER_ID"), count(distinct "PAYING_CUSTOMER_ID"), sum(sys_op_opnsize("PAYING_CUSTOMER_ID"))
, substrb(dump(min("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("PAYING_SITE_USE_ID"), count(distinct "PAYING_SITE_USE_ID"), sum(sys_op_opnsize("PAYING_SITE_USE_ID")), substrb(dump(min("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_FLAG"), count(distinct "TAX_EXEMPT_FLAG"), sum(sys_op_opnsize("TAX_EXEMPT_FLAG")), substrb(dump(min("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE"), count(distinct "TAX_EXEMPT_REASON_CODE"), sum(sys_op_opnsize("TAX_EXEMPT_REASON_CODE")), substrb(dump(min("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE_MEANING"), count(distinct "TAX_EXEMPT_REASON_CODE_MEANING"), sum(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("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(substrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_REF"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(
dump(max(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_ID"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_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(distin
ct "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_L
INE_ATTRIBUTE6"), count(distinct "LINK_TO_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE6")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE7"), count(distinct "LINK_TO_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE7")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("RECEIPT_METHOD_NAME"), count(distinct "RECEIPT_METHOD_NAME"), sum(sys_op_opnsize("RECEIPT_METHOD_NAME")), substrb(dump(min("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), count("RECEIPT_METHOD_ID"), count(distinct "RECEIPT_METHOD_ID"), sum(sys_op_opnsize("RECEIPT_METHOD_ID")), substrb(dump(min("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), count(distinct "CONVERSION_TYPE"), sum(sys_op_opnsize("CONVERSION_TYPE")), substrb(dump(min("CONVERSION_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_TYPE"), 16, 0, 32), 1, 120), count("CONVERSION_DATE"), count(distinct "CONVERSION_DATE"), substrb(dump(min("CONVERSION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_DATE"), 16, 0, 32), 1, 120), count("CONVERSION_RATE"), count(distinct "CONVERSION_RATE"), sum(sys_op_opnsize("CONVERSION_RATE")), substrb(dump(min("CONVERSION_RATE"), 16, 0, 32), 1, 120), substrb(dum
p(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_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("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"), coun
t(distinct "RELATED_TRX_NUMBER"), sum(sys_op_opnsize("RELATED_TRX_NUMBER")), substrb(dump(min("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), count("RELATED_CUSTOMER_TRX_ID"), count(distinct "RELATED_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("RELATED_CUSTOMER_TRX_ID")), substrb(dump(min("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("PREVIOUS_CUSTOMER_TRX_ID"), count(distinct "PREVIOUS_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("PREVIOUS_CUSTOMER_TRX_ID")), substrb(dump(min("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_ACCT_RULE"), count(distinct "CREDIT_METHOD_FOR_ACCT_RULE"), sum(sys_op_opnsize("CREDIT_METHOD_FOR_ACCT_RULE")), substrb(dump(min("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_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), subst
rb(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("RUL
E_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(sub
strb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_REVISION"), count(distinct "SALES_ORDER_REVISION"), sum(sys_op_opnsize("SALES_ORDER_REVISION")), substrb(dump(min("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), count("PURCHASE_ORDER"), count(distinct "PURCHASE_ORDER"), sum(sys_op_opnsize("PURCHASE_ORDER")), substrb(dump(min(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), count("PURCHASE_ORDER_REVISION"), count(distinct "PURCHASE_ORDER_REVISION"), sum(sys_op_opnsize("PURCHASE_ORDER_REVISION")), substrb(dump(min(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), count("PURCHASE_ORDER_DATE"), count(distinct "PURCHASE_ORDER_DATE"), substrb(dump(min("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), count("AGREEMENT_NAME"), count(distinct "AGREEMENT_NAME"), sum(sys_op_opnsize("AGREEMENT_NAME")), substrb(dump(min("AGREEMENT_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_NAME"), 16, 0, 32), 1, 120), count("AGREEMENT_ID"), count(distinct "AGREEMENT_ID"), sum(sys_op_opnsize("AGREEMENT_ID")), substrb(dump(min("AGREEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_ID"), 16, 0, 32), 1, 120), count("MEMO_LINE_NAME"), count(distinct "MEMO_LINE_NAME"), su
m(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(substrb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG2"), count(distinct "MTL_SYSTEM_ITEMS_SEG2"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG2")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG3"), count(distinct "MTL_SYSTEM_ITEMS_SEG3"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG3")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG4"), count(distinct "MTL
_SYSTEM_ITEMS_SEG4"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG4")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG5"), count(distinct "MTL_SYSTEM_ITEMS_SEG5"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG5")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG6"), count(distinct "MTL_SYSTEM_ITEMS_SEG6"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG6")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG6", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG7"), count(distinct "MTL_SYSTEM_ITEMS_SEG7"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG7")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG7", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG8"), count(distinct "MTL_SYSTEM_ITEMS_SEG8"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG8")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG8", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG9"), count(distinct "MTL_SYSTEM_ITEMS_SEG9"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG9")), substrb(dump(min(substrb("MTL_SYSTEM_
ITEMS_SEG9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG9", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG10"), count(distinct "MTL_SYSTEM_ITEMS_SEG10"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG10")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG11"), count(distinct "MTL_SYSTEM_ITEMS_SEG11"), sum(sys_op_opnsize("MTL_SYSTEM_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_I
TEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG15"), count(distinct "MTL_SYSTEM_ITEMS_SEG15"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG15")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG16"), count(distinct "MTL_SYSTEM_ITEMS_SEG16"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG16")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG17"), count(distinct "MTL_SYSTEM_ITEMS_SEG17"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG17")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG18"), count(distinct "MTL_SYSTEM_ITEMS_SEG18"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG18")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG19"), count(distinct "MTL_SYSTEM_ITEMS_SEG19"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG19")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG20"), coun
t(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_ATTRIBUT
E3"), 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(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_LIN
E_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE5"), count(distinct "INTERFACE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE5")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE6"), count(distinct "INTERFACE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE6")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE7"), count(distinct "INTERFACE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE7")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE8"), count(distinct "INTERFACE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE8")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count(distinct "BATCH_SOURCE_NAME"), sum(sys_op_opnsize("BATCH_SOURCE_NAME")), substrb(dump(min(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䈀䄀吀䌀䠀开匀伀唀刀䌀䔀开一䄀䴀䔀∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ猀甀洀⠀猀礀
猀开漀瀀开漀瀀渀猀椀稀攀⠀∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀匀䔀吀开
伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䰀䤀一䔀开吀夀倀䔀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䰀䤀一䔀开吀夀倀䔀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䰀䤀一䔀开吀夀倀䔀∀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䰀䤀一䔀开吀夀倀䔀∀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀ⰀⰀ㌀㈀⤀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ挀漀甀渀琀⠀∀䄀䴀伀唀一吀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䄀䴀伀唀一吀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䄀䴀伀唀一吀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䄀䴀伀唀一吀∀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䄀䴀伀唀一吀∀⤀Ⰰ㘀Ⰰ Ⰰ㌀㈀⤀ⰀⰀ㈀ ⤀ 昀爀漀洀 ∀䄀刀∀⸀∀刀䄀开䤀一吀䔀刀䘀䄀䌀䔀开䰀䤀一䔀匀开䄀䰀䰀∀ 猀愀洀瀀氀攀 ⠀ ⸀ ⤀ 琀 |
| 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; |
| gk43kd7q5mak4 | update ra_customer_trx_lines l set
(vat_tax_id, amount_includes_tax_flag) =
(select :VAT_TAX_ID,
decode(:AMOUNT_INCLUDES_TAX_OVERRIDE,
'N', :AMOUNT_INCLUDES_TAX_FLAG,
NVL(l.amount_includes_tax_flag,
:AMOUNT_INCLUDES_TAX_FLAG)
)
from dual
)
where customer_trx_line_id=:LINE_ID
and line_type ='LINE' |
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 | 5,671,926 | 1,549.85 | 4.83 |
| CPU used when call started | 5,656,200 | 1,545.55 | 4.81 |
| CR blocks created | 14,053,027 | 3,839.97 | 11.96 |
| Cached Commit SCN referenced | 1,656,149 | 452.54 | 1.41 |
| Commit SCN cached | 16 | 0.00 | 0.00 |
| DB time | 16,502,149 | 4,509.19 | 14.05 |
| DBWR checkpoint buffers written | 1,669,715 | 456.25 | 1.42 |
| DBWR checkpoints | 55 | 0.02 | 0.00 |
| DBWR object drop buffers written | 58,697 | 16.04 | 0.05 |
| DBWR parallel query checkpoint buffers written | 87,630 | 23.94 | 0.07 |
| DBWR revisited being-written buffer | 591 | 0.16 | 0.00 |
| DBWR transaction table writes | 1,430 | 0.39 | 0.00 |
| DBWR undo block writes | 1,624,220 | 443.82 | 1.38 |
| DFO trees parallelized | 13 | 0.00 | 0.00 |
| IMU CR rollbacks | 30,132,082 | 8,233.55 | 25.65 |
| IMU Flushes | 351,422 | 96.03 | 0.30 |
| IMU Redo allocation size | 2,395,908,392 | 654,678.81 | 2,039.53 |
| IMU commits | 601,969 | 164.49 | 0.51 |
| IMU contention | 40,682 | 11.12 | 0.03 |
| IMU ktichg flush | 11,741 | 3.21 | 0.01 |
| IMU pool not allocated | 3,238 | 0.88 | 0.00 |
| IMU recursive-transaction flush | 1,693 | 0.46 | 0.00 |
| IMU undo allocation size | 5,368,074,416 | 1,466,819.25 | 4,569.60 |
| IMU- failed to get a private strand | 3,238 | 0.88 | 0.00 |
| PX local messages recv'd | 14,226 | 3.89 | 0.01 |
| PX local messages sent | 14,226 | 3.89 | 0.01 |
| Parallel operations downgraded 25 to 50 pct | 8 | 0.00 | 0.00 |
| Parallel operations downgraded 50 to 75 pct | 2 | 0.00 | 0.00 |
| Parallel operations downgraded to serial | 27 | 0.01 | 0.00 |
| Parallel operations not downgraded | 3 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 43,701,614 | 11,941.41 | 37.20 |
| active txn count during cleanout | 83,605,104 | 22,844.98 | 71.17 |
| application wait time | 31,486 | 8.60 | 0.03 |
| background checkpoints completed | 2 | 0.00 | 0.00 |
| background checkpoints started | 2 | 0.00 | 0.00 |
| background timeouts | 11,558 | 3.16 | 0.01 |
| branch node splits | 1,037 | 0.28 | 0.00 |
| buffer is not pinned count | 703,448,546 | 192,216.39 | 598.81 |
| buffer is pinned count | 1,158,317,612 | 316,508.76 | 986.02 |
| bytes received via SQL*Net from client | 10,341,197,867 | 2,825,718.68 | 8,803.00 |
| bytes sent via SQL*Net to client | 9,269,405,099 | 2,532,852.72 | 7,890.63 |
| calls to get snapshot scn: kcmgss | 112,717,163 | 30,799.82 | 95.95 |
| calls to kcmgas | 18,351,407 | 5,014.50 | 15.62 |
| calls to kcmgcs | 1,655,133 | 452.26 | 1.41 |
| change write time | 107,719 | 29.43 | 0.09 |
| cleanout - number of ktugct calls | 15,200,365 | 4,153.48 | 12.94 |
| cleanouts and rollbacks - consistent read gets | 12,998,068 | 3,551.70 | 11.06 |
| cleanouts only - consistent read gets | 160,425 | 43.84 | 0.14 |
| cluster key scan block gets | 929,265 | 253.92 | 0.79 |
| cluster key scans | 190,382 | 52.02 | 0.16 |
| commit batch/immediate performed | 5,880 | 1.61 | 0.01 |
| commit batch/immediate requested | 5,880 | 1.61 | 0.01 |
| commit cleanout failures: block lost | 259,934 | 71.03 | 0.22 |
| commit cleanout failures: buffer being written | 1,150 | 0.31 | 0.00 |
| commit cleanout failures: callback failure | 140,073 | 38.27 | 0.12 |
| commit cleanout failures: cannot pin | 42,814 | 11.70 | 0.04 |
| commit cleanouts | 10,030,221 | 2,740.74 | 8.54 |
| commit cleanouts successfully completed | 9,586,249 | 2,619.43 | 8.16 |
| commit immediate performed | 5,880 | 1.61 | 0.01 |
| commit immediate requested | 5,880 | 1.61 | 0.01 |
| commit txn count during cleanout | 1,598,950 | 436.91 | 1.36 |
| concurrency wait time | 42,561 | 11.63 | 0.04 |
| consistent changes | 800,090,466 | 218,623.66 | 681.08 |
| consistent gets | 1,927,714,929 | 526,745.56 | 1,640.98 |
| consistent gets - examination | 1,245,191,802 | 340,247.02 | 1,059.98 |
| consistent gets direct | 190,952 | 52.18 | 0.16 |
| consistent gets from cache | 1,927,523,293 | 526,693.20 | 1,640.82 |
| current blocks converted for CR | 1,005 | 0.27 | 0.00 |
| cursor authentications | 1,988 | 0.54 | 0.00 |
| data blocks consistent reads - undo records applied | 795,345,810 | 217,327.19 | 677.04 |
| db block changes | 197,184,369 | 53,880.37 | 167.85 |
| db block gets | 208,690,056 | 57,024.28 | 177.65 |
| db block gets direct | 61,711 | 16.86 | 0.05 |
| db block gets from cache | 208,628,369 | 57,007.43 | 177.60 |
| deferred (CURRENT) block cleanout applications | 1,738,879 | 475.15 | 1.48 |
| dirty buffers inspected | 768,288 | 209.93 | 0.65 |
| doubling up with imu segment | 0 | 0.00 | 0.00 |
| enqueue conversions | 9,176 | 2.51 | 0.01 |
| enqueue releases | 4,723,893 | 1,290.80 | 4.02 |
| enqueue requests | 4,726,405 | 1,291.48 | 4.02 |
| enqueue timeouts | 2,256 | 0.62 | 0.00 |
| enqueue waits | 119,464 | 32.64 | 0.10 |
| exchange deadlocks | 36,456 | 9.96 | 0.03 |
| execute count | 99,951,299 | 27,311.56 | 85.08 |
| failed probes on index block reclamation | 1,200 | 0.33 | 0.00 |
| free buffer inspected | 6,043,330 | 1,651.33 | 5.14 |
| free buffer requested | 19,572,363 | 5,348.12 | 16.66 |
| heap block compress | 9,111,130 | 2,489.60 | 7.76 |
| hot buffers moved to head of LRU | 2,856,736 | 780.60 | 2.43 |
| immediate (CR) block cleanout applications | 13,158,417 | 3,595.52 | 11.20 |
| immediate (CURRENT) block cleanout applications | 1,143,728 | 312.52 | 0.97 |
| index crx upgrade (found) | 85,200 | 23.28 | 0.07 |
| index crx upgrade (positioned) | 10,124,881 | 2,766.61 | 8.62 |
| index fast full scans (full) | 7 | 0.00 | 0.00 |
| index fast full scans (rowid ranges) | 44 | 0.01 | 0.00 |
| index fetch by key | 159,418,128 | 43,560.79 | 135.71 |
| index scans kdiixs1 | 152,854,340 | 41,767.25 | 130.12 |
| java call heap collected bytes | 1,412,107,648 | 385,856.55 | 1,202.06 |
| java call heap collected count | 17,263,373 | 4,717.19 | 14.70 |
| java call heap gc count | 4,550 | 1.24 | 0.00 |
| java call heap live object count | 1,362,249 | 372.23 | 1.16 |
| java call heap live object count max | 1,429,397 | 390.58 | 1.22 |
| java call heap live size | 330,064,936 | 90,189.81 | 280.97 |
| java call heap live size max | 343,316,224 | 93,810.71 | 292.25 |
| java call heap object count | 3,586,501 | 980.01 | 3.05 |
| java call heap object count max | 3,595,477 | 982.46 | 3.06 |
| java call heap total size | 425,328,640 | 116,220.49 | 362.06 |
| java call heap total size max | 442,105,856 | 120,804.84 | 376.35 |
| java call heap used size | 473,410,208 | 129,358.71 | 402.99 |
| java call heap used size max | 481,955,016 | 131,693.57 | 410.27 |
| leaf node 90-10 splits | 22,789 | 6.23 | 0.02 |
| leaf node splits | 254,165 | 69.45 | 0.22 |
| lob reads | 21,680 | 5.92 | 0.02 |
| lob writes | 45,668 | 12.48 | 0.04 |
| lob writes unaligned | 45,669 | 12.48 | 0.04 |
| logons cumulative | 11,473 | 3.13 | 0.01 |
| messages received | 1,142,209 | 312.11 | 0.97 |
| messages sent | 1,142,208 | 312.11 | 0.97 |
| no buffer to keep pinned count | 14 | 0.00 | 0.00 |
| no work - consistent read gets | 635,570,998 | 173,668.94 | 541.03 |
| opened cursors cumulative | 6,248,218 | 1,707.32 | 5.32 |
| parse count (failures) | 3,735 | 1.02 | 0.00 |
| parse count (hard) | 9,286 | 2.54 | 0.01 |
| parse count (total) | 9,382,404 | 2,563.73 | 7.99 |
| parse time cpu | 102,551 | 28.02 | 0.09 |
| parse time elapsed | 120,404 | 32.90 | 0.10 |
| physical read IO requests | 904,722 | 247.21 | 0.77 |
| physical read bytes | 12,232,351,744 | 3,342,473.98 | 10,412.86 |
| physical read total IO requests | 906,451 | 247.69 | 0.77 |
| physical read total bytes | 12,259,641,344 | 3,349,930.83 | 10,436.09 |
| physical read total multi block requests | 19,599 | 5.36 | 0.02 |
| physical reads | 1,493,210 | 408.02 | 1.27 |
| physical reads cache | 1,066,354 | 291.38 | 0.91 |
| physical reads cache prefetch | 170,257 | 46.52 | 0.14 |
| physical reads direct | 426,854 | 116.64 | 0.36 |
| physical reads direct temporary tablespace | 186 | 0.05 | 0.00 |
| physical reads prefetch warmup | 22,592 | 6.17 | 0.02 |
| physical write IO requests | 1,126,732 | 307.88 | 0.96 |
| physical write bytes | 24,878,571,520 | 6,798,036.85 | 21,178.03 |
| physical write total IO requests | 2,624,649 | 717.18 | 2.23 |
| physical write total bytes | 57,799,217,152 | 15,793,559.84 | 49,201.92 |
| physical write total multi block requests | 1,719,275 | 469.79 | 1.46 |
| physical writes | 3,036,935 | 829.84 | 2.59 |
| physical writes direct | 62,117 | 16.97 | 0.05 |
| physical writes direct (lob) | 251 | 0.07 | 0.00 |
| physical writes direct temporary tablespace | 4,060 | 1.11 | 0.00 |
| physical writes from cache | 2,974,818 | 812.87 | 2.53 |
| physical writes non checkpoint | 2,618,656 | 715.54 | 2.23 |
| pinned buffers inspected | 7,279 | 1.99 | 0.01 |
| prefetch warmup blocks aged out before use | 222,178 | 60.71 | 0.19 |
| prefetched blocks aged out before use | 139 | 0.04 | 0.00 |
| process last non-idle time | 3,659 | 1.00 | 0.00 |
| queries parallelized | 13 | 0.00 | 0.00 |
| recursive aborts on index block reclamation | 13 | 0.00 | 0.00 |
| recursive calls | 163,191,658 | 44,591.91 | 138.92 |
| recursive cpu usage | 3,359,000 | 917.84 | 2.86 |
| redo blocks written | 64,127,592 | 17,522.78 | 54.59 |
| redo buffer allocation retries | 39 | 0.01 | 0.00 |
| redo entries | 100,990,470 | 27,595.51 | 85.97 |
| redo log space requests | 84 | 0.02 | 0.00 |
| redo log space wait time | 140 | 0.04 | 0.00 |
| redo ordering marks | 1,067,633 | 291.73 | 0.91 |
| redo size | 31,377,018,780 | 8,573,728.99 | 26,709.87 |
| redo subscn max counts | 2,417,344 | 660.54 | 2.06 |
| redo synch time | 83,248 | 22.75 | 0.07 |
| redo synch writes | 2,212,507 | 604.56 | 1.88 |
| redo wastage | 383,243,848 | 104,720.88 | 326.24 |
| redo write time | 31,222 | 8.53 | 0.03 |
| redo writer latching time | 631 | 0.17 | 0.00 |
| redo writes | 859,627 | 234.89 | 0.73 |
| rollback changes - undo records applied | 273,255 | 74.67 | 0.23 |
| rollbacks only - consistent read gets | 1,153,450 | 315.18 | 0.98 |
| rows fetched via callback | 97,984,081 | 26,774.02 | 83.41 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 5,558,872 | 1,518.95 | 4.73 |
| session logical reads | 2,136,414,396 | 583,772.42 | 1,818.64 |
| session pga memory | 12,961,396,904 | 3,541,684.61 | 11,033.46 |
| session pga memory max | 13,772,185,864 | 3,763,231.62 | 11,723.65 |
| session uga memory | ############### | 75,716,983.66 | 235,882.28 |
| session uga memory max | 82,740,430,744 | 22,608,713.56 | 70,433.27 |
| shared hash latch upgrades - no wait | 32,621,118 | 8,913.68 | 27.77 |
| shared hash latch upgrades - wait | 123,728 | 33.81 | 0.11 |
| sorts (memory) | 10,590,377 | 2,893.81 | 9.02 |
| sorts (rows) | 112,656,786 | 30,783.32 | 95.90 |
| sql area evicted | 858 | 0.23 | 0.00 |
| sql area purged | 3,819 | 1.04 | 0.00 |
| summed dirty queue length | 3,920,921 | 1,071.39 | 3.34 |
| switch current to new buffer | 1,764,952 | 482.27 | 1.50 |
| table fetch by rowid | 795,780,549 | 217,445.99 | 677.41 |
| table fetch continued row | 20,350,033 | 5,560.62 | 17.32 |
| table scan blocks gotten | 73,332,389 | 20,037.98 | 62.42 |
| table scan rows gotten | 4,128,227,381 | 1,128,032.69 | 3,514.18 |
| table scans (direct read) | 490 | 0.13 | 0.00 |
| table scans (long tables) | 739 | 0.20 | 0.00 |
| table scans (rowid ranges) | 698 | 0.19 | 0.00 |
| table scans (short tables) | 5,821,209 | 1,590.64 | 4.96 |
| total number of times SMON posted | 155,672 | 42.54 | 0.13 |
| transaction rollbacks | 5,880 | 1.61 | 0.01 |
| transaction tables consistent read rollbacks | 191 | 0.05 | 0.00 |
| transaction tables consistent reads - undo records applied | 16,098 | 4.40 | 0.01 |
| undo change vector size | 11,280,870,684 | 3,082,483.03 | 9,602.91 |
| user I/O wait time | 279,414 | 76.35 | 0.24 |
| user calls | 41,608,478 | 11,369.46 | 35.42 |
| user commits | 927,461 | 253.43 | 0.79 |
| user rollbacks | 247,274 | 67.57 | 0.21 |
| workarea executions - onepass | 2 | 0.00 | 0.00 |
| workarea executions - optimal | 5,862,709 | 1,601.98 | 4.99 |
| write clones created in background | 3,830 | 1.05 | 0.00 |
| write clones created in foreground | 653 | 0.18 | 0.00 |
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 | 284,087 | 1,142,469 |
| opened cursors current | 1,001,062 | 1,243,251 |
| workarea memory allocated | 4,255 | 1,302 |
| logons current | 5,013 | 5,041 |
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) | 2 | 1.97 |
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_TS_TX_DATA |
564,176 | 154 | 3.14 | 1.14 | 108,252 | 30 | 169,604 | 0.19 |
| APPS_UNDOTS1 |
18,572 | 5 | 0.42 | 1.00 | 618,775 | 169 | 374,689 | 0.05 |
| APPS_TS_TX_IDX |
226,155 | 62 | 3.03 | 1.06 | 121,321 | 33 | 112,185 | 0.25 |
| APPS_TS_TX_INTERFACE |
12,585 | 3 | 2.70 | 34.41 | 126,251 | 34 | 49,843 | 0.33 |
| APPS_ASSM_DATA |
39,048 | 11 | 0.76 | 2.37 | 59,731 | 16 | 199,890 | 0.66 |
| APPS_ASSM_IDX |
22,303 | 6 | 1.69 | 1.00 | 60,470 | 17 | 131,102 | 0.17 |
| TEMP |
3,801 | 1 | 2.89 | 2.06 | 22,154 | 6 | 57 | 4.74 |
| SYSTEM |
7,989 | 2 | 3.46 | 3.44 | 3,174 | 1 | 11,102 | 0.32 |
| APPS_TS_SEED |
7,574 | 2 | 4.17 | 1.20 | 2,441 | 1 | 1,056 | 2.37 |
| CTXSYS |
593 | 0 | 3.81 | 1.00 | 1,811 | 0 | 1 | 0.00 |
| APPS_TS_QUEUES |
339 | 0 | 3.07 | 1.32 | 654 | 0 | 452 | 0.22 |
| SYSAUX |
469 | 0 | 2.35 | 1.28 | 509 | 0 | 0 | 0.00 |
| APPS_TS_ARCHIVE |
244 | 0 | 3.69 | 1.00 | 528 | 0 | 200 | 5.40 |
| APPS_TS_SUMMARY |
94 | 0 | 6.28 | 1.00 | 257 | 0 | 81 | 0.00 |
| APPS_TS_NOLOGGING |
47 | 0 | 5.74 | 1.19 | 138 | 0 | 24 | 1.25 |
| APPS_TS_MEDIA |
6 | 0 | 5.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| ODM |
10 | 0 | 2.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLAP |
10 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| OWAPUB |
10 | 0 | 2.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| PORTAL |
10 | 0 | 4.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| SYNCSERVER |
10 | 0 | 2.00 | 1.00 | 2 | 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 | /OASB/11.5.10/oracle/data/apps_assm_data.dbf |
39,048 | 11 | 0.76 | 2.37 | 59,731 | 16 | 199,890 | 0.66 |
| APPS_ASSM_IDX | /OASB/11.5.10/oracle/data/apps_assm_idx.dbf |
22,303 | 6 | 1.69 | 1.00 | 60,470 | 17 | 131,102 | 0.17 |
| APPS_TS_ARCHIVE | /OASB/11.5.10/oracle/data/archive1.dbf |
90 | 0 | 3.67 | 1.00 | 243 | 0 | 86 | 6.40 |
| APPS_TS_ARCHIVE | /OASB/11.5.10/oracle/data/archive2.dbf |
154 | 0 | 3.70 | 1.00 | 285 | 0 | 114 | 4.65 |
| APPS_TS_MEDIA | /OASB/11.5.10/oracle/data/media1.dbf |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /OASB/11.5.10/oracle/data/media2.dbf |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /OASB/11.5.10/oracle/data/media3.dbf |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /OASB/11.5.10/oracle/data/nologging1.dbf |
28 | 0 | 5.00 | 1.32 | 88 | 0 | 24 | 1.25 |
| APPS_TS_NOLOGGING | /OASB/11.5.10/oracle/data/nologging2.dbf |
15 | 0 | 4.67 | 1.00 | 43 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /OASB/11.5.10/oracle/data/nologging3.dbf |
4 | 0 | 15.00 | 1.00 | 7 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /OASB/11.5.10/oracle/data/queues1.dbf |
30 | 0 | 4.33 | 1.47 | 85 | 0 | 4 | 0.00 |
| APPS_TS_QUEUES | /OASB/11.5.10/oracle/data/queues2.dbf |
93 | 0 | 3.44 | 1.54 | 149 | 0 | 142 | 0.21 |
| APPS_TS_QUEUES | /OASB/11.5.10/oracle/data/queues3.dbf |
66 | 0 | 2.27 | 1.03 | 121 | 0 | 113 | 0.27 |
| APPS_TS_QUEUES | /OASB/11.5.10/oracle/data/queues4.dbf |
56 | 0 | 2.50 | 1.13 | 79 | 0 | 152 | 0.20 |
| APPS_TS_QUEUES | /OASB/11.5.10/oracle/data/queues5.dbf |
35 | 0 | 2.86 | 1.23 | 60 | 0 | 15 | 0.00 |
| APPS_TS_QUEUES | /OASB/11.5.10/oracle/data/queues6.dbf |
30 | 0 | 3.33 | 1.47 | 56 | 0 | 3 | 0.00 |
| APPS_TS_QUEUES | /OASB/11.5.10/oracle/data/queues7.dbf |
29 | 0 | 3.45 | 1.48 | 104 | 0 | 23 | 0.43 |
| APPS_TS_SEED | /OASB/11.5.10/oracle/data/reference1.dbf |
471 | 0 | 3.91 | 1.30 | 221 | 0 | 229 | 2.62 |
| APPS_TS_SEED | /OASB/11.5.10/oracle/data/reference10.dbf |
493 | 0 | 4.65 | 1.16 | 172 | 0 | 1 | 0.00 |
| APPS_TS_SEED | /OASB/11.5.10/oracle/data/reference2.dbf |
611 | 0 | 3.73 | 1.24 | 230 | 0 | 739 | 2.52 |
| APPS_TS_SEED | /OASB/11.5.10/oracle/data/reference3.dbf |
867 | 0 | 4.01 | 1.20 | 272 | 0 | 4 | 7.50 |
| APPS_TS_SEED | /OASB/11.5.10/oracle/data/reference4.dbf |
857 | 0 | 4.41 | 1.19 | 247 | 0 | 39 | 0.26 |
| APPS_TS_SEED | /OASB/11.5.10/oracle/data/reference5.dbf |
856 | 0 | 4.39 | 1.12 | 239 | 0 | 4 | 0.00 |
| APPS_TS_SEED | /OASB/11.5.10/oracle/data/reference6.dbf |
838 | 0 | 4.61 | 1.24 | 269 | 0 | 17 | 0.00 |
| APPS_TS_SEED | /OASB/11.5.10/oracle/data/reference7.dbf |
848 | 0 | 3.93 | 1.25 | 263 | 0 | 9 | 0.00 |
| APPS_TS_SEED | /OASB/11.5.10/oracle/data/reference8.dbf |
872 | 0 | 3.81 | 1.15 | 282 | 0 | 10 | 0.00 |
| APPS_TS_SEED | /OASB/11.5.10/oracle/data/reference9.dbf |
861 | 0 | 4.24 | 1.18 | 246 | 0 | 4 | 0.00 |
| APPS_TS_SUMMARY | /OASB/11.5.10/oracle/data/summary1.dbf |
7 | 0 | 7.14 | 1.00 | 29 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /OASB/11.5.10/oracle/data/summary2.dbf |
8 | 0 | 7.50 | 1.00 | 38 | 0 | 78 | 0.00 |
| APPS_TS_SUMMARY | /OASB/11.5.10/oracle/data/summary3.dbf |
9 | 0 | 8.89 | 1.00 | 23 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /OASB/11.5.10/oracle/data/summary4.dbf |
7 | 0 | 7.14 | 1.00 | 19 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /OASB/11.5.10/oracle/data/summary5.dbf |
6 | 0 | 6.67 | 1.00 | 23 | 0 | 2 | 0.00 |
| APPS_TS_SUMMARY | /OASB/11.5.10/oracle/data/summary6.dbf |
32 | 0 | 4.06 | 1.00 | 59 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /OASB/11.5.10/oracle/data/summary7.dbf |
20 | 0 | 7.00 | 1.00 | 47 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /OASB/11.5.10/oracle/data/summary8.dbf |
5 | 0 | 8.00 | 1.00 | 19 | 0 | 1 | 0.00 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data1.dbf |
1,928 | 1 | 2.64 | 1.66 | 2,234 | 1 | 6,290 | 0.28 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data10.dbf |
1,847 | 1 | 2.34 | 1.50 | 1,994 | 1 | 5,374 | 0.31 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data11.dbf |
2,095 | 1 | 2.67 | 1.57 | 2,302 | 1 | 7,445 | 0.37 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data12.dbf |
51,089 | 14 | 3.06 | 1.09 | 7,589 | 2 | 6,774 | 0.12 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data13.dbf |
51,224 | 14 | 3.30 | 1.09 | 7,633 | 2 | 6,713 | 0.09 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data14.dbf |
52,872 | 14 | 3.33 | 1.09 | 9,160 | 3 | 41,980 | 0.08 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data15.dbf |
50,690 | 14 | 2.94 | 1.10 | 7,893 | 2 | 6,359 | 0.11 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data16.dbf |
50,424 | 14 | 3.06 | 1.09 | 7,649 | 2 | 6,841 | 0.07 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data17.dbf |
50,364 | 14 | 2.98 | 1.10 | 7,603 | 2 | 6,277 | 0.07 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data18.dbf |
50,229 | 14 | 3.05 | 1.09 | 7,503 | 2 | 5,813 | 0.09 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data19.dbf |
50,166 | 14 | 3.06 | 1.09 | 7,525 | 2 | 6,276 | 0.09 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data2.dbf |
2,098 | 1 | 2.32 | 2.40 | 2,541 | 1 | 6,571 | 0.35 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data20.dbf |
50,201 | 14 | 3.33 | 1.10 | 7,413 | 2 | 5,686 | 0.11 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data21.dbf |
50,507 | 14 | 3.37 | 1.10 | 7,385 | 2 | 5,620 | 0.08 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data3.dbf |
2,777 | 1 | 2.53 | 2.20 | 3,160 | 1 | 5,930 | 0.49 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data4.dbf |
3,335 | 1 | 2.73 | 1.94 | 3,206 | 1 | 6,065 | 0.29 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data5.dbf |
15,981 | 4 | 3.46 | 1.22 | 3,219 | 1 | 6,550 | 0.45 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data6.dbf |
4,648 | 1 | 2.92 | 1.73 | 3,269 | 1 | 6,923 | 0.35 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data7.dbf |
15,648 | 4 | 3.50 | 1.22 | 3,079 | 1 | 6,121 | 0.31 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data8.dbf |
2,611 | 1 | 2.37 | 2.02 | 2,761 | 1 | 7,432 | 0.27 |
| APPS_TS_TX_DATA | /OASB/11.5.10/oracle/data/tx_data9.dbf |
3,442 | 1 | 2.57 | 1.93 | 3,134 | 1 | 6,564 | 0.26 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx1.dbf |
1,550 | 0 | 3.15 | 1.02 | 2,067 | 1 | 2,849 | 0.44 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx10.dbf |
2,016 | 1 | 3.29 | 1.03 | 4,777 | 1 | 2,865 | 0.24 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx11.dbf |
2,192 | 1 | 2.97 | 1.03 | 3,904 | 1 | 3,820 | 0.94 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx12.dbf |
19,551 | 5 | 3.00 | 1.07 | 8,630 | 2 | 7,444 | 0.22 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx13.dbf |
19,247 | 5 | 2.96 | 1.07 | 8,328 | 2 | 6,854 | 0.25 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx14.dbf |
22,058 | 6 | 2.86 | 1.06 | 12,411 | 3 | 9,711 | 0.13 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx15.dbf |
19,023 | 5 | 2.97 | 1.07 | 8,301 | 2 | 6,804 | 0.18 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx16.dbf |
18,852 | 5 | 3.09 | 1.07 | 7,946 | 2 | 5,198 | 0.14 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx17.dbf |
18,828 | 5 | 2.91 | 1.07 | 7,851 | 2 | 5,650 | 0.22 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx18.dbf |
18,734 | 5 | 3.04 | 1.06 | 7,882 | 2 | 6,821 | 0.21 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx19.dbf |
19,059 | 5 | 2.98 | 1.08 | 8,127 | 2 | 6,620 | 0.18 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx2.dbf |
1,658 | 0 | 2.85 | 1.02 | 3,408 | 1 | 8,921 | 0.22 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx20.dbf |
18,559 | 5 | 3.07 | 1.06 | 7,820 | 2 | 7,905 | 0.16 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx21.dbf |
18,652 | 5 | 3.04 | 1.08 | 7,823 | 2 | 8,301 | 0.19 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx3.dbf |
2,891 | 1 | 3.13 | 1.05 | 3,802 | 1 | 2,672 | 0.49 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx4.dbf |
4,160 | 1 | 3.25 | 1.06 | 3,691 | 1 | 2,537 | 0.47 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx5.dbf |
4,004 | 1 | 3.22 | 1.03 | 3,102 | 1 | 2,591 | 0.39 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx6.dbf |
3,828 | 1 | 3.32 | 1.05 | 2,941 | 1 | 2,774 | 0.28 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx7.dbf |
3,800 | 1 | 3.38 | 1.04 | 2,604 | 1 | 4,048 | 0.40 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx8.dbf |
3,622 | 1 | 3.26 | 1.05 | 3,320 | 1 | 4,063 | 0.31 |
| APPS_TS_TX_IDX | /OASB/11.5.10/oracle/data/tx_idx9.dbf |
3,871 | 1 | 3.51 | 1.03 | 2,586 | 1 | 3,737 | 0.18 |
| APPS_TS_TX_INTERFACE | /OASB/11.5.10/oracle/data/ts_tx_inte.dbf |
1,436 | 0 | 1.99 | 15.59 | 5,158 | 1 | 4,840 | 0.21 |
| APPS_TS_TX_INTERFACE | /OASB/11.5.10/oracle/data/ts_tx_inte2.dbf |
2,517 | 1 | 2.89 | 32.65 | 24,200 | 7 | 9,813 | 0.52 |
| APPS_TS_TX_INTERFACE | /OASB/11.5.10/oracle/data/ts_tx_inte3.dbf |
2,045 | 1 | 3.16 | 40.28 | 24,376 | 7 | 7,542 | 0.28 |
| APPS_TS_TX_INTERFACE | /OASB/11.5.10/oracle/data/ts_tx_inte4.dbf |
2,403 | 1 | 3.05 | 34.11 | 24,149 | 7 | 9,168 | 0.35 |
| APPS_TS_TX_INTERFACE | /OASB/11.5.10/oracle/data/ts_tx_inte5.dbf |
1,960 | 1 | 2.27 | 41.98 | 24,409 | 7 | 8,908 | 0.24 |
| APPS_TS_TX_INTERFACE | /OASB/11.5.10/oracle/data/ts_tx_inte6.dbf |
2,224 | 1 | 2.53 | 36.79 | 23,959 | 7 | 9,572 | 0.30 |
| APPS_UNDOTS1 | /OASB/11.5.10/oracle/data/undo01.dbf |
78 | 0 | 0.64 | 1.00 | 24,684 | 7 | 42,505 | 0.05 |
| APPS_UNDOTS1 | /OASB/11.5.10/oracle/data/undo02.dbf |
25 | 0 | 0.40 | 1.00 | 25,291 | 7 | 40,609 | 0.05 |
| APPS_UNDOTS1 | /OASB/11.5.10/oracle/data/undo03.dbf |
122 | 0 | 0.16 | 1.00 | 25,087 | 7 | 37,963 | 0.05 |
| APPS_UNDOTS1 | /OASB/11.5.10/oracle/data/undo04.dbf |
57 | 0 | 0.35 | 1.00 | 25,181 | 7 | 38,592 | 0.05 |
| APPS_UNDOTS1 | /OASB/11.5.10/oracle/data/undo05.dbf |
3,215 | 1 | 0.50 | 1.00 | 108,258 | 30 | 43,752 | 0.05 |
| APPS_UNDOTS1 | /OASB/11.5.10/oracle/data/undo06.dbf |
3,359 | 1 | 0.48 | 1.00 | 105,731 | 29 | 45,516 | 0.05 |
| APPS_UNDOTS1 | /OASB/11.5.10/oracle/data/undo07.dbf |
3,750 | 1 | 0.39 | 1.00 | 104,589 | 29 | 43,263 | 0.06 |
| APPS_UNDOTS1 | /OASB/11.5.10/oracle/data/undo08.dbf |
4,192 | 1 | 0.41 | 1.00 | 101,794 | 28 | 40,165 | 0.05 |
| APPS_UNDOTS1 | /OASB/11.5.10/oracle/data/undo09.dbf |
3,774 | 1 | 0.34 | 1.00 | 98,160 | 27 | 42,324 | 0.05 |
| CTXSYS | /OASB/11.5.10/oracle/data/ctx1.dbf |
154 | 0 | 3.64 | 1.00 | 243 | 0 | 1 | 0.00 |
| CTXSYS | /OASB/11.5.10/oracle/data/ctx2.dbf |
439 | 0 | 3.87 | 1.00 | 1,568 | 0 | 0 | 0.00 |
| ODM | /OASB/11.5.10/oracle/data/odm.dbf |
10 | 0 | 2.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLAP | /OASB/11.5.10/oracle/data/olap.dbf |
10 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| OWAPUB | /OASB/11.5.10/oracle/data/owa1.dbf |
10 | 0 | 2.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| PORTAL | /OASB/11.5.10/oracle/data/portal.dbf |
10 | 0 | 4.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| SYNCSERVER | /OASB/11.5.10/oracle/data/mobile01.dbf |
10 | 0 | 2.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| SYSAUX | /OASB/11.5.10/oracle/data/sysaux01.dbf |
320 | 0 | 2.09 | 1.37 | 314 | 0 | 0 | 0.00 |
| SYSAUX | /OASB/11.5.10/oracle/data/sysaux02.dbf |
149 | 0 | 2.89 | 1.08 | 195 | 0 | 0 | 0.00 |
| SYSTEM | /OASB/11.5.10/oracle/data/sys1.dbf |
1,227 | 0 | 3.37 | 3.37 | 345 | 0 | 363 | 0.91 |
| SYSTEM | /OASB/11.5.10/oracle/data/sys2.dbf |
1,180 | 0 | 3.64 | 3.47 | 420 | 0 | 404 | 1.49 |
| SYSTEM | /OASB/11.5.10/oracle/data/sys3.dbf |
1,044 | 0 | 3.30 | 3.73 | 382 | 0 | 390 | 0.69 |
| SYSTEM | /OASB/11.5.10/oracle/data/sys4.dbf |
1,165 | 0 | 3.68 | 3.41 | 636 | 0 | 487 | 1.01 |
| SYSTEM | /OASB/11.5.10/oracle/data/sys5.dbf |
1,270 | 0 | 3.37 | 3.19 | 555 | 0 | 453 | 0.73 |
| SYSTEM | /OASB/11.5.10/oracle/data/sys6.dbf |
1,206 | 0 | 3.46 | 3.35 | 432 | 0 | 1,045 | 0.55 |
| SYSTEM | /OASB/11.5.10/oracle/data/sys7.dbf |
842 | 0 | 3.40 | 3.84 | 326 | 0 | 2,383 | 0.23 |
| SYSTEM | /OASB/11.5.10/oracle/data/sys8.dbf |
29 | 0 | 3.79 | 1.00 | 37 | 0 | 5,491 | 0.08 |
| SYSTEM | /OASB/11.5.10/oracle/data/sys9.dbf |
26 | 0 | 1.54 | 1.00 | 41 | 0 | 86 | 0.23 |
| TEMP | /OASB/11.5.10/oracle/data/tmp1.dbf |
746 | 0 | 3.15 | 2.82 | 3,992 | 1 | 0 | |
| TEMP | /OASB/11.5.10/oracle/data/tmp2.dbf |
1,063 | 0 | 2.82 | 2.00 | 6,869 | 2 | 35 | 6.00 |
| TEMP | /OASB/11.5.10/oracle/data/tmp3.dbf |
1,006 | 0 | 3.03 | 1.00 | 5,728 | 2 | 3 | 3.33 |
| TEMP | /OASB/11.5.10/oracle/data/tmp4.dbf |
986 | 0 | 2.61 | 2.61 | 5,565 | 2 | 19 | 2.63 |
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 | 989,500 | 100 | 2,133,894,352 | 1,067,177 | 2,974,884 | 0 | 0 | 1,050,417 |
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 | 0 | 93 | 51414 | 1189294 | 3338128 | 73728000 | 3338128 | |
| E | 0 | 96 | 54079 | 1232255 | 16978231 | 73728000 | 16978231 | |
Back to Advisory Statistics
Back to Top
|
