WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
VIS432961441VIS115-Sep-15 11:0911.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
dbzone2.priv.comSolaris[tm] OE (64-bit) 432 54 2 1914.29

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2815-Sep-15 18:15:253179 61.9
End Snap:3215-Sep-15 19:15:332410 60.7
Elapsed:  60.13 (mins)  
DB Time:  2,213.82 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 62,464M 62,464MStd Block Size: 8K
Shared Pool Size: 16,384M 16,384MLog Buffer: 172,632K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 36.8 0.0 0.00 0.00
DB CPU(s): 36.6 0.0 0.00 0.00
Redo size: 4,996,537.7 5,771.2  
Logical reads: 1,108,313.3 1,280.2  
Block changes: 37,129.2 42.9  
Physical reads: 64.2 0.1  
Physical writes: 428.3 0.5  
User calls: 18,780.3 21.7  
Parses: 2,702.7 3.1  
Hard parses: 1.9 0.0  
W/A MB processed: 122.5 0.1  
Logons: 16.1 0.0  
Executes: 65,467.4 75.6  
Rollbacks: 107.0 0.1  
Transactions: 865.8   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 100.34Soft Parse %: 99.93
Execute to Parse %: 95.87Latch Hit %: 93.60
Parse CPU to Parse Elapsd %: 96.38% Non-Parse CPU: 98.81

Shared Pool Statistics

BeginEnd
Memory Usage %: 23.83 22.45
% SQL with executions>1: 94.95 96.19
% Memory for SQL w/exec>1: 93.47 94.03

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 132,146 99.49 
log file sync1,372,14299310.75Commit
library cache: mutex X661,52367910.51Concurrency
latch: cache buffers chains9,981,32260100.45Concurrency
SQL*Net message to client66,553,97210700.08Network

Host CPU (CPUs: 432 Cores: 54 Sockets: 2)

Load Average BeginLoad Average End%User%System%WIO%Idle
297.43 88.58 26.0 5.1 0.0 68.9
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
8.6 27.6 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 1,960,232.0 1,960,232.0
SGA use (MB): 81,920.0 81,920.0
PGA use (MB): 39,876.3 29,930.6
% Host Mem used for SGA+PGA: 6.21 5.71

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU132,145.7499.49
sql execute elapsed time118,229.7589.01
PL/SQL execution elapsed time24,942.3818.78
parse time elapsed1,746.551.31
connection management call elapsed time597.670.45
Java execution elapsed time595.970.45
inbound PL/SQL rpc elapsed time44.060.03
repeated bind elapsed time17.250.01
failed parse elapsed time4.870.00
hard parse elapsed time3.080.00
sequence load elapsed time2.520.00
PL/SQL compilation elapsed time0.000.00
DB time132,828.96 
background elapsed time3,673.45 
background cpu time1,440.05 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME112,044 
AVG_IDLE_TIME248,281 
AVG_SYS_TIME18,309 
AVG_USER_TIME93,539 
BUSY_TIME48,480,482 
IDLE_TIME107,338,757 
SYS_TIME7,989,823 
USER_TIME40,490,659 
LOAD29789
OS_CPU_WAIT_TIME2,946,500 
VM_IN_BYTES37,715,968 
PHYSICAL_MEMORY_BYTES2,055,452,229,632 
NUM_CPUS432 
NUM_CPU_CORES54 
NUM_CPU_SOCKETS2 
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
15-Sep 18:15:25297.43     
15-Sep 18:30:28286.4332.3626.685.6867.640.00
15-Sep 18:45:30276.1932.0326.535.5067.970.00
15-Sep 19:00:31276.0031.8426.675.1768.160.00
15-Sep 19:15:3388.5828.2124.054.1671.790.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  132,146 99.49
Concurrency10,884,44001,31600.99
Commit1,372,142099310.75
User I/O1,699,836024200.18
Network67,094,174012700.10
Application263,99709800.07
Other822,91705200.04
Configuration2481010.00
System I/O0 0 0.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
log file sync1,372,142099310.440.75
library cache: mutex X661,523067910.210.51
latch: cache buffers chains9,981,322060103.200.45
SQL*Net message to client66,553,9720107021.310.08
db file sequential read16,150010260.010.08
utl_file I/O1,570,16706200.500.05
enq: TX - row lock contention3590621730.000.05
SQL*Net break/reset to client263,63803600.080.03
Disk file operations I/O58,96203510.020.03
buffer busy waits179,80203000.060.02
direct path read50,82602910.020.02
latch free16,45402620.010.02
latch: object queue header operation803,46402500.260.02
SQL*Net more data to client495,16501900.160.01
local write wait3,59401230.000.01
cursor: pin S31,6950300.010.00
latch: In memory undo latch11,7040200.000.00
db file scattered read11502150.000.00
enq: TX - index contention1,3040110.000.00
SQL*Net more data from client45,0370100.010.00
latch: row cache objects16,2740000.010.00
latch: undo global data1,2340000.000.00
enq: US - contention550030.000.00
read by other session210060.000.00
wait list latch free1000010.000.00
enq: SQ - contention1570000.000.00
latch: shared pool6860000.000.00
kksfbc child completion11000500.000.00
enq: HW - contention580010.000.00
buffer deadlock1,400100000.000.00
cursor: pin S wait on X50070.000.00
latch: active service list180010.000.00
db file parallel read100220.000.00
undo segment extension367070.000.00
row cache lock270010.000.00
latch: call allocation1380000.000.00
enq: TX - contention70010.000.00
enq: TX - allocate ITL entry300000.000.00
cursor: mutex X910000.000.00
latch: cache buffers lru chain340000.000.00
SQL*Net message from client66,554,52809,736,22014621.31 
Streams AQ: waiting for messages in the queue8,4739772,84585970.00 
pipe get4,3209918,04941780.00 
PL/SQL lock timer1,44110014,411100000.00 
jobq slave wait7,2231003,6074990.00 

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 write238,74901,85380.0850.45
log file parallel write2,173,372076400.7020.81
os thread startup1610221350.000.59
db file async I/O submit237,89701300.080.35
LGWR wait for redo copy103,3260600.030.16
latch free2,2400520.000.14
control file parallel write1,7550210.000.07
control file sequential read7,9350200.000.06
enq: PR - contention2015530.000.03
db file sequential read8420110.000.02
direct path write3100130.000.01
library cache: mutex X7620000.000.01
latch: object queue header operation3,5400000.000.01
SQL*Net message to client163,3700000.050.00
reliable message1430010.000.00
asynch descriptor resize58,024100000.020.00
latch: active service list3900000.000.00
Disk file operations I/O6610000.000.00
ADR block file write50060.000.00
latch: call allocation2450000.000.00
log file sync130000.000.00
latch: redo allocation530000.000.00
latch: shared pool360000.000.00
buffer busy waits150000.000.00
rdbms ipc message2,008,020165,290330.64 
Space Manager: slave idle wait9,9173932,25532520.00 
Streams AQ: qmn slave idle wait2,084014,40569120.00 
DIAG idle wait7,0121007,01310000.00 
smon timer35703,607101020.00 
Streams AQ: qmn coordinator idle wait1,096483,60132860.00 
JOX Jit Process Sleep2381003,570150000.00 
Streams AQ: waiting for time management or cleanup tasks4,826673,5497350.00 
pmon timer1,912413,25717040.00 
SQL*Net message from client221,27801,19350.07 
class slave wait410050.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 read19100.0       
ADR block file write5 40.0 40.0 20.0  
ADR file lock6100.0       
Disk file operations I/O59.5K96.7.2.4.7.9.8.2 
LGWR wait for redo copy103.2K100.0.0.0 .0   
SQL*Net break/reset to client262.3K99.7.1.1.0.0.0.0 
SQL*Net message to client66.4M100.0       
SQL*Net more data from client45K100.0.0.0.0    
SQL*Net more data to client494.7K100.0.0.0.0.0.0.0 
asynch descriptor resize58K100.0       
buffer busy waits179.8K99.5.1.1.1.1.1.1 
buffer deadlock1400100.0       
control file parallel write17542.295.01.4.7.4.2  
control file sequential read793599.9.0.0.0  .0 
cursor: mutex S6100.0       
cursor: mutex X91100.0       
cursor: pin S31.6K99.4.0.1.0.5.0  
cursor: pin S wait on X5 40.0  60.0   
db file async I/O submit237.6K100.0    .0  
db file parallel read1     100.0  
db file parallel write238.5K2.837.59.917.919.99.03.1 
db file scattered read115  7.020.040.027.85.2 
db file sequential read17K21.21.311.341.622.02.4.1 
direct path read50.8K97.9.4.5.5.5.1.1 
direct path write316.53.212.916.132.325.83.2 
enq: FB - contention1100.0       
enq: HW - contention5891.41.73.41.7 1.7  
enq: PR - contention2      100.0 
enq: SQ - contention15796.81.31.3.6    
enq: TX - allocate ITL entry30100.0       
enq: TX - contention785.714.3      
enq: TX - index contention130392.9.71.41.71.51.4.5 
enq: TX - row lock contention35991.11.7.6.6.31.11.43.3
enq: US - contention5523.618.227.330.9    
kksfbc child completion1      100.0 
latch free18.7K83.4.4.75.09.7.8.0 
latch: In memory undo latch11.7K98.81.1.1.0  .0 
latch: active service list40898.3 .2 .51.0  
latch: cache buffer handles1100.0       
latch: cache buffers chains9951K99.8.1.1.0.0.0.0 
latch: cache buffers lru chain36100.0       
latch: call allocation382100.0       
latch: enqueue hash chains7100.0       
latch: messages4100.0       
latch: object queue header operation806.2K100.0.0.0.0.0.0.0 
latch: redo allocation53100.0       
latch: redo writing2100.0       
latch: row cache objects16.2K100.0       
latch: shared pool722100.0       
latch: undo global data123498.5.8.6     
library cache lock1100.0       
library cache: mutex X661.4K90.7.0.2.18.3.6.0 
local write wait35882.455.929.64.74.42.1.9 
log file parallel write2171K99.4.1.2.3.1.0.0 
log file sync1370.4K96.8.8.91.1.3.1.2 
os thread startup162     1.996.91.2
read by other session214.89.528.638.114.34.8  
reliable message14351.747.6    .7 
row cache lock2785.214.8      
undo segment extension366.7    33.3  
utl_file I/O1568.7K100.0.0.0.0.0.0.0 
wait list latch free100 100.0      
DIAG idle wait7009      100.0 
JOX Jit Process Sleep238       100.0
PL/SQL lock timer1407       100.0
SQL*Net message from client66.5M82.96.92.81.71.5.92.21.0
Space Manager: slave idle wait9779.9.2.1.1.4.215.782.5
Streams AQ: qmn coordinator idle wait109852.3.1  .1  47.5
Streams AQ: qmn slave idle wait2018       100.0
Streams AQ: waiting for messages in the queue84341.1    .01.997.0
Streams AQ: waiting for time management or cleanup tasks482332.6   .0 63.34.1
class slave wait4269.09.54.84.84.82.44.8 
jobq slave wait7233.0.0.0   99.9 
pipe get4313.0     8.291.8
pmon timer191110.5 .1.2.5.529.059.3
rdbms ipc message2005.9K59.919.113.94.8.8.2.4.9
smon timer357 .3.3.3.8 9.289.1

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
Disk file operations I/O12599.8.2.0.0    
SQL*Net break/reset to client45100.0.0.0.0.0.0  
SQL*Net more data to client1100.0 .0     
buffer busy waits9399.9.0.0.0.0.0  
control file sequential read2100.0 .0.0    
db file parallel write728096.92.6.4.0.0.0  
db file scattered read694.85.2      
db file sequential read2299.9.1.0  .0  
direct path read4899.9.1.0.0.0.0  
direct path write196.8 3.2     
enq: PR - contention2    50.050.0  
enq: TX - index contention699.5.5      
enq: TX - row lock contention795.3.8.3.3  .62.8
kksfbc child completion1 100.0      
latch free3100.0.0      
latch: In memory undo latch1100.0 .0     
latch: cache buffers chains22100.0.0.0.0    
latch: object queue header operation2100.0.0.0     
library cache: mutex X104100.0.0.0     
local write wait3399.1.7.2     
log file parallel write97100.0.0.0.0.0   
log file sync209499.8.1.0.0.0.0  
os thread startup1591.958.017.314.22.54.91.2 
reliable message199.3.7      
utl_file I/O13100.0.0.0.0.0   

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
enq: TX - row lock contention1097.2.61.9.3    

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)
VIS132,889132,2032313,999,662
SYS$USERS912049
SYS$BACKGROUND001415

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 17000282421088440313160067099556127
SYS$USERS 90500060
SYS$BACKGROUND 15341960220000

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
24,361.90239,3250.1018.3498.510.00dtv3rtt90j9dy e:FND:cp:STANDARD Select R.Rowid From Fnd_Concur...
17,563.893,6514.8113.22100.010.0185gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
17,350.643,6504.7513.06100.030.0054tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...
16,928.413,6524.6412.74100.090.0081xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
13,834.35361,0900.0410.4299.230.0367mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
11,854.047,6901.548.9299.990.001f93n1zaan5x1 e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...
8,526.467,7261.106.4297.900.1215py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
5,780.5939,1930.154.3599.980.40ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
3,562.6277,541,0660.002.68101.180.00g4pktka6kg4w9 e::fwk:fnd.sso.login.server.MainLoginPageAM SELECT MENU_ID, ENTRY_SEQUENCE...
3,410.2015,5910.222.5799.830.11327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
2,923.2438,6100.082.20100.050.00akma8kaxsp84b e:PO:wf:POAPPRV SELECT reservation_id , requir...
2,639.917,8660.341.9997.530.183mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
2,165.0631,1750.071.6399.430.19du9txjm3qa2yw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.DO...
1,662.33117,5920.011.2599.990.00bf7uwg5pa3pj6 e:ICX:wf:POWFRQAG begin FND_FLEX_WORKFLOW_APIS.V...
1,515.427,6970.201.1499.310.359ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
1,479.55210,9420.011.1195.040.001rd31t40r4fu5 JDBC Thin Client BEGIN fnd_global.bless_next_in...

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
23,998.70239,3250.1018.1624,361.9098.510.00dtv3rtt90j9dy e:FND:cp:STANDARD Select R.Rowid From Fnd_Concur...
17,564.833,6514.8113.2917,563.89100.010.0185gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
17,355.033,6504.7513.1317,350.64100.030.0054tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...
16,943.943,6524.6412.8216,928.41100.090.0081xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
13,727.47361,0900.0410.3913,834.3599.230.0367mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
11,853.077,6901.548.9711,854.0499.990.001f93n1zaan5x1 e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...
8,347.177,7261.086.328,526.4697.900.1215py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
5,779.6239,1930.154.375,780.5999.980.40ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
3,604.8077,541,0660.002.733,562.62101.180.00g4pktka6kg4w9 e::fwk:fnd.sso.login.server.MainLoginPageAM SELECT MENU_ID, ENTRY_SEQUENCE...
3,404.3315,5910.222.583,410.2099.830.11327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
2,924.8338,6100.082.212,923.24100.050.00akma8kaxsp84b e:PO:wf:POAPPRV SELECT reservation_id , requir...
2,574.677,8660.331.952,639.9197.530.183mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
2,152.7631,1750.071.632,165.0699.430.19du9txjm3qa2yw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.DO...
1,662.10117,5920.011.261,662.3399.990.00bf7uwg5pa3pj6 e:ICX:wf:POWFRQAG begin FND_FLEX_WORKFLOW_APIS.V...
1,505.017,6970.201.141,515.4299.310.359ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
1,406.09210,9420.011.061,479.5595.040.001rd31t40r4fu5 JDBC Thin Client BEGIN fnd_global.bless_next_in...

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
23.0339,1930.009.465,780.5999.980.40ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
10.147,7260.004.178,526.4697.900.1215py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
5.347,6970.002.201,515.4299.310.359ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
5.2318,2950.002.15662.0289.290.795vbbcp6pd58b8 e:FND:cp:STANDARD begin Fnd_Concurrent.Init_Requ...
4.867,8660.002.002,639.9197.530.183mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
4.34361,0900.001.7813,834.3599.230.0367mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
4.2031,1750.001.722,165.0699.430.19du9txjm3qa2yw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.DO...
3.8915,5910.001.603,410.2099.830.11327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
2.5614,1060.001.05806.8796.260.32aaw4na3kmdfkq e::bes:oracle.apps.icx.security.session.created DECLARE l_result varchar2(1); ...
2.1824,8570.000.90720.1899.570.30d3pkzg7h1v8uq e:PO:bes:oracle.apps.wf.notification.send SELECT * FROM (SELECT POH.ACCE...

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
1,153,862,2177,690150,047.1028.8611,854.0410001f93n1zaan5x1 e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...
1,025,784,667239,3254,286.1625.6524,361.9098.50dtv3rtt90j9dy e:FND:cp:STANDARD Select R.Rowid From Fnd_Concur...
423,882,0833,651116,100.2710.6017,563.89100085gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
420,262,3323,650115,140.3610.5117,350.64100054tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...
406,754,5543,652111,378.5710.1716,928.41100.1081xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
359,140,526361,090994.608.9813,834.3599.2067mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
299,860,99777,541,0663.877.503,562.62101.20g4pktka6kg4w9 e::fwk:fnd.sso.login.server.MainLoginPageAM SELECT MENU_ID, ENTRY_SEQUENCE...
207,790,8537,72626,895.015.208,526.4697.9.115py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
96,952,36415,5916,218.482.423,410.2099.8.1327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
84,388,71438,6102,185.672.112,923.24100.10akma8kaxsp84b e:PO:wf:POAPPRV SELECT reservation_id , requir...
83,450,65339,1932,129.222.095,780.59100.4ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
77,510,2077,8669,853.831.942,639.9197.5.23mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
69,668,17030,6012,276.661.74859.23100.102vndf5psfws5a e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
9597,7260.120.418,526.4697.900.1215py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
7247,6970.090.311,515.4299.310.359ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
6497,8660.080.282,639.9197.530.183mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
62215,5910.040.273,410.2099.830.11327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
5514137.750.240.5523.4486.4847mm81hm9sggy   SELECT sum(case when a.sessio...
33624,8570.010.14720.1899.570.30d3pkzg7h1v8uq e:PO:bes:oracle.apps.wf.notification.send SELECT * FROM (SELECT POH.ACCE...
1406,5880.020.061,019.4499.810.13733t7qc78btqw e:POS:fwk:ap.invoice.request.server.InvoiceReque SELECT * FROM (SELECT DECODE(p...
11231,1750.000.052,165.0699.430.19du9txjm3qa2yw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.DO...
8014,1060.010.03806.8796.260.32aaw4na3kmdfkq e::bes:oracle.apps.icx.security.session.created DECLARE l_result varchar2(1); ...
7229,7370.000.031,024.6394.870.17bqf04xkudk4zt JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.crea...

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
9499497,7260.120.000.9515py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
6996997,6970.090.000.709ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
6356357,8660.080.000.643mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
61361315,5910.040.000.61327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
33533524,8570.010.000.34d3pkzg7h1v8uq e:PO:bes:oracle.apps.wf.notification.send SELECT * FROM (SELECT POH.ACCE...
1391396,5880.020.000.14733t7qc78btqw e:POS:fwk:ap.invoice.request.server.InvoiceReque SELECT * FROM (SELECT DECODE(p...
11211231,1750.000.000.11du9txjm3qa2yw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.DO...
808014,1060.010.000.08aaw4na3kmdfkq e::bes:oracle.apps.icx.security.session.created DECLARE l_result varchar2(1); ...
727229,7370.000.000.07bqf04xkudk4zt JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.crea...
171715,4060.000.000.02g89s7tq651bus e:PO:fwk:po.autocreate.server.AutocreateAM INSERT INTO ZX_TRANSACTION_LIN...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
77,541,066624,218,5098.053,562.62101.20g4pktka6kg4w9 e::fwk:fnd.sso.login.server.MainLoginPageAM SELECT MENU_ID, ENTRY_SEQUENCE...
10,210,1249,592,3650.94507.56100.900wmwsjy9kd92f ICM@appszone2.priv.com (TNS V1-V3) SELECT PROFILE_OPTION_ID, APPL...
7,767,2572,083,0130.27282.90102.307qs7fx89194u1 ICM@appszone2.priv.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
4,898,47844,095,9869.00189.88101.808w57t3xaxs89k ICM@appszone2.priv.com (TNS V1-V3) SELECT NAME, VERSION FROM FND_...
4,072,9181,710,2000.42353.78101.60dawf7hvg1ym94 JDBC Thin Client select V.PROFILE_OPTION_VALUE ...
3,825,0263,821,8461.00806.65101.109tmzdvyu94058 e:PO:fwk:po.document.server.DocumentAM SELECT PoLineLocationMergeEO.O...
3,318,5843,315,9401.00687.01100.80cd02js3xuc27n e:PO:fwk:po.document.server.DocumentAM SELECT PoLineMergeEO.DRAFT_ID ...
2,409,4852,409,1501.00248.03100.8016614jtsr33r0 JDBC Thin Client begin fnd_date.initialize_with...
2,114,7862,091,4900.99138.84101.7091hakq9n36htp e:ICX:wf:REQAPPRV SELECT TEXT_VALUE FROM WF_ITEM...
1,936,9381,933,5801.00180.55101.9037kp7bjxfn4u5 ICM@appszone2.priv.com (TNS V1-V3) SELECT NLS_DATE_LANGUAGE FROM ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
459,864459,8744.726vx0fw5141z4n e:POS:fwk:ap.invoice.request.server.InvoiceReque SELECT STATUS_FLAG FROM IGI_GC...
353,221353,2353.62bbugagurwv1vy e:POS:fwk:ap.invoice.request.server.InvoiceReque (SELECT STATUS_FLAG FROM IGI_G...
157,031157,0271.617yr8xbwxpdnav e:ICX:wf:POWFRQAG INSERT INTO WIP_EAM_DIRECT_ITE...
117,757117,7571.21dnx99s71vmu3r e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT POA.AGENT_ID FROM PO_AG...
99,95399,9521.039tssyu6p7uk2s e:POS:fwk:ap.invoice.request.server.InvoiceReque SELECT SUM(AID.AMOUNT) FROM AP...
99,94899,9461.02529wb67xu0sy9 e:POS:fwk:ap.invoice.request.server.InvoiceReque SELECT INPUT_TAX_CLASSIFICATIO...
78,39678,3980.801xhyhsq3uy5by e:ICX:wf:POWFRQAG SELECT ACCRUED_CODE_COMBINATIO...
77,65577,6610.80f2mg2y50g364u e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT DEFAULT_TAXATION_COUNTR...
70,55910,210,1240.720wmwsjy9kd92f ICM@appszone2.priv.com (TNS V1-V3) SELECT PROFILE_OPTION_ID, APPL...
67,50067,5100.696puncb1y2mfyw e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT SOB.SET_OF_BOOKS_ID, SO...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
4,849,3703,6520.03b5ku28kvsxwuk e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT phx.*, PO_COMMUNICATION...
2,413,8253,6520.0181xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
1,133,74518,2510.014mj8xhjcnw7gf e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."SHIPMENT_NUM" "SH...

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
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;
1f93n1zaan5x1 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, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02") RFQ_REQUIRED , NVL(prl.rfq_required_flag, :"SYS_B_03") RFQ_REQUIRED_FLAG , NVL(prl.on_rfq_flag, :"SYS_B_04") ON_RFQ_FLAG , NVL(prl.drop_ship_flag, :"SYS_B_05") 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, :"SYS_B_06", prl.amount, :"SYS_B_07", 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, :"SYS_B_08", prl.currency_amount, :"SYS_B_09", prl.currency_amount, prl.quantity * prl.currency_unit_price) FOREIGN_CURRENCY_AMT , decode(pltb.purchase_basis, :"SYS_B_10", prl.currency_unit_price , :"SYS_B_11", decode(prl.order_type_lookup_code , :"SYS_B_12", prl.amount , :"SYS_B_13", prl.quantity * prl.currency_unit_price) , :"SYS_B_14", 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)||:"SYS_B_15"||rtrim(deliver_hz.city), :"SYS_B_16", :"SYS_B_17")) 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, :"SYS_B_18", :"SYS_B_19", :"SYS_B_20") ENCUMBERED , NVL(prl.encumbered_flag, :"SYS_B_21") 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, :"SYS_B_22")), :"SYS_B_23", :"SYS_B_24", :"SYS_B_25") LATE_FLAG , DECODE(prl.modified_by_agent_flag, :"SYS_B_26", :"SYS_B_27", :"SYS_B_28") 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, :"SYS_B_29"), :"SYS_B_30", TO_NUMBER(NULL), :"SYS_B_31", -:"SYS_B_32", 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 REQUESTER_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, :"SYS_B_33") GLOBAL_FLAG , DECODE (src_doc.global_agreement_flag, :"SYS_B_34", :"SYS_B_35", :"SYS_B_36") GLOBAL , DECODE (prl.blanket_po_header_id, NULL, :"SYS_B_37", :"SYS_B_38") REQ_SOURCED_FLAG , prl.oke_contract_header_id OKE_CONTRACT_HEADER_ID , prl.assignment_start_date ASSIGNMENT_START_DATE , DECODE (prl.new_supplier_flag, :"SYS_B_39", :"SYS_B_40", :"SYS_B_41") NEW_SUPPLIER , NVL(prl.new_supplier_flag, :"SYS_B_42") 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, :"SYS_B_43", :"SYS_B_44") UNASSIGNED_FLAG , prl.un_number_id UN_NUMBER_ID , DECODE (prl.urgent_flag, :"SYS_B_45", :"SYS_B_46", :"SYS_B_47") URGENT , NVL(prl.urgent_flag, :"SYS_B_48") URGENT_FLAG , DECODE (prl.vmi_flag, :"SYS_B_49", :"SYS_B_50", :"SYS_B_51") VMI , NVL(prl.vmi_flag, :"SYS_B_52") VMI_FLAG , prl.wip_entity_id WIP_ENTITY_ID , prl.wip_line_id WIP_LINE_ID , NVL(prh.authorization_status, :"SYS_B_53") 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 ||:"SYS_B_54" || prl.line_num REQUEST , nvl( msi.concatenated_segments, prl.item_description) ITEM , decode(pltb.purchase_basis, :"SYS_B_55", prl.unit_price , :"SYS_B_56", decode(prl.order_type_lookup_code , :"SYS_B_57", prl.amount , :"SYS_B_58", prl.quantity * prl.unit_price) , :"SYS_B_59", prl.unit_price ) PRICE , prl.vendor_contact_id VENDOR_CONTACT_ID , prl.PARENT_REQ_LINE_ID , prl.source_type_code , ( SELECT :"SYS_B_60" FROM dual WHERE exists ( SELECT :"SYS_B_61" FROM po_req_distributions_all prd WHERE prd.requisition_line_id=prl.requisition_line_id AND prd.award_id is not null ) )AWARD_E XISTS , 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(:"SYS_B_62") AND pltb.line_type_id = prl.line_type_id AND plttl.line_type_id = pltb.line_type_id AND plttl.language = userenv(:"SYS_B_63") 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(:"SYS_B_64") 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(:"SYS_B_65") 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 = :"SYS_B_66" AND ( NOT (pltb.order_type_lookup_code = :"SYS_B_67" AND pltb.purchase_basis = :"SYS_B_68" AND EXISTS (SELECT :"SYS_B_69" 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 = :"SYS_B_70" AND pltb.purchase_basis = :"SYS_B_71" AND EXISTS (SELECT :"SYS_B_72" 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, :"SYS_B_73") NOT IN (:"SYS_B_74", :"SYS_B_75") 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(:"SYS_B_76"), :"SYS_B_77", FND_GLOBAL.EMPLOYEE_ID, :"SYS_B_78", 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
1rd31t40r4fu5BEGIN fnd_global.bless_next_init('FND_PERMIT_0006'); FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
1xhyhsq3uy5bySELECT ACCRUED_CODE_COMBINATION_ID FROM PO_SYSTEM_PARAMETERS
2vndf5psfws5a 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, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02") RFQ_REQUIRED , NVL(prl.rfq_required_flag, :"SYS_B_03") RFQ_REQUIRED_FLAG , NVL(prl.on_rfq_flag, :"SYS_B_04") ON_RFQ_FLAG , NVL(prl.drop_ship_flag, :"SYS_B_05") 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, :"SYS_B_06", prl.amount, :"SYS_B_07", 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, :"SYS_B_08", prl.currency_amount, :"SYS_B_09", prl.currency_amount, prl.quantity * prl.currency_unit_price) FOREIGN_CURRENCY_AMT , decode(pltb.purchase_basis, :"SYS_B_10", prl.currency_unit_price , :"SYS_B_11", decode(prl.order_type_lookup_code , :"SYS_B_12", prl.amount , :"SYS_B_13", prl.quantity * prl.currency_unit_price) , :"SYS_B_14", 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)||:"SYS_B_15"||rtrim(deliver_hz.city), :"SYS_B_16", :"SYS_B_17")) 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, :"SYS_B_18", :"SYS_B_19", :"SYS_B_20") ENCUMBERED , NVL(prl.encumbered_flag, :"SYS_B_21") 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, :"SYS_B_22")), :"SYS_B_23", :"SYS_B_24", :"SYS_B_25") LATE_FLAG , DECODE(prl.modified_by_agent_flag, :"SYS_B_26", :"SYS_B_27", :"SYS_B_28") 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, :"SYS_B_29"), :"SYS_B_30", TO_NUMBER(NULL), :"SYS_B_31", -:"SYS_B_32", 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 REQUESTER_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, :"SYS_B_33") GLOBAL_FLAG , DECODE (src_doc.global_agreement_flag, :"SYS_B_34", :"SYS_B_35", :"SYS_B_36") GLOBAL , DECODE (prl.blanket_po_header_id, NULL, :"SYS_B_37", :"SYS_B_38") REQ_SOURCED_FLAG , prl.oke_contract_header_id OKE_CONTRACT_HEADER_ID , prl.assignment_start_date ASSIGNMENT_START_DATE , DECODE (prl.new_supplier_flag, :"SYS_B_39", :"SYS_B_40", :"SYS_B_41") NEW_SUPPLIER , NVL(prl.new_supplier_flag, :"SYS_B_42") 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, :"SYS_B_43", :"SYS_B_44") UNASSIGNED_FLAG , prl.un_number_id UN_NUMBER_ID , DECODE (prl.urgent_flag, :"SYS_B_45", :"SYS_B_46", :"SYS_B_47") URGENT , NVL(prl.urgent_flag, :"SYS_B_48") URGENT_FLAG , DECODE (prl.vmi_flag, :"SYS_B_49", :"SYS_B_50", :"SYS_B_51") VMI , NVL(prl.vmi_flag, :"SYS_B_52") VMI_FLAG , prl.wip_entity_id WIP_ENTITY_ID , prl.wip_line_id WIP_LINE_ID , NVL(prh.authorization_status, :"SYS_B_53") 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 ||:"SYS_B_54" || prl.line_num REQUEST , nvl( msi.concatenated_segments, prl.item_description) ITEM , decode(pltb.purchase_basis, :"SYS_B_55", prl.unit_price , :"SYS_B_56", decode(prl.order_type_lookup_code , :"SYS_B_57", prl.amount , :"SYS_B_58", prl.quantity * prl.unit_price) , :"SYS_B_59", prl.unit_price ) PRICE , prl.vendor_contact_id VENDOR_CONTACT_ID , prl.PARENT_REQ_LINE_ID , prl.source_type_code , ( SELECT :"SYS_B_60" FROM dual WHERE exists ( SELECT :"SYS_B_61" FROM po_req_distributions_all prd WHERE prd.requisition_line_id=prl.requisition_line_id AND prd.award_id is not null ) )AWARD_E XISTS , 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(:"SYS_B_62") AND pltb.line_type_id = prl.line_type_id AND plttl.line_type_id = pltb.line_type_id AND plttl.language = userenv(:"SYS_B_63") 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(:"SYS_B_64") 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(:"SYS_B_65") 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 = :"SYS_B_66" AND ( NOT (pltb.order_type_lookup_code = :"SYS_B_67" AND pltb.purchase_basis = :"SYS_B_68" AND EXISTS (SELECT :"SYS_B_69" 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 = :"SYS_B_70" AND pltb.purchase_basis = :"SYS_B_71" AND EXISTS (SELECT :"SYS_B_72" 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, :"SYS_B_73") NOT IN (:"SYS_B_74", :"SYS_B_75") 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(:"SYS_B_76"), :"SYS_B_77", FND_GLOBAL.EMPLOYEE_ID, :"SYS_B_78", 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
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 )
3mhu25sfw466xbegin :1 := POR_UTIL_PKG.submitreq(:2, :3, :4, :5, :6); end;
47mm81hm9sggy SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid
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'
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;
5vbbcp6pd58b8begin Fnd_Concurrent.Init_Request; end;
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;
6puncb1y2mfywSELECT SOB.SET_OF_BOOKS_ID, SOB.CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS SOB, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
6vx0fw5141z4nSELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 )
733t7qc78btqw SELECT * FROM (SELECT DECODE(prl.po_release_id, NULL, NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1), NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1) || :"SYS_B_00" || TO_CHAR(prl.release_num)) po_number_display, NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1) po_number , poh.po_header_id po_header_id , poh.agent_id agent_id , poh.creation_date creation_date , poh.vendor_id vendor_id , poh.vendor_site_id vendor_site_id , poh.vendor_contact_id vendor_contact_id , NVL(POL.LINE_NUM_DISPLAY, to_char(POL.LINE_NUM)) line_num , pol.item_description item_description , /*5082374, we should set the unit price and uom to null for prepayments. The 0*null is used so the datatype returned from the decode is number */ DECODE(pll.shipment_type, :"SYS_B_01", DECODE(pll.matching_basis, :"SYS_B_02", :"SYS_B_03" *NULL, NVL(pll.price_override, pol.unit_price)), NVL(pll.price_override, pol.unit_price)) unit_price, DECODE(pll.shipment_type, :"SYS_B_04", DECODE(pll.matching_basis, :"SYS_B_05", NULL, pol.unit_meas_lookup_code), pol.unit_meas_lookup_code) unit_meas_lookup_code , mum.uom_class uom_class, pll.quantity quantity_ordered, pll.quantity_received quantity_received , (DECODE(pll.shipment_type, :"SYS_B_06", pll.quantity_financed, NVL(pll.quantity_billed, :"SYS_B_07"))) quantity_billed, hrl.location_code ship_to_location, pvs.vendor_site_code vendor_site_code, pvs.pay_site_flag pay_site_flag, poh.currency_code currency_code, pol.po_line_id po_line_id, pll.line_location_id line_location_id, pll.ship_to_organization_id shipto_org_id, pll.shipment_num shipment_num, pll.taxable_flag taxable_flag, pll.tax_code_id tax_code_id, hro.name organization_name, pll.org_id org_id, pll.po_release_id po_release_id, msi.concatenated_segments item_number, pol.vendor_product_num supplier_item_number, pll.amount_received amount_received, DECODE(pll.shipment_type, :"SYS_B_08", pll.amount_financed, NVL(pll.amount_billed, :"SYS_B_09")) amount_billed, pll.amount amount_ordered, NVL(pll.matching_basis, :"SYS_B_10") matching_basis, pol.item_id, flv.meaning matching_basis_meaning, prl.release_num, pv.vendor_name vendor_name, NULL waybill_airbill_num, --rsh.waybill_airbill_num, NULL packing_slip, --rsl.packing_slip, NULL container_num, --rsl.container_num, pll.match_option, pll.shipment_type, DECODE(pll.shipment_type, :"SYS_B_11", :"SYS_B_12", :"SYS_B_13") finance_flag, pll.ship_to_location_id, pv.segment1 vendor_num, (NVL(pll.quantity, :"SYS_B_14") -DECODE(pll.shipment_type, :"SYS_B_15", pll.quantity_financed, NVL(pll.quantity_billed, :"SYS_B_16")) -NVL(pll.quantity_cancelled, :"SYS_B_17")) unbilled_qty, NULL shipment_line_id, --rsl.shipment_line_id, (NVL(pll.amount, :"SYS_B_18") -DECODE(pll.shipment_type, :"SYS_B_19", pll.amount_financed, NVL(pll.amount_billed, :"SYS_B_20")) -NVL(pll.amount_cancelled, :"SYS_B_21")) unbilled_amount, poh.pay_on_code pay_on_code FROM po_headers_all poh , po_lines_all pol , po_lines_ap_v polv , po_line_locations_all pll , po_releases_all prl , po_vendor_sites_all pvs , hr_locations_all hrl , mtl_units_of_measure mum, mtl_system_items_kfv msi, hr_all_organization_units_vl hro, fnd_lookup_values_vl flv, po_vendors pv WHERE poh.po_header_id = pol.po_header_id AND poh.authorization_status = :"SYS_B_22" AND pol.po_line_id = pll.po_line_id and pol.po_line_id = polv.po_line_id AND pol.unit_meas_lookup_code = mum.unit_of_measure(+) AND pll.po_release_id = prl.po_release_id(+) AND pvs.vendor_site_id = poh.vendor_site_id AND hrl.location_id(+) = pll.ship_to_location_id AND NVL(pll.approved_flag, :"SYS_B_23") = :"SYS_B_24" AND NVL(pll.cancel_flag, :"SYS_B_25") = :"SYS_B_26" AND poh.pcard_id I S NULL AND NVL(pll.closed_code, :"SYS_B_27") NOT IN(:"SYS_B_28", :"SYS_B_29", :"SYS_B_30") AND pll.shipment_type IN(:"SYS_B_31", :"SYS_B_32", :"SYS_B_33", :"SYS_B_34") AND hro.organization_id(+) = poh.org_id AND pol.item_id = msi.inventory_item_id(+) AND NVL(pll.consigned_flag, :"SYS_B_35") <> :"SYS_B_36" AND NVL(msi.organization_id, pll.ship_to_organization_id) = pll.ship_to_organization_id AND flv.lookup_type(+) = :"SYS_B_37" AND flv.lookup_code(+) = NVL(pll.matching_basis, :"SYS_B_38") AND pv.vendor_id = poh.vendor_id AND (DECODE(pll.shipment_type, :"SYS_B_39", DECODE(pll.matching_basis, :"SYS_B_40", (NVL(pll.quantity, :"SYS_B_41") -NVL(pll.quantity_financed, :"SYS_B_42") -NVL(pll.quantity_cancelled, :"SYS_B_43")), (NVL(pll.amount, :"SYS_B_44") -NVL(pll.amount_financed, :"SYS_B_45") -NVL(pll.amount_cancelled, :"SYS_B_46"))), :"SYS_B_47")) > :"SYS_B_48" AND NVL(pll.match_option, :"SYS_B_49") = :"SYS_B_50" UNION SELECT DECODE(prl.PO_RELEASE_ID, NULL, NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1), NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1) || :"SYS_B_51" || TO_CHAR(prl.RELEASE_NUM)) PO_NUMBER_DISPLAY, NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1) PO_NUMBER , poh.PO_HEADER_ID PO_HEADER_ID , poh.AGENT_ID AGENT_ID , poh.CREATION_DATE CREATION_DATE , poh.VENDOR_ID VENDOR_ID , poh.VENDOR_SITE_ID VENDOR_SITE_ID , poh.VENDOR_CONTACT_ID VENDOR_CONTACT_ID , NVL(POL.LINE_NUM_DISPLAY, to_char(POL.LINE_NUM)) LINE_NUM , pol.ITEM_DESCRIPTION ITEM_DESCRIPTION , /*5082374, we should set the unit price and uom to null for prepayments. The 0*null is used so the datatype returned from the decode is number */ DECODE(pll.shipment_type, :"SYS_B_52", DECODE(pll.matching_basis, :"SYS_B_53", :"SYS_B_54"*NULL, NVL(pll.PRICE_OVERRIDE, pol.UNIT_PRICE)), NVL(pll.PRICE_OVERRIDE, pol.UNIT_PRICE)) UNIT_PRICE , DECODE(pll.shipment_type, :"SYS_B_55", DECODE(pll.matching_basis, :"SYS_B_56", NULL, pol.UNIT_MEAS_LOOKUP_CODE), pol.UNIT_MEAS_LOOKUP_CODE) UNIT_MEAS_LOOKUP_CODE , mum.UOM_CLASS UOM_CLASS, PLL.QUANTITY QUANTITY_ORDERED, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt(RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_57")) QUANTITY_RECEIVED, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt(RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_58")) QUANTITY_BILLED, hrl.LOCATION_CODE SHIP_TO_LOCATION, pvs.VENDOR_SITE_CODE VENDOR_SITE_CODE, pvs.PAY_SITE_FLAG PAY_SITE_FLAG, poh.CURRENCY_CODE CURRENCY_CODE, pol.PO_LINE_ID PO_LINE_ID, pll.LINE_LOCATION_ID LINE_LOCATION_ID, pll.SHIP_TO_ORGANIZATION_ID SHIPTO_ORG_ID, pll.SHIPMENT_NUM SHIPMENT_NUM, pll.TAXABLE_FLAG TAXABLE_FLAG, pll.TAX_CODE_ID TAX_CODE_ID, hro.NAME ORGANIZATION_NAME, pll.ORG_ID ORG_ID, pll.PO_RELEASE_ID PO_RELEASE_ID, msi.CONCATENATED_SEGMENTS ITEM_NUMBER, pol.VENDOR_PRODUCT_NUM SUPPLIER_ITEM_NUMBER, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt(RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_59")) amount_received, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt( RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_60")) amount_billed, pll.amount AMOUNT_ORDERED, NVL(pll.MATCHING_BASIS, :"SYS_B_61") MATCHING_BASIS, pol.ITEM_ID, flv.meaning MATCHING_BASIS_MEANING, prl.release_num, PV.VENDOR_NAME VENDOR_NAME, RSH.WAYBILL_AIRBILL_NUM, RSL.PACKING_SLIP, RSL.CONTAINER_NUM, PLL.MATCH_OPTION, PLL.SHIPMENT_TYPE, DECODE(pll.shipment_type, :"SYS_B_62", :"SYS_B_63", :"SYS_B_64") FINANCE_FLAG, pll.ship_to_location_id, pv.segment1 vendor_num, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt( RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_65")) UN BILLED_QTY, RSL.shipment_line_id, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt( RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_66")) UNBILLED_AMOUNT, POH.PAY_ON_CODE PAY_ON_CODE FROM PO_HEADERS_ALL poh , PO_LINES_ALL pol , po_lines_ap_v polv , PO_LINE_LOCATIONS_ALL pll , PO_RELEASES_ALL prl , PO_VENDOR_SITES_ALL pvs , HR_LOCATIONS_ALL hrl , MTL_UNITS_OF_MEASURE mum , MTL_SYSTEM_ITEMS_KFV MSI , HR_ALL_ORGANIZATION_UNITS_VL hro, fnd_lookup_values_vl flv , PO_VENDORS PV , RCV_SHIPMENT_LINES RSL , RCV_SHIPMENT_HEADERS RSH WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID AND POH.AUTHORIZATION_STATUS = :"SYS_B_67" AND POL.PO_LINE_ID = PLL.PO_LINE_ID and pol.po_line_id = polv.po_line_id AND pol.unit_meas_lookup_code = mum.unit_of_measure (+) AND PLL.PO_RELEASE_ID = PRL.PO_RELEASE_ID(+) AND pvs.vendor_site_id = poh.vendor_site_id AND hrl.location_id (+) = pll.ship_to_location_id AND NVL(pll.approved_flag, :"SYS_B_68") = :"SYS_B_69" AND NVL(pll.CANCEL_FLAG, :"SYS_B_70") = :"SYS_B_71" AND POH.pcard_id IS NULL AND NVL(pll.closed_code, :"SYS_B_72") NOT IN (:"SYS_B_73", :"SYS_B_74", :"SYS_B_75") AND pll.shipment_type IN (:"SYS_B_76", :"SYS_B_77", :"SYS_B_78", :"SYS_B_79") AND hro.ORGANIZATION_ID (+) = poh.ORG_ID AND pol.item_id = MSI.inventory_item_id (+) AND NVL(pll.consigned_flag, :"SYS_B_80") <> :"SYS_B_81" AND NVL(msi.ORGANIZATION_ID, pll.SHIP_TO_ORGANIZATION_ID) = pll.SHIP_TO_ORGANIZATION_ID AND flv.lookup_type (+) = :"SYS_B_82" AND flv.lookup_code (+) = NVL(pll.MATCHING_BASIS, :"SYS_B_83") AND PV.VENDOR_ID = POH.VENDOR_ID AND RSL.PO_LINE_LOCATION_ID(+) = PLL.LINE_LOCATION_ID AND RSH.SHIPMENT_HEADER_ID(+) = RSL.SHIPMENT_HEADER_ID AND DECODE( PLL.MATCHING_BASIS, :"SYS_B_84", AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt( RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_85"), AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt(RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_86"), :"SYS_B_87" ) > :"SYS_B_88" AND pll.match_option = :"SYS_B_89") QRSLT WHERE (UPPER(PO_NUMBER) LIKE :1 AND (PO_NUMBER LIKE :2 OR PO_NUMBER LIKE :3 OR PO_NUMBER LIKE :4 OR PO_NUMBER LIKE :5) AND NVL(PAY_ON_CODE, :"SYS_B_90") NOT IN (:"SYS_B_91") AND org_id IN (SELECT organization_id FROM per_all_assignments_f WHERE person_id=:6 AND nvl(effective_end_date, SYSDATE) >= SYSDATE)) ORDER BY PO_NUMBER desc, RELEASE_NUM desc
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
91hakq9n36htpSELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
9tmzdvyu94058 SELECT PoLineLocationMergeEO.OWNER_USER_ID AS "OwnerUserId", PoLineLocationMergeEO.OWNER_ROLE AS "OwnerRole", PoLineLocationMergeEO.STATUS AS "Status", PoLineLocationMergeEO.DRAFT_ID AS "DraftId", PoLineLocationMergeEO.CHANGE_ACCEPTED_FLAG AS "ChangeAcceptedFlag", PoLineLocationMergeEO.DELETE_FLAG AS "DeleteFlag", PoLineLocationMergeEO.USSGL_TRANSACTION_CODE AS "UssglTransactionCode", PoLineLocationMergeEO.GOVERNMENT_CONTEXT AS "GovernmentContext", PoLineLocationMergeEO.RECEIVING_ROUTING_ID AS "ReceivingRoutingId", PoLineLocationMergeEO.ACCRUE_ON_RECEIPT_FLAG AS "AccrueOnReceiptFlag", PoLineLocationMergeEO.CLOSED_REASON AS "ClosedReason", PoLineLocationMergeEO.CLOSED_DATE AS "ClosedDate", PoLineLocationMergeEO.CLOSED_BY AS "ClosedBy", PoLineLocationMergeEO.ORG_ID AS "OrgId", PoLineLocationMergeEO.ATTRIBUTE6 AS "Attribute6", PoLineLocationMergeEO.ATTRIBUTE7 AS "Attribute7", PoLineLocationMergeEO.ATTRIBUTE8 AS "Attribute8", PoLineLocationMergeEO.ATTRIBUTE9 AS "Attribute9", PoLineLocationMergeEO.ATTRIBUTE10 AS "Attribute10", PoLineLocationMergeEO.UNIT_OF_MEASURE_CLASS AS "UnitOfMeasureClass", PoLineLocationMergeEO.ENCUMBER_NOW AS "EncumberNow", PoLineLocationMergeEO.ATTRIBUTE11 AS "Attribute11", PoLineLocationMergeEO.ATTRIBUTE12 AS "Attribute12", PoLineLocationMergeEO.ATTRIBUTE13 AS "Attribute13", PoLineLocationMergeEO.ATTRIBUTE14 AS "Attribute14", PoLineLocationMergeEO.ATTRIBUTE15 AS "Attribute15", PoLineLocationMergeEO.INSPECTION_REQUIRED_FLAG AS "InspectionRequiredFlag", PoLineLocationMergeEO.RECEIPT_REQUIRED_FLAG AS "ReceiptRequiredFlag", PoLineLocationMergeEO.QTY_RCV_TOLERANCE AS "QtyRcvTolerance", PoLineLocationMergeEO.QTY_RCV_EXCEPTION_CODE AS "QtyRcvExceptionCode", PoLineLocationMergeEO.ENFORCE_SHIP_TO_LOCATION_CODE AS "EnforceShipToLocationCode", PoLineLocationMergeEO.ALLOW_SUBSTITUTE_RECEIPTS_FLAG AS "AllowSubstituteReceiptsFlag", PoLineLocationMergeEO.DAYS_EARLY_RECEIPT_ALLOWED AS "DaysEarlyReceiptAllowed", PoLineLocationMergeEO.DAYS_LATE_RECEIPT_ALLOWED AS "DaysLateReceiptAllowed", PoLineLocationMergeEO.RECEIPT_DAYS_EXCEPTION_CODE AS "ReceiptDaysExceptionCode", PoLineLocationMergeEO.INVOICE_CLOSE_TOLERANCE AS "InvoiceCloseTolerance", PoLineLocationMergeEO.RECEIVE_CLOSE_TOLERANCE AS "ReceiveCloseTolerance", PoLineLocationMergeEO.SHIP_TO_ORGANIZATION_ID AS "ShipToOrganizationId", PoLineLocationMergeEO.SHIPMENT_NUM AS "ShipmentNum", PoLineLocationMergeEO.SOURCE_SHIPMENT_ID AS "SourceShipmentId", PoLineLocationMergeEO.SHIPMENT_TYPE AS "ShipmentType", PoLineLocationMergeEO.CLOSED_CODE AS "ClosedCode", PoLineLocationMergeEO.REQUEST_ID AS "RequestId", PoLineLocationMergeEO.PROGRAM_APPLICATION_ID AS "ProgramApplicationId", PoLineLocationMergeEO.PROGRAM_ID AS "ProgramId", PoLineLocationMergeEO.PROGRAM_UPDATE_DATE AS "ProgramUpdateDate", PoLineLocationMergeEO.PROMISED_DATE AS "PromisedDate", PoLineLocationMergeEO.LAST_ACCEPT_DATE AS "LastAcceptDate", PoLineLocationMergeEO.PRICE_OVERRIDE AS "PriceOverride", PoLineLocationMergeEO.ENCUMBERED_FLAG AS "EncumberedFlag", PoLineLocationMergeEO.ENCUMBERED_DATE AS "EncumberedDate", PoLineLocationMergeEO.UNENCUMBERED_QUANTITY AS "UnencumberedQuantity", PoLineLocationMergeEO.FOB_LOOKUP_CODE AS "FobLookupCode", PoLineLocationMergeEO.FREIGHT_TERMS_LOOKUP_CODE AS "FreightTermsLookupCode", PoLineLocationMergeEO.TAXABLE_FLAG AS "TaxableFlag", PoLineLocationMergeEO.ESTIMATED_TAX_AMOUNT AS "Estimat edTaxAmount", PoLineLocationMergeEO.FROM_HEADER_ID AS "FromHeaderId", PoLineLocationMergeEO.FROM_LINE_ID AS "FromLineId", PoLineLocationMergeEO.FROM_LINE_LOCATION_ID AS "FromLineLocationId", PoLineLocationMergeEO.START_DATE AS "StartDate", PoLineLocationMergeEO.END_DATE AS "EndDate", PoLineLocationMergeEO.LEAD_TIME AS "LeadTime", PoLineLocationMergeEO.LEAD_TIME_UNIT AS "LeadTimeUnit", PoLineLocationMergeEO.PRICE_DISCOUNT AS "PriceDiscount", PoLineLocationMergeEO.TERMS_ID AS "TermsId", PoLineLocationMergeEO.APPROVED_FLAG AS "ApprovedFlag", PoLineLocationMergeEO.APPROVED_DATE AS "ApprovedDate", PoLineLocationMergeEO.CLOSED_FLAG AS "ClosedFlag", PoLineLocationMergeEO.CANCEL_FLAG AS "CancelFlag", PoLineLocationMergeEO.CANCELLED_BY AS "CancelledBy", PoLineLocationMergeEO.CANCEL_DATE AS "CancelDate", PoLineLocationMergeEO.CANCEL_REASON AS "CancelReason", PoLineLocationMergeEO.FIRM_STATUS_LOOKUP_CODE AS "FirmStatusLookupCode", PoLineLocationMergeEO.FIRM_DATE AS "FirmDate", PoLineLocationMergeEO.ATTRIBUTE_CATEGORY AS "AttributeCategory", PoLineLocationMergeEO.ATTRIBUTE1 AS "Attribute1", PoLineLocationMergeEO.ATTRIBUTE2 AS "Attribute2", PoLineLocationMergeEO.ATTRIBUTE3 AS "Attribute3", PoLineLocationMergeEO.ATTRIBUTE4 AS "Attribute4", PoLineLocationMergeEO.ATTRIBUTE5 AS "Attribute5", PoLineLocationMergeEO.LINE_LOCATION_ID AS "LineLocationId", PoLineLocationMergeEO.LAST_UPDATE_DATE AS "LastUpdateDate", PoLineLocationMergeEO.LAST_UPDATED_BY AS "LastUpdatedBy", PoLineLocationMergeEO.PO_HEADER_ID AS "PoHeaderId", PoLineLocationMergeEO.PO_LINE_ID AS "PoLineId", PoLineLocationMergeEO.LAST_UPDATE_LOGIN AS "LastUpdateLogin", PoLineLocationMergeEO.CREATION_DATE AS "CreationDate", PoLineLocationMergeEO.CREATED_BY AS "CreatedBy", PoLineLocationMergeEO.QUANTITY AS "Quantity", PoLineLocationMergeEO.QUANTITY_RECEIVED AS "QuantityReceived", PoLineLocationMergeEO.QUANTITY_ACCEPTED AS "QuantityAccepted", PoLineLocationMergeEO.QUANTITY_REJECTED AS "QuantityRejected", PoLineLocationMergeEO.QUANTITY_BILLED AS "QuantityBilled", PoLineLocationMergeEO.QUANTITY_CANCELLED AS "QuantityCancelled", PoLineLocationMergeEO.UNIT_MEAS_LOOKUP_CODE AS "UnitMeasLookupCode", PoLineLocationMergeEO.PO_RELEASE_ID AS "PoReleaseId", PoLineLocationMergeEO.SHIP_TO_LOCATION_ID AS "ShipToLocationId", PoLineLocationMergeEO.SHIP_VIA_LOOKUP_CODE AS "ShipViaLookupCode", PoLineLocationMergeEO.NEED_BY_DATE AS "NeedByDate", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE_CATEGORY AS "GlobalAttributeCategory", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE1 AS "GlobalAttribute1", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE2 AS "GlobalAttribute2", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE3 AS "GlobalAttribute3", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE4 AS "GlobalAttribute4", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE5 AS "GlobalAttribute5", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE6 AS "GlobalAttribute6", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE7 AS "GlobalAttribute7", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE8 AS "GlobalAttribute8", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE9 AS "GlobalAttribute9", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE10 AS "GlobalAttribute10", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE11 AS "GlobalAttribute11", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE12 AS "GlobalAttribute12", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE13 AS "GlobalAttribute13", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE14 AS "Global Attribute14", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE15 AS "GlobalAttribute15", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE16 AS "GlobalAttribute16", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE17 AS "GlobalAttribute17", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE18 AS "GlobalAttribute18", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE19 AS "GlobalAttribute19", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE20 AS "GlobalAttribute20", PoLineLocationMergeEO.QUANTITY_SHIPPED AS "QuantityShipped", PoLineLocationMergeEO.COUNTRY_OF_ORIGIN_CODE AS "CountryOfOriginCode", PoLineLocationMergeEO.TAX_USER_OVERRIDE_FLAG AS "TaxUserOverrideFlag", PoLineLocationMergeEO.MATCH_OPTION AS "MatchOption", PoLineLocationMergeEO.TAX_CODE_ID AS "TaxCodeId", PoLineLocationMergeEO.CALCULATE_TAX_FLAG AS "CalculateTaxFlag", PoLineLocationMergeEO.CHANGE_PROMISED_DATE_REASON AS "ChangePromisedDateReason", PoLineLocationMergeEO.NOTE_TO_RECEIVER AS "NoteToReceiver", PoLineLocationMergeEO.SECONDARY_UNIT_OF_MEASURE AS "SecondaryUnitOfMeasure", PoLineLocationMergeEO.SECONDARY_QUANTITY AS "SecondaryQuantity", PoLineLocationMergeEO.PREFERRED_GRADE AS "PreferredGrade", PoLineLocationMergeEO.SECONDARY_QUANTITY_RECEIVED AS "SecondaryQuantityReceived", PoLineLocationMergeEO.SECONDARY_QUANTITY_ACCEPTED AS "SecondaryQuantityAccepted", PoLineLocationMergeEO.SECONDARY_QUANTITY_REJECTED AS "SecondaryQuantityRejected", PoLineLocationMergeEO.SECONDARY_QUANTITY_CANCELLED AS "SecondaryQuantityCancelled", PoLineLocationMergeEO.VMI_FLAG AS "VmiFlag", PoLineLocationMergeEO.CONSIGNED_FLAG AS "ConsignedFlag", PoLineLocationMergeEO.RETROACTIVE_DATE AS "RetroactiveDate", PoLineLocationMergeEO.SUPPLIER_ORDER_LINE_NUMBER AS "SupplierOrderLineNumber", PoLineLocationMergeEO.AMOUNT AS "Amount", PoLineLocationMergeEO.AMOUNT_RECEIVED AS "AmountReceived", PoLineLocationMergeEO.AMOUNT_BILLED AS "AmountBilled", PoLineLocationMergeEO.AMOUNT_CANCELLED AS "AmountCancelled", PoLineLocationMergeEO.AMOUNT_ACCEPTED AS "AmountAccepted", PoLineLocationMergeEO.AMOUNT_REJECTED AS "AmountRejected", PoLineLocationMergeEO.DROP_SHIP_FLAG AS "DropShipFlag", PoLineLocationMergeEO.SALES_ORDER_UPDATE_DATE AS "SalesOrderUpdateDate", PoLineLocationMergeEO.TRANSACTION_FLOW_HEADER_ID AS "TransactionFlowHeaderId", PoLineLocationMergeEO.FINAL_MATCH_FLAG AS "FinalMatchFlag", PoLineLocationMergeEO.MANUAL_PRICE_CHANGE_FLAG AS "ManualPriceChangeFlag", PoLineLocationMergeEO.SHIPMENT_CLOSED_DATE AS "ShipmentClosedDate", PoLineLocationMergeEO.CLOSED_FOR_RECEIVING_DATE AS "ClosedForReceivingDate", PoLineLocationMergeEO.CLOSED_FOR_INVOICE_DATE AS "ClosedForInvoiceDate", PoLineLocationMergeEO.SECONDARY_QUANTITY_SHIPPED AS "SecondaryQuantityShipped", PoLineLocationMergeEO.PAYMENT_TYPE AS "PaymentType", PoLineLocationMergeEO.DESCRIPTION AS "Description", PoLineLocationMergeEO.VALUE_BASIS AS "ValueBasis", PoLineLocationMergeEO.MATCHING_BASIS AS "MatchingBasis", PoLineLocationMergeEO.WORK_APPROVER_ID AS "WorkApproverId", PoLineLocationMergeEO.BID_PAYMENT_ID AS "BidPaymentId", PoLineLocationMergeEO.QUANTITY_FINANCED AS "QuantityFinanced", PoLineLocationMergeEO.AMOUNT_FINANCED AS "AmountFinanced", PoLineLocationMergeEO.QUANTITY_RECOUPED AS "QuantityRecouped", PoLineLocationMergeEO.AMOUNT_RECOUPED AS "AmountRecouped", PoLineLocationMergeEO.RETAINAGE_WITHHELD_AMOUNT AS "RetainageWithheldAmount", PoLineLocationMergeEO.RETAINAGE_RELEASED_AMOUNT AS "RetainageReleasedAmount", PoLineLocationMergeEO.AMOUNT_ SHIPPED AS "AmountShipped", PoLineLocationMergeEO.TAX_ATTRIBUTE_UPDATE_CODE AS "TaxAttributeUpdateCode", PoLineLocationMergeEO.OUTSOURCED_ASSEMBLY AS "OutsourcedAssembly", PoLineLocationMergeEO.TAX_NAME AS "TaxName" FROM PO_LINE_LOCATIONS_MERGE_V PoLineLocationMergeEO WHERE PoLineLocationMergeEO.LINE_LOCATION_ID = :1
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;
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
b5ku28kvsxwuk 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(:"SYS_B_000") 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 ( :"SYS_B_001", :"SYS_B_002", :"SYS_B_003", :"SYS_B_004", :"SYS_B_005", :"SYS_B_006", :"SYS_B_007", :"SYS_B_008", :"SYS_B_009", :"SYS_B_010", :"SYS_B_011", :"SYS_B_012", :"SYS_B_013", :"SYS_B_014", :"SYS_B_015", :"SYS_B_016", :"SYS_B_017", :"SYS_B_018", :"SYS_B_019", :"SYS_B_020", -- <Complex Work R12> :"SYS_B_021", :"SYS_B_022", :"SYS_B_023", :"SYS_B_024", :"SYS_B_025", :"SYS_B_026", :"SYS_B_027", :"SYS_B_028", :"SYS_B_029", :"SYS_B_030", :"SYS_B_031", :"SYS_B_032", :"SYS_B_033", :"SYS_B_034", :"SYS_B_035", :"SYS_B_036", :"SYS_B_037", :"SYS_B_038", :"SYS_B_039", :"SYS_B_040", :"SYS_B_041", -- <Complex Work R12> :"SYS_B_042", -- <Complex Work R12> :"SYS_B_043", -- <Complex Work R12> :"SYS_B_044", -- <Complex Work R12> :"SYS_B_045", -- <Complex Work R12> :"SYS_B_046", :"SYS_B_047", :"SYS_B_048", :"SYS_B_049", :"SYS_B_050", :"SYS_B_051", :"SYS_B_052", :"SYS_B_053", :"SYS_B_054", :"SYS_B_055", :"SYS_B_056", :"SYS_B_057", :"SYS_B_058", :"SYS_B_059", :"SYS_B_060", :"SYS_B_061", :"SYS_B_062", :"SYS_B_063", :"SYS_B_064", :"SYS_B_065", :"SYS_B_066", :"SYS_B_067", :"SYS_B_068", :"SYS_B_069", :"SYS_B_070", :"SYS_B_071", :"SYS_B_072", :"SYS_B_073", :"SYS_B_074", :"SYS_B_075", :"SYS_B_076", :"SYS_B_077", :"SYS_B_078", :"SYS_B_079", :"SYS_B_080", :"SYS_B_081", :"SYS_B_082", :"SYS_B_083", :"SYS_B_084", :"SYS_B_085", :"SYS_B_086", :"SYS_B_087", :"SYS_B_088", :"SYS_B_089", :"SYS_B_090", :"SYS_B_091", :"SYS_B_092", :"SYS_B_093", :"SYS_B_094", :"SYS_B_095", :"SYS_B_096", :"SYS_B_097", :"SYS_B_098", :"SYS_B_099", :"SYS_B_100", :"SYS_B_101", :"SYS_B_102", :"SYS_B_103", :"SYS_B_104", :"SYS_B_105", :"SYS_B_106", :"SYS_B_107", :"SYS_B_108", :"SYS_B_109", :"SYS_B_110", :"SYS_B_111", :"SYS_B_112", :"SYS_B_113", --<Bug#: 4899200> :"SYS_B_114", --<Bug#: 4899200> :"SYS_B_115", --<Bug#: 4899200> :"SYS_B_116", --<Bug#: 5464968> : "SYS_B_117", --Enhanced Pricing :"SYS_B_118", --Enhanced Pricing :"SYS_B_119", --Enhanced Pricing :"SYS_B_120", --Enhanced Pricing :"SYS_B_121", --Enhanced Pricing :"SYS_B_122", --Enhanced Pricing :"SYS_B_123", --Enhanced Pricing :"SYS_B_124", --Enhanced Pricing :"SYS_B_125" --<Bug#: 5464968> ) AND application_id = :"SYS_B_126" AND language_code = :"SYS_B_127") AS message, CURSOR( SELECT fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE ((entity_name = :"SYS_B_128" AND pk1_value = to_char(phx.po_header_id)) OR (entity_name = :"SYS_B_129" AND pk1_value = to_char(phx.vendor_id)) OR (entity_name = :"SYS_B_130" AND pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354 function_name = :"SYS_B_131" AND fad.media_id = fds.media_id AND fad.datatype_id=:"SYS_B_132" 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=:"SYS_B_133" AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name=:"SYS_B_134" AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name=:"SYS_B_135" AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=:"SYS_B_136" AND fad.function_name=:"SYS_B_137" 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=:"SYS_B_138" AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name=:"SYS_B_139" AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name=:"SYS_B_140" AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=:"SYS_B_141" AND fad.function_name=:"SYS_B_142" 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=:"SYS_B_143" AND entity_id = plx.po_line_id and enabled_flag=:"SYS_B_144") 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=:"SYS_B_145" AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name=:"SYS_B_146" 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=:"SYS_B_147" AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_148" AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_149" AND fad.pk1_value=to_char(plx.CONTRACT_ID) AND plx.CONTRACT_ID IS NOT NULL) ) AND function_name = :"SYS_B_150" AND fad.media_id = fds.media_id AND fad.datatype_id=:"SYS_B_151" 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=:"SYS_B_152" AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name=:"S YS_B_153" AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_154" AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_155" AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_156" 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=:"SYS_B_157" AND fad.function_name=:"SYS_B_158" 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=:"SYS_B_159" AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name=:"SYS_B_160" AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_161" AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_162" AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_163" 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=:"SYS_B_164" AND fad.function_name=:"SYS_B_165" 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 = :"SYS_B_166" AND pk1_value = to_char(pllx.line_location_id) AND function_name = :"SYS_B_167" AND fad.media_id = fds.media_id AND fad.datatype_id=:"SYS_B_168" 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=:"SYS_B_169" AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=:"SYS_B_170" AND fad.function_name=:"SYS_B_171" 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=:"SYS_B_172" AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=:"SYS_B_173" AND fad.function_name=:"SYS_B_174" 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, :"SYS_B_175") NOT IN (:"SYS_B_176", :"SYS_B_177") ) 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()
bbugagurwv1vy(SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 ))
bf7uwg5pa3pj6begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
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;
cd02js3xuc27n SELECT PoLineMergeEO.DRAFT_ID AS "DraftId", PoLineMergeEO.CHANGE_ACCEPTED_FLAG AS "ChangeAcceptedFlag", PoLineMergeEO.DELETE_FLAG AS "DeleteFlag", PoLineMergeEO.ATTRIBUTE9 AS "Attribute9", PoLineMergeEO.ATTRIBUTE10 AS "Attribute10", PoLineMergeEO.REFERENCE_NUM AS "ReferenceNum", PoLineMergeEO.ATTRIBUTE11 AS "Attribute11", PoLineMergeEO.ATTRIBUTE12 AS "Attribute12", PoLineMergeEO.ATTRIBUTE13 AS "Attribute13", PoLineMergeEO.ATTRIBUTE14 AS "Attribute14", PoLineMergeEO.ATTRIBUTE15 AS "Attribute15", PoLineMergeEO.MIN_RELEASE_AMOUNT AS "MinReleaseAmount", PoLineMergeEO.PRICE_TYPE_LOOKUP_CODE AS "PriceTypeLookupCode", PoLineMergeEO.CLOSED_CODE AS "ClosedCode", PoLineMergeEO.PRICE_BREAK_LOOKUP_CODE AS "PriceBreakLookupCode", PoLineMergeEO.USSGL_TRANSACTION_CODE AS "UssglTransactionCode", PoLineMergeEO.GOVERNMENT_CONTEXT AS "GovernmentContext", PoLineMergeEO.REQUEST_ID AS "RequestId", PoLineMergeEO.PROGRAM_APPLICATION_ID AS "ProgramApplicationId", PoLineMergeEO.PROGRAM_ID AS "ProgramId", PoLineMergeEO.PROGRAM_UPDATE_DATE AS "ProgramUpdateDate", PoLineMergeEO.CLOSED_DATE AS "ClosedDate", PoLineMergeEO.CLOSED_REASON AS "ClosedReason", PoLineMergeEO.CLOSED_BY AS "ClosedBy", PoLineMergeEO.TRANSACTION_REASON_CODE AS "TransactionReasonCode", PoLineMergeEO.ORG_ID AS "OrgId", PoLineMergeEO.HAZARD_CLASS_ID AS "HazardClassId", PoLineMergeEO.NOTE_TO_VENDOR AS "NoteToVendor", PoLineMergeEO.FROM_HEADER_ID AS "FromHeaderId", PoLineMergeEO.FROM_LINE_ID AS "FromLineId", PoLineMergeEO.MIN_ORDER_QUANTITY AS "MinOrderQuantity", PoLineMergeEO.MAX_ORDER_QUANTITY AS "MaxOrderQuantity", PoLineMergeEO.QTY_RCV_TOLERANCE AS "QtyRcvTolerance", PoLineMergeEO.OVER_TOLERANCE_ERROR_FLAG AS "OverToleranceErrorFlag", PoLineMergeEO.MARKET_PRICE AS "MarketPrice", PoLineMergeEO.UNORDERED_FLAG AS "UnorderedFlag", PoLineMergeEO.CLOSED_FLAG AS "ClosedFlag", PoLineMergeEO.USER_HOLD_FLAG AS "UserHoldFlag", PoLineMergeEO.CANCEL_FLAG AS "CancelFlag", PoLineMergeEO.CANCELLED_BY AS "CancelledBy", PoLineMergeEO.CANCEL_DATE AS "CancelDate", PoLineMergeEO.CANCEL_REASON AS "CancelReason", PoLineMergeEO.FIRM_STATUS_LOOKUP_CODE AS "FirmStatusLookupCode", PoLineMergeEO.FIRM_DATE AS "FirmDate", PoLineMergeEO.VENDOR_PRODUCT_NUM AS "VendorProductNum", PoLineMergeEO.CONTRACT_NUM AS "ContractNum", PoLineMergeEO.TAXABLE_FLAG AS "TaxableFlag", PoLineMergeEO.TYPE_1099 AS "Type1099", PoLineMergeEO.CAPITAL_EXPENSE_FLAG AS "CapitalExpenseFlag", PoLineMergeEO.NEGOTIATED_BY_PREPARER_FLAG AS "NegotiatedByPreparerFlag", PoLineMergeEO.ATTRIBUTE_CATEGORY AS "AttributeCategory", PoLineMergeEO.ATTRIBUTE1 AS "Attribute1", PoLineMergeEO.ATTRIBUTE2 AS "Attribute2", PoLineMergeEO.ATTRIBUTE3 AS "Attribute3", PoLineMergeEO.ATTRIBUTE4 AS "Attribute4", PoLineMergeEO.ATTRIBUTE5 AS "Attribute5", PoLineMergeEO.ATTRIBUTE6 AS "Attribute6", PoLineMergeEO.ATTRIBUTE7 AS "Attribute7", PoLineMergeEO.ATTRIBUTE8 AS "Attribute8", PoLineMergeEO.QC_GRADE AS "QcGrade", PoLineMergeEO.BASE_UOM AS "BaseUom", PoLineMergeEO.BASE_QTY AS "BaseQty", PoLineMergeEO.SECONDARY_UOM AS "SecondaryUom", PoLineMergeEO.SECONDARY_QTY AS "SecondaryQty", PoLineMergeEO.PO_LINE_ID AS "PoLineId", PoLineMergeEO.LAST_UPDATE_DATE AS "LastUpdateDate", PoLineMergeEO.LAST_UPDATED_BY AS "LastUpdatedBy", PoLineMergeEO.PO_HEADER_ID AS "PoHeaderId", PoLineMergeEO.LINE_TYPE_ID AS "LineTypeId", PoLineMergeEO.LINE_NUM AS "LineNum", PoLineMergeEO.LAST_UPDATE_LOGIN AS "LastUpdateLogin", PoLineMergeEO.CREATION_DATE AS "CreationDate", PoLineMergeEO.CREATED_BY AS "CreatedBy", PoLineMergeEO.ITEM_ID AS "ItemId", PoLineMergeEO.ITEM_REVISION AS "ItemRevision", PoLineMergeEO.CATEGORY_ID AS "CategoryId", PoLineMergeEO.ITEM_DESCRIPTION AS "ItemDescription", PoLineMergeEO.UNIT_MEAS_LOOKUP_CODE AS "UnitMeasLookupCode", PoLineMergeEO.QUANTITY_COMMITTED AS "QuantityCommitted", PoLineMergeEO.COMMITTED_AMOUNT AS "CommittedAmount", PoLineMergeEO.ALLOW_PRICE_OVERRIDE_FLAG AS "AllowPriceOverrideFlag", PoLineMergeEO.NOT_TO_EXCEED_PRICE AS "NotToExceedPrice", PoLineMergeEO.LIST_PRICE_PER_UNIT AS "ListPricePerUnit", PoLineMergeEO.UNIT_PRICE AS "UnitPrice", PoLineMergeEO.QUANTITY AS "Quantity", PoLineMergeEO.UN_NUMBER_ID AS "UnNumberId", PoLineMergeEO.GLOBAL_ATTRIBUTE_CATEGORY AS "GlobalAttributeCategory", PoLineMergeEO.GLOBAL_ATTRIBUTE1 AS "GlobalAttribute1", PoLineMergeEO.GLOBAL_ATTRIBUTE2 AS "GlobalAttribute2", PoLineMergeEO.GLOBAL_ATTRIBUTE3 AS "GlobalAttribute3", PoLineMergeEO.GLOBAL_ATTRIBUTE4 AS "GlobalAttribute4", PoLineMergeEO.GLOBAL_ATTRIBUTE5 AS "GlobalAttribute5", PoLineMergeEO.GLOBAL_ATTRIBUTE6 AS "GlobalAttribute6", PoLineMergeEO.GLOBAL_ATTRIBUTE7 AS "GlobalAttribute7", PoLineMergeEO.GLOBAL_ATTRIBUTE8 AS "GlobalAttribute8", PoLineMergeEO.GLOBAL_ATTRIBUTE9 AS "GlobalAttribute9", PoLineMergeEO.GLOBAL_ATTRIBUTE10 AS "GlobalAttribute10", PoLineMergeEO.GLOBAL_ATTRIBUTE11 AS "GlobalAttribute11", PoLineMergeEO.GLOBAL_ATTRIBUTE12 AS "GlobalAttribute12", PoLineMergeEO.GLOBAL_ATTRIBUTE13 AS "GlobalAttribute13", PoLineMergeEO.GLOBAL_ATTRIBUTE14 AS "GlobalAttribute14", PoLineMergeEO.GLOBAL_ATTRIBUTE15 AS "GlobalAttribute15", PoLineMergeEO.GLOBAL_ATTRIBUTE16 AS "GlobalAttribute16", PoLineMergeEO.GLOBAL_ATTRIBUTE17 AS "GlobalAttribute17", PoLineMergeEO.GLOBAL_ATTRIBUTE18 AS "GlobalAttribute18", PoLineMergeEO.GLOBAL_ATTRIBUTE19 AS "GlobalAttribute19", PoLineMergeEO.GLOBAL_ATTRIBUTE20 AS "GlobalAttribute20", PoLineMergeEO.LINE_REFERENCE_NUM AS "LineReferenceNum", PoLineMergeEO.PROJECT_ID AS "ProjectId", PoLineMergeEO.TASK_ID AS "TaskId", PoLineMergeEO.EXPIRATION_DATE AS "ExpirationDate", PoLineMergeEO.TAX_CODE_ID AS "TaxCodeId", PoLineMergeEO.OKE_CONTRACT_HEADER_ID AS "OkeContractHeaderId", PoLineMergeEO.OKE_CONTRACT_VERSION_ID AS "OkeContractVersionId", PoLineMergeEO.TAX_NAME AS "TaxName", PoLineMergeEO.SECONDARY_UNIT_OF_MEASURE AS "SecondaryUnitOfMeasure", PoLineMergeEO.SECONDARY_QUANTITY AS "SecondaryQuantity", PoLineMergeEO.PREFERRED_GRADE AS "PreferredGrade", PoLineMergeEO.AUCTION_HEADER_ID AS "AuctionHeaderId", PoLineMergeEO.AUCTION_DISPLAY_NUMBER AS "AuctionDisplayNumber", PoLineMergeEO.AUCTION_LINE_NUMBER AS "AuctionLineNumber", PoLineMergeEO.BID_NUMBER AS "BidNumber", PoLineMergeEO.BID_LINE_NUMBER AS "BidLineNumber", PoLineMergeEO.RETROACTIVE_DATE AS "RetroactiveDate", PoLineMergeEO.SUPPLIER_REF_NUMBER AS "SupplierRefNumber", PoLineMergeEO.CONTRACT_ID AS "ContractId", PoLineMergeEO.JOB_ID AS "JobId", PoLineMergeEO.AMOUNT AS "Amount", PoLineMergeEO.START_DATE AS "StartDate", PoLineMergeEO.CONTRACTOR_FIRST_NAME AS "ContractorFirstName", PoLineMergeEO.CONTRACTOR_LAST_NAME AS "ContractorLastName ", PoLineMergeEO.ORDER_TYPE_LOOKUP_CODE AS "OrderTypeLookupCode", PoLineMergeEO.PURCHASE_BASIS AS "PurchaseBasis", PoLineMergeEO.MATCHING_BASIS AS "MatchingBasis", PoLineMergeEO.SVC_AMOUNT_NOTIF_SENT AS "SvcAmountNotifSent", PoLineMergeEO.SVC_COMPLETION_NOTIF_SENT AS "SvcCompletionNotifSent", PoLineMergeEO.FROM_LINE_LOCATION_ID AS "FromLineLocationId", PoLineMergeEO.BASE_UNIT_PRICE AS "BaseUnitPrice", PoLineMergeEO.MANUAL_PRICE_CHANGE_FLAG AS "ManualPriceChangeFlag", PoLineMergeEO.RETAINAGE_RATE AS "RetainageRate", PoLineMergeEO.MAX_RETAINAGE_AMOUNT AS "MaxRetainageAmount", PoLineMergeEO.PROGRESS_PAYMENT_RATE AS "ProgressPaymentRate", PoLineMergeEO.RECOUPMENT_RATE AS "RecoupmentRate", PoLineMergeEO.SUPPLIER_PART_AUXID AS "SupplierPartAuxid", PoLineMergeEO.IP_CATEGORY_ID AS "IpCategoryId", PoLineMergeEO.TAX_ATTRIBUTE_UPDATE_CODE AS "TaxAttributeUpdateCode", PoLineMergeEO.CATALOG_NAME AS "CatalogName" FROM PO_LINES_MERGE_V PoLineMergeEO WHERE PoLineMergeEO.PO_LINE_ID = :1
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;
d3pkzg7h1v8uq SELECT * FROM (SELECT POH.ACCEPTANCE_DUE_DATE ACKNOWLEDGE_BY, NVL(POH.ACCEPTANCE_REQUIRED_FLAG, :"SYS_B_00") ACCEPTANCE_REQUIRED_FLAG, DECODE(POH.APPROVED_FLAG, :"SYS_B_01", POH.APPROVED_DATE, NULL) APPROVED_DATE, POH.BILL_TO_LOCATION_ID, POH.AGENT_ID, NVL(POH.CANCEL_FLAG, :"SYS_B_02") HEADER_CANCEL_FLAG, POH.CLOSED_DATE, NVL(POH.CLOSED_CODE, :"SYS_B_03") HEADER_CLOSED_CODE, POH.CONFIRMING_ORDER_FLAG, POH.CONSIGNED_CONSUMPTION_FLAG, NVL(POH.CONTERMS_EXIST_FLAG, :"SYS_B_04") CONTERMS_EXIST_FLAG, POH.CURRENCY_CODE CURRENCY_CODE, POH.COMMENTS DESCRIPTION, NVL(POH.FIRM_STATUS_LOOKUP_CODE, :"SYS_B_05") FIRM_STATUS_LOOKUP_CODE, POH.FIRM_DATE, POH.FOB_LOOKUP_CODE, POH.FREIGHT_TERMS_LOOKUP_CODE, NVL(POH.FROZEN_FLAG, :"SYS_B_06") FROZEN_FLAG, POH.NOTE_TO_RECEIVER, POH.NOTE_TO_VENDOR, POH.SEGMENT1 PO_NUM, NVL(POH.USER_HOLD_FLAG, :"SYS_B_07") USER_HOLD_FLAG, POH.ORG_ID, POH.CREATION_DATE HEADER_CREATION_DATE, POH.PCARD_ID, POH.PAY_ON_CODE, POH.PRINT_COUNT, POH.PRINTED_DATE, POH.RATE RATE, POH.RATE_DATE, POH.RATE_TYPE RATE_TYPE, POH.REVISED_DATE, POH.REVISION_NUM, POH.SHIP_VIA_LOOKUP_CODE, POH.VENDOR_ID, POH.VENDOR_CONTACT_ID, POH.VENDOR_SITE_ID, POH.TERMS_ID, POH.SHIPPING_CONTROL, POH.TYPE_LOOKUP_CODE, DECODE(POH.XML_CHANGE_SEND_DATE, NULL, POH.XML_SEND_DATE, POH.XML_CHANGE_SEND_DATE) XML_SEND_DATE, POH.BLANKET_TOTAL_AMOUNT, POH.START_DATE EFFECTIVE_FROM, POH.END_DATE EFFECTIVE_TO, POH.GLOBAL_AGREEMENT_FLAG, POH.AMOUNT_LIMIT, POH.PRICE_UPDATE_TOLERANCE, POH.STYLE_ID, NVL(POH.ENCUMBRANCE_REQUIRED_FLAG, :"SYS_B_08") ENCUMBRANCE_REQUIRED_FLAG, POH.CHANGE_REQUESTED_BY, POH.ATTRIBUTE1, POH.ATTRIBUTE2, POH.ATTRIBUTE3, POH.ATTRIBUTE4, POH.ATTRIBUTE5, POH.ATTRIBUTE6, POH.ATTRIBUTE7, POH.ATTRIBUTE8, POH.ATTRIBUTE9, POH.ATTRIBUTE10, POH.ATTRIBUTE11, POH.ATTRIBUTE12, POH.ATTRIBUTE13, POH.ATTRIBUTE14, POH.ATTRIBUTE15, POH.PO_HEADER_ID, NVL(POH.AUTHORIZATION_STATUS, :"SYS_B_09") AUTHORIZATION_STATUS, NVL(POH.SUPPLIER_AUTH_ENABLED_FLAG, :"SYS_B_10") SUPPLIER_AUTH_ENABLED_FLAG, PDTL.TYPE_NAME DOC_TYPE_NAME, PDTL.DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE, AT.NAME TERMS_NAME, HRL2.LOCATION_CODE BILL_TO_LOCATION, V.VENDOR_NAME SUPPLIER, VS.VENDOR_SITE_CODE SUPPLIER_SITE, POD.AMOUNT_TO_ENCUMBER, POD.BUDGET_ACCOUNT_ID, POD.ENCUMBERED_FLAG, POD.ENCUMBERED_AMOUNT, POD.GL_ENCUMBERED_DATE, POD.GL_ENCUMBERED_PERIOD_NAME ENCUMBERED_PERIOD, POD.UNENCUMBERED_AMOUNT BLANKET_UNENCUMBERED_AMOUNT, POAH.ACTION_DATE CANCELED_DATE, POAH.EMPLOYEE_ID CANCELED_BY_ID, NVL(PO_MOAC_UTILS_PVT.GET_OU_SHORTCODE(POH.ORG_ID), PO_MOAC_UTILS_PVT.GET_OU_NAME(POH.ORG_ID)) OPERATING_UNIT, POH.ATTRIBUTE_CATEGORY, PDSLVL.DISPLAY_NAME DOC_STYLE, PDT.SECURITY_LEVEL_CODE, PDT.ACCESS_LEVEL_CODE, NVL(POH.PENDING_SIGNATURE_FLAG, :"SYS_B_11") PENDING_SIGNATURE_FLAG, POH.LOCK_OWNER_ROLE, POD.PO_DISTRIBUTION_ID, POH.SUPPLIER_NOTIF_METHOD, POH.FAX, POH.EMAIL_ADDRESS, -- Bug 5468465 NVL(POH.CAT_ADMIN_AUTH_ENABLED_FLAG, :"SYS_B_12") CAT_ADMIN_AUTH_ENABLED_FLAG FROM PO_DOCUMENT_TYPES_ALL_B PDT, PO_DOCUMENT_TYPES_ALL_TL PDTL, PO_VENDORS V, PO_VENDOR_SITES_ALL VS, PO_VENDOR_CONTACTS VC, AP_TERMS AT, HR_LOCATIONS_ALL_TL HRL2, PO_HEADERS_ALL POH, PO_DISTRIBUTIONS_ALL POD, PO_ACTION_HISTORY POAH, PO_DOC_STYLE_LINES_VL PDSLVL WHERE PDT.DOCUMENT_TYPE_CODE = :1 AND PDT.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE AND PDT.DOCUMENT_TYPE_CODE = PDTL.DOCUMENT_TYPE_CODE AND PDT.DOCUMENT_SUBTYPE = PDTL.DOCUMENT_SUBTYPE AND PDTL.LANGUAGE = USERENV(:"SYS_B_13") AND PDT.ORG_ID = PDTL.ORG_ID AND PDT.ORG_ID = POH.ORG_ID AND V.VENDOR_ID (+) = POH.VENDOR_ID AND VS.VENDOR_SITE_ID (+) = POH.VENDOR_SITE_ID AND VC.VENDOR_CONTACT_ID (+) = POH.VENDOR_CONTACT_ID AND /* Bug 6241452 */ ( POH.VENDOR_CONTACT_ID IS NULL OR POH.VENDOR_SITE_ID=VC.VENDOR_SITE_ID ) AND AT.TERM_ID (+) = POH .TERMS_ID AND POH.PO_HEADER_ID = POD.PO_HEADER_ID (+) AND :"SYS_B_14" = POD.DISTRIBUTION_TYPE (+) AND POH.REVISION_NUM = POAH.OBJECT_REVISION_NUM (+) AND POH.PO_HEADER_ID = POAH.OBJECT_ID (+) AND POH.TYPE_LOOKUP_CODE = POAH.OBJECT_SUB_TYPE_CODE (+) AND :2 = POAH.OBJECT_TYPE_CODE (+) AND POAH.ACTION_CODE (+) = :"SYS_B_15" AND HRL2.LOCATION_ID (+) = POH.BILL_TO_LOCATION_ID AND HRL2.LANGUAGE (+) = USERENV(:"SYS_B_16") AND ( ( NVL(POH.GLOBAL_AGREEMENT_FLAG, :"SYS_B_17") = :"SYS_B_18" AND (PO_MOAC_UTILS_PVT.check_access(POH.ORG_ID) = :"SYS_B_19" OR EXISTS ( SELECT :"SYS_B_20" FROM PO_GA_ORG_ASSIGNMENTS POGA WHERE POH.PO_HEADER_ID = POGA.PO_HEADER_ID AND POGA.ENABLED_FLAG =:"SYS_B_21" AND (PO_MOAC_UTILS_PVT.check_access(POGA.ORGANIZATION_ID) = :"SYS_B_22" OR PO_MOAC_UTILS_PVT.check_access(POGA.PURCHASING_ORG_ID) = :"SYS_B_23" ) ) AND POH.AUTHORIZATION_STATUS = :"SYS_B_24" AND NVL(POH.CLOSED_CODE, :"SYS_B_25") <> :"SYS_B_26" AND NVL(POH.CANCEL_FLAG, :"SYS_B_27") = :"SYS_B_28" AND NVL(POH.FROZEN_FLAG, :"SYS_B_29") = :"SYS_B_30" AND ( TRUNC(SYSDATE) BETWEEN NVL(TRUNC(POH.START_DATE), TRUNC(SYSDATE) -:"SYS_B_31") AND NVL(TRUNC(POH.END_DATE), TRUNC(SYSDATE)+:"SYS_B_32") OR ( TRUNC(POH.START_DATE) IS NOT NULL AND TRUNC(SYSDATE) <= TRUNC(POH.START_DATE)) ) ) ) OR (NVL(GLOBAL_AGREEMENT_FLAG, :"SYS_B_33") = :"SYS_B_34" AND TYPE_LOOKUP_CODE = :"SYS_B_35" AND PO_MOAC_UTILS_PVT.CHECK_ACCESS (POH.ORG_ID ) = :"SYS_B_36") ) AND POH.STYLE_ID = PDSLVL.STYLE_ID (+) AND POH.TYPE_LOOKUP_CODE = PDSLVL.DOCUMENT_SUBTYPE (+) AND PDSLVL.ENABLED_FLAG (+) = :"SYS_B_37" AND (:3<> :"SYS_B_38" OR POH.CAT_ADMIN_AUTH_ENABLED_FLAG = :"SYS_B_39") AND (/** always allow access to the buyer of the document **/ (agent_id = :4) OR ( ( (access_level_code IS NULL OR access_level_code = :"SYS_B_40") OR /** If the access level is View Only, prevent Modify or Full access **/ (access_level_code = :"SYS_B_41" AND :5 NOT IN (:"SYS_B_42", :"SYS_B_43")) OR /** If the access level is Modify, prevent Full access **/ (access_level_code = :"SYS_B_44" AND :6 <> :"SYS_B_45")) AND ( (security_level_code = :"SYS_B_46") OR (security_level_code IN (:"SYS_B_47", :"SYS_B_48", :"SYS_B_49") AND EXISTS ( SELECT :"SYS_B_50" FROM PO_ACTION_HISTORY POAH WHERE POAH.employee_id = :7 AND POAH.object_type_code IN (:"SYS_B_51", :"SYS_B_52") AND POAH.object_id = POH.po_header_id) ) OR (security_level_code = :"SYS_B_53" AND EXISTS ( SELECT :"SYS_B_54" FROM po_agents poa WHERE poa.agent_id = :8 AND SYSDATE BETWEEN NVL(POA.start_date_active, SYSDATE) AND NVL(POA.end_date_active, SYSDATE + :"SYS_B_55")) ) OR (security_level_code = :"SYS_B_56" AND EXISTS ( SELECT :"SYS_B_57" /** use aliases to avoid clashes with the main query for the org_id column name **/ FROM (SELECT org_id poeh_org_id, position_structure_id, employee_id, superior_id FROM po_employee_hierarchies) poeh, (SELECT org_id psp_org_id, security_position_structure_id FROM po_system_parameters_all) psp WHERE poeh.superior_id = :9 AND psp.psp_org_id = POH.org_id AND poeh.employee_id = agent_id AND poeh.position_structure_id = NVL(psp.security_position_structure_id, -:"SYS_B_58") ) ) ) ) ) AND :"SYS_B_59" = Decode(Nvl(FND_PROFILE.Value(:"SYS_B_60"), :"SYS_B_61"), :"SYS_B_62", PA_PO_INTEGRATION_UTILS.PA_USER_PO_ACCESS_CHECK(poh.po_header_id, :10, :"SYS_B_63"), :"SYS_B_64")) QRSLT WHERE (AGENT_ID = :11 AND ( UPPER(AUTHORIZATION_STATUS) = UPPER(:12) AND (AUTHORIZATION_STATUS like :13 OR AUTHORIZATION_STATUS like :14 OR AUTHORIZATION_STATUS like :15 OR AUTHORIZATION_STATUS like :16))) ORDER BY header_creation_date DESC
dawf7hvg1ym94select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE = :3
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)
dtv3rtt90j9dySelect R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = :"SYS_B_00" And R.Status_Code = :"SYS_B_01" And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = :"SYS_B_02")) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = :"SYS_B_03" And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != :"SYS_B_04" OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((:"SYS_B_05", :"SYS_B_06"), (:"SYS_B_07", :"SYS_B_08"), (:"SYS_B_09", :"SYS_B_10"), (:"SYS_B_11", :"SYS_B_12"), (:"SYS_B_13", :"SYS_B_14"))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((:"SYS_B_15", :"SYS_B_16"), (:"SYS_B_17", :"SYS_B_18"), (:"SYS_B_19", :"SYS_B_20"), (:"SYS_B_21", :"SYS_B_22"), (:"SYS_B_23", :"SYS_B_24"), (:"SYS_B_25", :"SYS_B_26"), (:"SYS_B_27", :"SYS_B_28"), (:"SYS_B_29", :"SYS_B_30"), (:"SYS_B_31", :"SYS_B_32")))) ORDER BY NVL(R.priority, :"SYS_B_33"), R.Priority_Request_ID, R.Request_ID
du9txjm3qa2ywbegin PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK (:v1, :v2, :v3, :v4, :v5); end;
f2mg2y50g364uSELECT DEFAULT_TAXATION_COUNTRY , DOCUMENT_SUB_TYPE, TAX_INVOICE_DATE FROM ZX_LINES_DET_FACTORS WHERE APPLICATION_ID = :B4 AND ENTITY_CODE = :B3 AND EVENT_CLASS_CODE = :B2 AND TRX_ID = :B1 AND ROWNUM = 1
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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count10.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count50.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count30.000.00
Batched IO single block count00.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count20.000.00
Batched IO vector read count10.000.00
Block Cleanout Optim referenced4980.140.00
CCursor + sql area evicted00.000.00
CPU used by this session12,237,5383,391.793.92
CPU used when call started12,225,9223,388.573.91
CR blocks created61,893,94417,154.6719.81
Cached Commit SCN referenced429,981,318119,174.65137.65
Commit SCN cached1,055,156292.450.34
DB time20,433,5035,663.406.54
DBWR checkpoint buffers written1,540,763427.040.49
DBWR checkpoints00.000.00
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes3,4200.950.00
DBWR undo block writes946,667262.380.30
DFO trees parallelized00.000.00
Effective IO time29,353,2888,135.639.40
HSC Heap Segment Block Changes21,815,9456,046.566.98
Heap Segment Array Inserts42,79511.860.01
Heap Segment Array Updates30,0778.340.01
IMU CR rollbacks348,78496.670.11
IMU Flushes817,549226.590.26
IMU Redo allocation size1,509,281,404418,316.06483.17
IMU commits1,983,203549.670.63
IMU contention36,35110.080.01
IMU ktichg flush59,13916.390.02
IMU recursive-transaction flush5460.150.00
IMU undo allocation size5,588,616,6561,548,954.411,789.11
LOB table id lookup cache misses00.000.00
Number of read IOs issued82,99023.000.03
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Parallel operations downgraded 75 to 99 pct00.000.00
Requests to/from client66,516,99418,436.0121.29
RowCR - row contention114,33231.690.04
RowCR attempts108,445,62730,057.0534.72
RowCR hits110,122,05330,521.6935.25
SMON posted for undo segment shrink30.000.00
SQL*Net roundtrips to/from client66,521,50918,437.2621.30
active txn count during cleanout16,900,7484,684.255.41
application wait time9,8502.730.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts25,8157.150.01
branch node splits7390.200.00
buffer is not pinned count3,350,432,442928,613.901,072.59
buffer is pinned count13,782,194,4283,819,906.094,412.15
bytes received via SQL*Net from client5,527,698,7151,532,070.241,769.60
bytes sent via SQL*Net to client14,291,543,5513,961,078.514,575.21
calls to get snapshot scn: kcmgss220,166,25961,021.8170.48
calls to kcmgas67,023,57018,576.4121.46
calls to kcmgcs8,837,6302,449.462.83
cell physical IO interconnect bytes34,315,540,4809,510,977.5710,985.57
change write time60,38616.740.02
cleanout - number of ktugct calls13,806,5513,826.664.42
cleanouts and rollbacks - consistent read gets12,629,7533,500.494.04
cleanouts only - consistent read gets396,549109.910.13
cluster key scan block gets1,002,983277.990.32
cluster key scans672,451186.380.22
commit batch performed8,1182.250.00
commit batch requested8,1182.250.00
commit batch/immediate performed15,9844.430.01
commit batch/immediate requested15,9844.430.01
commit cleanout failures: block lost751,213208.210.24
commit cleanout failures: buffer being written1200.030.00
commit cleanout failures: callback failure52,32014.500.02
commit cleanout failures: cannot pin27,0787.510.01
commit cleanouts11,656,0823,230.633.73
commit cleanouts successfully completed10,825,3513,000.383.47
commit immediate performed7,8662.180.00
commit immediate requested7,8662.180.00
commit txn count during cleanout2,027,716562.010.65
concurrency wait time133,83637.090.04
consistent changes648,692,542179,793.18207.67
consistent gets3,860,839,7101,070,079.601,235.99
consistent gets - examination2,104,645,693583,328.65673.77
consistent gets direct185,33051.370.06
consistent gets from cache3,860,653,4491,070,027.981,235.93
consistent gets from cache (fastpath)1,471,086,523407,729.87470.94
cursor authentications270.010.00
data blocks consistent reads - undo records applied632,089,595175,191.47202.35
db block changes133,962,00237,129.2342.89
db block gets137,928,15438,228.5044.16
db block gets direct5880.160.00
db block gets from cache137,927,53338,228.3344.16
db block gets from cache (fastpath)27,640,6367,660.958.85
deferred (CURRENT) block cleanout applications2,242,039621.410.72
dirty buffers inspected1700.050.00
doubling up with imu segment00.000.00
enqueue conversions24,2566.720.01
enqueue releases10,355,0182,870.023.31
enqueue requests10,429,0152,890.533.34
enqueue timeouts77,06421.360.02
enqueue waits1,9730.550.00
exchange deadlocks1,4000.390.00
execute count236,206,00565,467.4275.62
failed probes on index block reclamation2990.080.00
file io service time14,562,7204,036.244.66
file io wait time1,957,721,749542,606.86626.73
free buffer inspected671,917186.230.22
free buffer requested66,076,04418,313.7921.15
heap block compress834,736231.360.27
hot buffers moved to head of LRU35,5699.860.01
immediate (CR) block cleanout applications13,026,2943,610.404.17
immediate (CURRENT) block cleanout applications1,134,809314.530.36
in call idle wait time24,541,8836,802.097.86
index crx upgrade (positioned)118,30932.790.04
index fetch by key1,308,855,984362,765.67419.01
index scans kdiixs1558,591,347154,820.52178.82
java call heap collected bytes40,934,48011,345.5013.10
java call heap collected count210,66558.390.07
java call heap gc count2890.080.00
java call heap live object count15,2704.230.00
java call heap live object count max15,2704.230.00
java call heap live size886,880245.810.28
java call heap live size max886,880245.810.28
java call heap object count219,30560.780.07
java call heap object count max219,30560.780.07
java call heap total size365,690,880101,355.76117.07
java call heap total size max365,690,880101,355.76117.07
java call heap used size40,447,60011,210.5512.95
java call heap used size max40,447,60011,210.5512.95
java session heap live object count00.000.00
java session heap live object count max00.000.00
java session heap live size83,841,02423,237.5826.84
java session heap live size max83,841,02423,237.5826.84
java session heap object count00.000.00
java session heap object count max00.000.00
java session heap used size83,841,02423,237.5826.84
java session heap used size max83,841,02423,237.5826.84
leaf node 90-10 splits9,7002.690.00
leaf node splits131,28636.390.04
lob reads309,30285.730.10
lob writes482,245133.660.15
lob writes unaligned482,245133.660.15
logical read bytes from cache32,756,353,482,7529,078,829,555.0310,486,425.67
logons cumulative58,09916.100.02
max cf enq hold time470.010.00
messages received2,415,627669.520.77
messages sent2,415,626669.520.77
min active SCN optimization applied on CR2,774,392768.960.89
no buffer to keep pinned count680.020.00
no work - consistent read gets1,465,324,816406,132.94469.10
non-idle wait count86,802,74124,058.4627.79
non-idle wait time549,262152.230.18
opened cursors cumulative210,651,46958,384.6767.44
parse count (describe)00.000.00
parse count (failures)6,6871.850.00
parse count (hard)6,7111.860.00
parse count (total)9,751,2632,702.683.12
parse time cpu156,93343.500.05
parse time elapsed162,81945.130.05
physical read IO requests99,84927.670.03
physical read bytes1,898,422,272526,171.27607.75
physical read total IO requests108,02529.940.03
physical read total bytes2,030,305,280562,724.28649.97
physical read total multi block requests00.000.00
physical reads231,74564.230.07
physical reads cache17,1804.760.01
physical reads cache prefetch3340.090.00
physical reads direct214,56159.470.07
physical reads direct (lob)214,55159.470.07
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup3330.090.00
physical write IO requests238,65366.150.08
physical write bytes12,659,351,5523,508,696.264,052.69
physical write total IO requests3,679,0761,019.701.18
physical write total bytes32,285,235,2008,948,253.2810,335.60
physical write total multi block requests73,31420.320.02
physical writes1,545,334428.310.49
physical writes direct5880.160.00
physical writes direct (lob)120.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache1,544,745428.150.49
physical writes non checkpoint1,212,073335.940.39
pinned buffers inspected5000.140.00
prefetch warmup blocks aged out before use510.010.00
process last non-idle time3,6071.000.00
queries parallelized00.000.00
recursive aborts on index block reclamation10.000.00
recursive calls399,174,853110,636.26127.79
recursive cpu usage5,416,4161,501.231.73
redo blocks checksummed by FG (exclusive)7,228,7582,003.542.31
redo blocks written38,162,64810,577.2512.22
redo entries65,369,32918,117.9220.93
redo ordering marks578,747160.410.19
redo size18,027,473,1604,996,537.735,771.21
redo size for direct writes2,0560.570.00
redo subscn max counts1,129,712313.110.36
redo synch long waits4,4221.230.00
redo synch time96,39526.720.03
redo synch time (usec)1,018,270,835282,226.39325.98
redo synch writes1,797,528498.210.58
redo wastage873,357,972242,061.99279.59
redo write time78,61321.790.03
redo writes2,172,599602.160.70
rollback changes - undo records applied2,542,928704.800.81
rollbacks only - consistent read gets49,334,68913,673.7215.79
root node splits250.010.00
rows fetched via callback1,039,109,023288,001.95332.65
session connect time00.000.00
session cursor cache hits89,001,38524,667.8428.49
session logical reads3,998,786,6401,108,313.301,280.15
shared hash latch upgrades - no wait226,070,75362,658.3172.37
shared hash latch upgrades - wait701,631194.470.22
sorts (memory)18,835,2105,220.416.03
sorts (rows)4,854,213,1521,345,405.371,554.00
sql area evicted00.000.00
sql area purged6,6881.850.00
summed dirty queue length7800.220.00
switch current to new buffer1,465,388406.150.47
table fetch by rowid8,353,120,2722,315,170.862,674.12
table fetch continued row369,728102.470.12
table scan blocks gotten510,434,713141,473.31163.41
table scan rows gotten15,339,863,4724,251,633.384,910.81
table scans (long tables)00.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)5,040,6891,397.091.61
total cf enq hold time9790.270.00
total number of cf enq holders1400.040.00
total number of times SMON posted3570.100.00
transaction rollbacks15,9414.420.01
transaction tables consistent read rollbacks560.020.00
transaction tables consistent reads - undo records applied9860.270.00
undo change vector size6,445,693,2841,786,503.822,063.49
user I/O wait time24,3216.740.01
user calls67,759,10818,780.2821.69
user commits2,737,631758.770.88
user rollbacks386,060107.000.12
workarea executions - optimal10,130,8772,807.903.24
write clones created in background3,5890.990.00
write clones created in foreground4730.130.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current3,1792,410
session uga memory max531,088,537,0321,077,576,836,680
session pga memory max49,261,413,71237,151,085,552
session cursor cache count4,187,0169,021,639
session uga memory2,003,248,338,4562,278,442,497,544
opened cursors current196,938146,289
workarea memory allocated362,231366,631
session pga memory39,635,611,48830,454,898,720

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)00.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)
LGWR0M0.000M18.2G951.355.160762171K0.03
DBWR0M0.000M11.8G66.103.342570 
Direct Reads1.6G22.99.4642470M0.000M0 
Others126M2.27.03492286M1.47.02383599380.23
Buffer Cache Reads134M4.67.0371390M0.000M16.8K5.68
Direct Writes0M0.000M0M0.000M0 
TOTAL:1.9G29.92.53630930G1018.928.527172197.8K0.08

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
Log File0M0.000M18.2G951.325.16076  
Data File1.8G27.62.50194111.8G65.083.336203.61 
Control File124M2.20.03436882M1.46.0227270.03 
Temp File2M0.10.00055431M1.04.0085920.16 
TOTAL:1.9G29.92.53686330G1018.908.528283.33 

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)
LGWR 0M0.000M18.2G951.325.160760 
LGWR (Log File) 0M0.000M18.2G951.325.160760 
DBWR 0M0.000M11.8G66.103.342300 
DBWR (Data File) 0M0.000M11.8G66.103.342300 
Direct Reads 1.6G22.98.4642470M0.000M0 
Direct Reads (Data File) 1.6G22.98.4642470M0.000M0 
Others 125M2.27.03464586M1.47.02383581840.05
Others (Control File) 123M2.20.03409082M1.46.02272779350.03
Others (Data File) 2M0.07.0005544M0.01.0011082490.40
Buffer Cache Reads 134M4.67.0371390M0.000M16.8K5.68
Buffer Cache Reads (Data File) 134M4.67.0371390M0.000M16.8K5.68
Direct Writes 0M0.000M0M0.000M0 
Direct Writes (Data File) 0M0.000M0M0.000M0 
TOTAL: 1.9G29.92.53603230G1018.898.5269025K3.83

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_DATA 93,344260.682.4168,10019112,4350.10
APPS_TS_TX_IDX 5,08217.091.0284,4022339,6030.07
APPS_UNDOTS1 000.000.0068,8391936,1460.05
TEMP1 37100.461.003,761177314.32
APPS_TS_QUEUES 7108.451.074,045160.00
APPS_TS_MEDIA 1906.321.003,007150.00
APPS_TS_ARCHIVE 4007.501.002,50812330.26
SYSAUX 62301.481.001,631030.00
APPS_TS_INTERFACE 000.000.001,28405253.85
APPS_TS_SUMMARY 32307.341.013550300.67
SYSTEM 705.711.004180440.00
APPS_TS_SEED 1707.651.003670160.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_TS_ARCHIVE/ebizdata/data/archive_01.dbf 4007.501.002,50812330.26
APPS_TS_INTERFACE/ebizdata/data/apps_ts_interface_01.dbf 00  1,28405253.85
APPS_TS_MEDIA/ebizdata/data/media_01.dbf 1906.321.003,007150.00
APPS_TS_QUEUES/ebizdata/data/queues_01.dbf 7108.451.074,045160.00
APPS_TS_SEED/ebizdata/data/reference_01.dbf 806.251.002080140.00
APPS_TS_SEED/ebizdata/data/reference_02.dbf 908.891.00159020.00
APPS_TS_SUMMARY/ebizdata/data/summary_01.dbf 32307.341.013550300.67
APPS_TS_TX_DATA/ebizdata/data/tx_data_01.dbf 15,11741.151.0023,546733,3110.04
APPS_TS_TX_DATA/ebizdata/data/tx_data_02.dbf 2,78715.811.011,456042111.62
APPS_TS_TX_DATA/ebizdata/data/tx_data_03.dbf 69,954190.262.8822,213636,8720.09
APPS_TS_TX_DATA/ebizdata/data/tx_data_04.dbf 5,48622.201.0120,885641,8310.05
APPS_TS_TX_IDX/ebizdata/data/tx_idx_01.dbf 1,36307.041.0222,286611,4390.06
APPS_TS_TX_IDX/ebizdata/data/tx_idx_02.dbf 1,02508.131.0219,30459,2510.06
APPS_TS_TX_IDX/ebizdata/data/tx_idx_03.dbf 1,68306.731.0120,982610,5260.08
APPS_TS_TX_IDX/ebizdata/data/tx_idx_04.dbf 1,01106.701.0321,83068,3870.09
APPS_UNDOTS1/ebizdata/data/undo_01.dbf 00  35,9331018,8260.05
APPS_UNDOTS1/ebizdata/data/undo_03.dbf 00  32,906917,3200.05
SYSAUX/ebizdata/data/sysaux_01.dbf 62301.481.001,631030.00
SYSTEM/ebizdata/data/sys_01.dbf 705.711.004180440.00
TEMP1/ebizdata/data/temp1_01.dbf 18700.531.001,985139311.32
TEMP1/ebizdata/data/temp1_02.dbf 18400.381.001,776038017.42

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
D7,702,3481003,956,183,64417,1871,545,41100189,884

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00001,541,2550

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
B024311128831668941242861515627969912428615   
E01434389615145791844398215627969918443982   

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.00704,1600

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)
B65,53628,16039,876.30792.951.99100.000.001,048,576
E65,53635,50829,930.57231.290.77100.000.001,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K9,671,6109,671,61000
64K128K91991900
128K256K14,12114,12100
256K512K11,50511,50500
512K1024K213,341213,34100
1M2M196,561196,56100
2M4M13913900
64M128M3,6583,65800

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
8,1920.13608,217.080.00100.0002,465,509,283
16,3840.25608,217.080.00100.0002,465,509,283
32,7680.50608,217.080.00100.0002,465,509,283
49,1520.75608,217.080.00100.0002,465,509,283
65,5361.00608,217.080.00100.0002,465,509,283
78,6431.20608,217.080.00100.0002,465,509,283
91,7501.40608,217.080.00100.0002,465,509,283
104,8581.60608,217.080.00100.0002,465,509,283
117,9651.80608,217.080.00100.0002,465,509,283
131,0722.00608,217.080.00100.0002,465,509,283
196,6083.00608,217.080.00100.0002,465,509,283
262,1444.00608,217.080.00100.0002,465,509,283

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)
3,8400.2355121,3206,781,2111.003,1511.00303,768
5,6320.3459623,8986,781,2161.003,1461.00303,769
7,4240.4559623,8986,781,2161.003,1461.00303,769
9,2160.5659623,8986,781,2161.003,1461.00303,769
11,0080.6759623,8986,781,2161.003,1461.00303,769
12,8000.7859623,8986,781,2161.003,1461.00303,769
13,8240.8459623,8986,781,2161.003,1461.00303,769
14,0800.8659623,8986,781,2161.003,1461.00303,769
14,3360.8859623,8986,781,2161.003,1461.00303,769
14,5920.8959623,8986,781,2161.003,1461.00303,769
14,8480.9159623,8986,781,2161.003,1461.00303,769
15,1040.9259623,8986,781,2161.003,1461.00303,769
15,3600.9459623,8986,781,2161.003,1461.00303,769
15,6160.9559623,8986,781,2161.003,1461.00303,769
15,8720.9759623,8986,781,2161.003,1461.00303,769
16,1280.9859623,8986,781,2161.003,1461.00303,769
16,3841.0059623,8986,781,2161.003,1461.00303,769
16,6401.0259623,8986,781,2161.003,1461.00303,769
16,8961.0359623,8986,781,2161.003,1461.00303,769
17,1521.0559623,8986,781,2161.003,1461.00303,769
17,4081.0659623,8986,781,2161.003,1461.00303,769
17,6641.0859623,8986,781,2161.003,1461.00303,769
17,9201.0959623,8986,781,2161.003,1461.00303,769
18,1761.1159623,8986,781,2161.003,1461.00303,769
18,4321.1359623,8986,781,2161.003,1461.00303,769
18,6881.1459623,8986,781,2161.003,1461.00303,769
19,9681.2259623,8986,781,2161.003,1461.00303,769
21,7601.3359623,8986,781,2161.003,1461.00303,769
23,5521.4459623,8986,781,2161.003,1461.00303,769
25,3441.5559623,8986,781,2161.003,1461.00303,769
27,1361.6659623,8986,781,2161.003,1461.00303,769
28,9281.7759623,8986,781,2161.003,1461.00303,769
30,7201.8859623,8986,781,2161.003,1461.00303,769
32,5121.9859623,8986,781,2161.003,1461.00303,769
34,3042.0959623,8986,781,2161.003,1461.00303,769

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
15,3600.19190,288 
20,4800.25190,288 
25,6000.31190,288 
30,7200.38190,288 
35,8400.44190,288 
40,9600.50190,289 
46,0800.56190,289 
51,2000.63190,290 
56,3200.69190,291 
61,4400.75190,294 
66,5600.81190,316 
71,6800.88190,316 
76,8000.94190,317 
81,9201.00190,287 
87,0401.06190,317 
92,1601.13190,318 
97,2801.19190,319 
102,4001.25190,319 
107,5201.31190,320 
112,6401.38190,321 
117,7601.44190,322 
122,8801.50190,322 
128,0001.56190,323 
133,1201.63190,324 
138,2401.69190,324 

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)
2560.500000
5121.000000
7681.500000
1,0242.000000
1,2802.500000
1,5363.000000
1,7923.500000
2,0484.000000
2,3044.500000
2,5605.000000
2,8165.500000
3,0726.000000
3,3286.500000
3,5847.000000
3,8407.500000
4,0968.000000
4,3528.500000
4,6089.000000
4,8649.500000
5,12010.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
1,7921.001139925,5101.003,1461.0066,053
2,0481.141139925,5101.003,1461.0066,053
2,3041.291139925,5101.003,1461.0066,053
2,5601.431139925,5101.003,1461.0066,053
2,8161.571139925,5101.003,1461.0066,053
3,0721.711139925,5101.003,1461.0066,053
3,3281.861139925,5101.003,1461.0066,053
3,5842.001139925,5101.003,1461.0066,053
3,8402.141139925,5101.003,1461.0066,053
4,0962.291139925,5101.003,1461.0066,053

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block152,625160
file header block7731114
undo block26,01110
undo header10,13110
1st level bmb22000
system undo header3700
segment header1200
2nd level bmb300
system undo block100

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 75,91647775,44035962172.91
TX-Transaction (index contention) 4,6214,62101,30411.07
PR-Process Startup 162162021552.50
US-Undo Segment 14414405502.91
SQ-Sequence Cache 4,7884,788015700.54
HW-Segment High Water Mark 714,793714,79205800.84
TX-Transaction 2,695,2972,697,3080700.86
TX-Transaction (allocate ITL entry) 858503000.17
FB-Format Block 14,69114,6910100.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
2946.972,850,9512,1843171202.8/2589.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
15-Sep 19:08157,173463,4771,6782751,2030/00/0/0/0/0/0
15-Sep 18:58160,461470,0471,7672891,3310/00/0/0/0/0/0
15-Sep 18:48158,708476,4991,8023031,5020/00/0/0/0/0/0
15-Sep 18:38160,238479,9051,7433171,7340/00/0/0/0/0/0
15-Sep 18:28156,858482,1562,1842772,0720/00/0/0/0/0/0
15-Sep 18:18153,534478,8671,5802842,5900/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 latch81,5470.00 00 
AQ deq log cmt cbk chunk latch32,2980.00 00 
AQ deq log statistics latch800.00 00 
AQ dequeue txn counter latch50,1521.570.0000 
AQ disk delete txn counter latch1020.00 00 
AQ ht cmt cbk chunk latch32,5420.00 00 
ASM db client latch2,5330.00 00 
ASM map operation hash table40.00 00 
ASM network state latch1,2630.00 00 
AWR Alerted Metric Element list215,0600.00 00 
Change Notification Hash table latch1,2100.00 00 
Consistent RBA2,174,4110.010.0000 
DML lock allocation10,021,9340.010.0000 
Event Group Locks116,1550.010.0000 
FOB s.o list latch122,6950.100.0100 
File State Object Pool Parent Latch40.00 00 
I/O Staticstics latch40.00 00 
IPC stats buffer allocation latch40.00 00 
In memory undo latch80,413,5120.600.0323,633,6460.01
JOX SGA heap latch963,6120.000.0000 
JS Sh mem access120.00 00 
JS queue access latch40.00 00 
JS queue state obj latch21,6300.00 00 
JS slv state obj latch2420.00 00 
KFC FX Hash Latch40.00 00 
KFC Hash Latch40.00 00 
KFCL LE Freelist40.00 00 
KGNFS-NFS:SHM structure40.00 00 
KGNFS-NFS:SVR LIST40.00 00 
KJC message pool free list40.00 00 
KJCT flow control latch40.00 00 
KMG MMAN ready and startup request latch1,2020.00 00 
KTF sga latch230.00 01,2130.00
KWQMN job cache list latch32,2570.011.0000 
KWQP Prop Status4590.00 00 
KWQS pqsubs latch33,5730.00 00 
KWQS pqueue ctx latch41,4220.030.6700 
Locator state objects pool parent latch40.00 00 
Lsod array latch40.00 00 
MQL Tracking Latch0  0710.00
Memory Management Latch40.00 01,2020.00
Memory Queue240.00 00 
Memory Queue Message Subscriber #140.00 00 
Memory Queue Message Subscriber #240.00 00 
Memory Queue Message Subscriber #340.00 00 
Memory Queue Message Subscriber #440.00 00 
Memory Queue Subscriber40.00 00 
MinActiveScn Latch412.440.0000 
Mutex40.00 00 
Mutex Stats40.00 00 
OS process234,8730.00 00 
OS process allocation124,5300.610.0000 
OS process: request allocation116,7150.260.0000 
PL/SQL warning settings7,892,1230.060.0000 
PX hash array latch40.00 00 
QMT40.00 00 
Real-time plan statistics latch58,7130.260.8900 
SGA blob parent40.00 00 
SGA bucket locks40.00 00 
SGA heap locks40.00 00 
SGA pool locks40.00 00 
SQL memory manager latch40.00 01,1950.00
SQL memory manager workarea list latch11,413,6070.000.0000 
Shared B-Tree85,5630.000.0000 
Streams Generic40.00 00 
Testing40.00 00 
Token Manager40.00 00 
WCR: sync40.00 00 
Write State Object Pool Parent Latch40.00 00 
X$KSFQP40.00 00 
XDB NFS Security Latch40.00 00 
XDB unused session pool40.00 00 
XDB used session pool40.00 00 
active checkpoint queue latch250,6800.090.0000 
active service list320,6760.240.5203,5850.00
begin backup scn array370.00 00 
bq:time manger info latch1280.00 00 
buffer pool40.00 00 
bufq statistics200.00 00 
business card40.00 00 
cache buffer handles6,056,2820.100.0000 
cache buffers chains6,360,059,4063.450.0560165,129,6300.98
cache buffers lru chain7,616,1160.020.020131,240,9560.90
call allocation1,422,4770.390.0700 
cas latch40.00 00 
change notification client cache latch40.00 00 
channel handle pool latch118,3470.320.0000 
channel operations parent latch198,5620.150.0000 
checkpoint queue latch50,157,8840.000.0001,473,6300.00
client/application info2,274,4190.000.0000 
compile environment latch58,1060.00 00 
corrupted undo seg latch7,645,9480.010.0000 
cp cmon/server latch40.00 00 
cp pool latch40.00 00 
cp server hash latch40.00 00 
cp sga latch1,2630.00 00 
cvmap freelist lock40.00 00 
deferred cleanup latch1,2630.00 00 
dml lock allocation1,3410.00 00 
done queue latch40.00 00 
dummy allocation116,9940.170.0000 
enqueue freelist latch60.00 05,202,8850.00
enqueue hash chains20,814,6790.150.000220.00
enqueues7,4890.030.0000 
fifth spare latch40.00 00 
file cache latch9,3670.010.0000 
flashback copy40.00 00 
fourth Audit Vault latch40.00 00 
gc element40.00 00 
gcs commit scn state40.00 00 
gcs partitioned table hash40.00 00 
gcs pcm hashed value bucket hash40.00 00 
gcs resource freelist40.00 00 
gcs resource hash40.00 00 
gcs resource scan list40.00 00 
gcs shadows freelist40.00 00 
ges domain table40.00 00 
ges enqueue table freelist40.00 00 
ges group table40.00 00 
ges process hash list40.00 00 
ges process parent latch40.00 00 
ges resource hash list40.00 00 
ges resource scan list40.00 00 
ges resource table freelist40.00 00 
ges value block free list40.00 00 
global KZLD latch for mem in SGA57,8810.00 00 
global ctx hash table latch2,322,4560.010.0000 
global tx hash mapping40.00 00 
granule operation40.00 00 
hash table column usage latch1580.00 07120.00
hash table modification latch60.00 00 
heartbeat check40.00 00 
intra txn parallel recovery40.00 00 
io pool granule metadata list40.00 00 
job workq parent latch690.00 0650.00
job_queue_processes free list latch1300.00 00 
job_queue_processes parameter latch8460.00 00 
k2q lock allocation40.00 00 
kdlx hb parent latch40.00 00 
kgb parent40.00 00 
kgnfs mount latch40.00 00 
kokc descriptor allocation latch695,7310.730.58240 
ksfv messages40.00 00 
ksim group membership cache40.00 00 
kss move lock880.00 00 
ksuosstats global area3730.271.0000 
ksv allocation latch1,4310.00 00 
ksv class latch1720.00 00 
ksv msg queue latch40.00 00 
ksz_so allocation latch116,7150.540.0000 
ktm global data1,4500.00 00 
kwqbsn:qsga2,2230.310.0000 
lgwr LWN SCN2,177,9900.060.0000 
list of block allocation443,7800.030.0000 
loader state object freelist1,113,2120.080.0000 
lob segment dispenser latch40.00 00 
lob segment hash table latch160.00 00 
lob segment query latch40.00 00 
lock DBA buffer during media recovery40.00 00 
logical standby cache40.00 00 
logminer context allocation80.00 00 
logminer work area40.00 00 
longop free list parent40.00 00 
mapped buffers lru chain40.00 00 
message pool operations parent latch4330.00 00 
messages7,393,4580.310.0000 
mostly latch-free SCN2,432,9915.190.0000 
msg queue latch40.00 00 
multiblock read objects3800.00 00 
name-service namespace bucket40.00 00 
ncodef allocation latch1,2630.00 00 
object queue header heap15,120,2420.000.1101,567,7220.00
object queue header operation2,690,163,87415.290.00260 
object stats modification1,665,2340.030.0100 
parallel query alloc buffer12,8560.00 00 
parallel query stats40.00 00 
parameter list414,7090.050.0000 
parameter table management11,346,4050.490.2310 
peshm40.00 00 
pesom_free_list4,392,6120.010.0000 
pesom_hash_node4,966,5780.000.0000 
pesom_heap_alloc33,7570.010.0000 
post/wait queue10,402,2300.010.0001,469,5030.03
process allocation116,8771.000.48557,8790.28
process group creation116,7150.070.0000 
process queue40.00 00 
process queue reference40.00 00 
qmn task queue latch4,9527.510.0100 
query server freelists40.00 00 
queued dump request120.00 00 
queuing load statistics40.00 00 
recovery domain hash list40.00 00 
redo allocation69,480,4930.170.00065,218,5531.56
redo copy40.00 065,384,2890.25
redo writing8,030,7720.020.0000 
resmgr group change latch101,9540.00 00 
resmgr:active threads116,9940.00 00 
resmgr:actses change group57,9940.00 00 
resmgr:actses change state40.00 00 
resmgr:free threads list116,9920.400.0000 
resmgr:plan CPU method40.00 00 
resmgr:resource group CPU method40.00 00 
resmgr:schema config40.00 00 
resmgr:session queuing40.00 00 
rm cas latch40.00 00 
row cache objects468,333,9213.270.0000 
rules engine aggregate statistics23,4750.00 00 
rules engine rule set statistics78,6970.000.0000 
rules engine rule statistics31,3470.00 00 
second Audit Vault latch40.00 00 
second spare latch40.00 00 
sequence cache5,558,2510.330.0000 
session allocation6,603,0330.000.0006,485,3390.00
session idle bit141,977,8600.000.0000 
session queue latch40.00 00 
session state list latch348,0640.330.7000 
session switching60,3800.390.0000 
session timer1,9110.00 00 
shared pool16,700,5130.240.0200 
shared pool sim alloc110.00 00 
shared pool simulator1660.00 00 
sim partition latch40.00 00 
simulator hash latch40.00 00 
simulator lru latch40.00 00 
sort extent pool4,616,2499.180.0000 
space background state object latch360.00 00 
space background task latch23,41515.310.5202,7300.95
state object free list80.00 00 
statistics aggregation1,3440.00 00 
tablespace key chain40.00 00 
temp lob duration state obj allocation7,3430.250.0000 
temporary table state object allocation47,2690.330.0000 
test excl. parent l040.00 00 
test excl. parent2 l040.00 00 
third spare latch40.00 00 
threshold alerts latch7320.00 00 
trace latch2200.00 00 
transaction allocation1,096,5930.010.0000 
undo global data97,820,6372.590.0007,3380.01
virtual circuit buffers40.00 00 
virtual circuit holder40.00 00 
virtual circuit queues40.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
object queue header operation2,690,163,874411,353,223843,001410,551,752
cache buffers chains6,360,059,406219,399,64110,708,728207,755,004
row cache objects468,333,92115,298,26916,40615,282,135
undo global data97,820,6372,531,3171,3052,530,081
In memory undo latch80,413,512483,15613,052471,218
sort extent pool4,616,249423,807188423,619
mostly latch-free SCN2,432,991126,270109126,161
redo allocation69,480,493116,85653116,803
parameter table management11,346,40555,54112,54843,179
shared pool16,700,51340,82775340,107
enqueue hash chains20,814,67931,025731,018
messages7,393,45822,899422,895
sequence cache5,558,25118,234618,228
cache buffer handles6,056,2826,06216,061
call allocation1,422,4775,5613865,178
kokc descriptor allocation latch695,7315,0782,9602,212
space background task latch23,4153,5861,8521,911
session idle bit141,977,8603,49563,489
cache buffers lru chain7,616,1161,649371,613
redo writing8,030,7721,55621,554
DML lock allocation10,021,9341,24411,243
process allocation116,8771,168560611
session state list latch348,0641,158805398
post/wait queue10,402,2301,14911,148
loader state object freelist1,113,2129221921
AQ dequeue txn counter latch50,1527881787
active service list320,676785410378
object stats modification1,665,2345513549
qmn task queue latch4,9523722370
Real-time plan statistics latch58,71315113528
FOB s.o list latch122,6951231122
object queue header heap15,120,242951085
KWQS pqueue ctx latch41,4221284
KWQMN job cache list latch32,257330
ksuosstats global area373110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
AQ dequeue txn counter latchkwqdUpdDeqTxnCnt: update011
DML lock allocationktaidm010
FOB s.o list latchksfd_allfob011
In memory undo latchktiFlush: child07,5213,772
In memory undo latchkticmt: child03,996946
In memory undo latchktichg: child01,0123,687
In memory undo latchktiFlushMe0789267
In memory undo latchktbgfc08031
In memory undo latchktigetmypoollatch_20550
In memory undo latchkturbk0434,823
In memory undo latchktiTxnPoolFree0268
In memory undo latchktbchg2ro061
In memory undo latchktiFlushTopTxn060
KWQMN job cache list latchkwqmnuji: update job item023
KWQMN job cache list latchkwqmndej: dequeue010
KWQS pqueue ctx latchkwqspqcbkf: updatepqs099
PC and Classifier lists for WLMNo latch02880
Real-time plan statistics latchkeswxAddNewPlanEntry0135135
active service listkswslogon: session logout0529501
active service listkswsgetso: get service object0417
active service listkswsite: service iterator031
active service listkswsclstabc: scan list to return rows021
active service listkswsgsnp: get service name ptr0241
active service listkswslistsvc: count/copy service name020
cache buffer handleskcbzgs011
cache buffers chainskcbchg1: mod cr pin010,230,8863,303,263
cache buffers chainskcbgtcr: fast path (cr pin)01,891,2042,923,663
cache buffers chainskcbgtcr: fast path0124,01116,843
cache buffers chainskcbgtcr: kslbegin excl085,273231,677
cache buffers chainskcbgkcbcr054,885588,696
cache buffers chainskcbrls_2022,0941,828,626
cache buffers chainskcbzwb016,05240,664
cache buffers chainskcbgcur_2016,02810,806
cache buffers chainskcbgtcr_2015,38632,115
cache buffers chainskcbcge012,7543,094,052
cache buffers chainskcbrls: fast release011,105166,003
cache buffers chainskcbget: fast exchange04,4731,217
cache buffers chainskcbchg1: clear MS bit03,495290,538
cache buffers chainskcbget: pin buffer01,301462
cache buffers chainskcbgcur: fast path (shr)0726330
cache buffers chainskcbzgb: scan from tail. nowait06270
cache buffers chainskcb_is_private03266,681
cache buffers chainskcbnlc02801,183
cache buffers chainskcbgcur_40273387
cache buffers chainskcbchg1: aux pin0138143
cache buffers chainskcb_trim_hash_chain0130181
cache buffers chainskcbesc: escalate07945
cache buffers chainskcbget: fast path075330
cache buffers chainskcbnew: new latch again0742
cache buffers chainskcbso1: set no access033775
cache buffers chainskcbchg1: mod cur pin0314,479
cache buffers chainskcbzpbuf0311,230
cache buffers chainskcbrls_1030489
cache buffers chainskcbbxsv0277
cache buffers chainskcb_pre_apply: kcbhq61011900
cache buffers chainskcbo_ivd_process0110
cache buffers chainskcbzar_fpin_1011704
cache buffers chainskcb_commit09803
cache buffers chainskcbget: release shr0672
cache buffers chainskcb_post_apply: kcbhq6205236
cache buffers chainskcbget: release excl04476
cache buffers chainskcbbic2034
cache buffers chainskcbget_1030
cache buffers chainskcbget: exchange02718
cache buffers chainskcbget: upgrade latch015
cache buffers chainskcbivbr010
cache buffers chainskcbrlb10121
cache buffers chainskcbzswcu012
cache buffers lru chainkcbzgws0180
cache buffers lru chainkcbo_link_q0167
cache buffers lru chainkcbo_ivd_proc0214
cache buffers lru chainkcbzswcu0120
call allocationksuxds0359140
call allocationksudlp: top call01494
call allocationksuprc0854
call allocationksudlc : rec call0571
channel handle pool latchksrchconnect()01514
client/application infoksuinfos_cinfo021
client/application infokqp3273011
client/application infokskirefrattrmap012
enqueue hash chainsksqgtl3044
enqueue hash chainsksqrcl033
kokc descriptor allocation latchkokcdlt: regular free02,180259
kokc descriptor allocation latchkokcdlt: allocation07802,701
ksuosstats global areaksugetosstat011
lgwr LWN SCNkcs023040
loader state object freelistkcblfs010
messagesksaamb: after wakeup033
messagesksarcv011
mostly latch-free SCNkcslcu30105109
object queue header heapkcbo_check_flist090
object queue header heapkcbo_link_q:alloc0112
object queue header operationkcbo_ivbo01,032,3021,020,496
object queue header operationkcbo_link_q01,1581,561
object queue header operationkcbo_sw_buf07131,567
object queue header operationkcbo_unlink_q02925,366
object queue header operationkcbo_switch_mq_bg090838
object queue header operationkcbo_switch_cq080661
object queue header operationkcbo_switch_q_bg048671
object queue header operationkcbo_link_q:reget031612
object queue header operationkcbo_check_flist0143,823
object stats modificationksols_rank030
parameter table managementksp_param_table_free06,950129
parameter table managementkspcpy06,64623
parameter table managementkspptval04613,486
post/wait queuekslpstevent:get010
process allocationksucrp:104970
process allocationksudlp06052
process allocationksuapc03507
qmn task queue latchkwqmngettsk: get task022
redo allocationkcrfw_redo_gen: redo allocation 10510
redo allocationkcrfw_redo_gen: redo allocation 2010
redo allocationkcrfw_redo_gen: redo allocation 3010
redo writingkcrfw_cal_target_rba021
row cache objectskqrpre: find obj08,27310,422
row cache objectskqreqd: reget04,086913
row cache objectskqrso02,3001,304
row cache objectskqreqd01,7473,767
sequence cachekdnssd043
sequence cachekdnnxt: cached seq012
sequence cachekdnss012
session idle bitksupuc: set busy050
session idle bitksuxds010
session state list latchkpseqd072418
session state list latchkpscad0708
session state list latchkpscdl010220
session state list latchkpseqa011,396
shared poolkghfre0620194
shared poolkghalo0119327
shared poolkghupr1014231
sort extent poolktstdt: dealloc sort extent014270
sort extent poolktstdt: return extent044115
sort extent poolktstaddextent1010
sort extent poolktstcrtobj012
space background task latchktsj_grab_task01,5641,852
undo global dataktudba: KSLBEGIN01,3031,302
undo global dataktucof: at start020

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpin1 4294,5850
Library Cachekglpndl1 95220,9900
Library Cachekglpnal1 90145,9870
Library Cachekglget1 171,1650
Cursor Pinkksfbc [KKSCHLFSP2]28,8470
Library Cachekgllkdl1 8526,7200
Library Cachekglhdgn2 10616,9840
Library Cachekgllkc1 5711,9190
Library Cachekglget2 24,0920
Library Cachekglhdgn1 623,6500
Cursor PinkksLockDelete [KKSCHLPIN6]2,1150
Cursor Pinkksxsccmp [KKSCHLPIN5]6290
Cursor Pinkksfbc [KKSCHLPIN1]4250
Cursor Pinkkslce [KKSCHLPIN2]1910
Library CachekglGetHandleReference 1241570
Library Cachekglobpn1 711290
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]910
Library Cachekglhdgh1 64520
Library CachekglReleaseHandleReference 125300
Library Cachekglhbh1 63220
Cursor ParentkkscsPruneChild [KKSPRTLOC35]50
Library Cachekglic1 4920
hash tablekkscsSearchChildList [KKSHBKLOC2]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
INVAPPS_TS_TX_DATAMTL_SYSTEM_ITEMS_B TABLE446,401,84011.16
APPLSYSAPPS_TS_TX_DATAFND_CONCURRENT_REQUESTS TABLE406,380,14410.16
APPLSYSAPPS_TS_SEEDFND_MENU_ENTRIES_U1 INDEX157,832,4483.95
APPLSYSAPPS_TS_SEEDFND_MENU_ENTRIES TABLE144,885,9683.62
POAPPS_TS_TX_DATAPO_REQUISITION_HEADERS_ALL TABLE119,451,0562.99

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
HRAPPS_TS_TX_DATAPER_ALL_PEOPLE_F TABLE3890.17
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_432961441_0TABLE PARTITION1380.06
POAPPS_TS_TX_DATAPO_ACTION_HISTORY TABLE1060.05
POAPPS_TS_TX_IDXPO_HEADERS_U1 INDEX580.03
POAPPS_TS_TX_IDXPO_LINE_LOCATIONS_U1 INDEX530.02

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
HRAPPS_TS_TX_DATAPER_ALL_PEOPLE_F TABLE3840.38
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_432961441_0TABLE PARTITION1380.14
POAPPS_TS_TX_DATAPO_ACTION_HISTORY TABLE1060.11
POAPPS_TS_TX_IDXPO_HEADERS_U1 INDEX580.06
POAPPS_TS_TX_IDXPO_LINE_LOCATIONS_U1 INDEX490.05

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
HRAPPS_TS_TX_DATAPER_ALL_PEOPLE_F TABLE3840.38
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_432961441_0TABLE PARTITION1380.14
POAPPS_TS_TX_DATAPO_ACTION_HISTORY TABLE1060.11
POAPPS_TS_TX_IDXPO_HEADERS_U1 INDEX580.06
POAPPS_TS_TX_IDXPO_LINE_LOCATIONS_U1 INDEX490.05

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_ATTRIBUTE_VALUES_PK INDEX91,9615.95
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE66,3304.29
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX29,9091.94
APPLSYSAPPS_TS_TX_DATAFND_CONCURRENT_REQUESTS TABLE22,8311.48
ZXAPPS_TS_TX_DATAZX_LINES_DET_FACTORS TABLE18,0071.17

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_ATTRIBUTE_VALUES_PK INDEX19,1028.00
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE12,0775.06
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX9,3093.90
ZXAPPS_TS_TX_DATAZX_LINES_DET_FACTORS TABLE4,0591.70
APPLSYSAPPS_TS_TX_DATAFND_CONCURRENT_REQUESTS TABLE3,9441.65

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_432961441_0TABLE PARTITION13623.13

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_DATAFND_CONCURRENT_REQUESTS TABLE607,894,48091.53
APAPPS_TS_TX_IDXAP_INVOICE_LINES_U1 INDEX10,298,4481.55
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE5,893,0720.89
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX5,849,5840.88
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX4,502,1600.68

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 TABLE75,35996.25
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX1,2521.60
APPLSYSAPPS_TS_TX_IDXWF_NOTIFICATIONS_ATTR_PK INDEX2150.27
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N4 INDEX1940.25
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N3 INDEX1910.24

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 INDEX3355.00
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_PKWF_ITEM57INDEX PARTITION711.67
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N3 INDEX610.00
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N4 INDEX610.00
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_PKWF_ITEM62INDEX PARTITION23.33

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 TABLE100,16768.37
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX12,2548.36
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX4,2372.89
POAPPS_TS_TX_IDXPO_HEADERS_DRAFT_U1 INDEX3,5332.41
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ACTIVITY_STATUSESWF_ITEM57TABLE PARTITION3,2552.22

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control880.000 83
dc_global_oids3,999,1200.000 0142
dc_histogram_data913.300 0447
dc_histogram_defs6176.650 017,266
dc_objects5,527,6540.000 010,505
dc_profiles57,9470.000 01
dc_rollback_segments40,3200.100 117320
dc_segments10,1260.390 8445,464
dc_sequences4,6300.000 4,63055
dc_table_scns380,9330.000 06
dc_tablespace_quotas1960.000 04
dc_tablespaces9,870,8040.000 057
dc_users195,482,1440.000 0187
global database name60,6230.000 01
outstanding_alerts3200.000 054


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS115,7640.000 00
APP CONTEXT116,4710.006,487,033-0.0000
BODY2,343,926-0.0066,039,522-0.0700
CLUSTER10.0010.0000
CONTEXT POLICY165,4550.0047,9990.0000
DBLINK115,7660.000 00
DIRECTORY92,9680.0092,9680.0000
EDITION58,2100.00116,1570.0000
INDEX30.0030.0000
JAVA DATA6,7700.004730.0000
PIPE1,0680.001,0700.0900
QUEUE14,7150.0069,109-0.0200
RULESET1,0700.0023,4750.0000
SCHEMA57,9550.000 00
SQL AREA3,004,3540.26249,881,110-0.496,6896,689
SQL AREA BUILD6,7110.160 00
SQL AREA STATS6,7110.336,7110.3300
SUBSCRIPTION7020.007020.0000
TABLE/PROCEDURE3,564,630-0.0072,531,038-0.1230
TRIGGER30,3520.001,180,317-0.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 cache62,464.0062,464.0062,464.0064,512.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target65,536.0065,536.0065,536.0065,536.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target81,920.0081,920.0081,920.0081,920.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool1,792.001,792.00256.001,792.000GRO/IMM
large pool256.00256.000.00256.000GRO/IMM
shared pool16,384.0016,384.0016,384.0016,384.000STA/
streams pool512.00512.000.00512.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
BPL/SQL16,405.3914,072.685.906.2739392,7812,781
Other13,259.41 4.772.9927272,7812,781
JAVA3,609.493,604.292.993.901381451,2061,206
SQL3,134.16539.971.143.2094942,7562,751
Freeable3,057.750.001.291.229 2,3682,368
EPL/SQL12,733.9210,554.225.917.0638392,1542,154
Other10,216.52 4.743.1227272,1542,154
JAVA2,708.582,704.653.034.54138145893893
SQL2,265.33444.521.063.2194942,1322,123
Freeable2,101.940.001.171.2511 1,7991,799

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers65,498,251,264 
Fixed Size2,168,728 
Redo Buffers176,775,168 
Variable Size19,864,225,896 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javaJOXLE18.6818.680.00
javafree memory1,772.491,772.490.00
largePX msg pool7.817.810.00
largefree memory248.19248.190.00
sharedASH buffers254.00254.000.00
sharedCheckpoint queue216.21216.210.00
sharedKKSSP858.21635.02-26.01
shareddb_block_hash_buckets356.00356.000.00
shareddirty object counts array216.00216.000.00
sharedfree memory12,480.3512,706.431.81
sharedprivate strands177.94177.940.00
streamsfree memory510.04510.04-0.00
 buffer_cache62,464.0062,464.000.00
 fixed_sga2.072.070.00
 log_buffer168.59168.590.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 Slaves0915 11:39:2212.430.000.00
QMON Coordinator0915 11:39:120.200.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_21138(17396)/APPLSYS.WF_CONTROL 00.0000.0000.00 
WFBESCL_21139(17397)/APPLSYS.WF_CONTROL 00.0000.0000.00 
WFBESCL_21140(17395)/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 15,5940.0003.823.984.320.000.000.000
APPLSYS.WF_DEFERRED_QUEUE_M_R 7,8670.007,8672.422.242.181.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) 560100.000.000.070.000.000.00
APPLSYS.WF_CONTROL(423650) 00  0.000.00  
APPLSYS.WF_DEFERRED(423674) 15,59400.000.0024.2510.590.0026.02
APPLSYS.WF_DEFERRED_QUEUE_M(423736) 7,86700.00100.008.590.000.0036.04
APPLSYS.WF_JAVA_DEFERRED(423754) 00  0.000.00  
APPLSYS.WF_NOTIFICATION_OUT(423750) 00  0.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) 4.320.000.00 
APPLSYS.WF_DEFERRED_QUEUE_M(423736) 2.180.000.00 
APPLSYS.WF_JAVA_DEFERRED(423754) 0.000.00  
APPLSYS.WF_NOTIFICATION_OUT(423750) 0.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_1597178(256)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_CARTRIDGE_1597179(258)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_CARTRIDGE_1597180(260)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_CARTRIDGE_1597181(262)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_CARTRIDGE_1597182(264)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_SERVICE_1597173(247)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597174(249)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597175(251)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597176(253)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597177(255)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597178(257)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597179(259)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597180(261)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597181(263)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597182(265)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597183(267)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597184(269)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1597185(271)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
WFBESCL_21138(17396)/APPLSYS.WF_CONTROL 0000.000.000.00
WFBESCL_21139(17397)/APPLSYS.WF_CONTROL 0000.000.000.00
WFBESCL_21140(17395)/APPLSYS.WF_CONTROL 0000.000.000.00
WF_DEFERRED(1)/APPLSYS.WF_DEFERRED 15,59416,03304.324.440.00
APPS(1)/APPLSYS.WF_DEFERRED_QUEUE_M 7,872002.180.000.00
WF_JAVA_DEFERRED(1)/APPLSYS.WF_JAVA_DEFERRED 000   
WF_NOTIFICATION_OUT(1)/APPLSYS.WF_NOTIFICATION_OUT 0000.000.000.00

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  
_fast_full_scan_enabledFALSE  
_kgl_hot_object_copies255  
_like_with_bind_as_equalityTRUE  
_optimizer_autostats_jobFALSE  
_sort_elimination_cost_ratio5  
_system_trig_enabledTRUE  
_trace_files_publicFALSE  
aq_tm_processes1  
audit_sys_operationsTRUE  
compatible11.2.0  
control_files/ebizdata/data/cntrl01.dbf, /ebizdata/data/cntrl02.dbf, /ebizdata/data/cntrl03.dbf  
cursor_sharingFORCE  
db_block_checkingFALSE  
db_block_checksumTRUE  
db_block_size8192  
db_cache_adviceOFF  
db_files512  
db_nameVIS  
db_writer_processes8  
diagnostic_dest/export/home/oracle/app/oracle/product/11.2.0/dbhome_1/admin/VIS_dbzone2  
dml_locks10000  
filesystemio_optionssetall  
ifile/export/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/VIS_dbzone2_ifile.ora  
job_queue_processes2  
local_listenerVIS_LOCAL  
log_archive_dest_1LOCATION=/ebizdata/data/archive  
log_archive_format%t_%s_%r.dbf  
log_buffer104841216  
log_checkpoints_to_alertTRUE  
max_dump_file_size20480  
nls_compbinary  
nls_date_formatDD-MON-RR  
nls_length_semanticsBYTE  
nls_numeric_characters.,  
nls_sortbinary  
nls_territoryamerica  
olap_page_pool_size4194304  
open_cursors600  
optimizer_secure_view_mergingFALSE  
os_authent_prefix    
parallel_max_servers8  
parallel_min_servers0  
pga_aggregate_target68719476736  
plsql_code_typeINTERPRETED  
plsql_optimize_level2  
processes8000  
recyclebinOFF  
sec_case_sensitive_logonFALSE  
session_cached_cursors1000  
sessions12096  
sga_target85899345920  
shared_pool_reserved_size8589934592  
shared_pool_size17179869184  
sql92_securityTRUE  
undo_managementAUTO  
undo_tablespaceAPPS_UNDOTS1  
utl_file_dir/usr/tmp, /usr/tmp, /export/home/oracle/app/oracle/product/11.2.0/dbhome_1/appsutil/outbound/VIS_dbzone2, /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/ebizdata/data/cntrl01.dbf  
/ebizdata/data/cntrl02.dbf  
/ebizdata/data/cntrl03.dbf  
utl_file_dir/export/home/oracle/app/oracle/product/11.2.0/dbhome_1/appsutil/outbound/VIS_dbzone2  
/usr/tmp  
/usr/tmp  
/usr/tmp  
/usr/tmp  
/usr/tmp  
/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