WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
VIS403747463VIS117-Jun-14 08:0611.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
A4U4S141Solaris[tm] OE (64-bit) 32 16 1 1022.25

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1817-Jun-14 10:26:092019 52.8
End Snap:2017-Jun-14 11:26:241990 58.4
Elapsed:  60.25 (mins)  
DB Time:  387.08 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 94,720M 94,720MStd Block Size: 8K
Shared Pool Size: 153,600M 153,600MLog Buffer: 478,456K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 6.4 0.0 0.00 0.00
DB CPU(s): 6.4 0.0 0.00 0.00
Redo size: 1,123,364.1 5,332.6  
Logical reads: 262,604.6 1,246.6  
Block changes: 8,064.0 38.3  
Physical reads: 32.6 0.2  
Physical writes: 161.7 0.8  
User calls: 5,215.4 24.8  
Parses: 793.9 3.8  
Hard parses: 1.3 0.0  
W/A MB processed: 27.9 0.1  
Logons: 5.9 0.0  
Executes: 16,012.7 76.0  
Rollbacks: 27.2 0.1  
Transactions: 210.7   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 99.99Soft Parse %: 99.84
Execute to Parse %: 95.04Latch Hit %: 97.62
Parse CPU to Parse Elapsd %: 96.98% Non-Parse CPU: 99.36

Shared Pool Statistics

BeginEnd
Memory Usage %: 9.64 9.75
% SQL with executions>1: 84.85 84.90
% Memory for SQL w/exec>1: 83.67 83.81

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 23,234 100.04 
library cache: mutex X36,1764610.20Concurrency
log file sync341,6963300.14Commit
SQL*Net message to client18,390,532800.04Network
local write wait4,110610.03User I/O

Host CPU (CPUs: 32 Cores: 16 Sockets: 1)

Load Average BeginLoad Average End%User%System%WIO%Idle
6.33 6.83 20.7 1.8 0.0 77.5
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
20.6 91.8 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 1,046,784.0 1,046,784.0
SGA use (MB): 256,000.0 256,000.0
PGA use (MB): 17,568.6 21,026.9
% Host Mem used for SGA+PGA: 26.13 26.46

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU23,233.51100.04
sql execute elapsed time22,334.6396.17
PL/SQL execution elapsed time7,660.9332.99
parse time elapsed166.020.71
connection management call elapsed time66.820.29
Java execution elapsed time20.590.09
inbound PL/SQL rpc elapsed time3.590.02
hard parse elapsed time3.030.01
repeated bind elapsed time1.510.01
failed parse elapsed time0.710.00
hard parse (sharing criteria) elapsed time0.570.00
sequence load elapsed time0.180.00
PL/SQL compilation elapsed time0.020.00
DB time23,224.99 
background elapsed time747.79 
background cpu time608.89 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME81,042 
AVG_IDLE_TIME280,176 
AVG_SYS_TIME6,364 
AVG_USER_TIME74,560 
BUSY_TIME2,597,242 
IDLE_TIME8,969,472 
SYS_TIME207,439 
USER_TIME2,389,803 
LOAD67
OS_CPU_WAIT_TIME178,200 
PHYSICAL_MEMORY_BYTES1,097,632,579,584 
NUM_CPUS32 
NUM_CPU_CORES16 
NUM_CPU_SOCKETS1 
TCP_RECEIVE_SIZE_DEFAULT128,000 
TCP_SEND_SIZE_DEFAULT49,152 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
17-Jun 10:26:096.33     
17-Jun 11:00:196.8422.3320.551.7877.670.00
17-Jun 11:26:246.8322.6220.811.8177.380.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  23,234 100.04
Concurrency43,70604610.20
Commit341,69603300.14
User I/O408,32601300.06
Network18,656,64301200.05
Application73,8450400.02
Other5,8221310.01
Administrative100610.00
Configuration110040.00
System I/O2,0670000.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
library cache: mutex X36,17604610.050.20
log file sync341,69603300.450.14
SQL*Net message to client18,390,53208024.150.04
local write wait4,1100610.010.03
utl_file I/O357,2050500.470.02
SQL*Net break/reset to client73,4700400.100.02
SQL*Net more data to client249,2500300.330.01
latch free7580230.000.01
Disk file operations I/O22,3670100.030.01
rdbms ipc reply2014760.000.00
direct path read11,5310100.020.00
buffer busy waits4,2280000.010.00
SQL*Net more data from client16,8610000.020.00
db file sequential read10,4820000.010.00
cursor: pin S1920000.000.00
db file scattered read2,5240000.000.00
direct path write990010.000.00
switch logfile command100610.000.00
enq: TX - row lock contention3750000.000.00
log file switch (private strand flush incomplete)400120.000.00
ADR block file write50080.000.00
latch: object queue header operation4,8810000.010.00
latch: cache buffers chains2,2930000.000.00
latch: In memory undo latch6270000.000.00
control file sequential read2,0670000.000.00
latch: undo global data170010.000.00
enq: TX - index contention710000.000.00
read by other session10050.000.00
latch: row cache objects900000.000.00
latch: call allocation340000.000.00
SQL*Net message from client18,390,54904,232,03123024.15 
Streams AQ: waiting for messages in the queue9,1549876,80383900.01 
pipe get4,3279918,06141740.01 
PL/SQL lock timer1,44110014,410100000.00 
wait for unread message on broadcast channel6,536263,6145530.01 
jobq slave wait7,0081003,5025000.01 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
db file parallel write13,32308060.0210.73
log file parallel write656,57904900.866.58
control file parallel write1,7890320.000.38
os thread startup15702150.000.32
db file async I/O submit9,8250200.010.21
ASM file metadata operation1,0890000.000.02
latch free390030.000.02
enq: TH - metric threshold evaluation600140.000.01
control file sequential read5,8040000.010.01
LGWR wait for redo copy4,9260000.010.01
library cache: mutex X5990000.000.01
direct path write140020.000.00
ADR block file write50060.000.00
latch: call allocation1,3440000.000.00
latch: active service list1,1800000.000.00
SQL*Net message to client57,6610000.080.00
asynch descriptor resize21,159100000.030.00
Disk file operations I/O5970000.000.00
latch: object queue header operation6880000.000.00
db file sequential read3720000.000.00
latch: undo global data30010.000.00
direct path write temp30010.000.00
rdbms ipc message682,020353,839790.90 
Space Manager: slave idle wait6,7137829,70444250.01 
Streams AQ: qmn slave idle wait1,03207,23070060.00 
DIAG idle wait6,7001006,70010000.01 
Streams AQ: qmn coordinator idle wait1,183443,61530560.00 
class slave wait48403,61474670.00 
wait for unread message on broadcast channel3,6141003,61410000.00 
Streams AQ: waiting for time management or cleanup tasks3,370673,61410720.00 
smon timer9303,614388570.00 
ASM background timer72403,61249890.00 
pmon timer1,252943,60328780.00 
JOX Jit Process Sleep3121003,591115100.00 
SQL*Net message from client78,663035550.10 
KSV master wait1490000.00 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read55100.0       
ADR block file write10  10.070.020.0   
ADR file lock12100.0       
ASM file metadata operation109299.5    .5  
Disk file operations I/O23K100.0       
LGWR wait for redo copy4931100.0       
SQL*Net break/reset to client73.7K100.0.0.0.0.0.0.0 
SQL*Net message to client18.5M100.0       
SQL*Net more data from client16.9K100.0.0      
SQL*Net more data to client249.9K100.0       
asynch descriptor resize21.2K100.0       
buffer busy waits424398.5.2.9.2.1.1  
buffer deadlock59100.0       
control file parallel write1785.198.7.6.2.2.1  
control file sequential read7583100.0       
cursor: mutex S1100.0       
cursor: mutex X1100.0       
cursor: pin S19294.8.5  4.7   
db file async I/O submit982499.9.0  .1.0  
db file parallel read6100.0       
db file parallel write13.3K50.76.42.610.219.39.41.4 
db file scattered read2518100.0       
db file sequential read10.8K100.0   .0   
direct path read11.5K99.9.0.0 .0.0.0 
direct path write11392.92.72.7.9.9   
direct path write temp4100.0       
enq: DV - contention6100.0       
enq: SQ - contention2100.0       
enq: TH - metric threshold evaluation6    100.0   
enq: TX - allocate ITL entry5100.0       
enq: TX - contention1100.0       
enq: TX - index contention71100.0       
enq: TX - row lock contention37799.7 .3     
latch free79871.1.4.63.124.8   
latch: In memory undo latch630100.0       
latch: active service list1189100.0       
latch: cache buffers chains2313100.0       
latch: cache buffers lru chain13100.0       
latch: call allocation1382100.0       
latch: object queue header operation5604100.0       
latch: redo allocation1100.0       
latch: row cache objects90100.0       
latch: shared pool28100.0       
latch: undo global data20100.0       
library cache: mutex X36.7K88.0.0  11.6.4.0 
local write wait411075.912.14.84.62.4.2.0 
log file parallel write657.1K99.9.0.0.0.0.0.0 
log file sequential read2100.0       
log file single write2100.0       
log file switch (private strand flush incomplete)4  50.025.0  25.0 
log file sync342.1K99.8.1.0.0.0.0.0 
os thread startup157    88.511.5  
rdbms ipc reply2      100.0 
read by other session1   100.0    
reliable message2100.0       
switch logfile command1      100.0 
utl_file I/O357.5K100.0       
ASM background timer725      .199.9
DIAG idle wait6700      100.0 
JOX Jit Process Sleep311      4.895.2
KSV master wait148100.0       
PL/SQL lock timer1448       100.0
SQL*Net message from client18.5M91.92.01.51.1.8.91.0.7
Space Manager: slave idle wait6641.3  .1.1 5.294.3
Streams AQ: qmn coordinator idle wait118356.4      43.6
Streams AQ: qmn slave idle wait1027       100.0
Streams AQ: waiting for messages in the queue9115.3     1.798.0
Streams AQ: waiting for time management or cleanup tasks336721.8 .0.1.1.152.825.2
class slave wait48139.9.2 28.1.81.0.629.3
jobq slave wait7008.1     99.9 
pipe get4300      8.291.8
pmon timer1250.8   .1.42.296.5
rdbms ipc message682.6K28.015.022.115.39.64.73.31.9
smon timer922.2  1.1  5.491.3
wait for unread message on broadcast channel10.1K.2.5.3.7.81.196.3 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
SQL*Net break/reset to client1100.0.0      
db file parallel write18798.61.2.2.0    
direct path read1100.0.0      
library cache: mutex X1100.0.0      
local write wait2100.0.0      
log file parallel write1100.0.0      
log file switch (private strand flush incomplete)175.025.0      
log file sync13100.0.0      
rdbms ipc reply2    100.0   
switch logfile command1 100.0      

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
VIS19,53619,545117580,979
SYS$USERS3,6803,6790338,676
SYS$BACKGROUND00030,054

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
VIS 407404134368546001865074412
SYS$USERS 6690500054190
SYS$BACKGROUND 988077730000

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModuleSQL Text
3,750.681,7892.1016.15100.170.0185gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
3,733.291,7892.0916.07100.100.0054tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...
3,631.844009.0815.64100.020.004z510cva9wzsv POXPRPOP SELECT decode ( : P_sortby , ...
3,615.780 15.57100.000.0051bbkcd9zwsjw emagent_SQL_oracle_database /* OracleOEM */ with max1 as (...
3,615.491,7852.0315.5799.990.001cyrp6fh6mp53 e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...
3,575.191,7872.0015.39100.150.0081xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
1,722.1783,7400.027.4299.620.0067mmmbx5hb3p0 e::bes:oracle.apps.icx.security.session.created BEGIN :1 := FND_AOLJ_UTIL.is_V...
846.061,7860.473.6499.760.1415py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
549.339,0350.062.37100.050.33ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
521.171,7870.292.2499.860.129ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
507.223,5940.142.1899.970.00327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
477.8317,426,0070.002.06101.560.00g4pktka6kg4w9 FNDSCMPI SELECT MENU_ID, ENTRY_SEQUENCE...
458.298,9340.051.97100.050.00akma8kaxsp84b e:PO:wf:POAPPRV SELECT reservation_id , requir...
400.198,9330.041.72100.140.004kk0bjar3pb7z e:PO:fwk:po.autocreate.server.AutocreateAM SELECT PLI.SHIPMENT_NUM , PLI....
358.329,3910.041.54101.490.275vbbcp6pd58b8 e:FND:cp:STANDARD begin Fnd_Concurrent.Init_Requ...
354.5911,1830.031.53104.090.00gyxv37z6aqyqp e:FND:cp:STANDARD SELECT P.PID, P.SPID, AUDSID, ...
299.071299.071.2994.950.0005s9358mm6vrr   begin dbms_feature_usage_inter...
283.161283.161.22100.000.003h1rjtcff3wy1   BEGIN ordsys.CARTRIDGE.dbms_fe...
283.161283.161.22100.000.0054wkgprhc32fh   SELECT COUNT(*), DATA_TYPE FRO...
250.701,8080.141.0899.640.013mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
3,757.011,7892.1016.173,750.68100.170.0185gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
3,737.201,7892.0916.093,733.29100.100.0054tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...
3,632.634009.0815.643,631.84100.020.004z510cva9wzsv POXPRPOP SELECT decode ( : P_sortby , ...
3,615.710 15.563,615.78100.000.0051bbkcd9zwsjw emagent_SQL_oracle_database /* OracleOEM */ with max1 as (...
3,615.281,7852.0315.563,615.4999.990.001cyrp6fh6mp53 e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...
3,580.531,7872.0015.413,575.19100.150.0081xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
1,715.6783,7400.027.381,722.1799.620.0067mmmbx5hb3p0 e::bes:oracle.apps.icx.security.session.created BEGIN :1 := FND_AOLJ_UTIL.is_V...
844.051,7860.473.63846.0699.760.1415py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
549.639,0350.062.37549.33100.050.33ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
520.471,7870.292.24521.1799.860.129ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
507.063,5940.142.18507.2299.970.00327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
485.2917,426,0070.002.09477.83101.560.00g4pktka6kg4w9 FNDSCMPI SELECT MENU_ID, ENTRY_SEQUENCE...
458.538,9340.051.97458.29100.050.00akma8kaxsp84b e:PO:wf:POAPPRV SELECT reservation_id , requir...
400.748,9330.041.72400.19100.140.004kk0bjar3pb7z e:PO:fwk:po.autocreate.server.AutocreateAM SELECT PLI.SHIPMENT_NUM , PLI....
369.1011,1830.031.59354.59104.090.00gyxv37z6aqyqp e:FND:cp:STANDARD SELECT P.PID, P.SPID, AUDSID, ...
363.679,3910.041.57358.32101.490.275vbbcp6pd58b8 e:FND:cp:STANDARD begin Fnd_Concurrent.Init_Requ...
283.961283.961.22299.0794.950.0005s9358mm6vrr   begin dbms_feature_usage_inter...
283.151283.151.22283.16100.000.003h1rjtcff3wy1   BEGIN ordsys.CARTRIDGE.dbms_fe...
283.151283.151.22283.16100.000.0054wkgprhc32fh   SELECT COUNT(*), DATA_TYPE FRO...
249.811,8080.141.08250.7099.640.013mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
1.839,0350.0013.76549.33100.050.33ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
1.181,7860.008.90846.0699.760.1415py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
0.989,3910.007.38358.32101.490.275vbbcp6pd58b8 e:FND:cp:STANDARD begin Fnd_Concurrent.Init_Requ...
0.631,7870.004.74521.1799.860.129ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
0.221,7890.001.683,750.68100.170.0185gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
0.183,5740.001.363.8999.164.65g89s7tq651bus e:PO:fwk:po.autocreate.server.AutocreateAM INSERT INTO ZX_TRANSACTION_LIN...
0.151,7890.001.143,733.29100.100.0054tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...
0.023,5940.000.15507.2299.970.00327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
0.021,8080.000.14250.7099.640.013mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
0.0283,7400.000.111,722.1799.620.0067mmmbx5hb3p0 e::bes:oracle.apps.icx.security.session.created BEGIN :1 := FND_AOLJ_UTIL.is_V...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
336,190,0880 35.413,615.78100051bbkcd9zwsjw emagent_SQL_oracle_database /* OracleOEM */ with max1 as (...
206,350,2011,789115,343.8821.743,750.68100.2085gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
204,465,7141,789114,290.5121.543,733.29100.1054tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...
202,797,7021,787113,485.0021.363,575.19100.1081xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
80,469,48183,740960.948.481,722.1799.6067mmmbx5hb3p0 e::bes:oracle.apps.icx.security.session.created BEGIN :1 := FND_AOLJ_UTIL.is_V...
67,621,23317,426,0073.887.12477.83101.60g4pktka6kg4w9 FNDSCMPI SELECT MENU_ID, ENTRY_SEQUENCE...
46,648,6101,78626,119.044.91846.0699.8.115py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
27,304,469127,304,469.002.88299.0794.9005s9358mm6vrr   begin dbms_feature_usage_inter...
27,230,372127,230,372.002.87283.1610003h1rjtcff3wy1   BEGIN ordsys.CARTRIDGE.dbms_fe...
27,230,372127,230,372.002.87283.16100054wkgprhc32fh   SELECT COUNT(*), DATA_TYPE FRO...
24,558,9009,0352,718.202.59549.33100.1.3ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
21,988,2673,5946,118.052.32507.221000327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
20,861,26440052,153.162.203,631.8410004z510cva9wzsv POXPRPOP SELECT decode ( : P_sortby , ...
19,521,0778,9342,185.032.06458.29100.10akma8kaxsp84b e:PO:wf:POAPPRV SELECT reservation_id , requir...
18,061,3431,78710,107.071.90521.1799.9.19ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
17,299,9451,8089,568.551.82250.7099.603mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
16,258,5547,1482,274.561.71127.95100.103v6p5sm1dkafz e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...
13,660,6841,7857,653.041.443,615.4910001cyrp6fh6mp53 e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...
11,414,7998,9331,277.821.20400.19100.104kk0bjar3pb7z e:PO:fwk:po.autocreate.server.AutocreateAM SELECT PLI.SHIPMENT_NUM , PLI....

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
2,0791,7871.161.76521.1799.860.129ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
1,8321,7861.031.55846.0699.760.1415py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
1,0843,5940.300.92507.2299.970.00327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
1,0581,8080.590.90250.7099.640.013mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
2623,5260.070.22192.36100.240.01aaw4na3kmdfkq JDBC Thin Client DECLARE l_result varchar2(1); ...
1307,0490.020.11101.8499.070.01bqf04xkudk4zt JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.crea...
3583,7400.000.031,722.1799.620.0067mmmbx5hb3p0 e::bes:oracle.apps.icx.security.session.created BEGIN :1 := FND_AOLJ_UTIL.is_V...
331,7890.020.033,750.68100.170.0185gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
231,7890.010.023,733.29100.100.0054tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...
199,3910.000.02358.32101.490.275vbbcp6pd58b8 e:FND:cp:STANDARD begin Fnd_Concurrent.Init_Requ...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
1,2851,2851,7870.720.002.939ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
1,1561,1561,7860.650.002.6415py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
6546543,5940.180.001.49327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
5705701,8080.320.001.303mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
2892891289.000.000.6605s9358mm6vrr   begin dbms_feature_usage_inter...
1371373,5260.040.000.31aaw4na3kmdfkq JDBC Thin Client DECLARE l_result varchar2(1); ...
86867,0490.010.000.20bqf04xkudk4zt JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.crea...
4848124.000.000.11fjvwzpxbpch0h emagent_SQL_oracle_database /* OracleOEM */ select capture...
33331,7890.020.000.0885gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
23231,7890.010.000.0554tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
17,426,007140,230,8978.05477.83101.60g4pktka6kg4w9 FNDSCMPI SELECT MENU_ID, ENTRY_SEQUENCE...
2,787,5562,541,2990.9165.15101.200wmwsjy9kd92f JDBC Thin Client SELECT PROFILE_OPTION_ID, APPL...
2,087,892557,3650.2741.0811107qs7fx89194u1 ICM@solaris (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
1,413,69812,723,0759.0025.9593.808w57t3xaxs89k ICM@solaris (TNS V1-V3) SELECT NAME, VERSION FROM FND_...
645,421645,4151.0018.6096.3016614jtsr33r0 JDBC Thin Client begin fnd_date.initialize_with...
528,497526,7891.0017.6390.6037kp7bjxfn4u5 JDBC Thin Client SELECT NLS_DATE_LANGUAGE FROM ...
383,810383,8011.0080.1899.402450j0nxcnga5 ICM@solaris (TNS V1-V3) declare sql_dummy1 boolean;beg...
328,247328,2411.007.81102.40ccprbqfuu8wb1 e:ICX:wf:REQAPPRV SELECT NUMBER_VALUE FROM WF_IT...
207,35487,0190.428.1710.50cm5vu20fhtnq1   select /*+ connect_by_filterin...
129,43646,5940.363.84770a4gss3ajbyfzr ICM@solaris (TNS V1-V3) SELECT R.RESPONSIBILITY_NAME F...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
120,405120,4054.206vx0fw5141z4n e:POS:fwk:ap.invoice.request.server.InvoiceReque SELECT STATUS_FLAG FROM IGI_GC...
92,48592,4843.22bbugagurwv1vy e:POS:fwk:ap.invoice.request.server.InvoiceReque (SELECT STATUS_FLAG FROM IGI_G...
36,17036,1701.267yr8xbwxpdnav e:ICX:wf:POWFRQAG INSERT INTO WIP_EAM_DIRECT_ITE...
35,77935,7791.25bw5t54n7fjk02 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT INVENTORY_ORGANIZATION_...
27,12827,1270.95dnx99s71vmu3r e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT POA.AGENT_ID FROM PO_AG...
26,17526,1730.91529wb67xu0sy9 e:POS:fwk:ap.invoice.request.server.InvoiceReque SELECT INPUT_TAX_CLASSIFICATIO...
26,17526,1750.919tssyu6p7uk2s e:POS:fwk:ap.invoice.request.server.InvoiceReque SELECT SUM(AID.AMOUNT) FROM AP...
23,3172,787,5560.810wmwsjy9kd92f JDBC Thin Client SELECT PROFILE_OPTION_ID, APPL...
21,10221,0980.740k8522rmdzg4k   select privilege# from sysauth...
21,102207,3540.74cm5vu20fhtnq1   select /*+ connect_by_filterin...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
3,556,1651,7870.00fc1vzazaaduns e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT phx.*, PO_COMMUNICATION...
2,417,8811,7870.0081xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
1,432,1713760.006129566gyvx21 OEM.BoundedPool SELECT INSTANTIABLE, supertype...
1,295,6684000.004z510cva9wzsv POXPRPOP SELECT decode ( : P_sortby , ...
1,255,0924000.004z510cva9wzsv POXPRPOP SELECT decode ( : P_sortby , ...
1,202,3324000.004z510cva9wzsv POXPRPOP SELECT decode ( : P_sortby , ...
1,133,0258,9450.004mj8xhjcnw7gf e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."SHIPMENT_NUM" "SH...
1,107,08600.000cyf7ts2q1dpg POXPRPOP SELECT decode ( : P_sortby , ...

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 IdSQL Text
05s9358mm6vrrbegin dbms_feature_usage_internal.exec_db_usage_sampling(:bind1); end;
0cyf7ts2q1dpg SELECT decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_last_name ) , decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_first_name ) , decode ( : po_num_type , 'NUMERIC' , null , poh . po_num ) , decode ( : po_num_type , 'NUMERIC' , decode ( rtrim ( poh . po_num , '0123456789' ) , NULL , to_number ( poh . po_num ) , - 1 ) , null ) , poh . po_type poh_po_type , por . release_type poh_release_type , poh . po_num || decode ( poh . po_type , 'RELEASE' , '-' || por . release_num , null ) poh_po_num , poh . po_num security_poh_po_num , por . release_num security_por_po_num , poh . revision_num poh_revision_num , poh . vendor_name poh_vendor_name , poh . vendor_address_line1 poh_vendor_address_line1 , poh . vendor_address_line2 poh_vendor_address_line2 , poh . vendor_address_line3 poh_vendor_address_line3 , decode ( poh . vendor_city , null , poh . vendor_state || ' ' || poh . vendor_postal_code , poh . vendor_city || ', ' || poh . vendor_state || ' ' || poh . vendor_postal_code ) poh_vendor_adr_info , poh . vendor_country poh_vendor_country , poh . customer_num poh_customer , poh . vendor_num poh_vendor_num , poh . creation_date poh_creation_date , poh . revised_date poh_revised_date , substr ( substr ( poh . document_buyer_first_name , 1 , 1 ) || ' ' || poh . document_buyer_last_name , 1 , 12 ) poh_buyer , substr ( trim ( substr ( poh . archive_buyer_first_name , 1 , 1 ) || ' ' || poh . archive_buyer_last_name ) , 1 , 12 ) poh_archive_buyer , poh . document_buyer_agent_id poh_agent_id , poh . payment_terms poh_payment_terms , poh . ship_via poh_ship_via , poh . fob poh_fob , poh . freight_terms poh_freight_terms , substr ( poh . vendor_contact_first_name , 1 , 1 ) || ' ' || substr ( poh . vendor_contact_last_name , 1 , 10 ) poh_vendor_contact_name , poh . vendor_phone poh_vendor_phone , poh . vendor_contact_phone poh_vendor_contact_phone , poh . note_to_vendor poh_note_to_vendor , poh . printed_date poh_printed_date , poh . amount_agreed poh_amount_agreed , poh . cancel_flag poh_cancel_flag , poh . confirming_order_flag poh_confirming_order_flag , poh . acceptance_required_flag poh_acceptance_req_flag , poh . acceptance_due_date poh_acceptance_due_date , poh . currency_code poh_currency_code , poh . currency_code C_CURRENCY , poh . currency_name poh_currency_name , poh . currency_conversion_rate poh_currency_conversion_rate , poh . bill_to_location_id poh_bill_to_location , poh . ship_to_location_id poh_ship_to_location , poh . po_header_id poh_po_header_id , poh . po_release_id poh_po_release_id , poh . po_type poh_po_type , poh . approved_flag poh_approved_flag , poh . print_count poh_print_count , poh . effective_date poh_effective_date , poh . expiration_date poh_expiration_date , nvl ( poh . po_release_id , - 1 ) poh_join_release_id , poh . vendor_site_id poh_vendor_site_id , poh . vendor_id poh_vendor_id FROM po_headers_print poh , po_releases por WHERE poh . po_release_id = por . po_release_id (+) AND ( nvl ( por . release_num , - 1 ) BETWEEN nvl ( : P_release_num_from , nvl ( por . release_num , - 1 ) ) AND nvl ( : P_release_num_to , nvl ( por . release_num , - 1 ) ) OR poh . po_type != 'RELEASE' ) AND poh . document_buyer_agent_id = nvl ( : P_agent_id , poh . document_buyer_agent_id ) AND ( poh . release_date is NULL OR trunc ( poh . release_date ) BETWEEN nvl ( : P_date_from , trunc ( poh . release_date ) ) AND nvl ( : P_date_to , trunc ( poh . release_date ) + 1 ) ) AND nvl ( poh . approved_flag , 'N' ) = nvl ( : P_approved_flag , nvl ( poh . approved_flag , 'N' ) ) AND ( ( nvl ( : P_print_releases , 'Y' ) = 'Y' ) or ( nvl ( : P_print_releases , 'Y' ) = 'N' and poh . po_type != 'RELEASE' ) ) AND nvl ( poh . consigned_consumption_flag , 'N' ) <> 'Y' AND nvl ( por . consigned_consumption_flag , 'N' ) <> 'Y' AND :P_single_po_print = 1 AND po_num = :P_po_num_from AND nvl(poh.print_ count, 0) =0 AND poh.approved_flag = :P_approved_flag and 1=1 and 1=1 ORDER BY 1 , 2 , 3 , 4
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0wmwsjy9kd92fSELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
15py3q5vknkb9BEGIN PO_REQAPPROVAL_INIT1.Start_WF_Process(ItemType => NULL, ItemKey => NULL, WorkflowProcess => NULL, ActionOriginatedFrom => 'PO_FORM', DocumentID => :1, DocumentNumber => :2, PreparerID => :3, DocumentTypeCode => :4, DocumentSubtype => :5, SubmitterAction => 'APPROVE', forwardToID => :6, forwardFromID => :7, DefaultApprovalPathID => :8, Note => :9, PrintFlag => :10, FaxFlag => :11, FaxNumber => :12, EmailFlag => :13, EmailAddress => :14, CreateSourcingRule => :15, UpdateSourcingRule => :16, ReleaseGenMethod => :17, MassUpdateReleases => :18, RetroactivePriceChange => :19, OrgAssignChange => :20, CommunicatePriceChange => :21, p_xml_flag => :22, FpdsngFlag => :23); END;
16614jtsr33r0begin fnd_date.initialize_with_calendar(:1, null, :2); end;
1cyrp6fh6mp53 SELECT * FROM (SELECT /*+ LEADING(prl) */ prh.requisition_header_id REQUISITION_HEADER_ID , prh.segment1 REQUISITION_NUM , prl.requisition_line_id REQUISITION_LINE_ID , prl.line_num REQUISITION_LINE_NUM , prh.org_id OPERATING_UNIT_ID , nvl(po_moac_utils_pvt.get_ou_shortcode(prh.org_id), po_moac_utils_pvt.get_ou_name(prh.org_id)) ORGANIZATION , prh.type_lookup_code TYPE_LOOKUP_CODE , prl.item_description ITEM_DESCRIPTION , prl.item_id ITEM_ID , msi.concatenated_segments ITEM_NUMBER , prl.item_revision ITEM_REVISION , prl.quantity QUANTITY , prl.need_by_date NEED_BY_DATE , prl.category_id CATEGORY_ID , mc.concatenated_segments CATEGORY , prl.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE , prl.unit_price REQ_UNIT_PRICE , DECODE (prl.rfq_required_flag, 'Y', 'RfqRequiredY', 'RfqRequiredN') RFQ_REQUIRED , NVL(prl.rfq_required_flag, 'N') RFQ_REQUIRED_FLAG , NVL(prl.on_rfq_flag, 'N') ON_RFQ_FLAG , NVL(prl.drop_ship_flag, 'N') DROP_SHIP_FLAG , prl.suggested_vendor_name SUGGESTED_VENDOR_NAME , prl.vendor_id VENDOR_ID , prl.suggested_vendor_location SUGGESTED_VENDOR_LOC , prl.vendor_site_id VENDOR_SITE_ID , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) REQ_AMOUNT , req_sob.currency_code REQ_CURRENCY_CODE , prl.bid_line_number BID_LINE_NUMBER , prl.bid_number BID_NUMBER , prl.suggested_buyer_id SUGGESTED_BUYER_ID , buyer.full_name SUGGESTED_BUYER , prh.creation_date CREATION_DATE , prl.currency_code FOREIGN_CURRENCY_CODE , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.currency_amount, 'RATE', prl.currency_amount, prl.quantity * prl.currency_unit_price) FOREIGN_CURRENCY_AMT , decode(pltb.purchase_basis, 'GOODS', prl.currency_unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.currency_unit_price) , 'TEMP LABOR', prl.currency_unit_price ) FOREIGN_CURRENCY_UNIT_PRICE , prl.deliver_to_location_id DELIVER_TO_LOCATION_ID , NVL(deliver_hrtl.location_code, SUBSTRB(rtrim(deliver_hz.address1)||'-'||rtrim(deliver_hz.city), 1, 20)) DELIVER_TO_LOCATION , prl.destination_organization_id DESTINATION_ORGANIZATION_ID , dst_hou.name DESTINATION_ORGANIZATION , prl.destination_subinventory DESTINATION_SUBINVENTORY , prl.destination_type_code DESTINATION_TYPE_CODE , NVL(deliver_hr.ship_to_location_id, deliver_hz.location_id) SHIP_TO_LOCATION_ID , prh.emergency_po_num EMERGENCY_PO_NUM , prh.emergency_po_org_id EMERGENCY_PO_ORG_ID , DECODE(prl.encumbered_flag, 'Y', 'EncumberedY', 'EncumberedN') ENCUMBERED , NVL(prl.encumbered_flag, 'N') ENCUMBERED_FLAG , prl.assignment_end_date ASSIGNMENT_END_DATE , prl.candidate_first_name CANDIDATE_FIRST_NAME , prl.suggested_vendor_contact SUGGESTED_VENDOR_CONTACT , prl.hazard_class_id HAZARD_CLASS_ID , prh.interface_source_code IMPORT_SOURCE_CODE , prl.job_id JOB_ID , prl.justification JUSTIFICATION , prl.candidate_last_name CANDIDATE_LAST_NAME , DECODE(SIGN(SYSDATE - NVL(prl.need_by_date, SYSDATE) - NVL(msi.full_lead_time, 0)), 1, 'Y', 'N') LATE_FLAG , DECODE(prl.modified_by_agent_flag, 'Y', 'ModifiedY', 'ModifiedN') MODIFIED , prl.auction_line_number NEGOTIATION_LINE_NUMBER , prl.auction_display_number NEGOTIATION_NUMBER , prl.note_to_agent NOTE_TO_BUYER , prl.note_to_receiver NOTE_TO_RECEIVER , prl.wip_operation_seq_num OPERATION_SEQUENCE , prl.wip_repetitive_schedule_id REPETITIVE_SCHEDULE_ID , DECODE(NVL(prl.pcard_flag, 'N'), 'N', TO_NUMBER(NULL), 'S', -99999, prh.pcard_id) PCARD_ID , prl.suggested_vendor_phone SUGGESTED_VENDOR_PHONE , prl.preferred_grade PREFERRED_GRADE , preparer.full_name PREPARER , prh.preparer_id PREPARER_ID , prl.quantity_received QUANTITY_RECEIVED , prl.rate FOREIGN_CURRENCY_RATE , prl.rate_date FOREIGN_CURRENCY_RATE_DATE , prl.rate_type FOREIGN_CURRENCY_RATE_TYPE , prl.reference_num REFERENCE_NUM , requester.full_name REQUESTER , prl.to_person_id R EQUESTER_ID , prh.description REQUISITION_DESCRIPTION , prl.bom_resource_id BOM_RESOURCE_ID , prl.wip_resource_seq_num RESOURCE_SEQUENCE , prl.secondary_quantity SECONDARY_QUANTITY , prl.secondary_unit_of_measure SECONDARY_UNIT_OF_MEASURE , prl.blanket_po_line_num SOURCE_DOCUMENT_LINE , src_doc.segment1 SOURCE_DOCUMENT_NUM , prl.blanket_po_header_id SOURCE_DOCUMENT_ID , src_doc.org_id SOURCE_DOCUMENT_ORG_ID , prl.document_type_code SOURCE_DOC_TYPE_CODE , NVL(src_doc.global_agreement_flag, 'N') GLOBAL_FLAG , DECODE (src_doc.global_agreement_flag, 'Y', 'GlobalY', 'GlobalN') GLOBAL , DECODE (prl.blanket_po_header_id, NULL, 'N', 'Y') REQ_SOURCED_FLAG , prl.oke_contract_header_id OKE_CONTRACT_HEADER_ID , prl.assignment_start_date ASSIGNMENT_START_DATE , DECODE (prl.new_supplier_flag, 'Y', 'NewSupplierY', 'NewSupplierN') NEW_SUPPLIER , NVL(prl.new_supplier_flag, 'N') NEW_SUPPLIER_FLAG , prl.supplier_ref_number SUPPLIER_CONFIG_ID , prl.suggested_vendor_contact_email SUGGESTED_VENDOR_EMAIL , prl.suggested_vendor_contact_fax SUGGESTED_VENDOR_FAX , prl.suggested_vendor_product_code SUPPLIER_ITEM , prl.ussgl_transaction_code TRANSACTION_CODE , prl.transaction_reason_code TRANSACTION_REASON , plttl.line_type LINE_TYPE_DSP , pltb.line_type_id LINE_TYPE_ID , pltb.order_type_lookup_code ORDER_TYPE_LOOKUP_CODE , pltb.purchase_basis PURCHASE_BASIS , pltb.matching_basis MATCHING_BASIS , prl.labor_req_line_id LABOR_REQ_LINE_ID , DECODE (prl.suggested_buyer_id, NULL, 'Y', 'N') UNASSIGNED_FLAG , prl.un_number_id UN_NUMBER_ID , DECODE (prl.urgent_flag, 'Y', 'UrgentY', 'UrgentN') URGENT , NVL(prl.urgent_flag, 'N') URGENT_FLAG , DECODE (prl.vmi_flag, 'Y', 'VmiY', 'VmiN') VMI , NVL(prl.vmi_flag, 'N') VMI_FLAG , prl.wip_entity_id WIP_ENTITY_ID , prl.wip_line_id WIP_LINE_ID , NVL(prh.authorization_status, 'INCOMPLETE') AUTHORIZATION_STATUS , prl.attribute_category ATTRIBUTE_CATEGORY , prl.attribute1 ATTRIBUTE1 , prl.attribute2 ATTRIBUTE2 , prl.attribute3 ATTRIBUTE3 , prl.attribute4 ATTRIBUTE4 , prl.attribute5 ATTRIBUTE5 , prl.attribute6 ATTRIBUTE6 , prl.attribute7 ATTRIBUTE7 , prl.attribute8 ATTRIBUTE8 , prl.attribute9 ATTRIBUTE9 , prl.attribute10 ATTRIBUTE10 , prl.attribute11 ATTRIBUTE11 , prl.attribute12 ATTRIBUTE12 , prl.attribute13 ATTRIBUTE13 , prl.attribute14 ATTRIBUTE14 , prl.attribute15 ATTRIBUTE15 , req_fsp.inventory_organization_id BASE_INV_ORGANIZATION_ID , prl.auction_header_id AUCTION_HEADER_ID , prh.segment1 ||', ' || prl.line_num REQUEST , nvl( msi.concatenated_segments, prl.item_description) ITEM , decode(pltb.purchase_basis, 'GOODS', prl.unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.unit_price) , 'TEMP LABOR', prl.unit_price ) PRICE , prl.vendor_contact_id VENDOR_CONTACT_ID , prl.PARENT_REQ_LINE_ID , prl.source_type_code , ( SELECT 'Y' FROM dual WHERE exists ( SELECT 'Y' FROM po_req_distributions_all prd WHERE prd.requisition_line_id=prl.requisition_line_id AND prd.award_id is not null ) )AWARD_EXISTS , prl.kanban_card_id , src_doc.style_id SOURCE_DOCUMENT_STYLE_ID , src_doc_line.po_line_id SOURCE_DOCUMENT_LINE_ID FROM po_requisition_headers_all prh, po_requisition_lines prl, hr_all_organization_units_tl hou, po_line_types_tl plttl, po_line_types_b pltb, po_headers_all src_doc, po_lines_all src_doc_line, hr_all_organization_units_tl dst_hou, mtl_system_items_b_kfv msi, mtl_categories_kfv mc, per_all_people_f buyer, per_all_people_f requester, per_all_people_f preparer, hr_locations_all_tl deliver_hrtl, hr_locations_all deliver_hr, hz_locations deliver_hz, financials_system_params_all req_fsp, gl_sets_of_books req_sob WHERE prl.requisition_header_id = prh.requisition_header_id AND hou.organization_id (+) = prl.org_id AND req_fsp.org_id = prl.org_id AND hou.language (+) = userenv('LANG') AND pltb.line_type_id = prl.line_type_id AND plttl.line_type_id = pltb.line_type_ id AND plttl.language = userenv('LANG') AND src_doc.po_header_id (+) = prl.blanket_po_header_id AND src_doc_line.po_header_id(+) = prl.blanket_po_header_id AND src_doc_line.line_num(+) = prl.blanket_po_line_num AND dst_hou.organization_id (+) = prl.destination_organization_id AND dst_hou.language (+) = userenv('LANG') AND msi.inventory_item_id (+) = prl.item_id AND msi.organization_id (+) = prl.destination_organization_id AND mc.category_id = prl.category_id AND buyer.person_id (+) = prl.suggested_buyer_id AND TRUNC(sysdate) BETWEEN buyer.effective_start_date(+) AND buyer.effective_end_date(+) AND requester.person_id = prl.to_person_id AND TRUNC(sysdate) BETWEEN requester.effective_start_date AND requester.effective_end_date AND preparer.person_id = prh.preparer_id AND TRUNC(sysdate) BETWEEN preparer.effective_start_date AND preparer.effective_end_date AND deliver_hr.location_id(+) = prl.deliver_to_location_id AND deliver_hrtl.location_id (+) = deliver_hr.location_id AND deliver_hrtl.language (+) = USERENV('LANG') AND deliver_hz.location_id(+) = prl.deliver_to_location_id AND req_fsp.set_of_books_id = req_sob.set_of_books_id AND prl.reqs_in_pool_flag = 'Y' AND ( NOT (pltb.order_type_lookup_code = 'RATE' AND pltb.purchase_basis = 'TEMP LABOR' AND EXISTS (SELECT 'Corresponding expense line not in pool' FROM po_requisition_lines_all expense_line WHERE expense_line.labor_req_line_id = prl.requisition_line_id AND expense_line.reqs_in_pool_flag is null))) AND ( NOT (pltb.order_type_lookup_code = 'FIXED PRICE' AND pltb.purchase_basis = 'SERVICES' AND EXISTS (SELECT 'Corresponding labor line not in pool' FROM po_requisition_lines_all labor_line WHERE labor_line.requisition_line_id = prl.labor_req_line_id AND labor_line.reqs_in_pool_flag is null))) AND NVL(prh.authorization_status, 'INCOMPLETE') NOT IN ('SYSTEM_SAVED', 'RETURNED') AND prl.requisition_line_id NOT IN (SELECT doc_builder.index_num1 FROM po_session_gt doc_builder WHERE doc_builder.key = :1) AND DECODE(FND_PROFILE.VALUE('PO_AUTOCREATE_ALLOW_BUYER_OVERRIDE'), 'Y', FND_GLOBAL.EMPLOYEE_ID, 'N', PRL.SUGGESTED_BUYER_ID, FND_GLOBAL.EMPLOYEE_ID)=FND_GLOBAL.EMPLOYEE_ID) QRSLT WHERE (requisition_line_id IN ( SELECT selected_req_lines.index_num1 FROM po_session_gt selected_req_lines WHERE selected_req_lines.key = :2 )) ORDER BY CREATION_DATE desc, ORGANIZATION, TO_NUMBER(REQUISITION_NUM) DESC, REQUISITION_LINE_NUM DESC
2450j0nxcnga5declare sql_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, sql_dummy1, :org_id, :server_id);end;
327r1ynryuzvwbegin PO_REQAPPROVAL_ACTION.APPROVE_DOC (:v1, :v2, :v3, :v4, :v5); end;
37kp7bjxfn4u5SELECT NLS_DATE_LANGUAGE FROM (SELECT UTF8_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 UNION SELECT LOCAL_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) NOT IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 )
3h1rjtcff3wy1BEGIN ordsys.CARTRIDGE.dbms_feature_multimedia(:feature_boolean, :aux_cnt, :feature_info); END;
3mhu25sfw466xbegin :1 := POR_UTIL_PKG.submitreq(:2, :3, :4, :5, :6); end;
3v6p5sm1dkafz SELECT * FROM (SELECT /*+ LEADING(prl) */ prh.requisition_header_id REQUISITION_HEADER_ID , prh.segment1 REQUISITION_NUM , prl.requisition_line_id REQUISITION_LINE_ID , prl.line_num REQUISITION_LINE_NUM , prh.org_id OPERATING_UNIT_ID , nvl(po_moac_utils_pvt.get_ou_shortcode(prh.org_id), po_moac_utils_pvt.get_ou_name(prh.org_id)) ORGANIZATION , prh.type_lookup_code TYPE_LOOKUP_CODE , prl.item_description ITEM_DESCRIPTION , prl.item_id ITEM_ID , msi.concatenated_segments ITEM_NUMBER , prl.item_revision ITEM_REVISION , prl.quantity QUANTITY , prl.need_by_date NEED_BY_DATE , prl.category_id CATEGORY_ID , mc.concatenated_segments CATEGORY , prl.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE , prl.unit_price REQ_UNIT_PRICE , DECODE (prl.rfq_required_flag, 'Y', 'RfqRequiredY', 'RfqRequiredN') RFQ_REQUIRED , NVL(prl.rfq_required_flag, 'N') RFQ_REQUIRED_FLAG , NVL(prl.on_rfq_flag, 'N') ON_RFQ_FLAG , NVL(prl.drop_ship_flag, 'N') DROP_SHIP_FLAG , prl.suggested_vendor_name SUGGESTED_VENDOR_NAME , prl.vendor_id VENDOR_ID , prl.suggested_vendor_location SUGGESTED_VENDOR_LOC , prl.vendor_site_id VENDOR_SITE_ID , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) REQ_AMOUNT , req_sob.currency_code REQ_CURRENCY_CODE , prl.bid_line_number BID_LINE_NUMBER , prl.bid_number BID_NUMBER , prl.suggested_buyer_id SUGGESTED_BUYER_ID , buyer.full_name SUGGESTED_BUYER , prh.creation_date CREATION_DATE , prl.currency_code FOREIGN_CURRENCY_CODE , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.currency_amount, 'RATE', prl.currency_amount, prl.quantity * prl.currency_unit_price) FOREIGN_CURRENCY_AMT , decode(pltb.purchase_basis, 'GOODS', prl.currency_unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.currency_unit_price) , 'TEMP LABOR', prl.currency_unit_price ) FOREIGN_CURRENCY_UNIT_PRICE , prl.deliver_to_location_id DELIVER_TO_LOCATION_ID , NVL(deliver_hrtl.location_code, SUBSTRB(rtrim(deliver_hz.address1)||'-'||rtrim(deliver_hz.city), 1, 20)) DELIVER_TO_LOCATION , prl.destination_organization_id DESTINATION_ORGANIZATION_ID , dst_hou.name DESTINATION_ORGANIZATION , prl.destination_subinventory DESTINATION_SUBINVENTORY , prl.destination_type_code DESTINATION_TYPE_CODE , NVL(deliver_hr.ship_to_location_id, deliver_hz.location_id) SHIP_TO_LOCATION_ID , prh.emergency_po_num EMERGENCY_PO_NUM , prh.emergency_po_org_id EMERGENCY_PO_ORG_ID , DECODE(prl.encumbered_flag, 'Y', 'EncumberedY', 'EncumberedN') ENCUMBERED , NVL(prl.encumbered_flag, 'N') ENCUMBERED_FLAG , prl.assignment_end_date ASSIGNMENT_END_DATE , prl.candidate_first_name CANDIDATE_FIRST_NAME , prl.suggested_vendor_contact SUGGESTED_VENDOR_CONTACT , prl.hazard_class_id HAZARD_CLASS_ID , prh.interface_source_code IMPORT_SOURCE_CODE , prl.job_id JOB_ID , prl.justification JUSTIFICATION , prl.candidate_last_name CANDIDATE_LAST_NAME , DECODE(SIGN(SYSDATE - NVL(prl.need_by_date, SYSDATE) - NVL(msi.full_lead_time, 0)), 1, 'Y', 'N') LATE_FLAG , DECODE(prl.modified_by_agent_flag, 'Y', 'ModifiedY', 'ModifiedN') MODIFIED , prl.auction_line_number NEGOTIATION_LINE_NUMBER , prl.auction_display_number NEGOTIATION_NUMBER , prl.note_to_agent NOTE_TO_BUYER , prl.note_to_receiver NOTE_TO_RECEIVER , prl.wip_operation_seq_num OPERATION_SEQUENCE , prl.wip_repetitive_schedule_id REPETITIVE_SCHEDULE_ID , DECODE(NVL(prl.pcard_flag, 'N'), 'N', TO_NUMBER(NULL), 'S', -99999, prh.pcard_id) PCARD_ID , prl.suggested_vendor_phone SUGGESTED_VENDOR_PHONE , prl.preferred_grade PREFERRED_GRADE , preparer.full_name PREPARER , prh.preparer_id PREPARER_ID , prl.quantity_received QUANTITY_RECEIVED , prl.rate FOREIGN_CURRENCY_RATE , prl.rate_date FOREIGN_CURRENCY_RATE_DATE , prl.rate_type FOREIGN_CURRENCY_RATE_TYPE , prl.reference_num REFERENCE_NUM , requester.full_name REQUESTER , prl.to_person_id R EQUESTER_ID , prh.description REQUISITION_DESCRIPTION , prl.bom_resource_id BOM_RESOURCE_ID , prl.wip_resource_seq_num RESOURCE_SEQUENCE , prl.secondary_quantity SECONDARY_QUANTITY , prl.secondary_unit_of_measure SECONDARY_UNIT_OF_MEASURE , prl.blanket_po_line_num SOURCE_DOCUMENT_LINE , src_doc.segment1 SOURCE_DOCUMENT_NUM , prl.blanket_po_header_id SOURCE_DOCUMENT_ID , src_doc.org_id SOURCE_DOCUMENT_ORG_ID , prl.document_type_code SOURCE_DOC_TYPE_CODE , NVL(src_doc.global_agreement_flag, 'N') GLOBAL_FLAG , DECODE (src_doc.global_agreement_flag, 'Y', 'GlobalY', 'GlobalN') GLOBAL , DECODE (prl.blanket_po_header_id, NULL, 'N', 'Y') REQ_SOURCED_FLAG , prl.oke_contract_header_id OKE_CONTRACT_HEADER_ID , prl.assignment_start_date ASSIGNMENT_START_DATE , DECODE (prl.new_supplier_flag, 'Y', 'NewSupplierY', 'NewSupplierN') NEW_SUPPLIER , NVL(prl.new_supplier_flag, 'N') NEW_SUPPLIER_FLAG , prl.supplier_ref_number SUPPLIER_CONFIG_ID , prl.suggested_vendor_contact_email SUGGESTED_VENDOR_EMAIL , prl.suggested_vendor_contact_fax SUGGESTED_VENDOR_FAX , prl.suggested_vendor_product_code SUPPLIER_ITEM , prl.ussgl_transaction_code TRANSACTION_CODE , prl.transaction_reason_code TRANSACTION_REASON , plttl.line_type LINE_TYPE_DSP , pltb.line_type_id LINE_TYPE_ID , pltb.order_type_lookup_code ORDER_TYPE_LOOKUP_CODE , pltb.purchase_basis PURCHASE_BASIS , pltb.matching_basis MATCHING_BASIS , prl.labor_req_line_id LABOR_REQ_LINE_ID , DECODE (prl.suggested_buyer_id, NULL, 'Y', 'N') UNASSIGNED_FLAG , prl.un_number_id UN_NUMBER_ID , DECODE (prl.urgent_flag, 'Y', 'UrgentY', 'UrgentN') URGENT , NVL(prl.urgent_flag, 'N') URGENT_FLAG , DECODE (prl.vmi_flag, 'Y', 'VmiY', 'VmiN') VMI , NVL(prl.vmi_flag, 'N') VMI_FLAG , prl.wip_entity_id WIP_ENTITY_ID , prl.wip_line_id WIP_LINE_ID , NVL(prh.authorization_status, 'INCOMPLETE') AUTHORIZATION_STATUS , prl.attribute_category ATTRIBUTE_CATEGORY , prl.attribute1 ATTRIBUTE1 , prl.attribute2 ATTRIBUTE2 , prl.attribute3 ATTRIBUTE3 , prl.attribute4 ATTRIBUTE4 , prl.attribute5 ATTRIBUTE5 , prl.attribute6 ATTRIBUTE6 , prl.attribute7 ATTRIBUTE7 , prl.attribute8 ATTRIBUTE8 , prl.attribute9 ATTRIBUTE9 , prl.attribute10 ATTRIBUTE10 , prl.attribute11 ATTRIBUTE11 , prl.attribute12 ATTRIBUTE12 , prl.attribute13 ATTRIBUTE13 , prl.attribute14 ATTRIBUTE14 , prl.attribute15 ATTRIBUTE15 , req_fsp.inventory_organization_id BASE_INV_ORGANIZATION_ID , prl.auction_header_id AUCTION_HEADER_ID , prh.segment1 ||', ' || prl.line_num REQUEST , nvl( msi.concatenated_segments, prl.item_description) ITEM , decode(pltb.purchase_basis, 'GOODS', prl.unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.unit_price) , 'TEMP LABOR', prl.unit_price ) PRICE , prl.vendor_contact_id VENDOR_CONTACT_ID , prl.PARENT_REQ_LINE_ID , prl.source_type_code , ( SELECT 'Y' FROM dual WHERE exists ( SELECT 'Y' FROM po_req_distributions_all prd WHERE prd.requisition_line_id=prl.requisition_line_id AND prd.award_id is not null ) )AWARD_EXISTS , prl.kanban_card_id , src_doc.style_id SOURCE_DOCUMENT_STYLE_ID , src_doc_line.po_line_id SOURCE_DOCUMENT_LINE_ID FROM po_requisition_headers_all prh, po_requisition_lines prl, hr_all_organization_units_tl hou, po_line_types_tl plttl, po_line_types_b pltb, po_headers_all src_doc, po_lines_all src_doc_line, hr_all_organization_units_tl dst_hou, mtl_system_items_b_kfv msi, mtl_categories_kfv mc, per_all_people_f buyer, per_all_people_f requester, per_all_people_f preparer, hr_locations_all_tl deliver_hrtl, hr_locations_all deliver_hr, hz_locations deliver_hz, financials_system_params_all req_fsp, gl_sets_of_books req_sob WHERE prl.requisition_header_id = prh.requisition_header_id AND hou.organization_id (+) = prl.org_id AND req_fsp.org_id = prl.org_id AND hou.language (+) = userenv('LANG') AND pltb.line_type_id = prl.line_type_id AND plttl.line_type_id = pltb.line_type_ id AND plttl.language = userenv('LANG') AND src_doc.po_header_id (+) = prl.blanket_po_header_id AND src_doc_line.po_header_id(+) = prl.blanket_po_header_id AND src_doc_line.line_num(+) = prl.blanket_po_line_num AND dst_hou.organization_id (+) = prl.destination_organization_id AND dst_hou.language (+) = userenv('LANG') AND msi.inventory_item_id (+) = prl.item_id AND msi.organization_id (+) = prl.destination_organization_id AND mc.category_id = prl.category_id AND buyer.person_id (+) = prl.suggested_buyer_id AND TRUNC(sysdate) BETWEEN buyer.effective_start_date(+) AND buyer.effective_end_date(+) AND requester.person_id = prl.to_person_id AND TRUNC(sysdate) BETWEEN requester.effective_start_date AND requester.effective_end_date AND preparer.person_id = prh.preparer_id AND TRUNC(sysdate) BETWEEN preparer.effective_start_date AND preparer.effective_end_date AND deliver_hr.location_id(+) = prl.deliver_to_location_id AND deliver_hrtl.location_id (+) = deliver_hr.location_id AND deliver_hrtl.language (+) = USERENV('LANG') AND deliver_hz.location_id(+) = prl.deliver_to_location_id AND req_fsp.set_of_books_id = req_sob.set_of_books_id AND prl.reqs_in_pool_flag = 'Y' AND ( NOT (pltb.order_type_lookup_code = 'RATE' AND pltb.purchase_basis = 'TEMP LABOR' AND EXISTS (SELECT 'Corresponding expense line not in pool' FROM po_requisition_lines_all expense_line WHERE expense_line.labor_req_line_id = prl.requisition_line_id AND expense_line.reqs_in_pool_flag is null))) AND ( NOT (pltb.order_type_lookup_code = 'FIXED PRICE' AND pltb.purchase_basis = 'SERVICES' AND EXISTS (SELECT 'Corresponding labor line not in pool' FROM po_requisition_lines_all labor_line WHERE labor_line.requisition_line_id = prl.labor_req_line_id AND labor_line.reqs_in_pool_flag is null))) AND NVL(prh.authorization_status, 'INCOMPLETE') NOT IN ('SYSTEM_SAVED', 'RETURNED') AND prl.requisition_line_id NOT IN (SELECT doc_builder.index_num1 FROM po_session_gt doc_builder WHERE doc_builder.key = :1) AND DECODE(FND_PROFILE.VALUE('PO_AUTOCREATE_ALLOW_BUYER_OVERRIDE'), 'Y', FND_GLOBAL.EMPLOYEE_ID, 'N', PRL.SUGGESTED_BUYER_ID, FND_GLOBAL.EMPLOYEE_ID)=FND_GLOBAL.EMPLOYEE_ID) QRSLT WHERE ((suggested_buyer_id = :2 AND ship_to_location_id = :3)) ORDER BY CREATION_DATE desc, ORGANIZATION, TO_NUMBER(REQUISITION_NUM) DESC, REQUISITION_LINE_NUM DESC
4kk0bjar3pb7zSELECT PLI.SHIPMENT_NUM , PLI.REQUISITION_LINE_ID FROM PO_LINES_INTERFACE PLI, PO_REQUISITION_LINES_ALL PRL, MTL_SYSTEM_ITEMS MSI , PO_LINE_TYPES PLT , PO_SYSTEM_PARAMETERS_ALL PSP , FINANCIALS_SYSTEM_PARAMS_ALL FSP, PO_VENDORS POV, PO_HEADERS_INTERFACE PHI WHERE PLI.LINE_NUM = :B10 AND PLI.SHIPMENT_NUM IS NOT NULL AND NVL(PSP.ORG_ID, -99) = NVL(:B9 , -99) AND NVL(FSP.ORG_ID, -99) = NVL(:B9 , -99) AND PLI.ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID)= FSP.INVENTORY_ORGANIZATION_ID AND PLI.LINE_TYPE_ID = PLT.LINE_TYPE_ID AND PHI.VENDOR_ID = POV.VENDOR_ID (+) AND PLI.INTERFACE_HEADER_ID = PHI.INTERFACE_HEADER_ID AND PRL.REQUISITION_LINE_ID <> :B8 AND PRL.REQUISITION_LINE_ID = PLI.REQUISITION_LINE_ID AND ( ( TO_CHAR(PLI.NEED_BY_DATE-(TO_NUMBER(SUBSTR(TO_CHAR(PLI.NEED_BY_DATE, 'DD-MM-YYYY HH24:MI:SS'), 18, 2))/86400), 'DD-MM-YYYY HH24:MI:SS') = TO_CHAR(:B7 -(TO_NUMBER(SUBSTR(TO_CHAR(:B7 , 'DD-MM-YYYY HH24:MI:SS'), 18, 2))/86400), 'DD-MM-YYYY HH24:MI:SS') ) OR (PLI.NEED_BY_DATE IS NULL AND :B7 IS NULL) ) AND NVL(PLI.DROP_SHIP_FLAG, 'N') <> 'Y' AND RTRIM(NVL(PLI.NOTE_TO_RECEIVER, '99')) = RTRIM(NVL(:B6 , '99')) AND EXISTS (SELECT 'x' FROM HR_LOCATIONS HRL WHERE PRL.DELIVER_TO_LOCATION_ID = HRL.LOCATION_ID AND NVL(HRL.SHIP_TO_LOCATION_ID, HRL.LOCATION_ID) = :B11 UNION ALL SELECT 'x' FROM HZ_LOCATIONS HZ WHERE PRL.DELIVER_TO_LOCATION_ID = HZ.LOCATION_ID AND HZ.LOCATION_ID = :B11 ) AND PRL.DESTINATION_ORGANIZATION_ID = :B5 AND DECODE(PRL.DESTINATION_TYPE_CODE, 'EXPENSE', DECODE(NVL(MSI.RECEIPT_REQUIRED_FLAG, NVL(PLT.RECEIVING_FLAG, NVL(POV.RECEIPT_REQUIRED_FLAG, NVL(PSP.RECEIVING_FLAG, 'N')))), 'N', 'N', DECODE(PSP.EXPENSE_ACCRUAL_CODE, 'PERIOD END', 'N', 'Y')), 'INVENTORY', 'Y', 'SHOP FLOOR', 'Y') = :B4 AND ( ( PLI.PREFERRED_GRADE IS NULL AND :B3 IS NULL ) OR ( PLI.PREFERRED_GRADE = :B3 ) ) AND NVL(PLI.VMI_FLAG, 'N') = NVL(:B2 , 'N') AND NVL(PLI.CONSIGNED_FLAG, 'N') = NVL(:B1 , 'N') AND ROWNUM = 1
4mj8xhjcnw7gf SELECT "A2"."SHIPMENT_NUM" "SHIPMENT_NUM", "A2"."DUE_DATE" "DUE_DATE", "A2"."QUANTITY" "QUANTITY", "A2"."PRICE_OVERRIDE" "PRICE_OVERRIDE", "A2"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A2"."CANCEL_FLAG" "CANCEL_FLAG", "A2"."CANCEL_DATE" "CANCEL_DATE", "A2"."CANCEL_REASON" "CANCEL_REASON", "A2"."TAXABLE_FLAG" "TAXABLE_FLAG", "A2"."START_DATE" "START_DATE", "A2"."END_DATE" "END_DATE", "A2"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A2"."ATTRIBUTE1" "ATTRIBUTE1", "A2"."ATTRIBUTE2" "ATTRIBUTE2", "A2"."ATTRIBUTE3" "ATTRIBUTE3", "A2"."ATTRIBUTE4" "ATTRIBUTE4", "A2"."ATTRIBUTE5" "ATTRIBUTE5", "A2"."ATTRIBUTE6" "ATTRIBUTE6", "A2"."ATTRIBUTE7" "ATTRIBUTE7", "A2"."ATTRIBUTE8" "ATTRIBUTE8", "A2"."ATTRIBUTE9" "ATTRIBUTE9", "A2"."ATTRIBUTE10" "ATTRIBUTE10", "A2"."ATTRIBUTE11" "ATTRIBUTE11", "A2"."ATTRIBUTE12" "ATTRIBUTE12", "A2"."ATTRIBUTE13" "ATTRIBUTE13", "A2"."ATTRIBUTE14" "ATTRIBUTE14", "A2"."ATTRIBUTE15" "ATTRIBUTE15", "A2"."PO_HEADER_ID" "PO_HEADER_ID", "A2"."PO_LINE_ID" "PO_LINE_ID", "A2"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A2"."SHIPMENT_TYPE" "SHIPMENT_TYPE", "A2"."PO_RELEASE_ID" "PO_RELEASE_ID", "A2"."CONSIGNED_FLAG" "CONSIGNED_FLAG", "A2"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A2"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A2"."RECEIVING_ROUTING_ID" "RECEIVING_ROUTING_ID", "A2"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A2"."CLOSED_REASON" "CLOSED_REASON", "A2"."CLOSED_DATE" "CLOSED_DATE", "A2"."CLOSED_BY" "CLOSED_BY", "A2"."ORG_ID" "ORG_ID", "A2"."UNIT_OF_MEASURE_CLASS" "UNIT_OF_MEASURE_CLASS", "A2"."ENCUMBER_NOW" "ENCUMBER_NOW", "A2"."INSPECTION_REQUIRED_FLAG" "INSPECTION_REQUIRED_FLAG", "A2"."RECEIPT_REQUIRED_FLAG" "RECEIPT_REQUIRED_FLAG", "A2"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A2"."QTY_RCV_EXCEPTION_CODE" "QTY_RCV_EXCEPTION_CODE", "A2"."ENFORCE_SHIP_TO_LOCATION_CODE" "ENFORCE_SHIP_TO_LOCATION_CODE", "A2"."ALLOW_SUBSTITUTE_RECEIPTS_FLAG" "ALLOW_SUBSTITUTE_RECEIPTS_FLAG", "A2"."DAYS_EARLY_RECEIPT_ALLOWED" "DAYS_EARLY_RECEIPT_ALLOWED", "A2"."DAYS_LATE_RECEIPT_ALLOWED" "DAYS_LATE_RECEIPT_ALLOWED", "A2"."RECEIPT_DAYS_EXCEPTION_CODE" "RECEIPT_DAYS_EXCEPTION_CODE", "A2"."INVOICE_CLOSE_TOLERANCE" "INVOICE_CLOSE_TOLERANCE", "A2"."RECEIVE_CLOSE_TOLERANCE" "RECEIVE_CLOSE_TOLERANCE", "A2"."SHIP_TO_ORGANIZATION_ID" "SHIP_TO_ORGANIZATION_ID", "A2"."SOURCE_SHIPMENT_ID " "SOURCE_SHIPMENT_ID", "A2"."CLOSED_CODE" "CLOSED_CODE", "A2"."REQUEST_ID" "REQUEST_ID", "A2"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A2"."PROGRAM_ID" "PROGRAM_ID", "A2"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A2"."LAST_ACCEPT_DATE" "LAST_ACCEPT_DATE", "A2"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A2"."ENCUMBERED_DATE" "ENCUMBERED_DATE", "A2"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A2"."FOB_LOOKUP_CODE" "FOB_LOOKUP_CODE", "A2"."FREIGHT_TERMS_LOOKUP_CODE" "FREIGHT_TERMS_LOOKUP_CODE", "A2"."ESTIMATED_TAX_AMOUNT" "ESTIMATED_TAX_AMOUNT", "A2"."FROM_HEADER_ID" "FROM_HEADER_ID", "A2"."FROM_LINE_ID" "FROM_LINE_ID", "A2"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A2"."LEAD_TIME" "LEAD_TIME", "A2"."LEAD_TIME_UNIT" "LEAD_TIME_UNIT", "A2"."PRICE_DISCOUNT" "PRICE_DISCOUNT", "A2"."TERMS_ID" "TERMS_ID", "A2"."APPROVED_FLAG" "APPROVED_FLAG", "A2"."APPROVED_DATE" "APPROVED_DATE", "A2"."CLOSED_FLAG" "CLOSED_FLAG", "A2"."CANCELLED_BY" "CANCELLED_BY", "A2"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A2"."FIRM_DATE" "FIRM_DATE", "A2"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A2"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A2"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A2"."CREATION_DATE" "CREATION_DATE", "A2"."CREATED_BY" "CREATED_BY", "A2"."QUANTITY_RECEIVED" "QUANTITY_RECEIVED", "A2"."QUANTITY_ACCEPTED" "QUANTITY_ACCEPTED", "A2"."QUANTITY_REJECTED" "QUANTITY_REJECTED", "A2"."QUANTITY_BILLED" "QUANTITY_BILLED", "A2"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A2"."SHIP_VIA_LOOKUP_CODE" "SHIP_VIA_LOOKUP_CODE", "A2"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A2"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A2"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A2"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A2"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A2"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A2"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A2"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A2"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A2"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A2"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A2"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A2"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A2"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A2"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A2"."GLOBAL_ATTRIBUTE15" "GLOBAL_ATTRIBUTE15", "A2"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A2"."GLOBAL _ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A2"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A2"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A2"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A2"."QUANTITY_SHIPPED" "QUANTITY_SHIPPED", "A2"."COUNTRY_OF_ORIGIN_CODE" "COUNTRY_OF_ORIGIN_CODE", "A2"."TAX_USER_OVERRIDE_FLAG" "TAX_USER_OVERRIDE_FLAG", "A2"."MATCH_OPTION" "MATCH_OPTION", "A2"."TAX_CODE_ID" "TAX_CODE_ID", "A2"."CALCULATE_TAX_FLAG" "CALCULATE_TAX_FLAG", "A2"."CHANGE_PROMISED_DATE_REASON" "CHANGE_PROMISED_DATE_REASON", "A2"."NOTE_TO_RECEIVER" "NOTE_TO_RECEIVER", "A2"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A2"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A2"."PREFERRED_GRADE" "PREFERRED_GRADE", "A2"."SECONDARY_QUANTITY_RECEIVED" "SECONDARY_QUANTITY_RECEIVED", "A2"."SECONDARY_QUANTITY_ACCEPTED" "SECONDARY_QUANTITY_ACCEPTED", "A2"."SECONDARY_QUANTITY_REJECTED" "SECONDARY_QUANTITY_REJECTED", "A2"."SECONDARY_QUANTITY_CANCELLED" "SECONDARY_QUANTITY_CANCELLED", "A2"."VMI_FLAG" "VMI_FLAG", "A2"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A2"."SUPPLIER_ORDER_LINE_NUMBER" "SUPPLIER_ORDER_LINE_NUMBER", "A2"."AMOUNT" "AMOUNT", "A2"."AMOUNT_RECEIVED" "AMOUNT_RECEIVED", "A2"."AMOUNT_BILLED" "AMOUNT_BILLED", "A2"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A2"."AMOUNT_ACCEPTED" "AMOUNT_ACCEPTED", "A2"."AMOUNT_REJECTED" "AMOUNT_REJECTED", "A2"."DROP_SHIP_FLAG" "DROP_SHIP_FLAG", "A2"."SALES_ORDER_UPDATE_DATE" "SALES_ORDER_UPDATE_DATE", "A2"."SHIP_TO_LOCATION_ID" "SHIP_TO_LOCATION_ID", "A2"."SHIP_TO_LOCATION_NAME" "SHIP_TO_LOCATION_NAME", "A2"."SHIP_TO_ADDRESS_LINE1" "SHIP_TO_ADDRESS_LINE1", "A2"."SHIP_TO_ADDRESS_LINE2" "SHIP_TO_ADDRESS_LINE2", "A2"."SHIP_TO_ADDRESS_LINE3" "SHIP_TO_ADDRESS_LINE3", "A2"."SHIP_TO_ADDRESS_LINE4" "SHIP_TO_ADDRESS_LINE4", "A2"."SHIP_TO_ADDRESS_INFO" "SHIP_TO_ADDRESS_INFO", "A2"."SHIP_TO_COUNTRY" "SHIP_TO_COUNTRY", "A2"."IS_SHIPMENT_ONE_TIME_LOC" "IS_SHIPMENT_ONE_TIME_LOC", "A2"."ONE_TIME_ADDRESS_DETAILS" "ONE_TIME_ADDRESS_DETAILS", "A2"."DETAILS" "DETAILS", "A2"."SHIP_CONT_PHONE" "SHIP_CONT_PHONE", "A2"."SHIP_CONT_EMAIL" "SHIP_CONT_EMAIL", "A2"."ULTIMATE_DELIVER_CONT_PHONE" "ULTIMATE_DELIVER_CONT_PHONE", "A2"."ULTIMATE_DELIVER_CONT_EMAIL" "ULTIMATE_DELIVER_CONT_EMAIL", "A2"."SHIP_CONT_NAME" "SHIP_CONT_NAME", "A2"."ULTIMATE_DELIVER_CONT_NAME" "ULTIMATE_DELIVER_CONT_NAME", "A2"."SHIP_CUST_NAME" "SHIP_CUST_NAME", "A2"."SHIP_CUST_LOCATION" "SHIP_CUST_LOCATION", "A2"."ULTIMATE_DELIVER_CUST_NAME" "ULTIMATE_DELIVER_CUST_NAME", "A2"."ULTIMATE_DELIV ER_CUST_LOCATION" "ULTIMATE_DELIVER_CUST_LOCATION", "A2"."SHIP_TO_CONTACT_FAX" "SHIP_TO_CONTACT_FAX", "A2"."ULTIMATE_DELIVER_TO_CONT_NAME" "ULTIMATE_DELIVER_TO_CONT_NAME", "A2"."ULTIMATE_DELIVER_TO_CONT_FAX" "ULTIMATE_DELIVER_TO_CONT_FAX", "A2"."SHIPPING_METHOD" "SHIPPING_METHOD", "A2"."SHIPPING_INSTRUCTIONS" "SHIPPING_INSTRUCTIONS", "A2"."PACKING_INSTRUCTIONS" "PACKING_INSTRUCTIONS", "A2"."CUSTOMER_PRODUCT_DESC" "CUSTOMER_PRODUCT_DESC", "A2"."CUSTOMER_PO_NUM" "CUSTOMER_PO_NUM", "A2"."CUSTOMER_PO_LINE_NUM" "CUSTOMER_PO_LINE_NUM", "A2"."CUSTOMER_PO_SHIPMENT_NUM" "CUSTOMER_PO_SHIPMENT_NUM", "A2"."NEED_BY_DATE" "NEED_BY_DATE", "A2"."PROMISED_DATE" "PROMISED_DATE", "A2"."TOTAL_SHIPMENT_AMOUNT" "TOTAL_SHIPMENT_AMOUNT", "A2"."FINAL_MATCH_FLAG" "FINAL_MATCH_FLAG", "A2"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A2"."TAX_NAME" "TAX_NAME", "A2"."TRANSACTION_FLOW_HEADER_ID" "TRANSACTION_FLOW_HEADER_ID", "A2"."VALUE_BASIS" "VALUE_BASIS", "A2"."MATCHING_BASIS" "MATCHING_BASIS", "A2"."PAYMENT_TYPE" "PAYMENT_TYPE", "A2"."DESCRIPTION" "DESCRIPTION", "A2"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A2"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A2"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A2"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A2"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A2"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT", "A2"."WORK_APPROVER_ID" "WORK_APPROVER_ID", "A2"."BID_PAYMENT_ID" "BID_PAYMENT_ID", "A2"."AMOUNT_SHIPPED" "AMOUNT_SHIPPED", CURSOR (SELECT "A2"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A59"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A60", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A59" WHERE "A60"."ENTITY_NAME"='PO_SHIPMENTS' AND "A60"."PK1_VALUE"=TO_CHAR("A2"."LINE_LOCATION_ID") AND "A60"."FUNCTION_NAME"='PO_PRINTPO' AND "A60"."MEDIA_ID"="A59"."MEDIA_ID" AND "A60"."DATATYPE_ID"=1 ORDER BY "A60"."SEQ_NUM") "LINE_LOC_SHORT_TEXT", CURSOR (SELECT "A58"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A58" WHERE "A58"."ENTITY_NAME"='PO_SHIPMENTS' AND "A58"."PK1_VALUE"=TO_CHAR("A2"."LINE_LOCATION_ID") AND "A58"."DATATYPE_ID"=5 AND "A58"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A58"."SEQ_NUM") "LINE_LOC_URL_ATTACHMENTS", CURSOR (SELECT "A57"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A57" WHERE "A57"."ENTITY_NAME"='PO_SHIPMENTS' AND "A57"."PK1_VALUE"=TO_CHAR("A2"."LINE_LOCATION_ID") AND "A57"."DATATYPE_ID"=6 AND "A57"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A57". "SEQ_NUM") "LINE_LOC_FILE_ATTACHMENTS", CURSOR (SELECT "A56"."AMOUNT_ORDERED" "AMOUNT_ORDERED", "A56"."AMOUNT_DELIVERED" "AMOUNT_DELIVERED", "A56"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A56"."DISTRIBUTION_TYPE" "DISTRIBUTION_TYPE", "A56"."AMOUNT_TO_ENCUMBER" "AMOUNT_TO_ENCUMBER", "A56"."INVOICE_ADJUSTMENT_FLAG" "INVOICE_ADJUSTMENT_FLAG", "A56"."DEST_CHARGE_ACCOUNT_ID" "DEST_CHARGE_ACCOUNT_ID", "A56"."DEST_VARIANCE_ACCOUNT_ID" "DEST_VARIANCE_ACCOUNT_ID", "A56"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A56"."PROJECT_ID" "PROJECT_ID", "A56"."TASK_ID" "TASK_ID", "A56"."EXPENDITURE_TYPE" "EXPENDITURE_TYPE", "A56"."PROJECT_ACCOUNTING_CONTEXT" "PROJECT_ACCOUNTING_CONTEXT", "A56"."EXPENDITURE_ORGANIZATION_ID" "EXPENDITURE_ORGANIZATION_ID", "A56"."GL_CLOSED_DATE" "GL_CLOSED_DATE", "A56"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A56"."EXPENDITURE_ITEM_DATE" "EXPENDITURE_ITEM_DATE", "A56"."ORG_ID" "ORG_ID", "A56"."GL_ENCUMBERED_PERIOD_NAME" "GL_ENCUMBERED_PERIOD_NAME", "A56"."GL_CANCELLED_DATE" "GL_CANCELLED_DATE", "A56"."DESTINATION_TYPE_CODE" "DESTINATION_TYPE_CODE", "A56"."DESTINATION_ORGANIZATION_ID" "DESTINATION_ORGANIZATION_ID", "A56"."DESTINATION_SUBINVENTORY" "DESTINATION_SUBINVENTORY", "A56"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A56"."ATTRIBUTE1" "ATTRIBUTE1", "A56"."ATTRIBUTE2" "ATTRIBUTE2", "A56"."ATTRIBUTE3" "ATTRIBUTE3", "A56"."ATTRIBUTE4" "ATTRIBUTE4", "A56"."ATTRIBUTE5" "ATTRIBUTE5", "A56"."ATTRIBUTE6" "ATTRIBUTE6", "A56"."ATTRIBUTE7" "ATTRIBUTE7", "A56"."ATTRIBUTE8" "ATTRIBUTE8", "A56"."ATTRIBUTE9" "ATTRIBUTE9", "A56"."ATTRIBUTE10" "ATTRIBUTE10", "A56"."ATTRIBUTE11" "ATTRIBUTE11", "A56"."ATTRIBUTE12" "ATTRIBUTE12", "A56"."ATTRIBUTE13" "ATTRIBUTE13", "A56"."ATTRIBUTE14" "ATTRIBUTE14", "A56"."ATTRIBUTE15" "ATTRIBUTE15", "A56"."WIP_ENTITY_ID" "WIP_ENTITY_ID", "A56"."WIP_OPERATION_SEQ_NUM" "WIP_OPERATION_SEQ_NUM", "A56"."WIP_RESOURCE_SEQ_NUM" "WIP_RESOURCE_SEQ_NUM", "A56"."WIP_REPETITIVE_SCHEDULE_ID" "WIP_REPETITIVE_SCHEDULE_ID", "A56"."WIP_LINE_ID" "WIP_LINE_ID", "A56"."BOM_RESOURCE_ID" "BOM_RESOURCE_ID", "A56"."BUDGET_ACCOUNT_ID" "BUDGET_ACCOUNT_ID", "A56"."ACCRUAL_ACCOUNT_ID" "ACCRUAL_ACCOUNT_ID", "A56"."VARIANCE_ACCOUNT_ID" "VARIANCE_ACCOUNT_ID", "A56"."PREVENT_ENCUMBRANCE_FLAG" "PREVENT_ENCUMBRANCE_FLAG", "A56"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A56"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A56"."PO_DISTRIBUTION_ID" "PO_DISTRIBUTION_ID ", "A56"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A56"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A56"."PO_HEADER_ID" "PO_HEADER_ID", "A56"."PO_LINE_ID" "PO_LINE_ID", "A56"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A56"."SET_OF_BOOKS_ID" "SET_OF_BOOKS_ID", "A56"."CODE_COMBINATION_ID" "CODE_COMBINATION_ID", "A56"."QUANTITY_ORDERED" "QUANTITY_ORDERED", "A56"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A56"."CREATION_DATE" "CREATION_DATE", "A56"."CREATED_BY" "CREATED_BY", "A56"."PO_RELEASE_ID" "PO_RELEASE_ID", "A56"."QUANTITY_DELIVERED" "QUANTITY_DELIVERED", "A56"."QUANTITY_BILLED" "QUANTITY_BILLED", "A56"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A56"."REQ_HEADER_REFERENCE_NUM" "REQ_HEADER_REFERENCE_NUM", "A56"."REQ_LINE_REFERENCE_NUM" "REQ_LINE_REFERENCE_NUM", "A56"."REQ_DISTRIBUTION_ID" "REQ_DISTRIBUTION_ID", "A56"."DELIVER_TO_LOCATION_ID" "DELIVER_TO_LOCATION_ID", "A56"."DELIVER_TO_PERSON_ID" "DELIVER_TO_PERSON_ID", "A56"."RATE_DATE" "RATE_DATE", "A56"."RATE" "RATE", "A56"."AMOUNT_BILLED" "AMOUNT_BILLED", "A56"."ACCRUED_FLAG" "ACCRUED_FLAG", "A56"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A56"."ENCUMBERED_AMOUNT" "ENCUMBERED_AMOUNT", "A56"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A56"."UNENCUMBERED_AMOUNT" "UNENCUMBERED_AMOUNT", "A56"."FAILED_FUNDS_LOOKUP_CODE" "FAILED_FUNDS_LOOKUP_CODE", "A56"."GL_ENCUMBERED_DATE" "GL_ENCUMBERED_DATE", "A56"."KANBAN_CARD_ID" "KANBAN_CARD_ID", "A56"."END_ITEM_UNIT_NUMBER" "END_ITEM_UNIT_NUMBER", "A56"."AWARD_ID" "AWARD_ID", "A56"."MRC_RATE_DATE" "MRC_RATE_DATE", "A56"."MRC_RATE" "MRC_RATE", "A56"."MRC_ENCUMBERED_AMOUNT" "MRC_ENCUMBERED_AMOUNT", "A56"."MRC_UNENCUMBERED_AMOUNT" "MRC_UNENCUMBERED_AMOUNT", "A56"."RECOVERABLE_TAX" "RECOVERABLE_TAX", "A56"."NONRECOVERABLE_TAX" "NONRECOVERABLE_TAX", "A56"."RECOVERY_RATE" "RECOVERY_RATE", "A56"."TAX_RECOVERY_OVERRIDE_FLAG" "TAX_RECOVERY_OVERRIDE_FLAG", "A56"."OKE_CONTRACT_LINE_ID" "OKE_CONTRACT_LINE_ID", "A56"."OKE_CONTRACT_DELIVERABLE_ID" "OKE_CONTRACT_DELIVERABLE_ID", "A56"."DESTINATION_CONTEXT" "DESTINATION_CONTEXT", "A56"."DISTRIBUTION_NUM" "DISTRIBUTION_NUM", "A56"."SOURCE_DISTRIBUTION_ID" "SOURCE_DISTRIBUTION_ID", "A56"."REQUEST_ID" "REQUEST_ID", "A56"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A56"."PROGRAM_ID" "PROGRAM_ID", "A56"."CHARGE_ACCOUNT" "CHARGE_ACCOUNT", "A56"."FULL_NAME" "FULL_NAME", "A56"."WORK_TELEPHONE" "WORK_TELEPHONE", "A56"."EMAIL_ADDRESS" "EMAIL_ADDRESS", "A56"."REQUESTER_DELIVER_FIRST_NAME" "REQUESTER_DELIVER_FIRST_NAME", "A56"."REQUESTER_DELIVER_LAST_NAME" "REQUESTER_DELIVER_LAST_NAME", "A56"."REQUESTER_DELIVER_TITLE" "REQUESTER_DELIVER_TITLE", "A56"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A56"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A56"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A56"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A56"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A56"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT" FROM "PO_DISTRIBUTION_XML" "A56" WHERE "A56"."PO_HEADER_ID"=:CV1$$ AND "A56"."LINE_LOCATION_ID"="A2"."LINE_LOCATION_ID") "DISTRIBUTIONS" FROM "PO_LINE_LOCATIONS_XML" "A2" WHERE "A2"."PO_LINE_ID"=:CV1$ AND NVL("A2"."PAYMENT_TYPE", 'NONE')<>'ADVANCE' AND NVL("A2"."PAYMENT_TYPE", 'NONE')<>'DELIVERY'
4z510cva9wzsv SELECT decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_last_name ) , decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_first_name ) , decode ( : po_num_type , 'NUMERIC' , null , poh . po_num ) , decode ( : po_num_type , 'NUMERIC' , decode ( rtrim ( poh . po_num , '0123456789' ) , NULL , to_number ( poh . po_num ) , - 1 ) , null ) , poh . po_type poh_po_type , por . release_type poh_release_type , poh . po_num || decode ( poh . po_type , 'RELEASE' , '-' || por . release_num , null ) poh_po_num , poh . po_num security_poh_po_num , por . release_num security_por_po_num , poh . revision_num poh_revision_num , poh . vendor_name poh_vendor_name , poh . vendor_address_line1 poh_vendor_address_line1 , poh . vendor_address_line2 poh_vendor_address_line2 , poh . vendor_address_line3 poh_vendor_address_line3 , decode ( poh . vendor_city , null , poh . vendor_state || ' ' || poh . vendor_postal_code , poh . vendor_city || ', ' || poh . vendor_state || ' ' || poh . vendor_postal_code ) poh_vendor_adr_info , poh . vendor_country poh_vendor_country , poh . customer_num poh_customer , poh . vendor_num poh_vendor_num , poh . creation_date poh_creation_date , poh . revised_date poh_revised_date , substr ( substr ( poh . document_buyer_first_name , 1 , 1 ) || ' ' || poh . document_buyer_last_name , 1 , 12 ) poh_buyer , substr ( trim ( substr ( poh . archive_buyer_first_name , 1 , 1 ) || ' ' || poh . archive_buyer_last_name ) , 1 , 12 ) poh_archive_buyer , poh . document_buyer_agent_id poh_agent_id , poh . payment_terms poh_payment_terms , poh . ship_via poh_ship_via , poh . fob poh_fob , poh . freight_terms poh_freight_terms , substr ( poh . vendor_contact_first_name , 1 , 1 ) || ' ' || substr ( poh . vendor_contact_last_name , 1 , 10 ) poh_vendor_contact_name , poh . vendor_phone poh_vendor_phone , poh . vendor_contact_phone poh_vendor_contact_phone , poh . note_to_vendor poh_note_to_vendor , poh . printed_date poh_printed_date , poh . amount_agreed poh_amount_agreed , poh . cancel_flag poh_cancel_flag , poh . confirming_order_flag poh_confirming_order_flag , poh . acceptance_required_flag poh_acceptance_req_flag , poh . acceptance_due_date poh_acceptance_due_date , poh . currency_code poh_currency_code , poh . currency_code C_CURRENCY , poh . currency_name poh_currency_name , poh . currency_conversion_rate poh_currency_conversion_rate , poh . bill_to_location_id poh_bill_to_location , poh . ship_to_location_id poh_ship_to_location , poh . po_header_id poh_po_header_id , poh . po_release_id poh_po_release_id , poh . po_type poh_po_type , poh . approved_flag poh_approved_flag , poh . print_count poh_print_count , poh . effective_date poh_effective_date , poh . expiration_date poh_expiration_date , nvl ( poh . po_release_id , - 1 ) poh_join_release_id , poh . vendor_site_id poh_vendor_site_id , poh . vendor_id poh_vendor_id FROM po_headers_print poh , po_releases por WHERE poh . po_release_id = por . po_release_id (+) AND ( nvl ( por . release_num , - 1 ) BETWEEN nvl ( : P_release_num_from , nvl ( por . release_num , - 1 ) ) AND nvl ( : P_release_num_to , nvl ( por . release_num , - 1 ) ) OR poh . po_type != 'RELEASE' ) AND poh . document_buyer_agent_id = nvl ( : P_agent_id , poh . document_buyer_agent_id ) AND ( poh . release_date is NULL OR trunc ( poh . release_date ) BETWEEN nvl ( : P_date_from , trunc ( poh . release_date ) ) AND nvl ( : P_date_to , trunc ( poh . release_date ) + 1 ) ) AND nvl ( poh . approved_flag , 'N' ) = nvl ( : P_approved_flag , nvl ( poh . approved_flag , 'N' ) ) AND ( ( nvl ( : P_print_releases , 'Y' ) = 'Y' ) or ( nvl ( : P_print_releases , 'Y' ) = 'N' and poh . po_type != 'RELEASE' ) ) AND nvl ( poh . consigned_consumption_flag , 'N' ) <> 'Y' AND nvl ( por . consigned_consumption_flag , 'N' ) <> 'Y' AND :P_single_po_print = 1 AND po_num = :P_po_num_from AND nvl(poh.print_ count, 0) = 0 AND NOT EXISTS (SELECT 'X' from ECE_TP_DETAILS ETD, ECE_TP_HEADERS ETH, PO_VENDOR_SITES E_PVS WHERE E_PVS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID AND ETH.TP_HEADER_ID = E_PVS.TP_HEADER_ID AND ETD.TP_HEADER_ID = ETH.TP_HEADER_ID AND ETD.EDI_FLAG = 'Y' AND ETD.DOCUMENT_ID = 'POO' AND ETD.DOCUMENT_TYPE = POH.PO_TYPE ) and 1=1 ORDER BY 1 , 2 , 3 , 4
51bbkcd9zwsjw/* OracleOEM */ with max1 as (select :1 as select_tab, :2 as select_priv from dual) select 'select_any_table', substr(SYS_CONNECT_BY_PATH(c, '->'), 3, 512) path, c from ( select null p, name c from system_privilege_map where name = 'SELECT ANY TABLE' union select granted_role p, grantee c from dba_role_privs union select privilege p, grantee c from dba_sys_privs ) where ((c = 'PUBLIC') or (exists (select 'w' from dba_users where username=c))) and rownum <= decode((select select_tab from max1), '-1', 2147483647, (select select_tab from max1)) start with p is null connect by p = prior c union select 'select_privilege', substr(SYS_CONNECT_BY_PATH(c, '->'), 3, 512) path, c from ( select null p, view_name c from dba_views where view_name like 'DBA_%' union select granted_role p, grantee c from dba_role_privs union select table_name p, grantee c from dba_tab_privs where privilege = 'SELECT' ) where ((c = 'PUBLIC') or (exists (select 'w' from dba_users where username=c))) and rownum <= decode((select select_priv from max1), '-1', 2147483647, (select select_priv from max1)) start with p is null connect by p = prior c
529wb67xu0sy9SELECT INPUT_TAX_CLASSIFICATION_CODE FROM ZX_LINES_DET_FACTORS WHERE APPLICATION_ID = :B6 AND ENTITY_CODE = :B5 AND EVENT_CLASS_CODE = :B4 AND TRX_ID = :B3 AND TRX_LINE_ID = :B2 AND TRX_LEVEL_TYPE = :B1
54tzhmhcs8nkh declare context DBMS_XMLGEN.ctxHandle; l_xml_query varchar2(15000) ; l_headerAttach_query varchar2(1000); l_lineAttach_query varchar2(1200) ; --Bug5213932 increase length l_disAttach_query varchar2(1200) ; --Bug5213932 increase length l_time varchar2(50); g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_COMMUNICATION_PVT.'; l_api_name CONSTANT VARCHAR2(30):= 'POXMLGEN'; TYPE ref_cursorType IS REF CURSOR; refcur ref_cursorType; l_fileClob CLOB := NULL; Begin l_xml_query := :1 ; l_headerAttach_query := :2; l_lineAttach_query := :3; l_disAttach_query := :4; l_fileClob := :5; select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Before Executing the Main Query', l_time); END IF; context := dbms_xmlgen.newContext(l_xml_query); dbms_xmlgen.setRowsetTag(context, 'PO_DATA'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xresult := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the Main Query', l_time); END IF; context := dbms_xmlgen.newContext(l_headerAttach_query); dbms_xmlgen.setRowsetTag(context, 'HEADER_ATTACHMENTS'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xheaderAttach := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the header attachment Query', l_time); END IF; context := dbms_xmlgen.newContext(l_lineAttach_query); dbms_xmlgen.setRowsetTag(context, 'LINE_ATTACHMENTS'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xlineAttach := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the line attachment Query', l_time); END IF; context := dbms_xmlgen.newContext(l_disAttach_query); dbms_xmlgen.setRowsetTag(context, 'SHIPMENT_ATTACHMENTS'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xdisAttach := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the shipment attachment Query', l_time); END IF; IF l_fileClob is not null THEN open refcur for 'select :l_fileClob1 as text_file from dual' using l_fileClob; context := DBMS_XMLGEN.newContext(refcur); DBMS_XMLGEN.setRowTag(context, NULL); DBMS_XMLGEN.setRowSetTag(context, NULL); :xfileClob := DBMS_XMLGEN.getXML(context, DBMS_XMLGEN.NONE); DBMS_XMLGEN.closeContext(context); close refcur; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'After executing the file clob'); END IF; ELSE IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'Value of File clob is null'); END IF; :xfileClob := null; END IF; -- bug#3580225 Start -- select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVE L <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Before calling PO_HR_LOCATION.populate_gt', l_time); END IF; /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/ PO_HR_LOCATION.populate_gt(); BEGIN context := dbms_xmlgen.newContext('select * from po_address_details_gt '); dbms_xmlgen.setRowsetTag(context, 'ADDRESS_DETAILS'); dbms_xmlgen.setRowTag(context, 'ADDRESS_DETAILS_ROW'); :xaddrDetails := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); EXCEPTION WHEN OTHERS THEN NULL; END; -- bug#3580225 Start -- End;
54wkgprhc32fhSELECT COUNT(*), DATA_TYPE FROM SYS.DBA_TAB_COLS WHERE DATA_TYPE IN ('ORDIMAGE', 'ORDAUDIO', 'ORDDOC', 'ORDVIDEO', 'SI_COLOR', 'SI_STILLIMAGE', 'SI_AVERAGECOLOR', 'SI_COLORHISTOGRAM', 'SI_POSITIONALCOLOR', 'SI_TEXTURE', 'SI_FEATURELIST') AND OWNER != 'PM' GROUP BY DATA_TYPE
5vbbcp6pd58b8begin Fnd_Concurrent.Init_Request; end;
6129566gyvx21SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_types WHERE type_name = :1 AND owner = :2
67mmmbx5hb3p0BEGIN :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;:21 := fnd_session_management.g_proxy_user_id; :22 := fnd_session_management.g_mode_code; END;
6vx0fw5141z4nSELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 )
7qs7fx89194u1SELECT 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 AND PROFILE_OPTION_VALUE IS NOT NULL
7yr8xbwxpdnavINSERT INTO WIP_EAM_DIRECT_ITEMS ( DESCRIPTION , PURCHASING_CATEGORY_ID , DIRECT_ITEM_SEQUENCE_ID , OPERATION_SEQ_NUM , DEPARTMENT_ID , WIP_ENTITY_ID , ORGANIZATION_ID , SUGGESTED_VENDOR_NAME , SUGGESTED_VENDOR_ID , SUGGESTED_VENDOR_SITE , SUGGESTED_VENDOR_SITE_ID , SUGGESTED_VENDOR_CONTACT , SUGGESTED_VENDOR_CONTACT_ID , UNIT_PRICE , AUTO_REQUEST_MATERIAL , REQUIRED_QUANTITY , UOM , NEED_BY_DATE , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , ORDER_TYPE_LOOKUP_CODE) VALUES ( :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , 'Y' , :B4 , :B3 , :B2 , SYSDATE , FND_GLOBAL.USER_ID , SYSDATE , FND_GLOBAL.USER_ID , FND_GLOBAL.LOGIN_ID , :B1 )
81xv2tma4cag8 SELECT "A2"."ITEM_REVISION" "ITEM_REVISION", "A2"."LINE_NUM" "LINE_NUM", "A2"."ITEM_DESCRIPTION" "ITEM_DESCRIPTION", "A2"."CANCEL_FLAG" "CANCEL_FLAG", "A2"."CANCEL_DATE" "CANCEL_DATE", "A2"."CANCEL_REASON" "CANCEL_REASON", "A2"."VENDOR_PRODUCT_NUM" "VENDOR_PRODUCT_NUM", "A2"."NOTE_TO_VENDOR" "NOTE_TO_VENDOR", "A2"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A2"."UN_NUMBER" "UN_NUMBER", "A2"."UN_DESC" "UN_DESC", "A2"."HAZARD_CLASS" "HAZARD_CLASS", "A2"."ORDER_TYPE_LOOKUP_CODE" "ORDER_TYPE_LOOKUP_CODE", "A2"."CONTRACT_NUM" "CONTRACT_NUM", "A2"."SEGMENT1" "SEGMENT1", "A2"."GLOBAL_AGREEMENT_FLAG" "GLOBAL_AGREEMENT_FLAG", "A2"."QUOTE_VENDOR_QUOTE_NUMBER" "QUOTE_VENDOR_QUOTE_NUMBER", "A2"."QUOTATION_LINE" "QUOTATION_LINE", "A2"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A2"."ATTRIBUTE1" "ATTRIBUTE1", "A2"."ATTRIBUTE2" "ATTRIBUTE2", "A2"."ATTRIBUTE3" "ATTRIBUTE3", "A2"."ATTRIBUTE4" "ATTRIBUTE4", "A2"."ATTRIBUTE5" "ATTRIBUTE5", "A2"."ATTRIBUTE6" "ATTRIBUTE6", "A2"."ATTRIBUTE7" "ATTRIBUTE7", "A2"."ATTRIBUTE8" "ATTRIBUTE8", "A2"."ATTRIBUTE9" "ATTRIBUTE9", "A2"."ATTRIBUTE10" "ATTRIBUTE10", "A2"."ATTRIBUTE11" "ATTRIBUTE11", "A2"."ATTRIBUTE12" "ATTRIBUTE12", "A2"."ATTRIBUTE13" "ATTRIBUTE13", "A2"."ATTRIBUTE14" "ATTRIBUTE14", "A2"."ATTRIBUTE15" "ATTRIBUTE15", "A2"."UNIT_PRICE" "UNIT_PRICE", "A2"."QUANTITY" "QUANTITY", "A2"."QUANTITY_COMMITTED" "QUANTITY_COMMITTED", "A2"."PO_HEADER_ID" "PO_HEADER_ID", "A2"."PO_LINE_ID" "PO_LINE_ID", "A2"."ITEM_ID" "ITEM_ID", "A2"."FROM_HEADER_ID" "FROM_HEADER_ID", "A2"."FROM_LINE_ID" "FROM_LINE_ID", "A2"."REFERENCE_NUM" "REFERENCE_NUM", "A2"."MIN_RELEASE_AMOUNT" "MIN_RELEASE_AMOUNT", "A2"."PRICE_TYPE_LOOKUP_CODE" "PRICE_TYPE_LOOKUP_CODE", "A2"."CLOSED_CODE" "CLOSED_CODE", "A2"."PRICE_BREAK_LOOKUP_CODE" "PRICE_BREAK_LOOKUP_CODE", "A2"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A2"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A2"."REQUEST_ID" "REQUEST_ID", "A2"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A2"."PROGRAM_ID" "PROGRAM_ID", "A2"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A2"."CLOSED_DATE" "CLOSED_DATE", "A2"."CLOSED_REASON" "CLOSED_REASON", "A2"."CLOSED_BY" "CLOSED_BY", "A2"."TRANSACTION_REASON_CODE" "TRANSACTION_REASON_CODE", "A2"."ORG_ID" "ORG_ID", "A2". "HAZARD_CLASS_ID" "HAZARD_CLASS_ID", "A2"."MIN_ORDER_QUANTITY" "MIN_ORDER_QUANTITY", "A2"."MAX_ORDER_QUANTITY" "MAX_ORDER_QUANTITY", "A2"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A2"."OVER_TOLERANCE_ERROR_FLAG" "OVER_TOLERANCE_ERROR_FLAG", "A2"."MARKET_PRICE" "MARKET_PRICE", "A2"."UNORDERED_FLAG" "UNORDERED_FLAG", "A2"."CLOSED_FLAG" "CLOSED_FLAG", "A2"."USER_HOLD_FLAG" "USER_HOLD_FLAG", "A2"."CANCELLED_BY" "CANCELLED_BY", "A2"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A2"."FIRM_DATE" "FIRM_DATE", "A2"."TAXABLE_FLAG" "TAXABLE_FLAG", "A2"."TYPE_1099" "TYPE_1099", "A2"."CAPITAL_EXPENSE_FLAG" "CAPITAL_EXPENSE_FLAG", "A2"."NEGOTIATED_BY_PREPARER_FLAG" "NEGOTIATED_BY_PREPARER_FLAG", "A2"."QC_GRADE" "QC_GRADE", "A2"."BASE_UOM" "BASE_UOM", "A2"."BASE_QTY" "BASE_QTY", "A2"."SECONDARY_UOM" "SECONDARY_UOM", "A2"."SECONDARY_QTY" "SECONDARY_QTY", "A2"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A2"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A2"."LINE_TYPE_ID" "LINE_TYPE_ID", "A2"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A2"."CREATION_DATE" "CREATION_DATE", "A2"."CREATED_BY" "CREATED_BY", "A2"."CATEGORY_ID" "CATEGORY_ID", "A2"."COMMITTED_AMOUNT" "COMMITTED_AMOUNT", "A2"."ALLOW_PRICE_OVERRIDE_FLAG" "ALLOW_PRICE_OVERRIDE_FLAG", "A2"."NOT_TO_EXCEED_PRICE" "NOT_TO_EXCEED_PRICE", "A2"."LIST_PRICE_PER_UNIT" "LIST_PRICE_PER_UNIT", "A2"."UN_NUMBER_ID" "UN_NUMBER_ID", "A2"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A2"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A2"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A2"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A2"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A2"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A2"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A2"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A2"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A2"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A2"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A2"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A2"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A2"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A2"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A2"."GLOBAL_ATTRIBUTE15" "GLOBAL_ATTRIBUTE15", "A2"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A2"."GLOBAL_ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A2"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A2"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A2"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A2 "."LINE_REFERENCE_NUM" "LINE_REFERENCE_NUM", "A2"."PROJECT_ID" "PROJECT_ID", "A2"."TASK_ID" "TASK_ID", "A2"."EXPIRATION_DATE" "EXPIRATION_DATE", "A2"."TAX_CODE_ID" "TAX_CODE_ID", "A2"."OKE_CONTRACT_HEADER_ID" "OKE_CONTRACT_HEADER_ID", "A2"."OKE_CONTRACT_VERSION_ID" "OKE_CONTRACT_VERSION_ID", "A2"."TAX_NAME" "TAX_NAME", "A2"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A2"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A2"."PREFERRED_GRADE" "PREFERRED_GRADE", "A2"."AUCTION_HEADER_ID" "AUCTION_HEADER_ID", "A2"."AUCTION_DISPLAY_NUMBER" "AUCTION_DISPLAY_NUMBER", "A2"."AUCTION_LINE_NUMBER" "AUCTION_LINE_NUMBER", "A2"."BID_NUMBER" "BID_NUMBER", "A2"."BID_LINE_NUMBER" "BID_LINE_NUMBER", "A2"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A2"."SUPPLIER_REF_NUMBER" "SUPPLIER_REF_NUMBER", "A2"."CONTRACT_ID" "CONTRACT_ID", "A2"."JOB_ID" "JOB_ID", "A2"."AMOUNT" "AMOUNT", "A2"."START_DATE" "START_DATE", "A2"."LINE_TYPE" "LINE_TYPE", "A2"."PURCHASE_BASIS" "PURCHASE_BASIS", "A2"."ITEM_NUM" "ITEM_NUM", "A2"."JOB_NAME" "JOB_NAME", "A2"."CONTRACTOR_FIRST_NAME" "CONTRACTOR_FIRST_NAME", "A2"."CONTRACTOR_LAST_NAME" "CONTRACTOR_LAST_NAME", "A2"."LINE_AMOUNT" "LINE_AMOUNT", "A2"."CANCELED_AMOUNT" "CANCELED_AMOUNT", "A2"."TOTAL_LINE_AMOUNT" "TOTAL_LINE_AMOUNT", "A2"."BASE_UNIT_PRICE" "BASE_UNIT_PRICE", "A2"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A2"."MATCHING_BASIS" "MATCHING_BASIS", "A2"."SVC_AMOUNT_NOTIF_SENT" "SVC_AMOUNT_NOTIF_SENT", "A2"."SVC_COMPLETION_NOTIF_SENT" "SVC_COMPLETION_NOTIF_SENT", "A2"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A2"."RETAINAGE_RATE" "RETAINAGE_RATE", "A2"."MAX_RETAINAGE_AMOUNT" "MAX_RETAINAGE_AMOUNT", "A2"."PROGRESS_PAYMENT_RATE" "PROGRESS_PAYMENT_RATE", "A2"."RECOUPMENT_RATE" "RECOUPMENT_RATE", CURSOR (SELECT "A40"."PRICE_TYPE_DSP" "PRICE_TYPE", "A40"."MULTIPLIER" "MULTIPLIER" FROM "PO_PRICE_DIFFERENTIALS_V" "A40" WHERE "A40"."ENTITY_TYPE"='PO LINE' AND "A40"."ENTITY_ID"="A2"."PO_LINE_ID" AND "A40"."ENABLED_FLAG"='Y') "PRICE_DIFF", CURSOR (SELECT "A2"."PO_LINE_ID" "PO_LINE_ID", "A38"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A39", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A38" WHERE ("A39"."ENTITY_NAME"='PO_LINES' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A39"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A39"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORG ID"()) AND "A39"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL OR "A39"."ENTITY_NAME"='PO_HEADERS' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A39"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A39"."ENTITY_NAME"='PO_HEADERS' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL) AND "A39"."FUNCTION_NAME"='PO_PRINTPO' AND "A39"."MEDIA_ID"="A38"."MEDIA_ID" AND "A39"."DATATYPE_ID"=1 ORDER BY "A39"."SEQ_NUM") "LINE_SHORT_TEXT", CURSOR (SELECT "A37"."PRICE_ADJUSTMENT_ID" "PRICE_ADJUSTMENT_ID", "A37"."CREATION_DATE" "CREATION_DATE", "A37"."CREATED_BY" "CREATED_BY", "A37"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A37"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A37"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A37"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A37"."PROGRAM_ID" "PROGRAM_ID", "A37"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A37"."REQUEST_ID" "REQUEST_ID", "A37"."PO_HEADER_ID" "PO_HEADER_ID", "A37"."AUTOMATIC_FLAG" "AUTOMATIC_FLAG", "A37"."PO_LINE_ID" "PO_LINE_ID", "A37"."ADJ_LINE_NUM" "ADJ_LINE_NUM", "A37"."CONTEXT" "CONTEXT", "A37"."ATTRIBUTE1" "ATTRIBUTE1", "A37"."ATTRIBUTE2" "ATTRIBUTE2", "A37"."ATTRIBUTE3" "ATTRIBUTE3", "A37"."ATTRIBUTE4" "ATTRIBUTE4", "A37"."ATTRIBUTE5" "ATTRIBUTE5", "A37"."ATTRIBUTE6" "ATTRIBUTE6", "A37"."ATTRIBUTE7" "ATTRIBUTE7", "A37"."ATTRIBUTE8" "ATTRIBUTE8", "A37"."ATTRIBUTE9" "ATTRIBUTE9", "A37"."ATTRIBUTE10" "ATTRIBUTE10", "A37"."ATTRIBUTE11" "ATTRIBUTE11", "A37"."ATTRIBUTE12" "ATTRIBUTE12", "A37"."ATTRIBUTE13" "ATTRIBUTE13", "A37"."ATTRIBUTE14" "ATTRIBUTE14", "A37"."ATTRIBUTE15" "ATTRIBUTE15", "A37"."ORIG_SYS_DISCOUNT_REF" "ORIG_SYS_DISCOUNT_REF", "A37"."CHANGE_SEQUENCE" "CHANGE_SEQUENCE", "A37"."LIST_HEADER_ID" "LIST_HEADER_ID", "A37"."LIST_TYPE_CODE" "LIST_TYPE_CODE", "A37"."LIST_LINE_ID" "LIST_LINE_ID", "A37"."MODIFIER_DESC" "MODIFIER_DESC", "A37"."LIST_LINE_TYPE_CODE" "LIST_LINE_TYPE_CODE", "A37"."MODIFIER_LINE_TYPE" "MODIFIER_LINE_TYPE", "A37"."MODIFIED_FROM" "MODIFIED_FROM", "A37"."MODIFIED_TO" "MODIFIED_TO", "A37"."UPDATE_ALLOWED" "UPDATE_ALLOWED", "A37"."CHANGE_REASON_CODE" "CHANGE_REASON_CODE", "A37"."CHANGE_REASON_TEXT" "CHANGE_REASON_T EXT", "A37"."UPDATED_FLAG" "UPDATED_FLAG", "A37"."APPLIED_FLAG" "APPLIED_FLAG", "A37"."OPERAND" "OPERAND", "A37"."ARITHMETIC_OPERATOR" "ARITHMETIC_OPERATOR", "A37"."COST_ID" "COST_ID", "A37"."TAX_CODE" "TAX_CODE", "A37"."TAX_EXEMPT_FLAG" "TAX_EXEMPT_FLAG", "A37"."TAX_EXEMPT_NUMBER" "TAX_EXEMPT_NUMBER", "A37"."TAX_EXEMPT_REASON_CODE" "TAX_EXEMPT_REASON_CODE", "A37"."PARENT_ADJUSTMENT_ID" "PARENT_ADJUSTMENT_ID", "A37"."INVOICED_FLAG" "INVOICED_FLAG", "A37"."ESTIMATED_FLAG" "ESTIMATED_FLAG", "A37"."INC_IN_SALES_PERFORMANCE" "INC_IN_SALES_PERFORMANCE", "A37"."ADJUSTED_AMOUNT" "ADJUSTED_AMOUNT", "A37"."PRICING_PHASE_ID" "PRICING_PHASE_ID", "A37"."CHARGE_TYPE_CODE" "CHARGE_TYPE_CODE", "A37"."CHARGE_SUBTYPE_CODE" "CHARGE_SUBTYPE_CODE", "A37"."RANGE_BREAK_QUANTITY" "RANGE_BREAK_QUANTITY", "A37"."ACCRUAL_CONVERSION_RATE" "ACCRUAL_CONVERSION_RATE", "A37"."PRICING_GROUP_SEQUENCE" "PRICING_GROUP_SEQUENCE", "A37"."ACCRUAL_FLAG" "ACCRUAL_FLAG", "A37"."LIST_LINE_NO" "LIST_LINE_NO", "A37"."SOURCE_SYSTEM_CODE" "SOURCE_SYSTEM_CODE", "A37"."BENEFIT_QTY" "BENEFIT_QTY", "A37"."BENEFIT_UOM_CODE" "BENEFIT_UOM_CODE", "A37"."PRINT_ON_INVOICE_FLAG" "PRINT_ON_INVOICE_FLAG", "A37"."EXPIRATION_DATE" "EXPIRATION_DATE", "A37"."REBATE_TRANSACTION_TYPE_CODE" "REBATE_TRANSACTION_TYPE_CODE", "A37"."REBATE_TRANSACTION_REFERENCE" "REBATE_TRANSACTION_REFERENCE", "A37"."REBATE_PAYMENT_SYSTEM_CODE" "REBATE_PAYMENT_SYSTEM_CODE", "A37"."REDEEMED_DATE" "REDEEMED_DATE", "A37"."REDEEMED_FLAG" "REDEEMED_FLAG", "A37"."MODIFIER_LEVEL_CODE" "MODIFIER_LEVEL_CODE", "A37"."PRICE_BREAK_TYPE_CODE" "PRICE_BREAK_TYPE_CODE", "A37"."SUBSTITUTION_ATTRIBUTE" "SUBSTITUTION_ATTRIBUTE", "A37"."PRORATION_TYPE_CODE" "PRORATION_TYPE_CODE", "A37"."INCLUDE_ON_RETURNS_FLAG" "INCLUDE_ON_RETURNS_FLAG", "A37"."CREDIT_OR_CHARGE_FLAG" "CREDIT_OR_CHARGE_FLAG", "A37"."AC_CONTEXT" "AC_CONTEXT", "A37"."AC_ATTRIBUTE1" "AC_ATTRIBUTE1", "A37"."AC_ATTRIBUTE2" "AC_ATTRIBUTE2", "A37"."AC_ATTRIBUTE3" "AC_ATTRIBUTE3", "A37"."AC_ATTRIBUTE4" "AC_ATTRIBUTE4", "A37"."AC_ATTRIBUTE5" "AC_ATTRIBUTE5", "A37"."AC_ATTRIBUTE6" "AC_ATTRIBUTE6", "A37"."AC_ATTRIBUTE7" "AC_ATTRIBUTE7", "A37"."AC_ATTRIBUTE8" "AC_ATTRIBUTE8", "A37"."AC_ATTRIBUTE9" "AC_ATTRIBUTE9", "A37"."AC_ATTRIBUTE10" "AC_ATTRIBUTE10", "A37"."AC_ATTRIBUTE11" "AC_ATTRIBUTE11", "A37"."AC_ATTRIBUTE12" "AC_ATTRIBUTE12", "A37"."AC_ATTRIBUTE13" "AC_ATTRIBUTE13", "A37"."AC_ATTRIBUTE14" "AC_ATTRIBUTE14" , "A37"."AC_ATTRIBUTE15" "AC_ATTRIBUTE15", "A37"."LOCK_CONTROL" "LOCK_CONTROL", "A37"."OPERAND_PER_PQTY" "OPERAND_PER_PQTY", "A37"."ADJUSTED_AMOUNT_PER_PQTY" "ADJUSTED_AMOUNT_PER_PQTY", "A37"."INTERCO_INVOICED_FLAG" "INTERCO_INVOICED_FLAG", "A37"."INVOICED_AMOUNT" "INVOICED_AMOUNT", "A37"."RETROBILL_REQUEST_ID" "RETROBILL_REQUEST_ID", "A37"."TAX_RATE_ID" "TAX_RATE_ID" FROM "PO_PRICE_ADJUSTMENTS_XML" "A37" WHERE "A37"."PO_HEADER_ID"="A2"."PO_HEADER_ID" AND "A37"."PO_LINE_ID"="A2"."PO_LINE_ID" AND "A37"."PARENT_ADJUSTMENT_ID" IS NULL ORDER BY "A37"."PRICING_GROUP_SEQUENCE") "PRICE_MODIFIERS", CURSOR (SELECT "A36"."PRICE_ADJUSTMENT_ID" "PRICE_ADJUSTMENT_ID", "A36"."CREATION_DATE" "CREATION_DATE", "A36"."CREATED_BY" "CREATED_BY", "A36"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A36"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A36"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A36"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A36"."PROGRAM_ID" "PROGRAM_ID", "A36"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A36"."REQUEST_ID" "REQUEST_ID", "A36"."PO_HEADER_ID" "PO_HEADER_ID", "A36"."AUTOMATIC_FLAG" "AUTOMATIC_FLAG", "A36"."PO_LINE_ID" "PO_LINE_ID", "A36"."ADJ_LINE_NUM" "ADJ_LINE_NUM", "A36"."CONTEXT" "CONTEXT", "A36"."ATTRIBUTE1" "ATTRIBUTE1", "A36"."ATTRIBUTE2" "ATTRIBUTE2", "A36"."ATTRIBUTE3" "ATTRIBUTE3", "A36"."ATTRIBUTE4" "ATTRIBUTE4", "A36"."ATTRIBUTE5" "ATTRIBUTE5", "A36"."ATTRIBUTE6" "ATTRIBUTE6", "A36"."ATTRIBUTE7" "ATTRIBUTE7", "A36"."ATTRIBUTE8" "ATTRIBUTE8", "A36"."ATTRIBUTE9" "ATTRIBUTE9", "A36"."ATTRIBUTE10" "ATTRIBUTE10", "A36"."ATTRIBUTE11" "ATTRIBUTE11", "A36"."ATTRIBUTE12" "ATTRIBUTE12", "A36"."ATTRIBUTE13" "ATTRIBUTE13", "A36"."ATTRIBUTE14" "ATTRIBUTE14", "A36"."ATTRIBUTE15" "ATTRIBUTE15", "A36"."ORIG_SYS_DISCOUNT_REF" "ORIG_SYS_DISCOUNT_REF", "A36"."CHANGE_SEQUENCE" "CHANGE_SEQUENCE", "A36"."LIST_HEADER_ID" "LIST_HEADER_ID", "A36"."LIST_TYPE_CODE" "LIST_TYPE_CODE", "A36"."LIST_LINE_ID" "LIST_LINE_ID", "A36"."MODIFIER_DESC" "MODIFIER_DESC", "A36"."LIST_LINE_TYPE_CODE" "LIST_LINE_TYPE_CODE", "A36"."MODIFIER_LINE_TYPE" "MODIFIER_LINE_TYPE", "A36"."MODIFIED_FROM" "MODIFIED_FROM", "A36"."MODIFIED_TO" "MODIFIED_TO", "A36"."UPDATE_ALLOWED" "UPDATE_ALLOWED", "A36"."CHANGE_REASON_CODE" "CHANGE_REASON_CODE", "A36"."CHANGE_REASON_TEXT" "CHANGE_REASON_TEXT", "A36"."UP DATED_FLAG" "UPDATED_FLAG", "A36"."APPLIED_FLAG" "APPLIED_FLAG", "A36"."OPERAND" "OPERAND", "A36"."ARITHMETIC_OPERATOR" "ARITHMETIC_OPERATOR", "A36"."COST_ID" "COST_ID", "A36"."TAX_CODE" "TAX_CODE", "A36"."TAX_EXEMPT_FLAG" "TAX_EXEMPT_FLAG", "A36"."TAX_EXEMPT_NUMBER" "TAX_EXEMPT_NUMBER", "A36"."TAX_EXEMPT_REASON_CODE" "TAX_EXEMPT_REASON_CODE", "A36"."PARENT_ADJUSTMENT_ID" "PARENT_ADJUSTMENT_ID", "A36"."INVOICED_FLAG" "INVOICED_FLAG", "A36"."ESTIMATED_FLAG" "ESTIMATED_FLAG", "A36"."INC_IN_SALES_PERFORMANCE" "INC_IN_SALES_PERFORMANCE", "A36"."ADJUSTED_AMOUNT" "ADJUSTED_AMOUNT", "A36"."PRICING_PHASE_ID" "PRICING_PHASE_ID", "A36"."CHARGE_TYPE_CODE" "CHARGE_TYPE_CODE", "A36"."CHARGE_SUBTYPE_CODE" "CHARGE_SUBTYPE_CODE", "A36"."RANGE_BREAK_QUANTITY" "RANGE_BREAK_QUANTITY", "A36"."ACCRUAL_CONVERSION_RATE" "ACCRUAL_CONVERSION_RATE", "A36"."PRICING_GROUP_SEQUENCE" "PRICING_GROUP_SEQUENCE", "A36"."ACCRUAL_FLAG" "ACCRUAL_FLAG", "A36"."LIST_LINE_NO" "LIST_LINE_NO", "A36"."SOURCE_SYSTEM_CODE" "SOURCE_SYSTEM_CODE", "A36"."BENEFIT_QTY" "BENEFIT_QTY", "A36"."BENEFIT_UOM_CODE" "BENEFIT_UOM_CODE", "A36"."PRINT_ON_INVOICE_FLAG" "PRINT_ON_INVOICE_FLAG", "A36"."EXPIRATION_DATE" "EXPIRATION_DATE", "A36"."REBATE_TRANSACTION_TYPE_CODE" "REBATE_TRANSACTION_TYPE_CODE", "A36"."REBATE_TRANSACTION_REFERENCE" "REBATE_TRANSACTION_REFERENCE", "A36"."REBATE_PAYMENT_SYSTEM_CODE" "REBATE_PAYMENT_SYSTEM_CODE", "A36"."REDEEMED_DATE" "REDEEMED_DATE", "A36"."REDEEMED_FLAG" "REDEEMED_FLAG", "A36"."MODIFIER_LEVEL_CODE" "MODIFIER_LEVEL_CODE", "A36"."PRICE_BREAK_TYPE_CODE" "PRICE_BREAK_TYPE_CODE", "A36"."SUBSTITUTION_ATTRIBUTE" "SUBSTITUTION_ATTRIBUTE", "A36"."PRORATION_TYPE_CODE" "PRORATION_TYPE_CODE", "A36"."INCLUDE_ON_RETURNS_FLAG" "INCLUDE_ON_RETURNS_FLAG", "A36"."CREDIT_OR_CHARGE_FLAG" "CREDIT_OR_CHARGE_FLAG", "A36"."AC_CONTEXT" "AC_CONTEXT", "A36"."AC_ATTRIBUTE1" "AC_ATTRIBUTE1", "A36"."AC_ATTRIBUTE2" "AC_ATTRIBUTE2", "A36"."AC_ATTRIBUTE3" "AC_ATTRIBUTE3", "A36"."AC_ATTRIBUTE4" "AC_ATTRIBUTE4", "A36"."AC_ATTRIBUTE5" "AC_ATTRIBUTE5", "A36"."AC_ATTRIBUTE6" "AC_ATTRIBUTE6", "A36"."AC_ATTRIBUTE7" "AC_ATTRIBUTE7", "A36"."AC_ATTRIBUTE8" "AC_ATTRIBUTE8", "A36"."AC_ATTRIBUTE9" "AC_ATTRIBUTE9", "A36"."AC_ATTRIBUTE10" "AC_ATTRIBUTE10", "A36"."AC_ATTRIBUTE11" "AC_ATTRIBUTE11", "A36"."AC_ATTRIBUTE12" "AC_ATTRIBUTE12", "A36"."AC_ATTRIBUTE13" "AC_ATTRIBUTE13", "A36"."AC_ATTRIBUTE14" "AC_ATTRIBUTE14", "A36"."AC_ATTRIBUT E15" "AC_ATTRIBUTE15", "A36"."LOCK_CONTROL" "LOCK_CONTROL", "A36"."OPERAND_PER_PQTY" "OPERAND_PER_PQTY", "A36"."ADJUSTED_AMOUNT_PER_PQTY" "ADJUSTED_AMOUNT_PER_PQTY", "A36"."INTERCO_INVOICED_FLAG" "INTERCO_INVOICED_FLAG", "A36"."INVOICED_AMOUNT" "INVOICED_AMOUNT", "A36"."RETROBILL_REQUEST_ID" "RETROBILL_REQUEST_ID", "A36"."TAX_RATE_ID" "TAX_RATE_ID" FROM "PO_PRICE_ADJUSTMENTS_XML" "A36" WHERE "A36"."PO_HEADER_ID"="A2"."FROM_HEADER_ID" AND "A36"."PO_LINE_ID"="A2"."FROM_LINE_ID" AND "A36"."PARENT_ADJUSTMENT_ID" IS NULL ORDER BY "A36"."PRICING_GROUP_SEQUENCE") "ADD_PRICE_MODIFIERS", CURSOR (SELECT "A35"."SEGMENT1" "PONUM" FROM "PO"."PO_HEADERS_ALL" "A35" WHERE "A35"."PO_HEADER_ID"="A2"."FROM_HEADER_ID") "ADD_PRICE_PONUM", CURSOR (SELECT "A34"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A34" WHERE ("A34"."ENTITY_NAME"='PO_LINES' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A34"."ENTITY_NAME"='PO_HEADERS' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='PO_HEADERS' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A34"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORGID"()) AND "A34"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL) AND "A34"."DATATYPE_ID"=5 AND "A34"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A34"."SEQ_NUM") "LINE_URL_ATTACHMENTS", CURSOR (SELECT "A33"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A33" WHERE ("A33"."ENTITY_NAME"='PO_LINES' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A33"."ENTITY_NAME"='PO_HEADERS' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A33"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A33"."ENTITY_NAME"='PO_HEADERS' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL OR "A33"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A33"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORGID"()) AND "A33"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL) AND "A33"."DATATYPE_ID"=6 AND "A33"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A33"."SEQ_NUM") "LINE_FILE_ATTACHMENTS", CURSOR (SELECT "A32"."SHIPMENT_NUM" "SHIPMENT_NUM", "A32"."DUE_DATE" "DUE_DATE", "A32"."QUANTITY" "QUANTITY", "A32"."PRICE_OVERRIDE" "PRICE_OVERRIDE", "A32"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A32"."CANCEL_FLAG" "CANCEL_FLAG", "A32"."CANCEL_DATE" "CANCEL_DATE", "A32"."CANCEL_REASON" "CANCEL_REASON", "A32"."TAXABLE_FLAG" "TAXABLE_FLAG", "A32"."START_DATE" "START_DATE", "A32"."END_DATE" "END_DATE", "A32"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A32"."ATTRIBUTE1" "ATTRIBUTE1", "A32"."ATTRIBUTE2" "ATTRIBUTE2", "A32"."ATTRIBUTE3" "ATTRIBUTE3", "A32"."ATTRIBUTE4" "ATTRIBUTE4", "A32"."ATTRIBUTE5" "ATTRIBUTE5", "A32"."ATTRIBUTE6" "ATTRIBUTE6", "A32"."ATTRIBUTE7" "ATTRIBUTE7", "A32"."ATTRIBUTE8" "ATTRIBUTE8", "A32"."ATTRIBUTE9" "ATTRIBUTE9", "A32"."ATTRIBUTE10" "ATTRIBUTE10", "A32"."ATTRIBUTE11" "ATTRIBUTE11", "A32"."ATTRIBUTE12" "ATTRIBUTE12", "A32"."ATTRIBUTE13" "ATTRIBUTE13", "A32"."ATTRIBUTE14" "ATTRIBUTE14", "A32"."ATTRIBUTE15" "ATTRIBUTE15", "A32"."PO_HEADER_ID" "PO_HEADER_ID", "A32"."PO_LINE_ID" "PO_LINE_ID", "A32"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A32"."SHIPMENT_TYPE" "SHIPMENT_TYPE", "A32"."PO_RELEASE_ID" "PO_RELEASE_ID", "A32"."CONSIGNED_FLAG" "CONSIGNED_FLAG", "A32"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A32"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A32"."RECEIVING_ROUTING_ID" "RECEIVING_ROUTING_ID", "A32"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A32"."CLOSED_REASON" "CLOSED_REASON", "A32"."CLOSED_DATE" "CLOSED_DATE", "A32"."CLOSED_BY" "CLOSED_BY", "A32"."ORG_ID" "ORG_ID", "A32"."UNIT_OF_MEASURE_CLASS" "UNIT_OF_MEASURE_CLASS", "A32"."ENCUMBER_NOW" "ENCUMBER_NOW", "A32"."INSPECTION_REQUIRED_FLAG" "INSPECTION_REQUIRED_FLAG", "A32"."RECEIPT_REQUIRED_FLAG" "RECEIPT_REQUIRED_FLAG", "A32"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A32"."QTY_RCV_EXCEPTION_CODE" "QTY_RCV_EXCEPTION_CODE", "A32"."ENFORCE_SHIP_TO_LOCATION_CODE" "ENFORCE_SHIP_TO_LOCATION_CODE", "A32"."ALLOW_SUBSTITUTE_RECEIPTS_FLAG" "ALLOW_SUBSTITUTE_RECEIPTS_FLAG", "A32"."DAYS_EARLY_RECEIPT_ALLOWED" "DAYS_EARLY_RECEIPT_ALLOWED", "A32"."DAYS_LATE_RECEIPT_ALLOWED" "DAYS_LATE_RECEIPT_ALLOWED", "A32"."RECEIPT_DAYS_EXCEPTION_CODE" "RECEIPT_DAYS_EXCEPTION_CODE", "A32"."INVOICE_CLOSE_TOLERANCE" "INVOICE_CLOSE_TOLERANCE", "A32"."RECEIVE_CLOSE_TOLERANCE" "RECEIVE_CLOSE_TOLERANCE", "A32"."SHIP_TO_OR GANIZATION_ID" "SHIP_TO_ORGANIZATION_ID", "A32"."SOURCE_SHIPMENT_ID" "SOURCE_SHIPMENT_ID", "A32"."CLOSED_CODE" "CLOSED_CODE", "A32"."REQUEST_ID" "REQUEST_ID", "A32"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A32"."PROGRAM_ID" "PROGRAM_ID", "A32"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A32"."LAST_ACCEPT_DATE" "LAST_ACCEPT_DATE", "A32"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A32"."ENCUMBERED_DATE" "ENCUMBERED_DATE", "A32"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A32"."FOB_LOOKUP_CODE" "FOB_LOOKUP_CODE", "A32"."FREIGHT_TERMS_LOOKUP_CODE" "FREIGHT_TERMS_LOOKUP_CODE", "A32"."ESTIMATED_TAX_AMOUNT" "ESTIMATED_TAX_AMOUNT", "A32"."FROM_HEADER_ID" "FROM_HEADER_ID", "A32"."FROM_LINE_ID" "FROM_LINE_ID", "A32"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A32"."LEAD_TIME" "LEAD_TIME", "A32"."LEAD_TIME_UNIT" "LEAD_TIME_UNIT", "A32"."PRICE_DISCOUNT" "PRICE_DISCOUNT", "A32"."TERMS_ID" "TERMS_ID", "A32"."APPROVED_FLAG" "APPROVED_FLAG", "A32"."APPROVED_DATE" "APPROVED_DATE", "A32"."CLOSED_FLAG" "CLOSED_FLAG", "A32"."CANCELLED_BY" "CANCELLED_BY", "A32"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A32"."FIRM_DATE" "FIRM_DATE", "A32"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A32"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A32"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A32"."CREATION_DATE" "CREATION_DATE", "A32"."CREATED_BY" "CREATED_BY", "A32"."QUANTITY_RECEIVED" "QUANTITY_RECEIVED", "A32"."QUANTITY_ACCEPTED" "QUANTITY_ACCEPTED", "A32"."QUANTITY_REJECTED" "QUANTITY_REJECTED", "A32"."QUANTITY_BILLED" "QUANTITY_BILLED", "A32"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A32"."SHIP_VIA_LOOKUP_CODE" "SHIP_VIA_LOOKUP_CODE", "A32"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A32"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A32"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A32"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A32"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A32"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A32"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A32"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A32"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A32"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A32"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A32"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A32"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A32"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A32"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A32"."GLOBAL_ATTRIB UTE15" "GLOBAL_ATTRIBUTE15", "A32"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A32"."GLOBAL_ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A32"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A32"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A32"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A32"."QUANTITY_SHIPPED" "QUANTITY_SHIPPED", "A32"."COUNTRY_OF_ORIGIN_CODE" "COUNTRY_OF_ORIGIN_CODE", "A32"."TAX_USER_OVERRIDE_FLAG" "TAX_USER_OVERRIDE_FLAG", "A32"."MATCH_OPTION" "MATCH_OPTION", "A32"."TAX_CODE_ID" "TAX_CODE_ID", "A32"."CALCULATE_TAX_FLAG" "CALCULATE_TAX_FLAG", "A32"."CHANGE_PROMISED_DATE_REASON" "CHANGE_PROMISED_DATE_REASON", "A32"."NOTE_TO_RECEIVER" "NOTE_TO_RECEIVER", "A32"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A32"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A32"."PREFERRED_GRADE" "PREFERRED_GRADE", "A32"."SECONDARY_QUANTITY_RECEIVED" "SECONDARY_QUANTITY_RECEIVED", "A32"."SECONDARY_QUANTITY_ACCEPTED" "SECONDARY_QUANTITY_ACCEPTED", "A32"."SECONDARY_QUANTITY_REJECTED" "SECONDARY_QUANTITY_REJECTED", "A32"."SECONDARY_QUANTITY_CANCELLED" "SECONDARY_QUANTITY_CANCELLED", "A32"."VMI_FLAG" "VMI_FLAG", "A32"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A32"."SUPPLIER_ORDER_LINE_NUMBER" "SUPPLIER_ORDER_LINE_NUMBER", "A32"."AMOUNT" "AMOUNT", "A32"."AMOUNT_RECEIVED" "AMOUNT_RECEIVED", "A32"."AMOUNT_BILLED" "AMOUNT_BILLED", "A32"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A32"."AMOUNT_ACCEPTED" "AMOUNT_ACCEPTED", "A32"."AMOUNT_REJECTED" "AMOUNT_REJECTED", "A32"."DROP_SHIP_FLAG" "DROP_SHIP_FLAG", "A32"."SALES_ORDER_UPDATE_DATE" "SALES_ORDER_UPDATE_DATE", "A32"."SHIP_TO_LOCATION_ID" "SHIP_TO_LOCATION_ID", "A32"."SHIP_TO_LOCATION_NAME" "SHIP_TO_LOCATION_NAME", "A32"."SHIP_TO_ADDRESS_LINE1" "SHIP_TO_ADDRESS_LINE1", "A32"."SHIP_TO_ADDRESS_LINE2" "SHIP_TO_ADDRESS_LINE2", "A32"."SHIP_TO_ADDRESS_LINE3" "SHIP_TO_ADDRESS_LINE3", "A32"."SHIP_TO_ADDRESS_LINE4" "SHIP_TO_ADDRESS_LINE4", "A32"."SHIP_TO_ADDRESS_INFO" "SHIP_TO_ADDRESS_INFO", "A32"."SHIP_TO_COUNTRY" "SHIP_TO_COUNTRY", "A32"."IS_SHIPMENT_ONE_TIME_LOC" "IS_SHIPMENT_ONE_TIME_LOC", "A32"."ONE_TIME_ADDRESS_DETAILS" "ONE_TIME_ADDRESS_DETAILS", "A32"."DETAILS" "DETAILS", "A32"."SHIP_CONT_PHONE" "SHIP_CONT_PHONE", "A32"."SHIP_CONT_EMAIL" "SHIP_CONT_EMAIL", "A32"."ULTIMATE_DELIVER_CONT_PHONE" "ULTIMATE_DELIVER_CONT_PHONE", "A32"."ULTIMATE_DELIVER_CONT_EMAIL" "ULTIMATE_DELIVER_CONT_EMAIL", "A32"."SHIP_CONT_NAME" "SHIP_CONT_NAME", "A32"."ULTIMATE_DELIVER_CONT_NAME" "ULTIMATE_DELIVER_CONT_NAME", "A32"."SHIP_CUST_NAME" "SHIP_CUST_NAME", "A32 "."SHIP_CUST_LOCATION" "SHIP_CUST_LOCATION", "A32"."ULTIMATE_DELIVER_CUST_NAME" "ULTIMATE_DELIVER_CUST_NAME", "A32"."ULTIMATE_DELIVER_CUST_LOCATION" "ULTIMATE_DELIVER_CUST_LOCATION", "A32"."SHIP_TO_CONTACT_FAX" "SHIP_TO_CONTACT_FAX", "A32"."ULTIMATE_DELIVER_TO_CONT_NAME" "ULTIMATE_DELIVER_TO_CONT_NAME", "A32"."ULTIMATE_DELIVER_TO_CONT_FAX" "ULTIMATE_DELIVER_TO_CONT_FAX", "A32"."SHIPPING_METHOD" "SHIPPING_METHOD", "A32"."SHIPPING_INSTRUCTIONS" "SHIPPING_INSTRUCTIONS", "A32"."PACKING_INSTRUCTIONS" "PACKING_INSTRUCTIONS", "A32"."CUSTOMER_PRODUCT_DESC" "CUSTOMER_PRODUCT_DESC", "A32"."CUSTOMER_PO_NUM" "CUSTOMER_PO_NUM", "A32"."CUSTOMER_PO_LINE_NUM" "CUSTOMER_PO_LINE_NUM", "A32"."CUSTOMER_PO_SHIPMENT_NUM" "CUSTOMER_PO_SHIPMENT_NUM", "A32"."NEED_BY_DATE" "NEED_BY_DATE", "A32"."PROMISED_DATE" "PROMISED_DATE", "A32"."TOTAL_SHIPMENT_AMOUNT" "TOTAL_SHIPMENT_AMOUNT", "A32"."FINAL_MATCH_FLAG" "FINAL_MATCH_FLAG", "A32"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A32"."TAX_NAME" "TAX_NAME", "A32"."TRANSACTION_FLOW_HEADER_ID" "TRANSACTION_FLOW_HEADER_ID", "A32"."VALUE_BASIS" "VALUE_BASIS", "A32"."MATCHING_BASIS" "MATCHING_BASIS", "A32"."PAYMENT_TYPE" "PAYMENT_TYPE", "A32"."DESCRIPTION" "DESCRIPTION", "A32"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A32"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A32"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A32"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A32"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A32"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT", "A32"."WORK_APPROVER_ID" "WORK_APPROVER_ID", "A32"."BID_PAYMENT_ID" "BID_PAYMENT_ID", "A32"."AMOUNT_SHIPPED" "AMOUNT_SHIPPED", CURSOR (SELECT "A32"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A89"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A90", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A89" WHERE "A90"."ENTITY_NAME"='PO_SHIPMENTS' AND "A90"."PK1_VALUE"=TO_CHAR("A32"."LINE_LOCATION_ID") AND "A90"."FUNCTION_NAME"='PO_PRINTPO' AND "A90"."MEDIA_ID"="A89"."MEDIA_ID" AND "A90"."DATATYPE_ID"=1 ORDER BY "A90"."SEQ_NUM") "LINE_LOC_SHORT_TEXT", CURSOR (SELECT "A88"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A88" WHERE "A88"."ENTITY_NAME"='PO_SHIPMENTS' AND "A88"."PK1_VALUE"=TO_CHAR("A32"."LINE_LOCATION_ID") AND "A88"."DATATYPE_ID"=5 AND "A88"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A88"."SEQ_NUM") "LINE_LOC_URL_ATTACHMENTS", CURSOR (SELECT "A87"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A87" WHERE "A87"."ENTITY_NAME"='PO_SHIPM ENTS' AND "A87"."PK1_VALUE"=TO_CHAR("A32"."LINE_LOCATION_ID") AND "A87"."DATATYPE_ID"=6 AND "A87"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A87"."SEQ_NUM") "LINE_LOC_FILE_ATTACHMENTS", CURSOR (SELECT "A86"."AMOUNT_ORDERED" "AMOUNT_ORDERED", "A86"."AMOUNT_DELIVERED" "AMOUNT_DELIVERED", "A86"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A86"."DISTRIBUTION_TYPE" "DISTRIBUTION_TYPE", "A86"."AMOUNT_TO_ENCUMBER" "AMOUNT_TO_ENCUMBER", "A86"."INVOICE_ADJUSTMENT_FLAG" "INVOICE_ADJUSTMENT_FLAG", "A86"."DEST_CHARGE_ACCOUNT_ID" "DEST_CHARGE_ACCOUNT_ID", "A86"."DEST_VARIANCE_ACCOUNT_ID" "DEST_VARIANCE_ACCOUNT_ID", "A86"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A86"."PROJECT_ID" "PROJECT_ID", "A86"."TASK_ID" "TASK_ID", "A86"."EXPENDITURE_TYPE" "EXPENDITURE_TYPE", "A86"."PROJECT_ACCOUNTING_CONTEXT" "PROJECT_ACCOUNTING_CONTEXT", "A86"."EXPENDITURE_ORGANIZATION_ID" "EXPENDITURE_ORGANIZATION_ID", "A86"."GL_CLOSED_DATE" "GL_CLOSED_DATE", "A86"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A86"."EXPENDITURE_ITEM_DATE" "EXPENDITURE_ITEM_DATE", "A86"."ORG_ID" "ORG_ID", "A86"."GL_ENCUMBERED_PERIOD_NAME" "GL_ENCUMBERED_PERIOD_NAME", "A86"."GL_CANCELLED_DATE" "GL_CANCELLED_DATE", "A86"."DESTINATION_TYPE_CODE" "DESTINATION_TYPE_CODE", "A86"."DESTINATION_ORGANIZATION_ID" "DESTINATION_ORGANIZATION_ID", "A86"."DESTINATION_SUBINVENTORY" "DESTINATION_SUBINVENTORY", "A86"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A86"."ATTRIBUTE1" "ATTRIBUTE1", "A86"."ATTRIBUTE2" "ATTRIBUTE2", "A86"."ATTRIBUTE3" "ATTRIBUTE3", "A86"."ATTRIBUTE4" "ATTRIBUTE4", "A86"."ATTRIBUTE5" "ATTRIBUTE5", "A86"."ATTRIBUTE6" "ATTRIBUTE6", "A86"."ATTRIBUTE7" "ATTRIBUTE7", "A86"."ATTRIBUTE8" "ATTRIBUTE8", "A86"."ATTRIBUTE9" "ATTRIBUTE9", "A86"."ATTRIBUTE10" "ATTRIBUTE10", "A86"."ATTRIBUTE11" "ATTRIBUTE11", "A86"."ATTRIBUTE12" "ATTRIBUTE12", "A86"."ATTRIBUTE13" "ATTRIBUTE13", "A86"."ATTRIBUTE14" "ATTRIBUTE14", "A86"."ATTRIBUTE15" "ATTRIBUTE15", "A86"."WIP_ENTITY_ID" "WIP_ENTITY_ID", "A86"."WIP_OPERATION_SEQ_NUM" "WIP_OPERATION_SEQ_NUM", "A86"."WIP_RESOURCE_SEQ_NUM" "WIP_RESOURCE_SEQ_NUM", "A86"."WIP_REPETITIVE_SCHEDULE_ID" "WIP_REPETITIVE_SCHEDULE_ID", "A86"."WIP_LINE_ID" "WIP_LINE_ID", "A86"."BOM_RESOURCE_ID" "BOM_RESOURCE_ID", "A86"."BUDGET_ACCOUNT_ID" "BUDGET_ACCOUNT_ID", "A86"."ACCRUAL_ACCOUNT_ID" "ACCRUAL_ACCOUNT_ID", "A86"."VARIANCE_ACCOUNT_ID" "VARIANCE_ACCOUNT_ID", "A86"."PREVENT_ENCUMBRANCE_FLAG" "PREVENT_ENCUMBRANCE_FLAG", " A86"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A86"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A86"."PO_DISTRIBUTION_ID" "PO_DISTRIBUTION_ID", "A86"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A86"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A86"."PO_HEADER_ID" "PO_HEADER_ID", "A86"."PO_LINE_ID" "PO_LINE_ID", "A86"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A86"."SET_OF_BOOKS_ID" "SET_OF_BOOKS_ID", "A86"."CODE_COMBINATION_ID" "CODE_COMBINATION_ID", "A86"."QUANTITY_ORDERED" "QUANTITY_ORDERED", "A86"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A86"."CREATION_DATE" "CREATION_DATE", "A86"."CREATED_BY" "CREATED_BY", "A86"."PO_RELEASE_ID" "PO_RELEASE_ID", "A86"."QUANTITY_DELIVERED" "QUANTITY_DELIVERED", "A86"."QUANTITY_BILLED" "QUANTITY_BILLED", "A86"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A86"."REQ_HEADER_REFERENCE_NUM" "REQ_HEADER_REFERENCE_NUM", "A86"."REQ_LINE_REFERENCE_NUM" "REQ_LINE_REFERENCE_NUM", "A86"."REQ_DISTRIBUTION_ID" "REQ_DISTRIBUTION_ID", "A86"."DELIVER_TO_LOCATION_ID" "DELIVER_TO_LOCATION_ID", "A86"."DELIVER_TO_PERSON_ID" "DELIVER_TO_PERSON_ID", "A86"."RATE_DATE" "RATE_DATE", "A86"."RATE" "RATE", "A86"."AMOUNT_BILLED" "AMOUNT_BILLED", "A86"."ACCRUED_FLAG" "ACCRUED_FLAG", "A86"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A86"."ENCUMBERED_AMOUNT" "ENCUMBERED_AMOUNT", "A86"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A86"."UNENCUMBERED_AMOUNT" "UNENCUMBERED_AMOUNT", "A86"."FAILED_FUNDS_LOOKUP_CODE" "FAILED_FUNDS_LOOKUP_CODE", "A86"."GL_ENCUMBERED_DATE" "GL_ENCUMBERED_DATE", "A86"."KANBAN_CARD_ID" "KANBAN_CARD_ID", "A86"."END_ITEM_UNIT_NUMBER" "END_ITEM_UNIT_NUMBER", "A86"."AWARD_ID" "AWARD_ID", "A86"."MRC_RATE_DATE" "MRC_RATE_DATE", "A86"."MRC_RATE" "MRC_RATE", "A86"."MRC_ENCUMBERED_AMOUNT" "MRC_ENCUMBERED_AMOUNT", "A86"."MRC_UNENCUMBERED_AMOUNT" "MRC_UNENCUMBERED_AMOUNT", "A86"."RECOVERABLE_TAX" "RECOVERABLE_TAX", "A86"."NONRECOVERABLE_TAX" "NONRECOVERABLE_TAX", "A86"."RECOVERY_RATE" "RECOVERY_RATE", "A86"."TAX_RECOVERY_OVERRIDE_FLAG" "TAX_RECOVERY_OVERRIDE_FLAG", "A86"."OKE_CONTRACT_LINE_ID" "OKE_CONTRACT_LINE_ID", "A86"."OKE_CONTRACT_DELIVERABLE_ID" "OKE_CONTRACT_DELIVERABLE_ID", "A86"."DESTINATION_CONTEXT" "DESTINATION_CONTEXT", "A86"."DISTRIBUTION_NUM" "DISTRIBUTION_NUM", "A86"."SOURCE_DISTRIBUTION_ID" "SOURCE_DISTRIBUTION_ID", "A86"."REQUEST_ID" "REQUEST_ID", "A86"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A86"."PROGRAM_ID" "PROGRAM_ID", "A86"."CHARGE_ACCOUNT " "CHARGE_ACCOUNT", "A86"."FULL_NAME" "FULL_NAME", "A86"."WORK_TELEPHONE" "WORK_TELEPHONE", "A86"."EMAIL_ADDRESS" "EMAIL_ADDRESS", "A86"."REQUESTER_DELIVER_FIRST_NAME" "REQUESTER_DELIVER_FIRST_NAME", "A86"."REQUESTER_DELIVER_LAST_NAME" "REQUESTER_DELIVER_LAST_NAME", "A86"."REQUESTER_DELIVER_TITLE" "REQUESTER_DELIVER_TITLE", "A86"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A86"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A86"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A86"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A86"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A86"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT" FROM "PO_DISTRIBUTION_XML" "A86" WHERE "A86"."PO_HEADER_ID"=:CV1$ AND "A86"."LINE_LOCATION_ID"="A32"."LINE_LOCATION_ID") "DISTRIBUTIONS" FROM "PO_LINE_LOCATIONS_XML" "A32" WHERE "A32"."PO_LINE_ID"="A2"."PO_LINE_ID" AND NVL("A32"."PAYMENT_TYPE", 'NONE')<>'ADVANCE' AND NVL("A32"."PAYMENT_TYPE", 'NONE')<>'DELIVERY') "LINE_LOCATIONS" FROM "PO_LINES_XML" "A2" WHERE "A2"."PO_HEADER_ID"=:CV1$
85gad38y8bvv3begin :1 :=PO_COMMUNICATION_PVT.POXMLGEN( :2, :3, :4, :5, :6, :7, :8, :9); end;
8w57t3xaxs89kSELECT NAME, VERSION FROM FND_CACHE_VERSIONS
9tssyu6p7uk2sSELECT SUM(AID.AMOUNT) FROM AP_INVOICE_DISTRIBUTIONS AID, AP_INVOICE_LINES AIL WHERE AID.INVOICE_ID = :B2 AND AID.INVOICE_LINE_NUMBER = :B1 AND AIL.INVOICE_ID = AID.INVOICE_ID AND AIL.LINE_NUMBER = AID.INVOICE_LINE_NUMBER AND AIL.LINE_TYPE_LOOKUP_CODE IN ('ITEM', 'RETAINAGE RELEASE') AND AID.PARENT_REVERSAL_ID IS NULL AND (AID.LINE_TYPE_LOOKUP_CODE = 'PREPAY' OR (AID.LINE_TYPE_LOOKUP_CODE IN ('REC_TAX', 'NONREC_TAX') AND AID.PREPAY_DISTRIBUTION_ID IS NOT NULL) OR (AID.LINE_TYPE_LOOKUP_CODE IN ('TIPV', 'TRV', 'TERV') AND AID.RELATED_ID IN (SELECT INVOICE_DISTRIBUTION_ID FROM AP_INVOICE_DISTRIBUTIONS AID1 WHERE AID1.INVOICE_ID = AID.INVOICE_ID AND AID1.INVOICE_LINE_NUMBER = AID.INVOICE_LINE_NUMBER AND AID1.LINE_TYPE_LOOKUP_CODE IN ('REC_TAX', 'NONREC_TAX') AND AID1.PREPAY_DISTRIBUTION_ID IS NOT NULL) ) )
9ybx57rqdhm4mBEGIN PO_INTERFACE_S.create_documents( p_api_version => 1.0, x_return_status => :1, x_msg_count => :2, x_msg_data => :3, p_batch_id => :4, p_req_operating_unit_id => :5, p_purch_operating_unit_id => :6, x_document_id => :7, x_number_lines => :8, x_document_number => :9, p_document_creation_method => 'AUTOCREATE'); END;
a4gss3ajbyfzrSELECT R.RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL R WHERE R.RESPONSIBILITY_ID = :B2 AND R.APPLICATION_ID = :B1
aaw4na3kmdfkqDECLARE l_result varchar2(1); BEGIN l_result := FND_AOLJ_UTIL.convertGuestSession(:1, :2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); :21 := l_result;END;
akma8kaxsp84b SELECT reservation_id , requirement_date , organization_id , inventory_item_id , demand_source_type_id , demand_source_name , demand_source_header_id , demand_source_line_id , demand_source_delivery , primary_uom_code , primary_uom_id , secondary_uom_code , secondary_uom_id , reservation_uom_code , reservation_uom_id , reservation_quantity , primary_reservation_quantity , secondary_reservation_quantity , detailed_quantity , secondary_detailed_quantity , autodetail_group_id , external_source_code , external_source_line_id , supply_source_type_id , supply_source_header_id , supply_source_line_id , supply_source_name , supply_source_line_detail , revision , subinventory_code , subinventory_id , locator_id , lot_number , lot_number_id , pick_slip_number , lpn_id , attribute_category , attribute1 , attribute2 , attribute3 , attribute4 , attribute5 , attribute6 , attribute7 , attribute8 , attribute9 , attribute10 , attribute11 , attribute12 , attribute13 , attribute14 , attribute15 , ship_ready_flag , staged_flag /**** {{ R12 Enhanced reservations code changes }}****/ , crossdock_flag , crossdock_criteria_id , demand_source_line_detail , serial_reservation_quantity , supply_receipt_date , demand_ship_date , project_id , task_id , orig_supply_source_type_id , orig_supply_source_header_id , orig_supply_source_line_id , orig_supply_source_line_detail , orig_demand_source_type_id , orig_demand_source_header_id , orig_demand_source_line_id , orig_demand_source_line_detail , serial_number /***** End R12 ***/ FROM mtl_reservations WHERE (:requirement_date = :l_miss_date OR :requirement_date IS NULL AND requirement_date IS NULL OR :requirement_date = requirement_date ) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id ) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id ) AND (:demand_source_type_id = :l_miss_num OR :demand_source_type_id IS NULL AND demand_source_type_id IS NULL OR :demand_source_type_id = demand_source_type_id ) AND (:demand_source_header_id = :l_miss_num OR :demand_source_header_id IS NULL AND demand_source_header_id IS NULL OR :demand_source_header_id = demand_source_header_id ) AND (:demand_source_line_id = :l_miss_num OR :demand_source_line_id IS NULL AND demand_source_line_id IS NULL OR :demand_source_line_id = demand_source_line_id ) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name ) AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery ) AND (:primary_uom_code = :l_miss_char OR :primary_uom_code IS NULL AND primary_uom_code IS NULL OR :primary_uom_code = primary_uom_code ) AND (:primary_uom_id = :l_miss_num OR :primary_uom_id IS NULL AND primary_uom_id IS NULL OR :primary_uom_id = primary_uom_id ) -- INVCONV BEGIN AND (:secondary_uom_code = :l_miss_char OR :secondary_uom_code IS NULL AND secondary_uom_code IS NULL OR :secondary_uom_code = secondary_uom_code ) AND (:secondary_uom_id = :l_miss_num OR :secondary_uom_id IS NULL AND secondary_uom_id IS NULL OR :secondary_uom_id = secondary_uom_id ) -- INVCONV END AND (:reservation_uom_code = :l_miss_char OR :reservation_uom_code IS NULL AND reservation_uom_code IS NULL OR :reservation_uom_code = reservation_uom_code ) AND (:reservation_uom_id = :l_miss_num OR :reservation_uom_id IS NULL AND reservation_uom_id IS NULL OR :reservation_uom_id = reservation_uom_id ) AND (:autodetail_group_id = :l_miss_num OR :autodetail_group_id IS NULL AND autodetail_group_id IS NULL OR :autodetail_group_id = autodetail_group_id ) AND (:external_source_code = :l_miss_char OR :external_source_code IS NULL AND external_source_code IS NULL OR :external_s ource_code = external_source_code ) AND (:external_source_line_id = :l_miss_num OR :external_source_line_id IS NULL AND external_source_line_id IS NULL OR :external_source_line_id = external_source_line_id ) AND (:supply_source_type_id = :l_miss_num OR :supply_source_type_id IS NULL AND supply_source_type_id IS NULL OR :supply_source_type_id = supply_source_type_id ) AND (:supply_source_header_id = :l_miss_num OR :supply_source_header_id IS NULL AND supply_source_header_id IS NULL OR :supply_source_header_id = supply_source_header_id ) AND (:supply_source_line_id = :l_miss_num OR :supply_source_line_id IS NULL AND supply_source_line_id IS NULL OR :supply_source_line_id = supply_source_line_id ) AND (:supply_source_name = :l_miss_char OR :supply_source_name IS NULL AND supply_source_name IS NULL OR :supply_source_name = supply_source_name ) AND (:supply_source_line_detail = :l_miss_num OR :supply_source_line_detail IS NULL AND supply_source_line_detail IS NULL OR :supply_source_line_detail = supply_source_line_detail ) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision ) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code ) AND (:subinventory_id = :l_miss_num OR :subinventory_id IS NULL AND subinventory_id IS NULL OR :subinventory_id = subinventory_id ) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id ) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number ) AND (:lot_number_id = :l_miss_num OR :lot_number_id IS NULL AND lot_number_id IS NULL OR :lot_number_id = lot_number_id ) AND (:lpn_id = :l_miss_num OR :lpn_id IS NULL AND lpn_id IS NULL OR :lpn_id = lpn_id ) AND (:ship_ready_flag = :l_miss_num OR (:ship_ready_flag IS NULL OR :ship_ready_flag = 2) AND (ship_ready_flag IS NULL OR ship_ready_flag = 2) OR :ship_ready_flag = ship_ready_flag ) AND (:staged_flag = :l_miss_char OR (:staged_flag IS NULL OR :staged_flag = 'N') AND (staged_flag IS NULL OR staged_flag = 'N') OR :staged_flag = staged_flag ) AND (:attribute_category = :l_miss_char OR :attribute_category IS NULL AND attribute_category IS NULL OR :attribute_category = attribute_category ) AND (:attribute1 = :l_miss_char OR :attribute1 IS NULL AND attribute1 IS NULL OR :attribute1 = attribute1 ) AND (:attribute2 = :l_miss_char OR :attribute2 IS NULL AND attribute2 IS NULL OR :attribute2 = attribute2 ) AND (:attribute3 = :l_miss_char OR :attribute3 IS NULL AND attribute3 IS NULL OR :attribute3 = attribute3 ) AND (:attribute4 = :l_miss_char OR :attribute4 IS NULL AND attribute4 IS NULL OR :attribute4 = attribute4 ) AND (:attribute5 = :l_miss_char OR :attribute5 IS NULL AND attribute5 IS NULL OR :attribute5 = attribute5 ) AND (:attribute6 = :l_miss_char OR :attribute6 IS NULL AND attribute6 IS NULL OR :attribute6 = attribute6 ) AND (:attribute7 = :l_miss_char OR :attribute7 IS NULL AND attribute7 IS NULL OR :attribute7 = attribute7 ) AND (:attribute8 = :l_miss_char OR :attribute8 IS NULL AND attribute8 IS NULL OR :attribute8 = attribute8 ) AND (:attribute9 = :l_miss_char OR :attribute9 IS NULL AND attribute9 IS NULL OR :attribute9 = attribute9 ) AND (:attribute10 = :l_miss_char OR :attribute10 IS NULL AND attribute10 IS NULL OR :attribute10 = attribute10 ) AND (:attribute11 = :l_miss_char OR :attribute11 IS NULL AND attribute11 IS NULL OR :attribute11 = attribute11 ) AND (:attribute12 = :l_miss_char OR :attribute12 IS NULL AND attribute12 IS NULL OR :attribute12 = attribute12 ) AND (:attribute13 = :l_miss_char OR :attribute13 IS NULL AND attribute13 IS NULL OR :attribute13 = attribute13 ) AND (:attribute14 = :l_miss_char OR :attribute14 IS NULL AND attribute14 IS NULL OR :attribute14 = attribute14 ) AND (:attribute15 = :l_miss_char OR :attribute15 IS NULL AND attribute15 IS NULL OR :attribute15 = attribute15 ) /**** {{ R12 Enhanced reserv ations code changes }}****/ AND (:crossdock_flag = :l_miss_char OR :crossdock_flag IS NULL AND crossdock_flag IS NULL OR :crossdock_flag = crossdock_flag ) AND (:crossdock_criteria_id = :l_miss_num OR :crossdock_criteria_id IS NULL AND crossdock_criteria_id IS NULL OR :crossdock_criteria_id = crossdock_criteria_id ) AND (:demand_source_line_detail = :l_miss_num OR :demand_source_line_detail IS NULL AND demand_source_line_detail IS NULL OR :demand_source_line_detail = demand_source_line_detail ) AND (:supply_receipt_date = :l_miss_date OR :supply_receipt_date IS NULL AND supply_receipt_date IS NULL OR :supply_receipt_date = supply_receipt_date ) AND (:demand_ship_date = :l_miss_date OR :demand_ship_date IS NULL AND demand_ship_date IS NULL OR :demand_ship_date = demand_ship_date ) AND (:project_id = :l_miss_num OR :project_id IS NULL AND project_id IS NULL OR :project_id = project_id ) AND (:task_id = :l_miss_num OR :task_id IS NULL AND task_id IS NULL OR :task_id = task_id ) /***** End R12 ***/ ORDER BY NVL(DEMAND_SHIP_DATE, REQUIREMENT_DATE) ASC
bbugagurwv1vy(SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 ))
bqf04xkudk4ztBEGIN :1 := FND_AOLJ_UTIL.createSession(:2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22);:23 := fnd_session_management.g_enc_key;:24 := fnd_session_management.g_mac_key;END;
bw5t54n7fjk02SELECT INVENTORY_ORGANIZATION_ID FROM FINANCIALS_SYSTEM_PARAMETERS
ccprbqfuu8wb1SELECT NUMBER_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
ctnvq3qjh4065begin :1 := por_util_pkg.interface_START_WORKFLOW( :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102); end;
dnx99s71vmu3rSELECT POA.AGENT_ID FROM PO_AGENTS POA, MTL_ITEM_CATEGORIES MIC WHERE MIC.INVENTORY_ITEM_ID=:B2 AND MIC.CATEGORY_ID=POA.CATEGORY_ID AND MIC.ORGANIZATION_ID=:B1 AND MIC.CATEGORY_SET_ID=(SELECT CATEGORY_SET_ID FROM MTL_DEFAULT_SETS_VIEW WHERE FUNCTIONAL_AREA_ID = 2)
fc1vzazaaduns SELECT phx.*, PO_COMMUNICATION_PVT.getIsComplexWorkPO() is_complex_work_po, PO_COMMUNICATION_PVT.getDocumentType() document_type, PO_COMMUNICATION_PVT.getCoverMessage() cover_message, PO_COMMUNICATION_PVT.getTimezone() timezone, PO_COMMUNICATION_PVT.getAmendmentMessage() ammendment_message, PO_COMMUNICATION_PVT.getTestFlag() test_flag, PO_COMMUNICATION_PVT.getDistinctShipmentCount() DIST_SHIPMENT_COUNT, PO_COMMUNICATION_PVT.getDocumentName() document_name, PO_COMMUNICATION_PVT.IsDocumentSigned(PO_COMMUNICATION_PVT.getDocumentId()) Signed, fnd_profile.value('PO_GENERATE_AMENDMENT_DOCS') amendment_profile, PO_COMMUNICATION_PVT.getWithTerms() With_Terms , PO_COMMUNICATION_PVT.getIsContractAttachedDoc() Is_Attached_Doc , CURSOR (SELECT message_name message, message_text text FROM fnd_new_messages WHERE message_name in ( 'PO_WF_NOTIF_REVISION', 'PO_WF_NOTIF_VENDOR_NO', 'PO_WF_NOTIF_PAYMENT_TERMS', 'PO_WF_NOTIF_FREIGHT_TERMS', 'PO_WF_NOTIF_FOB', 'PO_WF_NOTIF_SHIP_VIA', 'PO_WF_NOTIF_CONFIRM_TO_TELE', 'PO_WF_NOTIF_REQUESTER_DELIVER', 'PO_WF_NOTIF_DESCRIPTION', 'PO_WF_NOTIF_TAX', 'PO_WF_NOTIF_UOM', 'PO_WF_NOTIF_UNIT_PRICE', 'PO_WF_NOTIF_QUANTITY', 'PO_WF_NOTIF_PURCHASE_ORDER', 'PO_WF_NOTIF_BUYER', 'PO_WF_NOTIF_AMOUNT', 'PO_WF_NOTIF_EFFECTIVE_DATE', 'PO_WF_NOTIF_HEADER_NOTE', 'PO_WF_NOTIF_LINE_NUMBER', 'PO_WF_NOTIF_LINE_PAYITEM_NUM', -- <Complex Work R12> 'PO_WF_NOTIF_MULTIPLE', 'PO_WF_NOTIF_PART_NO_DESC', 'PO_WF_NOTIF_SUPPLIER_ITEM', 'PO_WF_NOTIF_TOTAL', 'PO_WF_NOTIF_NOTE', 'PO_FO_PACKING_INSTRUCTION', 'PO_FO_CUST_PO_NUMBER', 'PO_FO_CUST_ITEM_DESC', 'PO_FO_LINE_NUMBER', 'PO_FO_SHIP_NUMBER', 'PO_FO_AMOUNT_BASED', 'PO_FO_CONTRACTOR_NAME', 'PO_FO_START_DATE', 'PO_FO_END_DATE', 'PO_FO_WORK_SCHEDULE', 'PO_FO_SHIFT_PATTERN', 'PO_FO_PRICE_DIFFERENTIALS', 'PO_FO_DELIVER_TO_LOCATION', 'PO_FO_EFFECTIVE_START_DATE', 'PO_FO_AMOUNT_AGREED', 'PO_FO_ADVANCE', -- <Complex Work R12> 'PO_FO_RETAINAGE_RATE', -- <Complex Work R12> 'PO_FO_MAX_RETAINAGE_AMOUNT', -- <Complex Work R12> 'PO_FO_PROGRESS_PAYMENT_RATE', -- <Complex Work R12> 'PO_FO_RECOUPMENT_RATE', -- <Complex Work R12> 'PO_FO_PRICE_BREAK', 'PO_FO_CHARGE_ACCOUNT', 'PO_FO_CONTRACTOR', 'PO_FO_CONTACT_NAME', 'PO_FO_TELEPHONE', 'PO_FO_FAX', 'PO_FO_NAME', 'PO_FO_TITLE', 'PO_FO_DATE', 'PO_FO_REVISION', 'PO_FO_AMENDMENT', 'PO_FO_SHIP_METHOD', 'PO_FO_SHIPPING_INSTRUCTION', 'PO_FO_DRAFT', 'PO_FO_PROPRIETARY_INFORMATION', 'PO_FO_TRANSPORTAION_ARRANGED', 'PO_FO_DELIVER_TO_LOCATION', 'PO_FO_NO', 'PO_FO_COMPANY', 'PO_FO_SUBMIT_RESPONSE', 'PO_FO_EMAIL', 'PO_WF_NOTIF_EXPIRES_ON', 'PO_FO_TEST', 'PO_FO_ORG_AGR_ASS', 'PO_FO_EFFECTIVE_END_DATE', 'PO_FO_PURCHASING_ORGANIZATION', 'PO_FO_PURCHASING_SUPPLIER_SITE', 'PO_FO_TRANSPORTATION_ARRANGED', 'PO_WF_NOTIF_ADDRESS', 'PO_WF_NOTIF_ORDER', 'PO_WF_NOTIF_ORDER_DATE', 'PO_FO_VENDOR', 'PO_FO_SHIP_TO', 'PO_FO_BILL_TO', 'PO_FO_CONFIRM_NOT_DUPLICATE', 'PO_FO_AGREEMENT_CANCELED', 'PO_FO_FORMAL_ACCEPT', 'PO_FO_TYPE', 'PO_FO_REVISION_DATE', 'PO_FO_REVISED_BY', 'PO_FO_PRICES_EXPRESSED', 'PO_FO_NOTES', 'PO_WF_NOTIF_PREPARER', 'PO_FO_SUPPLIER_CONFIGURATION', 'PO_FO_DELIVER_DATE_TIME', 'PO_FO_LINE_REF_BPA', 'PO_FO_LINE_REF_CONTRACT', 'PO_FO_LINE_SUPPLIER_QUOTATION', 'PO_FO_USE_SHIP_ADDRESS_TOP', 'PO_FO_LINE_CANCELED', 'PO_FO_ORIGINAL_QTY_ORDERED', 'PO_FO_QUANTITY_CANCELED', 'PO_FO_SHIPMENT_CANCELED', 'PO_FO_ORIGINAL_SHIPMENT_QTY', 'PO_FO_CUSTOMER_ACCOUNT_NO', 'PO_FO_RELEASE_CANCELED', 'PO_FO_PO_CANCELED', 'PO_FO_TOTAL', 'PO_FO_SUPPLIER_ITEM', 'PO_FO_ORIGINAL_AMOUNT_ORDERED', 'PO_FO_AMOUNT_CANCELED', 'PO_FO_UN_NUMBER', 'PO_WF_NOTIF_PROMISED_DATE', 'PO_WF_NOTIF_NEEDBY_DATE', 'PO_FO_HAZARD_CLASS', 'PO_FO_PAGE', 'PO_FO_REFERENCE_DOCUMENTS', 'PO_FO_PAYITEM_CANCELED', --<Bug#: 4899200> 'PO_FO_ORIGINAL_PAYITEM_QTY', --<Bug#: 4899200> 'PO_FO_PAYITEM_QTY_CANCELED', --<Bug#: 4899200> 'PO_FO_ORIGINAL_PAYITEM_AMT', --<Bug#: 5464968> 'PO_FO_MODIFIER_TYPE', --Enhanced Pricing 'PO_FO_BLANKET', --Enhanced Pricing 'PO_FO_BLANKET_PRICE_STRUCT', --Enhanced Pricing 'PO_FO_MODIFIER_DESC', --Enhanced Pricing 'PO_FO_RATE', --Enhanced Pricing 'PO_FO_ADJUSTED_AMT', --Enhanced Pricing 'PO_FO_RATE_APP_METHOD', --Enhanced Pricing 'PO_FO_LIST_LINE_PRICE', --Enhanced Pricing 'PO_FO_PAYITEM_AMT_CANCELED' --<Bug#: 5464968> ) AND application_id = 201 AND language_code = 'US') AS message, CURSOR( SELECT fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE ((entity_name = 'PO_HEADERS' AND pk1_value = to_char(phx.po_header_id)) OR (entity_name = 'PO_VENDORS' AND pk1_value = to_char(phx.vendor_id)) OR (entity_name = 'PO_VENDOR_SITES' AND pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354 function_name = 'PO_PRINTPO' AND fad.media_id = fds.media_id AND fad.datatype_id=1 order by fad.seq_num) AS header_short_text, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name='PO_VENDORS' AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name='PO_VENDOR_SITES' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=5 AND fad.function_name='PO_PRINTPO' order by fad.entity_name, fad.seq_num) AS header_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name='PO_VENDORS' AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name='PO_VENDOR_SITES' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=6 AND fad.function_name='PO_PRINTPO' order by fad.entity_name, fad.seq_num) AS header_file_attachments, CURSOR(SELECT plx.*, CURSOR(SELECT PRICE_TYPE_DSP PRICE_TYPE, MULTIPLIER FROM po_price_differentials_v WHERE entity_type='PO LINE' AND entity_id = plx.po_line_id and enabled_flag='Y') AS price_diff, CURSOR( SELECT plx.po_line_id , fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE ((fad.entity_name='PO_LINES' AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name='MTL_SYSTEM_ITEMS' AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND --Bug6139548 fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name='PO_IN_GA_LINES' AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.CONTRACT_ID) AND plx.CONTRACT_ID IS NOT NULL) ) AND function_name = 'PO_PRINTPO' AND fad.media_id = fds.media_id AND fad.datatype_id=1 order by fad.seq_num) AS line_short_text, CURSOR (SELECT pax1.* FROM PO_PRICE_ADJUSTMENTS_XML pax1 WHERE pax1.po_header_id = plx.po_header_id AND pax1.po_line_id = plx.po_line_id AND pax1.parent_adjustment_id is null order by pax1.pricing_group_sequence) AS PRICE_MODIFIERS, CURSOR (SELECT pax2.* FROM PO_PRICE_ADJUSTMENTS_XML pax2 WHERE pax2.po_header_id = plx.from_header_id AND pax2.po_line_id = plx.from_line_id AND pax2.parent_adjustment_id is null order by pax2.pricing_group_sequence) AS ADD_PRICE_MODIFIERS, CURSOR (SELECT pha.segment1 ponum FROM po_headers_all pha WHERE pha.po_header_id = plx.from_header_id) AS ADD_PRICE_PONUM, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_LINES' AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name='PO_IN_GA_LINES' AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NO T NULL) OR (fad.entity_name='MTL_SYSTEM_ITEMS' AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) ) AND fad.datatype_id=5 AND fad.function_name='PO_PRINTPO' order by fad.seq_num) AS line_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_LINES' AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name='PO_IN_GA_LINES' AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NOT NULL) OR (fad.entity_name='MTL_SYSTEM_ITEMS' AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) ) AND fad.datatype_id=6 AND fad.function_name='PO_PRINTPO' order by fad.seq_num) AS line_file_attachments, CURSOR(SELECT pllx.*, CURSOR( SELECT pllx.line_location_id, fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE entity_name = 'PO_SHIPMENTS' AND pk1_value = to_char(pllx.line_location_id) AND function_name = 'PO_PRINTPO' AND fad.media_id = fds.media_id AND fad.datatype_id=1 order by fad.seq_num) AS line_loc_short_text, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE fad.entity_name='PO_SHIPMENTS' AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=5 AND fad.function_name='PO_PRINTPO' order by fad.seq_num ) AS line_loc_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE fad.entity_name='PO_SHIPMENTS' AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=6 AND fad.function_name='PO_PRINTPO' order by fad.seq_num) AS line_loc_file_attachments, CURSOR(SELECT pdx.* FROM po_distribution_xml pdx WHERE pdx.po_header_id = phx.po_header_id and pdx.LINE_LOCATION_ID = pllx.LINE_LOCATION_ID) AS distributions FROM po_line_locations_xml pllx WHERE pllx.po_line_id = plx.po_line_id AND NVL(pllx.payment_type, 'NONE') NOT IN ('ADVANCE', 'DELIVERY') ) AS line_locations FROM po_lines_xml plx WHERE plx.po_header_id = phx.po_header_id ) AS lines FROM PO_HEADERS_XML phx WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()
fjvwzpxbpch0h/* OracleOEM */ select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STREAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT c.apply_name, state, -- This is the XOUT case c.hwm_time as apply_time, hwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name in (select server_name from dba_xstream_outbound) union SELECT c.apply_name, state, -- This is non-XOUT case c.lwm_time as apply_time, lwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name not in (select server_name from dba_xstream_outbound) ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name
g4pktka6kg4w9SELECT MENU_ID, ENTRY_SEQUENCE, FUNCTION_ID, SUB_MENU_ID, GRANT_FLAG FROM FND_MENU_ENTRIES WHERE MENU_ID = :B1
g89s7tq651bus INSERT INTO ZX_TRANSACTION_LINES_GT( APPLICATION_ID , ENTITY_CODE , EVENT_CLASS_CODE , TRX_ID , TRX_LEVEL_TYPE , TRX_LINE_ID , LINE_LEVEL_ACTION , LINE_CLASS , TRX_LINE_TYPE , TRX_LINE_DATE , TRX_BUSINESS_CATEGORY , LINE_INTENDED_USE , USER_DEFINED_FISC_CLASS , LINE_AMT , TRX_LINE_QUANTITY , PRODUCT_ID , PRODUCT_ORG_ID , PRODUCT_FISC_CLASSIFICATION , UOM_CODE , PRODUCT_TYPE , PRODUCT_CODE , PRODUCT_CATEGORY , FOB_POINT , SHIP_FROM_PARTY_ID , BILL_FROM_PARTY_ID , SHIP_FROM_PARTY_SITE_ID , BILL_FROM_PARTY_SITE_ID , SHIP_TO_LOCATION_ID , SHIP_FROM_LOCATION_ID , BILL_TO_LOCATION_ID , BILL_FROM_LOCATION_ID , ACCOUNT_CCID , REF_DOC_APPLICATION_ID , REF_DOC_ENTITY_CODE , REF_DOC_EVENT_CLASS_CODE , REF_DOC_TRX_ID , REF_DOC_LINE_ID , LINE_TRX_USER_KEY1 , LINE_TRX_USER_KEY2 , LINE_TRX_USER_KEY3 , TRX_LINE_NUMBER , TRX_LINE_DESCRIPTION , PRODUCT_DESCRIPTION , ASSESSABLE_VALUE , LINE_AMT_INCLUDES_TAX_FLAG , INPUT_TAX_CLASSIFICATION_CODE , SOURCE_APPLICATION_ID , SOURCE_ENTITY_CODE , SOURCE_EVENT_CLASS_CODE , SOURCE_TRX_ID , SOURCE_LINE_ID , SOURCE_TRX_LEVEL_TYPE , UNIT_PRICE , REF_DOC_TRX_LEVEL_TYPE , SHIP_THIRD_PTY_ACCT_ID , BILL_THIRD_PTY_ACCT_ID , SHIP_THIRD_PTY_ACCT_SITE_ID , BILL_THIRD_PTY_ACCT_SITE_ID , SHIP_TO_PARTY_ID , USER_UPD_DET_FACTORS_FLAG , DEFAULTING_ATTRIBUTE1 ) SELECT :B5 , :B4 , :B3 , PH.PO_HEADER_ID , :B2 , PLL.LINE_LOCATION_ID , PLL.TAX_ATTRIBUTE_UPDATE_CODE , DECODE(PLL.SHIPMENT_TYPE, 'PREPAYMENT', DECODE(PLL.PAYMENT_TYPE, 'ADVANCE', 'ADVANCE', 'FINANCING'), DECODE(PLL.VALUE_BASIS, 'QUANTITY', 'INVOICE', 'AMOUNT') ) , 'ITEM' , COALESCE(PLL.NEED_BY_DATE, PLL.PROMISED_DATE, SYSDATE) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.TRX_BUSINESS_CATEGORY) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.LINE_INTENDED_USE) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.USER_DEFINED_FISC_CLASS) , NVL(PLL.AMOUNT, PLL.PRICE_OVERRIDE*PLL.QUANTITY) , PLL.QUANTITY , PL.ITEM_ID , (SELECT FSP.INVENTORY_ORGANIZATION_ID FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP WHERE FSP.ORG_ID=PLL.ORG_ID) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.PRODUCT_FISC_CLASSIFICATION) , (SELECT MUM.UOM_CODE FROM MTL_UNITS_OF_MEASURE MUM WHERE MUM.UNIT_OF_MEASURE=PLL.UNIT_MEAS_LOOKUP_CODE) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.PRODUCT_TYPE) , MSIB.SEGMENT1 , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.PRODUCT_CATEGORY) , PH.FOB_LOOKUP_CODE , PV.PARTY_ID , PV.PARTY_ID , PVS.PARTY_SITE_ID , PVS.PARTY_SITE_ID , PLL.SHIP_TO_LOCATION_ID , (SELECT HZPS.LOCATION_ID FROM HZ_PARTY_SITES HZPS WHERE HZPS.PARTY_SITE_ID = PVS.PARTY_SITE_ID) , PH.BILL_TO_LOCATION_ID , (SELECT PVS.LOCATION_ID FROM PO_VENDOR_SITES_ALL PVS WHERE PVS.VENDOR_SITE_ID=PH.VENDOR_SITE_ID) , NVL((SELECT PD.CODE_COMBINATION_ID FROM PO_DISTRIBUTIONS_ALL PD WHERE PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND ROWNUM = 1), MSIB.EXPENSE_ACCOUNT ) , NULL , NULL , NULL , NULL , NULL , PL.LINE_NUM , PO_LOCATIONS_S.GET_LOCATION_CODE(PLL.SHIP_TO_LOCATION_ID) , DECODE(PLL.PAYMENT_TYPE, NULL, 0, 'DELIVERY', 1, 'ADVANCE', 2, 3) , DECODE(PLL.PAYMENT_TYPE, 'ADVANCE', NULL, 'DELIVERY', NULL, PLL.SHIPMENT_NUM) , DECODE(PLL.SHIPMENT_TYPE, 'STANDARD', DECODE(PLL.PAYMENT_TYPE, NULL, PL.ITEM_DESCRIPTION, PLL.DESCRIPTION ), PL.ITEM_DESCRIPTION ) , DECODE(PLL.SHIPMENT_TYPE, 'STANDARD', DECODE(PLL.PAYMENT_TYPE, NULL, PL.ITEM_DESCRIPTION, PLL.DESCRIPTION ), PL.ITEM_DESCRIPTION ) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.ASSESSABLE_VALUE) , 'N' , DECODE(:B7 , 'PDOI', PLL.TAX_NAME, 'COPY_DOCUMENT', NULL, ZXLDET.INPUT_TAX_CLASSIFICATION_CODE) , DECODE(:B7 , 'COPY_DOCUMENT', :B5 , 'POXBWVRP_PO', :B5 , 'AUTOCREATED_DOC_WF' , :B5 , 'PORELGEB', :B5 , NULL) , DECODE(:B7 , 'COPY_DOCUMENT', :B4 , 'POXBWVRP_PO', :B9 , 'AUTOCREATED_DOC_WF', :B9 , 'PORELGEB', :B9 , NULL) , DECODE(:B7 , 'COPY_DOCUMENT', :B3 , 'POXBWVRP_PO', :B8 , 'AUTOCREATED_DOC_WF', :B8 , 'PORELGEB', :B8 , NULL) , DECODE(:B7 , 'COPY_DOCUMENT', (SELECT SOURCE_SHIPMENT.PO_HEADER_ID F ROM PO_LINE_LOCATIONS_ALL SOURCE_SHIPMENT WHERE SOURCE_SHIPMENT.LINE_LOCATION_ID = PLL.ORIGINAL_SHIPMENT_ID AND :B7 = 'COPY_DOCUMENT'), 'POXBWVRP_PO', (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_LINE_ID IN (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID) AND :B7 = 'POXBWVRP_PO'), 'AUTOCREATED_DOC_WF', (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_LINE_ID IN (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID) AND :B7 = 'AUTOCREATED_DOC_WF'), 'PORELGEB', (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_LINE_ID IN (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID) AND :B7 = 'PORELGEB'), NULL) , DECODE(:B7 , 'COPY_DOCUMENT', PLL.ORIGINAL_SHIPMENT_ID, 'POXBWVRP_PO', (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND :B7 = 'POXBWVRP_PO'), 'AUTOCREATED_DOC_WF', (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND :B7 = 'AUTOCREATED_DOC_WF'), 'PORELGEB', (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND :B7 = 'PORELGEB'), NULL) , DECODE(:B7 , 'COPY_DOCUMENT', :B2 , 'POXBWVRP_PO', :B6 , 'AUTOCREATED_DOC_WF', :B6 , 'PORELGEB', :B6 , NULL) , PLL.PRICE_OVERRIDE , NULL , PV.VENDOR_ID , PV.VENDOR_ID , PVS.VENDOR_SITE_ID , PVS.VENDOR_SITE_ID , PLL.SHIP_TO_ORGANIZATION_ID , (SELECT 'Y' FROM DUAL WHERE :B7 = 'PDOI' AND PLL.TAX_NAME IS NOT NULL) , PLL.SHIP_TO_ORGANIZATION_ID FROM PO_HEADERS_ALL PH, PO_LINES_ALL PL, PO_LINE_LOCATIONS_ALL PLL, ZX_LINES_DET_FACTORS ZXLDET, PO_VENDORS PV, PO_VENDOR_SITES_ALL PVS, MTL_SYSTEM_ITEMS_B MSIB WHERE PH.PO_HEADER_ID = PLL.PO_HEADER_ID AND PL.PO_LINE_ID = PLL.PO_LINE_ID AND PLL.TAX_ATTRIBUTE_UPDATE_CODE IS NOT NULL AND PLL.TAX_ATTRIBUTE_UPDATE_CODE <> 'DIST_DELETE' AND PH.PO_HEADER_ID = :B1 AND ZXLDET.APPLICATION_ID(+) = :B5 AND ZXLDET.ENTITY_CODE(+) = :B4 AND ZXLDET.EVENT_CLASS_CODE(+) = :B3 AND ZXLDET.TRX_LEVEL_TYPE(+) = :B2 AND ZXLDET.TRX_LINE_ID(+) = PLL.ORIGINAL_SHIPMENT_ID AND PV.VENDOR_ID(+) = PH.VENDOR_ID AND PVS.VENDOR_SITE_ID(+) = PH.VENDOR_SITE_ID AND MSIB.INVENTORY_ITEM_ID(+) = PL.ITEM_ID AND MSIB.ORGANIZATION_ID(+) = PL.ORG_ID
gyxv37z6aqyqpSELECT P.PID, P.SPID, AUDSID, PROCESS, SUBSTR(USERENV('LANGUAGE'), INSTR( USERENV('LANGUAGE'), '.') + 1) FROM V$SESSION S, V$PROCESS P WHERE P.ADDR = S.PADDR AND S.AUDSID = USERENV('SESSIONID')

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count100.000.00
Batched IO (full) vector count00.000.00
Batched IO (space) vector count00.000.00
Batched IO block miss count720.020.00
Batched IO buffer defrag count10.000.00
Batched IO double miss count20.000.00
Batched IO same unit count400.010.00
Batched IO single block count60.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count250.010.00
Batched IO vector read count60.000.00
Block Cleanout Optim referenced5380.150.00
CCursor + sql area evicted00.000.00
CPU used by this session1,928,649533.492.53
CPU used when call started1,914,008529.442.51
CR blocks created151,79241.990.20
Cached Commit SCN referenced238,203,07165,890.12312.78
Commit SCN cached129,81935.910.17
DB time10,637,2222,942.4013.97
DBWR checkpoint buffers written579,948160.420.76
DBWR checkpoints30.000.00
DBWR revisited being-written buffer00.000.00
DBWR thread checkpoint buffers written579,948160.420.76
DBWR transaction table writes5,0651.400.01
DBWR undo block writes213,58259.080.28
DFO trees parallelized00.000.00
Effective IO time580,677160.620.76
HSC Heap Segment Block Changes4,931,2231,364.046.48
Heap Segment Array Inserts11,0723.060.01
Heap Segment Array Updates13,9033.850.02
IMU CR rollbacks31,6268.750.04
IMU Flushes195,03653.950.26
IMU Redo allocation size476,630,936131,842.43625.85
IMU commits519,812143.790.68
IMU contention5,1301.420.01
IMU ktichg flush20,7235.730.03
IMU pool not allocated90.000.00
IMU recursive-transaction flush1430.040.00
IMU undo allocation size1,530,001,984423,218.802,009.00
IMU- failed to get a private strand90.000.00
LOB table id lookup cache misses00.000.00
Number of read IOs issued30,5398.450.04
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Parallel operations not downgraded00.000.00
Requests to/from client18,384,6805,085.4524.14
RowCR - row contention20,6135.700.03
RowCR attempts7,636,1042,112.2510.03
RowCR hits8,209,4402,270.8410.78
SQL*Net roundtrips to/from client18,391,4575,087.3224.15
active txn count during cleanout254,45970.390.33
application wait time4150.110.00
background checkpoints completed30.000.00
background checkpoints started30.000.00
background timeouts21,0355.820.03
branch node splits1600.040.00
buffer is not pinned count283,786,87978,499.21372.63
buffer is pinned count1,223,833,799338,528.631,606.98
bytes received via SQL*Net from client1,649,742,962456,340.742,166.23
bytes sent via SQL*Net to client4,514,778,3971,248,847.465,928.21
calls to get snapshot scn: kcmgss53,681,34014,848.9770.49
calls to kcmgas1,490,477412.291.96
calls to kcmgcs1,534,695424.522.02
cell physical IO interconnect bytes10,369,254,4002,868,273.0213,615.54
change write time4,9121.360.01
cleanout - number of ktugct calls345,08995.460.45
cleanouts and rollbacks - consistent read gets100,63027.840.13
cleanouts only - consistent read gets98,00627.110.13
cluster key scan block gets208,23057.600.27
cluster key scans107,32829.690.14
commit batch performed4,3541.200.01
commit batch requested4,3541.200.01
commit batch/immediate performed6,2421.730.01
commit batch/immediate requested6,2421.730.01
commit cleanout failures: block lost184,51351.040.24
commit cleanout failures: buffer being written2830.080.00
commit cleanout failures: callback failure5,0891.410.01
commit cleanout failures: cannot pin3,0600.850.00
commit cleanouts2,826,370781.813.71
commit cleanouts successfully completed2,633,425728.443.46
commit immediate performed1,8880.520.00
commit immediate requested1,8880.520.00
commit txn count during cleanout263,06572.770.35
concurrency wait time4,8871.350.01
consistent changes4,792,1681,325.586.29
consistent gets916,884,634253,622.431,203.93
consistent gets - examination142,052,27539,293.54186.52
consistent gets direct80,69322.320.11
consistent gets from cache916,803,756253,600.051,203.83
consistent gets from cache (fastpath)753,126,676208,324.81988.91
cursor authentications2160.060.00
data blocks consistent reads - undo records applied791,271218.881.04
db block changes29,152,7548,064.0438.28
db block gets32,468,3778,981.1842.63
db block gets direct3000.080.00
db block gets from cache32,468,0778,981.1042.63
db block gets from cache (fastpath)6,615,2741,829.878.69
deferred (CURRENT) block cleanout applications713,514197.370.94
enqueue conversions11,9413.300.02
enqueue releases2,709,008749.353.56
enqueue requests2,719,842752.343.57
enqueue timeouts10,4442.890.01
enqueue waits4660.130.00
exchange deadlocks590.020.00
execute count57,888,22116,012.6576.01
failed probes on index block reclamation50.000.00
file io service time3,707,3981,025.524.87
file io wait time5,678,805,4521,570,832.757,456.66
free buffer inspected3130.090.00
free buffer requested1,184,667327.691.56
heap block compress103,58528.650.14
hot buffers moved to head of LRU60.000.00
immediate (CR) block cleanout applications198,63654.950.26
immediate (CURRENT) block cleanout applications318,45288.090.42
in call idle wait time24,263,3056,711.5531.86
index crx upgrade (positioned)40,37111.170.05
index fast full scans (full)00.000.00
index fetch by key75,357,10020,844.7798.95
index scans kdiixs1198,273,70154,845.13260.35
java call heap collected bytes449,209,016124,257.16589.84
java call heap collected count2,193,863606.852.88
java call heap gc count4030.110.00
java call heap live object count68,69119.000.09
java call heap live object count max261,39272.300.34
java call heap live size max35,779,0809,896.9746.98
java call heap object count1,116,384308.811.47
java call heap object count max1,038,811287.351.36
java call heap total size355,205,12098,254.44466.41
java call heap total size max355,205,12098,254.44466.41
java call heap used size207,354,23257,356.93272.27
java call heap used size max158,331,01643,796.45207.90
java session heap live object count00.000.00
java session heap live object count max00.000.00
java session heap live size57,098,24015,794.1374.97
java session heap live size max57,098,24015,794.1374.97
java session heap object count00.000.00
java session heap object count max00.000.00
java session heap used size57,098,24015,794.1374.97
java session heap used size max57,098,24015,794.1374.97
leaf node 90-10 splits2,5060.690.00
leaf node splits29,3418.120.04
lob reads91,47825.300.12
lob writes221,18961.180.29
lob writes unaligned221,18961.180.29
logical read bytes from cache7,776,430,514,1762,151,063,609.4810,210,984.49
logons cumulative21,2165.870.03
max cf enq hold time190.010.00
messages received675,597186.880.89
messages sent675,597186.880.89
min active SCN optimization applied on CR53,33714.750.07
no buffer to keep pinned count1,9260.530.00
no work - consistent read gets754,532,332208,713.63990.75
non-idle wait count20,595,6815,697.0427.04
non-idle wait time24,8936.890.03
opened cursors cumulative51,102,84614,135.7267.10
parse count (describe)120.000.00
parse count (failures)2,6030.720.00
parse count (hard)4,5271.250.01
parse count (total)2,870,125793.913.77
parse time cpu14,7864.090.02
parse time elapsed15,2464.220.02
physical read IO requests43,80812.120.06
physical read bytes965,443,584267,054.471,267.69
physical read total IO requests51,91714.360.07
physical read total bytes1,096,139,776303,206.771,439.31
physical read total multi block requests00.000.00
physical reads117,85232.600.15
physical reads cache22,6876.280.03
physical reads cache prefetch9,6502.670.01
physical reads direct95,16526.320.12
physical reads direct (lob)94,95226.260.12
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup9,6312.660.01
physical write IO requests248,28268.680.33
physical write bytes4,788,084,7361,324,447.616,287.08
physical write total IO requests919,798254.431.21
physical write total bytes9,273,114,6242,565,066.2412,176.23
physical write total multi block requests18,5265.120.02
physical writes584,483161.680.77
physical writes direct4300.120.00
physical writes direct (lob)1870.050.00
physical writes direct temporary tablespace40.000.00
physical writes from cache584,053161.560.77
physical writes non checkpoint281,36977.830.37
pinned buffers inspected500.010.00
pinned cursors current6280.170.00
process last non-idle time3,6151.000.00
queries parallelized00.000.00
recursive calls98,051,94927,122.47128.75
recursive cpu usage870,740240.861.14
redo blocks checksummed by FG (exclusive)1,830,555506.362.40
redo blocks written8,588,5792,375.7111.28
redo buffer allocation retries40.000.00
redo entries12,361,2013,419.2716.23
redo log space requests40.000.00
redo log space wait time30.000.00
redo ordering marks189,63852.460.25
redo size4,061,136,4281,123,364.095,332.55
redo size for direct writes8,5842.370.01
redo subscn max counts292,11880.800.38
redo synch long waits910.030.00
redo synch time2,8910.800.00
redo synch time (usec)35,087,2349,705.5946.07
redo synch writes477,051131.960.63
redo wastage193,103,46453,414.97253.56
redo write time7,3802.040.01
redo writes656,699181.650.86
rollback changes - undo records applied645,009178.420.85
rollbacks only - consistent read gets40,53711.210.05
root node splits50.000.00
rows fetched via callback44,056,83112,186.7057.85
session connect time00.000.00
session cursor cache hits23,081,3516,384.6130.31
session logical reads949,356,520262,604.581,246.57
shared hash latch upgrades - no wait19,900,4585,504.7326.13
shared hash latch upgrades - wait5,6061.550.01
sorts (memory)5,060,4601,399.796.64
sorts (rows)20,075,0005,553.0126.36
sql area evicted00.000.00
sql area purged2,2390.620.00
switch current to new buffer320,48688.650.42
table fetch by rowid696,055,583192,538.19913.97
table fetch continued row103,68728.680.14
table scan blocks gotten237,850,88865,792.70312.31
table scan rows gotten6,526,338,3901,805,271.588,569.53
table scans (long tables)00.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)820,992227.101.08
temp space allocated (bytes)1,333,788,672368,943.601,751.36
total cf enq hold time1,0490.290.00
total number of cf enq holders1700.050.00
total number of times SMON posted930.030.00
transaction rollbacks6,2411.730.01
undo change vector size1,514,959,336419,057.801,989.25
user I/O wait time1,3290.370.00
user calls18,854,5035,215.4124.76
user commits663,155183.440.87
user rollbacks98,42027.220.13
workarea executions - optimal2,944,469814.483.87
write clones created in background4,1121.140.01
write clones created in foreground1,4130.390.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max18,803,562,08022,400,012,376
session cursor cache count705,7882,216,397
session uga memory587,530,440,768869,983,708,776
opened cursors current106,693116,306
workarea memory allocated1,5302,112
logons current2,0191,990
session uga memory max60,746,819,792294,802,294,584
session pga memory18,674,759,41622,263,468,408

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)11.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
DBWR0M0.000M4.5G68.611.262180 
LGWR0M0.010M4.1G184.391.16039657.1K0.00
Direct Reads743M8.49.2055230M0.000M0 
Others120M2.18.03319384M1.51.02323596490.19
Buffer Cache Reads177M3.61.0489600M0.000M13K0.00
Direct Writes0M0.000M3M0.05.0008290 
Streams AQ0M0.000M0M0.000M60.00
TOTAL:1G14.28.2876778.6G254.562.44664679.8K0.01

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Data File916M12.03.2533774.4G67.581.254710.01 
Log File0M0.000M4.1G184.381.160390.00 
Control File119M2.10.03291684M1.48.0232350.00 
Temp File5M0.16.00138332M1.14.0088510.00 
TOTAL:1G14.28.2876778.6G254.582.447190.01 

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
DBWR 0M0.000M4.5G68.611.262180 
DBWR (Data File) 0M0.000M4.5G68.611.262180 
LGWR 0M0.010M4.1G184.391.16039260.00
LGWR (Log File) 0M0.000M4.1G184.381.1603940.00
LGWR (Control File) 0M0.010M0M0.010M220.00
Direct Reads 743M8.49.2055230M0.000M0 
Direct Reads (Data File) 743M8.49.2055230M0.000M0 
Others 120M2.18.03319384M1.51.02323578740.00
Others (Control File) 118M2.09.03264083M1.47.02295875610.00
Others (Data File) 2M0.09.0005531M0.03.0002763130.00
Buffer Cache Reads 177M3.61.0489600M0.000M13K0.00
Buffer Cache Reads (Data File) 177M3.61.0489600M0.000M13K0.00
Direct Writes 0M0.000M3M0.05.0008290 
Direct Writes (Data File) 0M0.000M3M0.05.0008290 
Streams AQ 0M0.000M0M0.000M60.00
Streams AQ (Data File) 0M0.000M0M0.000M60.00
TOTAL: 1G14.28.2876778.6G254.562.4466420.9K0.00

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_TS_TX_IDX 9,86830.021.81128,534361,5100.00
APPS_TS_TX_DATA 32,30490.003.0371,628201,4090.04
APPS_UNDOTS1 600.001.0021,13761,4310.03
APPS_TS_ARCHIVE 19200.001.906,0452190.00
TEMP1 57300.001.004,1151824.02
APPS_TS_QUEUES 1600.002.884,550100.00
SYSAUX 59600.021.003,8851130.00
APPS_TS_INTERFACE 200.001.002,9761130.00
APPS_TS_MEDIA 600.001.172,273100.00
APPS_TS_SUMMARY 4300.001.911,714010.00
APPS_TS_SEED 9100.111.74751000.00
SYSTEM 1100.911.00614000.00
OWAPUB 400.001.002000.00
PORTAL 400.001.002000.00
PORTAL_DOC 400.001.002000.00
PORTAL_IDX 400.001.002000.00
PORTAL_LOG 400.001.002000.00
RE 400.001.002000.00
SYNCSERVER 400.001.002000.00
UDDISYS_TS 400.001.002000.00
WCRSYS_TS 400.001.002000.00
XDB 400.001.002000.00
APPS_CALCLIP 200.001.002000.00
APPS_OMO 200.001.002000.00
APPS_TS_DISCO 200.001.002000.00
APPS_TS_DISCO_OLAP 200.001.002000.00
APPS_TS_NOLOGGING 200.001.002000.00
APPS_TS_TOOLS 200.001.002000.00
B2B_DT 200.001.002000.00
B2B_IDX 200.001.002000.00
B2B_LOB 200.001.002000.00
B2B_RT 200.001.002000.00
BAM 200.001.002000.00
CTXSYS 200.001.002000.00
CWMLITE 200.001.002000.00
DCM 200.001.002000.00
DISCO_PTM5_CACHE 200.001.002000.00
DISCO_PTM5_META 200.001.002000.00
DSGATEWAY_TAB 200.001.002000.00
GEOR_TBS 200.001.002000.00
HTMLDB 200.001.002000.00
IAS_META 200.001.002000.00
MTR 200.001.002000.00
NOETIX 200.001.002000.00
NON_APPS_TS_DATA 200.001.002000.00
OCATS 200.001.002000.00
ODM_DATA 200.001.002000.00
OLTS_ATTRSTORE 200.001.002000.00
OLTS_BATTRSTORE 200.001.002000.00
OLTS_CT_STORE 200.001.002000.00
OLTS_DEFAULT 200.001.002000.00
OLTS_SVRMGSTORE 200.001.002000.00
OPMOR 200.001.002000.00
ORABPEL 200.001.002000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_CALCLIP/DBF11g/apps_calclip_01.dbf 200.001.002000.00
APPS_OMO/DBF11g/omo_01.dbf 200.001.002000.00
APPS_TS_ARCHIVE/DBF11g/archive_01.dbf 19200.001.906,0452190.00
APPS_TS_DISCO/DBF11g/disco_01.dbf 200.001.002000.00
APPS_TS_DISCO_OLAP/DBF11g/disco_drake_01.dbf 200.001.002000.00
APPS_TS_INTERFACE/DBF11g/apps_ts_interface_01.dbf 200.001.002,9761130.00
APPS_TS_MEDIA/DBF11g/media_01.dbf 600.001.172,273100.00
APPS_TS_NOLOGGING/DBF11g/nologging_01.dbf 200.001.002000.00
APPS_TS_QUEUES/DBF11g/queues_01.dbf 1600.002.884,550100.00
APPS_TS_SEED/DBF11g/reference_01.dbf 5900.171.92633000.00
APPS_TS_SEED/DBF11g/reference_02.dbf 3200.001.41118000.00
APPS_TS_SUMMARY/DBF/summary_02.dbf 400.001.00800010.00
APPS_TS_SUMMARY/DBF11g/summary_01.dbf 3900.002.00914000.00
APPS_TS_TOOLS/DBF11g/apps_ts_tools01.dbf 200.001.002000.00
APPS_TS_TX_DATA/DBF/tx_data_05.dbf 1,31300.001.0011,91532720.00
APPS_TS_TX_DATA/DBF/tx_data_06.dbf 59800.001.006,5242240.00
APPS_TS_TX_DATA/DBF/tx_data_07.dbf 1,66000.001.011,564090.00
APPS_TS_TX_DATA/DBF11g/tx_data_01.dbf 3,24410.011.186,9742150.00
APPS_TS_TX_DATA/DBF11g/tx_data_02.dbf 36300.031.597,24721180.00
APPS_TS_TX_DATA/DBF11g/tx_data_03.dbf 22,19960.003.9121,8556760.13
APPS_TS_TX_DATA/DBF11g/tx_data_04.dbf 2,92710.001.0815,54948950.06
APPS_TS_TX_IDX/DBF11g/tx_idx_01.dbf 2,20810.021.7133,27592900.00
APPS_TS_TX_IDX/DBF11g/tx_idx_02.dbf 2,27010.021.8331,74693600.00
APPS_TS_TX_IDX/DBF11g/tx_idx_03.dbf 2,86710.021.8727,36884540.00
APPS_TS_TX_IDX/DBF11g/tx_idx_04.dbf 2,52310.021.7936,145104060.00
APPS_UNDOTS1/DBF/undo_02.dbf 400.001.007,96125610.02
APPS_UNDOTS1/DBF11g/undo_01.dbf 200.001.0013,17648700.03
B2B_DT/DBF11g/b2b_dt_01.dbf 200.001.002000.00
B2B_IDX/DBF11g/b2b_idx_01.dbf 200.001.002000.00
B2B_LOB/DBF11g/b2b_lob_01.dbf 200.001.002000.00
B2B_RT/DBF11g/b2b_rt_01.dbf 200.001.002000.00
BAM/DBF11g/bam_01.dbf 200.001.002000.00
CTXSYS/DBF11g/ctx1_01.dbf 200.001.002000.00
CWMLITE/DBF11g/cwmlite_01.dbf 200.001.002000.00
DCM/DBF11g/dcm_01.dbf 200.001.002000.00
DISCO_PTM5_CACHE/DBF11g/discopltc_01.dbf 200.001.002000.00
DISCO_PTM5_META/DBF11g/discopltm_01.dbf 200.001.002000.00
DSGATEWAY_TAB/DBF11g/oss_sys_01.dbf 200.001.002000.00
GEOR_TBS/DBF11g/apps_ts_spatial_01.dbf 200.001.002000.00
HTMLDB/DBF11g/htmldb_01.dbf 200.001.002000.00
IAS_META/DBF11g/ias_meta_01.dbf 200.001.002000.00
MTR/DBF11g/opmtr_01.dbf 200.001.002000.00
NOETIX/DBF11g/noetix_01.dbf 200.001.002000.00
NON_APPS_TS_DATA/DBF11g/non_apps_data_01.dbf 200.001.002000.00
OCATS/DBF11g/oca_01.dbf 200.001.002000.00
ODM_DATA/DBF11g/odm_01.dbf 200.001.002000.00
OLTS_ATTRSTORE/DBF11g/attrs_oid_01.dbf 200.001.002000.00
OLTS_BATTRSTORE/DBF11g/battrs_oid_01.dbf 200.001.002000.00
OLTS_CT_STORE/DBF11g/gcats_oid_01.dbf 200.001.002000.00
OLTS_DEFAULT/DBF11g/gdefault_oid_01.dbf 200.001.002000.00
OLTS_SVRMGSTORE/DBF11g/svrmg_oid_01.dbf 200.001.002000.00
OPMOR/DBF11g/opmor_01.dbf 200.001.002000.00
ORABPEL/DBF11g/orabpel_01.dbf 200.001.002000.00
OWAPUB/DBF11g/owa_01.dbf 400.001.002000.00
PORTAL/DBF11g/portal_01.dbf 400.001.002000.00
PORTAL_DOC/DBF11g/ptldoc_01.dbf 400.001.002000.00
PORTAL_IDX/DBF11g/ptlidx_01.dbf 400.001.002000.00
PORTAL_LOG/DBF11g/ptllog_01.dbf 400.001.002000.00
RE/DBF11g/opre_01.dbf 400.001.002000.00
SYNCSERVER/DBF11g/mobile_01.dbf 400.001.002000.00
SYSAUX/DBF11g/sysaux_01.dbf 59600.021.003,8851130.00
SYSTEM/DBF11g/sys_01.dbf 1100.911.00614000.00
TEMP1/DBF/temp1_02.dbf 22600.001.001,5640176.47
TEMP1/DBF/temp1_03.dbf 14100.001.009390282.86
TEMP1/DBF11g/temp1_01.dbf 20600.001.001,6120373.78
UDDISYS_TS/DBF11g/uddisys_01.dbf 400.001.002000.00
WCRSYS_TS/DBF11g/wcrsys_01.dbf 400.001.002000.00
XDB/DBF11g/xdb_01.dbf 400.001.002000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D11,680,345100943,465,23422,687584,053004,480

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00567,9770011,925

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual RedoBlksTarget RedoBlksLog Sz RedoBlksLog Ckpt Timeout RedoBlksLog Ckpt Interval RedoBlksOpt Log Sz(M)Estd RAC Avail Time
B0445619101625100000849346561781078100000  
E0446208109128100000849346564271702100000  

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

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 ProcessedExtra W/A MB Read/Written
100.00183,3690

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 MemGlobal Mem Bound(K)
B204,800170,07717,568.611.360.01100.000.00102,400
E204,800167,80521,026.931.810.01100.000.00102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K2,852,3542,852,35400
64K128K7,3827,38200
128K256K9,1639,16300
256K512K48648600
512K1024K69,23769,23700
1M2M3,9203,92000
64M128M1,7881,78800

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
25,6000.13137,257.840.00100.000132,014,590
51,2000.25137,257.840.00100.000132,014,590
102,4000.50137,257.840.00100.000132,014,590
153,6000.75137,257.840.00100.000132,014,590
204,8001.00137,257.840.00100.000132,014,590
245,7601.20137,257.840.00100.000132,014,590

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
15,3600.1051428,227695,5261.003871.0067,786
30,7200.2051428,227695,5261.003871.0067,786
46,0800.3051428,227695,5261.003871.0067,786
61,4400.4051428,227695,5261.003871.0067,786
76,8000.5051428,227695,5261.003871.0067,786
92,1600.6051428,227695,5261.003871.0067,786
107,5200.7051428,227695,5261.003871.0067,786
122,8800.8051428,227695,5261.003871.0067,786
138,2400.9051428,227695,5261.003871.0067,786
148,4800.9751428,227695,5261.003871.0067,786
148,9920.9751428,227695,5261.003871.0067,786
149,5040.9751428,227695,5261.003871.0067,786
150,0160.9851428,227695,5261.003871.0067,786
150,5280.9851428,227695,5261.003871.0067,786
151,0400.9851428,227695,5261.003871.0067,786
151,5520.9951428,227695,5261.003871.0067,786
152,0640.9951428,227695,5261.003871.0067,786
152,5760.9951428,227695,5261.003871.0067,786
153,0881.0051428,227695,5261.003871.0067,786
153,6001.0051428,227695,5261.003871.0067,786
154,1121.0051428,227695,5261.003871.0067,786
154,6241.0151428,227695,5261.003871.0067,786
155,1361.0151428,227695,5261.003871.0067,786
155,6481.0151428,227695,5261.003871.0067,786
156,1601.0251428,227695,5261.003871.0067,786
156,6721.0251428,227695,5261.003871.0067,786
157,1841.0251428,227695,5261.003871.0067,786
157,6961.0351428,227695,5261.003871.0067,786
158,2081.0351428,227695,5261.003871.0067,786
168,9601.1051428,227695,5261.003871.0067,786
184,3201.2051428,227695,5261.003871.0067,786
199,6801.3051428,227695,5261.003871.0067,786
215,0401.4051428,227695,5261.003871.0067,786
230,4001.5051428,227695,5261.003871.0067,786
245,7601.6051428,227695,5261.003871.0067,786
261,1201.7051428,227695,5261.003871.0067,786
276,4801.8051428,227695,5261.003871.0067,786
291,8401.9051428,227695,5261.003871.0067,786
307,2002.0051428,227695,5261.003871.0067,786

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
32,0000.1335,740 
48,0000.1935,740 
64,0000.2535,740 
80,0000.3135,740 
96,0000.3835,740 
112,0000.4435,740 
128,0000.5035,740 
144,0000.5635,740 
160,0000.6335,740 
176,0000.6935,740 
192,0000.7535,740 
208,0000.8135,741 
224,0000.8835,741 
240,0000.9435,741 
256,0001.0035,740 
272,0001.0635,746 
288,0001.1335,748 
304,0001.1935,748 
320,0001.2535,748 
336,0001.3135,748 
352,0001.3835,749 
368,0001.4435,749 
384,0001.5035,749 
400,0001.5635,753 
416,0001.6335,753 
432,0001.6935,753 
448,0001.7535,753 
464,0001.8135,753 
480,0001.8835,754 
496,0001.9435,754 
512,0002.0035,754 

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
5120.500000
1,0241.000000
1,5361.500000
2,0482.000000
2,5602.500000
3,0723.000000
3,5843.500000
4,0964.000000
4,6084.500000
5,1205.000000
5,6325.500000
6,1446.000000
6,6566.500000
7,1687.000000
7,6807.500000
8,1928.000000
8,7048.500000
9,2169.000000
9,7289.500000
10,24010.000000

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
4,6081.001645815,7981.003871.0031,812
5,1201.111645815,7981.003871.0031,812
5,6321.221645815,7981.003871.0031,812
6,1441.331645815,7981.003871.0031,812
6,6561.441645815,7981.003871.0031,812
7,1681.561645815,7981.003871.0031,812
7,6801.671645815,7981.003871.0031,812
8,1921.781645815,7981.003871.0031,812
8,7041.891645815,7981.003871.0031,812
9,2162.001645815,7981.003871.0031,812

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
file header block8204
data block2,95200
undo block1,20300
undo header23000
1st level bmb1200
segment header100

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TH-Threshold Chain (metric threshold evaluation) 40240206014.00
TX-Transaction (row lock contention) 9,1133758,73837500.18
TX-Transaction (index contention) 10110107100.15
DV-Diana Versioning 12,40012,4000600.17
SQ-Sequence Cache 9899890200.50
TX-Transaction (allocate ITL entry) 550500.00
TX-Transaction 696,025696,0290100.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
2209.19686,67210,389363669.8/7714.60/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
17-Jun 11:2534,281115,34910,389323,6700/00/0/0/0/0/0
17-Jun 11:1534,647114,9149,786313,9820/00/0/0/0/0/0
17-Jun 11:0535,518116,1599,181324,4120/00/0/0/0/0/0
17-Jun 10:5532,201105,9008,574305,0530/00/0/0/0/0/0
17-Jun 10:4536,306115,6687,967305,9450/00/0/0/0/0/0
17-Jun 10:3536,233118,6827,361367,7150/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch20,0690.060.0000 
AQ deq log cmt cbk chunk latch7,1700.040.0000 
AQ deq log statistics latch330.00 00 
AQ dequeue txn counter latch28,2140.840.0000 
AQ disk delete txn counter latch60.00 00 
AQ ht cmt cbk chunk latch7,2860.030.0000 
ASM Keyed state latch42,3330.210.0000 
ASM allocation30.00 00 
ASM db client latch2,3980.00 00 
ASM map operation hash table1,340,1300.00 00 
ASM network background latch1,6270.00 00 
ASM network state latch4620.00 00 
AWR Alerted Metric Element list138,3460.00 00 
Change Notification Hash table latch1,2070.00 00 
Consistent RBA656,7640.010.0000 
DML lock allocation2,547,6840.010.0000 
Event Group Locks42,3790.00 00 
FOB s.o list latch43,8480.210.0000 
File State Object Pool Parent Latch20.00 00 
I/O Staticstics latch20.00 00 
IPC stats buffer allocation latch20.00 00 
In memory undo latch4,762,8380.020.810905,5270.00
JOX SGA heap latch54,2640.00 00 
JS Sh mem access100.00 00 
JS queue access latch20.00 00 
JS queue state obj latch21,8100.00 00 
JS slv state obj latch2420.830.0000 
KFC FX Hash Latch20.00 00 
KFC Hash Latch20.00 00 
KFCL LE Freelist20.00 00 
KFK SGA Libload latch3,4720.00 00 
KGNFS-NFS:SHM structure20.00 00 
KGNFS-NFS:SVR LIST30.00 00 
KJC message pool free list20.00 00 
KJCT flow control latch20.00 00 
KMG MMAN ready and startup request latch1,2050.00 00 
KTF sga latch230.00 01,2160.00
KWQMN job cache list latch11,1940.030.0000 
KWQP Prop Status4800.00 00 
KWQS pqsubs latch18,7800.00 00 
KWQS pqueue ctx latch22,4420.020.6000 
Locator state objects pool parent latch20.00 00 
Lsod array latch275,3030.370.0000 
MQL Tracking Latch0  0720.00
Memory Management Latch20.00 01,2050.00
Memory Queue2,1160.00 00 
Memory Queue Message Subscriber #120.00 00 
Memory Queue Message Subscriber #220.00 00 
Memory Queue Message Subscriber #320.00 00 
Memory Queue Message Subscriber #420.00 00 
Memory Queue Subscriber20.00 00 
MinActiveScn Latch412.440.0000 
Mutex20.00 00 
Mutex Stats20.00 00 
OS process85,4830.00 00 
OS process allocation50,1642.570.0000 
OS process: request allocation42,3380.540.0000 
PL/SQL warning settings2,049,8710.010.0000 
PX hash array latch20.00 00 
QMT20.00 00 
Real-time plan statistics latch26,4270.020.2500 
Result Cache: RC Latch20.00 00 
SGA IO buffer pool latch1,3870.00 01,4320.28
SGA blob parent20.00 00 
SGA bucket locks20.00 00 
SGA heap locks20.00 00 
SGA pool locks20.00 00 
SQL memory manager latch20.00 01,1960.00
SQL memory manager workarea list latch1,797,6200.000.0000 
Shared B-Tree54,0030.010.0000 
Streams Generic20.00 00 
Testing20.00 00 
Token Manager20.00 00 
WCR: sync20.00 00 
Write State Object Pool Parent Latch20.00 00 
X$KSFQP20.00 00 
XDB NFS Security Latch20.00 00 
XDB unused session pool20.00 00 
XDB used session pool20.00 00 
active checkpoint queue latch22,0960.390.0000 
active service list115,7711.150.90023,6000.00
archive control620.00 00 
begin backup scn array1600.00 00 
bq:time manger info latch1290.00 00 
buffer pool20.00 00 
bufq statistics2,0900.00 00 
business card20.00 00 
cache buffer handles1,485,6900.010.0000 
cache buffers chains1,816,512,8682.700.0001,001,4720.03
cache buffers lru chain2,061,2670.010.0901,896,3950.03
call allocation416,8220.580.5800 
cas latch20.00 00 
change notification client cache latch20.00 00 
channel handle pool latch42,6100.860.0000 
channel operations parent latch119,8520.230.0000 
checkpoint queue latch2,226,0860.010.000578,4030.00
client/application info522,2220.000.0000 
compile environment latch21,2210.00 00 
corrupted undo seg latch1,941,2810.000.0000 
cp cmon/server latch20.00 00 
cp pool latch20.00 00 
cp server hash latch20.00 00 
cp sga latch1220.00 00 
cvmap freelist lock20.00 00 
deferred cleanup latch1220.00 00 
dml lock allocation1220.00 00 
done queue latch20.00 00 
dummy allocation42,4651.350.0000 
enqueue freelist latch20.00 01,413,3060.00
enqueue hash chains5,441,4540.050.0000 
enqueues29,9540.010.0000 
fifth spare latch20.00 00 
file cache latch2,4550.00 00 
flashback copy20.00 00 
fourth Audit Vault latch20.00 00 
gc element20.00 00 
gcs commit scn state20.00 00 
gcs partitioned table hash20.00 00 
gcs pcm hashed value bucket hash20.00 00 
gcs resource freelist20.00 00 
gcs resource hash20.00 00 
gcs resource scan list20.00 00 
gcs shadows freelist20.00 00 
ges domain table20.00 00 
ges enqueue table freelist20.00 00 
ges group table20.00 00 
ges process hash list20.00 00 
ges process parent latch20.00 00 
ges resource hash list20.00 00 
ges resource scan list20.00 00 
ges resource table freelist20.00 00 
ges value block free list20.00 00 
global KZLD latch for mem in SGA20,9990.00 00 
global ctx hash table latch620,5870.000.0000 
global tx hash mapping20.00 00 
granule operation20.00 00 
hash table column usage latch8530.00 076,0130.00
hash table modification latch1770.00 00 
heartbeat check20.00 00 
internal temp table object number allocation latch130.00 00 
intra txn parallel recovery20.00 00 
io pool granule metadata list20.00 00 
job workq parent latch670.00 0650.00
job_queue_processes free list latch1300.00 00 
job_queue_processes parameter latch8520.00 00 
k2q lock allocation20.00 00 
kcbtsemkid latch10.00 00 
kdlx hb parent latch20.00 00 
kgb parent20.00 00 
kgnfs mount latch20.00 00 
kokc descriptor allocation latch167,4290.830.1620 
ksfv messages20.00 00 
ksim group membership cache20.00 00 
kss move lock760.00 00 
ksuosstats global area2470.00 00 
ksv allocation latch2650.00 00 
ksv class latch1,4760.070.0000 
ksv instance latch40.00 00 
ksv msg queue latch20.00 00 
ksz_so allocation latch42,3382.850.0000 
ktm global data3910.00 00 
kwqbsn:qsga4,0960.120.0000 
lgwr LWN SCN658,2690.020.0000 
list of block allocation99,6950.020.0000 
loader state object freelist279,7380.020.0000 
lob segment dispenser latch20.00 00 
lob segment hash table latch140.00 00 
lob segment query latch20.00 00 
lock DBA buffer during media recovery20.00 00 
logical standby cache20.00 00 
logminer context allocation40.00 00 
logminer work area20.00 00 
longop free list parent990.00 010.00
mapped buffers lru chain20.00 00 
message pool operations parent latch13,3000.00 00 
messages2,095,7250.060.0000 
mostly latch-free SCN664,0380.650.0000 
msg queue latch20.00 00 
multiblock read objects5,5700.00 00 
name-service namespace bucket20.00 00 
ncodef allocation latch1220.00 00 
object queue header heap594,0520.000.090412,0260.00
object queue header operation53,219,4150.120.0900 
object stats modification243,3220.000.1400 
parallel query alloc buffer9620.00 00 
parallel query stats20.00 00 
parameter list134,7820.010.0000 
parameter table management3,155,7300.040.3200 
peshm90.00 00 
pesom_free_list829,2800.000.0000 
pesom_hash_node831,4020.000.0000 
pesom_heap_alloc1,7180.00 00 
post/wait queue561,5200.080.000371,7940.10
process allocation42,4951.550.02021,1570.01
process group creation42,3380.090.0000 
process queue20.00 00 
process queue reference20.00 00 
qmn task queue latch3,9032.540.0000 
query server freelists20.00 00 
queued dump request120.00 00 
queuing load statistics20.00 00 
recovery domain hash list20.00 00 
redo allocation3,782,0950.050.00012,360,1870.12
redo copy20.00 012,363,2450.06
redo writing2,004,2850.000.0000 
resmgr:actses change group20.00 00 
resmgr:actses change state20.00 00 
resmgr:plan CPU method20.00 00 
resmgr:resource group CPU method20.00 00 
resmgr:session queuing20.00 00 
rm cas latch20.00 00 
row cache objects117,591,0480.470.0000 
rules engine aggregate statistics5,4010.00 00 
rules engine rule set statistics18,2100.00 00 
rules engine rule statistics7,2080.00 00 
second Audit Vault latch20.00 00 
second spare latch20.00 00 
sequence cache1,387,9280.010.0000 
session allocation1,729,0720.000.0001,686,6600.00
session idle bit39,374,8430.000.0000 
session queue latch20.00 00 
session state list latch126,1600.180.7700 
session switching21,3030.270.0000 
session timer1,2510.00 00 
shared pool4,648,0450.350.0000 
shared pool sim alloc1410.00 00 
shared pool simulator2,9260.00 00 
sim partition latch20.00 00 
simulator hash latch20.00 00 
simulator lru latch20.00 00 
sort extent pool1,168,0020.130.0000 
space background state object latch450.00 00 
space background task latch16,1229.790.0102,5000.12
state object free list60.00 00 
statistics aggregation6720.00 00 
tablespace key chain580.00 00 
temp lob duration state obj allocation3,5810.140.0000 
temporary table state object allocation22,9050.410.0000 
test excl. parent l020.00 00 
test excl. parent2 l020.00 00 
third spare latch20.00 00 
threshold alerts latch7380.00 00 
trace latch380.00 00 
transaction allocation309,9460.010.0000 
undo global data4,258,8620.000.1001610.00
virtual circuit buffers20.00 00 
virtual circuit holder20.00 00 
virtual circuit queues20.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains1,816,512,86849,001,6942,34048,980,733
row cache objects117,591,048557,85790557,767
object queue header operation53,219,41564,7855,72159,217
shared pool4,648,04516,1852816,157
mostly latch-free SCN664,0384,30314,302
call allocation416,8222,4121,4011,034
redo allocation3,782,0951,87011,869
space background task latch16,1221,578221,556
kokc descriptor allocation latch167,4291,3872211,166
active service list115,7711,3281,196141
OS process allocation50,1641,28811,287
parameter table management3,155,7301,136359778
In memory undo latch4,762,838784634158
process allocation42,49565814644
channel handle pool latch42,6103671366
channel operations parent latch119,8522771276
session state list latch126,16022917658
undo global data4,258,86221020190
cache buffers lru chain2,061,26715013137
object queue header heap594,05211110
object stats modification243,322716
KWQS pqueue ctx latch22,442532
Real-time plan statistics latch26,427413

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchktiFlush: child0492142
In memory undo latchkticmt: child011369
In memory undo latchktichg: child030362
In memory undo latchktiFlushMe0164
In memory undo latchktbchg2ro020
In memory undo latchkticflush_2020
In memory undo latchkturbk02183
In memory undo latchktbgfc011
In memory undo latchktigetmypoollatch_2010
KWQMN job cache list latchkwqmnuji: update job item033
KWQS pqueue ctx latchkwqspqcbkf: updatepqs033
OS process allocationkso_delete_process:1011
PC and Classifier lists for WLMNo latch020
Real-time plan statistics latchkeswxAddNewPlanEntry011
active service listkswslogon: session logout01,2381,226
cache buffers chainskcbchg1: mod cr pin0888374
cache buffers chainskcbgtcr: fast path0843121
cache buffers chainskcbgtcr: fast path (cr pin)0724228
cache buffers chainskcbgcur_20499318
cache buffers chainskcbget: fast exchange018327
cache buffers chainskcbgtcr_20101251
cache buffers chainskcbgtcr: kslbegin excl063136
cache buffers chainskcbrls: fast release02048
cache buffers chainskcbzwb01539
cache buffers chainskcbrls_2012827
cache buffers chainskcbbxsv0109
cache buffers chainskcbget: pin buffer072
cache buffers chainskcbgcur_4041
cache buffers chainskcb_is_private03142
cache buffers chainskcbgkcbcr0345
cache buffers chainskcbcge02207
cache buffers chainskcbgcur: fast path (shr)023
cache buffers chainskcbbic2011
cache buffers chainskcbso1: set no access0112
cache buffers lru chainkcbo_link_q0123
cache buffers lru chainkcbzgws010
call allocationksuxds01,3941,362
call allocationksudlp: top call054
call allocationksuprc0212
channel handle pool latchksrchdelete()011
channel operations parent latchksrchdelete_sub()011
kokc descriptor allocation latchkokcdlt: regular free01943
kokc descriptor allocation latchkokcdlt: allocation027218
lgwr LWN SCNkcs023010
object queue header heapkcbo_check_flist010
object queue header operationkcbo_ivbo05,4955,047
object queue header operationkcbo_switch_mq_bg0363445
object queue header operationkcbo_switch_q_bg0177275
object queue header operationkcbo_link_q0122119
object queue header operationkcbo_switch_cq08103
object queue header operationkcbo_sw_buf0763
object queue header operationkcbo_link_q:reget0135
object stats modificationksols_rank010
parameter table managementksp_param_table_free02542
parameter table managementkspcpy01381
process allocationksucrp:10140
redo allocationkcrfw_redo_gen: redo allocation 1010
row cache objectskqreqd: reget0377
row cache objectskqrpre: find obj03148
row cache objectskqreqd01129
row cache objectskqrso0116
session state list latchkpseqd01671
session state list latchkpscad0720
session state list latchkpscdl0250
shared poolkghfre0279
shared poolkghalo0113
space background task latchktsj_grab_task02022
undo global datakturax0200

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpin1 411,6210
Library Cachekgllkdl1 857,7300
Library Cachekglpndl1 957,5640
Library Cachekglhdgn2 1066,3130
Library Cachekglpnal1 905,9720
Library Cachekgllkc1 573,7420
Library Cachekglget1 11,7910
Library Cachekglhdgn1 621,1480
Library Cachekglget2 26010
Cursor Pinkksfbc [KKSCHLFSP2]1580
Library Cachekglobpn1 71530
Cursor PinkksLockDelete [KKSCHLPIN6]430
Library CachekglGetHandleReference 124210
Cursor Pinkksfbc [KKSCHLPIN1]50
Cursor Pinkkslce [KKSCHLPIN2]50
Library CachekglReleaseHandleReference 12540
Cursor Pinkksxsccmp [KKSCHLPIN5]40
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]10
Cursor ParentkkscsPruneChild [KKSPRTLOC35]10

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

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
SYSSYSTEMI_OBJ2 INDEX368,409,66438.81
INVAPPS_TS_TX_DATAMTL_SYSTEM_ITEMS_B TABLE185,145,79219.50
APPLSYSAPPS_TS_SEEDFND_MENU_ENTRIES_U1 INDEX35,315,5363.72
APPLSYSAPPS_TS_SEEDFND_MENU_ENTRIES TABLE32,392,8483.41
INVAPPS_TS_TX_DATAMTL_RESERVATIONS TABLE19,538,3362.06

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX3750.32
ZXAPPS_TS_TX_IDXZX_LINES_DET_FACTORS_U2 INDEX1160.10
APPLSYSAPPS_TS_TX_IDXALR_ALERT_CHECKS_N1 INDEX990.08
APPLSYSAPPS_TS_TX_IDXFND_CONCURRENT_REQUESTS_N9 INDEX910.08
ICXAPPS_TS_TX_IDXICX_SESSIONS_U2 INDEX910.08

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX1370.31
APPLSYSAPPS_TS_TX_IDXALR_ALERT_CHECKS_N1 INDEX950.22
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_403747463_0TABLE PARTITION860.20
APPLSYSAPPS_TS_TX_IDXALR_ALERT_CHECKS_U1 INDEX660.15
ZXAPPS_TS_TX_IDXZX_LINES_DET_FACTORS_U2 INDEX640.15

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX1370.31
APPLSYSAPPS_TS_TX_IDXALR_ALERT_CHECKS_N1 INDEX950.22
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_403747463_0TABLE PARTITION860.20
APPLSYSAPPS_TS_TX_IDXALR_ALERT_CHECKS_U1 INDEX660.15
ZXAPPS_TS_TX_IDXZX_LINES_DET_FACTORS_U2 INDEX640.15

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX28,8294.93
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX24,6924.22
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE20,2633.47
ICXAPPS_TS_TX_IDXICX_TRANSACTIONS_U2 INDEX14,2492.44
ICXAPPS_TS_TX_IDXICX_SESSION_ATTRIBUTES_U1 INDEX12,4912.14

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX20,0518.08
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX10,4804.22
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE9,4323.80
ICXAPPS_TS_TX_IDXICX_SESSION_ATTRIBUTES_U1 INDEX8,8533.57
ICXAPPS_TS_TX_IDXICX_TRANSACTIONS_U2 INDEX8,5163.43

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXSYS_LOB0000006324C00038$$ LOB11626.98
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_403747463_0TABLE PARTITION10925.35
SYSTEMP1SYS_TEMP_0FD9D6605_7B751AF TABLE10.23

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE1,345,74417.31
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX1,194,43215.36
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX1,043,16813.42
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ACTIVITY_STATUSESWF_ITEM57TABLE PARTITION387,9204.99
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N4 INDEX360,4484.64

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
APPLSYSAPPS_TS_TX_DATAFND_CONCURRENT_REQUESTS TABLE8,73895.02
APPLSYSAPPS_TS_TX_DATAFND_CONC_PROG_ONSITE_INFO TABLE2072.25
APPLSYSAPPS_TS_TX_DATAALR_ALERTS TABLE1681.83
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX280.30
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_PKWF_ITEM62INDEX PARTITION110.12

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX5100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
APPLSYSAPPS_TS_TX_DATAFND_CONCURRENT_REQUESTS TABLE1,04741.38
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX25310.00
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX1194.70
APPLSYSAPPS_TS_TX_DATAFND_CONC_PROG_ONSITE_INFO TABLE1174.62
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_PKWF_ITEM57INDEX PARTITION973.83

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control690.000 41
dc_files3250.000 065
dc_global_oids977,9400.000 0184
dc_histogram_data1,9180.000 01,186
dc_histogram_defs26,8670.150 019,365
dc_object_grants150.000 0572
dc_objects1,443,3960.000 012,331
dc_profiles21,0640.000 01
dc_rollback_segments3,1280.000 067
dc_segments36,3670.000 1815,732
dc_sequences9870.000 98760
dc_table_scns88,4610.000 06
dc_tablespace_quotas484.170 04
dc_tablespaces2,288,0580.000 057
dc_users49,270,2780.000 0242
global database name23,8060.000 01
outstanding_alerts3200.000 054


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS41,9980.000 00
APP CONTEXT41,8100.001,806,882-0.0000
BODY720,6690.0017,804,0550.0000
CLUSTER120.00120.0000
CONTEXT POLICY40,0940.0012,9680.0000
DBLINK42,0000.000 00
DIRECTORY22,5680.0022,5680.0000
EDITION21,4040.0042,4680.0000
INDEX670.00670.0000
JAVA DATA5100.003,8760.0000
PIPE1,066-0.191,0650.0000
QUEUE12,4170.00230,0410.0000
RULESET2410.005,4010.0000
SCHEMA21,0830.000 00
SQL AREA1,089,1920.1762,580,2090.012,6032,239
SQL AREA BUILD4,52040.220 00
SQL AREA STATS4,15646.134,15646.1300
SUBSCRIPTION1690.001690.0000
TABLE/PROCEDURE897,0610.0019,865,8150.0000
TRIGGER12,4440.00320,0720.0000


Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache94,720.0094,720.0094,720.0098,816.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target204,800.00204,800.00204,800.00204,800.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target256,000.00256,000.00256,000.00256,000.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool4,608.004,608.00512.004,608.000GRO/IMM
large pool512.00512.000.00512.000GRO/IMM
shared pool153,600.00153,600.00153,600.00153,600.000STA/
streams pool1,024.001,024.000.001,024.000GRO/IMM

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther7,396.19 3.853.801291381,9191,919
PL/SQL6,442.175,300.583.363.8624241,9191,919
JAVA2,479.342,477.053.219.20259267773773
SQL1,261.7291.520.670.884191,8961,889
EOther8,486.88 4.504.551291381,8871,887
PL/SQL7,835.416,033.154.154.9042421,8871,887
JAVA2,774.392,771.543.178.65259267875875
SQL1,506.2675.110.811.005191,8641,858

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers99,321,118,720 
Fixed Size2,175,944 
Redo Buffers489,938,944 
Variable Size167,503,727,672 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory4,586.974,586.96-0.00
largePX msg pool7.817.810.00
largefree memory503.81503.810.00
shareddb_block_hash_buckets6,912.006,912.000.00
sharedfree memory138,787.50138,629.67-0.11
streamsfree memory1,020.191,020.190.00
 buffer_cache94,720.0094,720.000.00
 fixed_sga2.082.080.00
 log_buffer467.24467.240.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0617 08:26:152.770.000.00
QMON Coordinator0617 08:26:050.050.000.00

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 Capture Rate

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

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

Queue NameEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
APPLSYS.WF_CONTROL(423650) 00.0000.0000.00 

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

Subscriber/QueueEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
WFBESCL_21130(17392)/APPLSYS.WF_CONTROL 00.0000.0000.00 
WFBESCL_21131(17393)/APPLSYS.WF_CONTROL 00.0000.0000.00 
WFBESCL_21132(17394)/APPLSYS.WF_CONTROL 00.0000.0000.00 

Back to Streams Statistics
Back to Top

Rule Set

RuleEvalsNo-SQL Eval%SQL ExecsCPU(s)Ela(s)Eval /SecSQL per EvalEla(s) per EvalCPU(s) per EvalReloads
APPLSYS.WF_DEFERRED_R 3,5940.0000.260.360.990.000.000.000
APPLSYS.WF_DEFERRED_QUEUE_M_R 1,8080.001,8080.320.160.501.000.000.000

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
APPLSYS.FND_CP_GSM_IPC_AQ(425717) 00  0.000.00  
APPLSYS.FND_CP_GSM_OPP_AQ(423855) 600100.000.000.020.000.000.00
APPLSYS.WF_CONTROL(423650) 00  0.000.00  
APPLSYS.WF_DEFERRED(423674) 3,59400.000.001.900.810.0027.07
APPLSYS.WF_DEFERRED_QUEUE_M(423736) 1,80800.00100.000.730.000.0041.17
APPLSYS.WF_JAVA_DEFERRED(423754) 00  0.000.00  
APPLSYS.WF_NOTIFICATION_OUT(423750) 00  0.000.00  
SYS.ALERT_QUE(12718) 00  0.000.00  
SYSMAN.MGMT_NOTIFY_Q(428129) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(427799) 61610.000.000.010.030.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
APPLSYS.FND_CP_GSM_IPC_AQ(425717) 0.000.00  
APPLSYS.FND_CP_GSM_OPP_AQ(423855) 0.020.000.00 
APPLSYS.WF_CONTROL(423650) 0.000.00  
APPLSYS.WF_DEFERRED(423674) 0.990.000.00 
APPLSYS.WF_DEFERRED_QUEUE_M(423736) 0.500.000.00 
APPLSYS.WF_JAVA_DEFERRED(423754) 0.000.00  
APPLSYS.WF_NOTIFICATION_OUT(423750) 0.000.00  
SYS.ALERT_QUE(12718) 0.000.00  
SYSMAN.MGMT_NOTIFY_Q(428129) 0.000.00  
SYSMAN.MGMT_TASK_Q(427799) 0.020.020.000.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
FNDCPGSMIPC_CARTRIDGE_1597117(212)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_CARTRIDGE_1597118(214)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_CARTRIDGE_1597119(216)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_CARTRIDGE_1597120(218)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_SERVICE_1597111(201)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597112(203)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597113(205)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597114(207)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597115(209)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597116(211)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597117(213)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597118(215)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597119(217)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597120(219)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597121(221)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597122(223)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597123(225)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
WFBESCL_21130(17392)/APPLSYS.WF_CONTROL 0000.000.000.00
WFBESCL_21131(17393)/APPLSYS.WF_CONTROL 0000.000.000.00
WFBESCL_21132(17394)/APPLSYS.WF_CONTROL 0000.000.000.00
WF_DEFERRED(1)/APPLSYS.WF_DEFERRED 3,5943,58500.990.990.00
APPS(1)/APPLSYS.WF_DEFERRED_QUEUE_M 1,808000.500.000.00
WF_NOTIFICATION_OUT(1)/APPLSYS.WF_NOTIFICATION_OUT 0000.000.000.00
A4U4S141_JP_F_3938_VIS(41)/SYS.ALERT_QUE 0000.000.000.00
HAE_SUB(1)/SYS.ALERT_QUE 000   

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
000000

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per SecDisp Queue Per SecServer Msgs/SecServer KB/SecCommon Queue TotalDisp Queue TotalServer Total MsgsServer Total(KB)
0000.000000

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
O7_DICTIONARY_ACCESSIBILITYFALSE  
_ash_size266338304  
_b_tree_bitmap_plansFALSE  
_db_block_hash_latches33554432  
_fast_full_scan_enabledFALSE  
_kgl_debug name='FND_MSG_PUB' schema='APPS' namespace=1 debug=33554432, name='FND_MSG_PUB' schema='APPS' namespace=2 debug=33554432   
_kgl_hot_object_copies255  
_ksmg_granule_size536870912  
_like_with_bind_as_equalityTRUE  
_optimizer_autostats_jobFALSE  
_resource_manager_always_offTRUE  
_sort_elimination_cost_ratio5  
_system_trig_enabledTRUE  
_trace_files_publicFALSE  
_use_realfree_heapFALSE  
aq_tm_processes1  
audit_sys_operationsTRUE  
audit_trailNONE  
compatible11.2.0  
control_files/DBF/cntrl01.dbf, /DBF/cntrl02.dbf, /DBF/cntrl03.dbf  
cursor_sharingEXACT  
db_block_checkingFALSE  
db_block_checksumTRUE  
db_block_size8192  
db_cache_adviceOFF  
db_files512  
db_nameVIS  
diagnostic_dest/11gR2/apps/VIS/oracle/product/11.2.0/dbhome_1/admin/VIS_a4u4s141  
dml_locks10000  
filesystemio_optionssetall  
ifile/11gR2/apps/VIS/oracle/product/11.2.0/dbhome_1/dbs/VIS_a4u4s141_ifile.ora  
job_queue_processes2  
local_listenerVIS_LOCAL  
log_archive_dest_1LOCATION=/DBF11g/archive  
log_archive_format%t_%s_%r.dbf  
log_buffer268427264  
log_checkpoint_interval100000  
log_checkpoint_timeout1800  
log_checkpoints_to_alertTRUE  
max_dump_file_sizeunlimited  
nls_compbinary  
nls_date_formatDD-MON-RR  
nls_length_semanticsBYTE  
nls_numeric_characters.,  
nls_sortbinary  
nls_territoryamerica  
olap_page_pool_size4194304  
open_cursors65000  
optimizer_dynamic_sampling0  
optimizer_index_caching100  
optimizer_secure_view_mergingFALSE  
os_authent_prefix    
parallel_max_servers128  
parallel_min_servers0  
pga_aggregate_target214748364800  
plsql_code_typeINTERPRETED  
plsql_optimize_level2  
processes40000  
recyclebinOFF  
sec_case_sensitive_logonFALSE  
session_cached_cursors1000000  
session_max_open_files10000  
sessions65024  
sga_max_size268435456000  
sga_target268435456000  
shared_pool_reserved_size8053063680  
shared_pool_size161061273600  
sql92_securityTRUE  
undo_managementAUTO  
undo_tablespaceAPPS_UNDOTS1  
utl_file_dir/usr/tmp, /u11tmp, /11gR2/apps/VIS/oracle/product/11.2.0/dbhome_1/appsutil/outbound/VIS_a4u4s141, /usr/tmp  
workarea_size_policyAUTO  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files/DBF/cntrl01.dbf  
/DBF/cntrl02.dbf  
/DBF/cntrl03.dbf  
utl_file_dir/11gR2/apps/VIS/oracle/product/11.2.0/dbhome_1/appsutil/outbound/VIS_a4u4s141  
/u11tmp  
/usr/tmp  
/usr/tmp  
/usr/tmp  
/usr/tmp  

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report