WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
VIS 187584551 VIS 1 10.2.0.3.0 NO hpdb1.zko.hp

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 1 01-May-09 19:39:49 5240 208.7
End Snap: 4 01-May-09 20:39:54 5282 234.8
Elapsed:   60.08 (mins)    
DB Time:   449.10 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 17,808M 17,616M Std Block Size: 8K
Shared Pool Size: 2,576M 2,768M Log Buffer: 14,320K

Load Profile

  Per Second Per Transaction
Redo size: 8,950,340.81 25,808.93
Logical reads: 581,183.59 1,675.88
Block changes: 55,892.08 161.17
Physical reads: 123.64 0.36
Physical writes: 875.62 2.52
User calls: 13,786.55 39.75
Parses: 2,573.35 7.42
Hard parses: 2.67 0.01
Sorts: 3,060.42 8.82
Logons: 2.83 0.01
Executes: 29,106.05 83.93
Transactions: 346.79  

% Blocks changed per Read: 9.62 Recursive Call %: 77.35
Rollback per transaction %: 21.19 Rows per Sort: 12.43

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 99.77 Soft Parse %: 99.90
Execute to Parse %: 91.16 Latch Hit %: 99.01
Parse CPU to Parse Elapsd %: 94.35 % Non-Parse CPU: 97.71

Shared Pool Statistics

  Begin End
Memory Usage %: 86.40 86.78
% SQL with executions>1: 87.95 93.82
% Memory for SQL w/exec>1: 65.25 85.98

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   21,152   78.5  
SQL*Net more data from client 2,572,653 6,118 2 22.7 Network
db file sequential read 286,011 981 3 3.6 User I/O
log file sync 546,213 786 1 2.9 Commit
log file parallel write 862,622 352 0 1.3 System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
DB CPU 21,152.48 78.50
sql execute elapsed time 20,339.37 75.48
PL/SQL execution elapsed time 7,797.45 28.94
inbound PL/SQL rpc elapsed time 7,648.51 28.38
parse time elapsed 586.57 2.18
Java execution elapsed time 506.25 1.88
hard parse elapsed time 312.13 1.16
repeated bind elapsed time 85.44 0.32
sequence load elapsed time 14.26 0.05
connection management call elapsed time 10.92 0.04
PL/SQL compilation elapsed time 6.56 0.02
hard parse (sharing criteria) elapsed time 4.96 0.02
failed parse elapsed time 1.62 0.01
hard parse (bind mismatch) elapsed time 1.03 0.00
DB time 26,946.02  
background elapsed time 1,061.64  
background cpu time 371.37  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
Network 56,683,829 0.00 6,162 0 45.34
User I/O 343,228 0.00 1,103 3 0.27
Commit 546,213 0.00 786 1 0.44
System I/O 1,175,731 0.00 506 0 0.94
Application 70,342 0.09 233 3 0.06
Concurrency 2,577,882 0.15 171 0 2.06
Other 163,541 17.74 43 0 0.13
Configuration 6,781 0.00 3 0 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
SQL*Net more data from client 2,572,653 0.00 6,118 2 2.06
db file sequential read 286,011 0.00 981 3 0.23
log file sync 546,213 0.00 786 1 0.44
log file parallel write 862,622 0.00 352 0 0.69
enq: TX - row lock contention 762 6.30 157 207 0.00
db file parallel write 281,239 0.00 147 1 0.22
latch: cache buffers chains 1,818,560 0.00 65 0 1.45
read by other session 42,379 0.00 63 1 0.03
db file scattered read 11,975 0.00 58 5 0.01
enq: UL - contention 2,080 0.72 55 26 0.00
cursor: pin S wait on X 4,132 90.51 41 10 0.00
SQL*Net message to client 52,070,964 0.00 25 0 41.65
buffer busy waits 686,819 0.00 23 0 0.55
SQL*Net more data to client 2,040,212 0.00 19 0 1.63
enq: TX - index contention 27,962 0.00 12 0 0.02
library cache load lock 580 0.00 11 19 0.00
SQL*Net break/reset to client 67,466 0.00 11 0 0.05
latch: undo global data 31,700 0.00 10 0 0.03
PX Deq Credit: send blkd 22,603 0.00 9 0 0.02
latch: library cache 11,027 0.00 7 1 0.01
enq: RO - fast object reuse 29 0.00 7 237 0.00
rdbms ipc reply 5 60.00 7 1350 0.00
control file sequential read 30,131 0.00 6 0 0.02
latch: In memory undo latch 19,272 0.00 6 0 0.02
enq: TM - contention 5 0.00 3 626 0.00
PX Deq: Signal ACK 246 41.06 3 12 0.00
latch: object queue header operation 23,581 0.00 3 0 0.02
kksfbc child completion 61 81.97 2 41 0.00
os thread startup 71 0.00 2 32 0.00
latch: library cache pin 2,974 0.00 2 1 0.00
latch free 3,168 0.00 2 1 0.00
LGWR wait for redo copy 34,486 0.00 1 0 0.03
local write wait 1,593 0.00 1 1 0.00
latch: cache buffers lru chain 1,764 0.00 1 1 0.00
enq: HW - contention 2,431 0.00 1 1 0.00
log buffer space 219 0.00 1 5 0.00
control file parallel write 1,739 0.00 1 1 0.00
enq: TX - contention 2,751 0.00 1 0 0.00
latch: row cache objects 968 0.00 1 1 0.00
latch: redo allocation 1,141 0.00 1 1 0.00
enq: DV - contention 146 0.00 1 4 0.00
enq: SQ - contention 3,960 0.00 1 0 0.00
library cache pin 2,324 0.00 1 0 0.00
wait list latch free 41 0.00 0 12 0.00
buffer deadlock 28,799 99.09 0 0 0.02
latch: session allocation 693 0.00 0 1 0.00
SGA: allocation forcing component growth 24 37.50 0 11 0.00
row cache lock 2,275 0.00 0 0 0.00
enq: CU - contention 14 0.00 0 18 0.00
latch: library cache lock 218 0.00 0 1 0.00
direct path read 735 0.00 0 0 0.00
cursor: pin S 10,438 0.00 0 0 0.01
latch: shared pool 617 0.00 0 0 0.00
enq: FB - contention 676 0.00 0 0 0.00
latch: object queue header heap 258 0.00 0 0 0.00
enq: US - contention 16 0.00 0 6 0.00
latch: cache buffer handles 266 0.00 0 0 0.00
latch: messages 161 0.00 0 0 0.00
PX qref latch 370 83.24 0 0 0.00
latch: enqueue hash chains 32 0.00 0 1 0.00
enq: TX - allocate ITL entry 75 0.00 0 0 0.00
latch: redo writing 91 0.00 0 0 0.00
reliable message 38 0.00 0 1 0.00
cursor: pin X 2 100.00 0 11 0.00
library cache lock 1 0.00 0 19 0.00
cursor: mutex S 65 0.00 0 0 0.00
latch: checkpoint queue latch 15 0.00 0 0 0.00
enq: PS - contention 43 0.00 0 0 0.00
write complete waits 5 0.00 0 1 0.00
direct path write 463 0.00 0 0 0.00
latch: parallel query alloc buffer 1 0.00 0 2 0.00
direct path write temp 52 0.00 0 0 0.00
cursor: mutex X 17 0.00 0 0 0.00
direct path read temp 20 0.00 0 0 0.00
L1 validation 2 0.00 0 0 0.00
SQL*Net message from client 52,070,915 0.00 10,075,701 193 41.65
pipe get 29,289 14.80 21,072 719 0.02
Streams AQ: qmn slave idle wait 129 0.00 3,526 27332 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,526 13666 0.00
Streams AQ: waiting for time management or cleanup tasks 2,999 39.58 3,509 1170 0.00
PX Idle Wait 1,619 76.10 2,540 1569 0.00
PL/SQL lock timer 216 99.07 2,423 11215 0.00
jobq slave wait 612 99.84 1,793 2930 0.00
PX Deq: Execution Msg 5,095 0.00 39 8 0.00
PX Deq: Execute Reply 2,674 0.00 3 1 0.00
PX Deq Credit: need buffer 4,760 0.00 1 0 0.00
PX Deq: Msg Fragment 4,415 0.00 1 0 0.00
PX Deq: Table Q Normal 7,117 0.00 0 0 0.01
PX Deq: Parse Reply 235 0.00 0 1 0.00
PX Deq: Join ACK 257 0.00 0 0 0.00
class slave wait 1 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 862,616 0.00 352 0 0.69
db file parallel write 281,239 0.00 147 1 0.22
events in waitclass Other 44,044 0.00 3 0 0.04
control file sequential read 827 0.00 2 3 0.00
os thread startup 62 0.00 2 33 0.00
db file scattered read 525 0.00 2 3 0.00
control file parallel write 1,739 0.00 1 1 0.00
db file sequential read 208 0.00 1 3 0.00
direct path read 732 0.00 0 0 0.00
latch: redo writing 91 0.00 0 0 0.00
latch: cache buffers chains 71 0.00 0 0 0.00
direct path write 333 0.00 0 0 0.00
latch: library cache pin 1 0.00 0 1 0.00
buffer busy waits 8 0.00 0 0 0.00
log file sync 1 0.00 0 1 0.00
latch: library cache 1 0.00 0 0 0.00
latch: library cache lock 1 0.00 0 0 0.00
latch: shared pool 1 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
rdbms ipc message 1,663,126 0.73 35,987 22 1.33
Streams AQ: qmn slave idle wait 129 0.00 3,526 27332 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,526 13666 0.00
pmon timer 1,401 86.65 3,509 2505 0.00
Streams AQ: waiting for time management or cleanup tasks 2,999 39.58 3,509 1170 0.00
smon timer 151,246 0.00 3,501 23 0.12

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 2,265,081
IDLE_TIME 3,499,991
IOWAIT_TIME 108,687
NICE_TIME 19,043
SYS_TIME 108,525
USER_TIME 2,060,438
LOAD 5
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 46,997,120
NUM_CPUS 16
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
SYS$USERS 26,947.40 21,153.60 430,656 2,091,274,779
SYS$BACKGROUND 0.00 0.00 15,095 3,885,409
VIS 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
SYS$USERS 341434 110083 2577733 16891 0 0 56668144 616197
SYS$BACKGROUND 1798 258 146 207 0 0 0 0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
728 722 298 2.44 2.70 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
474 469 16 29.59 1.76 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
449 421 112,644 0.00 1.67 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
412 11 20,008 0.02 1.53 fw8fr3nddyd26 PYUSLV insert into pay_run_balances(r...
406 403 64,006 0.01 1.51 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
399 8 10,000 0.04 1.48 38kpqs2vdwfh9 PYUSLV update pay_person_latest_balan...
382 372 1,441 0.27 1.42 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
380 377 55,654 0.01 1.41 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
337 335 55,673 0.01 1.25 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
317 315 374,992 0.00 1.18 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
310 308 55,673 0.01 1.15 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
275 273 50,440 0.01 1.02 6ubqcscr1gk1b asnDispContainer.jsp select name, value from icx_s...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
722 728 298 2.42 2.70 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
469 474 16 29.34 1.76 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
421 449 112,644 0.00 1.67 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
403 406 64,006 0.01 1.51 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
377 380 55,654 0.01 1.41 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
372 382 1,441 0.26 1.42 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
335 337 55,673 0.01 1.25 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
315 317 374,992 0.00 1.18 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
308 310 55,673 0.01 1.15 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
273 275 50,440 0.01 1.02 6ubqcscr1gk1b asnDispContainer.jsp select name, value from icx_s...
11 412 20,008 0.00 1.53 fw8fr3nddyd26 PYUSLV insert into pay_run_balances(r...
8 399 10,000 0.00 1.48 38kpqs2vdwfh9 PYUSLV update pay_person_latest_balan...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
99,666,226 16 6,229,139.13 4.76 469.37 473.50 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
62,706,998 155,643 402.89 2.99 182.44 184.07 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
49,501,570 55,654 889.45 2.36 376.59 379.88 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
44,827,529 64,006 700.36 2.14 402.59 406.10 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
44,009,678 298 147,683.48 2.10 721.90 727.86 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
40,961,650 1,441 28,425.85 1.96 372.11 382.31 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
37,181,699 55,673 667.86 1.77 307.80 309.89 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
31,368,700 1,439,443 21.79 1.50 115.76 117.03 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
29,080,402 168,752 172.33 1.39 153.40 155.30 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
29,073,199 168,733 172.30 1.39 142.63 144.42 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
28,755,561 55,673 516.51 1.37 335.00 337.34 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
26,401,162 10,000 2,640.12 1.26 81.24 183.23 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
25,935,158 202,396 128.14 1.24 205.26 225.80 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
24,788,036 9 2,754,226.22 1.18 101.74 101.74 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
24,622,589 50,440 488.16 1.18 272.98 274.87 6ubqcscr1gk1b asnDispContainer.jsp select name, value from icx_s...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
45,237 10,000 4.52 10.15 81.24 183.23 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
38,134 2,400 15.89 8.56 14.45 153.23 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
37,265 2,400 15.53 8.36 99.69 220.90 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
19,886 21,625 0.92 4.46 165.38 227.77 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
9,735 7,212 1.35 2.18 116.23 150.24 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
9,705 202,396 0.05 2.18 205.26 225.80 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
5,462 10,000 0.55 1.23 15.29 25.86 4sqqnd7uvn7xg PYUSLV select /*+ ORDERED USE_NL(AC...
4,779 10,000 0.48 1.07 8.37 398.52 38kpqs2vdwfh9 PYUSLV update pay_person_latest_balan...
4,596 9,999 0.46 1.03 130.17 138.56 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,515 10,000 0.45 1.01 107.34 113.15 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
1,439,443 744,934 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
818,479 818,480 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
596,502 596,493 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
513,506 168,801 0.33 0.00 0.00 c4y7jp0q2awbf   SELECT PROFILE_OPTION_VALUE FR...
501,392 447,332 0.89 0.00 0.00 6cjfxb1c4kx16   SELECT PROFILE_OPTION_ID, APP...
439,207 439,105 1.00 0.00 0.00 821fx90awyvj7 OEXOETEL SELECT ACCOUNTING_RULE_ID , A...
374,992 374,986 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
343,946 262,588 0.76 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
290,767 4,942,945 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
202,396 202,396 1.00 0.00 0.00 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
596,517 596,502 6.43 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
374,990 374,992 4.04 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
343,959 343,946 3.71 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
290,769 290,767 3.13 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
202,395 202,396 2.18 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
173,990 173,981 1.88 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
125,225 125,219 1.35 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
120,301 120,301 1.30 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
113,100 113,097 1.22 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
111,293 111,293 1.20 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
101,265 101,250 1.09 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
95,270 95,266 1.03 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
95,270 95,260 1.03 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
95,270 101,262 1.03 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
1,752,544 1,198 0.06 2nfc4vng01c8t POXPOVPO SELECT END_DATE, START_DATE, R...
1,260,735 20,887 0.04 8q8zmrwmrccz4 OEXOETEL SELECT /*+ ORDERED USE_NL(adj ...
1,077,898 28,787 0.04 dzt4ys8ynkyrj CSCCCCRC INSERT INTO CS_INCIDENTS_AUDIT...

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
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
1q78dwnrrkf6c BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END;
2nfc4vng01c8t SELECT END_DATE, START_DATE, ROW_ID, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, PO_NUM, RELEASE_NUM, RELEASE_TYPE, REVISED_DATE, APPROVED_DATE, BILL_TO_LOCATION_ID, BILL_TO_LOCATION, AGENT_ID, VENDOR_SITE_ID, VENDOR_SITE_CODE, VENDOR_ID, VENDOR_NAME, VENDOR_CONTACT, AUTHORIZATION_STATUS, NEED_BY_DATE, REVISION_NUM, DOC_TYPE_NAME, GLOBAL_AGREEMENT_FLAG, OWNING_ORG_ID, TYPE_LOOKUP_CODE, ORDER_DATE, CURRENCY_CODE, TERMS_NAME, SHIP_VIA_LOOKUP_CODE, HEADER_FOB_LOOKUP_CODE, HEADER_FREIGHT_TERMS_LC, RATE_TYPE, RATE_DATE, RATE, PLL_NOTE_TO_RECEIVER, CONFIRMING_ORDER_FLAG, LINE_NUM, LINE_TYPE_ID, LINE_TYPE, ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS, ITEM_ID, ITEM_REVISION, JOB_ID, CATEGORY_ID, ITEM_DESCRIPTION, UNIT_MEAS_LOOKUP_CODE, ALLOW_PRICE_OVERRIDE_FLAG, NOT_TO_EXCEED_PRICE, UN_NUMBER, HAZARD_CLASS, FROM_HEADER_ID, FROM_LINE_ID, FROM_LINE_LOCATION_ID, NOTE_TO_VENDOR, UNORDERED_FLAG, VENDOR_PRODUCT_NUM, CONTRACT_ID, MIN_RELEASE_AMOUNT, PO_HEADER_ID, PO_RELEASE_ID, CLOSED_BY, CANCELLED_BY, PO_LINE_ID, LINE_LOCATION_ID, SHIPMENT_NUM, CREATION_DATE, QUANTITY, QUANTITY_RECEIVED, QUANTITY_ACCEPTED, QUANTITY_REJECTED, QUANTITY_BILLED, QUANTITY_CANCELLED, AMOUNT, AMOUNT_RECEIVED, AMOUNT_BILLED, AMOUNT_CANCELLED, SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION, PROMISED_DATE, LAST_ACCEPT_DATE, PRICE_OVERRIDE, ENCUMBERED_FLAG, TAXABLE_FLAG, TAX_NAME, CANCEL_FLAG, CANCEL_DATE, CANCEL_REASON, FIRM_STATUS_LOOKUP_CODE, MATCHING_TYPE, MATCH_OPTION, COUNTRY_OF_ORIGIN, QTY_RCV_TOLERANC E, QTY_RCV_EXCEPTION_CODE, ENFORCE_SHIP_TO_LOCATION_CODE, ALLOW_SUBSTITUTE_RECEIPTS_FLAG, DAYS_EARLY_RECEIPT_ALLOWED, DAYS_LATE_RECEIPT_ALLOWED, RECEIPT_DAYS_EXCEPTION_CODE, INVOICE_CLOSE_TOLERANCE, RECEIVE_CLOSE_TOLERANCE, SHIP_TO_ORGANIZATION_ID, SHIP_TO_ORGANIZATION, SOURCE_SHIPMENT_ID, SHIPMENT_TYPE, CLOSED_CODE, RECEIVING_ROUTING_ID, ROUTING_NAME, ACCRUE_ON_RECEIPT_FLAG, CLOSED_REASON, CLOSED_DATE, SOURCE_SHIPMENT_NUM, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE_CATEGORY, USSGL_TRANSACTION_CODE, ACCEPTANCE_DUE_DATE, SECONDARY_UNIT_OF_MEASURE, SECONDARY_QUANTITY, PREFERRED_GRADE, SECONDARY_QUANTITY_RECEIVED, SECONDARY_QUANTITY_ACCEPTED, SECONDARY_QUANTITY_REJECTED, SECONDARY_QUANTITY_CANCELLED, VMI_FLAG, CONSIGNED_FLAG, CONSIGNED_CONSUMPTION_FLAG, AUTO_PRICED_FLAG FROM PO_LINE_LOCATIONS_INQ_V WHERE (:1 = agent_id OR EXISTS ( SELECT 'This employee is in approval path of this doc' FROM PO_ACTION_HISTORY POAH2 WHERE POAH2.employee_id + 0 = :2 AND POAH2.object_type_code in ('PO', 'PA') AND POAH2.object_id = po_header_id) OR( ((type_lookup_code = 'STANDARD') AND (release_num is null)) AND ( ( :3 = 'PUBLIC') OR ( :4 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id =:5 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :6 = 'HIERARCHY' AND :7 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :8 , -1) )) ) ) OR( ((type_lookup_code = 'PLANNED') AND (release_num is null)) AND ( ( :9 = 'PUBLIC') OR ( :10 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :11 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :12 = 'HIERARCHY' AND :13 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :14 , -1) )) ) ) OR( ((type_lookup_code = 'BLANKET') AND (release_num is null)) AND ( ( :15 = 'PUBLIC') OR ( :16 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :17 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :18 = 'HIERARCHY' AND :19 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :20 , -1) )) ) )OR( release_type = 'BLANKET' AND ( ( :21 = 'PUBLIC') OR ( :22 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :23 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :24 = 'HIERARCHY' AND :25 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIE S POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :26 , -1) )) ) )OR( release_type = 'SCHEDULED' AND ( ( :27 = 'PUBLIC') OR ( :28 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :29 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :30 = 'HIERARCHY' AND :31 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :32 , -1) )) ) )OR (:33 = 'Y')) AND -1=-1 and (po_line_locations_inq_v.owning_org_id = decode(po_line_locations_inq_v.global_agreement_flag, 'Y', po_line_locations_inq_v.owning_org_id, 204) ) and (RELEASE_TYPE IS NULL) and (PO_HEADER_ID=:34) and (PO_LINE_ID=:35) order by po_header_id desc, release_num desc, line_num, shipment_num
38kpqs2vdwfh9 update pay_person_latest_balances set assignment_action_id=:b1, value=:b2, expired_assignment_action_id=:b3, expired_value=:b4, prev_assignment_action_id=:b5, prev_balance_value=:b6 where rowid=:b7
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3dssuqfjsynrk SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) )
4sqqnd7uvn7xg select /*+ ORDERED USE_NL(ACT EE ET EEV) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK, EE PAY_ELEMENT_ENTRIES_F_N50, ET PAY_ELEMENT_TYPES_F_PK, EEV PAY_ELEMENT_ENTRY_VALUES_F_N50) +*/ EE.entry_type , to_char(EE.element_entry_id) , decode(:b0, 'T', decode(EE.entry_type, 'R', to_char(EE.target_entry_id), 'A', to_char(EE.target_entry_id), to_char(EE.original_entry_id)), to_char(EE.original_entry_id)) , EE.element_link_id , to_char(EE.target_entry_id) , EE.subpriority , ET.element_type_id , ET.processing_priority , ET.processing_type , EEV.input_value_id , EEV.screen_entry_value , to_char(null ) , to_char(null ) , 0 , to_char(null ) , to_char(null ) , decode(EE.entry_type, 'S', 1, 'E', 2, 'R', 2, 'A', 2, 'D', 3) , nvl(EE.target_entry_id, EE.element_entry_id) , decode(EE.entry_type, 'E', 2, 1) , to_char(EE.effective_start_date, :b1) , to_char(EE.effective_end_date, :b1) , ET.proration_group_id , pay_retro_pkg.is_retro_entry(EE.creator_type) , to_char(null ) , 'RECALC_NON_RETRO' , 'E' , PEPD.tax_unit_id from pay_assignment_actions ACT , pay_element_entries_f EE , pay_element_types_f ET , pay_element_entry_values_f EEV , pay_entry_process_details PEPD where ((((((((((((((((ACT.assignment_action_id=:b3 and EE.assignment_id=:b4) and ((:b5='N' and to_date(:b6, :b1) between EE.effective_start_date and EE.effective_end_date) or ((:b5='Y' and EE.effective_start_date<=to_date(:b6, :b1)) and EE.effective_end_date>=decode(ET.proration_group_id, null , to_date(:b6, :b1), pay_interprete r_pkg.prorate_start_date(:b3, ET.proration_group_id))))) and EE.element_type_id=ET.element_type_id) and EE.element_entry_id=PEPD.element_entry_id(+)) and to_date(:b6, :b1) between ET.effective_start_date and ET.effective_end_date) and EEV.element_entry_id(+)=EE.element_entry_id) and EEV.screen_entry_value(+) is not null ) and EE.effective_start_date=EEV.effective_start_date(+)) and EE.effective_end_date=EEV.effective_end_date(+)) and EE.entry_type<>'B') and ET.process_in_run_flag<>'N') and ((:b5='N' or ET.proration_group_id is null ) or (:b5='Y' and exists (select '' from pay_payroll_actions ppa , per_time_periods ptp , pay_element_entries_f pee where (((((pee.element_entry_id=EE.element_entry_id and ppa.payroll_action_id=ACT.payroll_action_id) and ppa.payroll_id=ptp.payroll_id) and to_date(:b6, :b1) between ptp.start_date and ptp.end_date) and pee.effective_start_date<=ptp.end_date) and pee.effective_end_date>=ptp.start_date))))) and not (ACT.action_status='B' and EE.creator_type='P')) and not (ACT.action_status='B' and EE.creator_type='R')) and ( not (ACT.action_status='B' and EE.creator_type in ('RR', 'EE')) or (((ACT.action_status='B' and EE.creator_type in ('RR', 'EE')) and pay_retro_pkg.process_retro_value(EE.element_entry_id, ET.element_type_id, :b20:b21, :b22:b23)='Y') and exists (select '' from pay_assignment_actions paa where (paa.assignment_action_id=EE.creator_id and paa.action_sequence<ACT.action_sequence))))) and ((((ET.processing_type= 'N' or EE.entry_type='D') and nvl(EE.date_earned, to_date('01/01/0001', 'DD/MM/YYYY'))<=to_date(:b6, :b1)) and not exists (select '' from pay_run_results prr where (((prr.source_id=EE.element_entry_id and prr.source_type='E') and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or ((ET.processing_type<>'N' and EE.entry_type<>'D') and ((nvl(ET.once_each_period_flag, 'N')='Y' and not exists (select '' from pay_run_results prr , pay_assignment_actions paa , pay_payroll_actions ppa , per_time_periods ptp , per_time_periods ptp1 , pay_payroll_actions ppa1 where (((((((((((prr.source_id=EE.element_entry_id and prr.source_type='E') and paa.assignment_action_id=prr.assignment_action_id) and ppa.payroll_action_id=paa.payroll_action_id) and ptp.payroll_id=ppa.payroll_id) and ppa.date_earned between ptp.start_date and ptp.end_date) and ppa1.payroll_action_id=ACT.payroll_action_id) and ptp1.payroll_id=ppa1.payroll_id) and ppa1.date_earned between ptp1.start_date and ptp1.end_date) and ptp.time_period_id=ptp1.time_period_id) and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or nvl(ET.once_each_period_flag, 'N')='N')))) order by 8 asc , 6 asc , 7 asc , 17 asc , 18 asc , 19 asc , 20 asc
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
608c0n36kaw62 begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
63t8zpm02skgh SELECT DECODE(COUNT(PRR.RUN_RESULT_ID), 0, 'N', 'Y') FROM PAY_RUN_RESULTS PRR, PAY_ASSIGNMENT_ACTIONS ASA, PAY_PAYROLL_ACTIONS PPA WHERE PRR.SOURCE_ID = :B3 AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.STATUS IN ('P', 'PA', 'R', 'O') AND ASA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PPA.PAYROLL_ACTION_ID = ASA.PAYROLL_ACTION_ID AND NOT EXISTS (SELECT NULL FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.SOURCE_ID = PRR.RUN_RESULT_ID AND PRR2.SOURCE_TYPE IN ('R', 'V')) AND PPA.DATE_EARNED BETWEEN :B2 AND :B1
64qc329wgjv39 select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6cjfxb1c4kx16 SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, HIERARCHY_TYPE FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = UPPER(:B1 ) AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
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;
6ubqcscr1gk1b select name, value from icx_session_attributes where session_id = :1
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;
821fx90awyvj7 SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRIBUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
827gtfny5uagb begin :con := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); end;
8c8cf4vtv4tx2 SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age )
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;
8jb36w62w5hqf BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
8q8zmrwmrccz4 SELECT /*+ ORDERED USE_NL(adj qplh) */ ADJ.LIST_LINE_ID CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , ADJ.PRICE_ADJUSTMENT_ID LINE_DETAIL_INDEX , ADJ.LIST_LINE_TYPE_CODE CREATED_FROM_LIST_LINE_TYPE , ADJ.LIST_HEADER_ID CREATED_FROM_LIST_HEADER_ID , ADJ.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , ADJ.RANGE_BREAK_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , ADJ.AUTOMATIC_FLAG , ADJ.UPDATE_ALLOWED OVERRIDE_FLAG , ADJ.PRICING_GROUP_SEQUENCE , ADJ.ARITHMETIC_OPERATOR OPERAND_CALCULATION_CODE , NVL(ADJ.OPERAND_PER_PQTY, ADJ.OPERAND) OPERAND_VALUE , ADJ.ADJUSTED_AMOUNT_PER_PQTY ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , ADJ.ACCRUAL_FLAG , NVL(ADJ.UPDATED_FLAG, :B16 ) , 'N' PROCESS_CODE , 'N' PRICING_STATUS_CODE , ' ' PRICING_STATUS_TEXT , ADJ.PRICE_BREAK_TYPE_CODE , ADJ.CHARGE_TYPE_CODE , ADJ.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , ADJ.PRICING_PHASE_ID , '' CREATED_FROM_LIST_TYPE_CODE , '' LIMIT_CODE , '' LIMIT_TEXT , ADJ.LIST_LINE_NO , ADJ.MODIFIER_LEVEL_CODE , ADJ.RANGE_BREAK_QUANTITY GROUP_QUANTITY , ADJ.RANGE_BREAK_QUANTITY GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B15 IS_LDET_REC , LINE.LINE_TYPE_CODE , NULL NET_AMOUNT_FLAG , NULL CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LI NE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , NULL LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE, OE_PRICE_ADJUSTMENTS ADJ, QP_LIST_HEADERS_B QPLH WHERE :B14 = :B7 AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND ADJ.LINE_ID = LINE.LINE_ID AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.LINE_TYPE_CODE = :B4 AND LINE.UNIT_PRICE IS NOT NULL AND (ADJ.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR (:B5 IS NULL AND ADJ.UPDATED_FLAG IS NULL) OR ADJ.PRICING_PHASE_ID NOT IN (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT_EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND ADJ.MODIFIER_LEVEL_CODE IN (:B4 , :B3 ) AND QPLH.LIST_HEADER_ID = ADJ.LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) AND NOT EXISTS (SELECT 'x' FROM OE_PRICE_ADJ_ASSOCS A, O E_PRICE_ADJUSTMENTS B WHERE A.RLTD_PRICE_ADJ_ID = ADJ.PRICE_ADJUSTMENT_ID AND B.PRICE_ADJUSTMENT_ID = A.PRICE_ADJUSTMENT_ID AND B.LIST_LINE_TYPE_CODE = :B18 ) UNION SELECT /*+ ORDERED USE_NL(adj line qplh) */ ADJ.LIST_LINE_ID CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , ADJ.PRICE_ADJUSTMENT_ID LINE_DETAIL_INDEX , ADJ.LIST_LINE_TYPE_CODE CREATED_FROM_LIST_LINE_TYPE , ADJ.LIST_HEADER_ID CREATED_FROM_LIST_HEADER_ID , ADJ.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , ADJ.RANGE_BREAK_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , ADJ.AUTOMATIC_FLAG , ADJ.UPDATE_ALLOWED OVERRIDE_FLAG , ADJ.PRICING_GROUP_SEQUENCE , ADJ.ARITHMETIC_OPERATOR OPERAND_CALCULATION_CODE , NVL(ADJ.OPERAND_PER_PQTY, ADJ.OPERAND) OPERAND_VALUE , ADJ.ADJUSTED_AMOUNT_PER_PQTY ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , ADJ.ACCRUAL_FLAG , NVL(ADJ.UPDATED_FLAG, :B16 ) , 'N' PROCESS_CODE , 'N' PRICING_STATUS_CODE , ' ' PRICING_STATUS_TEXT , ADJ.PRICE_BREAK_TYPE_CODE , ADJ.CHARGE_TYPE_CODE , ADJ.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , ADJ.PRICING_PHASE_ID , '' CREATED_FROM_LIST_TYPE_CODE , '' LIMIT_CODE , '' LIMIT_TEXT , ADJ.LIST_LINE_NO , ADJ.MODIFIER_LEVEL_CODE , ADJ.RANGE_BREAK_QUANTITY GROUP_QUANTITY , ADJ.RANGE_BREAK_QUANTITY GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICI NG_STATUS_CODE , :B20 IS_LDET_REC , LINE.LINE_TYPE_CODE , NULL NET_AMOUNT_FLAG , NULL CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , NULL LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE1, OE_PRICE_ADJUSTMENTS ADJ , QP_NPREQ_LINES_TMP LINE, QP_LIST_HEADERS_B QPLH WHERE :B14 = :B7 AND LINE1.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE1.LINE_ID = ADJ.HEADER_ID AND LINE1.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.LINE_TYPE_CODE = :B19 AND (LINE1.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE1.PROCESSED_CODE, '0') = :B8 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND (LINE.UNIT_PRICE IS NOT NULL OR LINE.LINE_TYPE_CODE = :B19 ) AND (ADJ.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR (:B5 IS NULL AND ADJ.UPDATED_FLAG IS NULL) OR ADJ.PRICING_PHASE_ID NOT IN (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT_EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_ PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND ADJ.MODIFIER_LEVEL_CODE = :B19 AND ADJ.LINE_ID IS NULL AND QPLH.LIST_HEADER_ID = ADJ.LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) UNION SELECT /*+ ORDERED USE_NL(ldet) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LE VEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B23 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE, QP_NPREQ_LDETS_TMP LDET WHERE LINE.LINE_INDEX = LDET.LINE_INDEX AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.LINE_TYPE_CODE = :B4 AND LINE.UNIT_PRICE IS NOT NULL AND LDET.PRICING_STATUS_CODE IN (:B13 , :B12 ) AND (LDET.APPLIED_FLAG = :B7 OR (LDET.APPLIED_FLAG = :B16 AND LDET.CREATED_FROM_LIST_LINE_TYPE = :B22 AND LDET.AUTOMATIC_FLAG = :B16 )) AND LDET.CREATED_FROM_LIST_TYPE_CODE NOT IN (:B2 , :B1 ) AND LDET.MODIFIER_LEVEL_CODE IN (:B4 , :B3 ) AND NVL(LDET.LINE_DETAIL_TYPE_CODE, 'NULL') <> :B21 UNION SELECT /*+ ORDERED USE_NL(ldet line) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LEVEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B24 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE1, QP_NPREQ_LDETS_TMP LDET , QP_NPREQ_LINES_TMP LINE WHERE LDET.LINE_INDEX = LINE1.LINE_INDEX AND LINE1.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD '||:B10 ) AND LINE1.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.PRICE_FLAG IN (:B7 , :B9 ) AND LINE1.LINE_TYPE_CODE = :B19 AND (LINE.UNIT_PRICE IS NOT NULL OR LINE.LINE_TYPE_CODE = :B19 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LDET.PRICING_STATUS_CODE IN (:B13 , :B12 ) AND (LDET.APPLIED_FLAG = :B7 OR (LDET.APPLIED_FLAG = :B16 AND LDET.CREATED_FROM_LIST_LINE_TYPE = :B22 AND LDET.AUTOMATIC_FLAG = :B16 )) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LDET.MODIFIER_LEVEL_CODE = :B19 AND LDET.CREATED_FROM_LIST_TYPE_CODE NOT IN (:B2 , :B1 ) UNION SELECT /*+ ORDERED USE_NL(ldet qplh) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CH ARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LEVEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B25 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE, QP_NPREQ_LDETS_TMP LDET, QP_LIST_HEADERS_B QPLH WHERE NVL(:B14 , :B16 ) <> :B7 AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.LINE_TYPE_CODE = :B4 AND LINE.UNIT_PRICE IS NOT NULL AND LDET.LINE_INDEX = LINE.LINE_INDEX AND LDET.PRICING_STATUS_CODE = :B10 AND (LDET.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR LDET.PRICING_PHASE_ID NOT IN (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT _EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND LDET.MODIFIER_LEVEL_CODE IN (:B4 , :B3 ) AND QPLH.LIST_HEADER_ID = LDET.CREATED_FROM_LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) AND NVL(LDET.LINE_DETAIL_TYPE_CODE, 'NULL') <> :B21 UNION SELECT /*+ ORDERED USE_NL(ldet line qplh) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CHARGE_SU BTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LEVEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B26 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE1, QP_NPREQ_LDETS_TMP LDET , QP_NPREQ_LINES_TMP LINE, QP_LIST_HEADERS_B QPLH WHERE NVL(:B14 , :B16 ) <> :B7 AND LINE1.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE1.LINE_TYPE_CODE = :B19 AND (LINE1.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE1.PROCESSED_CODE, '0') = :B8 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND (LINE.UNIT_PRICE IS NOT NULL OR LINE.LINE_TYPE_CODE = :B19 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.LINE_INDEX = LDET.LINE_INDEX AND LDET.PRICING_STATUS_CODE = :B10 AND (LDET.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR LDET.PRICING_PHASE_ID NOT I N (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT_EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND LDET.MODIFIER_LEVEL_CODE = :B19 AND QPLH.LIST_HEADER_ID = LDET.CREATED_FROM_LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) ORDER BY PRICING_GROUP_SEQUENCE, LINE_IND, IS_LDET_REC
9wdrypwkpf607 begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4 BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
avc1jqzz04wpr SELECT 'x' FROM DUAL
bf7uwg5pa3pj6 begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bp8crdjba8zgt update ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b4)
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
c4y7jp0q2awbf SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1
cd9mbmqyf4qhp UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
csvvv0fmhr1yc BEGIN FFP1893_01010001.FORMULA( :N1, :N4, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N3, :T4, :I4, :N2, :N5, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
cwyx16zn1hpfb select parameter, value from nls_session_parameters
dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
dzt4ys8ynkyrj INSERT INTO CS_INCIDENTS_AUDIT_B ( INCIDENT_AUDIT_ID , INCIDENT_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , CREATION_TIME , INCIDENT_STATUS_ID , OLD_INCIDENT_STATUS_ID , CHANGE_INCIDENT_STATUS_FLAG , INCIDENT_TYPE_ID , OLD_INCIDENT_TYPE_ID , CHANGE_INCIDENT_TYPE_FLAG , INCIDENT_URGENCY_ID , OLD_INCIDENT_URGENCY_ID , CHANGE_INCIDENT_URGENCY_FLAG , INCIDENT_SEVERITY_ID , OLD_INCIDENT_SEVERITY_ID , CHANGE_INCIDENT_SEVERITY_FLAG, INCIDENT_OWNER_ID , OLD_INCIDENT_OWNER_ID , CHANGE_INCIDENT_OWNER_FLAG , CREATE_MANUAL_ACTION , ACTION_ID , EXPECTED_RESOLUTION_DATE , OLD_EXPECTED_RESOLUTION_DATE , CHANGE_RESOLUTION_FLAG , NEW_WORKFLOW_FLAG , WORKFLOW_PROCESS_NAME , WORKFLOW_PROCESS_ITEMKEY , GROUP_ID, OLD_GROUP_ID, CHANGE_GROUP_FLAG, GROUP_TYPE, OLD_GROUP_TYPE, CHANGE_GROUP_TYPE_FLAG, INV_PLATFORM_ORG_ID, OLD_INV_PLATFORM_ORG_ID, CHANGE_PLATFORM_ORG_ID_FLAG, OWNER_ASSIGNED_TIME, OLD_OWNER_ASSIGNED_TIME, CHANGE_ASSIGNED_TIME_FLAG, OBLIGATION_DATE, OLD_OBLIGATION_DATE, CHANGE_OBLIGATION_FLAG, SITE_ID, OLD_SITE_ID, CHANGE_SITE_FLAG, BILL_TO_CONTACT_ID, OLD_BILL_TO_CONTACT_ID, CHANGE_BILL_TO_FLAG, SHIP_TO_CONTACT_ID, OLD_SHIP_TO_CONTACT_ID, CHANGE_SHIP_TO_FLAG, CLOSE_DATE, OLD_CLOSE_DATE, CHANGE_CLOSE_DATE_FLAG, CUSTOMER_PRODUCT_ID, OLD_CUSTOMER_PRODUCT_ID, CHANGE_CUSTOMER_PRODUCT_FLAG, PLATFORM_ID, OLD_PLATFORM_ID, CHANGE_PLATFORM_ID_FLAG, PRODUCT_REVISION, OLD_PRODUCT_REVISION , CHANGE_PRODUCT_REVISION_FLAG, COMPONENT_VERSION, OLD_COMPONENT_VERSION, CHANGE_COMP_VER_FLAG, SUBCOMPONENT_VERSION, OLD_SUBCOMPONENT_VERSION, CHANGE_SUBCOMP_VER_FLAG, CP_COMPONENT_ID, OLD_CP_COMPONENT_ID, CHANGE_CP_COMPONENT_ID_FLAG, CP_COMPONENT_VERSION_ID, OLD_CP_COMPONENT_VERSION_ID, CHANGE_CP_COMP_VER_ID_FLAG, CP_SUBCOMPONENT_ID, OLD_CP_SUBCOMPONENT_ID, CHANGE_CP_SUBCOMPONENT_ID_FLAG, CP_SUBCOMPONENT_VERSION_ID, OLD_CP_SUBCOMPONENT_VERSION_ID, CHANGE_CP_SUBCOMP_VER_ID_FLAG, CP_REVISION_ID, OLD_CP_REVISION_ID, CHANGE_CP_REVISION_ID_FLAG, INV_ITEM_REVISION, OLD_INV_ITEM_REVISION, CHANGE_INV_ITEM_REVISION, INV_COMPONENT_ID, OLD_INV_COMPONENT_ID, CHANGE_INV_COMPONENT_ID, INV_COMPONENT_VERSION, OLD_INV_COMPONENT_VERSION, CHANGE_INV_COMPONENT_VERSION, INV_SUBCOMPONENT_ID, OLD_INV_SUBCOMPONENT_ID, CHANGE_INV_SUBCOMPONENT_ID, INV_SUBCOMPONENT_VERSION, OLD_INV_SUBCOMPONENT_VERSION, CHANGE_INV_SUBCOMP_VERSION, TERRITORY_ID, OLD_TERRITORY_ID, CHANGE_TERRITORY_ID_FLAG, RESOURCE_TYPE, OLD_RESOURCE_TYPE, CHANGE_RESOURCE_TYPE_FLAG, OBJECT_VERSION_NUMBER, AUDIT_FIELD, INVENTORY_ITEM_ID , OLD_INVENTORY_ITEM_ID, CHANGE_INVENTORY_ITEM_FLAG, INV_ORGANIZATION_ID, OLD_INV_ORGANIZATION_ID, CHANGE_INV_ORGANIZATION_FLAG, STATUS_FLAG , OLD_STATUS_FLAG , CHANGE_STATUS_FLAG , INCIDENT_DATE, OLD_INCIDENT_DATE, CHANGE_INCIDENT_DATE_FLAG, PLATFORM_VERSION_ID, OLD_PLATFORM_VERSION_ID, CHANGE_PLAT_VER_ID_FLAG, LANGUAGE_ID, OLD_LANGUAGE_ID, CHANGE_LANGUAGE_ID_FLAG, UPGRADE_FLAG_FOR_CREATE , OLD_INCIDENT_NUMBER , INCIDENT_NUMBER , OLD_CUSTOMER_ID , CUSTOMER_ID , OLD_BILL_TO_SITE_USE_ID , BILL_TO_SITE_USE_ID , OLD_EMPLOYEE_ID , EMPLOYEE_ID , OLD_SHIP_TO_SITE_USE_ID , SHIP_TO_SITE_USE_ID , OLD_PROBLEM_CODE , PROBLEM_CODE , OLD_ACTUAL_RESOLUTION_DATE , ACTUAL_RESOLUTION_DATE , OLD_INSTALL_SITE_USE_ID , INSTALL_SITE_USE_ID , OLD_CURRENT_SERIAL_NUMBER , CURRENT_SERIAL_NUMBER , OLD_SYSTEM_ID , SYSTEM_ID , OLD_INCIDENT_ATTRIBUTE_1 , INCIDENT_ATTRIBUTE_1 , OLD_INCIDENT_ATTRIBUTE_2 , INCIDENT_ATTRIBUTE_2 , OLD_INCIDENT_ATTRIBUTE_3 , INCIDENT_ATTRIBUTE_3 , OLD_INCIDENT_ATTRIBUTE_4 , INCIDENT_ATTRIBUTE_4 , OLD_INCIDENT_ATTRIBUTE_5 , INCIDENT_ATTRIBUTE_5 , OLD_INCIDENT_ATTRIBUTE_6 , INCIDENT_ATTRIBUTE_6 , OLD_INCIDENT_ATTRIBUTE_7 , INCIDENT_ATTRIBUTE_7 , OLD_INCIDENT_ATTRIBUTE_8 , INCIDENT_ATTRIBUTE_8 , OLD_INCIDENT_ATTRIBUTE_9 , INCIDENT_ATTRIBUTE_9 , OLD_INCIDENT_ATTRIBUTE_10 , INCIDENT_ATTRIBUTE_10 , OLD_INCIDENT_ATTRIBUTE_11 , INCIDENT_ATTRIBUTE_11 , OLD_INCIDENT_ATTRIBUTE_12 , INCIDENT_ATTRIBUTE_12 , OLD_INCIDENT_ATTRIBUTE_13 , INCIDENT_ATTRIBUTE_13 , OLD_INCIDENT_ATTRIBUTE_14 , INCIDENT_ATTRIBUTE_14 , OLD_INCIDENT_ATTRIBUTE_15 , INCIDENT_ATTRIBUTE_15 , OLD_INCIDENT_CONTEXT , INCIDENT_CONTEXT , OLD_RESOLUTION_CODE , RESOLUTION_CODE , OLD_ORIGINAL_ORDER_NUMBER , ORIGINAL_ORDER_NUMBER , OLD_ORG_ID , ORG_ID , OLD_PURCHASE_ORDER_NUMBER , PURCHASE_ORDER_NUMBER , O LD_PUBLISH_FLAG , PUBLISH_FLAG , OLD_QA_COLLECTION_ID , QA_COLLECTION_ID , OLD_CONTRACT_ID , CONTRACT_ID , OLD_CONTRACT_NUMBER , CONTRACT_NUMBER , OLD_CONTRACT_SERVICE_ID , CONTRACT_SERVICE_ID , OLD_TIME_ZONE_ID , TIME_ZONE_ID , OLD_ACCOUNT_ID , ACCOUNT_ID , OLD_TIME_DIFFERENCE , TIME_DIFFERENCE , OLD_CUSTOMER_PO_NUMBER , CUSTOMER_PO_NUMBER , OLD_CUSTOMER_TICKET_NUMBER , CUSTOMER_TICKET_NUMBER , OLD_CUSTOMER_SITE_ID , CUSTOMER_SITE_ID , OLD_CALLER_TYPE , CALLER_TYPE , OLD_SECURITY_GROUP_ID , OLD_ORIG_SYSTEM_REFERENCE , ORIG_SYSTEM_REFERENCE , OLD_ORIG_SYSTEM_REFERENCE_ID , ORIG_SYSTEM_REFERENCE_ID , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , OLD_PROJECT_NUMBER , PROJECT_NUMBER , OLD_PLATFORM_VERSION , PLATFORM_VERSION , OLD_DB_VERSION , DB_VERSION , OLD_CUST_PREF_LANG_ID , CUST_PREF_LANG_ID , OLD_TIER , TIER , OLD_CATEGORY_ID , CATEGORY_ID , OLD_OPERATING_SYSTEM , OPERATING_SYSTEM , OLD_OPERATING_SYSTEM_VERSION , OPERATING_SYSTEM_VERSION , OLD_DATABASE , DATABASE , OLD_GROUP_TERRITORY_ID , GROUP_TERRITORY_ID , OLD_COMM_PREF_CODE , COMM_PREF_CODE , OLD_LAST_UPDATE_CHANNEL , LAST_UPDATE_CHANNEL , OLD_CUST_PREF_LANG_CODE , CUST_PREF_LANG_CODE , OLD_ERROR_CODE , ERROR_CODE , OLD_CATEGORY_SET_ID , CATEGORY_SET_ID , OLD_EXTERNAL_REFERENCE , EXTERNAL_REFERENCE , OLD_INCIDENT_OCCURRED_DATE , INCIDENT_OCCURRED_DATE , OLD_INCIDENT_RESOLVED_DATE , INCIDENT_RESOLVED_DATE , OLD_INC_RESPONDED _BY_DATE , INC_RESPONDED_BY_DATE , OLD_INCIDENT_LOCATION_ID , INCIDENT_LOCATION_ID , OLD_INCIDENT_ADDRESS , INCIDENT_ADDRESS , OLD_INCIDENT_CITY , INCIDENT_CITY , OLD_INCIDENT_STATE , INCIDENT_STATE , OLD_INCIDENT_COUNTRY , INCIDENT_COUNTRY , OLD_INCIDENT_PROVINCE , INCIDENT_PROVINCE , OLD_INCIDENT_POSTAL_CODE , INCIDENT_POSTAL_CODE , OLD_INCIDENT_COUNTY , INCIDENT_COUNTY , OLD_SR_CREATION_CHANNEL , SR_CREATION_CHANNEL , OLD_DEF_DEFECT_ID , DEF_DEFECT_ID , OLD_DEF_DEFECT_ID2 , DEF_DEFECT_ID2 , OLD_EXTERNAL_ATTRIBUTE_1 , EXTERNAL_ATTRIBUTE_1 , OLD_EXTERNAL_ATTRIBUTE_2 , EXTERNAL_ATTRIBUTE_2 , OLD_EXTERNAL_ATTRIBUTE_3 , EXTERNAL_ATTRIBUTE_3 , OLD_EXTERNAL_ATTRIBUTE_4 , EXTERNAL_ATTRIBUTE_4 , OLD_EXTERNAL_ATTRIBUTE_5 , EXTERNAL_ATTRIBUTE_5 , OLD_EXTERNAL_ATTRIBUTE_6 , EXTERNAL_ATTRIBUTE_6 , OLD_EXTERNAL_ATTRIBUTE_7 , EXTERNAL_ATTRIBUTE_7 , OLD_EXTERNAL_ATTRIBUTE_8 , EXTERNAL_ATTRIBUTE_8 , OLD_EXTERNAL_ATTRIBUTE_9 , EXTERNAL_ATTRIBUTE_9 , OLD_EXTERNAL_ATTRIBUTE_10 , EXTERNAL_ATTRIBUTE_10 , OLD_EXTERNAL_ATTRIBUTE_11 , EXTERNAL_ATTRIBUTE_11 , OLD_EXTERNAL_ATTRIBUTE_12 , EXTERNAL_ATTRIBUTE_12 , OLD_EXTERNAL_ATTRIBUTE_13 , EXTERNAL_ATTRIBUTE_13 , OLD_EXTERNAL_ATTRIBUTE_14 , EXTERNAL_ATTRIBUTE_14 , OLD_EXTERNAL_ATTRIBUTE_15 , EXTERNAL_ATTRIBUTE_15 , OLD_EXTERNAL_CONTEXT , EXTERNAL_CONTEXT , OLD_LAST_UPDATE_PROGRAM_CODE , LAST_UPDATE_PROGRAM_CODE , OLD_CREATION_PROGRAM_CODE , CREATION_PROGRAM_CODE , OLD_COVERAGE_TYPE , COVERA GE_TYPE , OLD_BILL_TO_ACCOUNT_ID , BILL_TO_ACCOUNT_ID , OLD_SHIP_TO_ACCOUNT_ID , SHIP_TO_ACCOUNT_ID , OLD_CUSTOMER_EMAIL_ID , CUSTOMER_EMAIL_ID , OLD_CUSTOMER_PHONE_ID , CUSTOMER_PHONE_ID , OLD_BILL_TO_PARTY_ID , BILL_TO_PARTY_ID , OLD_SHIP_TO_PARTY_ID , SHIP_TO_PARTY_ID , OLD_BILL_TO_SITE_ID , BILL_TO_SITE_ID , OLD_SHIP_TO_SITE_ID , SHIP_TO_SITE_ID , OLD_PROGRAM_LOGIN_ID , PROGRAM_LOGIN_ID , OLD_INCIDENT_POINT_OF_INTEREST , INCIDENT_POINT_OF_INTEREST , OLD_INCIDENT_CROSS_STREET , INCIDENT_CROSS_STREET , OLD_INCIDENT_DIRECTION_QUALIF , INCIDENT_DIRECTION_QUALIF , OLD_INCIDENT_DISTANCE_QUALIF , INCIDENT_DISTANCE_QUALIF , OLD_INCIDENT_DISTANCE_QUAL_UOM , INCIDENT_DISTANCE_QUAL_UOM , OLD_INCIDENT_ADDRESS2 , INCIDENT_ADDRESS2 , OLD_INCIDENT_ADDRESS3 , INCIDENT_ADDRESS3 , OLD_INCIDENT_ADDRESS4 , INCIDENT_ADDRESS4 , OLD_INCIDENT_ADDRESS_STYLE , INCIDENT_ADDRESS_STYLE , OLD_INCIDENT_ADDR_LNS_PHONETIC , INCIDENT_ADDR_LNS_PHONETIC , OLD_INCIDENT_PO_BOX_NUMBER , INCIDENT_PO_BOX_NUMBER , OLD_INCIDENT_HOUSE_NUMBER , INCIDENT_HOUSE_NUMBER , OLD_INCIDENT_STREET_SUFFIX , INCIDENT_STREET_SUFFIX , OLD_INCIDENT_STREET , INCIDENT_STREET , OLD_INCIDENT_STREET_NUMBER , INCIDENT_STREET_NUMBER , OLD_INCIDENT_FLOOR , INCIDENT_FLOOR , OLD_INCIDENT_SUITE , INCIDENT_SUITE , OLD_INCIDENT_POSTAL_PLUS4_CODE , INCIDENT_POSTAL_PLUS4_CODE , OLD_INCIDENT_POSITION , INCIDENT_POSITION , OLD_INCIDENT_LOC_DIRECTIONS , INCIDENT_LOC_DIRECTIONS , OLD_INCIDEN T_LOC_DESCRIPTION , INCIDENT_LOC_DESCRIPTION , OLD_INSTALL_SITE_ID , INSTALL_SITE_ID , INCIDENT_LAST_MODIFIED_DATE , UPDATED_ENTITY_CODE , UPDATED_ENTITY_ID , ENTITY_ACTIVITY_CODE , OLD_TIER_VERSION , TIER_VERSION , OLD_INC_OBJECT_VERSION_NUMBER , INC_OBJECT_VERSION_NUMBER , OLD_INC_REQUEST_ID , INC_REQUEST_ID , OLD_INC_PROGRAM_APPLICATION_ID , INC_PROGRAM_APPLICATION_ID , OLD_INC_PROGRAM_ID , INC_PROGRAM_ID , OLD_INC_PROGRAM_UPDATE_DATE , INC_PROGRAM_UPDATE_DATE , OLD_OWNING_DEPARTMENT_ID , OWNING_DEPARTMENT_ID , OLD_ITEM_SERIAL_NUMBER , ITEM_SERIAL_NUMBER , OLD_INCIDENT_LOCATION_TYPE , INCIDENT_LOCATION_TYPE , OLD_UNASSIGNED_INDICATOR , UNASSIGNED_INDICATOR ) VALUES( :B403 , :B402 , :B401 , :B400 , :B401 , :B400 , :B399 , TO_CHAR(:B398 , 'HH24:MI:SS'), :B397 , :B396 , :B395 , :B394 , :B393 , :B392 , :B391 , :B390 , :B389 , :B388 , :B387 , :B386 , :B385 , :B384 , :B383 , :B382 , :B381 , :B380 , :B379 , :B378 , :B377 , :B376 , :B375 , :B374 , :B373 , :B372 , :B371 , :B370 , :B369 , :B368 , :B367 , :B366 , :B365 , :B364 , :B363 , :B362 , :B361 , :B360 , :B359 , :B358 , :B357 , :B356 , :B355 , :B354 , :B353 , :B352 , :B351 , :B350 , :B349 , :B348 , :B347 , :B346 , :B345 , :B344 , :B343 , :B342 , :B341 , :B340 , :B339 , :B338 , :B337 , :B336 , :B335 , :B334 , :B333 , :B332 , :B331 , :B330 , :B329 , :B328 , :B327 , :B326 , :B325 , :B324 , :B323 , :B322 , :B321 , :B320 , :B319 , :B318 , :B317 , :B316 , :B315 , :B314 , :B313 , :B312 , :B311 , :B310 , :B309 , :B308 , :B307 , :B306 , :B305 , :B304 , :B303 , :B302 , :B301 , :B300 , :B299 , :B298 , :B297 , 1, '', :B296 , :B295 , :B294 , :B293 , :B292 , :B291 , :B290 , :B289 , :B288 , :B287 , :B286 , :B285 , :B284 , :B283 , :B282 , :B281 , :B280 , :B279 , :B278 , :B277 , :B276 , :B275 , :B274 , :B273 , :B272 , :B271 , :B270 , :B269 , :B268 , :B267 , :B266 , :B265 , :B264 , :B263 , :B262 , :B261 , :B260 , :B259 , :B258 , :B257 , :B256 , :B255 , :B254 , :B253 , :B252 , :B251 , :B250 , :B249 , :B248 , :B247 , :B246 , :B245 , :B244 , :B243 , :B242 , :B241 , :B240 , :B239 , :B238 , :B237 , :B236 , :B235 , :B234 , :B233 , :B232 , :B231 , :B230 , :B229 , :B228 , :B227 , :B226 , :B225 , :B224 , :B223 , :B222 , :B221 , :B220 , :B219 , :B218 , :B217 , :B216 , :B215 , :B214 , :B213 , :B212 , :B211 , :B210 , :B209 , :B208 , :B207 , :B206 , :B205 , :B204 , :B203 , :B202 , :B201 , :B200 , :B199 , :B198 , :B197 , :B196 , :B195 , :B194 , :B193 , :B192 , :B191 , :B190 , :B189 , :B188 , :B187 , :B186 , :B185 , :B184 , :B183 , :B182 , :B181 , :B180 , :B179 , :B178 , :B177 , :B176 , :B175 , :B174 , :B173 , :B172 , :B171 , :B170 , :B169 , :B168 , :B167 , :B166 , :B165 , :B164 , :B163 , :B162 , :B161 , :B160 , :B159 , :B158 , :B157 , :B156 , :B155 , :B15 4 , :B153 , :B152 , :B151 , :B150 , :B149 , :B148 , :B147 , :B146 , :B145 , :B144 , :B143 , :B142 , :B141 , :B140 , :B139 , :B138 , :B137 , :B136 , :B135 , :B134 , :B133 , :B132 , :B131 , :B130 , :B129 , :B128 , :B127 , :B126 , :B125 , :B124 , :B123 , :B122 , :B121 , :B120 , :B119 , :B118 , :B117 , :B116 , :B115 , :B114 , :B113 , :B112 , :B111 , :B110 , :B109 , :B108 , :B107 , :B106 , :B105 , :B104 , :B103 , :B102 , :B101 , :B100 , :B99 , :B98 , :B97 , :B96 , :B95 , :B94 , :B93 , :B92 , :B91 , :B90 , :B89 , :B88 , :B87 , :B86 , :B85 , :B84 , :B83 , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) RETURNING INCIDENT_AUDIT_ID INTO :O0
fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23 SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
fw8fr3nddyd26 insert into pay_run_balances(run_balance_id, assignment_action_id, assignment_id, action_sequence, defined_balance_id, balance_value, payroll_action_id, effective_date, tax_unit_id, jurisdiction_code, jurisdiction_comp1, jurisdiction_comp2, jurisdiction_comp3, source_id, source_text, tax_group, source_number, source_text2) values (:b1, :b2:b3, :b4:b5, :b6:b7, :b8, :b9, :b10:b11, to_date(:b12, :b13), :b14:b15, :b16:b17, :b18:b19, :b20:b21, :b22:b23, :b24:b25, :b26:b27, :b28:b29, :b30:b31, :b32:b33)
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;
gksvm8wmzk8w0 begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 2,083,207 577.88 1.67
CPU used when call started 2,077,917 576.41 1.66
CR blocks created 16,974,543 4,708.71 13.58
Cached Commit SCN referenced 50,187 13.92 0.04
Commit SCN cached 10 0.00 0.00
DB time 5,423,110 1,504.36 4.34
DBWR checkpoint buffers written 3,068,168 851.10 2.45
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 55,511 15.40 0.04
DBWR revisited being-written buffer 264 0.07 0.00
DBWR thread checkpoint buffers written 533,397 147.96 0.43
DBWR transaction table writes 2,536 0.70 0.00
DBWR undo block writes 1,621,801 449.88 1.30
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 42,203,930 11,707.29 33.76
IMU Flushes 358,480 99.44 0.29
IMU Redo allocation size 2,379,145,636 659,970.73 1,903.07
IMU commits 647,588 179.64 0.52
IMU contention 39,183 10.87 0.03
IMU ktichg flush 11,521 3.20 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,729 0.48 0.00
IMU undo allocation size 5,738,120,424 1,591,744.30 4,589.91
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 53,122 14.74 0.04
PX local messages sent 53,122 14.74 0.04
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 52,051,557 14,439.01 41.64
active txn count during cleanout 127,049,683 35,243.35 101.63
application wait time 23,303 6.46 0.02
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,896 3.85 0.01
branch node splits 1,068 0.30 0.00
buffer is not pinned count 596,300,641 165,412.73 476.98
buffer is pinned count 1,500,435,645 416,218.15 1,200.19
bytes received via SQL*Net from client 11,408,818,410 3,164,785.74 9,125.88
bytes sent via SQL*Net to client 10,329,378,108 2,865,350.94 8,262.44
calls to get snapshot scn: kcmgss 117,961,659 32,722.35 94.36
calls to kcmgas 21,144,780 5,865.52 16.91
calls to kcmgcs 13,758,469 3,816.57 11.01
change write time 46,464 12.89 0.04
cleanout - number of ktugct calls 29,064,350 8,062.40 23.25
cleanouts and rollbacks - consistent read gets 14,796,269 4,104.46 11.84
cleanouts only - consistent read gets 158,387 43.94 0.13
cluster key scan block gets 873,569 242.33 0.70
cluster key scans 241,281 66.93 0.19
commit batch/immediate performed 4,485 1.24 0.00
commit batch/immediate requested 4,485 1.24 0.00
commit cleanout failures: block lost 260,455 72.25 0.21
commit cleanout failures: buffer being written 1,807 0.50 0.00
commit cleanout failures: callback failure 113,047 31.36 0.09
commit cleanout failures: cannot pin 33,293 9.24 0.03
commit cleanouts 9,647,157 2,676.10 7.72
commit cleanouts successfully completed 9,238,555 2,562.76 7.39
commit immediate performed 4,485 1.24 0.00
commit immediate requested 4,485 1.24 0.00
commit txn count during cleanout 1,400,279 388.43 1.12
concurrency wait time 17,097 4.74 0.01
consistent changes 798,316,966 221,451.69 638.57
consistent gets 1,867,858,458 518,140.58 1,494.09
consistent gets - examination 1,314,378,806 364,606.32 1,051.37
consistent gets direct 3 0.00 0.00
consistent gets from cache 1,867,858,418 518,140.57 1,494.09
current blocks converted for CR 11 0.00 0.00
cursor authentications 2,344 0.65 0.00
data blocks consistent reads - undo records applied 793,987,614 220,250.74 635.11
db block changes 201,486,808 55,892.08 161.17
db block gets 227,264,973 63,042.90 181.79
db block gets direct 4,365 1.21 0.00
db block gets from cache 227,260,620 63,041.69 181.79
deferred (CURRENT) block cleanout applications 1,668,740 462.91 1.33
dirty buffers inspected 9,423 2.61 0.01
enqueue conversions 10,427 2.89 0.01
enqueue releases 4,691,348 1,301.37 3.75
enqueue requests 4,698,879 1,303.46 3.76
enqueue timeouts 7,363 2.04 0.01
enqueue waits 34,550 9.58 0.03
exchange deadlocks 28,800 7.99 0.02
execute count 104,925,160 29,106.05 83.93
failed probes on index block reclamation 8,456 2.35 0.01
frame signature mismatch 356 0.10 0.00
free buffer inspected 3,232,820 896.78 2.59
free buffer requested 21,488,215 5,960.79 17.19
heap block compress 35,635,330 9,885.18 28.50
hot buffers moved to head of LRU 1,353,197 375.37 1.08
immediate (CR) block cleanout applications 14,954,660 4,148.40 11.96
immediate (CURRENT) block cleanout applications 1,158,246 321.30 0.93
index crx upgrade (found) 27,411 7.60 0.02
index crx upgrade (positioned) 10,520,751 2,918.44 8.42
index fast full scans (full) 0 0.00 0.00
index fast full scans (rowid ranges) 784 0.22 0.00
index fetch by key 189,050,850 52,442.37 151.22
index scans kdiixs1 130,886,939 36,307.80 104.70
java call heap collected bytes 1,495,042,272 414,722.04 1,195.88
java call heap collected count 18,232,657 5,057.71 14.58
java call heap gc count 4,837 1.34 0.00
java call heap live object count 1,537,727 426.56 1.23
java call heap live object count max 1,536,707 426.28 1.23
java call heap live size 373,321,688 103,558.77 298.62
java call heap live size max 372,984,408 103,465.21 298.35
java call heap object count 3,774,169 1,046.95 3.02
java call heap object count max 3,780,904 1,048.82 3.02
java call heap total size 482,345,984 133,801.91 385.83
java call heap total size max 481,565,696 133,585.46 385.20
java call heap used size 516,451,688 143,262.77 413.11
java call heap used size max 516,772,664 143,351.81 413.36
leaf node 90-10 splits 21,709 6.02 0.02
leaf node splits 247,925 68.77 0.20
lob reads 23,718 6.58 0.02
lob writes 41,532 11.52 0.03
lob writes unaligned 41,532 11.52 0.03
logons cumulative 10,197 2.83 0.01
messages received 2,166,268 600.92 1.73
messages sent 2,166,268 600.92 1.73
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 501,722,499 139,176.92 401.33
opened cursors cumulative 6,055,637 1,679.82 4.84
parse count (failures) 3,616 1.00 0.00
parse count (hard) 9,619 2.67 0.01
parse count (total) 9,276,727 2,573.35 7.42
parse time cpu 48,466 13.44 0.04
parse time elapsed 51,370 14.25 0.04
physical read IO requests 298,414 82.78 0.24
physical read bytes 3,651,149,824 1,012,822.41 2,920.54
physical read total IO requests 328,877 91.23 0.26
physical read total bytes 4,147,535,872 1,150,519.00 3,317.60
physical read total multi block requests 11,988 3.33 0.01
physical reads 445,697 123.64 0.36
physical reads cache 444,342 123.26 0.36
physical reads cache prefetch 146,683 40.69 0.12
physical reads direct 1,355 0.38 0.00
physical reads direct (lob) 3 0.00 0.00
physical reads direct temporary tablespace 620 0.17 0.00
physical reads prefetch warmup 77,633 21.54 0.06
physical write IO requests 1,383,928 383.90 1.11
physical write bytes 25,858,392,064 7,173,071.53 20,684.05
physical write total IO requests 2,675,175 742.09 2.14
physical write total bytes 59,640,054,272 16,544,043.98 47,705.90
physical write total multi block requests 1,475,244 409.23 1.18
physical writes 3,156,542 875.62 2.52
physical writes direct 5,318 1.48 0.00
physical writes direct (lob) 247 0.07 0.00
physical writes direct temporary tablespace 4,662 1.29 0.00
physical writes from cache 3,151,224 874.14 2.52
physical writes non checkpoint 2,370,004 657.43 1.90
pinned buffers inspected 4,198 1.16 0.00
prefetch warmup blocks aged out before use 239,409 66.41 0.19
prefetched blocks aged out before use 3,289 0.91 0.00
process last non-idle time 3,603 1.00 0.00
queries parallelized 48 0.01 0.00
recursive calls 169,726,771 47,081.90 135.76
recursive cpu usage 1,162,061 322.35 0.93
redo blocks written 65,812,958 18,256.40 52.64
redo buffer allocation retries 223 0.06 0.00
redo entries 103,793,112 28,792.02 83.02
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,295,291 359.31 1.04
redo size 32,265,316,292 8,950,340.81 25,808.93
redo subscn max counts 2,414,014 669.64 1.93
redo synch time 80,660 22.37 0.06
redo synch writes 2,426,730 673.17 1.94
redo wastage 328,490,680 91,122.72 262.76
redo write time 40,513 11.24 0.03
redo writer latching time 159 0.04 0.00
redo writes 862,545 239.27 0.69
rollback changes - undo records applied 189,191 52.48 0.15
rollbacks only - consistent read gets 2,347,569 651.21 1.88
rows fetched via callback 99,689,111 27,653.58 79.74
session connect time 0 0.00 0.00
session cursor cache hits 5,785,912 1,605.00 4.63
session logical reads 2,095,123,845 581,183.59 1,675.88
session pga memory 11,071,607,096 3,071,243.93 8,856.15
session pga memory max 12,272,403,480 3,404,342.69 9,816.66
session uga memory ############### 75,302,983.54 217,141.38
session uga memory max 75,086,978,064 20,828,992.90 60,061.85
shared hash latch upgrades - no wait 32,849,094 9,112.28 26.28
shared hash latch upgrades - wait 42,480 11.78 0.03
sorts (memory) 11,032,598 3,060.42 8.82
sorts (rows) 137,167,670 38,050.07 109.72
sql area evicted 2,527 0.70 0.00
sql area purged 3,786 1.05 0.00
summed dirty queue length 629,350 174.58 0.50
switch current to new buffer 1,392,986 386.41 1.11
table fetch by rowid 897,988,993 249,100.53 718.30
table fetch continued row 33,582,156 9,315.63 26.86
table scan blocks gotten 108,820,107 30,186.50 87.04
table scan rows gotten 8,686,380,095 2,409,586.24 6,948.21
table scans (long tables) 2,047 0.57 0.00
table scans (rowid ranges) 2,045 0.57 0.00
table scans (short tables) 6,226,240 1,727.15 4.98
total number of times SMON posted 151,233 41.95 0.12
transaction rollbacks 4,485 1.24 0.00
transaction tables consistent read rollbacks 73 0.02 0.00
transaction tables consistent reads - undo records applied 6,802 1.89 0.01
undo change vector size 11,290,665,180 3,132,010.25 9,031.37
user I/O wait time 110,364 30.61 0.09
user calls 49,699,495 13,786.55 39.75
user commits 985,231 273.30 0.79
user rollbacks 264,930 73.49 0.21
workarea executions - onepass 4 0.00 0.00
workarea executions - optimal 6,626,786 1,838.26 5.30
write clones created in background 1,598 0.44 0.00
write clones created in foreground 6,956 1.93 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 551,108 1,273,065
opened cursors current 1,093,824 1,240,119
workarea memory allocated 254 859
logons current 5,240 5,282

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_UNDOTS1 31 0 9.68 1.00 622,624 173 268,939 0.03
APPS_TS_TX_DATA 180,253 50 3.61 1.29 190,143 53 133,016 0.19
APPS_TS_TX_IDX 92,735 26 3.54 1.27 216,970 60 61,522 0.28
APPS_ASSM_DATA 8,791 2 1.80 6.52 157,554 44 41,857 0.45
APPS_ASSM_IDX 6,738 2 2.15 1.04 126,362 35 185,160 0.09
APPS_TS_TX_INTERFACE 1,260 0 1.94 2.05 34,783 10 15,178 0.05
TEMP 550 0 4.29 9.35 9,883 3 67 3.13
APPS_TS_SEED 2,134 1 4.87 1.34 5,609 2 831 2.44
APPS_TS_SUMMARY 54 0 10.37 1.00 7,393 2 2,665 0.04
SYSTEM 4,404 1 3.47 4.03 2,797 1 19,557 0.06
APPS_TS_QUEUES 392 0 4.77 2.17 5,350 1 309 0.36
SYSAUX 912 0 2.02 1.04 1,930 1 0 0.00
APPS_TS_ARCHIVE 64 0 4.84 1.38 2,261 1 97 2.58
APPS_TS_NOLOGGING 25 0 9.20 1.56 30 0 0 0.00
CTXSYS 24 0 4.58 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 10.83 1.00 9 0 0 0.00
ODM 12 0 4.17 1.00 3 0 0 0.00
OLAP 12 0 5.00 1.00 3 0 0 0.00
OWAPUB 12 0 5.00 1.00 3 0 0 0.00
PORTAL 12 0 3.33 1.00 3 0 0 0.00
SYNCSERVER 12 0 3.33 1.00 3 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_ASSM_DATA /DB/visdata/apps_assm_data.dbf 8,791 2 1.80 6.52 157,554 44 41,857 0.45
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,738 2 2.15 1.04 126,362 35 185,160 0.09
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 35 0 4.86 1.37 1,982 1 94 2.66
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 29 0 4.83 1.38 279 0 3 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 10.00 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 4 0 12.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 4 0 10.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 4 0 15.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 15 0 6.67 1.00 17 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 11.67 3.33 10 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 38 0 4.74 2.50 664 0 134 0.37
APPS_TS_QUEUES /DB/visdata/queues2.dbf 39 0 3.85 2.82 839 0 123 0.33
APPS_TS_QUEUES /DB/visdata/queues3.dbf 39 0 5.38 2.59 922 0 2 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 47 0 5.11 2.23 779 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 41 0 4.63 1.85 725 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 49 0 5.31 2.20 436 0 2 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 139 0 4.60 1.84 985 0 47 0.43
APPS_TS_SEED /DB/visdata/reference1.dbf 182 0 5.16 1.37 470 0 56 4.46
APPS_TS_SEED /DB/visdata/reference10.dbf 173 0 5.14 1.24 552 0 68 3.38
APPS_TS_SEED /DB/visdata/reference2.dbf 199 0 4.97 1.27 575 0 50 0.00
APPS_TS_SEED /DB/visdata/reference3.dbf 329 0 4.44 1.34 630 0 387 2.07
APPS_TS_SEED /DB/visdata/reference4.dbf 208 0 4.38 1.35 629 0 28 2.14
APPS_TS_SEED /DB/visdata/reference5.dbf 247 0 5.63 1.31 569 0 45 5.11
APPS_TS_SEED /DB/visdata/reference6.dbf 233 0 4.89 1.39 629 0 33 0.91
APPS_TS_SEED /DB/visdata/reference7.dbf 218 0 4.36 1.33 489 0 35 4.00
APPS_TS_SEED /DB/visdata/reference8.dbf 182 0 5.82 1.49 499 0 54 4.26
APPS_TS_SEED /DB/visdata/reference9.dbf 163 0 4.05 1.31 567 0 75 0.80
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 5 0 8.00 1.00 918 0 391 0.05
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 8.00 1.00 755 0 203 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 9 0 12.22 1.00 842 0 276 0.04
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 7 0 8.57 1.00 896 0 302 0.00
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 7 0 8.57 1.00 913 0 353 0.03
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 12.86 1.00 934 0 659 0.05
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 7 0 14.29 1.00 1,014 0 200 0.10
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 8.57 1.00 1,121 0 281 0.04
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 3,345 1 3.93 1.23 357 0 7 5.71
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 3,314 1 4.03 1.27 254 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 3,304 1 4.10 1.30 221 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 13,483 4 2.66 1.21 4,099 1 3,176 0.65
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 17,679 5 3.81 1.41 5,556 2 2,495 0.71
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 13,189 4 3.53 1.34 27,634 8 18,527 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 9,377 3 3.38 1.41 26,182 7 16,843 0.22
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,453 3 3.39 1.39 25,555 7 18,074 0.18
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 9,337 3 3.45 1.40 24,825 7 18,553 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 9,496 3 3.44 1.38 23,550 7 18,091 0.14
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 9,290 3 3.47 1.41 23,425 6 16,516 0.12
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,920 2 3.13 1.15 1,101 0 2,157 0.80
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 9,284 3 3.47 1.41 23,556 7 17,114 0.17
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 23,761 7 4.02 1.22 1,088 0 1,398 0.04
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 4,159 1 4.23 1.40 488 0 4 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 17,903 5 3.67 1.08 329 0 3 6.67
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 3,438 1 3.98 1.22 386 0 4 7.50
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 3,411 1 3.92 1.25 253 0 12 2.50
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 3,339 1 4.22 1.26 518 0 33 2.42
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 3,303 1 3.78 1.26 479 0 7 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,468 1 3.77 1.30 287 0 2 5.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,669 1 3.36 1.12 2,319 1 1,008 0.72
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,537 1 3.07 1.11 1,649 0 1,252 0.56
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,556 1 3.17 1.16 1,760 0 1,115 0.19
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 11,618 3 3.86 1.47 24,876 7 1,328 0.38
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 9,208 3 3.62 1.21 29,204 8 3,663 0.25
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 5,387 1 3.73 1.31 21,592 6 3,685 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 5,352 1 3.75 1.30 18,778 5 4,257 0.18
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 5,310 1 3.73 1.30 17,401 5 4,414 0.15
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 5,299 1 3.66 1.28 16,132 4 3,793 0.22
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 5,339 1 3.54 1.32 15,966 4 6,024 0.13
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 5,343 1 3.61 1.26 15,527 4 4,722 0.16
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 3,163 1 3.64 1.27 2,193 1 1,861 0.20
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 5,131 1 3.69 1.31 14,864 4 3,609 0.08
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,625 1 3.88 1.47 15,283 4 2,503 0.34
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 4,087 1 2.58 1.11 1,900 1 2,258 0.84
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,727 1 3.41 1.12 3,523 1 2,053 0.77
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,777 1 3.09 1.16 4,873 1 8,221 0.16
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,704 1 3.29 1.21 2,755 1 1,813 0.71
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,647 1 3.14 1.14 2,549 1 1,424 0.51
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,654 1 3.27 1.15 2,038 1 1,339 0.67
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,602 1 3.27 1.15 1,788 0 1,180 0.64
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 155 0 1.68 1.99 5,501 2 2,039 0.10
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 326 0 1.78 2.00 6,764 2 3,459 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 201 0 1.84 2.23 6,000 2 3,213 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 158 0 2.22 2.34 5,578 2 2,049 0.07
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 259 0 1.89 1.75 5,459 2 2,667 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 161 0 2.48 2.17 5,481 2 1,751 0.05
APPS_UNDOTS1 /DB/visdata/undo01.dbf 3 0 10.00 1.00 64,410 18 23,471 0.03
APPS_UNDOTS1 /DB/visdata/undo02.dbf 3 0 10.00 1.00 62,759 17 25,227 0.03
APPS_UNDOTS1 /DB/visdata/undo03.dbf 3 0 10.00 1.00 62,478 17 26,710 0.03
APPS_UNDOTS1 /DB/visdata/undo04.dbf 3 0 10.00 1.00 63,508 18 24,112 0.02
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 6.67 1.00 60,962 17 29,541 0.04
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 6.67 1.00 60,884 17 25,085 0.02
APPS_UNDOTS1 /DB/visdata/undo07.dbf 3 0 10.00 1.00 60,657 17 29,588 0.03
APPS_UNDOTS1 /DB/visdata/undo08.dbf 4 0 10.00 1.00 60,003 17 31,736 0.02
APPS_UNDOTS1 /DB/visdata/undo09.dbf 3 0 6.67 1.00 61,649 17 28,744 0.03
APPS_UNDOTS1 /DB/visdata/undo10.dbf 3 0 16.67 1.00 65,314 18 24,725 0.03
CTXSYS /DB/visdata/ctx1.dbf 12 0 5.00 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 4.17 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 12 0 4.17 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 5.00 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 12 0 5.00 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 12 0 3.33 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 3.33 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 116 0 1.72 1.02 585 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 796 0 2.06 1.05 1,345 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 498 0 3.05 4.35 114 0 16 0.00
SYSTEM /DB/visdata/sys2.dbf 462 0 3.51 4.84 208 0 7 1.43
SYSTEM /DB/visdata/sys3.dbf 536 0 3.02 4.18 245 0 1 0.00
SYSTEM /DB/visdata/sys4.dbf 519 0 2.89 4.29 264 0 1 0.00
SYSTEM /DB/visdata/sys5.dbf 735 0 3.82 3.29 700 0 442 0.02
SYSTEM /DB/visdata/sys6.dbf 560 0 3.46 4.15 77 0 1 0.00
SYSTEM /DB/visdata/sys7.dbf 402 0 3.91 4.61 180 0 25 1.20
SYSTEM /DB/visdata/sys8.dbf 292 0 3.87 3.85 520 0 19,054 0.06
SYSTEM /DB/visdata/sys9.dbf 400 0 3.88 2.94 489 0 10 0.00
TEMP /DB/visdata/temp1.dbf 127 0 3.78 2.00 2,262 1 10 5.00
TEMP /DB/visdata/temp2.dbf 137 0 3.94 2.76 2,675 1 39 3.33
TEMP /DB/visdata/temp3.dbf 128 0 5.08 12.65 2,496 1 2 10.00
TEMP /DB/visdata/temp4.dbf 158 0 4.37 18.30 2,450 1 16 0.63

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 2,178,888 100 2,094,899,594 444,396 3,151,224 0 0 729,201


Back to Top

 

Advisory Statistics

Back to Top

Instance Recovery Stats

  Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual Redo Blks Target Redo Blks Log File Size Redo Blks Log Ckpt Timeout Redo Blks Log Ckpt Interval Redo Blks
B 180 96 48403 1186404 4582462 188743680 4582462  
E 180 99 52580 1195632 10195460 188743680 10195460  

Back to Advisory Statistics
Back to Top

 

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 639,593 16

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 20,480 1,280 47,168.22 0.25 0.00 100.00 0.00 1,048,576
E 20,480 1,280 55,630.57 0.84 0.00 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 5,985,547 5,985,547 0 0
64K 128K 11,800 11,800 0 0
128K 256K 1,150 1,150 0 0
256K 512K 1,095 1,095 0 0
512K 1024K 188,191 188,191 0 0
1M 2M 438,820 438,820 0 0
2M 4M 68 66 2 0
4M 8M 19 17 2 0
8M 16M 18 18 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
2,560 0.13 935,583.66 9,032.01 99.00 1,130
5,120 0.25 935,583.66 8,600.85 99.00 1,096
10,240 0.50 935,583.66 8,451.03 99.00 1,045
15,360 0.75 935,583.66 8,335.21 99.00 998
20,480 1.00 935,583.66 8.01 100.00 951
24,576 1.20 935,583.66 8.01 100.00 912
28,672 1.40 935,583.66 8.01 100.00 858
32,768 1.60 935,583.66 8.01 100.00 755
36,864 1.80 935,583.66 8.01 100.00 471
40,960 2.00 935,583.66 0.00 100.00 162
61,440 3.00 935,583.66 0.00 100.00 0
81,920 4.00 935,583.66 0.00 100.00 0
122,880 6.00 935,583.66 0.00 100.00 0
163,840 8.00 935,583.66 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
1,616 0.58 320 13,664 2,256,580 1.00 3,798 3.22 190,383,588
1,904 0.69 584 18,088 2,258,293 1.00 2,085 1.77 190,505,351
2,192 0.79 869 21,991 2,259,012 1.00 1,366 1.16 190,558,510
2,480 0.90 1,155 26,664 2,259,174 1.00 1,204 1.02 190,571,309
2,768 1.00 1,403 33,462 2,259,199 1.00 1,179 1.00 190,573,483
3,056 1.10 1,572 38,525 2,259,201 1.00 1,177 1.00 190,573,769
3,344 1.21 1,643 39,954 2,259,201 1.00 1,177 1.00 190,573,803
3,632 1.31 1,660 40,905 2,259,201 1.00 1,177 1.00 190,573,807
3,920 1.42 1,660 40,905 2,259,201 1.00 1,177 1.00 190,573,807
4,208 1.52 1,660 40,905 2,259,201 1.00 1,177 1.00 190,573,807
4,496 1.62 1,660 40,905 2,259,201 1.00 1,177 1.00 190,573,807
4,784 1.73 1,660 40,905 2,259,201 1.00 1,177 1.00 190,573,807
5,072 1.83 1,660 40,905 2,259,201 1.00 1,177 1.00 190,573,807
5,360 1.94 1,660 40,905 2,259,201 1.00 1,177 1.00 190,573,807
5,648 2.04 1,660 40,905 2,259,201 1.00 1,177 1.00 190,573,807

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
5,120 0.25 35,745  
10,240 0.50 35,745  
15,360 0.75 35,745  
20,480 1.00 35,744  
25,600 1.25 35,745  
30,720 1.50 35,750  
35,840 1.75 35,750  
40,960 2.00 35,750  

Back to Advisory Statistics
Back to Top

 

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M) JP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
16 0.25 9 336 1,252 1.00 1,179 1.00 21,598
32 0.50 9 336 1,252 1.00 1,179 1.00 21,598
48 0.75 9 336 1,252 1.00 1,179 1.00 21,598
64 1.00 9 336 1,252 1.00 1,179 1.00 21,598
80 1.25 9 336 1,252 1.00 1,179 1.00 21,598
96 1.50 9 336 1,252 1.00 1,179 1.00 21,598
112 1.75 9 336 1,252 1.00 1,179 1.00 21,598
128 2.00 9 336 1,252 1.00 1,179 1.00 21,598

Back to Advisory Statistics
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 451,728 83 0
undo block 216,866 6 0
undo header 52,073 2 0
1st level bmb 5,045 0 0
file header block 127 0 2
segment header 2,481 0 0
2nd level bmb 858 0 0
extent map 19 0 0
bitmap index block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
TX-Transaction (row lock contention) 6,729 692 6,037 658 161 245.14
UL-User-defined 69,515 68,522 993 2,002 56 28.18
TX-Transaction (index contention) 27,006 27,006 0 24,255 13 0.54
RO-Multiple Object Reuse (fast object reuse) 288 288 0 29 7 243.45
TM-DML 2,173,521 2,173,466 2 5 3 642.00
HW-Segment High Water Mark 279,936 279,925 11 2,078 1 0.60
TX-Transaction 1,339,895 1,339,898 0 1,845 1 0.44
SQ-Sequence Cache 43,252 43,252 0 2,908 1 0.21
DV-Diana Versioning 32,299 32,299 0 146 1 3.84
CU-Cursor 9,621 9,621 0 14 0 15.00
FB-Format Block 36,738 36,737 0 500 0 0.22
US-Undo Segment 11,225 11,225 0 15 0 6.67
TX-Transaction (allocate ITL entry) 159 159 0 65 0 0.77
PS-PX Process Reservation 1,864 1,544 320 30 0 0.00

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,624.32 1,343,087 2,670 384   0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
01-May 20:38 188,154 175,258 479 380 206 0/0 0/0/0/0/0/0
01-May 20:28 97,633 149,164 793 379 209 0/0 0/0/0/0/0/0
01-May 20:18 225,870 164,921 634 371 200 0/0 0/0/0/0/0/0
01-May 20:08 405,526 221,549 2,670 373 209 0/0 0/0/0/0/0/0
01-May 19:58 326,323 255,176 2,666 384 267 0/0 0/0/0/0/0/0
01-May 19:48 380,818 377,019 2,061 381 363 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 2,466 0.00   0 0  
AWR Alerted Metric Element list 334,904 0.00   0 0  
Consistent RBA 863,664 0.08 0.14 0 0  
FOB s.o list latch 55,098 0.00 0.00 0 0  
In memory undo latch 772,864,641 1.52 0.00 6 1,277,581 0.00
JOX SGA heap latch 1,949,708 0.00   0 0  
JS mem alloc latch 8 0.00   0 0  
JS queue access latch 8 0.00   0 0  
JS queue state obj latch 21,600 0.00   0 0  
JS slv state obj latch 183 0.00   0 0  
KMG MMAN ready and startup request latch 3,499 0.00   0 0  
KMG resize request state object freelist 24 0.00   0 0  
KTF sga latch 12 0.00   0 1,214 0.00
KWQMN job cache list latch 14,453 0.25 0.94 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 2,526 0.00   0 3,486 0.00
OS process 15,267 0.00   0 0  
OS process allocation 11,427 0.00   0 0  
OS process: request allocation 9,946 0.01 0.00 0 0  
PL/SQL warning settings 4,608,052 0.00   0 0  
SGA IO buffer pool latch 33,562 0.03 0.00 0 34,505 0.24
SQL memory manager latch 3 0.00   0 1,199 0.00
SQL memory manager workarea list latch 7,207,123 0.01 0.00 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 1,304,205 0.80 0.00 0 2 0.00
active service list 48,819 0.07 0.03 0 1,321 0.00
begin backup scn array 165 0.00   0 0  
buffer pool 23 0.00   0 0  
cache buffer handles 20,655,781 1.39 0.00 0 0  
cache buffers chains 4,941,228,092 1.01 0.04 65 19,029,961 2.48
cache buffers lru chain 10,165,592 0.36 0.05 1 38,073,345 0.50
cache table scan latch 2,147 0.00   0 2,147 0.00
channel handle pool latch 414,883 0.09 0.03 0 0  
channel operations parent latch 1,772,757 0.43 0.00 0 0  
checkpoint queue latch 18,898,517 0.01 0.01 0 3,163,974 0.02
client/application info 1,796,464 0.00 0.20 0 0  
commit callback allocation 88,575 0.00   0 0  
compile environment latch 3,148,400 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 4,329,733 0.19 0.01 0 0  
dummy allocation 20,368 0.22 0.00 0 0  
enqueue hash chains 9,443,020 0.06 0.01 0 544 0.00
enqueues 5,416,388 0.11 0.01 0 0  
error message lists 816 1.10 0.00 0 0  
event group latch 4,997 0.00   0 0  
file cache latch 22,292 0.00   0 0  
global KZLD latch for mem in SGA 9,689 0.00   0 0  
global ctx hash table latch 24,489 0.00   0 0  
hash table column usage latch 2,121 0.05 0.00 0 15,524,435 0.00
hash table modification latch 190 0.00   0 0  
internal temp table object number allocation latc 6 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes parameter latch 120 0.00   0 0  
kks stats 30,914 0.00   0 0  
ksuosstats global area 246 0.00   0 0  
ktm global data 151,249 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 866,624 0.13 0.02 0 0  
library cache 355,979,821 0.36 0.01 7 20,868 0.96
library cache load lock 11,232 0.41 0.00 0 25 0.00
library cache lock 59,956,989 0.06 0.01 0 0  
library cache lock allocation 1,559,330 0.01 0.04 0 0  
library cache pin 221,843,314 0.12 0.01 2 91 0.00
library cache pin allocation 542,042 0.00 0.00 0 0  
list of block allocation 455,399 0.01 0.00 0 0  
loader state object freelist 322,544 0.00 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 421,526 0.01 0.11 0 0  
messages 6,189,974 0.41 0.01 0 0  
mostly latch-free SCN 920,757 4.73 0.05 1 0  
multiblock read objects 26,680 0.00   0 0  
ncodef allocation latch 236 0.00   0 0  
object queue header heap 3,766,276 0.03 0.21 0 402,665 0.08
object queue header operation 36,117,008 0.15 0.44 3 23,613 0.02
object stats modification 412,842 0.02 0.01 0 0  
parallel query alloc buffer 8,160 0.78 0.02 0 0  
parallel query stats 528 13.64 0.00 0 0  
parameter table allocation management 24,244 0.94 0.52 0 0  
post/wait queue 1,337,793 0.07 0.00 0 546,892 0.01
process allocation 9,994 0.10 0.50 0 4,992 0.10
process group creation 9,946 0.00   0 0  
process queue 5,030 0.91 0.00 0 0  
process queue reference 789,750 0.07 0.22 0 83,976 0.44
qmn task queue latch 516 0.00   0 0  
query server freelists 4,256 4.82 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 5,674,295 2.31 0.01 1 103,608,414 1.93
redo copy 0     0 103,796,240 0.05
redo writing 4,340,961 0.34 0.01 0 0  
resmgr group change latch 859,901 0.00   0 0  
resmgr:actses active list 30,026 0.58 0.99 0 0  
resmgr:actses change group 29,449 0.00   0 0  
resmgr:free threads list 20,366 0.22 0.07 0 0  
resmgr:schema config 3 0.00   0 0  
row cache objects 128,088,449 0.20 0.00 1 6,341 0.13
rules engine aggregate statistics 41,589 0.00   0 0  
rules engine rule set statistics 133,661 0.00 0.00 0 0  
rules engine rule statistics 50,483 0.00   0 0  
sequence cache 16,488,974 0.33 0.00 0 0  
session allocation 20,044,956 0.44 0.01 0 0  
session idle bit 102,541,613 0.01 0.02 0 0  
session state list latch 59,062 0.11 0.88 0 0  
session switching 15,323 0.00   0 0  
session timer 1,321 0.00   0 0  
shared pool 7,747,496 0.15 0.05 0 0  
shared pool sim alloc 397 0.00   0 0  
shared pool simulator 2,166,990 0.00 0.03 0 0  
sim partition latch 3 0.00   0 22,772 0.09
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 1,591 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,419,764 0.12 0.00 0 0  
state object free list 36 0.00   0 0  
statistics aggregation 252 0.00   0 0  
temp lob duration state obj allocation 281 0.00   0 0  
temporary table state object allocation 12,644 0.01 0.00 0 0  
threshold alerts latch 612 0.00   0 0  
trace latch 62 0.00   0 0  
transaction allocation 117,225 0.00   0 0  
transaction branch allocation 236 0.00   0 0  
undo global data 1,017,555,198 1.30 0.00 10 11,939 0.08
user lock 38,794 0.02 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 4,941,228,092 49,938,817 1,818,554 48,531,780 0 0 0
undo global data 1,017,555,198 13,237,392 31,709 13,209,616 0 0 0
In memory undo latch 772,864,641 11,723,917 19,272 11,707,423 0 0 0
library cache 355,979,821 1,296,708 11,028 1,286,840 0 0 0
cache buffer handles 20,655,781 286,527 266 286,307 0 0 0
row cache objects 128,088,449 260,670 968 259,751 0 0 0
library cache pin 221,843,314 255,545 2,974 252,871 0 0 0
redo allocation 5,674,295 131,033 1,141 130,067 0 0 0
session allocation 20,044,956 87,710 693 87,058 0 0 0
sequence cache 16,488,974 54,191 73 54,125 0 0 0
object queue header operation 36,117,008 53,087 23,580 31,551 0 0 0
mostly latch-free SCN 920,757 43,520 2,050 41,693 0 0 0
cache buffers lru chain 10,165,592 36,445 1,764 34,768 0 0 0
library cache lock 59,956,989 34,363 218 34,161 0 0 0
messages 6,189,974 25,483 161 25,325 0 0 0
redo writing 4,340,961 14,868 91 14,779 0 0 0
session idle bit 102,541,613 13,705 311 13,401 0 0 0
shared pool 7,747,496 12,004 617 11,439 0 0 0
active checkpoint queue latch 1,304,205 10,394 8 10,386 0 0 0
dml lock allocation 4,329,733 8,265 94 8,183 0 0 0
channel operations parent latch 1,772,757 7,673 14 7,659 0 0 0
enqueues 5,416,388 6,221 63 6,159 0 0 0
enqueue hash chains 9,443,020 5,597 32 5,567 0 0 0
checkpoint queue latch 18,898,517 2,607 15 2,593 0 0 0
sort extent pool 1,419,764 1,638 8 1,630 0 0 0
object queue header heap 3,766,276 1,211 258 975 0 0 0
lgwr LWN SCN 866,624 1,099 22 1,077 0 0 0
post/wait queue 1,337,793 872 4 868 0 0 0
Consistent RBA 863,664 690 98 611 0 0 0
process queue reference 789,750 514 114 400 0 0 0
SQL memory manager workarea list latch 7,207,123 392 1 391 0 0 0
channel handle pool latch 414,883 370 10 361 0 0 0
parameter table allocation management 24,244 229 120 115 0 0 0
resmgr:actses active list 30,026 175 174 2 0 0 0
library cache lock allocation 1,559,330 129 5 125 0 0 0
object stats modification 412,842 82 1 81 0 0 0
session state list latch 59,062 67 59 9 0 0 0
parallel query alloc buffer 8,160 64 1 63 0 0 0
resmgr:free threads list 20,366 44 3 41 0 0 0
KWQMN job cache list latch 14,453 36 34 2 0 0 0
shared pool simulator 2,166,990 35 1 34 0 0 0
active service list 48,819 34 1 33 0 0 0
message pool operations parent latch 421,526 28 3 25 0 0 0
client/application info 1,796,464 10 2 8 0 0 0
process allocation 9,994 10 5 5 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch kturbk 0 9,156 11,658
In memory undo latch ktiFlush: child 0 5,667 3,265
In memory undo latch kticmt: child 0 3,656 700
In memory undo latch ktichg: child 0 572 3,548
In memory undo latch ktiTxnPoolFree 0 200 1
In memory undo latch ktiBRacquire 0 11 0
In memory undo latch ktbgfc 0 10 132
KWQMN job cache list latch kwqmnuji: update job item 0 35 2
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 1 0
active checkpoint queue latch kcbbacq: scan active checkpoints 0 8 8
active service list kswsgetso: get service object 0 1 0
cache buffer handles kcbzgs 0 166 123
cache buffer handles kcbzfs 0 100 145
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,972,916 2,137,048
cache buffers chains kcbchg: kslbegin: call CR func 0 1,021,950 1,609,335
cache buffers chains kcbgtcr: fast path 0 580,331 26,227
cache buffers chains kcbgtcr: kslbegin excl 0 164,497 71,950
cache buffers chains kcbzgb: scan from tail. nowait 0 136,098 0
cache buffers chains kcbrls: kslbegin 0 58,524 106,414
cache buffers chains kcbgcur: kslbegin 0 29,275 13,994
cache buffers chains kcbget: pin buffer 0 18,331 7,820
cache buffers chains kcbzwb 0 5,930 4,802
cache buffers chains kcbcge 0 3,214 6,173
cache buffers chains kcbget: exchange rls 0 2,086 2,189
cache buffers chains kcbget: exchange 0 1,312 3,561
cache buffers chains kcbnlc 0 271 1,477
cache buffers chains kcbbxsv 0 174 166
cache buffers chains kcb_is_private 0 155 2,022
cache buffers chains kcbgtcr: kslbegin shared 0 104 83
cache buffers chains kcbesc: escalate 0 82 27
cache buffers chains kcbnew: new latch again 0 76 7
cache buffers chains kcbso1: set no access 0 37 48
cache buffers chains kcb_pre_apply: kcbhq61 0 19 1,605
cache buffers chains kcbbic2 0 10 2
cache buffers chains kcb_post_apply: kcbhq63 0 9 232
cache buffers chains kcb_post_apply: kcbhq62 0 7 362
cache buffers chains kcbo_ivd_process 0 4 56
cache buffers chains kcbgtcr 0 1 1
cache buffers chains kcbnew_1 0 1 3
cache buffers chains kcbrlb1 0 1 6
cache buffers chains kcbw_next_free 0 1 0
cache buffers chains kcbzib: finish free bufs 0 1 4
cache buffers chains kcbzib: multi-block read: nowait 0 1 0
cache buffers lru chain kcbzgws 0 1,064 0
cache buffers lru chain kcbbxsv: move to being written 0 190 543
cache buffers lru chain kcbo_link_q 0 188 38
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 162 0
cache buffers lru chain kcbzgb: posted for free bufs 0 66 402
cache buffers lru chain kcbzswcu 0 36 67
cache buffers lru chain kcbo_ivd_proc 0 30 330
cache buffers lru chain kcbbic2 0 19 329
cache buffers lru chain kcbzfw 0 3 1
cache buffers lru chain kcbz_decr_wspwbcnt 0 2 11
cache buffers lru chain kcbbwlru 0 1 38
cache buffers lru chain kcbzar: KSLNBEGIN 0 1 0
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 1 68
cache buffers lru chain kcbzib 0 1 1
channel handle pool latch ksrchconnect() 0 17 10
channel handle pool latch ksrchdelete() 0 2 9
channel operations parent latch ksrapublish() 0 23 6
channel operations parent latch ksrchdelete() 0 16 23
channel operations parent latch ksrmfree() 0 15 0
channel operations parent latch ksrchconnect() 0 10 12
channel operations parent latch ksrwait() 0 7 29
channel operations parent latch ksrsconsume() 0 3 5
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 5 6
checkpoint queue latch kcbkubc 0 5 7
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 4 0
checkpoint queue latch kcbswcu: Switch buffers 0 1 3
client/application info kqp327i 0 1 2
client/application info kskirefrattrmap 0 1 0
dml lock allocation ktaiam 0 58 75
dml lock allocation ktaidm 0 36 19
enqueue hash chains ksqgtl3 0 15 20
enqueue hash chains ksqrcl 0 15 9
enqueue hash chains ksqcmi: get hash chain latch after wait 0 2 3
enqueues ksqies 0 31 47
enqueues ksqgel: create enqueue 0 20 13
enqueues ksqdel 0 12 3
lgwr LWN SCN kcs023 0 551 0
library cache kglpndl: child: after processing 0 4,181 103
library cache kglpnp: child 0 3,990 5,907
library cache kglobpn: child: 0 1,111 1,582
library cache kglpndl: child: before processing 0 590 2,625
library cache kglLockCursor 0 288 398
library cache kglScanDependency 0 171 0
library cache kglpin 0 126 56
library cache kglhdgn: child: 0 95 143
library cache kgldte: child 0 0 82 165
library cache kglic 0 40 0
library cache kgldti: 2child 0 11 1
library cache kglhdgc: child: 0 7 1
library cache kglivl: child 0 4 0
library cache kglrtl 0 2 0
library cache kglupd: child 0 2 0
library cache kglati 0 1 0
library cache kgldrp: child 0 1 0
library cache kglhdiv: child 0 1 0
library cache kglini: child 0 1 1
library cache lock kgllkdl: child: cleanup 0 132 130
library cache lock kgllkal: child: multiinstance 0 86 88
library cache lock kgllkdl: child: no lock handle 0 84 34
library cache lock allocation kgllkget 0 5 5
library cache pin kglpndl 0 1,492 828
library cache pin kglpnp: child 0 1,278 1,671
library cache pin kglpnal: child: alloc space 0 204 474
message pool operations parent latch ksrmalloc() 0 4 3
messages ksaamb: after wakeup 0 66 82
messages ksarcv 0 49 12
messages ksarcv: after wait 0 46 67
mostly latch-free SCN kcslcu3 0 1,500 2,072
mostly latch-free SCN kcs01 0 56 101
mostly latch-free SCN kcsnew_scn_rba 0 42 0
mostly latch-free SCN kcs024 0 21 0
object queue header heap kcbo_link_q:reget 0 249 5
object queue header heap kcbw_link_q:alloc 0 6 253
object queue header heap kcbw_unlink_q 0 3 0
object queue header operation kcbo_ivbo 0 24,091 5,521
object queue header operation kcbw_link_q 0 4,107 2,478
object queue header operation kcbw_unlink_q 0 1,360 7,922
object queue header operation kcbo_switch_q_bg 0 287 2,226
object queue header operation kcbo_switch_mq_bg 0 272 3,415
object queue header operation kcbo_switch_cq 0 160 3,345
object queue header operation kcbo_link_q:reget 0 120 157
object queue header operation kcbo_swap_buf_bg 0 17 4,829
object queue header operation kcbo_swap_buf 0 13 542
object queue header operation kcbo_write_q 0 12 7
object queue header operation kcbo_service_ockpt 0 10 1
object stats modification ksoslinelm 0 1 0
parallel query alloc buffer kxfpbalo 0 1 1
parameter table allocation management ksp_param_table_free 0 118 118
parameter table allocation management kspallmod 0 2 0
post/wait queue ksliwat:remove 0 3 3
post/wait queue kslpstevent:get 0 1 1
process allocation ksucrp 0 4 0
process allocation ksudlp 0 1 9
process queue reference kxfprialo1 0 3 3
process queue reference kxfpqrsnd 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 679 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 245 940
redo allocation kcrfw_redo_write: before write 0 133 119
redo allocation kcrfw_redo_write: more space 0 49 98
redo allocation kcrfw_redo_gen: redo allocation 2 0 35 0
redo writing kcrfw_post: after write 0 38 0
redo writing kcrfw_post: rba scn pair 0 22 0
redo writing kcrfwcr 0 21 99
redo writing kcrfw_cal_target_rba 0 10 0
resmgr:actses active list kgskchclass 0 174 90
resmgr:free threads list kgskthrsod 0 2 1
resmgr:free threads list kgskthrcreate 0 1 2
row cache objects kqreqd: reget 0 759 3
row cache objects kqrpre: find obj 0 137 796
row cache objects kqreqd 0 64 169
row cache objects kqrso 0 5 0
sequence cache kdnssd 0 46 1
sequence cache kdnnxt: cached seq 0 22 0
sequence cache kdnss 0 5 72
session allocation ksuxds: KSUSFCLC not set 0 218 25
session allocation ksuprc 0 134 131
session allocation ksucri 0 107 249
session allocation ksuxds: not user session 0 89 82
session allocation ksudlc 0 85 156
session allocation kspallmod 0 25 0
session allocation ksursi 0 14 29
session allocation kxfpqidqr 0 9 14
session allocation ksudlp 0 7 0
session allocation kxfprdp 0 4 7
session allocation ksusroll 0 1 0
session idle bit ksupuc: set busy 0 344 152
session idle bit ksupuc: clear busy 0 144 326
session idle bit ksuxds 0 16 26
session state list latch kpseqd 0 54 0
session state list latch kpscad 0 4 2
session state list latch kpseqa 0 1 99
shared pool kghupr1 0 280 409
shared pool kghalo 0 261 123
shared pool kghfrunp: clatch: nowait 0 230 0
shared pool kghfre 0 46 82
shared pool kghfrunp: alloc: wait 0 22 1
shared pool kghfrunp: clatch: wait 0 13 11
shared pool kghalp 0 8 2
shared pool simulator kglsim_unpin_simhp 0 1 1
sort extent pool ktstdt: dealloc sort extent 0 6 0
sort extent pool ktstaddextent1 0 1 1
sort extent pool ktstcrtobj 0 1 0
undo global data kturimugur: child 0 30,150 26,314
undo global data ktudba: KSLBEGIN 0 1,478 5,363
undo global data ktusmasp: ktugd_tuux 0 23 4
undo global data ktucof: at start 0 18 0
undo global data ktudnx:child 0 18 6
undo global data ktufrbs: child 0 13 21
undo global data ktubnd:child 0 6 0
undo global data ktusmofu: KSLBEGIN 0 2 0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 67,484,784 3.22
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 50,892,912 2.43
ICX APPS_TS_TX_DATA ICX_SESSION_ATTRIBUTES   TABLE 24,950,048 1.19
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 22,619,696 1.08
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 20,684,304 0.99

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 35,008 7.85
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,005 2.92
HR APPS_TS_TX_IDX PAY_BALANCE_CONTEXT_VALUES_PK   INDEX 10,478 2.35
HR APPS_TS_TX_DATA PAY_BALANCE_CONTEXT_VALUES   TABLE 10,370 2.33
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.14

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 11,712 26.83
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 10,117 23.17
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,215 21.11
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 2,709 6.20
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,680 3.85

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 20 24.10
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 16 19.28
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_N51   INDEX 8 9.64
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 6 7.23
HR APPS_TS_TX_IDX PAY_RUN_BALANCES_N1   INDEX 6 7.23

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 132,793 33.77
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 77,801 19.79
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 19,030 4.84
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 17,079 4.34
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 16,421 4.18

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 13 7.69 0   6 1
dc_constraints 648 47.22 0   648 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 7,838,656 0.00 0   0 59
dc_histogram_data 68,100 1.77 0   0 705
dc_histogram_defs 422,893 3.09 0   4,044 3,298
dc_object_grants 72,700 0.07 0   0 86
dc_object_ids 12,646,291 0.02 0   58 1,387
dc_objects 183,829 1.04 0   347 1,102
dc_profiles 9,750 0.00 0   0 1
dc_rollback_segments 29,065 0.02 0   15 390
dc_segments 369,835 0.86 0   16,035 1,525
dc_sequences 53,632 0.12 0   53,632 118
dc_table_scns 20,650 0.04 0   0 5
dc_tablespace_quotas 15,867 0.13 0   213 44
dc_tablespaces 5,931,522 0.00 0   0 21
dc_usernames 515,221 0.00 0   0 21
dc_users 15,121,694 0.00 0   0 64
outstanding_alerts 275 2.18 0   7 43


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 644,849 0.02 42,591,956 0.00 12 0
CLUSTER 119 0.84 269 1.49 3 0
INDEX 15,855 0.47 16,743 0.63 2 0
JAVA DATA 624 0.00 0   0 0
PIPE 50,532 2.54 74,634 1.72 0 0
SQL AREA 6,427 93.51 114,704,579 0.43 4,060 531
TABLE/PROCEDURE 411,459 0.28 57,973,088 0.01 1,237 0
TRIGGER 28,901 0.09 1,408,107 0.00 23 0


Back to Top

 

Memory Statistics

Back to Top

Process Memory Summary

  Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc
B Other 37,372.96   12.13 7.13 38 38 3,080 3,080
  Freeable 3,638.88 0.00 1.33 0.80 9   2,737 2,737
  SQL 3,491.89 1,787.18 1.14 0.71 4 22 3,072 3,071
  PL/SQL 2,396.16 189.59 0.78 0.97 3 3 3,080 3,080
  JAVA 270.94 269.69 2.26 0.29 4 6 120 120
E Other 44,239.27   14.14 8.65 40 40 3,128 3,128
  Freeable 4,287.75 0.00 1.52 0.94 9   2,826 2,826
  SQL 4,037.31 2,108.83 1.29 0.77 5 22 3,120 3,119
  PL/SQL 2,797.00 216.56 0.89 0.99 3 3 3,128 3,128
  JAVA 270.73 269.49 2.26 0.29 4 7 120 120

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 18,673,041,408 18,471,714,816
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,785,020,272 2,986,346,864

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 51.29 51.29 0.00
java joxlod exec hp 12.09 12.09 0.00
large free memory 15.94 15.94 0.00
shared ASH buffers 29.00 29.00 0.00
shared CCursor 37.47 38.81 3.59
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.61 69.41 4.20
shared db_block_hash_buckets 180.00 180.00 0.00
shared event statistics per sess 63.28 63.28 0.00
shared free memory 350.43 365.90 4.42
shared library cache 852.78 1,015.28 19.05
shared parameter table block 57.58 58.04 0.80
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 383.00 393.41 2.72
shared trace buffer 48.17 49.14 2.01
  buffer_cache 17,808.00 17,616.00 -1.08
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

 

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Resource Limit Stats

Resource Name Current Utilization Maximum Utilization Initial Allocation Limit
processes 3,129 3,146 3600 3600


Back to Top

 

init.ora Parameters

Parameter Name Begin value End value (if different)
O7_DICTIONARY_ACCESSIBILITY FALSE   
_b_tree_bitmap_plans FALSE   
_fast_full_scan_enabled FALSE   
_like_with_bind_as_equality TRUE   
_sort_elimination_cost_ratio 5   
_sqlexec_progression_cost 2147483647   
_swrf_mmon_dbfus FALSE   
_swrf_mmon_flush FALSE   
_system_trig_enabled TRUE   
aq_tm_processes 1   
background_dump_dest /DB/oracle/product/10.2.0/db_1/admin/VIS/bdump   
compatible 10.2.0.3   
control_files /raw_links/cntrl01, /raw_links/cntrl02, /raw_links/cntrl03   
core_dump_dest /DB/oracle/product/10.2.0/db_1/admin/VIS/cdump   
cursor_sharing exact   
cursor_space_for_time FALSE   
db_block_checking false   
db_block_checksum TRUE   
db_block_size 8192   
db_cache_advice off   
db_files 130   
db_name VIS   
db_writer_processes 3   
dml_locks 10000   
fast_start_mttr_target 180   
java_pool_size 67108864   
job_queue_processes 2   
lock_sga FALSE   
log_buffer 14219264   
log_checkpoint_timeout 1200   
log_checkpoints_to_alert TRUE   
max_dump_file_size unlimited   
nls_comp binary   
nls_date_format DD-MON-RR   
nls_language american   
nls_length_semantics BYTE   
nls_numeric_characters .,   
nls_sort binary   
nls_territory america   
olap_page_pool_size 4194304   
open_cursors 1000   
optimizer_secure_view_merging FALSE   
parallel_max_servers 8   
pga_aggregate_target 21474836480   
plsql_code_type INTERPRETED   
plsql_native_library_dir /DB/oracle/product/10.2.0/db_1/native   
plsql_native_library_subdir_count 300   
plsql_optimize_level 2   
processes 3600   
remote_login_passwordfile EXCLUSIVE   
replication_dependency_tracking FALSE   
session_cached_cursors 500   
sessions 7200   
sga_target 21474836480   
shared_pool_reserved_size 209715200   
shared_pool_size 2097152000   
timed_statistics TRUE   
trace_enabled FALSE   
undo_management AUTO   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /DB/oracle/product/10.2.0/db_1/admin/VIS/udump   
utl_file_dir /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report