WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
VIS375914273VIS118-Sep-13 06:0911.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
dbzone1Solaris[tm] OE (64-bit) 80 10 1 1006.00

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1018-Sep-13 12:30:45907 53.7
End Snap:1118-Sep-13 12:45:46910 54.0
Elapsed:  15.01 (mins)  
DB Time:  128.28 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 100,096M 100,096MStd Block Size: 8K
Shared Pool Size: 16,384M 16,384MLog Buffer: 225,048K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 8.6 0.0 0.00 0.00
DB CPU(s): 8.6 0.0 0.00 0.00
Redo size: 1,016,091.6 5,245.4  
Logical reads: 149,912.4 773.9  
Block changes: 7,368.4 38.0  
Physical reads: 26.4 0.1  
Physical writes: 114.1 0.6  
User calls: 4,649.5 24.0  
Parses: 859.1 4.4  
Hard parses: 1.5 0.0  
W/A MB processed: 38.9 0.2  
Logons: 5.9 0.0  
Executes: 15,004.7 77.5  
Rollbacks: 23.9 0.1  
Transactions: 193.7   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 100.04Soft Parse %: 99.82
Execute to Parse %: 94.27Latch Hit %: 98.65
Parse CPU to Parse Elapsd %: 91.52% Non-Parse CPU: 99.29

Shared Pool Statistics

BeginEnd
Memory Usage %: 21.63 21.93
% SQL with executions>1: 94.27 93.40
% Memory for SQL w/exec>1: 94.45 93.36

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 7,762 100.84 
log file sync85,2922300.30Commit
virtual circuit wait58,132800.10Network
SQL*Net message to client4,080,969600.08Network
library cache: mutex X10,513510.07Concurrency

Host CPU (CPUs: 80 Cores: 10 Sockets: 1)

Load Average BeginLoad Average End%User%System%WIO%Idle
50.89 48.07 11.3 0.8 0.0 87.9
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
10.9 89.4 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 1,030,144.0 1,030,144.0
SGA use (MB): 131,072.0 131,072.0
PGA use (MB): 4,022.9 4,002.2
% Host Mem used for SGA+PGA: 13.11 13.11

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU7,761.96100.84
sql execute elapsed time7,567.0398.31
PL/SQL execution elapsed time3,522.9045.77
parse time elapsed64.880.84
connection management call elapsed time23.630.31
Java execution elapsed time10.930.14
hard parse elapsed time4.920.06
PL/SQL compilation elapsed time2.020.03
inbound PL/SQL rpc elapsed time1.850.02
repeated bind elapsed time0.730.01
failed parse elapsed time0.140.00
sequence load elapsed time0.070.00
DB time7,697.09 
background elapsed time171.90 
background cpu time61.45 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME10,891 
AVG_IDLE_TIME79,080 
AVG_SYS_TIME688 
AVG_USER_TIME10,158 
BUSY_TIME874,995 
IDLE_TIME6,330,355 
SYS_TIME58,667 
USER_TIME816,328 
LOAD5148
OS_CPU_WAIT_TIME108,600 
PHYSICAL_MEMORY_BYTES1,080,184,274,944 
NUM_CPUS80 
NUM_CPU_CORES10 
NUM_CPU_SOCKETS1 
TCP_RECEIVE_SIZE_DEFAULT128,000 
TCP_SEND_SIZE_DEFAULT49,152 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
18-Sep 12:30:4550.89     
18-Sep 12:45:4648.0712.1411.330.8187.860.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  7,762 100.84
Commit85,29202300.30
Network4,193,61301500.19
Concurrency16,0310600.08
User I/O132,2240600.08
Application20,8100000.01
Other55810000.00
Configuration10000.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 sync85,29202300.490.30
virtual circuit wait58,1320800.330.10
SQL*Net message to client4,080,96906023.390.08
library cache: mutex X10,5130510.060.07
utl_file I/O128,4250400.740.06
direct path read3,4350200.020.02
SQL*Net more data to client50,6760100.290.01
latch: shared pool1,7040100.010.01
SQL*Net break/reset to client20,4940000.120.00
db file sequential read2960000.000.00
enq: TX - row lock contention3160000.000.00
buffer busy waits2,0430000.010.00
latch: cache buffers chains1,1960000.010.00
latch: In memory undo latch4200000.000.00
latch free2170000.000.00
SQL*Net more data from client3,8360000.020.00
Disk file operations I/O670000.000.00
enq: TX - index contention420000.000.00
cursor: pin S1070000.000.00
SQL*Net message from client8,151,1150558,3186846.72 
Streams AQ: waiting for messages in the queue2,1329618,26385660.01 
pipe get1,0801004,50041670.01 
PL/SQL lock timer3601003,600100000.00 
jobq slave wait1,8631009304990.01 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
db file parallel write22,65907430.1343.27
log file parallel write150,32504100.8623.56
os thread startup4201350.000.86
control file parallel write4400120.000.61
control file sequential read1,9950100.010.44
db file async I/O submit22,6590000.130.21
db file sequential read1,0070000.010.18
db file scattered read1070000.000.03
LGWR wait for redo copy1,6090000.010.02
ADR block file write50070.000.02
latch: shared pool600000.000.01
SQL*Net message to client14,4960000.080.01
latch free2500000.000.00
Disk file operations I/O1860000.000.00
library cache: mutex X1700000.000.00
latch: active service list1250000.000.00
direct path write20010.000.00
shared server idle wait4,135,01211,750,06842323.70 
dispatcher timer8,247,2980179,4812247.27 
rdbms ipc message156,216419,6811260.90 
Space Manager: slave idle wait2,128708,79041310.01 
Streams AQ: qmn slave idle wait43202,68862220.00 
DIAG idle wait1,7721001,77210000.01 
smon timer340900264610.00 
pmon timer3039889929680.00 
Streams AQ: qmn coordinator idle wait3144689628540.00 
Streams AQ: waiting for time management or cleanup tasks6426789313910.00 
JOX Jit Process Sleep59100885150000.00 
class slave wait120000.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 read15100.0       
ADR block file write5   60.040.0   
ADR file lock6100.0       
Disk file operations I/O252100.0       
LGWR wait for redo copy1615100.0       
SQL*Net break/reset to client20.5K100.0       
SQL*Net message to client4091K100.0       
SQL*Net more data from client3835100.0       
SQL*Net more data to client50.6K100.0       
asynch descriptor resize42100.0       
buffer busy waits2045100.0       
buffer deadlock55100.0       
control file parallel write43977.9.52.512.84.61.4.5 
control file sequential read199199.7.2   .1.1 
cursor: mutex X1100.0       
cursor: pin S107100.0       
db file async I/O submit22.7K100.0       
db file parallel write22.7K51.46.57.825.37.8.9.3 
db file scattered read10799.1.9      
db file sequential read130499.4.3 .2.2   
direct path read342299.1.1.3.3.1.1  
direct path write250.050.0      
enq: DV - contention1100.0       
enq: SQ - contention1100.0       
enq: TX - index contention42100.0       
enq: TX - row lock contention316100.0       
latch free466100.0       
latch: In memory undo latch420100.0       
latch: active service list125100.0       
latch: cache buffers chains1197100.0       
latch: call allocation15100.0       
latch: object queue header operation283100.0       
latch: row cache objects5100.0       
latch: shared pool176794.25.8      
library cache: mutex X10.7K95.1   4.9.0  
log file parallel write150.4K99.5.2.1.1.0.0.0 
log file sync85.3K99.1.3.2.2.1.0.0 
os thread startup42     40.559.5 
read by other session1100.0       
reliable message1100.0       
utl_file I/O128.3K100.0       
virtual circuit wait58.1K99.9.0.0.0.0.0.0 
DIAG idle wait1773      100.0 
JOX Jit Process Sleep59       100.0
PL/SQL lock timer324       100.0
SQL*Net message from client8125.4K94.71.7.8.8.5.3.9.4
Space Manager: slave idle wait20431.4.5    10.387.7
Streams AQ: qmn coordinator idle wait31654.1      45.9
Streams AQ: qmn slave idle wait424       100.0
Streams AQ: waiting for messages in the queue21223.0     1.695.4
Streams AQ: waiting for time management or cleanup tasks64219.0     50.230.8
class slave wait12100.0       
dispatcher timer8240.6K91.92.91.41.3.7.31.1.3
jobq slave wait1861.1.1   .199.8 
pipe get1072.1     8.391.6
pmon timer303      .399.7
rdbms ipc message156.3K25.413.919.918.411.05.03.33.2
shared server idle wait4132.6K90.44.01.91.1.6.3.41.4
smon timer33      9.190.9

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
control file parallel write299.5.2.2     
control file sequential read199.9  .1    
db file parallel write6799.7.2.1.0    
log file parallel write7100.0.0.0     
log file sync9100.0.0.0     
os thread startup2540.559.5      
virtual circuit wait2100.0  .0 .0  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
VIS7,6877,75222133,500
SYS$USERS33021
SYS$BACKGROUND0021,454

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 132223616032600419295715
SYS$USERS 30100000
SYS$BACKGROUND 1308021910000

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
2,347.964235.5530.50100.010.001cyrp6fh6mp53 e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...
1,422.854193.4018.4999.640.0085gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
1,396.604193.3318.1499.910.0054tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...
1,383.064143.3417.9799.310.0081xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
1,347.419813.7517.51100.010.004z510cva9wzsv POXPRPOP SELECT decode ( : P_sortby , ...
651.8420,2070.038.4799.800.0067mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
265.564190.633.45100.060.0115py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
179.454,073,2400.002.33100.950.00g4pktka6kg4w9 e::fwk:fnd.sso.login.server.MainLoginPageAM SELECT MENU_ID, ENTRY_SEQUENCE...
150.441,7580.091.9599.790.84ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
145.797660.191.89100.020.01327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
129.662,0950.061.68100.030.00akma8kaxsp84b e:PO:wf:POAPPRV SELECT reservation_id , requir...
81.7622,8440.001.06100.160.00f5z70bpcu7f0w e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := PO_RCO_VALIDATION_...

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
2,348.164235.5530.252,347.96100.010.001cyrp6fh6mp53 e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...
1,417.684193.3818.261,422.8599.640.0085gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
1,395.394193.3317.981,396.6099.910.0054tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...
1,373.564143.3217.701,383.0699.310.0081xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
1,347.499813.7517.361,347.41100.010.004z510cva9wzsv POXPRPOP SELECT decode ( : P_sortby , ...
650.5420,2070.038.38651.8499.800.0067mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
265.724190.633.42265.56100.060.0115py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
181.154,073,2400.002.33179.45100.950.00g4pktka6kg4w9 e::fwk:fnd.sso.login.server.MainLoginPageAM SELECT MENU_ID, ENTRY_SEQUENCE...
150.121,7580.091.93150.4499.790.84ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
145.827660.191.88145.79100.020.01327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
129.702,0950.061.67129.66100.030.00akma8kaxsp84b e:PO:wf:POAPPRV SELECT reservation_id , requir...
81.8922,8440.001.0681.76100.160.00f5z70bpcu7f0w e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := PO_RCO_VALIDATION_...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
1.271,7580.0020.26150.4499.790.84ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
0.044210.000.5942.92100.030.099ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
0.024190.000.33265.56100.060.0115py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
0.017660.000.19145.79100.020.01327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
0.013470.000.0972.8899.760.013mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
0.0010,3410.000.040.59104.150.40akpdj9s4ug2s2 e::bes:oracle.apps.icx.security.session.created SELECT PATH_DOCID FROM jdr_pat...
0.001,6800.000.0319.0099.360.012m7nn405vu27s e:PO:fwk:po.document.server.DocumentAM SELECT * FROM (SELECT POH.ACCE...
0.0020,2070.000.01651.8499.800.0067mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
0.004190.000.010.1794.510.284md5yxcm3xmuy e:PO:fwk:po.document.server.DocumentAM MERGE INTO PO_HEADERS_ALL PH U...
0.007800.000.0026.8499.320.00aaw4na3kmdfkq JDBC Thin Client DECLARE l_result varchar2(1); ...

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
48,264,647419115,190.0935.751,396.6099.9054tzhmhcs8nkh e:PO:fwk:po.contract.server.PoxSysVariableAM declare context DBMS_XMLGEN.ct...
48,255,684419115,168.7035.741,422.8599.6085gad38y8bvv3 e:PO:fwk:po.contract.server.PoxSysVariableAM begin :1 :=PO_COMMUNICATION_PV...
45,235,058414109,263.4333.501,383.0699.3081xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
18,981,47720,207939.3514.06651.8499.8067mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
15,867,1044,073,2403.9011.75179.45100.90g4pktka6kg4w9 e::fwk:fnd.sso.login.server.MainLoginPageAM SELECT MENU_ID, ENTRY_SEQUENCE...
11,033,79541926,333.648.17265.56100.1015py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
5,196,2047666,783.563.85145.791000327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
5,072,1689851,756.823.761,347.4110004z510cva9wzsv POXPRPOP SELECT decode ( : P_sortby , ...
4,621,5792,0952,206.003.42129.661000akma8kaxsp84b e:PO:wf:POAPPRV SELECT reservation_id , requir...
4,423,46642310,457.373.282,347.9610001cyrp6fh6mp53 e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...
3,854,1921,6922,277.892.8548.0010003v6p5sm1dkafz e:PO:fwk:po.autocreate.server.AutocreateAM SELECT * FROM (SELECT /*+ LEAD...
3,756,2561,7582,136.662.78150.4499.8.8ctnvq3qjh4065 e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := por_util_pkg.inter...
3,372,7473479,719.732.5072.8899.803mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
2,897,88722,844126.862.1581.76100.20f5z70bpcu7f0w e:ICX:fwk:icx.por.req.server.RequisitionAM begin :1 := PO_RCO_VALIDATION_...
1,870,707639,5722.921.3923.73102.900wmwsjy9kd92f JDBC Thin Client SELECT PROFILE_OPTION_ID, APPL...
1,606,1914213,815.181.1942.92100.19ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
1,581,920484,4323.271.1715.3796.807qs7fx89194u1 JDBC Thin Client SELECT PROFILE_OPTION_VALUE FR...
1,475,189229,1956.441.0912.7199.80dawf7hvg1ym94 JDBC Thin Client select V.PROFILE_OPTION_VALUE ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
504190.120.21265.56100.060.0115py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
364210.090.1542.92100.030.099ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
307660.040.13145.79100.020.01327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
143470.040.0672.8899.760.013mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
610,3410.000.030.59104.150.40akpdj9s4ug2s2 e::bes:oracle.apps.icx.security.session.created SELECT PATH_DOCID FROM jdr_pat...
31,6800.000.0119.0099.360.012m7nn405vu27s e:PO:fwk:po.document.server.DocumentAM SELECT * FROM (SELECT POH.ACCE...
14190.000.000.1794.510.284md5yxcm3xmuy e:PO:fwk:po.document.server.DocumentAM MERGE INTO PO_HEADERS_ALL PH U...
17800.000.0026.8499.320.00aaw4na3kmdfkq JDBC Thin Client DECLARE l_result varchar2(1); ...
015,2620.000.002.2588.500.0002w6b7xyjd8hu e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT 'Y' FROM SYS.DUAL WHERE...
00 0.000.0171.650.000cyf7ts2q1dpg POXPRPOP SELECT decode ( : P_sortby , ...

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
50504190.120.000.6215py3q5vknkb9 e:PO:fwk:po.document.server.DocumentAM BEGIN PO_REQAPPROVAL_INIT1.Sta...
36364210.090.000.449ybx57rqdhm4m e:PO:fwk:po.autocreate.server.AutocreateAM BEGIN PO_INTERFACE_S.create_do...
30307660.040.000.37327r1ynryuzvw e:ICX:wf:REQAPPRV begin PO_REQAPPROVAL_ACTION.AP...
14143470.040.000.173mhu25sfw466x e:ICX:wf:POWFRQAG begin :1 := POR_UTIL_PKG.submi...
331,6800.000.000.042m7nn405vu27s e:PO:fwk:po.document.server.DocumentAM SELECT * FROM (SELECT POH.ACCE...
114190.000.000.014md5yxcm3xmuy e:PO:fwk:po.document.server.DocumentAM MERGE INTO PO_HEADERS_ALL PH U...
117800.000.000.01aaw4na3kmdfkq JDBC Thin Client DECLARE l_result varchar2(1); ...
0015,2620.00 0.0002w6b7xyjd8hu e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT 'Y' FROM SYS.DUAL WHERE...
000  0.000cyf7ts2q1dpg POXPRPOP SELECT decode ( : P_sortby , ...
004200.00 0.000dd7939mhr0ka e:PO:fwk:po.document.server.DocumentAM SELECT * FROM (SELECT /*+ USE_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
4,073,24032,928,2098.08179.45100.90g4pktka6kg4w9 e::fwk:fnd.sso.login.server.MainLoginPageAM SELECT MENU_ID, ENTRY_SEQUENCE...
639,572590,0390.9223.73102.900wmwsjy9kd92f JDBC Thin Client SELECT PROFILE_OPTION_ID, APPL...
484,432128,0250.2615.3796.807qs7fx89194u1 JDBC Thin Client SELECT PROFILE_OPTION_VALUE FR...
253,550253,5141.0025.4899.809tmzdvyu94058 e:PO:fwk:po.document.server.DocumentAM SELECT PoLineLocationMergeEO.O...
229,19599,7320.4412.7199.80dawf7hvg1ym94 JDBC Thin Client select V.PROFILE_OPTION_VALUE ...
109,732108,5500.994.2599.9091hakq9n36htp e:ICX:wf:REQAPPRV SELECT TEXT_VALUE FROM WF_ITEM...
73,76373,7631.0026.2797.502450j0nxcnga5 ICM@appszone1 (TNS V1-V3) declare sql_dummy1 boolean;beg...
72,30472,3031.002.68102.10ccprbqfuu8wb1 e:ICX:wf:REQAPPRV SELECT NUMBER_VALUE FROM WF_IT...
49,42420,6640.427.27105.80cm5vu20fhtnq1   select /*+ connect_by_filterin...
30,57711,5420.381.32103.90a4gss3ajbyfzr JDBC Thin Client SELECT R.RESPONSIBILITY_NAME F...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
28,29328,2933.666vx0fw5141z4n e:POS:fwk:ap.invoice.request.server.InvoiceReque SELECT STATUS_FLAG FROM IGI_GC...
21,73321,7332.81bbugagurwv1vy e:POS:fwk:ap.invoice.request.server.InvoiceReque (SELECT STATUS_FLAG FROM IGI_G...
15,26515,2621.9702w6b7xyjd8hu e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT 'Y' FROM SYS.DUAL WHERE...
15,26515,2641.972xn2trkq5y922 e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT POH.PO_HEADER_ID FROM P...
15,26515,2641.97ch6akxnh7bfx9 e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT 'Exists' FROM PO_LINES ...
15,26515,2641.97gmzaqj0bt8jy1 e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT 'Y' FROM PO_HEADERS_ARC...
15,26415,2651.975693gr4xpt3ac e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT 1 FROM PO_LINE_LOCATION...
15,26415,2631.9764y52qc72ffda e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT 'Y' FROM SYS.DUAL WHERE...
15,26315,2641.97gnkqm72nrzg9j e:ICX:fwk:icx.por.req.server.RequisitionAM SELECT 'Exists' FROM PO_LINE_L...
6,9866,9860.907yr8xbwxpdnav e:ICX:wf:POWFRQAG INSERT INTO WIP_EAM_DIRECT_ITE...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
3,556,1654140.02fc1vzazaaduns e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT phx.*, PO_COMMUNICATION...
2,413,8254140.0181xv2tma4cag8 e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."ITEM_REVISION" "I...
1,254,332980.014z510cva9wzsv POXPRPOP SELECT decode ( : P_sortby , ...
1,209,676980.014z510cva9wzsv POXPRPOP SELECT decode ( : P_sortby , ...
1,133,0252,0950.014mj8xhjcnw7gf e:PO:fwk:po.contract.server.PoxSysVariableAM SELECT "A2"."SHIPMENT_NUM" "SH...
1,107,08600.010cyf7ts2q1dpg POXPRPOP SELECT decode ( : P_sortby , ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
02w6b7xyjd8huSELECT 'Y' FROM SYS.DUAL WHERE EXISTS( SELECT NULL FROM PO_DISTRIBUTIONS POD, PO_DISTRIBUTIONS_ARCHIVE PODA WHERE POD.PO_HEADER_ID = :B3 AND (:B2 IS NULL OR POD.PO_LINE_ID = :B2 ) AND (:B1 IS NULL OR POD.LINE_LOCATION_ID = :B1 ) AND POD.PO_DISTRIBUTION_ID = PODA.PO_DISTRIBUTION_ID (+) AND PODA.LATEST_EXTERNAL_FLAG (+) = 'Y' AND ( (PODA.PO_DISTRIBUTION_ID IS NULL) OR (POD.QUANTITY_ORDERED <> PODA.QUANTITY_ORDERED) OR (POD.QUANTITY_ORDERED IS NULL AND PODA.QUANTITY_ORDERED IS NOT NULL) OR (POD.QUANTITY_ORDERED IS NOT NULL AND PODA.QUANTITY_ORDERED IS NULL) OR (POD.AMOUNT_ORDERED <> PODA.AMOUNT_ORDERED) OR (POD.AMOUNT_ORDERED IS NULL AND PODA.AMOUNT_ORDERED IS NOT NULL) OR (POD.AMOUNT_ORDERED IS NOT NULL AND PODA.AMOUNT_ORDERED IS NULL) OR (POD.DELIVER_TO_PERSON_ID <> PODA.DELIVER_TO_PERSON_ID) OR (POD.DELIVER_TO_PERSON_ID IS NULL AND PODA.DELIVER_TO_PERSON_ID IS NOT NULL) OR (POD.DELIVER_TO_PERSON_ID IS NOT NULL AND PODA.DELIVER_TO_PERSON_ID IS NULL) ))
0cyf7ts2q1dpg SELECT decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_last_name ) , decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_first_name ) , decode ( : po_num_type , 'NUMERIC' , null , poh . po_num ) , decode ( : po_num_type , 'NUMERIC' , decode ( rtrim ( poh . po_num , '0123456789' ) , NULL , to_number ( poh . po_num ) , - 1 ) , null ) , poh . po_type poh_po_type , por . release_type poh_release_type , poh . po_num || decode ( poh . po_type , 'RELEASE' , '-' || por . release_num , null ) poh_po_num , poh . po_num security_poh_po_num , por . release_num security_por_po_num , poh . revision_num poh_revision_num , poh . vendor_name poh_vendor_name , poh . vendor_address_line1 poh_vendor_address_line1 , poh . vendor_address_line2 poh_vendor_address_line2 , poh . vendor_address_line3 poh_vendor_address_line3 , decode ( poh . vendor_city , null , poh . vendor_state || ' ' || poh . vendor_postal_code , poh . vendor_city || ', ' || poh . vendor_state || ' ' || poh . vendor_postal_code ) poh_vendor_adr_info , poh . vendor_country poh_vendor_country , poh . customer_num poh_customer , poh . vendor_num poh_vendor_num , poh . creation_date poh_creation_date , poh . revised_date poh_revised_date , substr ( substr ( poh . document_buyer_first_name , 1 , 1 ) || ' ' || poh . document_buyer_last_name , 1 , 12 ) poh_buyer , substr ( trim ( substr ( poh . archive_buyer_first_name , 1 , 1 ) || ' ' || poh . archive_buyer_last_name ) , 1 , 12 ) poh_archive_buyer , poh . document_buyer_agent_id poh_agent_id , poh . payment_terms poh_payment_terms , poh . ship_via poh_ship_via , poh . fob poh_fob , poh . freight_terms poh_freight_terms , substr ( poh . vendor_contact_first_name , 1 , 1 ) || ' ' || substr ( poh . vendor_contact_last_name , 1 , 10 ) poh_vendor_contact_name , poh . vendor_phone poh_vendor_phone , poh . vendor_contact_phone poh_vendor_contact_phone , poh . note_to_vendor poh_note_to_vendor , poh . printed_date poh_printed_date , poh . amount_agreed poh_amount_agreed , poh . cancel_flag poh_cancel_flag , poh . confirming_order_flag poh_confirming_order_flag , poh . acceptance_required_flag poh_acceptance_req_flag , poh . acceptance_due_date poh_acceptance_due_date , poh . currency_code poh_currency_code , poh . currency_code C_CURRENCY , poh . currency_name poh_currency_name , poh . currency_conversion_rate poh_currency_conversion_rate , poh . bill_to_location_id poh_bill_to_location , poh . ship_to_location_id poh_ship_to_location , poh . po_header_id poh_po_header_id , poh . po_release_id poh_po_release_id , poh . po_type poh_po_type , poh . approved_flag poh_approved_flag , poh . print_count poh_print_count , poh . effective_date poh_effective_date , poh . expiration_date poh_expiration_date , nvl ( poh . po_release_id , - 1 ) poh_join_release_id , poh . vendor_site_id poh_vendor_site_id , poh . vendor_id poh_vendor_id FROM po_headers_print poh , po_releases por WHERE poh . po_release_id = por . po_release_id (+) AND ( nvl ( por . release_num , - 1 ) BETWEEN nvl ( : P_release_num_from , nvl ( por . release_num , - 1 ) ) AND nvl ( : P_release_num_to , nvl ( por . release_num , - 1 ) ) OR poh . po_type != 'RELEASE' ) AND poh . document_buyer_agent_id = nvl ( : P_agent_id , poh . document_buyer_agent_id ) AND ( poh . release_date is NULL OR trunc ( poh . release_date ) BETWEEN nvl ( : P_date_from , trunc ( poh . release_date ) ) AND nvl ( : P_date_to , trunc ( poh . release_date ) + 1 ) ) AND nvl ( poh . approved_flag , 'N' ) = nvl ( : P_approved_flag , nvl ( poh . approved_flag , 'N' ) ) AND ( ( nvl ( : P_print_releases , 'Y' ) = 'Y' ) or ( nvl ( : P_print_releases , 'Y' ) = 'N' and poh . po_type != 'RELEASE' ) ) AND nvl ( poh . consigned_consumption_flag , 'N' ) <> 'Y' AND nvl ( por . consigned_consumption_flag , 'N' ) <> 'Y' AND :P_single_po_print = 1 AND po_num = :P_po_num_from AND nvl(poh.print_ count, 0) =0 AND poh.approved_flag = :P_approved_flag and 1=1 and 1=1 ORDER BY 1 , 2 , 3 , 4
0dd7939mhr0ka SELECT * FROM (SELECT /*+ USE_NL(PoLineLocationMergeEO) */ PoLineLocationMergeEO.OWNER_USER_ID, PoLineLocationMergeEO.OWNER_ROLE, PoLineLocationMergeEO.STATUS, PoLineLocationMergeEO.DRAFT_ID, PoLineLocationMergeEO.CHANGE_ACCEPTED_FLAG, PoLineLocationMergeEO.DELETE_FLAG, PoLineLocationMergeEO.USSGL_TRANSACTION_CODE, PoLineLocationMergeEO.GOVERNMENT_CONTEXT, PoLineLocationMergeEO.RECEIVING_ROUTING_ID, PoLineLocationMergeEO.ACCRUE_ON_RECEIPT_FLAG, PoLineLocationMergeEO.CLOSED_REASON, PoLineLocationMergeEO.CLOSED_DATE, PoLineLocationMergeEO.CLOSED_BY, PoLineLocationMergeEO.ORG_ID, PoLineLocationMergeEO.ATTRIBUTE6, PoLineLocationMergeEO.ATTRIBUTE7, PoLineLocationMergeEO.ATTRIBUTE8, PoLineLocationMergeEO.ATTRIBUTE9, PoLineLocationMergeEO.ATTRIBUTE10, PoLineLocationMergeEO.UNIT_OF_MEASURE_CLASS, PoLineLocationMergeEO.ENCUMBER_NOW, PoLineLocationMergeEO.ATTRIBUTE11, PoLineLocationMergeEO.ATTRIBUTE12, PoLineLocationMergeEO.ATTRIBUTE13, PoLineLocationMergeEO.ATTRIBUTE14, PoLineLocationMergeEO.ATTRIBUTE15, PoLineLocationMergeEO.INSPECTION_REQUIRED_FLAG, PoLineLocationMergeEO.RECEIPT_REQUIRED_FLAG, PoLineLocationMergeEO.QTY_RCV_TOLERANCE, PoLineLocationMergeEO.QTY_RCV_EXCEPTION_CODE, PoLineLocationMergeEO.ENFORCE_SHIP_TO_LOCATION_CODE, PoLineLocationMergeEO.ALLOW_SUBSTITUTE_RECEIPTS_FLAG, PoLineLocationMergeEO.DAYS_EARLY_RECEIPT_ALLOWED, PoLineLocationMergeEO.DAYS_LATE_RECEIPT_ALLOWED, PoLineLocationMergeEO.RECEIPT_DAYS_EXCEPTION_CODE, PoLineLocationMergeEO.INVOICE_CLOSE_TOLERANCE, PoLineLocationMergeEO.RECEIVE_CLOSE_TOLERANCE, PoLineLocationMergeEO.SHIP_TO_ORGANIZATION_ID, PoLineLocationMergeEO.SHIPMENT_NUM, PoLineLocationMergeEO.SOURCE_SHIPMENT_ID, PoLineLocationMergeEO.SHIPMENT_TYPE, PoLineLocationMergeEO.CLOSED_CODE, PoLineLocationMergeEO.REQUEST_ID, PoLineLocationMergeEO.PROGRAM_APPLICATION_ID, PoLineLocationMergeEO.PROGRAM_ID, PoLineLocationMergeEO.PROGRAM_UPDATE_DATE, PoLineLocationMergeEO.PROMISED_DATE, PoLineLocationMergeEO.LAST_ACCEPT_DATE, PoLineLocationMergeEO.PRICE_OVERRIDE, PoLineLocationMergeEO.ENCUMBERED_FLAG, PoLineLocationMergeEO.ENCUMBERED_DATE, PoLineLocationMergeEO.UNENCUMBERED_QUANTITY, PoLineLocationMergeEO.FOB_LOOKUP_CODE, PoLineLocationMergeEO.FREIGHT_TERMS_LOOKUP_CODE, PoLineLocationMergeEO.TAXABLE_FLAG, PoLineLocationMergeEO.ESTIMATED_TAX_AMOUNT, PoLineLocationMergeEO.FROM_HEADER_ID, PoLineLocationMergeEO.FROM_LINE_ID, PoLineLocationMergeEO.FROM_LINE_LOCATION_ID, PoLineLocationMergeEO.START_DATE, PoLineLocationMergeEO.END_DATE, PoLineLocationMergeEO.TERMS_ID, PoLineLocationMergeEO.APPROVED_FLAG, PoLineLocationMergeEO.APPROVED_DATE, PoLineLocationMergeEO.CLOSED_FLAG, PoLineLocationMergeEO.CANCEL_FLAG, PoLineLocationMergeEO.CANCELLED_BY, PoLineLocationMergeEO.CANCEL_DATE, PoLineLocationMergeEO.CANCEL_REASON, PoLineLocationMergeEO.FIRM_STATUS_LOOKUP_CODE, PoLineLocationMergeEO.FIRM_DATE, PoLineLocationMergeEO.ATTRIBUTE_CATEGORY, PoLineLocationMergeEO.ATTRIBUTE1, PoLineLocationMergeEO.ATTRIBUTE2, PoLineLocationMergeEO.ATTRIBUTE3, PoLineLocationMergeEO.ATTRIBUTE4, PoLineLocationMergeEO.ATTRIBUTE5, PoLineLocationMergeEO.LINE_LOCATION_ID, PoLineLocationMergeEO.LAST_UPDATE_DATE, PoLineLocationMergeEO.LAST_UPDATED_BY, PoLineLocationMergeEO.PO_HEADER_ID, PoLineLocationMergeEO.PO_LINE_ID, PoLineLocationMergeEO.LAST_UPDATE_LOGIN, PoLineLocationMergeEO.CREATION_DATE, PoLineLocationMergeEO.CREATED_BY, PoLineLocationMergeEO.QUANTITY, PoLineLocationMergeEO.QUANTITY_RECEIVED, PoLineLocationMergeEO.QUANTITY_ACCEPTED, PoLineLocationMergeEO.QUANTITY_REJECTED, PoLineLocationMergeEO.QUANTITY_BILLED, PoLineLocationMergeEO.QUANTITY_CANCELLED, PoLineLocationMergeEO.UNIT_MEAS_LOOKUP_CODE, PoLineLocationMergeEO.PO_RELEASE_ID, PoLineLocationMergeEO.SHIP_TO_LOCATION_ID, PoLineLocationMergeEO.SHIP_VIA_LOOKUP_CODE, PoLineLocationMergeEO.NEED_BY_DATE, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE_CATEGORY, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE1, PoLineL ocationMergeEO.GLOBAL_ATTRIBUTE2, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE3, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE4, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE5, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE6, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE7, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE8, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE9, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE10, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE11, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE12, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE13, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE14, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE15, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE16, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE17, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE18, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE19, PoLineLocationMergeEO.GLOBAL_ATTRIBUTE20, PoLineLocationMergeEO.QUANTITY_SHIPPED, PoLineLocationMergeEO.COUNTRY_OF_ORIGIN_CODE, PoLineLocationMergeEO.TAX_USER_OVERRIDE_FLAG, PoLineLocationMergeEO.MATCH_OPTION, PoLineLocationMergeEO.TAX_CODE_ID, PoLineLocationMergeEO.CALCULATE_TAX_FLAG, PoLineLocationMergeEO.CHANGE_PROMISED_DATE_REASON, PoLineLocationMergeEO.NOTE_TO_RECEIVER, PoLineLocationMergeEO.SECONDARY_UNIT_OF_MEASURE, PoLineLocationMergeEO.SECONDARY_QUANTITY, PoLineLocationMergeEO.PREFERRED_GRADE, PoLineLocationMergeEO.SECONDARY_QUANTITY_RECEIVED, PoLineLocationMergeEO.SECONDARY_QUANTITY_ACCEPTED, PoLineLocationMergeEO.SECONDARY_QUANTITY_REJECTED, PoLineLocationMergeEO.SECONDARY_QUANTITY_CANCELLED, PoLineLocationMergeEO.VMI_FLAG, PoLineLocationMergeEO.CONSIGNED_FLAG, PoLineLocationMergeEO.RETROACTIVE_DATE, PoLineLocationMergeEO.SUPPLIER_ORDER_LINE_NUMBER, PoLineLocationMergeEO.AMOUNT, PoLineLocationMergeEO.AMOUNT_RECEIVED, PoLineLocationMergeEO.AMOUNT_BILLED, PoLineLocationMergeEO.AMOUNT_CANCELLED, PoLineLocationMergeEO.AMOUNT_ACCEPTED, PoLineLocationMergeEO.AMOUNT_REJECTED, PoLineLocationMergeEO.DROP_SHIP_FLAG, PoLineLocationMergeEO.SALES_ORDER_UPDATE_DATE, PoLineLocationMergeEO.TRANSACTION_FLOW_HEADER_ID, PoLineLocationMergeEO.FINAL_MATCH_FLAG, PoLineLocationMergeEO.MANUAL_PRICE_CHANGE_FLAG, PoLineLocationMergeEO.SHIPMENT_CLOSED_DATE, PoLineLocationMergeEO.CLOSED_FOR_RECEIVING_DATE, PoLineLocationMergeEO.CLOSED_FOR_INVOICE_DATE, PoLineLocationMergeEO.SECONDARY_QUANTITY_SHIPPED, PoLinesAll.LINE_NUM, PoLineLocationMergeEO.PAYMENT_TYPE, PoLineLocationMergeEO.DESCRIPTION, PoLineLocationMergeEO.VALUE_BASIS, PoLineLocationMergeEO.MATCHING_BASIS, PoLineLocationMergeEO.WORK_APPROVER_ID, PoLineLocationMergeEO.BID_PAYMENT_ID, PoLineLocationMergeEO.QUANTITY_FINANCED, PoLineLocationMergeEO.AMOUNT_FINANCED, PoLineLocationMergeEO.QUANTITY_RECOUPED, PoLineLocationMergeEO.AMOUNT_RECOUPED, PoLineLocationMergeEO.RETAINAGE_WITHHELD_AMOUNT, PoLineLocationMergeEO.RETAINAGE_RELEASED_AMOUNT, PoLineLocationMergeEO.AMOUNT_SHIPPED, PoLineLocationMergeEO.TAX_ATTRIBUTE_UPDATE_CODE, PoLineLocationMergeEO.OUTSOURCED_ASSEMBLY FROM PO_LINE_LOCATIONS_MERGE_V PoLineLocationMergeEO, PO_LINES_ALL PoLinesAll /** We join to the _all table to order by line_num. This will need to be changed if we add support for Standard PO drafts. **/ WHERE PoLineLocationMergeEO.PO_LINE_ID = PoLinesAll.PO_LINE_ID) QRSLT WHERE (po_header_id = :1 AND shipment_type IN ('STANDARD', 'PREPAYMENT') AND ( ( payment_type IS NULL AND po_line_id IN (SELECT po_line_id FROM po_lines_merge_v POL WHERE POL.po_header_id = :2 AND POL.purchase_basis <> 'TEMP LABOR') ) OR payment_type NOT IN ('ADVANCE', 'DELIVERY') )) ORDER BY LINE_NUM, SHIPMENT_NUM
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;
1cyrp6fh6mp53 SELECT * FROM (SELECT /*+ LEADING(prl) */ prh.requisition_header_id REQUISITION_HEADER_ID , prh.segment1 REQUISITION_NUM , prl.requisition_line_id REQUISITION_LINE_ID , prl.line_num REQUISITION_LINE_NUM , prh.org_id OPERATING_UNIT_ID , nvl(po_moac_utils_pvt.get_ou_shortcode(prh.org_id), po_moac_utils_pvt.get_ou_name(prh.org_id)) ORGANIZATION , prh.type_lookup_code TYPE_LOOKUP_CODE , prl.item_description ITEM_DESCRIPTION , prl.item_id ITEM_ID , msi.concatenated_segments ITEM_NUMBER , prl.item_revision ITEM_REVISION , prl.quantity QUANTITY , prl.need_by_date NEED_BY_DATE , prl.category_id CATEGORY_ID , mc.concatenated_segments CATEGORY , prl.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE , prl.unit_price REQ_UNIT_PRICE , DECODE (prl.rfq_required_flag, 'Y', 'RfqRequiredY', 'RfqRequiredN') RFQ_REQUIRED , NVL(prl.rfq_required_flag, 'N') RFQ_REQUIRED_FLAG , NVL(prl.on_rfq_flag, 'N') ON_RFQ_FLAG , NVL(prl.drop_ship_flag, 'N') DROP_SHIP_FLAG , prl.suggested_vendor_name SUGGESTED_VENDOR_NAME , prl.vendor_id VENDOR_ID , prl.suggested_vendor_location SUGGESTED_VENDOR_LOC , prl.vendor_site_id VENDOR_SITE_ID , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) REQ_AMOUNT , req_sob.currency_code REQ_CURRENCY_CODE , prl.bid_line_number BID_LINE_NUMBER , prl.bid_number BID_NUMBER , prl.suggested_buyer_id SUGGESTED_BUYER_ID , buyer.full_name SUGGESTED_BUYER , prh.creation_date CREATION_DATE , prl.currency_code FOREIGN_CURRENCY_CODE , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.currency_amount, 'RATE', prl.currency_amount, prl.quantity * prl.currency_unit_price) FOREIGN_CURRENCY_AMT , decode(pltb.purchase_basis, 'GOODS', prl.currency_unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.currency_unit_price) , 'TEMP LABOR', prl.currency_unit_price ) FOREIGN_CURRENCY_UNIT_PRICE , prl.deliver_to_location_id DELIVER_TO_LOCATION_ID , NVL(deliver_hrtl.location_code, SUBSTRB(rtrim(deliver_hz.address1)||'-'||rtrim(deliver_hz.city), 1, 20)) DELIVER_TO_LOCATION , prl.destination_organization_id DESTINATION_ORGANIZATION_ID , dst_hou.name DESTINATION_ORGANIZATION , prl.destination_subinventory DESTINATION_SUBINVENTORY , prl.destination_type_code DESTINATION_TYPE_CODE , NVL(deliver_hr.ship_to_location_id, deliver_hz.location_id) SHIP_TO_LOCATION_ID , prh.emergency_po_num EMERGENCY_PO_NUM , prh.emergency_po_org_id EMERGENCY_PO_ORG_ID , DECODE(prl.encumbered_flag, 'Y', 'EncumberedY', 'EncumberedN') ENCUMBERED , NVL(prl.encumbered_flag, 'N') ENCUMBERED_FLAG , prl.assignment_end_date ASSIGNMENT_END_DATE , prl.candidate_first_name CANDIDATE_FIRST_NAME , prl.suggested_vendor_contact SUGGESTED_VENDOR_CONTACT , prl.hazard_class_id HAZARD_CLASS_ID , prh.interface_source_code IMPORT_SOURCE_CODE , prl.job_id JOB_ID , prl.justification JUSTIFICATION , prl.candidate_last_name CANDIDATE_LAST_NAME , DECODE(SIGN(SYSDATE - NVL(prl.need_by_date, SYSDATE) - NVL(msi.full_lead_time, 0)), 1, 'Y', 'N') LATE_FLAG , DECODE(prl.modified_by_agent_flag, 'Y', 'ModifiedY', 'ModifiedN') MODIFIED , prl.auction_line_number NEGOTIATION_LINE_NUMBER , prl.auction_display_number NEGOTIATION_NUMBER , prl.note_to_agent NOTE_TO_BUYER , prl.note_to_receiver NOTE_TO_RECEIVER , prl.wip_operation_seq_num OPERATION_SEQUENCE , prl.wip_repetitive_schedule_id REPETITIVE_SCHEDULE_ID , DECODE(NVL(prl.pcard_flag, 'N'), 'N', TO_NUMBER(NULL), 'S', -99999, prh.pcard_id) PCARD_ID , prl.suggested_vendor_phone SUGGESTED_VENDOR_PHONE , prl.preferred_grade PREFERRED_GRADE , preparer.full_name PREPARER , prh.preparer_id PREPARER_ID , prl.quantity_received QUANTITY_RECEIVED , prl.rate FOREIGN_CURRENCY_RATE , prl.rate_date FOREIGN_CURRENCY_RATE_DATE , prl.rate_type FOREIGN_CURRENCY_RATE_TYPE , prl.reference_num REFERENCE_NUM , requester.full_name REQUESTER , prl.to_person_id R EQUESTER_ID , prh.description REQUISITION_DESCRIPTION , prl.bom_resource_id BOM_RESOURCE_ID , prl.wip_resource_seq_num RESOURCE_SEQUENCE , prl.secondary_quantity SECONDARY_QUANTITY , prl.secondary_unit_of_measure SECONDARY_UNIT_OF_MEASURE , prl.blanket_po_line_num SOURCE_DOCUMENT_LINE , src_doc.segment1 SOURCE_DOCUMENT_NUM , prl.blanket_po_header_id SOURCE_DOCUMENT_ID , src_doc.org_id SOURCE_DOCUMENT_ORG_ID , prl.document_type_code SOURCE_DOC_TYPE_CODE , NVL(src_doc.global_agreement_flag, 'N') GLOBAL_FLAG , DECODE (src_doc.global_agreement_flag, 'Y', 'GlobalY', 'GlobalN') GLOBAL , DECODE (prl.blanket_po_header_id, NULL, 'N', 'Y') REQ_SOURCED_FLAG , prl.oke_contract_header_id OKE_CONTRACT_HEADER_ID , prl.assignment_start_date ASSIGNMENT_START_DATE , DECODE (prl.new_supplier_flag, 'Y', 'NewSupplierY', 'NewSupplierN') NEW_SUPPLIER , NVL(prl.new_supplier_flag, 'N') NEW_SUPPLIER_FLAG , prl.supplier_ref_number SUPPLIER_CONFIG_ID , prl.suggested_vendor_contact_email SUGGESTED_VENDOR_EMAIL , prl.suggested_vendor_contact_fax SUGGESTED_VENDOR_FAX , prl.suggested_vendor_product_code SUPPLIER_ITEM , prl.ussgl_transaction_code TRANSACTION_CODE , prl.transaction_reason_code TRANSACTION_REASON , plttl.line_type LINE_TYPE_DSP , pltb.line_type_id LINE_TYPE_ID , pltb.order_type_lookup_code ORDER_TYPE_LOOKUP_CODE , pltb.purchase_basis PURCHASE_BASIS , pltb.matching_basis MATCHING_BASIS , prl.labor_req_line_id LABOR_REQ_LINE_ID , DECODE (prl.suggested_buyer_id, NULL, 'Y', 'N') UNASSIGNED_FLAG , prl.un_number_id UN_NUMBER_ID , DECODE (prl.urgent_flag, 'Y', 'UrgentY', 'UrgentN') URGENT , NVL(prl.urgent_flag, 'N') URGENT_FLAG , DECODE (prl.vmi_flag, 'Y', 'VmiY', 'VmiN') VMI , NVL(prl.vmi_flag, 'N') VMI_FLAG , prl.wip_entity_id WIP_ENTITY_ID , prl.wip_line_id WIP_LINE_ID , NVL(prh.authorization_status, 'INCOMPLETE') AUTHORIZATION_STATUS , prl.attribute_category ATTRIBUTE_CATEGORY , prl.attribute1 ATTRIBUTE1 , prl.attribute2 ATTRIBUTE2 , prl.attribute3 ATTRIBUTE3 , prl.attribute4 ATTRIBUTE4 , prl.attribute5 ATTRIBUTE5 , prl.attribute6 ATTRIBUTE6 , prl.attribute7 ATTRIBUTE7 , prl.attribute8 ATTRIBUTE8 , prl.attribute9 ATTRIBUTE9 , prl.attribute10 ATTRIBUTE10 , prl.attribute11 ATTRIBUTE11 , prl.attribute12 ATTRIBUTE12 , prl.attribute13 ATTRIBUTE13 , prl.attribute14 ATTRIBUTE14 , prl.attribute15 ATTRIBUTE15 , req_fsp.inventory_organization_id BASE_INV_ORGANIZATION_ID , prl.auction_header_id AUCTION_HEADER_ID , prh.segment1 ||', ' || prl.line_num REQUEST , nvl( msi.concatenated_segments, prl.item_description) ITEM , decode(pltb.purchase_basis, 'GOODS', prl.unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.unit_price) , 'TEMP LABOR', prl.unit_price ) PRICE , prl.vendor_contact_id VENDOR_CONTACT_ID , prl.PARENT_REQ_LINE_ID , prl.source_type_code , ( SELECT 'Y' FROM dual WHERE exists ( SELECT 'Y' FROM po_req_distributions_all prd WHERE prd.requisition_line_id=prl.requisition_line_id AND prd.award_id is not null ) )AWARD_EXISTS , prl.kanban_card_id , src_doc.style_id SOURCE_DOCUMENT_STYLE_ID , src_doc_line.po_line_id SOURCE_DOCUMENT_LINE_ID FROM po_requisition_headers_all prh, po_requisition_lines prl, hr_all_organization_units_tl hou, po_line_types_tl plttl, po_line_types_b pltb, po_headers_all src_doc, po_lines_all src_doc_line, hr_all_organization_units_tl dst_hou, mtl_system_items_b_kfv msi, mtl_categories_kfv mc, per_all_people_f buyer, per_all_people_f requester, per_all_people_f preparer, hr_locations_all_tl deliver_hrtl, hr_locations_all deliver_hr, hz_locations deliver_hz, financials_system_params_all req_fsp, gl_sets_of_books req_sob WHERE prl.requisition_header_id = prh.requisition_header_id AND hou.organization_id (+) = prl.org_id AND req_fsp.org_id = prl.org_id AND hou.language (+) = userenv('LANG') AND pltb.line_type_id = prl.line_type_id AND plttl.line_type_id = pltb.line_type_ id AND plttl.language = userenv('LANG') AND src_doc.po_header_id (+) = prl.blanket_po_header_id AND src_doc_line.po_header_id(+) = prl.blanket_po_header_id AND src_doc_line.line_num(+) = prl.blanket_po_line_num AND dst_hou.organization_id (+) = prl.destination_organization_id AND dst_hou.language (+) = userenv('LANG') AND msi.inventory_item_id (+) = prl.item_id AND msi.organization_id (+) = prl.destination_organization_id AND mc.category_id = prl.category_id AND buyer.person_id (+) = prl.suggested_buyer_id AND TRUNC(sysdate) BETWEEN buyer.effective_start_date(+) AND buyer.effective_end_date(+) AND requester.person_id = prl.to_person_id AND TRUNC(sysdate) BETWEEN requester.effective_start_date AND requester.effective_end_date AND preparer.person_id = prh.preparer_id AND TRUNC(sysdate) BETWEEN preparer.effective_start_date AND preparer.effective_end_date AND deliver_hr.location_id(+) = prl.deliver_to_location_id AND deliver_hrtl.location_id (+) = deliver_hr.location_id AND deliver_hrtl.language (+) = USERENV('LANG') AND deliver_hz.location_id(+) = prl.deliver_to_location_id AND req_fsp.set_of_books_id = req_sob.set_of_books_id AND prl.reqs_in_pool_flag = 'Y' AND ( NOT (pltb.order_type_lookup_code = 'RATE' AND pltb.purchase_basis = 'TEMP LABOR' AND EXISTS (SELECT 'Corresponding expense line not in pool' FROM po_requisition_lines_all expense_line WHERE expense_line.labor_req_line_id = prl.requisition_line_id AND expense_line.reqs_in_pool_flag is null))) AND ( NOT (pltb.order_type_lookup_code = 'FIXED PRICE' AND pltb.purchase_basis = 'SERVICES' AND EXISTS (SELECT 'Corresponding labor line not in pool' FROM po_requisition_lines_all labor_line WHERE labor_line.requisition_line_id = prl.labor_req_line_id AND labor_line.reqs_in_pool_flag is null))) AND NVL(prh.authorization_status, 'INCOMPLETE') NOT IN ('SYSTEM_SAVED', 'RETURNED') AND prl.requisition_line_id NOT IN (SELECT doc_builder.index_num1 FROM po_session_gt doc_builder WHERE doc_builder.key = :1) AND DECODE(FND_PROFILE.VALUE('PO_AUTOCREATE_ALLOW_BUYER_OVERRIDE'), 'Y', FND_GLOBAL.EMPLOYEE_ID, 'N', PRL.SUGGESTED_BUYER_ID, FND_GLOBAL.EMPLOYEE_ID)=FND_GLOBAL.EMPLOYEE_ID) QRSLT WHERE (requisition_line_id IN ( SELECT selected_req_lines.index_num1 FROM po_session_gt selected_req_lines WHERE selected_req_lines.key = :2 )) ORDER BY CREATION_DATE desc, ORGANIZATION, TO_NUMBER(REQUISITION_NUM) DESC, REQUISITION_LINE_NUM DESC
2450j0nxcnga5declare sql_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, sql_dummy1, :org_id, :server_id);end;
2m7nn405vu27s SELECT * FROM (SELECT POH.ACCEPTANCE_DUE_DATE ACKNOWLEDGE_BY, NVL(POH.ACCEPTANCE_REQUIRED_FLAG, 'N') ACCEPTANCE_REQUIRED_FLAG, DECODE(POH.APPROVED_FLAG, 'Y', POH.APPROVED_DATE, NULL) APPROVED_DATE, POH.BILL_TO_LOCATION_ID, POH.AGENT_ID, NVL(POH.CANCEL_FLAG, 'N') HEADER_CANCEL_FLAG, POH.CLOSED_DATE, NVL(POH.CLOSED_CODE, 'OPEN') HEADER_CLOSED_CODE, POH.CONFIRMING_ORDER_FLAG, POH.CONSIGNED_CONSUMPTION_FLAG, NVL(POH.CONTERMS_EXIST_FLAG, 'N') CONTERMS_EXIST_FLAG, POH.CURRENCY_CODE CURRENCY_CODE, POH.COMMENTS DESCRIPTION, NVL(POH.FIRM_STATUS_LOOKUP_CODE, 'N') FIRM_STATUS_LOOKUP_CODE, POH.FIRM_DATE, POH.FOB_LOOKUP_CODE, POH.FREIGHT_TERMS_LOOKUP_CODE, NVL(POH.FROZEN_FLAG, 'N') FROZEN_FLAG, POH.NOTE_TO_RECEIVER, POH.NOTE_TO_VENDOR, POH.SEGMENT1 PO_NUM, NVL(POH.USER_HOLD_FLAG, 'N') 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, 'N') 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, 'INCOMPLETE') AUTHORIZATION_STATUS, NVL(POH.SUPPLIER_AUTH_ENABLED_FLAG, 'N') 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, 'N') 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, 'N') 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('LANG') 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 'AGREEMENT' = 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_TY PE_CODE (+) AND :2 = POAH.OBJECT_TYPE_CODE (+) AND POAH.ACTION_CODE (+) = 'CANCEL' AND HRL2.LOCATION_ID (+) = POH.BILL_TO_LOCATION_ID AND HRL2.LANGUAGE (+) = USERENV('LANG') AND ( ( NVL(POH.GLOBAL_AGREEMENT_FLAG, 'N') = 'Y' AND (PO_MOAC_UTILS_PVT.check_access(POH.ORG_ID) = 'Y' OR EXISTS ( SELECT 'ENABLED IN MOAC OU' FROM PO_GA_ORG_ASSIGNMENTS POGA WHERE POH.PO_HEADER_ID = POGA.PO_HEADER_ID AND POGA.ENABLED_FLAG ='Y' AND (PO_MOAC_UTILS_PVT.check_access(POGA.ORGANIZATION_ID) = 'Y' OR PO_MOAC_UTILS_PVT.check_access(POGA.PURCHASING_ORG_ID) = 'Y' ) ) AND POH.AUTHORIZATION_STATUS = 'APPROVED' AND NVL(POH.CLOSED_CODE, 'OPEN') <> 'FINALLY CLOSED' AND NVL(POH.CANCEL_FLAG, 'N') = 'N' AND NVL(POH.FROZEN_FLAG, 'N') = 'N' AND ( TRUNC(SYSDATE) BETWEEN NVL(TRUNC(POH.START_DATE), TRUNC(SYSDATE) -1) AND NVL(TRUNC(POH.END_DATE), TRUNC(SYSDATE)+1) OR ( TRUNC(POH.START_DATE) IS NOT NULL AND TRUNC(SYSDATE) <= TRUNC(POH.START_DATE)) ) ) ) OR (NVL(GLOBAL_AGREEMENT_FLAG, 'N') = 'N' AND TYPE_LOOKUP_CODE = 'STANDARD' AND PO_MOAC_UTILS_PVT.CHECK_ACCESS (POH.ORG_ID ) = 'Y') ) AND POH.STYLE_ID = PDSLVL.STYLE_ID (+) AND POH.TYPE_LOOKUP_CODE = PDSLVL.DOCUMENT_SUBTYPE (+) AND PDSLVL.ENABLED_FLAG (+) = 'Y' AND (:3<> 'CAT_ADMIN' OR POH.CAT_ADMIN_AUTH_ENABLED_FLAG = 'Y') AND (/** always allow access to the buyer of the document **/ (agent_id = :4) OR ( ( (access_level_code IS NULL OR access_level_code = 'FULL') OR /** If the access level is View Only, prevent Modify or Full access **/ (access_level_code = 'VIEW_ONLY' AND :5 NOT IN ('MODIFY', 'FULL')) OR /** If the access level is Modify, prevent Full access **/ (access_level_code = 'MODIFY' AND :6 <> 'FULL')) AND ( (security_level_code = 'PUBLIC') OR (security_level_code IN ('PRIVATE', 'PURCHASING', 'HIERARCHY') AND EXISTS ( SELECT 'Employee is in approval path of this document' FROM PO_ACTION_HISTORY POAH WHERE POAH.employee_id = :7 AND POAH.object_type_code IN ('PO', 'PA') AND POAH.object_id = POH.po_header_id) ) OR (security_level_code = 'PURCHASING' AND EXISTS ( SELECT 'User is a BUYER' 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 + 1)) ) OR (security_level_code = 'HIERARCHY' AND EXISTS ( SELECT 'User exists in the HIERARCHY' /** 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, -1) ) ) ) ) ) AND 'Y' = Decode(Nvl(FND_PROFILE.Value('PO_ENFORCE_PROJ_SECURITY'), 'N'), 'Y', PA_PO_INTEGRATION_UTILS.PA_USER_PO_ACCESS_CHECK(poh.po_header_id, :10, 'VIEW'), 'Y')) 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
2xn2trkq5y922SELECT POH.PO_HEADER_ID FROM PO_HEADERS POH WHERE POH.PO_HEADER_ID = :B1
327r1ynryuzvwbegin PO_REQAPPROVAL_ACTION.APPROVE_DOC (:v1, :v2, :v3, :v4, :v5); end;
3mhu25sfw466xbegin :1 := POR_UTIL_PKG.submitreq(:2, :3, :4, :5, :6); end;
3v6p5sm1dkafz SELECT * FROM (SELECT /*+ LEADING(prl) */ prh.requisition_header_id REQUISITION_HEADER_ID , prh.segment1 REQUISITION_NUM , prl.requisition_line_id REQUISITION_LINE_ID , prl.line_num REQUISITION_LINE_NUM , prh.org_id OPERATING_UNIT_ID , nvl(po_moac_utils_pvt.get_ou_shortcode(prh.org_id), po_moac_utils_pvt.get_ou_name(prh.org_id)) ORGANIZATION , prh.type_lookup_code TYPE_LOOKUP_CODE , prl.item_description ITEM_DESCRIPTION , prl.item_id ITEM_ID , msi.concatenated_segments ITEM_NUMBER , prl.item_revision ITEM_REVISION , prl.quantity QUANTITY , prl.need_by_date NEED_BY_DATE , prl.category_id CATEGORY_ID , mc.concatenated_segments CATEGORY , prl.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE , prl.unit_price REQ_UNIT_PRICE , DECODE (prl.rfq_required_flag, 'Y', 'RfqRequiredY', 'RfqRequiredN') RFQ_REQUIRED , NVL(prl.rfq_required_flag, 'N') RFQ_REQUIRED_FLAG , NVL(prl.on_rfq_flag, 'N') ON_RFQ_FLAG , NVL(prl.drop_ship_flag, 'N') DROP_SHIP_FLAG , prl.suggested_vendor_name SUGGESTED_VENDOR_NAME , prl.vendor_id VENDOR_ID , prl.suggested_vendor_location SUGGESTED_VENDOR_LOC , prl.vendor_site_id VENDOR_SITE_ID , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) REQ_AMOUNT , req_sob.currency_code REQ_CURRENCY_CODE , prl.bid_line_number BID_LINE_NUMBER , prl.bid_number BID_NUMBER , prl.suggested_buyer_id SUGGESTED_BUYER_ID , buyer.full_name SUGGESTED_BUYER , prh.creation_date CREATION_DATE , prl.currency_code FOREIGN_CURRENCY_CODE , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.currency_amount, 'RATE', prl.currency_amount, prl.quantity * prl.currency_unit_price) FOREIGN_CURRENCY_AMT , decode(pltb.purchase_basis, 'GOODS', prl.currency_unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.currency_unit_price) , 'TEMP LABOR', prl.currency_unit_price ) FOREIGN_CURRENCY_UNIT_PRICE , prl.deliver_to_location_id DELIVER_TO_LOCATION_ID , NVL(deliver_hrtl.location_code, SUBSTRB(rtrim(deliver_hz.address1)||'-'||rtrim(deliver_hz.city), 1, 20)) DELIVER_TO_LOCATION , prl.destination_organization_id DESTINATION_ORGANIZATION_ID , dst_hou.name DESTINATION_ORGANIZATION , prl.destination_subinventory DESTINATION_SUBINVENTORY , prl.destination_type_code DESTINATION_TYPE_CODE , NVL(deliver_hr.ship_to_location_id, deliver_hz.location_id) SHIP_TO_LOCATION_ID , prh.emergency_po_num EMERGENCY_PO_NUM , prh.emergency_po_org_id EMERGENCY_PO_ORG_ID , DECODE(prl.encumbered_flag, 'Y', 'EncumberedY', 'EncumberedN') ENCUMBERED , NVL(prl.encumbered_flag, 'N') ENCUMBERED_FLAG , prl.assignment_end_date ASSIGNMENT_END_DATE , prl.candidate_first_name CANDIDATE_FIRST_NAME , prl.suggested_vendor_contact SUGGESTED_VENDOR_CONTACT , prl.hazard_class_id HAZARD_CLASS_ID , prh.interface_source_code IMPORT_SOURCE_CODE , prl.job_id JOB_ID , prl.justification JUSTIFICATION , prl.candidate_last_name CANDIDATE_LAST_NAME , DECODE(SIGN(SYSDATE - NVL(prl.need_by_date, SYSDATE) - NVL(msi.full_lead_time, 0)), 1, 'Y', 'N') LATE_FLAG , DECODE(prl.modified_by_agent_flag, 'Y', 'ModifiedY', 'ModifiedN') MODIFIED , prl.auction_line_number NEGOTIATION_LINE_NUMBER , prl.auction_display_number NEGOTIATION_NUMBER , prl.note_to_agent NOTE_TO_BUYER , prl.note_to_receiver NOTE_TO_RECEIVER , prl.wip_operation_seq_num OPERATION_SEQUENCE , prl.wip_repetitive_schedule_id REPETITIVE_SCHEDULE_ID , DECODE(NVL(prl.pcard_flag, 'N'), 'N', TO_NUMBER(NULL), 'S', -99999, prh.pcard_id) PCARD_ID , prl.suggested_vendor_phone SUGGESTED_VENDOR_PHONE , prl.preferred_grade PREFERRED_GRADE , preparer.full_name PREPARER , prh.preparer_id PREPARER_ID , prl.quantity_received QUANTITY_RECEIVED , prl.rate FOREIGN_CURRENCY_RATE , prl.rate_date FOREIGN_CURRENCY_RATE_DATE , prl.rate_type FOREIGN_CURRENCY_RATE_TYPE , prl.reference_num REFERENCE_NUM , requester.full_name REQUESTER , prl.to_person_id R EQUESTER_ID , prh.description REQUISITION_DESCRIPTION , prl.bom_resource_id BOM_RESOURCE_ID , prl.wip_resource_seq_num RESOURCE_SEQUENCE , prl.secondary_quantity SECONDARY_QUANTITY , prl.secondary_unit_of_measure SECONDARY_UNIT_OF_MEASURE , prl.blanket_po_line_num SOURCE_DOCUMENT_LINE , src_doc.segment1 SOURCE_DOCUMENT_NUM , prl.blanket_po_header_id SOURCE_DOCUMENT_ID , src_doc.org_id SOURCE_DOCUMENT_ORG_ID , prl.document_type_code SOURCE_DOC_TYPE_CODE , NVL(src_doc.global_agreement_flag, 'N') GLOBAL_FLAG , DECODE (src_doc.global_agreement_flag, 'Y', 'GlobalY', 'GlobalN') GLOBAL , DECODE (prl.blanket_po_header_id, NULL, 'N', 'Y') REQ_SOURCED_FLAG , prl.oke_contract_header_id OKE_CONTRACT_HEADER_ID , prl.assignment_start_date ASSIGNMENT_START_DATE , DECODE (prl.new_supplier_flag, 'Y', 'NewSupplierY', 'NewSupplierN') NEW_SUPPLIER , NVL(prl.new_supplier_flag, 'N') NEW_SUPPLIER_FLAG , prl.supplier_ref_number SUPPLIER_CONFIG_ID , prl.suggested_vendor_contact_email SUGGESTED_VENDOR_EMAIL , prl.suggested_vendor_contact_fax SUGGESTED_VENDOR_FAX , prl.suggested_vendor_product_code SUPPLIER_ITEM , prl.ussgl_transaction_code TRANSACTION_CODE , prl.transaction_reason_code TRANSACTION_REASON , plttl.line_type LINE_TYPE_DSP , pltb.line_type_id LINE_TYPE_ID , pltb.order_type_lookup_code ORDER_TYPE_LOOKUP_CODE , pltb.purchase_basis PURCHASE_BASIS , pltb.matching_basis MATCHING_BASIS , prl.labor_req_line_id LABOR_REQ_LINE_ID , DECODE (prl.suggested_buyer_id, NULL, 'Y', 'N') UNASSIGNED_FLAG , prl.un_number_id UN_NUMBER_ID , DECODE (prl.urgent_flag, 'Y', 'UrgentY', 'UrgentN') URGENT , NVL(prl.urgent_flag, 'N') URGENT_FLAG , DECODE (prl.vmi_flag, 'Y', 'VmiY', 'VmiN') VMI , NVL(prl.vmi_flag, 'N') VMI_FLAG , prl.wip_entity_id WIP_ENTITY_ID , prl.wip_line_id WIP_LINE_ID , NVL(prh.authorization_status, 'INCOMPLETE') AUTHORIZATION_STATUS , prl.attribute_category ATTRIBUTE_CATEGORY , prl.attribute1 ATTRIBUTE1 , prl.attribute2 ATTRIBUTE2 , prl.attribute3 ATTRIBUTE3 , prl.attribute4 ATTRIBUTE4 , prl.attribute5 ATTRIBUTE5 , prl.attribute6 ATTRIBUTE6 , prl.attribute7 ATTRIBUTE7 , prl.attribute8 ATTRIBUTE8 , prl.attribute9 ATTRIBUTE9 , prl.attribute10 ATTRIBUTE10 , prl.attribute11 ATTRIBUTE11 , prl.attribute12 ATTRIBUTE12 , prl.attribute13 ATTRIBUTE13 , prl.attribute14 ATTRIBUTE14 , prl.attribute15 ATTRIBUTE15 , req_fsp.inventory_organization_id BASE_INV_ORGANIZATION_ID , prl.auction_header_id AUCTION_HEADER_ID , prh.segment1 ||', ' || prl.line_num REQUEST , nvl( msi.concatenated_segments, prl.item_description) ITEM , decode(pltb.purchase_basis, 'GOODS', prl.unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.unit_price) , 'TEMP LABOR', prl.unit_price ) PRICE , prl.vendor_contact_id VENDOR_CONTACT_ID , prl.PARENT_REQ_LINE_ID , prl.source_type_code , ( SELECT 'Y' FROM dual WHERE exists ( SELECT 'Y' FROM po_req_distributions_all prd WHERE prd.requisition_line_id=prl.requisition_line_id AND prd.award_id is not null ) )AWARD_EXISTS , prl.kanban_card_id , src_doc.style_id SOURCE_DOCUMENT_STYLE_ID , src_doc_line.po_line_id SOURCE_DOCUMENT_LINE_ID FROM po_requisition_headers_all prh, po_requisition_lines prl, hr_all_organization_units_tl hou, po_line_types_tl plttl, po_line_types_b pltb, po_headers_all src_doc, po_lines_all src_doc_line, hr_all_organization_units_tl dst_hou, mtl_system_items_b_kfv msi, mtl_categories_kfv mc, per_all_people_f buyer, per_all_people_f requester, per_all_people_f preparer, hr_locations_all_tl deliver_hrtl, hr_locations_all deliver_hr, hz_locations deliver_hz, financials_system_params_all req_fsp, gl_sets_of_books req_sob WHERE prl.requisition_header_id = prh.requisition_header_id AND hou.organization_id (+) = prl.org_id AND req_fsp.org_id = prl.org_id AND hou.language (+) = userenv('LANG') AND pltb.line_type_id = prl.line_type_id AND plttl.line_type_id = pltb.line_type_ id AND plttl.language = userenv('LANG') AND src_doc.po_header_id (+) = prl.blanket_po_header_id AND src_doc_line.po_header_id(+) = prl.blanket_po_header_id AND src_doc_line.line_num(+) = prl.blanket_po_line_num AND dst_hou.organization_id (+) = prl.destination_organization_id AND dst_hou.language (+) = userenv('LANG') AND msi.inventory_item_id (+) = prl.item_id AND msi.organization_id (+) = prl.destination_organization_id AND mc.category_id = prl.category_id AND buyer.person_id (+) = prl.suggested_buyer_id AND TRUNC(sysdate) BETWEEN buyer.effective_start_date(+) AND buyer.effective_end_date(+) AND requester.person_id = prl.to_person_id AND TRUNC(sysdate) BETWEEN requester.effective_start_date AND requester.effective_end_date AND preparer.person_id = prh.preparer_id AND TRUNC(sysdate) BETWEEN preparer.effective_start_date AND preparer.effective_end_date AND deliver_hr.location_id(+) = prl.deliver_to_location_id AND deliver_hrtl.location_id (+) = deliver_hr.location_id AND deliver_hrtl.language (+) = USERENV('LANG') AND deliver_hz.location_id(+) = prl.deliver_to_location_id AND req_fsp.set_of_books_id = req_sob.set_of_books_id AND prl.reqs_in_pool_flag = 'Y' AND ( NOT (pltb.order_type_lookup_code = 'RATE' AND pltb.purchase_basis = 'TEMP LABOR' AND EXISTS (SELECT 'Corresponding expense line not in pool' FROM po_requisition_lines_all expense_line WHERE expense_line.labor_req_line_id = prl.requisition_line_id AND expense_line.reqs_in_pool_flag is null))) AND ( NOT (pltb.order_type_lookup_code = 'FIXED PRICE' AND pltb.purchase_basis = 'SERVICES' AND EXISTS (SELECT 'Corresponding labor line not in pool' FROM po_requisition_lines_all labor_line WHERE labor_line.requisition_line_id = prl.labor_req_line_id AND labor_line.reqs_in_pool_flag is null))) AND NVL(prh.authorization_status, 'INCOMPLETE') NOT IN ('SYSTEM_SAVED', 'RETURNED') AND prl.requisition_line_id NOT IN (SELECT doc_builder.index_num1 FROM po_session_gt doc_builder WHERE doc_builder.key = :1) AND DECODE(FND_PROFILE.VALUE('PO_AUTOCREATE_ALLOW_BUYER_OVERRIDE'), 'Y', FND_GLOBAL.EMPLOYEE_ID, 'N', PRL.SUGGESTED_BUYER_ID, FND_GLOBAL.EMPLOYEE_ID)=FND_GLOBAL.EMPLOYEE_ID) QRSLT WHERE ((suggested_buyer_id = :2 AND ship_to_location_id = :3)) ORDER BY CREATION_DATE desc, ORGANIZATION, TO_NUMBER(REQUISITION_NUM) DESC, REQUISITION_LINE_NUM DESC
4md5yxcm3xmuy MERGE INTO PO_HEADERS_ALL PH USING ( SELECT PHD.DRAFT_ID, PHD.DELETE_FLAG, PHD.CHANGE_ACCEPTED_FLAG, PHD.PO_HEADER_ID, PHD.AGENT_ID, PHD.TYPE_LOOKUP_CODE, PHD.LAST_UPDATE_DATE, PHD.LAST_UPDATED_BY, PHD.SEGMENT1, PHD.SUMMARY_FLAG, PHD.ENABLED_FLAG, PHD.SEGMENT2, PHD.SEGMENT3, PHD.SEGMENT4, PHD.SEGMENT5, PHD.START_DATE_ACTIVE, PHD.END_DATE_ACTIVE, PHD.LAST_UPDATE_LOGIN, PHD.CREATION_DATE, PHD.CREATED_BY, PHD.VENDOR_ID, PHD.VENDOR_SITE_ID, PHD.VENDOR_CONTACT_ID, PHD.SHIP_TO_LOCATION_ID, PHD.BILL_TO_LOCATION_ID, PHD.TERMS_ID, PHD.SHIP_VIA_LOOKUP_CODE, PHD.FOB_LOOKUP_CODE, PHD.FREIGHT_TERMS_LOOKUP_CODE, PHD.STATUS_LOOKUP_CODE, PHD.CURRENCY_CODE, PHD.RATE_TYPE, PHD.RATE_DATE, PHD.RATE, PHD.FROM_HEADER_ID, PHD.FROM_TYPE_LOOKUP_CODE, PHD.START_DATE, PHD.END_DATE, PHD.BLANKET_TOTAL_AMOUNT, PHD.AUTHORIZATION_STATUS, PHD.REVISION_NUM, PHD.REVISED_DATE, PHD.APPROVED_FLAG, PHD.APPROVED_DATE, PHD.AMOUNT_LIMIT, PHD.MIN_RELEASE_AMOUNT, PHD.NOTE_TO_AUTHORIZER, PHD.NOTE_TO_VENDOR, PHD.NOTE_TO_RECEIVER, PHD.PRINT_COUNT, PHD.PRINTED_DATE, PHD.VENDOR_ORDER_NUM, PHD.CONFIRMING_ORDER_FLAG, PHD.COMMENTS, PHD.REPLY_DATE, PHD.REPLY_METHOD_LOOKUP_CODE, PHD.RFQ_CLOSE_DATE, PHD.QUOTE_TYPE_LOOKUP_CODE, PHD.QUOTATION_CLASS_CODE, PHD.QUOTE_WARNING_DELAY_UNIT, PHD.QUOTE_WARNING_DELAY, PHD.QUOTE_VENDOR_QUOTE_NUMBER, PHD.ACCEPTANCE_REQUIRED_FLAG, PHD.ACCEPTANCE_DUE_DATE, PHD.CLOSED_DATE, PHD.USER_HOLD_FLAG, PHD.APPROVAL_REQUIRED_FLAG, PHD.CANCEL_FLAG, PHD.FIRM_STATUS_LOOKUP_CODE, PHD.FIRM_DATE, PHD.FROZEN_FLAG, PHD.SUPPLY_AGREEMENT_FLAG, PHD.EDI_PROCESSED_FLAG, PHD.EDI_PROCESSED_STATUS, PHD.ATTRIBUTE_CATEGORY, PHD.ATTRIBUTE1, PHD.ATTRIBUTE2, PHD.ATTRIBUTE3, PHD.ATTRIBUTE4, PHD.ATTRIBUTE5, PHD.ATTRIBUTE6, PHD.ATTRIBUTE7, PHD.ATTRIBUTE8, PHD.ATTRIBUTE9, PHD.ATTRIBUTE10, PHD.ATTRIBUTE11, PHD.ATTRIBUTE12, PHD.ATTRIBUTE13, PHD.ATTRIBUTE14, PHD.ATTRIBUTE15, PHD.CLOSED_CODE, PHD.USSGL_TRANSACTION_CODE, PHD.GOVERNMENT_CONTEXT, PHD.REQUEST_ID, PHD.PROGRAM_APPLICATION_ID, PHD.PROGRAM_ID, PHD.PROGRAM_UPDATE_DATE, PHD.ORG_ID, PHD.GLOBAL_ATTRIBUTE_CATEGORY, PHD.GLOBAL_ATTRIBUTE1, PHD.GLOBAL_ATTRIBUTE2, PHD.GLOBAL_ATTRIBUTE3, PHD.GLOBAL_ATTRIBUTE4, PHD.GLOBAL_ATTRIBUTE5, PHD.GLOBAL_ATTRIBUTE6, PHD.GLOBAL_ATTRIBUTE7, PHD.GLOBAL_ATTRIBUTE8, PHD.GLOBAL_ATTRIBUTE9, PHD.GLOBAL_ATTRIBUTE10, PHD.GLOBAL_ATTRIBUTE11, PHD.GLOBAL_ATTRIBUTE12, PHD.GLOBAL_ATTRIBUTE13, PHD.GLOBAL_ATTRIBUTE14, PHD.GLOBAL_ATTRIBUTE15, PHD.GLOBAL_ATTRIBUTE16, PHD.GLOBAL_ATTRIBUTE17, PHD.GLOBAL_ATTRIBUTE18, PHD.GLOBAL_ATTRIBUTE19, PHD.GLOBAL_ATTRIBUTE20, PHD.INTERFACE_SOURCE_CODE, PHD.REFERENCE_NUM, PHD.WF_ITEM_TYPE, PHD.WF_ITEM_KEY, PHD.MRC_RATE_TYPE, PHD.MRC_RATE_DATE, PHD.MRC_RATE, PHD.PCARD_ID, PHD.PRICE_UPDATE_TOLERANCE, PHD.PAY_ON_CODE, PHD.XML_FLAG, PHD.XML_SEND_DATE, PHD.XML_CHANGE_SEND_DATE, PHD.GLOBAL_AGREEMENT_FLAG, PHD.CONSIGNED_CONSUMPTION_FLAG, PHD.CBC_ACCOUNTING_DATE, PHD.CONSUME_REQ_DEMAND_FLAG, PHD.CHANGE_REQUESTED_BY, PHD.SHIPPING_CONTROL, PHD.CONTERMS_EXIST_FLAG, PHD.CONTERMS_ARTICLES_UPD_DATE, PHD.CONTERMS_DELIV_UPD_DATE, PHD.ENCUMBRANCE_REQUIRED_FLAG, PHD.PENDING_SIGNATURE_FLAG, PHD.CHANGE_SUMMARY, PHD.DOCUMENT_CREATION_METHOD, PHD.SUBMIT_DATE, PHD.SUPPLIER_NOTIF_METHOD, PHD.FAX, PHD.EMAIL_ADDRESS, PHD.RETRO_PRICE_COMM_UPDATES_FLAG, PHD.RETRO_PRICE_APPLY_UPDATES_FLAG, PHD.UPDATE_SOURCING_RULES_FLAG, PHD.AUTO_SOURCING_FLAG, PHD.CREATED_LANGUAGE, PHD.CPA_REFERENCE, PHD.STYLE_ID, PHD.TAX_ATTRIBUTE_UPDATE_CODE, PHD.PAY_WHEN_PAID FROM PO_HEADERS_DRAFT_ALL PHD WHERE PHD.DRAFT_ID = :B1 AND NVL(PHD.CHANGE_ACCEPTED_FLAG, 'Y') = 'Y' ) PHDV ON (PH.PO_HEADER_ID = PHDV.PO_HEADER_ID) WHEN MATCHED THEN UPDATE SET PH.AGENT_ID = PHDV.AGENT_ID, PH.TYPE_LOOKUP_CODE = PHDV.TYPE_LOOKUP_CODE, PH.LAST_UPDATE_DATE = PHDV.LAST_UPDATE_DATE, PH.LAST_UPDATED_BY = PHDV.LAST_UPDATED_BY, PH.SEGMENT1 = PHDV.SEGMENT1, PH.SUMMARY_FLAG = PHDV.SUMMARY_FLAG, PH.EN ABLED_FLAG = PHDV.ENABLED_FLAG, PH.SEGMENT2 = PHDV.SEGMENT2, PH.SEGMENT3 = PHDV.SEGMENT3, PH.SEGMENT4 = PHDV.SEGMENT4, PH.SEGMENT5 = PHDV.SEGMENT5, PH.START_DATE_ACTIVE = PHDV.START_DATE_ACTIVE, PH.END_DATE_ACTIVE = PHDV.END_DATE_ACTIVE, PH.LAST_UPDATE_LOGIN = PHDV.LAST_UPDATE_LOGIN, PH.VENDOR_ID = PHDV.VENDOR_ID, PH.VENDOR_SITE_ID = PHDV.VENDOR_SITE_ID, PH.VENDOR_CONTACT_ID = PHDV.VENDOR_CONTACT_ID, PH.SHIP_TO_LOCATION_ID = PHDV.SHIP_TO_LOCATION_ID, PH.BILL_TO_LOCATION_ID = PHDV.BILL_TO_LOCATION_ID, PH.TERMS_ID = PHDV.TERMS_ID, PH.SHIP_VIA_LOOKUP_CODE = PHDV.SHIP_VIA_LOOKUP_CODE, PH.FOB_LOOKUP_CODE = PHDV.FOB_LOOKUP_CODE, PH.FREIGHT_TERMS_LOOKUP_CODE = PHDV.FREIGHT_TERMS_LOOKUP_CODE, PH.STATUS_LOOKUP_CODE = PHDV.STATUS_LOOKUP_CODE, PH.CURRENCY_CODE = PHDV.CURRENCY_CODE, PH.RATE_TYPE = PHDV.RATE_TYPE, PH.RATE_DATE = PHDV.RATE_DATE, PH.RATE = PHDV.RATE, PH.FROM_HEADER_ID = PHDV.FROM_HEADER_ID, PH.FROM_TYPE_LOOKUP_CODE = PHDV.FROM_TYPE_LOOKUP_CODE, PH.START_DATE = PHDV.START_DATE, PH.END_DATE = PHDV.END_DATE, PH.BLANKET_TOTAL_AMOUNT = PHDV.BLANKET_TOTAL_AMOUNT, PH.AUTHORIZATION_STATUS = PHDV.AUTHORIZATION_STATUS, PH.REVISION_NUM = PHDV.REVISION_NUM, PH.REVISED_DATE = PHDV.REVISED_DATE, PH.APPROVED_FLAG = PHDV.APPROVED_FLAG, PH.APPROVED_DATE = PHDV.APPROVED_DATE, PH.AMOUNT_LIMIT = PHDV.AMOUNT_LIMIT, PH.MIN_RELEASE_AMOUNT = PHDV.MIN_RELEASE_AMOUNT, PH.NOTE_TO_AUTHORIZER = PHDV.NOTE_TO_AUTHORIZER, PH.NOTE_TO_VENDOR = PHDV.NOTE_TO_VENDOR, PH.NOTE_TO_RECEIVER = PHDV.NOTE_TO_RECEIVER, PH.PRINT_COUNT = PHDV.PRINT_COUNT, PH.PRINTED_DATE = PHDV.PRINTED_DATE, PH.VENDOR_ORDER_NUM = PHDV.VENDOR_ORDER_NUM, PH.CONFIRMING_ORDER_FLAG = PHDV.CONFIRMING_ORDER_FLAG, PH.COMMENTS = PHDV.COMMENTS, PH.REPLY_DATE = PHDV.REPLY_DATE, PH.REPLY_METHOD_LOOKUP_CODE = PHDV.REPLY_METHOD_LOOKUP_CODE, PH.RFQ_CLOSE_DATE = PHDV.RFQ_CLOSE_DATE, PH.QUOTE_TYPE_LOOKUP_CODE = PHDV.QUOTE_TYPE_LOOKUP_CODE, PH.QUOTATION_CLASS_CODE = PHDV.QUOTATION_CLASS_CODE, PH.QUOTE_WARNING_DELAY_UNIT = PHDV.QUOTE_WARNING_DELAY_UNIT, PH.QUOTE_WARNING_DELAY = PHDV.QUOTE_WARNING_DELAY, PH.QUOTE_VENDOR_QUOTE_NUMBER = PHDV.QUOTE_VENDOR_QUOTE_NUMBER, PH.ACCEPTANCE_REQUIRED_FLAG = PHDV.ACCEPTANCE_REQUIRED_FLAG, PH.ACCEPTANCE_DUE_DATE = PHDV.ACCEPTANCE_DUE_DATE, PH.CLOSED_DATE = PHDV.CLOSED_DATE, PH.USER_HOLD_FLAG = PHDV.USER_HOLD_FLAG, PH.APPROVAL_REQUIRED_FLAG = PHDV.APPROVAL_REQUIRED_FLAG, PH.CANCEL_FLAG = PHDV.CANCEL_FLAG, PH.FIRM_STATUS_LOOKUP_CODE = PHDV.FIRM_STATUS_LOOKUP_CODE, PH.FIRM_DATE = PHDV.FIRM_DATE, PH.FROZEN_FLAG = PHDV.FROZEN_FLAG, PH.SUPPLY_AGREEMENT_FLAG = PHDV.SUPPLY_AGREEMENT_FLAG, PH.ATTRIBUTE_CATEGORY = PHDV.ATTRIBUTE_CATEGORY, PH.ATTRIBUTE1 = PHDV.ATTRIBUTE1, PH.ATTRIBUTE2 = PHDV.ATTRIBUTE2, PH.ATTRIBUTE3 = PHDV.ATTRIBUTE3, PH.ATTRIBUTE4 = PHDV.ATTRIBUTE4, PH.ATTRIBUTE5 = PHDV.ATTRIBUTE5, PH.ATTRIBUTE6 = PHDV.ATTRIBUTE6, PH.ATTRIBUTE7 = PHDV.ATTRIBUTE7, PH.ATTRIBUTE8 = PHDV.ATTRIBUTE8, PH.ATTRIBUTE9 = PHDV.ATTRIBUTE9, PH.ATTRIBUTE10 = PHDV.ATTRIBUTE10, PH.ATTRIBUTE11 = PHDV.ATTRIBUTE11, PH.ATTRIBUTE12 = PHDV.ATTRIBUTE12, PH.ATTRIBUTE13 = PHDV.ATTRIBUTE13, PH.ATTRIBUTE14 = PHDV.ATTRIBUTE14, PH.ATTRIBUTE15 = PHDV.ATTRIBUTE15, PH.CLOSED_CODE = PHDV.CLOSED_CODE, PH.USSGL_TRANSACTION_CODE = PHDV.USSGL_TRANSACTION_CODE, PH.GOVERNMENT_CONTEXT = PHDV.GOVERNMENT_CONTEXT, PH.REQUEST_ID = PHDV.REQUEST_ID, PH.PROGRAM_APPLICATION_ID = PHDV.PROGRAM_APPLICATION_ID, PH.PROGRAM_ID = PHDV.PROGRAM_ID, PH.PROGRAM_UPDATE_DATE = PHDV.PROGRAM_UPDATE_DATE, PH.ORG_ID = PHDV.ORG_ID, PH.GLOBAL_ATTRIBUTE_CATEGORY = PHDV.GLOBAL_ATTRIBUTE_CATEGORY, PH.GLOBAL_ATTRIBUTE1 = PHDV.GLOBAL_ATTRIBUTE1, PH.GLOBAL_ATTRIBUTE2 = PHDV.GLOBAL_ATTRIBUTE2, PH.GLOBAL_ATTRIBUTE3 = PHDV.GLOBAL_ATTRIBUTE3, PH.GLOBAL_ATTRIBUTE4 = PHDV.GLOBAL_ATTRIBUTE4, PH.GLOBAL_ATTRIBUTE5 = PHDV.GLOBAL_ATTRIBUTE5, PH.GLOBAL_ATTRIBUTE6 = PHDV.GLOBAL_ATTRIBUTE6, PH.GLOBAL_ATTRIBUTE7 = PHDV.GLOBAL_ATTRIBUTE7, PH.GLOBAL_ATTRIBUTE8 = PHDV.GLOBAL_AT TRIBUTE8, PH.GLOBAL_ATTRIBUTE9 = PHDV.GLOBAL_ATTRIBUTE9, PH.GLOBAL_ATTRIBUTE10 = PHDV.GLOBAL_ATTRIBUTE10, PH.GLOBAL_ATTRIBUTE11 = PHDV.GLOBAL_ATTRIBUTE11, PH.GLOBAL_ATTRIBUTE12 = PHDV.GLOBAL_ATTRIBUTE12, PH.GLOBAL_ATTRIBUTE13 = PHDV.GLOBAL_ATTRIBUTE13, PH.GLOBAL_ATTRIBUTE14 = PHDV.GLOBAL_ATTRIBUTE14, PH.GLOBAL_ATTRIBUTE15 = PHDV.GLOBAL_ATTRIBUTE15, PH.GLOBAL_ATTRIBUTE16 = PHDV.GLOBAL_ATTRIBUTE16, PH.GLOBAL_ATTRIBUTE17 = PHDV.GLOBAL_ATTRIBUTE17, PH.GLOBAL_ATTRIBUTE18 = PHDV.GLOBAL_ATTRIBUTE18, PH.GLOBAL_ATTRIBUTE19 = PHDV.GLOBAL_ATTRIBUTE19, PH.GLOBAL_ATTRIBUTE20 = PHDV.GLOBAL_ATTRIBUTE20, PH.PCARD_ID = PHDV.PCARD_ID, PH.PRICE_UPDATE_TOLERANCE = PHDV.PRICE_UPDATE_TOLERANCE, PH.PAY_ON_CODE = PHDV.PAY_ON_CODE, PH.CHANGE_REQUESTED_BY = PHDV.CHANGE_REQUESTED_BY, PH.SHIPPING_CONTROL = PHDV.SHIPPING_CONTROL, PH.CONTERMS_ARTICLES_UPD_DATE = PHDV.CONTERMS_ARTICLES_UPD_DATE, PH.CONTERMS_DELIV_UPD_DATE = PHDV.CONTERMS_DELIV_UPD_DATE, PH.ENCUMBRANCE_REQUIRED_FLAG = PHDV.ENCUMBRANCE_REQUIRED_FLAG, PH.SUPPLIER_NOTIF_METHOD = PHDV.SUPPLIER_NOTIF_METHOD, PH.FAX = PHDV.FAX, PH.EMAIL_ADDRESS = PHDV.EMAIL_ADDRESS, PH.RETRO_PRICE_COMM_UPDATES_FLAG = PHDV.RETRO_PRICE_COMM_UPDATES_FLAG, PH.RETRO_PRICE_APPLY_UPDATES_FLAG = PHDV.RETRO_PRICE_APPLY_UPDATES_FLAG, PH.UPDATE_SOURCING_RULES_FLAG = PHDV.UPDATE_SOURCING_RULES_FLAG, PH.AUTO_SOURCING_FLAG = PHDV.AUTO_SOURCING_FLAG, PH.TAX_ATTRIBUTE_UPDATE_CODE = PHDV.TAX_ATTRIBUTE_UPDATE_CODE, PH.PAY_WHEN_PAID = PHDV.PAY_WHEN_PAID WHEN NOT MATCHED THEN INSERT ( PH.PO_HEADER_ID, PH.AGENT_ID, PH.TYPE_LOOKUP_CODE, PH.LAST_UPDATE_DATE, PH.LAST_UPDATED_BY, PH.SEGMENT1, PH.SUMMARY_FLAG, PH.ENABLED_FLAG, PH.SEGMENT2, PH.SEGMENT3, PH.SEGMENT4, PH.SEGMENT5, PH.START_DATE_ACTIVE, PH.END_DATE_ACTIVE, PH.LAST_UPDATE_LOGIN, PH.CREATION_DATE, PH.CREATED_BY, PH.VENDOR_ID, PH.VENDOR_SITE_ID, PH.VENDOR_CONTACT_ID, PH.SHIP_TO_LOCATION_ID, PH.BILL_TO_LOCATION_ID, PH.TERMS_ID, PH.SHIP_VIA_LOOKUP_CODE, PH.FOB_LOOKUP_CODE, PH.FREIGHT_TERMS_LOOKUP_CODE, PH.STATUS_LOOKUP_CODE, PH.CURRENCY_CODE, PH.RATE_TYPE, PH.RATE_DATE, PH.RATE, PH.FROM_HEADER_ID, PH.FROM_TYPE_LOOKUP_CODE, PH.START_DATE, PH.END_DATE, PH.BLANKET_TOTAL_AMOUNT, PH.AUTHORIZATION_STATUS, PH.REVISION_NUM, PH.REVISED_DATE, PH.APPROVED_FLAG, PH.APPROVED_DATE, PH.AMOUNT_LIMIT, PH.MIN_RELEASE_AMOUNT, PH.NOTE_TO_AUTHORIZER, PH.NOTE_TO_VENDOR, PH.NOTE_TO_RECEIVER, PH.PRINT_COUNT, PH.PRINTED_DATE, PH.VENDOR_ORDER_NUM, PH.CONFIRMING_ORDER_FLAG, PH.COMMENTS, PH.REPLY_DATE, PH.REPLY_METHOD_LOOKUP_CODE, PH.RFQ_CLOSE_DATE, PH.QUOTE_TYPE_LOOKUP_CODE, PH.QUOTATION_CLASS_CODE, PH.QUOTE_WARNING_DELAY_UNIT, PH.QUOTE_WARNING_DELAY, PH.QUOTE_VENDOR_QUOTE_NUMBER, PH.ACCEPTANCE_REQUIRED_FLAG, PH.ACCEPTANCE_DUE_DATE, PH.CLOSED_DATE, PH.USER_HOLD_FLAG, PH.APPROVAL_REQUIRED_FLAG, PH.CANCEL_FLAG, PH.FIRM_STATUS_LOOKUP_CODE, PH.FIRM_DATE, PH.FROZEN_FLAG, PH.SUPPLY_AGREEMENT_FLAG, PH.EDI_PROCESSED_FLAG, PH.EDI_PROCESSED_STATUS, PH.ATTRIBUTE_CATEGORY, PH.ATTRIBUTE1, PH.ATTRIBUTE2, PH.ATTRIBUTE3, PH.ATTRIBUTE4, PH.ATTRIBUTE5, PH.ATTRIBUTE6, PH.ATTRIBUTE7, PH.ATTRIBUTE8, PH.ATTRIBUTE9, PH.ATTRIBUTE10, PH.ATTRIBUTE11, PH.ATTRIBUTE12, PH.ATTRIBUTE13, PH.ATTRIBUTE14, PH.ATTRIBUTE15, PH.CLOSED_CODE, PH.USSGL_TRANSACTION_CODE, PH.GOVERNMENT_CONTEXT, PH.REQUEST_ID, PH.PROGRAM_APPLICATION_ID, PH.PROGRAM_ID, PH.PROGRAM_UPDATE_DATE, PH.ORG_ID, PH.GLOBAL_ATTRIBUTE_CATEGORY, PH.GLOBAL_ATTRIBUTE1, PH.GLOBAL_ATTRIBUTE2, PH.GLOBAL_ATTRIBUTE3, PH.GLOBAL_ATTRIBUTE4, PH.GLOBAL_ATTRIBUTE5, PH.GLOBAL_ATTRIBUTE6, PH.GLOBAL_ATTRIBUTE7, PH.GLOBAL_ATTRIBUTE8, PH.GLOBAL_ATTRIBUTE9, PH.GLOBAL_ATTRIBUTE10, PH.GLOBAL_ATTRIBUTE11, PH.GLOBAL_ATTRIBUTE12, PH.GLOBAL_ATTRIBUTE13, PH.GLOBAL_ATTRIBUTE14, PH.GLOBAL_ATTRIBUTE15, PH.GLOBAL_ATTRIBUTE16, PH.GLOBAL_ATTRIBUTE17, PH.GLOBAL_ATTRIBUTE18, PH.GLOBAL_ATTRIBUTE19, PH.GLOBAL_ATTRIBUTE20, PH.INTERFACE_SOURCE_CODE, PH.REFERENCE_NUM, PH.WF_ ITEM_TYPE, PH.WF_ITEM_KEY, PH.MRC_RATE_TYPE, PH.MRC_RATE_DATE, PH.MRC_RATE, PH.PCARD_ID, PH.PRICE_UPDATE_TOLERANCE, PH.PAY_ON_CODE, PH.XML_FLAG, PH.XML_SEND_DATE, PH.XML_CHANGE_SEND_DATE, PH.GLOBAL_AGREEMENT_FLAG, PH.CONSIGNED_CONSUMPTION_FLAG, PH.CBC_ACCOUNTING_DATE, PH.CONSUME_REQ_DEMAND_FLAG, PH.CHANGE_REQUESTED_BY, PH.SHIPPING_CONTROL, PH.CONTERMS_EXIST_FLAG, PH.CONTERMS_ARTICLES_UPD_DATE, PH.CONTERMS_DELIV_UPD_DATE, PH.ENCUMBRANCE_REQUIRED_FLAG, PH.PENDING_SIGNATURE_FLAG, PH.CHANGE_SUMMARY, PH.DOCUMENT_CREATION_METHOD, PH.SUBMIT_DATE, PH.SUPPLIER_NOTIF_METHOD, PH.FAX, PH.EMAIL_ADDRESS, PH.RETRO_PRICE_COMM_UPDATES_FLAG, PH.RETRO_PRICE_APPLY_UPDATES_FLAG, PH.UPDATE_SOURCING_RULES_FLAG, PH.AUTO_SOURCING_FLAG, PH.CREATED_LANGUAGE, PH.CPA_REFERENCE, PH.STYLE_ID, PH.TAX_ATTRIBUTE_UPDATE_CODE, PH.PAY_WHEN_PAID ) VALUES ( PHDV.PO_HEADER_ID, PHDV.AGENT_ID, PHDV.TYPE_LOOKUP_CODE, PHDV.LAST_UPDATE_DATE, PHDV.LAST_UPDATED_BY, PHDV.SEGMENT1, PHDV.SUMMARY_FLAG, PHDV.ENABLED_FLAG, PHDV.SEGMENT2, PHDV.SEGMENT3, PHDV.SEGMENT4, PHDV.SEGMENT5, PHDV.START_DATE_ACTIVE, PHDV.END_DATE_ACTIVE, PHDV.LAST_UPDATE_LOGIN, PHDV.CREATION_DATE, PHDV.CREATED_BY, PHDV.VENDOR_ID, PHDV.VENDOR_SITE_ID, PHDV.VENDOR_CONTACT_ID, PHDV.SHIP_TO_LOCATION_ID, PHDV.BILL_TO_LOCATION_ID, PHDV.TERMS_ID, PHDV.SHIP_VIA_LOOKUP_CODE, PHDV.FOB_LOOKUP_CODE, PHDV.FREIGHT_TERMS_LOOKUP_CODE, PHDV.STATUS_LOOKUP_CODE, PHDV.CURRENCY_CODE, PHDV.RATE_TYPE, PHDV.RATE_DATE, PHDV.RATE, PHDV.FROM_HEADER_ID, PHDV.FROM_TYPE_LOOKUP_CODE, PHDV.START_DATE, PHDV.END_DATE, PHDV.BLANKET_TOTAL_AMOUNT, PHDV.AUTHORIZATION_STATUS, PHDV.REVISION_NUM, PHDV.REVISED_DATE, PHDV.APPROVED_FLAG, PHDV.APPROVED_DATE, PHDV.AMOUNT_LIMIT, PHDV.MIN_RELEASE_AMOUNT, PHDV.NOTE_TO_AUTHORIZER, PHDV.NOTE_TO_VENDOR, PHDV.NOTE_TO_RECEIVER, PHDV.PRINT_COUNT, PHDV.PRINTED_DATE, PHDV.VENDOR_ORDER_NUM, PHDV.CONFIRMING_ORDER_FLAG, PHDV.COMMENTS, PHDV.REPLY_DATE, PHDV.REPLY_METHOD_LOOKUP_CODE, PHDV.RFQ_CLOSE_DATE, PHDV.QUOTE_TYPE_LOOKUP_CODE, PHDV.QUOTATION_CLASS_CODE, PHDV.QUOTE_WARNING_DELAY_UNIT, PHDV.QUOTE_WARNING_DELAY, PHDV.QUOTE_VENDOR_QUOTE_NUMBER, PHDV.ACCEPTANCE_REQUIRED_FLAG, PHDV.ACCEPTANCE_DUE_DATE, PHDV.CLOSED_DATE, PHDV.USER_HOLD_FLAG, PHDV.APPROVAL_REQUIRED_FLAG, PHDV.CANCEL_FLAG, PHDV.FIRM_STATUS_LOOKUP_CODE, PHDV.FIRM_DATE, PHDV.FROZEN_FLAG, PHDV.SUPPLY_AGREEMENT_FLAG, PHDV.EDI_PROCESSED_FLAG, PHDV.EDI_PROCESSED_STATUS, PHDV.ATTRIBUTE_CATEGORY, PHDV.ATTRIBUTE1, PHDV.ATTRIBUTE2, PHDV.ATTRIBUTE3, PHDV.ATTRIBUTE4, PHDV.ATTRIBUTE5, PHDV.ATTRIBUTE6, PHDV.ATTRIBUTE7, PHDV.ATTRIBUTE8, PHDV.ATTRIBUTE9, PHDV.ATTRIBUTE10, PHDV.ATTRIBUTE11, PHDV.ATTRIBUTE12, PHDV.ATTRIBUTE13, PHDV.ATTRIBUTE14, PHDV.ATTRIBUTE15, PHDV.CLOSED_CODE, PHDV.USSGL_TRANSACTION_CODE, PHDV.GOVERNMENT_CONTEXT, PHDV.REQUEST_ID, PHDV.PROGRAM_APPLICATION_ID, PHDV.PROGRAM_ID, PHDV.PROGRAM_UPDATE_DATE, PHDV.ORG_ID, PHDV.GLOBAL_ATTRIBUTE_CATEGORY, PHDV.GLOBAL_ATTRIBUTE1, PHDV.GLOBAL_ATTRIBUTE2, PHDV.GLOBAL_ATTRIBUTE3, PHDV.GLOBAL_ATTRIBUTE4, PHDV.GLOBAL_ATTRIBUTE5, PHDV.GLOBAL_ATTRIBUTE6, PHDV.GLOBAL_ATTRIBUTE7, PHDV.GLOBAL_ATTRIBUTE8, PHDV.GLOBAL_ATTRIBUTE9, PHDV.GLOBAL_ATTRIBUTE10, PHDV.GLOBAL_ATTRIBUTE11, PHDV.GLOBAL_ATTRIBUTE12, PHDV.GLOBAL_ATTRIBUTE13, PHDV.GLOBAL_ATTRIBUTE14, PHDV.GLOBAL_ATTRIBUTE15, PHDV.GLOBAL_ATTRIBUTE16, PHDV.GLOBAL_ATTRIBUTE17, PHDV.GLOBAL_ATTRIBUTE18, PHDV.GLOBAL_ATTRIBUTE19, PHDV.GLOBAL_ATTRIBUTE20, PHDV.INTERFACE_SOURCE_CODE, PHDV.REFERENCE_NUM, PHDV.WF_ITEM_TYPE, PHDV.WF_ITEM_KEY, PHDV.MRC_RATE_TYPE, PHDV.MRC_RATE_DATE, PHDV.MRC_RATE, PHDV.PCARD_ID, PHDV.PRICE_UPDATE_TOLERANCE, PHDV.PAY_ON_CODE, PHDV.XML_FLAG, PHDV.XML_SEND_DATE, PHDV.XML_CHANGE_SEND_DATE, PHDV.GLOBAL_AGREEMENT_FLAG, PHDV.CONSIGNED_CONSUMPTION_FLAG, PHDV.CBC_ACCOUNTING_DATE, PHDV.CONSUME_REQ_DEMAND_FLAG, PHDV.CHANGE_REQUESTED_BY, PHDV.SHIPPING_CONTROL, PHDV.CONTERMS_EXIST_FLAG, PHDV.CONT ERMS_ARTICLES_UPD_DATE, PHDV.CONTERMS_DELIV_UPD_DATE, PHDV.ENCUMBRANCE_REQUIRED_FLAG, PHDV.PENDING_SIGNATURE_FLAG, PHDV.CHANGE_SUMMARY, PHDV.DOCUMENT_CREATION_METHOD, PHDV.SUBMIT_DATE, PHDV.SUPPLIER_NOTIF_METHOD, PHDV.FAX, PHDV.EMAIL_ADDRESS, PHDV.RETRO_PRICE_COMM_UPDATES_FLAG, PHDV.RETRO_PRICE_APPLY_UPDATES_FLAG, PHDV.UPDATE_SOURCING_RULES_FLAG, PHDV.AUTO_SOURCING_FLAG, PHDV.CREATED_LANGUAGE, PHDV.CPA_REFERENCE, PHDV.STYLE_ID, PHDV.TAX_ATTRIBUTE_UPDATE_CODE, PHDV.PAY_WHEN_PAID ) WHERE NVL(PHDV.DELETE_FLAG, 'N') <> 'Y'
4mj8xhjcnw7gf SELECT "A2"."SHIPMENT_NUM" "SHIPMENT_NUM", "A2"."DUE_DATE" "DUE_DATE", "A2"."QUANTITY" "QUANTITY", "A2"."PRICE_OVERRIDE" "PRICE_OVERRIDE", "A2"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A2"."CANCEL_FLAG" "CANCEL_FLAG", "A2"."CANCEL_DATE" "CANCEL_DATE", "A2"."CANCEL_REASON" "CANCEL_REASON", "A2"."TAXABLE_FLAG" "TAXABLE_FLAG", "A2"."START_DATE" "START_DATE", "A2"."END_DATE" "END_DATE", "A2"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A2"."ATTRIBUTE1" "ATTRIBUTE1", "A2"."ATTRIBUTE2" "ATTRIBUTE2", "A2"."ATTRIBUTE3" "ATTRIBUTE3", "A2"."ATTRIBUTE4" "ATTRIBUTE4", "A2"."ATTRIBUTE5" "ATTRIBUTE5", "A2"."ATTRIBUTE6" "ATTRIBUTE6", "A2"."ATTRIBUTE7" "ATTRIBUTE7", "A2"."ATTRIBUTE8" "ATTRIBUTE8", "A2"."ATTRIBUTE9" "ATTRIBUTE9", "A2"."ATTRIBUTE10" "ATTRIBUTE10", "A2"."ATTRIBUTE11" "ATTRIBUTE11", "A2"."ATTRIBUTE12" "ATTRIBUTE12", "A2"."ATTRIBUTE13" "ATTRIBUTE13", "A2"."ATTRIBUTE14" "ATTRIBUTE14", "A2"."ATTRIBUTE15" "ATTRIBUTE15", "A2"."PO_HEADER_ID" "PO_HEADER_ID", "A2"."PO_LINE_ID" "PO_LINE_ID", "A2"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A2"."SHIPMENT_TYPE" "SHIPMENT_TYPE", "A2"."PO_RELEASE_ID" "PO_RELEASE_ID", "A2"."CONSIGNED_FLAG" "CONSIGNED_FLAG", "A2"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A2"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A2"."RECEIVING_ROUTING_ID" "RECEIVING_ROUTING_ID", "A2"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A2"."CLOSED_REASON" "CLOSED_REASON", "A2"."CLOSED_DATE" "CLOSED_DATE", "A2"."CLOSED_BY" "CLOSED_BY", "A2"."ORG_ID" "ORG_ID", "A2"."UNIT_OF_MEASURE_CLASS" "UNIT_OF_MEASURE_CLASS", "A2"."ENCUMBER_NOW" "ENCUMBER_NOW", "A2"."INSPECTION_REQUIRED_FLAG" "INSPECTION_REQUIRED_FLAG", "A2"."RECEIPT_REQUIRED_FLAG" "RECEIPT_REQUIRED_FLAG", "A2"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A2"."QTY_RCV_EXCEPTION_CODE" "QTY_RCV_EXCEPTION_CODE", "A2"."ENFORCE_SHIP_TO_LOCATION_CODE" "ENFORCE_SHIP_TO_LOCATION_CODE", "A2"."ALLOW_SUBSTITUTE_RECEIPTS_FLAG" "ALLOW_SUBSTITUTE_RECEIPTS_FLAG", "A2"."DAYS_EARLY_RECEIPT_ALLOWED" "DAYS_EARLY_RECEIPT_ALLOWED", "A2"."DAYS_LATE_RECEIPT_ALLOWED" "DAYS_LATE_RECEIPT_ALLOWED", "A2"."RECEIPT_DAYS_EXCEPTION_CODE" "RECEIPT_DAYS_EXCEPTION_CODE", "A2"."INVOICE_CLOSE_TOLERANCE" "INVOICE_CLOSE_TOLERANCE", "A2"."RECEIVE_CLOSE_TOLERANCE" "RECEIVE_CLOSE_TOLERANCE", "A2"."SHIP_TO_ORGANIZATION_ID" "SHIP_TO_ORGANIZATION_ID", "A2"."SOURCE_SHIPMENT_ID " "SOURCE_SHIPMENT_ID", "A2"."CLOSED_CODE" "CLOSED_CODE", "A2"."REQUEST_ID" "REQUEST_ID", "A2"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A2"."PROGRAM_ID" "PROGRAM_ID", "A2"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A2"."LAST_ACCEPT_DATE" "LAST_ACCEPT_DATE", "A2"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A2"."ENCUMBERED_DATE" "ENCUMBERED_DATE", "A2"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A2"."FOB_LOOKUP_CODE" "FOB_LOOKUP_CODE", "A2"."FREIGHT_TERMS_LOOKUP_CODE" "FREIGHT_TERMS_LOOKUP_CODE", "A2"."ESTIMATED_TAX_AMOUNT" "ESTIMATED_TAX_AMOUNT", "A2"."FROM_HEADER_ID" "FROM_HEADER_ID", "A2"."FROM_LINE_ID" "FROM_LINE_ID", "A2"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A2"."LEAD_TIME" "LEAD_TIME", "A2"."LEAD_TIME_UNIT" "LEAD_TIME_UNIT", "A2"."PRICE_DISCOUNT" "PRICE_DISCOUNT", "A2"."TERMS_ID" "TERMS_ID", "A2"."APPROVED_FLAG" "APPROVED_FLAG", "A2"."APPROVED_DATE" "APPROVED_DATE", "A2"."CLOSED_FLAG" "CLOSED_FLAG", "A2"."CANCELLED_BY" "CANCELLED_BY", "A2"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A2"."FIRM_DATE" "FIRM_DATE", "A2"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A2"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A2"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A2"."CREATION_DATE" "CREATION_DATE", "A2"."CREATED_BY" "CREATED_BY", "A2"."QUANTITY_RECEIVED" "QUANTITY_RECEIVED", "A2"."QUANTITY_ACCEPTED" "QUANTITY_ACCEPTED", "A2"."QUANTITY_REJECTED" "QUANTITY_REJECTED", "A2"."QUANTITY_BILLED" "QUANTITY_BILLED", "A2"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A2"."SHIP_VIA_LOOKUP_CODE" "SHIP_VIA_LOOKUP_CODE", "A2"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A2"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A2"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A2"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A2"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A2"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A2"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A2"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A2"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A2"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A2"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A2"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A2"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A2"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A2"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A2"."GLOBAL_ATTRIBUTE15" "GLOBAL_ATTRIBUTE15", "A2"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A2"."GLOBAL _ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A2"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A2"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A2"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A2"."QUANTITY_SHIPPED" "QUANTITY_SHIPPED", "A2"."COUNTRY_OF_ORIGIN_CODE" "COUNTRY_OF_ORIGIN_CODE", "A2"."TAX_USER_OVERRIDE_FLAG" "TAX_USER_OVERRIDE_FLAG", "A2"."MATCH_OPTION" "MATCH_OPTION", "A2"."TAX_CODE_ID" "TAX_CODE_ID", "A2"."CALCULATE_TAX_FLAG" "CALCULATE_TAX_FLAG", "A2"."CHANGE_PROMISED_DATE_REASON" "CHANGE_PROMISED_DATE_REASON", "A2"."NOTE_TO_RECEIVER" "NOTE_TO_RECEIVER", "A2"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A2"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A2"."PREFERRED_GRADE" "PREFERRED_GRADE", "A2"."SECONDARY_QUANTITY_RECEIVED" "SECONDARY_QUANTITY_RECEIVED", "A2"."SECONDARY_QUANTITY_ACCEPTED" "SECONDARY_QUANTITY_ACCEPTED", "A2"."SECONDARY_QUANTITY_REJECTED" "SECONDARY_QUANTITY_REJECTED", "A2"."SECONDARY_QUANTITY_CANCELLED" "SECONDARY_QUANTITY_CANCELLED", "A2"."VMI_FLAG" "VMI_FLAG", "A2"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A2"."SUPPLIER_ORDER_LINE_NUMBER" "SUPPLIER_ORDER_LINE_NUMBER", "A2"."AMOUNT" "AMOUNT", "A2"."AMOUNT_RECEIVED" "AMOUNT_RECEIVED", "A2"."AMOUNT_BILLED" "AMOUNT_BILLED", "A2"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A2"."AMOUNT_ACCEPTED" "AMOUNT_ACCEPTED", "A2"."AMOUNT_REJECTED" "AMOUNT_REJECTED", "A2"."DROP_SHIP_FLAG" "DROP_SHIP_FLAG", "A2"."SALES_ORDER_UPDATE_DATE" "SALES_ORDER_UPDATE_DATE", "A2"."SHIP_TO_LOCATION_ID" "SHIP_TO_LOCATION_ID", "A2"."SHIP_TO_LOCATION_NAME" "SHIP_TO_LOCATION_NAME", "A2"."SHIP_TO_ADDRESS_LINE1" "SHIP_TO_ADDRESS_LINE1", "A2"."SHIP_TO_ADDRESS_LINE2" "SHIP_TO_ADDRESS_LINE2", "A2"."SHIP_TO_ADDRESS_LINE3" "SHIP_TO_ADDRESS_LINE3", "A2"."SHIP_TO_ADDRESS_LINE4" "SHIP_TO_ADDRESS_LINE4", "A2"."SHIP_TO_ADDRESS_INFO" "SHIP_TO_ADDRESS_INFO", "A2"."SHIP_TO_COUNTRY" "SHIP_TO_COUNTRY", "A2"."IS_SHIPMENT_ONE_TIME_LOC" "IS_SHIPMENT_ONE_TIME_LOC", "A2"."ONE_TIME_ADDRESS_DETAILS" "ONE_TIME_ADDRESS_DETAILS", "A2"."DETAILS" "DETAILS", "A2"."SHIP_CONT_PHONE" "SHIP_CONT_PHONE", "A2"."SHIP_CONT_EMAIL" "SHIP_CONT_EMAIL", "A2"."ULTIMATE_DELIVER_CONT_PHONE" "ULTIMATE_DELIVER_CONT_PHONE", "A2"."ULTIMATE_DELIVER_CONT_EMAIL" "ULTIMATE_DELIVER_CONT_EMAIL", "A2"."SHIP_CONT_NAME" "SHIP_CONT_NAME", "A2"."ULTIMATE_DELIVER_CONT_NAME" "ULTIMATE_DELIVER_CONT_NAME", "A2"."SHIP_CUST_NAME" "SHIP_CUST_NAME", "A2"."SHIP_CUST_LOCATION" "SHIP_CUST_LOCATION", "A2"."ULTIMATE_DELIVER_CUST_NAME" "ULTIMATE_DELIVER_CUST_NAME", "A2"."ULTIMATE_DELIV ER_CUST_LOCATION" "ULTIMATE_DELIVER_CUST_LOCATION", "A2"."SHIP_TO_CONTACT_FAX" "SHIP_TO_CONTACT_FAX", "A2"."ULTIMATE_DELIVER_TO_CONT_NAME" "ULTIMATE_DELIVER_TO_CONT_NAME", "A2"."ULTIMATE_DELIVER_TO_CONT_FAX" "ULTIMATE_DELIVER_TO_CONT_FAX", "A2"."SHIPPING_METHOD" "SHIPPING_METHOD", "A2"."SHIPPING_INSTRUCTIONS" "SHIPPING_INSTRUCTIONS", "A2"."PACKING_INSTRUCTIONS" "PACKING_INSTRUCTIONS", "A2"."CUSTOMER_PRODUCT_DESC" "CUSTOMER_PRODUCT_DESC", "A2"."CUSTOMER_PO_NUM" "CUSTOMER_PO_NUM", "A2"."CUSTOMER_PO_LINE_NUM" "CUSTOMER_PO_LINE_NUM", "A2"."CUSTOMER_PO_SHIPMENT_NUM" "CUSTOMER_PO_SHIPMENT_NUM", "A2"."NEED_BY_DATE" "NEED_BY_DATE", "A2"."PROMISED_DATE" "PROMISED_DATE", "A2"."TOTAL_SHIPMENT_AMOUNT" "TOTAL_SHIPMENT_AMOUNT", "A2"."FINAL_MATCH_FLAG" "FINAL_MATCH_FLAG", "A2"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A2"."TAX_NAME" "TAX_NAME", "A2"."TRANSACTION_FLOW_HEADER_ID" "TRANSACTION_FLOW_HEADER_ID", "A2"."VALUE_BASIS" "VALUE_BASIS", "A2"."MATCHING_BASIS" "MATCHING_BASIS", "A2"."PAYMENT_TYPE" "PAYMENT_TYPE", "A2"."DESCRIPTION" "DESCRIPTION", "A2"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A2"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A2"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A2"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A2"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A2"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT", "A2"."WORK_APPROVER_ID" "WORK_APPROVER_ID", "A2"."BID_PAYMENT_ID" "BID_PAYMENT_ID", "A2"."AMOUNT_SHIPPED" "AMOUNT_SHIPPED", CURSOR (SELECT "A2"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A59"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A60", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A59" WHERE "A60"."ENTITY_NAME"='PO_SHIPMENTS' AND "A60"."PK1_VALUE"=TO_CHAR("A2"."LINE_LOCATION_ID") AND "A60"."FUNCTION_NAME"='PO_PRINTPO' AND "A60"."MEDIA_ID"="A59"."MEDIA_ID" AND "A60"."DATATYPE_ID"=1 ORDER BY "A60"."SEQ_NUM") "LINE_LOC_SHORT_TEXT", CURSOR (SELECT "A58"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A58" WHERE "A58"."ENTITY_NAME"='PO_SHIPMENTS' AND "A58"."PK1_VALUE"=TO_CHAR("A2"."LINE_LOCATION_ID") AND "A58"."DATATYPE_ID"=5 AND "A58"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A58"."SEQ_NUM") "LINE_LOC_URL_ATTACHMENTS", CURSOR (SELECT "A57"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A57" WHERE "A57"."ENTITY_NAME"='PO_SHIPMENTS' AND "A57"."PK1_VALUE"=TO_CHAR("A2"."LINE_LOCATION_ID") AND "A57"."DATATYPE_ID"=6 AND "A57"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A57". "SEQ_NUM") "LINE_LOC_FILE_ATTACHMENTS", CURSOR (SELECT "A56"."AMOUNT_ORDERED" "AMOUNT_ORDERED", "A56"."AMOUNT_DELIVERED" "AMOUNT_DELIVERED", "A56"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A56"."DISTRIBUTION_TYPE" "DISTRIBUTION_TYPE", "A56"."AMOUNT_TO_ENCUMBER" "AMOUNT_TO_ENCUMBER", "A56"."INVOICE_ADJUSTMENT_FLAG" "INVOICE_ADJUSTMENT_FLAG", "A56"."DEST_CHARGE_ACCOUNT_ID" "DEST_CHARGE_ACCOUNT_ID", "A56"."DEST_VARIANCE_ACCOUNT_ID" "DEST_VARIANCE_ACCOUNT_ID", "A56"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A56"."PROJECT_ID" "PROJECT_ID", "A56"."TASK_ID" "TASK_ID", "A56"."EXPENDITURE_TYPE" "EXPENDITURE_TYPE", "A56"."PROJECT_ACCOUNTING_CONTEXT" "PROJECT_ACCOUNTING_CONTEXT", "A56"."EXPENDITURE_ORGANIZATION_ID" "EXPENDITURE_ORGANIZATION_ID", "A56"."GL_CLOSED_DATE" "GL_CLOSED_DATE", "A56"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A56"."EXPENDITURE_ITEM_DATE" "EXPENDITURE_ITEM_DATE", "A56"."ORG_ID" "ORG_ID", "A56"."GL_ENCUMBERED_PERIOD_NAME" "GL_ENCUMBERED_PERIOD_NAME", "A56"."GL_CANCELLED_DATE" "GL_CANCELLED_DATE", "A56"."DESTINATION_TYPE_CODE" "DESTINATION_TYPE_CODE", "A56"."DESTINATION_ORGANIZATION_ID" "DESTINATION_ORGANIZATION_ID", "A56"."DESTINATION_SUBINVENTORY" "DESTINATION_SUBINVENTORY", "A56"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A56"."ATTRIBUTE1" "ATTRIBUTE1", "A56"."ATTRIBUTE2" "ATTRIBUTE2", "A56"."ATTRIBUTE3" "ATTRIBUTE3", "A56"."ATTRIBUTE4" "ATTRIBUTE4", "A56"."ATTRIBUTE5" "ATTRIBUTE5", "A56"."ATTRIBUTE6" "ATTRIBUTE6", "A56"."ATTRIBUTE7" "ATTRIBUTE7", "A56"."ATTRIBUTE8" "ATTRIBUTE8", "A56"."ATTRIBUTE9" "ATTRIBUTE9", "A56"."ATTRIBUTE10" "ATTRIBUTE10", "A56"."ATTRIBUTE11" "ATTRIBUTE11", "A56"."ATTRIBUTE12" "ATTRIBUTE12", "A56"."ATTRIBUTE13" "ATTRIBUTE13", "A56"."ATTRIBUTE14" "ATTRIBUTE14", "A56"."ATTRIBUTE15" "ATTRIBUTE15", "A56"."WIP_ENTITY_ID" "WIP_ENTITY_ID", "A56"."WIP_OPERATION_SEQ_NUM" "WIP_OPERATION_SEQ_NUM", "A56"."WIP_RESOURCE_SEQ_NUM" "WIP_RESOURCE_SEQ_NUM", "A56"."WIP_REPETITIVE_SCHEDULE_ID" "WIP_REPETITIVE_SCHEDULE_ID", "A56"."WIP_LINE_ID" "WIP_LINE_ID", "A56"."BOM_RESOURCE_ID" "BOM_RESOURCE_ID", "A56"."BUDGET_ACCOUNT_ID" "BUDGET_ACCOUNT_ID", "A56"."ACCRUAL_ACCOUNT_ID" "ACCRUAL_ACCOUNT_ID", "A56"."VARIANCE_ACCOUNT_ID" "VARIANCE_ACCOUNT_ID", "A56"."PREVENT_ENCUMBRANCE_FLAG" "PREVENT_ENCUMBRANCE_FLAG", "A56"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A56"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A56"."PO_DISTRIBUTION_ID" "PO_DISTRIBUTION_ID ", "A56"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A56"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A56"."PO_HEADER_ID" "PO_HEADER_ID", "A56"."PO_LINE_ID" "PO_LINE_ID", "A56"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A56"."SET_OF_BOOKS_ID" "SET_OF_BOOKS_ID", "A56"."CODE_COMBINATION_ID" "CODE_COMBINATION_ID", "A56"."QUANTITY_ORDERED" "QUANTITY_ORDERED", "A56"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A56"."CREATION_DATE" "CREATION_DATE", "A56"."CREATED_BY" "CREATED_BY", "A56"."PO_RELEASE_ID" "PO_RELEASE_ID", "A56"."QUANTITY_DELIVERED" "QUANTITY_DELIVERED", "A56"."QUANTITY_BILLED" "QUANTITY_BILLED", "A56"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A56"."REQ_HEADER_REFERENCE_NUM" "REQ_HEADER_REFERENCE_NUM", "A56"."REQ_LINE_REFERENCE_NUM" "REQ_LINE_REFERENCE_NUM", "A56"."REQ_DISTRIBUTION_ID" "REQ_DISTRIBUTION_ID", "A56"."DELIVER_TO_LOCATION_ID" "DELIVER_TO_LOCATION_ID", "A56"."DELIVER_TO_PERSON_ID" "DELIVER_TO_PERSON_ID", "A56"."RATE_DATE" "RATE_DATE", "A56"."RATE" "RATE", "A56"."AMOUNT_BILLED" "AMOUNT_BILLED", "A56"."ACCRUED_FLAG" "ACCRUED_FLAG", "A56"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A56"."ENCUMBERED_AMOUNT" "ENCUMBERED_AMOUNT", "A56"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A56"."UNENCUMBERED_AMOUNT" "UNENCUMBERED_AMOUNT", "A56"."FAILED_FUNDS_LOOKUP_CODE" "FAILED_FUNDS_LOOKUP_CODE", "A56"."GL_ENCUMBERED_DATE" "GL_ENCUMBERED_DATE", "A56"."KANBAN_CARD_ID" "KANBAN_CARD_ID", "A56"."END_ITEM_UNIT_NUMBER" "END_ITEM_UNIT_NUMBER", "A56"."AWARD_ID" "AWARD_ID", "A56"."MRC_RATE_DATE" "MRC_RATE_DATE", "A56"."MRC_RATE" "MRC_RATE", "A56"."MRC_ENCUMBERED_AMOUNT" "MRC_ENCUMBERED_AMOUNT", "A56"."MRC_UNENCUMBERED_AMOUNT" "MRC_UNENCUMBERED_AMOUNT", "A56"."RECOVERABLE_TAX" "RECOVERABLE_TAX", "A56"."NONRECOVERABLE_TAX" "NONRECOVERABLE_TAX", "A56"."RECOVERY_RATE" "RECOVERY_RATE", "A56"."TAX_RECOVERY_OVERRIDE_FLAG" "TAX_RECOVERY_OVERRIDE_FLAG", "A56"."OKE_CONTRACT_LINE_ID" "OKE_CONTRACT_LINE_ID", "A56"."OKE_CONTRACT_DELIVERABLE_ID" "OKE_CONTRACT_DELIVERABLE_ID", "A56"."DESTINATION_CONTEXT" "DESTINATION_CONTEXT", "A56"."DISTRIBUTION_NUM" "DISTRIBUTION_NUM", "A56"."SOURCE_DISTRIBUTION_ID" "SOURCE_DISTRIBUTION_ID", "A56"."REQUEST_ID" "REQUEST_ID", "A56"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A56"."PROGRAM_ID" "PROGRAM_ID", "A56"."CHARGE_ACCOUNT" "CHARGE_ACCOUNT", "A56"."FULL_NAME" "FULL_NAME", "A56"."WORK_TELEPHONE" "WORK_TELEPHONE", "A56"."EMAIL_ADDRESS" "EMAIL_ADDRESS", "A56"."REQUESTER_DELIVER_FIRST_NAME" "REQUESTER_DELIVER_FIRST_NAME", "A56"."REQUESTER_DELIVER_LAST_NAME" "REQUESTER_DELIVER_LAST_NAME", "A56"."REQUESTER_DELIVER_TITLE" "REQUESTER_DELIVER_TITLE", "A56"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A56"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A56"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A56"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A56"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A56"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT" FROM "PO_DISTRIBUTION_XML" "A56" WHERE "A56"."PO_HEADER_ID"=:CV1$$ AND "A56"."LINE_LOCATION_ID"="A2"."LINE_LOCATION_ID") "DISTRIBUTIONS" FROM "PO_LINE_LOCATIONS_XML" "A2" WHERE "A2"."PO_LINE_ID"=:CV1$ AND NVL("A2"."PAYMENT_TYPE", 'NONE')<>'ADVANCE' AND NVL("A2"."PAYMENT_TYPE", 'NONE')<>'DELIVERY'
4z510cva9wzsv SELECT decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_last_name ) , decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_first_name ) , decode ( : po_num_type , 'NUMERIC' , null , poh . po_num ) , decode ( : po_num_type , 'NUMERIC' , decode ( rtrim ( poh . po_num , '0123456789' ) , NULL , to_number ( poh . po_num ) , - 1 ) , null ) , poh . po_type poh_po_type , por . release_type poh_release_type , poh . po_num || decode ( poh . po_type , 'RELEASE' , '-' || por . release_num , null ) poh_po_num , poh . po_num security_poh_po_num , por . release_num security_por_po_num , poh . revision_num poh_revision_num , poh . vendor_name poh_vendor_name , poh . vendor_address_line1 poh_vendor_address_line1 , poh . vendor_address_line2 poh_vendor_address_line2 , poh . vendor_address_line3 poh_vendor_address_line3 , decode ( poh . vendor_city , null , poh . vendor_state || ' ' || poh . vendor_postal_code , poh . vendor_city || ', ' || poh . vendor_state || ' ' || poh . vendor_postal_code ) poh_vendor_adr_info , poh . vendor_country poh_vendor_country , poh . customer_num poh_customer , poh . vendor_num poh_vendor_num , poh . creation_date poh_creation_date , poh . revised_date poh_revised_date , substr ( substr ( poh . document_buyer_first_name , 1 , 1 ) || ' ' || poh . document_buyer_last_name , 1 , 12 ) poh_buyer , substr ( trim ( substr ( poh . archive_buyer_first_name , 1 , 1 ) || ' ' || poh . archive_buyer_last_name ) , 1 , 12 ) poh_archive_buyer , poh . document_buyer_agent_id poh_agent_id , poh . payment_terms poh_payment_terms , poh . ship_via poh_ship_via , poh . fob poh_fob , poh . freight_terms poh_freight_terms , substr ( poh . vendor_contact_first_name , 1 , 1 ) || ' ' || substr ( poh . vendor_contact_last_name , 1 , 10 ) poh_vendor_contact_name , poh . vendor_phone poh_vendor_phone , poh . vendor_contact_phone poh_vendor_contact_phone , poh . note_to_vendor poh_note_to_vendor , poh . printed_date poh_printed_date , poh . amount_agreed poh_amount_agreed , poh . cancel_flag poh_cancel_flag , poh . confirming_order_flag poh_confirming_order_flag , poh . acceptance_required_flag poh_acceptance_req_flag , poh . acceptance_due_date poh_acceptance_due_date , poh . currency_code poh_currency_code , poh . currency_code C_CURRENCY , poh . currency_name poh_currency_name , poh . currency_conversion_rate poh_currency_conversion_rate , poh . bill_to_location_id poh_bill_to_location , poh . ship_to_location_id poh_ship_to_location , poh . po_header_id poh_po_header_id , poh . po_release_id poh_po_release_id , poh . po_type poh_po_type , poh . approved_flag poh_approved_flag , poh . print_count poh_print_count , poh . effective_date poh_effective_date , poh . expiration_date poh_expiration_date , nvl ( poh . po_release_id , - 1 ) poh_join_release_id , poh . vendor_site_id poh_vendor_site_id , poh . vendor_id poh_vendor_id FROM po_headers_print poh , po_releases por WHERE poh . po_release_id = por . po_release_id (+) AND ( nvl ( por . release_num , - 1 ) BETWEEN nvl ( : P_release_num_from , nvl ( por . release_num , - 1 ) ) AND nvl ( : P_release_num_to , nvl ( por . release_num , - 1 ) ) OR poh . po_type != 'RELEASE' ) AND poh . document_buyer_agent_id = nvl ( : P_agent_id , poh . document_buyer_agent_id ) AND ( poh . release_date is NULL OR trunc ( poh . release_date ) BETWEEN nvl ( : P_date_from , trunc ( poh . release_date ) ) AND nvl ( : P_date_to , trunc ( poh . release_date ) + 1 ) ) AND nvl ( poh . approved_flag , 'N' ) = nvl ( : P_approved_flag , nvl ( poh . approved_flag , 'N' ) ) AND ( ( nvl ( : P_print_releases , 'Y' ) = 'Y' ) or ( nvl ( : P_print_releases , 'Y' ) = 'N' and poh . po_type != 'RELEASE' ) ) AND nvl ( poh . consigned_consumption_flag , 'N' ) <> 'Y' AND nvl ( por . consigned_consumption_flag , 'N' ) <> 'Y' AND :P_single_po_print = 1 AND po_num = :P_po_num_from AND nvl(poh.print_ count, 0) = 0 AND NOT EXISTS (SELECT 'X' from ECE_TP_DETAILS ETD, ECE_TP_HEADERS ETH, PO_VENDOR_SITES E_PVS WHERE E_PVS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID AND ETH.TP_HEADER_ID = E_PVS.TP_HEADER_ID AND ETD.TP_HEADER_ID = ETH.TP_HEADER_ID AND ETD.EDI_FLAG = 'Y' AND ETD.DOCUMENT_ID = 'POO' AND ETD.DOCUMENT_TYPE = POH.PO_TYPE ) and 1=1 ORDER BY 1 , 2 , 3 , 4
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;
5693gr4xpt3acSELECT 1 FROM PO_LINE_LOCATIONS_ALL PLLA WHERE PLLA.LINE_LOCATION_ID = :B1 AND ((NVL(PLLA.QUANTITY_RECEIVED, 0) > (SELECT SUM(NVL(POD.QUANTITY_DELIVERED, 0)) FROM PO_DISTRIBUTIONS POD WHERE POD.LINE_LOCATION_ID = PLLA.LINE_LOCATION_ID)) OR (NVL(PLLA.AMOUNT_RECEIVED, 0) > (SELECT SUM(NVL(POD.AMOUNT_DELIVERED, 0)) FROM PO_DISTRIBUTIONS POD WHERE POD.LINE_LOCATION_ID = PLLA.LINE_LOCATION_ID)))
64y52qc72ffdaSELECT 'Y' FROM SYS.DUAL WHERE EXISTS( SELECT NULL FROM PO_LINE_LOCATIONS POLL, PO_LINE_LOCATIONS_ARCHIVE POLLA WHERE POLL.PO_HEADER_ID = :B4 AND POLL.PO_RELEASE_ID IS NULL AND (:B3 IS NULL OR POLL.PO_LINE_ID = :B3 ) AND (:B2 IS NULL OR POLL.LINE_LOCATION_ID = :B2 ) AND POLL.LINE_LOCATION_ID = POLLA.LINE_LOCATION_ID (+) AND POLLA.LATEST_EXTERNAL_FLAG (+) = 'Y' AND ( (POLLA.LINE_LOCATION_ID IS NULL) OR (POLL.QUANTITY <> POLLA.QUANTITY) OR (POLL.QUANTITY IS NULL AND POLLA.QUANTITY IS NOT NULL) OR (POLL.QUANTITY IS NOT NULL AND POLLA.QUANTITY IS NULL) OR (POLL.AMOUNT <> POLLA.AMOUNT) OR (POLL.AMOUNT IS NULL AND POLLA.AMOUNT IS NOT NULL) OR (POLL.AMOUNT IS NOT NULL AND POLLA.AMOUNT IS NULL) OR (POLL.SHIP_TO_LOCATION_ID <> POLLA.SHIP_TO_LOCATION_ID) OR (POLL.SHIP_TO_LOCATION_ID IS NULL AND POLLA.SHIP_TO_LOCATION_ID IS NOT NULL) OR (POLL.SHIP_TO_LOCATION_ID IS NOT NULL AND POLLA.SHIP_TO_LOCATION_ID IS NULL) OR (POLL.NEED_BY_DATE <> POLLA.NEED_BY_DATE) OR (POLL.NEED_BY_DATE IS NULL AND POLLA.NEED_BY_DATE IS NOT NULL) OR (POLL.NEED_BY_DATE IS NOT NULL AND POLLA.NEED_BY_DATE IS NULL) OR (POLL.PROMISED_DATE <> POLLA.PROMISED_DATE) OR (POLL.PROMISED_DATE IS NULL AND POLLA.PROMISED_DATE IS NOT NULL) OR (POLL.PROMISED_DATE IS NOT NULL AND POLLA.PROMISED_DATE IS NULL) OR (POLL.LAST_ACCEPT_DATE <> POLLA.LAST_ACCEPT_DATE) OR (POLL.LAST_ACCEPT_DATE IS NULL AND POLLA.LAST_ACCEPT_DATE IS NOT NULL) OR (POLL.LAST_ACCEPT_DATE IS NOT NULL AND POLLA.LAST_ACCEPT_DATE IS NULL) OR (POLL.PRICE_OVERRIDE <> POLLA.PRICE_OVERRIDE) OR (POLL.PRICE_OVERRIDE IS NULL AND POLLA.PRICE_OVERRIDE IS NOT NULL) OR (POLL.PRICE_OVERRIDE IS NOT NULL AND POLLA.PRICE_OVERRIDE IS NULL) OR (POLL.PAYMENT_TYPE <> POLLA.PAYMENT_TYPE) OR (POLL.PAYMENT_TYPE IS NULL AND POLLA.PAYMENT_TYPE IS NOT NULL) OR (POLL.PAYMENT_TYPE IS NOT NULL AND POLLA.PAYMENT_TYPE IS NULL) OR (POLL.DESCRIPTION <> POLLA.DESCRIPTION) OR (POLL.DESCRIPTION IS NULL AND POLLA.DESCRIPTION IS NOT NULL) OR (POLL.DESCRIPTION IS NOT NULL AND POLLA.DESCRIPTION IS NULL) OR (POLL.WORK_APPROVER_ID <> POLLA.WORK_APPROVER_ID) OR (POLL.WORK_APPROVER_ID IS NULL AND POLLA.WORK_APPROVER_ID IS NOT NULL) OR (POLL.WORK_APPROVER_ID IS NOT NULL AND POLLA.WORK_APPROVER_ID IS NULL) OR (POLL.SHIPMENT_NUM <> POLLA.SHIPMENT_NUM) OR (POLL.SHIPMENT_NUM IS NULL AND POLLA.SHIPMENT_NUM IS NOT NULL) OR (POLL.SHIPMENT_NUM IS NOT NULL AND POLLA.SHIPMENT_NUM IS NULL) OR (POLL.SALES_ORDER_UPDATE_DATE <> POLLA.SALES_ORDER_UPDATE_DATE) OR (POLL.SALES_ORDER_UPDATE_DATE IS NULL AND POLLA.SALES_ORDER_UPDATE_DATE IS NOT NULL) OR (POLL.SALES_ORDER_UPDATE_DATE IS NOT NULL AND POLLA.SALES_ORDER_UPDATE_DATE IS NULL) OR (:B1 = 'Y' AND ((POLL.CANCEL_FLAG <> POLLA.CANCEL_FLAG) OR (POLL.CANCEL_FLAG IS NULL AND POLLA.CANCEL_FLAG IS NOT NULL) OR (POLL.CANCEL_FLAG IS NOT NULL AND POLLA.CANCEL_FLAG IS NULL)))))
67mmmbx5hb3p0BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, true);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;:21 := fnd_session_management.g_proxy_user_id; :22 := fnd_session_management.g_mode_code; END;
6vx0fw5141z4nSELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 )
7qs7fx89194u1SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
7yr8xbwxpdnavINSERT INTO WIP_EAM_DIRECT_ITEMS ( DESCRIPTION , PURCHASING_CATEGORY_ID , DIRECT_ITEM_SEQUENCE_ID , OPERATION_SEQ_NUM , DEPARTMENT_ID , WIP_ENTITY_ID , ORGANIZATION_ID , SUGGESTED_VENDOR_NAME , SUGGESTED_VENDOR_ID , SUGGESTED_VENDOR_SITE , SUGGESTED_VENDOR_SITE_ID , SUGGESTED_VENDOR_CONTACT , SUGGESTED_VENDOR_CONTACT_ID , UNIT_PRICE , AUTO_REQUEST_MATERIAL , REQUIRED_QUANTITY , UOM , NEED_BY_DATE , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , ORDER_TYPE_LOOKUP_CODE) VALUES ( :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , 'Y' , :B4 , :B3 , :B2 , SYSDATE , FND_GLOBAL.USER_ID , SYSDATE , FND_GLOBAL.USER_ID , FND_GLOBAL.LOGIN_ID , :B1 )
81xv2tma4cag8 SELECT "A2"."ITEM_REVISION" "ITEM_REVISION", "A2"."LINE_NUM" "LINE_NUM", "A2"."ITEM_DESCRIPTION" "ITEM_DESCRIPTION", "A2"."CANCEL_FLAG" "CANCEL_FLAG", "A2"."CANCEL_DATE" "CANCEL_DATE", "A2"."CANCEL_REASON" "CANCEL_REASON", "A2"."VENDOR_PRODUCT_NUM" "VENDOR_PRODUCT_NUM", "A2"."NOTE_TO_VENDOR" "NOTE_TO_VENDOR", "A2"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A2"."UN_NUMBER" "UN_NUMBER", "A2"."UN_DESC" "UN_DESC", "A2"."HAZARD_CLASS" "HAZARD_CLASS", "A2"."ORDER_TYPE_LOOKUP_CODE" "ORDER_TYPE_LOOKUP_CODE", "A2"."CONTRACT_NUM" "CONTRACT_NUM", "A2"."SEGMENT1" "SEGMENT1", "A2"."GLOBAL_AGREEMENT_FLAG" "GLOBAL_AGREEMENT_FLAG", "A2"."QUOTE_VENDOR_QUOTE_NUMBER" "QUOTE_VENDOR_QUOTE_NUMBER", "A2"."QUOTATION_LINE" "QUOTATION_LINE", "A2"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A2"."ATTRIBUTE1" "ATTRIBUTE1", "A2"."ATTRIBUTE2" "ATTRIBUTE2", "A2"."ATTRIBUTE3" "ATTRIBUTE3", "A2"."ATTRIBUTE4" "ATTRIBUTE4", "A2"."ATTRIBUTE5" "ATTRIBUTE5", "A2"."ATTRIBUTE6" "ATTRIBUTE6", "A2"."ATTRIBUTE7" "ATTRIBUTE7", "A2"."ATTRIBUTE8" "ATTRIBUTE8", "A2"."ATTRIBUTE9" "ATTRIBUTE9", "A2"."ATTRIBUTE10" "ATTRIBUTE10", "A2"."ATTRIBUTE11" "ATTRIBUTE11", "A2"."ATTRIBUTE12" "ATTRIBUTE12", "A2"."ATTRIBUTE13" "ATTRIBUTE13", "A2"."ATTRIBUTE14" "ATTRIBUTE14", "A2"."ATTRIBUTE15" "ATTRIBUTE15", "A2"."UNIT_PRICE" "UNIT_PRICE", "A2"."QUANTITY" "QUANTITY", "A2"."QUANTITY_COMMITTED" "QUANTITY_COMMITTED", "A2"."PO_HEADER_ID" "PO_HEADER_ID", "A2"."PO_LINE_ID" "PO_LINE_ID", "A2"."ITEM_ID" "ITEM_ID", "A2"."FROM_HEADER_ID" "FROM_HEADER_ID", "A2"."FROM_LINE_ID" "FROM_LINE_ID", "A2"."REFERENCE_NUM" "REFERENCE_NUM", "A2"."MIN_RELEASE_AMOUNT" "MIN_RELEASE_AMOUNT", "A2"."PRICE_TYPE_LOOKUP_CODE" "PRICE_TYPE_LOOKUP_CODE", "A2"."CLOSED_CODE" "CLOSED_CODE", "A2"."PRICE_BREAK_LOOKUP_CODE" "PRICE_BREAK_LOOKUP_CODE", "A2"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A2"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A2"."REQUEST_ID" "REQUEST_ID", "A2"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A2"."PROGRAM_ID" "PROGRAM_ID", "A2"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A2"."CLOSED_DATE" "CLOSED_DATE", "A2"."CLOSED_REASON" "CLOSED_REASON", "A2"."CLOSED_BY" "CLOSED_BY", "A2"."TRANSACTION_REASON_CODE" "TRANSACTION_REASON_CODE", "A2"."ORG_ID" "ORG_ID", "A2". "HAZARD_CLASS_ID" "HAZARD_CLASS_ID", "A2"."MIN_ORDER_QUANTITY" "MIN_ORDER_QUANTITY", "A2"."MAX_ORDER_QUANTITY" "MAX_ORDER_QUANTITY", "A2"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A2"."OVER_TOLERANCE_ERROR_FLAG" "OVER_TOLERANCE_ERROR_FLAG", "A2"."MARKET_PRICE" "MARKET_PRICE", "A2"."UNORDERED_FLAG" "UNORDERED_FLAG", "A2"."CLOSED_FLAG" "CLOSED_FLAG", "A2"."USER_HOLD_FLAG" "USER_HOLD_FLAG", "A2"."CANCELLED_BY" "CANCELLED_BY", "A2"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A2"."FIRM_DATE" "FIRM_DATE", "A2"."TAXABLE_FLAG" "TAXABLE_FLAG", "A2"."TYPE_1099" "TYPE_1099", "A2"."CAPITAL_EXPENSE_FLAG" "CAPITAL_EXPENSE_FLAG", "A2"."NEGOTIATED_BY_PREPARER_FLAG" "NEGOTIATED_BY_PREPARER_FLAG", "A2"."QC_GRADE" "QC_GRADE", "A2"."BASE_UOM" "BASE_UOM", "A2"."BASE_QTY" "BASE_QTY", "A2"."SECONDARY_UOM" "SECONDARY_UOM", "A2"."SECONDARY_QTY" "SECONDARY_QTY", "A2"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A2"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A2"."LINE_TYPE_ID" "LINE_TYPE_ID", "A2"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A2"."CREATION_DATE" "CREATION_DATE", "A2"."CREATED_BY" "CREATED_BY", "A2"."CATEGORY_ID" "CATEGORY_ID", "A2"."COMMITTED_AMOUNT" "COMMITTED_AMOUNT", "A2"."ALLOW_PRICE_OVERRIDE_FLAG" "ALLOW_PRICE_OVERRIDE_FLAG", "A2"."NOT_TO_EXCEED_PRICE" "NOT_TO_EXCEED_PRICE", "A2"."LIST_PRICE_PER_UNIT" "LIST_PRICE_PER_UNIT", "A2"."UN_NUMBER_ID" "UN_NUMBER_ID", "A2"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A2"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A2"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A2"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A2"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A2"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A2"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A2"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A2"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A2"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A2"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A2"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A2"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A2"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A2"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A2"."GLOBAL_ATTRIBUTE15" "GLOBAL_ATTRIBUTE15", "A2"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A2"."GLOBAL_ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A2"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A2"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A2"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A2 "."LINE_REFERENCE_NUM" "LINE_REFERENCE_NUM", "A2"."PROJECT_ID" "PROJECT_ID", "A2"."TASK_ID" "TASK_ID", "A2"."EXPIRATION_DATE" "EXPIRATION_DATE", "A2"."TAX_CODE_ID" "TAX_CODE_ID", "A2"."OKE_CONTRACT_HEADER_ID" "OKE_CONTRACT_HEADER_ID", "A2"."OKE_CONTRACT_VERSION_ID" "OKE_CONTRACT_VERSION_ID", "A2"."TAX_NAME" "TAX_NAME", "A2"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A2"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A2"."PREFERRED_GRADE" "PREFERRED_GRADE", "A2"."AUCTION_HEADER_ID" "AUCTION_HEADER_ID", "A2"."AUCTION_DISPLAY_NUMBER" "AUCTION_DISPLAY_NUMBER", "A2"."AUCTION_LINE_NUMBER" "AUCTION_LINE_NUMBER", "A2"."BID_NUMBER" "BID_NUMBER", "A2"."BID_LINE_NUMBER" "BID_LINE_NUMBER", "A2"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A2"."SUPPLIER_REF_NUMBER" "SUPPLIER_REF_NUMBER", "A2"."CONTRACT_ID" "CONTRACT_ID", "A2"."JOB_ID" "JOB_ID", "A2"."AMOUNT" "AMOUNT", "A2"."START_DATE" "START_DATE", "A2"."LINE_TYPE" "LINE_TYPE", "A2"."PURCHASE_BASIS" "PURCHASE_BASIS", "A2"."ITEM_NUM" "ITEM_NUM", "A2"."JOB_NAME" "JOB_NAME", "A2"."CONTRACTOR_FIRST_NAME" "CONTRACTOR_FIRST_NAME", "A2"."CONTRACTOR_LAST_NAME" "CONTRACTOR_LAST_NAME", "A2"."LINE_AMOUNT" "LINE_AMOUNT", "A2"."CANCELED_AMOUNT" "CANCELED_AMOUNT", "A2"."TOTAL_LINE_AMOUNT" "TOTAL_LINE_AMOUNT", "A2"."BASE_UNIT_PRICE" "BASE_UNIT_PRICE", "A2"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A2"."MATCHING_BASIS" "MATCHING_BASIS", "A2"."SVC_AMOUNT_NOTIF_SENT" "SVC_AMOUNT_NOTIF_SENT", "A2"."SVC_COMPLETION_NOTIF_SENT" "SVC_COMPLETION_NOTIF_SENT", "A2"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A2"."RETAINAGE_RATE" "RETAINAGE_RATE", "A2"."MAX_RETAINAGE_AMOUNT" "MAX_RETAINAGE_AMOUNT", "A2"."PROGRESS_PAYMENT_RATE" "PROGRESS_PAYMENT_RATE", "A2"."RECOUPMENT_RATE" "RECOUPMENT_RATE", CURSOR (SELECT "A40"."PRICE_TYPE_DSP" "PRICE_TYPE", "A40"."MULTIPLIER" "MULTIPLIER" FROM "PO_PRICE_DIFFERENTIALS_V" "A40" WHERE "A40"."ENTITY_TYPE"='PO LINE' AND "A40"."ENTITY_ID"="A2"."PO_LINE_ID" AND "A40"."ENABLED_FLAG"='Y') "PRICE_DIFF", CURSOR (SELECT "A2"."PO_LINE_ID" "PO_LINE_ID", "A38"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A39", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A38" WHERE ("A39"."ENTITY_NAME"='PO_LINES' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A39"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A39"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORG ID"()) AND "A39"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL OR "A39"."ENTITY_NAME"='PO_HEADERS' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A39"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A39"."ENTITY_NAME"='PO_HEADERS' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL) AND "A39"."FUNCTION_NAME"='PO_PRINTPO' AND "A39"."MEDIA_ID"="A38"."MEDIA_ID" AND "A39"."DATATYPE_ID"=1 ORDER BY "A39"."SEQ_NUM") "LINE_SHORT_TEXT", CURSOR (SELECT "A37"."PRICE_ADJUSTMENT_ID" "PRICE_ADJUSTMENT_ID", "A37"."CREATION_DATE" "CREATION_DATE", "A37"."CREATED_BY" "CREATED_BY", "A37"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A37"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A37"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A37"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A37"."PROGRAM_ID" "PROGRAM_ID", "A37"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A37"."REQUEST_ID" "REQUEST_ID", "A37"."PO_HEADER_ID" "PO_HEADER_ID", "A37"."AUTOMATIC_FLAG" "AUTOMATIC_FLAG", "A37"."PO_LINE_ID" "PO_LINE_ID", "A37"."ADJ_LINE_NUM" "ADJ_LINE_NUM", "A37"."CONTEXT" "CONTEXT", "A37"."ATTRIBUTE1" "ATTRIBUTE1", "A37"."ATTRIBUTE2" "ATTRIBUTE2", "A37"."ATTRIBUTE3" "ATTRIBUTE3", "A37"."ATTRIBUTE4" "ATTRIBUTE4", "A37"."ATTRIBUTE5" "ATTRIBUTE5", "A37"."ATTRIBUTE6" "ATTRIBUTE6", "A37"."ATTRIBUTE7" "ATTRIBUTE7", "A37"."ATTRIBUTE8" "ATTRIBUTE8", "A37"."ATTRIBUTE9" "ATTRIBUTE9", "A37"."ATTRIBUTE10" "ATTRIBUTE10", "A37"."ATTRIBUTE11" "ATTRIBUTE11", "A37"."ATTRIBUTE12" "ATTRIBUTE12", "A37"."ATTRIBUTE13" "ATTRIBUTE13", "A37"."ATTRIBUTE14" "ATTRIBUTE14", "A37"."ATTRIBUTE15" "ATTRIBUTE15", "A37"."ORIG_SYS_DISCOUNT_REF" "ORIG_SYS_DISCOUNT_REF", "A37"."CHANGE_SEQUENCE" "CHANGE_SEQUENCE", "A37"."LIST_HEADER_ID" "LIST_HEADER_ID", "A37"."LIST_TYPE_CODE" "LIST_TYPE_CODE", "A37"."LIST_LINE_ID" "LIST_LINE_ID", "A37"."MODIFIER_DESC" "MODIFIER_DESC", "A37"."LIST_LINE_TYPE_CODE" "LIST_LINE_TYPE_CODE", "A37"."MODIFIER_LINE_TYPE" "MODIFIER_LINE_TYPE", "A37"."MODIFIED_FROM" "MODIFIED_FROM", "A37"."MODIFIED_TO" "MODIFIED_TO", "A37"."UPDATE_ALLOWED" "UPDATE_ALLOWED", "A37"."CHANGE_REASON_CODE" "CHANGE_REASON_CODE", "A37"."CHANGE_REASON_TEXT" "CHANGE_REASON_T EXT", "A37"."UPDATED_FLAG" "UPDATED_FLAG", "A37"."APPLIED_FLAG" "APPLIED_FLAG", "A37"."OPERAND" "OPERAND", "A37"."ARITHMETIC_OPERATOR" "ARITHMETIC_OPERATOR", "A37"."COST_ID" "COST_ID", "A37"."TAX_CODE" "TAX_CODE", "A37"."TAX_EXEMPT_FLAG" "TAX_EXEMPT_FLAG", "A37"."TAX_EXEMPT_NUMBER" "TAX_EXEMPT_NUMBER", "A37"."TAX_EXEMPT_REASON_CODE" "TAX_EXEMPT_REASON_CODE", "A37"."PARENT_ADJUSTMENT_ID" "PARENT_ADJUSTMENT_ID", "A37"."INVOICED_FLAG" "INVOICED_FLAG", "A37"."ESTIMATED_FLAG" "ESTIMATED_FLAG", "A37"."INC_IN_SALES_PERFORMANCE" "INC_IN_SALES_PERFORMANCE", "A37"."ADJUSTED_AMOUNT" "ADJUSTED_AMOUNT", "A37"."PRICING_PHASE_ID" "PRICING_PHASE_ID", "A37"."CHARGE_TYPE_CODE" "CHARGE_TYPE_CODE", "A37"."CHARGE_SUBTYPE_CODE" "CHARGE_SUBTYPE_CODE", "A37"."RANGE_BREAK_QUANTITY" "RANGE_BREAK_QUANTITY", "A37"."ACCRUAL_CONVERSION_RATE" "ACCRUAL_CONVERSION_RATE", "A37"."PRICING_GROUP_SEQUENCE" "PRICING_GROUP_SEQUENCE", "A37"."ACCRUAL_FLAG" "ACCRUAL_FLAG", "A37"."LIST_LINE_NO" "LIST_LINE_NO", "A37"."SOURCE_SYSTEM_CODE" "SOURCE_SYSTEM_CODE", "A37"."BENEFIT_QTY" "BENEFIT_QTY", "A37"."BENEFIT_UOM_CODE" "BENEFIT_UOM_CODE", "A37"."PRINT_ON_INVOICE_FLAG" "PRINT_ON_INVOICE_FLAG", "A37"."EXPIRATION_DATE" "EXPIRATION_DATE", "A37"."REBATE_TRANSACTION_TYPE_CODE" "REBATE_TRANSACTION_TYPE_CODE", "A37"."REBATE_TRANSACTION_REFERENCE" "REBATE_TRANSACTION_REFERENCE", "A37"."REBATE_PAYMENT_SYSTEM_CODE" "REBATE_PAYMENT_SYSTEM_CODE", "A37"."REDEEMED_DATE" "REDEEMED_DATE", "A37"."REDEEMED_FLAG" "REDEEMED_FLAG", "A37"."MODIFIER_LEVEL_CODE" "MODIFIER_LEVEL_CODE", "A37"."PRICE_BREAK_TYPE_CODE" "PRICE_BREAK_TYPE_CODE", "A37"."SUBSTITUTION_ATTRIBUTE" "SUBSTITUTION_ATTRIBUTE", "A37"."PRORATION_TYPE_CODE" "PRORATION_TYPE_CODE", "A37"."INCLUDE_ON_RETURNS_FLAG" "INCLUDE_ON_RETURNS_FLAG", "A37"."CREDIT_OR_CHARGE_FLAG" "CREDIT_OR_CHARGE_FLAG", "A37"."AC_CONTEXT" "AC_CONTEXT", "A37"."AC_ATTRIBUTE1" "AC_ATTRIBUTE1", "A37"."AC_ATTRIBUTE2" "AC_ATTRIBUTE2", "A37"."AC_ATTRIBUTE3" "AC_ATTRIBUTE3", "A37"."AC_ATTRIBUTE4" "AC_ATTRIBUTE4", "A37"."AC_ATTRIBUTE5" "AC_ATTRIBUTE5", "A37"."AC_ATTRIBUTE6" "AC_ATTRIBUTE6", "A37"."AC_ATTRIBUTE7" "AC_ATTRIBUTE7", "A37"."AC_ATTRIBUTE8" "AC_ATTRIBUTE8", "A37"."AC_ATTRIBUTE9" "AC_ATTRIBUTE9", "A37"."AC_ATTRIBUTE10" "AC_ATTRIBUTE10", "A37"."AC_ATTRIBUTE11" "AC_ATTRIBUTE11", "A37"."AC_ATTRIBUTE12" "AC_ATTRIBUTE12", "A37"."AC_ATTRIBUTE13" "AC_ATTRIBUTE13", "A37"."AC_ATTRIBUTE14" "AC_ATTRIBUTE14" , "A37"."AC_ATTRIBUTE15" "AC_ATTRIBUTE15", "A37"."LOCK_CONTROL" "LOCK_CONTROL", "A37"."OPERAND_PER_PQTY" "OPERAND_PER_PQTY", "A37"."ADJUSTED_AMOUNT_PER_PQTY" "ADJUSTED_AMOUNT_PER_PQTY", "A37"."INTERCO_INVOICED_FLAG" "INTERCO_INVOICED_FLAG", "A37"."INVOICED_AMOUNT" "INVOICED_AMOUNT", "A37"."RETROBILL_REQUEST_ID" "RETROBILL_REQUEST_ID", "A37"."TAX_RATE_ID" "TAX_RATE_ID" FROM "PO_PRICE_ADJUSTMENTS_XML" "A37" WHERE "A37"."PO_HEADER_ID"="A2"."PO_HEADER_ID" AND "A37"."PO_LINE_ID"="A2"."PO_LINE_ID" AND "A37"."PARENT_ADJUSTMENT_ID" IS NULL ORDER BY "A37"."PRICING_GROUP_SEQUENCE") "PRICE_MODIFIERS", CURSOR (SELECT "A36"."PRICE_ADJUSTMENT_ID" "PRICE_ADJUSTMENT_ID", "A36"."CREATION_DATE" "CREATION_DATE", "A36"."CREATED_BY" "CREATED_BY", "A36"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A36"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A36"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A36"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A36"."PROGRAM_ID" "PROGRAM_ID", "A36"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A36"."REQUEST_ID" "REQUEST_ID", "A36"."PO_HEADER_ID" "PO_HEADER_ID", "A36"."AUTOMATIC_FLAG" "AUTOMATIC_FLAG", "A36"."PO_LINE_ID" "PO_LINE_ID", "A36"."ADJ_LINE_NUM" "ADJ_LINE_NUM", "A36"."CONTEXT" "CONTEXT", "A36"."ATTRIBUTE1" "ATTRIBUTE1", "A36"."ATTRIBUTE2" "ATTRIBUTE2", "A36"."ATTRIBUTE3" "ATTRIBUTE3", "A36"."ATTRIBUTE4" "ATTRIBUTE4", "A36"."ATTRIBUTE5" "ATTRIBUTE5", "A36"."ATTRIBUTE6" "ATTRIBUTE6", "A36"."ATTRIBUTE7" "ATTRIBUTE7", "A36"."ATTRIBUTE8" "ATTRIBUTE8", "A36"."ATTRIBUTE9" "ATTRIBUTE9", "A36"."ATTRIBUTE10" "ATTRIBUTE10", "A36"."ATTRIBUTE11" "ATTRIBUTE11", "A36"."ATTRIBUTE12" "ATTRIBUTE12", "A36"."ATTRIBUTE13" "ATTRIBUTE13", "A36"."ATTRIBUTE14" "ATTRIBUTE14", "A36"."ATTRIBUTE15" "ATTRIBUTE15", "A36"."ORIG_SYS_DISCOUNT_REF" "ORIG_SYS_DISCOUNT_REF", "A36"."CHANGE_SEQUENCE" "CHANGE_SEQUENCE", "A36"."LIST_HEADER_ID" "LIST_HEADER_ID", "A36"."LIST_TYPE_CODE" "LIST_TYPE_CODE", "A36"."LIST_LINE_ID" "LIST_LINE_ID", "A36"."MODIFIER_DESC" "MODIFIER_DESC", "A36"."LIST_LINE_TYPE_CODE" "LIST_LINE_TYPE_CODE", "A36"."MODIFIER_LINE_TYPE" "MODIFIER_LINE_TYPE", "A36"."MODIFIED_FROM" "MODIFIED_FROM", "A36"."MODIFIED_TO" "MODIFIED_TO", "A36"."UPDATE_ALLOWED" "UPDATE_ALLOWED", "A36"."CHANGE_REASON_CODE" "CHANGE_REASON_CODE", "A36"."CHANGE_REASON_TEXT" "CHANGE_REASON_TEXT", "A36"."UP DATED_FLAG" "UPDATED_FLAG", "A36"."APPLIED_FLAG" "APPLIED_FLAG", "A36"."OPERAND" "OPERAND", "A36"."ARITHMETIC_OPERATOR" "ARITHMETIC_OPERATOR", "A36"."COST_ID" "COST_ID", "A36"."TAX_CODE" "TAX_CODE", "A36"."TAX_EXEMPT_FLAG" "TAX_EXEMPT_FLAG", "A36"."TAX_EXEMPT_NUMBER" "TAX_EXEMPT_NUMBER", "A36"."TAX_EXEMPT_REASON_CODE" "TAX_EXEMPT_REASON_CODE", "A36"."PARENT_ADJUSTMENT_ID" "PARENT_ADJUSTMENT_ID", "A36"."INVOICED_FLAG" "INVOICED_FLAG", "A36"."ESTIMATED_FLAG" "ESTIMATED_FLAG", "A36"."INC_IN_SALES_PERFORMANCE" "INC_IN_SALES_PERFORMANCE", "A36"."ADJUSTED_AMOUNT" "ADJUSTED_AMOUNT", "A36"."PRICING_PHASE_ID" "PRICING_PHASE_ID", "A36"."CHARGE_TYPE_CODE" "CHARGE_TYPE_CODE", "A36"."CHARGE_SUBTYPE_CODE" "CHARGE_SUBTYPE_CODE", "A36"."RANGE_BREAK_QUANTITY" "RANGE_BREAK_QUANTITY", "A36"."ACCRUAL_CONVERSION_RATE" "ACCRUAL_CONVERSION_RATE", "A36"."PRICING_GROUP_SEQUENCE" "PRICING_GROUP_SEQUENCE", "A36"."ACCRUAL_FLAG" "ACCRUAL_FLAG", "A36"."LIST_LINE_NO" "LIST_LINE_NO", "A36"."SOURCE_SYSTEM_CODE" "SOURCE_SYSTEM_CODE", "A36"."BENEFIT_QTY" "BENEFIT_QTY", "A36"."BENEFIT_UOM_CODE" "BENEFIT_UOM_CODE", "A36"."PRINT_ON_INVOICE_FLAG" "PRINT_ON_INVOICE_FLAG", "A36"."EXPIRATION_DATE" "EXPIRATION_DATE", "A36"."REBATE_TRANSACTION_TYPE_CODE" "REBATE_TRANSACTION_TYPE_CODE", "A36"."REBATE_TRANSACTION_REFERENCE" "REBATE_TRANSACTION_REFERENCE", "A36"."REBATE_PAYMENT_SYSTEM_CODE" "REBATE_PAYMENT_SYSTEM_CODE", "A36"."REDEEMED_DATE" "REDEEMED_DATE", "A36"."REDEEMED_FLAG" "REDEEMED_FLAG", "A36"."MODIFIER_LEVEL_CODE" "MODIFIER_LEVEL_CODE", "A36"."PRICE_BREAK_TYPE_CODE" "PRICE_BREAK_TYPE_CODE", "A36"."SUBSTITUTION_ATTRIBUTE" "SUBSTITUTION_ATTRIBUTE", "A36"."PRORATION_TYPE_CODE" "PRORATION_TYPE_CODE", "A36"."INCLUDE_ON_RETURNS_FLAG" "INCLUDE_ON_RETURNS_FLAG", "A36"."CREDIT_OR_CHARGE_FLAG" "CREDIT_OR_CHARGE_FLAG", "A36"."AC_CONTEXT" "AC_CONTEXT", "A36"."AC_ATTRIBUTE1" "AC_ATTRIBUTE1", "A36"."AC_ATTRIBUTE2" "AC_ATTRIBUTE2", "A36"."AC_ATTRIBUTE3" "AC_ATTRIBUTE3", "A36"."AC_ATTRIBUTE4" "AC_ATTRIBUTE4", "A36"."AC_ATTRIBUTE5" "AC_ATTRIBUTE5", "A36"."AC_ATTRIBUTE6" "AC_ATTRIBUTE6", "A36"."AC_ATTRIBUTE7" "AC_ATTRIBUTE7", "A36"."AC_ATTRIBUTE8" "AC_ATTRIBUTE8", "A36"."AC_ATTRIBUTE9" "AC_ATTRIBUTE9", "A36"."AC_ATTRIBUTE10" "AC_ATTRIBUTE10", "A36"."AC_ATTRIBUTE11" "AC_ATTRIBUTE11", "A36"."AC_ATTRIBUTE12" "AC_ATTRIBUTE12", "A36"."AC_ATTRIBUTE13" "AC_ATTRIBUTE13", "A36"."AC_ATTRIBUTE14" "AC_ATTRIBUTE14", "A36"."AC_ATTRIBUT E15" "AC_ATTRIBUTE15", "A36"."LOCK_CONTROL" "LOCK_CONTROL", "A36"."OPERAND_PER_PQTY" "OPERAND_PER_PQTY", "A36"."ADJUSTED_AMOUNT_PER_PQTY" "ADJUSTED_AMOUNT_PER_PQTY", "A36"."INTERCO_INVOICED_FLAG" "INTERCO_INVOICED_FLAG", "A36"."INVOICED_AMOUNT" "INVOICED_AMOUNT", "A36"."RETROBILL_REQUEST_ID" "RETROBILL_REQUEST_ID", "A36"."TAX_RATE_ID" "TAX_RATE_ID" FROM "PO_PRICE_ADJUSTMENTS_XML" "A36" WHERE "A36"."PO_HEADER_ID"="A2"."FROM_HEADER_ID" AND "A36"."PO_LINE_ID"="A2"."FROM_LINE_ID" AND "A36"."PARENT_ADJUSTMENT_ID" IS NULL ORDER BY "A36"."PRICING_GROUP_SEQUENCE") "ADD_PRICE_MODIFIERS", CURSOR (SELECT "A35"."SEGMENT1" "PONUM" FROM "PO"."PO_HEADERS_ALL" "A35" WHERE "A35"."PO_HEADER_ID"="A2"."FROM_HEADER_ID") "ADD_PRICE_PONUM", CURSOR (SELECT "A34"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A34" WHERE ("A34"."ENTITY_NAME"='PO_LINES' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A34"."ENTITY_NAME"='PO_HEADERS' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='PO_HEADERS' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A34"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORGID"()) AND "A34"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL) AND "A34"."DATATYPE_ID"=5 AND "A34"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A34"."SEQ_NUM") "LINE_URL_ATTACHMENTS", CURSOR (SELECT "A33"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A33" WHERE ("A33"."ENTITY_NAME"='PO_LINES' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A33"."ENTITY_NAME"='PO_HEADERS' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A33"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A33"."ENTITY_NAME"='PO_HEADERS' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL OR "A33"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A33"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORGID"()) AND "A33"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL) AND "A33"."DATATYPE_ID"=6 AND "A33"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A33"."SEQ_NUM") "LINE_FILE_ATTACHMENTS", CURSOR (SELECT "A32"."SHIPMENT_NUM" "SHIPMENT_NUM", "A32"."DUE_DATE" "DUE_DATE", "A32"."QUANTITY" "QUANTITY", "A32"."PRICE_OVERRIDE" "PRICE_OVERRIDE", "A32"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A32"."CANCEL_FLAG" "CANCEL_FLAG", "A32"."CANCEL_DATE" "CANCEL_DATE", "A32"."CANCEL_REASON" "CANCEL_REASON", "A32"."TAXABLE_FLAG" "TAXABLE_FLAG", "A32"."START_DATE" "START_DATE", "A32"."END_DATE" "END_DATE", "A32"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A32"."ATTRIBUTE1" "ATTRIBUTE1", "A32"."ATTRIBUTE2" "ATTRIBUTE2", "A32"."ATTRIBUTE3" "ATTRIBUTE3", "A32"."ATTRIBUTE4" "ATTRIBUTE4", "A32"."ATTRIBUTE5" "ATTRIBUTE5", "A32"."ATTRIBUTE6" "ATTRIBUTE6", "A32"."ATTRIBUTE7" "ATTRIBUTE7", "A32"."ATTRIBUTE8" "ATTRIBUTE8", "A32"."ATTRIBUTE9" "ATTRIBUTE9", "A32"."ATTRIBUTE10" "ATTRIBUTE10", "A32"."ATTRIBUTE11" "ATTRIBUTE11", "A32"."ATTRIBUTE12" "ATTRIBUTE12", "A32"."ATTRIBUTE13" "ATTRIBUTE13", "A32"."ATTRIBUTE14" "ATTRIBUTE14", "A32"."ATTRIBUTE15" "ATTRIBUTE15", "A32"."PO_HEADER_ID" "PO_HEADER_ID", "A32"."PO_LINE_ID" "PO_LINE_ID", "A32"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A32"."SHIPMENT_TYPE" "SHIPMENT_TYPE", "A32"."PO_RELEASE_ID" "PO_RELEASE_ID", "A32"."CONSIGNED_FLAG" "CONSIGNED_FLAG", "A32"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A32"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A32"."RECEIVING_ROUTING_ID" "RECEIVING_ROUTING_ID", "A32"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A32"."CLOSED_REASON" "CLOSED_REASON", "A32"."CLOSED_DATE" "CLOSED_DATE", "A32"."CLOSED_BY" "CLOSED_BY", "A32"."ORG_ID" "ORG_ID", "A32"."UNIT_OF_MEASURE_CLASS" "UNIT_OF_MEASURE_CLASS", "A32"."ENCUMBER_NOW" "ENCUMBER_NOW", "A32"."INSPECTION_REQUIRED_FLAG" "INSPECTION_REQUIRED_FLAG", "A32"."RECEIPT_REQUIRED_FLAG" "RECEIPT_REQUIRED_FLAG", "A32"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A32"."QTY_RCV_EXCEPTION_CODE" "QTY_RCV_EXCEPTION_CODE", "A32"."ENFORCE_SHIP_TO_LOCATION_CODE" "ENFORCE_SHIP_TO_LOCATION_CODE", "A32"."ALLOW_SUBSTITUTE_RECEIPTS_FLAG" "ALLOW_SUBSTITUTE_RECEIPTS_FLAG", "A32"."DAYS_EARLY_RECEIPT_ALLOWED" "DAYS_EARLY_RECEIPT_ALLOWED", "A32"."DAYS_LATE_RECEIPT_ALLOWED" "DAYS_LATE_RECEIPT_ALLOWED", "A32"."RECEIPT_DAYS_EXCEPTION_CODE" "RECEIPT_DAYS_EXCEPTION_CODE", "A32"."INVOICE_CLOSE_TOLERANCE" "INVOICE_CLOSE_TOLERANCE", "A32"."RECEIVE_CLOSE_TOLERANCE" "RECEIVE_CLOSE_TOLERANCE", "A32"."SHIP_TO_OR GANIZATION_ID" "SHIP_TO_ORGANIZATION_ID", "A32"."SOURCE_SHIPMENT_ID" "SOURCE_SHIPMENT_ID", "A32"."CLOSED_CODE" "CLOSED_CODE", "A32"."REQUEST_ID" "REQUEST_ID", "A32"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A32"."PROGRAM_ID" "PROGRAM_ID", "A32"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A32"."LAST_ACCEPT_DATE" "LAST_ACCEPT_DATE", "A32"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A32"."ENCUMBERED_DATE" "ENCUMBERED_DATE", "A32"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A32"."FOB_LOOKUP_CODE" "FOB_LOOKUP_CODE", "A32"."FREIGHT_TERMS_LOOKUP_CODE" "FREIGHT_TERMS_LOOKUP_CODE", "A32"."ESTIMATED_TAX_AMOUNT" "ESTIMATED_TAX_AMOUNT", "A32"."FROM_HEADER_ID" "FROM_HEADER_ID", "A32"."FROM_LINE_ID" "FROM_LINE_ID", "A32"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A32"."LEAD_TIME" "LEAD_TIME", "A32"."LEAD_TIME_UNIT" "LEAD_TIME_UNIT", "A32"."PRICE_DISCOUNT" "PRICE_DISCOUNT", "A32"."TERMS_ID" "TERMS_ID", "A32"."APPROVED_FLAG" "APPROVED_FLAG", "A32"."APPROVED_DATE" "APPROVED_DATE", "A32"."CLOSED_FLAG" "CLOSED_FLAG", "A32"."CANCELLED_BY" "CANCELLED_BY", "A32"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A32"."FIRM_DATE" "FIRM_DATE", "A32"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A32"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A32"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A32"."CREATION_DATE" "CREATION_DATE", "A32"."CREATED_BY" "CREATED_BY", "A32"."QUANTITY_RECEIVED" "QUANTITY_RECEIVED", "A32"."QUANTITY_ACCEPTED" "QUANTITY_ACCEPTED", "A32"."QUANTITY_REJECTED" "QUANTITY_REJECTED", "A32"."QUANTITY_BILLED" "QUANTITY_BILLED", "A32"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A32"."SHIP_VIA_LOOKUP_CODE" "SHIP_VIA_LOOKUP_CODE", "A32"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A32"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A32"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A32"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A32"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A32"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A32"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A32"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A32"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A32"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A32"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A32"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A32"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A32"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A32"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A32"."GLOBAL_ATTRIB UTE15" "GLOBAL_ATTRIBUTE15", "A32"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A32"."GLOBAL_ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A32"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A32"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A32"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A32"."QUANTITY_SHIPPED" "QUANTITY_SHIPPED", "A32"."COUNTRY_OF_ORIGIN_CODE" "COUNTRY_OF_ORIGIN_CODE", "A32"."TAX_USER_OVERRIDE_FLAG" "TAX_USER_OVERRIDE_FLAG", "A32"."MATCH_OPTION" "MATCH_OPTION", "A32"."TAX_CODE_ID" "TAX_CODE_ID", "A32"."CALCULATE_TAX_FLAG" "CALCULATE_TAX_FLAG", "A32"."CHANGE_PROMISED_DATE_REASON" "CHANGE_PROMISED_DATE_REASON", "A32"."NOTE_TO_RECEIVER" "NOTE_TO_RECEIVER", "A32"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A32"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A32"."PREFERRED_GRADE" "PREFERRED_GRADE", "A32"."SECONDARY_QUANTITY_RECEIVED" "SECONDARY_QUANTITY_RECEIVED", "A32"."SECONDARY_QUANTITY_ACCEPTED" "SECONDARY_QUANTITY_ACCEPTED", "A32"."SECONDARY_QUANTITY_REJECTED" "SECONDARY_QUANTITY_REJECTED", "A32"."SECONDARY_QUANTITY_CANCELLED" "SECONDARY_QUANTITY_CANCELLED", "A32"."VMI_FLAG" "VMI_FLAG", "A32"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A32"."SUPPLIER_ORDER_LINE_NUMBER" "SUPPLIER_ORDER_LINE_NUMBER", "A32"."AMOUNT" "AMOUNT", "A32"."AMOUNT_RECEIVED" "AMOUNT_RECEIVED", "A32"."AMOUNT_BILLED" "AMOUNT_BILLED", "A32"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A32"."AMOUNT_ACCEPTED" "AMOUNT_ACCEPTED", "A32"."AMOUNT_REJECTED" "AMOUNT_REJECTED", "A32"."DROP_SHIP_FLAG" "DROP_SHIP_FLAG", "A32"."SALES_ORDER_UPDATE_DATE" "SALES_ORDER_UPDATE_DATE", "A32"."SHIP_TO_LOCATION_ID" "SHIP_TO_LOCATION_ID", "A32"."SHIP_TO_LOCATION_NAME" "SHIP_TO_LOCATION_NAME", "A32"."SHIP_TO_ADDRESS_LINE1" "SHIP_TO_ADDRESS_LINE1", "A32"."SHIP_TO_ADDRESS_LINE2" "SHIP_TO_ADDRESS_LINE2", "A32"."SHIP_TO_ADDRESS_LINE3" "SHIP_TO_ADDRESS_LINE3", "A32"."SHIP_TO_ADDRESS_LINE4" "SHIP_TO_ADDRESS_LINE4", "A32"."SHIP_TO_ADDRESS_INFO" "SHIP_TO_ADDRESS_INFO", "A32"."SHIP_TO_COUNTRY" "SHIP_TO_COUNTRY", "A32"."IS_SHIPMENT_ONE_TIME_LOC" "IS_SHIPMENT_ONE_TIME_LOC", "A32"."ONE_TIME_ADDRESS_DETAILS" "ONE_TIME_ADDRESS_DETAILS", "A32"."DETAILS" "DETAILS", "A32"."SHIP_CONT_PHONE" "SHIP_CONT_PHONE", "A32"."SHIP_CONT_EMAIL" "SHIP_CONT_EMAIL", "A32"."ULTIMATE_DELIVER_CONT_PHONE" "ULTIMATE_DELIVER_CONT_PHONE", "A32"."ULTIMATE_DELIVER_CONT_EMAIL" "ULTIMATE_DELIVER_CONT_EMAIL", "A32"."SHIP_CONT_NAME" "SHIP_CONT_NAME", "A32"."ULTIMATE_DELIVER_CONT_NAME" "ULTIMATE_DELIVER_CONT_NAME", "A32"."SHIP_CUST_NAME" "SHIP_CUST_NAME", "A32 "."SHIP_CUST_LOCATION" "SHIP_CUST_LOCATION", "A32"."ULTIMATE_DELIVER_CUST_NAME" "ULTIMATE_DELIVER_CUST_NAME", "A32"."ULTIMATE_DELIVER_CUST_LOCATION" "ULTIMATE_DELIVER_CUST_LOCATION", "A32"."SHIP_TO_CONTACT_FAX" "SHIP_TO_CONTACT_FAX", "A32"."ULTIMATE_DELIVER_TO_CONT_NAME" "ULTIMATE_DELIVER_TO_CONT_NAME", "A32"."ULTIMATE_DELIVER_TO_CONT_FAX" "ULTIMATE_DELIVER_TO_CONT_FAX", "A32"."SHIPPING_METHOD" "SHIPPING_METHOD", "A32"."SHIPPING_INSTRUCTIONS" "SHIPPING_INSTRUCTIONS", "A32"."PACKING_INSTRUCTIONS" "PACKING_INSTRUCTIONS", "A32"."CUSTOMER_PRODUCT_DESC" "CUSTOMER_PRODUCT_DESC", "A32"."CUSTOMER_PO_NUM" "CUSTOMER_PO_NUM", "A32"."CUSTOMER_PO_LINE_NUM" "CUSTOMER_PO_LINE_NUM", "A32"."CUSTOMER_PO_SHIPMENT_NUM" "CUSTOMER_PO_SHIPMENT_NUM", "A32"."NEED_BY_DATE" "NEED_BY_DATE", "A32"."PROMISED_DATE" "PROMISED_DATE", "A32"."TOTAL_SHIPMENT_AMOUNT" "TOTAL_SHIPMENT_AMOUNT", "A32"."FINAL_MATCH_FLAG" "FINAL_MATCH_FLAG", "A32"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A32"."TAX_NAME" "TAX_NAME", "A32"."TRANSACTION_FLOW_HEADER_ID" "TRANSACTION_FLOW_HEADER_ID", "A32"."VALUE_BASIS" "VALUE_BASIS", "A32"."MATCHING_BASIS" "MATCHING_BASIS", "A32"."PAYMENT_TYPE" "PAYMENT_TYPE", "A32"."DESCRIPTION" "DESCRIPTION", "A32"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A32"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A32"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A32"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A32"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A32"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT", "A32"."WORK_APPROVER_ID" "WORK_APPROVER_ID", "A32"."BID_PAYMENT_ID" "BID_PAYMENT_ID", "A32"."AMOUNT_SHIPPED" "AMOUNT_SHIPPED", CURSOR (SELECT "A32"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A89"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A90", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A89" WHERE "A90"."ENTITY_NAME"='PO_SHIPMENTS' AND "A90"."PK1_VALUE"=TO_CHAR("A32"."LINE_LOCATION_ID") AND "A90"."FUNCTION_NAME"='PO_PRINTPO' AND "A90"."MEDIA_ID"="A89"."MEDIA_ID" AND "A90"."DATATYPE_ID"=1 ORDER BY "A90"."SEQ_NUM") "LINE_LOC_SHORT_TEXT", CURSOR (SELECT "A88"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A88" WHERE "A88"."ENTITY_NAME"='PO_SHIPMENTS' AND "A88"."PK1_VALUE"=TO_CHAR("A32"."LINE_LOCATION_ID") AND "A88"."DATATYPE_ID"=5 AND "A88"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A88"."SEQ_NUM") "LINE_LOC_URL_ATTACHMENTS", CURSOR (SELECT "A87"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A87" WHERE "A87"."ENTITY_NAME"='PO_SHIPM ENTS' AND "A87"."PK1_VALUE"=TO_CHAR("A32"."LINE_LOCATION_ID") AND "A87"."DATATYPE_ID"=6 AND "A87"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A87"."SEQ_NUM") "LINE_LOC_FILE_ATTACHMENTS", CURSOR (SELECT "A86"."AMOUNT_ORDERED" "AMOUNT_ORDERED", "A86"."AMOUNT_DELIVERED" "AMOUNT_DELIVERED", "A86"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A86"."DISTRIBUTION_TYPE" "DISTRIBUTION_TYPE", "A86"."AMOUNT_TO_ENCUMBER" "AMOUNT_TO_ENCUMBER", "A86"."INVOICE_ADJUSTMENT_FLAG" "INVOICE_ADJUSTMENT_FLAG", "A86"."DEST_CHARGE_ACCOUNT_ID" "DEST_CHARGE_ACCOUNT_ID", "A86"."DEST_VARIANCE_ACCOUNT_ID" "DEST_VARIANCE_ACCOUNT_ID", "A86"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A86"."PROJECT_ID" "PROJECT_ID", "A86"."TASK_ID" "TASK_ID", "A86"."EXPENDITURE_TYPE" "EXPENDITURE_TYPE", "A86"."PROJECT_ACCOUNTING_CONTEXT" "PROJECT_ACCOUNTING_CONTEXT", "A86"."EXPENDITURE_ORGANIZATION_ID" "EXPENDITURE_ORGANIZATION_ID", "A86"."GL_CLOSED_DATE" "GL_CLOSED_DATE", "A86"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A86"."EXPENDITURE_ITEM_DATE" "EXPENDITURE_ITEM_DATE", "A86"."ORG_ID" "ORG_ID", "A86"."GL_ENCUMBERED_PERIOD_NAME" "GL_ENCUMBERED_PERIOD_NAME", "A86"."GL_CANCELLED_DATE" "GL_CANCELLED_DATE", "A86"."DESTINATION_TYPE_CODE" "DESTINATION_TYPE_CODE", "A86"."DESTINATION_ORGANIZATION_ID" "DESTINATION_ORGANIZATION_ID", "A86"."DESTINATION_SUBINVENTORY" "DESTINATION_SUBINVENTORY", "A86"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A86"."ATTRIBUTE1" "ATTRIBUTE1", "A86"."ATTRIBUTE2" "ATTRIBUTE2", "A86"."ATTRIBUTE3" "ATTRIBUTE3", "A86"."ATTRIBUTE4" "ATTRIBUTE4", "A86"."ATTRIBUTE5" "ATTRIBUTE5", "A86"."ATTRIBUTE6" "ATTRIBUTE6", "A86"."ATTRIBUTE7" "ATTRIBUTE7", "A86"."ATTRIBUTE8" "ATTRIBUTE8", "A86"."ATTRIBUTE9" "ATTRIBUTE9", "A86"."ATTRIBUTE10" "ATTRIBUTE10", "A86"."ATTRIBUTE11" "ATTRIBUTE11", "A86"."ATTRIBUTE12" "ATTRIBUTE12", "A86"."ATTRIBUTE13" "ATTRIBUTE13", "A86"."ATTRIBUTE14" "ATTRIBUTE14", "A86"."ATTRIBUTE15" "ATTRIBUTE15", "A86"."WIP_ENTITY_ID" "WIP_ENTITY_ID", "A86"."WIP_OPERATION_SEQ_NUM" "WIP_OPERATION_SEQ_NUM", "A86"."WIP_RESOURCE_SEQ_NUM" "WIP_RESOURCE_SEQ_NUM", "A86"."WIP_REPETITIVE_SCHEDULE_ID" "WIP_REPETITIVE_SCHEDULE_ID", "A86"."WIP_LINE_ID" "WIP_LINE_ID", "A86"."BOM_RESOURCE_ID" "BOM_RESOURCE_ID", "A86"."BUDGET_ACCOUNT_ID" "BUDGET_ACCOUNT_ID", "A86"."ACCRUAL_ACCOUNT_ID" "ACCRUAL_ACCOUNT_ID", "A86"."VARIANCE_ACCOUNT_ID" "VARIANCE_ACCOUNT_ID", "A86"."PREVENT_ENCUMBRANCE_FLAG" "PREVENT_ENCUMBRANCE_FLAG", " A86"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A86"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A86"."PO_DISTRIBUTION_ID" "PO_DISTRIBUTION_ID", "A86"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A86"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A86"."PO_HEADER_ID" "PO_HEADER_ID", "A86"."PO_LINE_ID" "PO_LINE_ID", "A86"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A86"."SET_OF_BOOKS_ID" "SET_OF_BOOKS_ID", "A86"."CODE_COMBINATION_ID" "CODE_COMBINATION_ID", "A86"."QUANTITY_ORDERED" "QUANTITY_ORDERED", "A86"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A86"."CREATION_DATE" "CREATION_DATE", "A86"."CREATED_BY" "CREATED_BY", "A86"."PO_RELEASE_ID" "PO_RELEASE_ID", "A86"."QUANTITY_DELIVERED" "QUANTITY_DELIVERED", "A86"."QUANTITY_BILLED" "QUANTITY_BILLED", "A86"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A86"."REQ_HEADER_REFERENCE_NUM" "REQ_HEADER_REFERENCE_NUM", "A86"."REQ_LINE_REFERENCE_NUM" "REQ_LINE_REFERENCE_NUM", "A86"."REQ_DISTRIBUTION_ID" "REQ_DISTRIBUTION_ID", "A86"."DELIVER_TO_LOCATION_ID" "DELIVER_TO_LOCATION_ID", "A86"."DELIVER_TO_PERSON_ID" "DELIVER_TO_PERSON_ID", "A86"."RATE_DATE" "RATE_DATE", "A86"."RATE" "RATE", "A86"."AMOUNT_BILLED" "AMOUNT_BILLED", "A86"."ACCRUED_FLAG" "ACCRUED_FLAG", "A86"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A86"."ENCUMBERED_AMOUNT" "ENCUMBERED_AMOUNT", "A86"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A86"."UNENCUMBERED_AMOUNT" "UNENCUMBERED_AMOUNT", "A86"."FAILED_FUNDS_LOOKUP_CODE" "FAILED_FUNDS_LOOKUP_CODE", "A86"."GL_ENCUMBERED_DATE" "GL_ENCUMBERED_DATE", "A86"."KANBAN_CARD_ID" "KANBAN_CARD_ID", "A86"."END_ITEM_UNIT_NUMBER" "END_ITEM_UNIT_NUMBER", "A86"."AWARD_ID" "AWARD_ID", "A86"."MRC_RATE_DATE" "MRC_RATE_DATE", "A86"."MRC_RATE" "MRC_RATE", "A86"."MRC_ENCUMBERED_AMOUNT" "MRC_ENCUMBERED_AMOUNT", "A86"."MRC_UNENCUMBERED_AMOUNT" "MRC_UNENCUMBERED_AMOUNT", "A86"."RECOVERABLE_TAX" "RECOVERABLE_TAX", "A86"."NONRECOVERABLE_TAX" "NONRECOVERABLE_TAX", "A86"."RECOVERY_RATE" "RECOVERY_RATE", "A86"."TAX_RECOVERY_OVERRIDE_FLAG" "TAX_RECOVERY_OVERRIDE_FLAG", "A86"."OKE_CONTRACT_LINE_ID" "OKE_CONTRACT_LINE_ID", "A86"."OKE_CONTRACT_DELIVERABLE_ID" "OKE_CONTRACT_DELIVERABLE_ID", "A86"."DESTINATION_CONTEXT" "DESTINATION_CONTEXT", "A86"."DISTRIBUTION_NUM" "DISTRIBUTION_NUM", "A86"."SOURCE_DISTRIBUTION_ID" "SOURCE_DISTRIBUTION_ID", "A86"."REQUEST_ID" "REQUEST_ID", "A86"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A86"."PROGRAM_ID" "PROGRAM_ID", "A86"."CHARGE_ACCOUNT " "CHARGE_ACCOUNT", "A86"."FULL_NAME" "FULL_NAME", "A86"."WORK_TELEPHONE" "WORK_TELEPHONE", "A86"."EMAIL_ADDRESS" "EMAIL_ADDRESS", "A86"."REQUESTER_DELIVER_FIRST_NAME" "REQUESTER_DELIVER_FIRST_NAME", "A86"."REQUESTER_DELIVER_LAST_NAME" "REQUESTER_DELIVER_LAST_NAME", "A86"."REQUESTER_DELIVER_TITLE" "REQUESTER_DELIVER_TITLE", "A86"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A86"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A86"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A86"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A86"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A86"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT" FROM "PO_DISTRIBUTION_XML" "A86" WHERE "A86"."PO_HEADER_ID"=:CV1$ AND "A86"."LINE_LOCATION_ID"="A32"."LINE_LOCATION_ID") "DISTRIBUTIONS" FROM "PO_LINE_LOCATIONS_XML" "A32" WHERE "A32"."PO_LINE_ID"="A2"."PO_LINE_ID" AND NVL("A32"."PAYMENT_TYPE", 'NONE')<>'ADVANCE' AND NVL("A32"."PAYMENT_TYPE", 'NONE')<>'DELIVERY') "LINE_LOCATIONS" FROM "PO_LINES_XML" "A2" WHERE "A2"."PO_HEADER_ID"=:CV1$
85gad38y8bvv3begin :1 :=PO_COMMUNICATION_PVT.POXMLGEN( :2, :3, :4, :5, :6, :7, :8, :9); end;
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
9ybx57rqdhm4mBEGIN PO_INTERFACE_S.create_documents( p_api_version => 1.0, x_return_status => :1, x_msg_count => :2, x_msg_data => :3, p_batch_id => :4, p_req_operating_unit_id => :5, p_purch_operating_unit_id => :6, x_document_id => :7, x_number_lines => :8, x_document_number => :9, p_document_creation_method => 'AUTOCREATE'); END;
a4gss3ajbyfzrSELECT R.RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL R WHERE R.RESPONSIBILITY_ID = :B2 AND R.APPLICATION_ID = :B1
aaw4na3kmdfkqDECLARE l_result varchar2(1); BEGIN l_result := FND_AOLJ_UTIL.convertGuestSession(:1, :2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); :21 := l_result;END;
akma8kaxsp84b SELECT reservation_id , requirement_date , organization_id , inventory_item_id , demand_source_type_id , demand_source_name , demand_source_header_id , demand_source_line_id , demand_source_delivery , primary_uom_code , primary_uom_id , secondary_uom_code , secondary_uom_id , reservation_uom_code , reservation_uom_id , reservation_quantity , primary_reservation_quantity , secondary_reservation_quantity , detailed_quantity , secondary_detailed_quantity , autodetail_group_id , external_source_code , external_source_line_id , supply_source_type_id , supply_source_header_id , supply_source_line_id , supply_source_name , supply_source_line_detail , revision , subinventory_code , subinventory_id , locator_id , lot_number , lot_number_id , pick_slip_number , lpn_id , attribute_category , attribute1 , attribute2 , attribute3 , attribute4 , attribute5 , attribute6 , attribute7 , attribute8 , attribute9 , attribute10 , attribute11 , attribute12 , attribute13 , attribute14 , attribute15 , ship_ready_flag , staged_flag /**** {{ R12 Enhanced reservations code changes }}****/ , crossdock_flag , crossdock_criteria_id , demand_source_line_detail , serial_reservation_quantity , supply_receipt_date , demand_ship_date , project_id , task_id , orig_supply_source_type_id , orig_supply_source_header_id , orig_supply_source_line_id , orig_supply_source_line_detail , orig_demand_source_type_id , orig_demand_source_header_id , orig_demand_source_line_id , orig_demand_source_line_detail , serial_number /***** End R12 ***/ FROM mtl_reservations WHERE (:requirement_date = :l_miss_date OR :requirement_date IS NULL AND requirement_date IS NULL OR :requirement_date = requirement_date ) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id ) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id ) AND (:demand_source_type_id = :l_miss_num OR :demand_source_type_id IS NULL AND demand_source_type_id IS NULL OR :demand_source_type_id = demand_source_type_id ) AND (:demand_source_header_id = :l_miss_num OR :demand_source_header_id IS NULL AND demand_source_header_id IS NULL OR :demand_source_header_id = demand_source_header_id ) AND (:demand_source_line_id = :l_miss_num OR :demand_source_line_id IS NULL AND demand_source_line_id IS NULL OR :demand_source_line_id = demand_source_line_id ) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name ) AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery ) AND (:primary_uom_code = :l_miss_char OR :primary_uom_code IS NULL AND primary_uom_code IS NULL OR :primary_uom_code = primary_uom_code ) AND (:primary_uom_id = :l_miss_num OR :primary_uom_id IS NULL AND primary_uom_id IS NULL OR :primary_uom_id = primary_uom_id ) -- INVCONV BEGIN AND (:secondary_uom_code = :l_miss_char OR :secondary_uom_code IS NULL AND secondary_uom_code IS NULL OR :secondary_uom_code = secondary_uom_code ) AND (:secondary_uom_id = :l_miss_num OR :secondary_uom_id IS NULL AND secondary_uom_id IS NULL OR :secondary_uom_id = secondary_uom_id ) -- INVCONV END AND (:reservation_uom_code = :l_miss_char OR :reservation_uom_code IS NULL AND reservation_uom_code IS NULL OR :reservation_uom_code = reservation_uom_code ) AND (:reservation_uom_id = :l_miss_num OR :reservation_uom_id IS NULL AND reservation_uom_id IS NULL OR :reservation_uom_id = reservation_uom_id ) AND (:autodetail_group_id = :l_miss_num OR :autodetail_group_id IS NULL AND autodetail_group_id IS NULL OR :autodetail_group_id = autodetail_group_id ) AND (:external_source_code = :l_miss_char OR :external_source_code IS NULL AND external_source_code IS NULL OR :external_s ource_code = external_source_code ) AND (:external_source_line_id = :l_miss_num OR :external_source_line_id IS NULL AND external_source_line_id IS NULL OR :external_source_line_id = external_source_line_id ) AND (:supply_source_type_id = :l_miss_num OR :supply_source_type_id IS NULL AND supply_source_type_id IS NULL OR :supply_source_type_id = supply_source_type_id ) AND (:supply_source_header_id = :l_miss_num OR :supply_source_header_id IS NULL AND supply_source_header_id IS NULL OR :supply_source_header_id = supply_source_header_id ) AND (:supply_source_line_id = :l_miss_num OR :supply_source_line_id IS NULL AND supply_source_line_id IS NULL OR :supply_source_line_id = supply_source_line_id ) AND (:supply_source_name = :l_miss_char OR :supply_source_name IS NULL AND supply_source_name IS NULL OR :supply_source_name = supply_source_name ) AND (:supply_source_line_detail = :l_miss_num OR :supply_source_line_detail IS NULL AND supply_source_line_detail IS NULL OR :supply_source_line_detail = supply_source_line_detail ) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision ) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code ) AND (:subinventory_id = :l_miss_num OR :subinventory_id IS NULL AND subinventory_id IS NULL OR :subinventory_id = subinventory_id ) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id ) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number ) AND (:lot_number_id = :l_miss_num OR :lot_number_id IS NULL AND lot_number_id IS NULL OR :lot_number_id = lot_number_id ) AND (:lpn_id = :l_miss_num OR :lpn_id IS NULL AND lpn_id IS NULL OR :lpn_id = lpn_id ) AND (:ship_ready_flag = :l_miss_num OR (:ship_ready_flag IS NULL OR :ship_ready_flag = 2) AND (ship_ready_flag IS NULL OR ship_ready_flag = 2) OR :ship_ready_flag = ship_ready_flag ) AND (:staged_flag = :l_miss_char OR (:staged_flag IS NULL OR :staged_flag = 'N') AND (staged_flag IS NULL OR staged_flag = 'N') OR :staged_flag = staged_flag ) AND (:attribute_category = :l_miss_char OR :attribute_category IS NULL AND attribute_category IS NULL OR :attribute_category = attribute_category ) AND (:attribute1 = :l_miss_char OR :attribute1 IS NULL AND attribute1 IS NULL OR :attribute1 = attribute1 ) AND (:attribute2 = :l_miss_char OR :attribute2 IS NULL AND attribute2 IS NULL OR :attribute2 = attribute2 ) AND (:attribute3 = :l_miss_char OR :attribute3 IS NULL AND attribute3 IS NULL OR :attribute3 = attribute3 ) AND (:attribute4 = :l_miss_char OR :attribute4 IS NULL AND attribute4 IS NULL OR :attribute4 = attribute4 ) AND (:attribute5 = :l_miss_char OR :attribute5 IS NULL AND attribute5 IS NULL OR :attribute5 = attribute5 ) AND (:attribute6 = :l_miss_char OR :attribute6 IS NULL AND attribute6 IS NULL OR :attribute6 = attribute6 ) AND (:attribute7 = :l_miss_char OR :attribute7 IS NULL AND attribute7 IS NULL OR :attribute7 = attribute7 ) AND (:attribute8 = :l_miss_char OR :attribute8 IS NULL AND attribute8 IS NULL OR :attribute8 = attribute8 ) AND (:attribute9 = :l_miss_char OR :attribute9 IS NULL AND attribute9 IS NULL OR :attribute9 = attribute9 ) AND (:attribute10 = :l_miss_char OR :attribute10 IS NULL AND attribute10 IS NULL OR :attribute10 = attribute10 ) AND (:attribute11 = :l_miss_char OR :attribute11 IS NULL AND attribute11 IS NULL OR :attribute11 = attribute11 ) AND (:attribute12 = :l_miss_char OR :attribute12 IS NULL AND attribute12 IS NULL OR :attribute12 = attribute12 ) AND (:attribute13 = :l_miss_char OR :attribute13 IS NULL AND attribute13 IS NULL OR :attribute13 = attribute13 ) AND (:attribute14 = :l_miss_char OR :attribute14 IS NULL AND attribute14 IS NULL OR :attribute14 = attribute14 ) AND (:attribute15 = :l_miss_char OR :attribute15 IS NULL AND attribute15 IS NULL OR :attribute15 = attribute15 ) /**** {{ R12 Enhanced reserv ations code changes }}****/ AND (:crossdock_flag = :l_miss_char OR :crossdock_flag IS NULL AND crossdock_flag IS NULL OR :crossdock_flag = crossdock_flag ) AND (:crossdock_criteria_id = :l_miss_num OR :crossdock_criteria_id IS NULL AND crossdock_criteria_id IS NULL OR :crossdock_criteria_id = crossdock_criteria_id ) AND (:demand_source_line_detail = :l_miss_num OR :demand_source_line_detail IS NULL AND demand_source_line_detail IS NULL OR :demand_source_line_detail = demand_source_line_detail ) AND (:supply_receipt_date = :l_miss_date OR :supply_receipt_date IS NULL AND supply_receipt_date IS NULL OR :supply_receipt_date = supply_receipt_date ) AND (:demand_ship_date = :l_miss_date OR :demand_ship_date IS NULL AND demand_ship_date IS NULL OR :demand_ship_date = demand_ship_date ) AND (:project_id = :l_miss_num OR :project_id IS NULL AND project_id IS NULL OR :project_id = project_id ) AND (:task_id = :l_miss_num OR :task_id IS NULL AND task_id IS NULL OR :task_id = task_id ) /***** End R12 ***/ ORDER BY NVL(DEMAND_SHIP_DATE, REQUIREMENT_DATE) ASC
akpdj9s4ug2s2SELECT PATH_DOCID FROM jdr_paths paths, jdr_attributes WHERE rownum=1 AND path_name=:1 AND path_docid=att_comp_docid AND att_comp_seq=0 AND att_name='customizes' AND att_value=:2 AND EXISTS (SELECT 'x' FROM jdr_paths p, jdr_paths owner WHERE owner.path_name = 'customizations' and owner.path_docid = p.path_owner_docid and p.path_name not in ('user', 'portlet') START WITH p.path_docid = paths.path_docid CONNECT BY PRIOR p.path_owner_docid = p.path_docid)
bbugagurwv1vy(SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 ))
ccprbqfuu8wb1SELECT NUMBER_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
ch6akxnh7bfx9SELECT 'Exists' FROM PO_LINES POL WHERE POL.PO_LINE_ID = :B2 AND POL.PO_HEADER_ID = :B1
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
ctnvq3qjh4065begin :1 := por_util_pkg.interface_START_WORKFLOW( :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102); end;
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
f5z70bpcu7f0wbegin :1 := PO_RCO_VALIDATION_GRP.IS_REQ_CHANGEABLE(:2); end;
fc1vzazaaduns SELECT phx.*, PO_COMMUNICATION_PVT.getIsComplexWorkPO() is_complex_work_po, PO_COMMUNICATION_PVT.getDocumentType() document_type, PO_COMMUNICATION_PVT.getCoverMessage() cover_message, PO_COMMUNICATION_PVT.getTimezone() timezone, PO_COMMUNICATION_PVT.getAmendmentMessage() ammendment_message, PO_COMMUNICATION_PVT.getTestFlag() test_flag, PO_COMMUNICATION_PVT.getDistinctShipmentCount() DIST_SHIPMENT_COUNT, PO_COMMUNICATION_PVT.getDocumentName() document_name, PO_COMMUNICATION_PVT.IsDocumentSigned(PO_COMMUNICATION_PVT.getDocumentId()) Signed, fnd_profile.value('PO_GENERATE_AMENDMENT_DOCS') amendment_profile, PO_COMMUNICATION_PVT.getWithTerms() With_Terms , PO_COMMUNICATION_PVT.getIsContractAttachedDoc() Is_Attached_Doc , CURSOR (SELECT message_name message, message_text text FROM fnd_new_messages WHERE message_name in ( 'PO_WF_NOTIF_REVISION', 'PO_WF_NOTIF_VENDOR_NO', 'PO_WF_NOTIF_PAYMENT_TERMS', 'PO_WF_NOTIF_FREIGHT_TERMS', 'PO_WF_NOTIF_FOB', 'PO_WF_NOTIF_SHIP_VIA', 'PO_WF_NOTIF_CONFIRM_TO_TELE', 'PO_WF_NOTIF_REQUESTER_DELIVER', 'PO_WF_NOTIF_DESCRIPTION', 'PO_WF_NOTIF_TAX', 'PO_WF_NOTIF_UOM', 'PO_WF_NOTIF_UNIT_PRICE', 'PO_WF_NOTIF_QUANTITY', 'PO_WF_NOTIF_PURCHASE_ORDER', 'PO_WF_NOTIF_BUYER', 'PO_WF_NOTIF_AMOUNT', 'PO_WF_NOTIF_EFFECTIVE_DATE', 'PO_WF_NOTIF_HEADER_NOTE', 'PO_WF_NOTIF_LINE_NUMBER', 'PO_WF_NOTIF_LINE_PAYITEM_NUM', -- <Complex Work R12> 'PO_WF_NOTIF_MULTIPLE', 'PO_WF_NOTIF_PART_NO_DESC', 'PO_WF_NOTIF_SUPPLIER_ITEM', 'PO_WF_NOTIF_TOTAL', 'PO_WF_NOTIF_NOTE', 'PO_FO_PACKING_INSTRUCTION', 'PO_FO_CUST_PO_NUMBER', 'PO_FO_CUST_ITEM_DESC', 'PO_FO_LINE_NUMBER', 'PO_FO_SHIP_NUMBER', 'PO_FO_AMOUNT_BASED', 'PO_FO_CONTRACTOR_NAME', 'PO_FO_START_DATE', 'PO_FO_END_DATE', 'PO_FO_WORK_SCHEDULE', 'PO_FO_SHIFT_PATTERN', 'PO_FO_PRICE_DIFFERENTIALS', 'PO_FO_DELIVER_TO_LOCATION', 'PO_FO_EFFECTIVE_START_DATE', 'PO_FO_AMOUNT_AGREED', 'PO_FO_ADVANCE', -- <Complex Work R12> 'PO_FO_RETAINAGE_RATE', -- <Complex Work R12> 'PO_FO_MAX_RETAINAGE_AMOUNT', -- <Complex Work R12> 'PO_FO_PROGRESS_PAYMENT_RATE', -- <Complex Work R12> 'PO_FO_RECOUPMENT_RATE', -- <Complex Work R12> 'PO_FO_PRICE_BREAK', 'PO_FO_CHARGE_ACCOUNT', 'PO_FO_CONTRACTOR', 'PO_FO_CONTACT_NAME', 'PO_FO_TELEPHONE', 'PO_FO_FAX', 'PO_FO_NAME', 'PO_FO_TITLE', 'PO_FO_DATE', 'PO_FO_REVISION', 'PO_FO_AMENDMENT', 'PO_FO_SHIP_METHOD', 'PO_FO_SHIPPING_INSTRUCTION', 'PO_FO_DRAFT', 'PO_FO_PROPRIETARY_INFORMATION', 'PO_FO_TRANSPORTAION_ARRANGED', 'PO_FO_DELIVER_TO_LOCATION', 'PO_FO_NO', 'PO_FO_COMPANY', 'PO_FO_SUBMIT_RESPONSE', 'PO_FO_EMAIL', 'PO_WF_NOTIF_EXPIRES_ON', 'PO_FO_TEST', 'PO_FO_ORG_AGR_ASS', 'PO_FO_EFFECTIVE_END_DATE', 'PO_FO_PURCHASING_ORGANIZATION', 'PO_FO_PURCHASING_SUPPLIER_SITE', 'PO_FO_TRANSPORTATION_ARRANGED', 'PO_WF_NOTIF_ADDRESS', 'PO_WF_NOTIF_ORDER', 'PO_WF_NOTIF_ORDER_DATE', 'PO_FO_VENDOR', 'PO_FO_SHIP_TO', 'PO_FO_BILL_TO', 'PO_FO_CONFIRM_NOT_DUPLICATE', 'PO_FO_AGREEMENT_CANCELED', 'PO_FO_FORMAL_ACCEPT', 'PO_FO_TYPE', 'PO_FO_REVISION_DATE', 'PO_FO_REVISED_BY', 'PO_FO_PRICES_EXPRESSED', 'PO_FO_NOTES', 'PO_WF_NOTIF_PREPARER', 'PO_FO_SUPPLIER_CONFIGURATION', 'PO_FO_DELIVER_DATE_TIME', 'PO_FO_LINE_REF_BPA', 'PO_FO_LINE_REF_CONTRACT', 'PO_FO_LINE_SUPPLIER_QUOTATION', 'PO_FO_USE_SHIP_ADDRESS_TOP', 'PO_FO_LINE_CANCELED', 'PO_FO_ORIGINAL_QTY_ORDERED', 'PO_FO_QUANTITY_CANCELED', 'PO_FO_SHIPMENT_CANCELED', 'PO_FO_ORIGINAL_SHIPMENT_QTY', 'PO_FO_CUSTOMER_ACCOUNT_NO', 'PO_FO_RELEASE_CANCELED', 'PO_FO_PO_CANCELED', 'PO_FO_TOTAL', 'PO_FO_SUPPLIER_ITEM', 'PO_FO_ORIGINAL_AMOUNT_ORDERED', 'PO_FO_AMOUNT_CANCELED', 'PO_FO_UN_NUMBER', 'PO_WF_NOTIF_PROMISED_DATE', 'PO_WF_NOTIF_NEEDBY_DATE', 'PO_FO_HAZARD_CLASS', 'PO_FO_PAGE', 'PO_FO_REFERENCE_DOCUMENTS', 'PO_FO_PAYITEM_CANCELED', --<Bug#: 4899200> 'PO_FO_ORIGINAL_PAYITEM_QTY', --<Bug#: 4899200> 'PO_FO_PAYITEM_QTY_CANCELED', --<Bug#: 4899200> 'PO_FO_ORIGINAL_PAYITEM_AMT', --<Bug#: 5464968> 'PO_FO_MODIFIER_TYPE', --Enhanced Pricing 'PO_FO_BLANKET', --Enhanced Pricing 'PO_FO_BLANKET_PRICE_STRUCT', --Enhanced Pricing 'PO_FO_MODIFIER_DESC', --Enhanced Pricing 'PO_FO_RATE', --Enhanced Pricing 'PO_FO_ADJUSTED_AMT', --Enhanced Pricing 'PO_FO_RATE_APP_METHOD', --Enhanced Pricing 'PO_FO_LIST_LINE_PRICE', --Enhanced Pricing 'PO_FO_PAYITEM_AMT_CANCELED' --<Bug#: 5464968> ) AND application_id = 201 AND language_code = 'US') AS message, CURSOR( SELECT fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE ((entity_name = 'PO_HEADERS' AND pk1_value = to_char(phx.po_header_id)) OR (entity_name = 'PO_VENDORS' AND pk1_value = to_char(phx.vendor_id)) OR (entity_name = 'PO_VENDOR_SITES' AND pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354 function_name = 'PO_PRINTPO' AND fad.media_id = fds.media_id AND fad.datatype_id=1 order by fad.seq_num) AS header_short_text, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name='PO_VENDORS' AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name='PO_VENDOR_SITES' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=5 AND fad.function_name='PO_PRINTPO' order by fad.entity_name, fad.seq_num) AS header_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name='PO_VENDORS' AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name='PO_VENDOR_SITES' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=6 AND fad.function_name='PO_PRINTPO' order by fad.entity_name, fad.seq_num) AS header_file_attachments, CURSOR(SELECT plx.*, CURSOR(SELECT PRICE_TYPE_DSP PRICE_TYPE, MULTIPLIER FROM po_price_differentials_v WHERE entity_type='PO LINE' AND entity_id = plx.po_line_id and enabled_flag='Y') AS price_diff, CURSOR( SELECT plx.po_line_id , fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE ((fad.entity_name='PO_LINES' AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name='MTL_SYSTEM_ITEMS' AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND --Bug6139548 fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name='PO_IN_GA_LINES' AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.CONTRACT_ID) AND plx.CONTRACT_ID IS NOT NULL) ) AND function_name = 'PO_PRINTPO' AND fad.media_id = fds.media_id AND fad.datatype_id=1 order by fad.seq_num) AS line_short_text, CURSOR (SELECT pax1.* FROM PO_PRICE_ADJUSTMENTS_XML pax1 WHERE pax1.po_header_id = plx.po_header_id AND pax1.po_line_id = plx.po_line_id AND pax1.parent_adjustment_id is null order by pax1.pricing_group_sequence) AS PRICE_MODIFIERS, CURSOR (SELECT pax2.* FROM PO_PRICE_ADJUSTMENTS_XML pax2 WHERE pax2.po_header_id = plx.from_header_id AND pax2.po_line_id = plx.from_line_id AND pax2.parent_adjustment_id is null order by pax2.pricing_group_sequence) AS ADD_PRICE_MODIFIERS, CURSOR (SELECT pha.segment1 ponum FROM po_headers_all pha WHERE pha.po_header_id = plx.from_header_id) AS ADD_PRICE_PONUM, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_LINES' AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name='PO_IN_GA_LINES' AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NO T NULL) OR (fad.entity_name='MTL_SYSTEM_ITEMS' AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) ) AND fad.datatype_id=5 AND fad.function_name='PO_PRINTPO' order by fad.seq_num) AS line_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_LINES' AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name='PO_IN_GA_LINES' AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NOT NULL) OR (fad.entity_name='MTL_SYSTEM_ITEMS' AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) ) AND fad.datatype_id=6 AND fad.function_name='PO_PRINTPO' order by fad.seq_num) AS line_file_attachments, CURSOR(SELECT pllx.*, CURSOR( SELECT pllx.line_location_id, fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE entity_name = 'PO_SHIPMENTS' AND pk1_value = to_char(pllx.line_location_id) AND function_name = 'PO_PRINTPO' AND fad.media_id = fds.media_id AND fad.datatype_id=1 order by fad.seq_num) AS line_loc_short_text, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE fad.entity_name='PO_SHIPMENTS' AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=5 AND fad.function_name='PO_PRINTPO' order by fad.seq_num ) AS line_loc_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE fad.entity_name='PO_SHIPMENTS' AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=6 AND fad.function_name='PO_PRINTPO' order by fad.seq_num) AS line_loc_file_attachments, CURSOR(SELECT pdx.* FROM po_distribution_xml pdx WHERE pdx.po_header_id = phx.po_header_id and pdx.LINE_LOCATION_ID = pllx.LINE_LOCATION_ID) AS distributions FROM po_line_locations_xml pllx WHERE pllx.po_line_id = plx.po_line_id AND NVL(pllx.payment_type, 'NONE') NOT IN ('ADVANCE', 'DELIVERY') ) AS line_locations FROM po_lines_xml plx WHERE plx.po_header_id = phx.po_header_id ) AS lines FROM PO_HEADERS_XML phx WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()
g4pktka6kg4w9SELECT MENU_ID, ENTRY_SEQUENCE, FUNCTION_ID, SUB_MENU_ID, GRANT_FLAG FROM FND_MENU_ENTRIES WHERE MENU_ID = :B1
gmzaqj0bt8jy1SELECT 'Y' FROM PO_HEADERS_ARCHIVE WHERE PO_HEADER_ID = :B1 AND ROWNUM = 1
gnkqm72nrzg9jSELECT 'Exists' FROM PO_LINE_LOCATIONS POLL WHERE POLL.LINE_LOCATION_ID = :B3 AND POLL.PO_LINE_ID = :B2 AND POLL.PO_HEADER_ID = :B1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced2,1142.350.01
CCursor + sql area evicted00.000.00
CPU used by this session773,810859.204.44
CPU used when call started771,879857.064.42
CR blocks created70,83178.650.41
Cached Commit SCN referenced51,348,38257,014.86294.33
Commit SCN cached19,67621.850.11
DB time2,789,2323,097.0315.99
DBWR checkpoint buffers written102,675114.010.59
DBWR checkpoints00.000.00
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes3650.410.00
DBWR undo block writes47,35952.590.27
DFO trees parallelized00.000.00
Effective IO time1,508,7351,675.238.65
HSC Heap Segment Block Changes1,104,6781,226.586.33
Heap Segment Array Inserts2,6482.940.02
Heap Segment Array Updates2,7793.090.02
IMU CR rollbacks8,1259.020.05
IMU Flushes46,46251.590.27
IMU Redo allocation size102,722,352114,058.13588.81
IMU commits118,204131.250.68
IMU contention2,1492.390.01
IMU ktichg flush4,3774.860.03
IMU recursive-transaction flush530.060.00
IMU undo allocation size337,771,856375,046.201,936.12
LOB table id lookup cache misses00.000.00
Number of read IOs issued6,7767.520.04
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 client4,081,7324,532.1723.40
RowCR - row contention5,9846.640.03
RowCR attempts2,123,5852,357.9312.17
RowCR hits2,224,2132,469.6612.75
SMON posted for undo segment shrink00.000.00
SQL*Net roundtrips to/from client4,081,6844,532.1123.40
active txn count during cleanout123,806137.470.71
application wait time420.050.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts7,0777.860.04
branch node splits350.040.00
buffer is not pinned count65,284,94372,489.37374.22
buffer is pinned count392,562,222435,882.882,250.18
bytes received via SQL*Net from client357,978,153397,482.332,051.94
bytes sent via SQL*Net to client2,335,616,019,2712,593,359,662.7113,387,841.31
calls to get snapshot scn: kcmgss12,570,87513,958.1272.06
calls to kcmgas375,722417.182.15
calls to kcmgcs451,429501.252.59
cell physical IO interconnect bytes2,081,833,9842,311,571.8711,933.15
change write time1,8182.020.01
cleanout - number of ktugct calls114,327126.940.66
cleanouts and rollbacks - consistent read gets53,15959.030.30
cleanouts only - consistent read gets22,93825.470.13
cluster key scan block gets103,659115.100.59
cluster key scans68,89276.490.39
commit batch performed2710.300.00
commit batch requested2710.300.00
commit batch/immediate performed7460.830.00
commit batch/immediate requested7460.830.00
commit cleanout failures: block lost42,37247.050.24
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure1,5921.770.01
commit cleanout failures: cannot pin2,3082.560.01
commit cleanouts644,128715.213.69
commit cleanouts successfully completed597,856663.833.43
commit immediate performed4750.530.00
commit immediate requested4750.530.00
commit txn count during cleanout98,213109.050.56
concurrency wait time7580.840.00
consistent changes1,440,4741,599.448.26
consistent gets127,557,147141,633.54731.16
consistent gets - examination34,567,85738,382.54198.14
consistent gets direct18,48020.520.11
consistent gets from cache127,538,664141,613.02731.06
consistent gets from cache (fastpath)87,021,02096,624.10498.81
cursor authentications2790.310.00
data blocks consistent reads - undo records applied485,812539.422.78
db block changes6,636,0937,368.4138.04
db block gets7,455,6718,278.4342.74
db block gets direct390.040.00
db block gets from cache7,455,6328,278.3942.74
db block gets from cache (fastpath)1,457,3001,618.128.35
deferred (CURRENT) block cleanout applications135,975150.980.78
doubling up with imu segment00.000.00
enqueue conversions2,4402.710.01
enqueue releases609,970677.283.50
enqueue requests615,258683.153.53
enqueue timeouts5,2825.860.03
enqueue waits3600.400.00
exchange deadlocks550.060.00
execute count13,513,42015,004.6777.46
failed probes on index block reclamation00.000.00
file io service time00.000.00
file io wait time75,173,08983,468.71430.90
free buffer inspected710.080.00
free buffer requested302,979336.411.74
heap block compress27,05430.040.16
hot buffers moved to head of LRU00.000.00
immediate (CR) block cleanout applications76,09784.490.44
immediate (CURRENT) block cleanout applications71,26279.130.41
in call idle wait time6,470,6787,184.7437.09
index crx upgrade (positioned)7,5428.370.04
index fetch by key18,949,01521,040.11108.62
index scans kdiixs157,417,87363,754.14329.12
java call heap collected bytes00.000.00
java call heap collected count00.000.00
java call heap gc count00.000.00
java call heap live object count00.000.00
java call heap live object count max00.000.00
java call heap live size00.000.00
java call heap live size max00.000.00
java call heap object count00.000.00
java call heap object count max00.000.00
java call heap total size00.000.00
java call heap total size max00.000.00
java call heap used size00.000.00
java call heap used size max00.000.00
java session heap live object count1,100,1661,221.576.31
java session heap live object count max1,100,1661,221.576.31
java session heap live size129,720,320144,035.42743.56
java session heap live size max129,720,320144,035.42743.56
java session heap object count1,100,1661,221.576.31
java session heap object count max1,100,1661,221.576.31
java session heap used size129,720,320144,035.42743.56
java session heap used size max129,720,320144,035.42743.56
leaf node 90-10 splits5930.660.00
leaf node splits6,8187.570.04
lob reads20,09222.310.12
lob writes51,01456.640.29
lob writes unaligned51,01456.640.29
logical read bytes from cache1,105,872,830,4641,227,909,882.006,338,905.81
logons cumulative5,3095.890.03
max cf enq hold time250.030.00
messages received173,241192.360.99
messages sent173,241192.360.99
min active SCN optimization applied on CR257,304285.701.47
no buffer to keep pinned count560.060.00
no work - consistent read gets87,702,58697,380.88502.71
non-idle wait count4,840,7015,374.8927.75
non-idle wait time16,92318.790.10
opened cursors cumulative12,046,64213,376.0369.05
parse count (describe)10.000.00
parse count (failures)4010.450.00
parse count (hard)1,3741.530.01
parse count (total)773,681859.064.43
parse time cpu5,4926.100.03
parse time elapsed6,0016.660.03
physical read IO requests8,1299.030.05
physical read bytes194,502,656215,966.721,114.90
physical read total IO requests10,18411.310.06
physical read total bytes227,680,256252,805.591,305.07
physical read total multi block requests60.010.00
physical reads23,74326.360.14
physical reads cache1,9192.130.01
physical reads cache prefetch5660.630.00
physical reads direct21,82424.230.13
physical reads direct (lob)21,82424.230.13
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests22,66125.160.13
physical write bytes841,433,088934,288.264,823.13
physical write total IO requests179,845199.691.03
physical write total bytes1,854,153,7282,058,766.2710,628.08
physical write total multi block requests4,7175.240.03
physical writes102,714114.050.59
physical writes direct390.040.00
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache102,675114.010.59
physical writes non checkpoint69,54277.220.40
pinned buffers inspected00.000.00
pinned cursors current320.040.00
process last non-idle time8981.000.01
queries parallelized00.000.00
recursive calls23,333,17325,908.07133.75
recursive cpu usage279,252310.071.60
redo blocks checksummed by FG (exclusive)406,695451.582.33
redo blocks written1,935,7302,149.3411.10
redo entries2,859,7213,175.3016.39
redo ordering marks42,50347.190.24
redo size915,106,3401,016,091.625,245.42
redo size for direct writes1480.160.00
redo subscn max counts63,44070.440.36
redo synch long waits310.030.00
redo synch time2,0172.240.01
redo synch time (usec)23,395,20725,976.95134.10
redo synch writes106,998118.810.61
redo wastage43,765,92048,595.65250.87
redo write time4,1224.580.02
redo writes150,304166.890.86
rollback changes - undo records applied169,232187.910.97
rollbacks only - consistent read gets16,24318.040.09
root node splits30.000.00
rows fetched via callback10,262,45911,394.9658.82
session connect time00.000.00
session cursor cache hits5,127,6565,693.5129.39
session logical reads135,013,165149,912.35773.90
shared hash latch upgrades - no wait5,156,1545,725.1529.56
shared hash latch upgrades - wait5,9056.560.03
sorts (memory)1,035,7561,150.065.94
sorts (rows)4,176,0884,636.9323.94
sql area evicted00.000.00
sql area purged4070.450.00
switch current to new buffer73,69581.830.42
table fetch by rowid209,721,443232,864.961,202.13
table fetch continued row23,62726.230.14
table scan blocks gotten57,110,68763,413.06327.36
table scan rows gotten1,622,780,7371,801,860.449,301.84
table scans (long tables)00.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)221,799246.281.27
total cf enq hold time8670.960.00
total number of cf enq holders350.040.00
total number of times SMON posted310.030.00
transaction rollbacks7460.830.00
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size339,509,648376,975.761,946.08
user I/O wait time6260.700.00
user calls4,187,3674,649.4624.00
user commits152,961169.840.88
user rollbacks21,49723.870.12
workarea executions - optimal560,057621.863.21
write clones created in background00.000.00
write clones created in foreground150.020.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory1,787,050,216,0401,860,129,440,784
opened cursors current48,69349,123
logons current907910
session uga memory max292,661,265,896307,774,648,536
session pga memory3,165,146,0803,112,553,984
session pga memory max54,245,946,16054,040,288,016
session cursor cache count8,875,4719,245,891

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.000M946M173.121.05039150.4K0.02
DBWR0M0.000M803M25.15.8916130 
Direct Reads170M7.50.1887600M0.000M0 
Others32M2.28.03553120M1.46.02220724900.42
Buffer Cache Reads14M1.50.0155440M0.000M13500.03
TOTAL:216M11.28.2398361.7G199.741.96421154.2K0.03

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Data File186M9.07.206525804M25.16.8927240.070.17
Log File0M0.000M946M173.121.05039  
Control File31M2.21.03442020M1.46.0222070.12 
TOTAL:217M11.28.2409461.7G199.741.965320.080.17

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.000M946M173.121.050390 
LGWR (Log File) 0M0.000M946M173.121.050390 
DBWR 0M0.000M803M25.15.8916130 
DBWR (Data File) 0M0.000M803M25.15.8916130 
Direct Reads 170M7.50.1887600M0.000M0 
Direct Reads (Data File) 170M7.50.1887600M0.000M0 
Others 32M2.28.03553120M1.46.02220720510.11
Others (Control File) 31M2.21.03442020M1.46.02220719910.12
Others (Data File) 1M0.07.0011100M0.000M600.00
Buffer Cache Reads 14M1.50.0155440M0.000M13480.03
Buffer Cache Reads (Data File) 14M1.50.0155440M0.000M13480.03
TOTAL: 216M11.27.2398361.7G199.731.9642133990.08

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 6,80480.003.225,26166470.03
APPS_TS_TX_IDX 26900.521.0011,711139740.02
APPS_UNDOTS1 000.000.003,57744920.04
SYSAUX 1,00510.321.56500100.00
APPS_TS_QUEUES 800.001.00460120.00
APPS_TS_MEDIA 100.001.00443030.00
SYSTEM 5400.371.00221010.00
APPS_TS_ARCHIVE 100.001.00255090.00
APPS_TS_INTERFACE 000.000.00127060.00
APPS_TS_SUMMARY 000.000.0063000.00
APPS_TS_SEED 600.001.0042010.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 100.001.00255090.00
APPS_TS_INTERFACE/ebizdata/data/apps_ts_interface_01.dbf 00  127060.00
APPS_TS_MEDIA/ebizdata/data/media_01.dbf 100.001.00443030.00
APPS_TS_QUEUES/ebizdata/data/queues_01.dbf 800.001.00460120.00
APPS_TS_SEED/ebizdata/data/reference_01.dbf 400.001.0028010.00
APPS_TS_SEED/ebizdata/data/reference_02.dbf 200.001.0014000.00
APPS_TS_SUMMARY/ebizdata/data/summary_01.dbf 00  63000.00
APPS_TS_TX_DATA/ebizdata/data/tx_data_01.dbf 14600.001.001,3532840.00
APPS_TS_TX_DATA/ebizdata/data/tx_data_02.dbf 00  1300890.00
APPS_TS_TX_DATA/ebizdata/data/tx_data_03.dbf 6,65870.003.272,15924300.05
APPS_TS_TX_DATA/ebizdata/data/tx_data_04.dbf 00  1,6192440.00
APPS_TS_TX_IDX/ebizdata/data/tx_idx_01.dbf 4500.441.002,63731560.06
APPS_TS_TX_IDX/ebizdata/data/tx_idx_02.dbf 6100.491.003,24541140.00
APPS_TS_TX_IDX/ebizdata/data/tx_idx_03.dbf 8000.381.002,51832650.00
APPS_TS_TX_IDX/ebizdata/data/tx_idx_04.dbf 8300.721.003,31144390.02
APPS_UNDOTS1/ebizdata/data/undo_01.dbf 00  3,57744920.04
SYSAUX/ebizdata/data/sysaux_01.dbf 1,00510.321.56500100.00
SYSTEM/ebizdata/data/sys_01.dbf 5400.371.00221010.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D12,342,697100133,953,5981,916102,675002,136

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0000102,6700

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
B0913425164822437331121545810483733112   
E0882899564305438567621545810483856762   

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.0034,5950

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)
B16,38413,0954,022.8970.741.76100.000.001,048,576
E16,38413,0834,002.200.000.000.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
2K4K549,300549,30000
64K128K1,0281,02800
128K256K1,1831,18300
256K512K121200
512K1024K7,9877,98700
1M2M616100
2M4M2200
64M128M41741700

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
2,0480.13663,122.91397,011.9563.0013,713,652,419
4,0960.25663,122.911,946.46100.0002,329,737,976
8,1920.50663,122.910.00100.0002,322,919,544
12,2880.75663,122.910.00100.0002,322,919,544
16,3841.00663,122.910.00100.0002,322,919,544
19,6611.20663,122.910.00100.0002,322,919,544
22,9381.40663,122.910.00100.0002,322,919,544
26,2141.60663,122.910.00100.0002,322,919,544
29,4911.80663,122.910.00100.0002,322,919,544
32,7682.00663,122.910.00100.0002,322,919,544
49,1523.00663,122.910.00100.0002,322,919,544
65,5364.00663,122.910.00100.0002,322,919,544
98,3046.00663,122.910.00100.0002,322,919,544
131,0728.00663,122.910.00100.0002,322,919,544

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.2361029,8661,054,7511.001,6731.00167,611
5,6320.3461029,8661,054,7511.001,6731.00167,611
7,4240.4561029,8661,054,7511.001,6731.00167,611
9,2160.5661029,8661,054,7511.001,6731.00167,611
11,0080.6761029,8661,054,7511.001,6731.00167,611
12,8000.7861029,8661,054,7511.001,6731.00167,611
13,8240.8461029,8661,054,7511.001,6731.00167,611
14,0800.8661029,8661,054,7511.001,6731.00167,611
14,3360.8861029,8661,054,7511.001,6731.00167,611
14,5920.8961029,8661,054,7511.001,6731.00167,611
14,8480.9161029,8661,054,7511.001,6731.00167,611
15,1040.9261029,8661,054,7511.001,6731.00167,611
15,3600.9461029,8661,054,7511.001,6731.00167,611
15,6160.9561029,8661,054,7511.001,6731.00167,611
15,8720.9761029,8661,054,7511.001,6731.00167,611
16,1280.9861029,8661,054,7511.001,6731.00167,611
16,3841.0061029,8661,054,7511.001,6731.00167,611
16,6401.0261029,8661,054,7511.001,6731.00167,611
16,8961.0361029,8661,054,7511.001,6731.00167,611
17,1521.0561029,8661,054,7511.001,6731.00167,611
17,4081.0661029,8661,054,7511.001,6731.00167,611
17,6641.0861029,8661,054,7511.001,6731.00167,611
17,9201.0961029,8661,054,7511.001,6731.00167,611
18,1761.1161029,8661,054,7511.001,6731.00167,611
18,4321.1361029,8661,054,7511.001,6731.00167,611
18,6881.1461029,8661,054,7511.001,6731.00167,611
19,9681.2261029,8661,054,7511.001,6731.00167,611
21,7601.3361029,8661,054,7511.001,6731.00167,611
23,5521.4461029,8661,054,7511.001,6731.00167,611
25,3441.5561029,8661,054,7511.001,6731.00167,611
27,1361.6661029,8661,054,7511.001,6731.00167,611
28,9281.7761029,8661,054,7511.001,6731.00167,611
30,7201.8861029,8661,054,7511.001,6731.00167,611
32,5121.9861029,8661,054,7511.001,6731.00167,611
34,3042.0961029,8661,054,7511.001,6731.00167,611

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
32,7680.25148,263 
40,9600.31148,263 
49,1520.38148,263 
57,3440.44148,263 
65,5360.50148,269 
73,7280.56148,269 
81,9200.63148,269 
90,1120.69148,269 
98,3040.75148,269 
106,4960.81148,269 
114,6880.88148,270 
122,8800.94148,270 
131,0721.00148,263 
139,2641.06148,270 
147,4561.13148,270 
155,6481.19148,270 
163,8401.25148,270 
172,0321.31148,270 
180,2241.38148,270 
188,4161.44148,286 
196,6081.50148,286 
204,8001.56148,286 
212,9921.63148,286 
221,1841.69148,286 
229,3761.75148,288 
237,5681.81148,288 
245,7601.88148,289 
253,9521.94148,296 
262,1442.00148,297 

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
2,0481.0016436821.001,6731.0020,202
2,3041.1316436821.001,6731.0020,202
2,5601.2516436821.001,6731.0020,202
2,8161.3816436821.001,6731.0020,202
3,0721.5016436821.001,6731.0020,202
3,3281.6316436821.001,6731.0020,202
3,5841.7516436821.001,6731.0020,202
3,8401.8816436821.001,6731.0020,202
4,0962.0016436821.001,6731.0020,202
4,3522.1316436821.001,6731.0020,202

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block1,62900
undo block40200
undo header9000
1st level bmb900
segment header500

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) 5,1753214,85431600.39
TX-Transaction (index contention) 21321304200.14
DV-Diana Versioning 3,0383,0380101.00
SQ-Sequence Cache 2262260100.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
263.09212,2411,90756967/970.40/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
18-Sep 12:4531,460105,2171,907529670/00/0/0/0/0/0
18-Sep 12:3531,632107,0241,803569700/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 latch3,9780.030.0000 
AQ deq log cmt cbk chunk latch1,4400.070.0000 
AQ deq log statistics latch80.00 00 
AQ dequeue txn counter latch5,9466.680.0000 
AQ ht cmt cbk chunk latch1,4640.070.0000 
ASM db client latch6010.00 00 
ASM map operation hash table10.00 00 
ASM network state latch180.00 00 
AWR Alerted Metric Element list19,3780.00 00 
Change Notification Hash table latch3010.00 00 
Consistent RBA150,3640.00 00 
DML lock allocation570,1090.020.0000 
Event Group Locks5,3540.00 00 
FOB s.o list latch4420.00 00 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch1,115,3980.050.810208,8340.01
JOX SGA heap latch43,4620.000.0000 
JS Sh mem access30.00 00 
JS queue access latch10.00 00 
JS queue state obj latch5,4300.00 00 
JS slv state obj latch610.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch3010.00 00 
KTF sga latch60.00 03050.00
KWQMN job cache list latch2,1770.00 00 
KWQP Prop Status1140.00 00 
KWQS pqsubs latch1,7460.00 00 
KWQS pqueue ctx latch2,0910.051.0000 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0180.00
Memory Management Latch10.00 03010.00
Memory Queue60.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch100.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process3730.00 00 
OS process allocation2,0440.050.0000 
OS process: request allocation820.00 00 
PL/SQL warning settings463,9550.010.0000 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch20,0320.040.5000 
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch10.00 03000.00
SQL memory manager workarea list latch223,4040.000.0000 
Shared B-Tree5,4900.050.0000 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch25,6590.110.0000 
active service list30,0400.670.6307200.00
address list5,2520.110.6700 
begin backup scn array20.00 00 
bq:time manger info latch320.00 00 
buffer pool10.00 00 
bufq statistics50.00 00 
business card10.00 00 
cache buffer handles350,9510.010.0000 
cache buffers chains248,933,8562.050.000268,4350.03
cache buffers lru chain434,6530.000.000482,0230.02
cache table scan latch1070.00 01070.00
call allocation83,1530.360.0500 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch880.00 00 
channel operations parent latch5,1720.00 00 
checkpoint queue latch1,192,6520.000.00097,3320.00
client/application info150,0670.00 00 
compile environment latch5,3110.00 00 
corrupted undo seg latch509,6460.010.0000 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch180.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch180.00 00 
dml lock allocation180.00 00 
done queue latch10.00 00 
dummy allocation10,6230.430.0000 
enqueue freelist latch10.00 0319,6030.00
enqueue hash chains1,228,3190.120.0000 
enqueues2120.00 00 
fifth spare latch10.00 00 
file cache latch6780.00 00 
flashback copy10.00 00 
fourth Audit Vault latch10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA5,2490.00 00 
global ctx hash table latch144,0320.000.0000 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch5320.00 0112,9400.00
hash table modification latch6780.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch30.00 00 
interrupt manipulation21,9380.150.0000 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch180.00 0175.88
job_queue_processes free list latch340.00 00 
job_queue_processes parameter latch2130.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch37,2031.490.0100 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock250.00 00 
ksuosstats global area940.00 00 
ksv allocation latch640.00 00 
ksv class latch450.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch821.220.0000 
ktm global data1410.00 00 
kwqbsn:qsga5530.360.0000 
lgwr LWN SCN150,6090.010.0000 
list of block allocation24,4240.120.0000 
loader state object freelist63,2520.120.0000 
lob segment dispenser latch10.00 00 
lob segment hash table latch50.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation20.00 00 
logminer work area10.00 00 
longop free list parent1710.00 01700.00
mapped buffers lru chain10.00 00 
message pool operations parent latch40.00 00 
messages521,1360.030.0000 
mostly latch-free SCN152,0550.290.0000 
msg queue latch10.00 00 
multiblock read objects2880.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch180.00 00 
object queue header heap301,1350.000.00094,5920.00
object queue header operation29,142,0960.200.0000 
object stats modification68,0330.010.0000 
parallel query alloc buffer6010.00 00 
parallel query stats10.00 00 
parameter list5,8440.030.0000 
parameter table management736,3310.080.2200 
peshm10.00 00 
pesom_free_list267,3850.000.0000 
pesom_hash_node270,2090.020.0000 
pesom_heap_alloc1,4400.070.0000 
post/wait queue141,0800.140.00092,6380.21
process allocation1240.00 0420.00
process group creation820.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch1,1617.150.0000 
query server freelists10.00 00 
queued dump request30.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation1,319,2800.040.0002,858,9930.20
redo copy10.00 02,860,5500.06
redo writing482,8350.010.0000 
resmgr group change latch9,7550.00 00 
resmgr:active threads10,6220.00 00 
resmgr:actses change group5,2790.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list10,6240.970.0000 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config10.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects36,779,0830.660.0000 
rules engine aggregate statistics1,1120.00 00 
rules engine rule set statistics3,7830.00 00 
rules engine rule statistics1,4590.00 00 
second Audit Vault latch10.00 00 
second spare latch10.00 00 
sequence cache301,3270.030.0000 
session allocation383,5330.000.000372,9310.00
session idle bit8,741,7580.000.0000 
session queue latch10.00 00 
session state list latch31,5590.500.5200 
session switching590.00 00 
session timer3030.00 00 
shared pool8,549,0200.420.0510 
shared pool sim alloc660.00 00 
shared pool simulator2,7520.00 00 
sim partition latch10.00 00 
simulator hash latch10.00 00 
simulator lru latch10.00 00 
sort extent pool264,5340.300.0000 
space background state object latch100.00 00 
space background task latch4,97225.120.0006340.00
state object free list20.00 00 
statistics aggregation3360.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation8420.480.0000 
temporary table state object allocation4,6110.540.0000 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch2390.00 00 
transaction allocation68,2750.000.0000 
undo global data1,125,2390.010.000510.00
virtual circuit buffers41,381,1810.020.0400 
virtual circuit holder8,188,4690.000.0000 
virtual circuit queues8,341,9230.080.0008,172,6980.49
virtual circuits10,5060.650.0000 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains248,933,8565,101,1461,2185,097,240
row cache objects36,779,083242,9465242,941
object queue header operation29,142,09658,07528357,792
shared pool8,549,02035,7071,77933,944
virtual circuit buffers41,381,1816,6122466,370
space background task latch4,9721,24941,245
parameter table management736,331604130475
kokc descriptor allocation latch37,2035534549
In memory undo latch1,115,398528427108
call allocation83,15330316288
active service list30,04020012675
session state list latch31,5591578278
Real-time plan statistics latch20,032844
address list5,252642
KWQS pqueue ctx latch2,091110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchktiFlush: child037071
In memory undo latchkticmt: child05924
In memory undo latchktiFlushMe083
In memory undo latchktichg: child05310
KWQS pqueue ctx latchkwqspqcbkf: updatepqs011
Real-time plan statistics latchkeswxAddNewPlanEntry044
active service listkswslogon: session logout0160159
address listkmcladd044
cache buffers chainskcbchg1: mod cr pin0580263
cache buffers chainskcbgtcr: fast path036148
cache buffers chainskcbgtcr: fast path (cr pin)0325122
cache buffers chainskcbgcur_20276185
cache buffers chainskcbgtcr_20123199
cache buffers chainskcbget: fast exchange0639
cache buffers chainskcbgtcr: kslbegin excl05093
cache buffers chainskcbget: pin buffer0171
cache buffers chainskcbzwb0614
cache buffers chainskcbgcur_4051
cache buffers chainskcbgkcbcr0316
cache buffers chainskcbrls: fast release0336
cache buffers chainskcb_is_private0270
cache buffers chainskcbrls_202344
cache buffers chainskcbgcur: fast path (shr)013
cache buffers chainskcbnlc0111
call allocationksuxds01614
kokc descriptor allocation latchkokcdlt: regular free042
object queue header operationkcbo_ivbo0609607
object queue header operationkcbo_unlink_q013
parameter table managementkspcpy01090
parameter table managementksp_param_table_free0531
parameter table managementkspptval02163
row cache objectskqrpre: find obj025
row cache objectskqreqd010
row cache objectskqreqd: reget010
row cache objectskqrso010
session state list latchkpseqd0790
session state list latchkpscad031
shared poolkghalo01,6201,124
shared poolkghfre0131531
shared poolkghupr1026109
shared poolkgh: kghalloc_java_page0111
shared poolkghalp014
space background task latchktsj_grab_task044
virtual circuitskmcmbf02460

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpin1 42,4590
Library Cachekglpndl1 952,2920
Library Cachekglpnal1 902,1400
Library Cachekglhdgn2 1061,9760
Library Cachekgllkc1 571,2990
Library Cachekgllkdl1 858960
Library Cachekglhdgn1 625300
Library Cachekglget2 22360
Library Cachekglget1 12340
Cursor Pinkksfbc [KKSCHLFSP2]910
Library Cachekglobpn1 71270
Cursor Pinkksxsccmp [KKSCHLPIN5]110
Cursor Pinkksfbc [KKSCHLPIN1]50
Library Cachekglhdgh1 6420
Library CachekglReleaseHandleReference 12510
Library Cachekgldtin1 4210
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]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 TABLE43,460,76832.19
APPLSYSAPPS_TS_SEEDFND_MENU_ENTRIES_U1 INDEX8,243,2006.11
APPLSYSAPPS_TS_SEEDFND_MENU_ENTRIES TABLE7,591,3605.62
POAPPS_TS_TX_DATAPO_REQUISITION_LINES_ALL TABLE4,607,1043.41
INVAPPS_TS_TX_DATAMTL_RESERVATIONS TABLE4,599,5523.41

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
POAPPS_TS_TX_IDXPO_LINE_LOCATIONS_U1 INDEX80.03
POAPPS_TS_TX_IDXPO_LINES_U1 INDEX70.03
APAPPS_TS_TX_IDXAP_INVOICE_DISTRIBUTIONS_N27 INDEX60.03
APAPPS_TS_TX_IDXAP_INVOICE_DISTRIBUTIONS_N2 INDEX40.02
APAPPS_TS_TX_IDXAP_INVOICE_DISTRIBUTIONS_N23 INDEX40.02

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
POAPPS_TS_TX_IDXPO_LINE_LOCATIONS_U1 INDEX80.10
POAPPS_TS_TX_IDXPO_LINES_U1 INDEX70.09
APAPPS_TS_TX_IDXAP_INVOICE_DISTRIBUTIONS_N27 INDEX60.07
APAPPS_TS_TX_IDXAP_INVOICE_DISTRIBUTIONS_N2 INDEX40.05
APAPPS_TS_TX_IDXAP_INVOICE_DISTRIBUTIONS_N23 INDEX40.05

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
POAPPS_TS_TX_IDXPO_LINE_LOCATIONS_U1 INDEX80.10
POAPPS_TS_TX_IDXPO_LINES_U1 INDEX70.09
APAPPS_TS_TX_IDXAP_INVOICE_DISTRIBUTIONS_N27 INDEX60.07
APAPPS_TS_TX_IDXAP_INVOICE_DISTRIBUTIONS_N2 INDEX40.05
APAPPS_TS_TX_IDXAP_INVOICE_DISTRIBUTIONS_N23 INDEX40.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 INDEX8,6738.44
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE6,4876.32
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX3,2473.16
ICXAPPS_TS_TX_IDXICX_SESSION_ATTRIBUTES_U1 INDEX1,7781.73
ICXAPPS_TS_TX_IDXICX_TRANSACTIONS_U1 INDEX1,4351.40

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX1,7827.86
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX1,2145.36
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE1,0644.70
ICXAPPS_TS_TX_IDXICX_SESSION_ATTRIBUTES_U1 INDEX7863.47
APPLSYSAPPS_TS_MEDIAFND_LOBS TABLE4331.91

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE295,31215.11
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX263,80813.50
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX227,90411.66
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_PKWF_ITEM57INDEX PARTITION105,0565.38
POAPPS_TS_TX_DATAPO_REQUISITION_LINES_ALL TABLE102,9445.27

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 TABLE4,85491.72
APPLSYSAPPS_TS_TX_DATAFND_CONC_PROG_ONSITE_INFO TABLE1603.02
APPLSYSAPPS_TS_TX_DATAALR_ALERTS TABLE1562.95
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX470.89
APPLSYSAPPS_TS_TX_IDXWF_NOTIFICATIONS_ATTR_PK INDEX120.23

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
POAPPS_TS_TX_IDXPO_REQUISITION_LINES_N17 INDEX1100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
APPLSYSAPPS_TS_TX_DATAFND_CONCURRENT_REQUESTS TABLE37225.05
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX1157.74
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX1157.74
APPLSYSAPPS_TS_TX_DATAFND_CONC_PROG_ONSITE_INFO TABLE936.26
APPLSYSAPPS_TS_TX_IDXALR_ACTION_SET_CHECKS_N3 INDEX614.11

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control200.000 32
dc_global_oids217,0740.000 0145
dc_histogram_data2659.430 0434
dc_histogram_defs19,70820.820 2,40016,468
dc_object_grants2270.000 0409
dc_objects371,1790.090 1410,545
dc_profiles5,2660.000 01
dc_rollback_segments1,6450.000 0127
dc_segments20,7220.070 655,218
dc_sequences2250.000 22554
dc_table_scns18,7400.000 06
dc_tablespace_quotas160.000 04
dc_tablespaces456,2740.000 057
dc_users16,181,3440.000 0184
global database name5,9380.000 01
outstanding_alerts1080.000 054


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS10,4980.000 00
APP CONTEXT9,550-0.01429,972-0.0000
BODY177,5850.004,295,931-0.0163
CLUSTER460.00460.0000
CONTEXT POLICY7,9800.002,7000.0000
DBLINK10,5020.000 00
DIRECTORY9,0680.009,0680.0000
EDITION5,3310.0010,5970.0000
INDEX1,0729.3395320.8810
JAVA DATA3020.00900.0000
OBJECT ID1100.000 00
PIPE2690.00267-0.7500
QUEUE1,9120.007,464-0.0700
RULESET590.001,1120.0000
SCHEMA5,3140.000 00
SQL AREA249,0960.3914,484,963-0.08319407
SQL AREA BUILD1,34374.680 00
SQL AREA STATS1,34876.341,34876.3400
SUBSCRIPTION340.00340.0000
TABLE/PROCEDURE200,6790.014,761,5830.002453
TRIGGER2,6620.0072,3530.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 cache100,096.00100,096.00100,096.00112,896.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target16,384.0016,384.0016,384.0016,384.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target131,072.00131,072.00131,072.00131,072.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool2,048.002,048.00256.002,048.000GRO/IMM
large pool11,264.0011,264.000.0011,264.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
BOther2,468.69 1.100.9425252,2422,242
Freeable1,233.880.000.810.509 1,5251,525
PL/SQL155.9123.150.080.15132,0422,042
SQL106.70106.520.071.9771891,62317
JAVA97.1396.980.637.83971051541
EOther2,478.02 1.100.9125252,2442,244
Freeable1,268.250.000.810.509 1,5751,575
PL/SQL160.1822.530.080.16132,0442,044
JAVA97.1396.970.617.73971051581
SQL0.160.050.000.000891,67017

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers104,958,263,296 
Fixed Size2,176,432 
Redo Buffers230,449,152 
Variable Size31,675,386,448 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory1,885.591,881.26-0.23
javaioc_make_sub2141.38145.713.07
largefree memory3,943.834,147.705.17
largesession heap7,312.367,108.49-2.79
sharedASH buffers254.00254.000.00
sharedFileOpenBlock192.00192.000.00
sharedKGLH0235.64249.475.87
sharedKKSSP215.92216.520.28
sharedSQLA345.94377.969.26
shareddb_block_hash_buckets712.00712.000.00
sharedfree memory12,839.8512,790.48-0.38
sharedprivate strands177.67177.670.00
streamsfree memory510.07510.080.00
 buffer_cache100,096.00100,096.000.00
 fixed_sga2.082.080.00
 log_buffer219.77219.770.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 Slaves0918 06:36:301.060.000.00
QMON Coordinator0918 06:36:090.030.000.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

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

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

Subscriber/QueueEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
WFBESCL_21130(17392)/APPLSYS.WF_CONTROL 00.0000.0000.00 
WFBESCL_21131(17394)/APPLSYS.WF_CONTROL 00.0000.0000.00 
WFBESCL_21132(17393)/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 7660.0000.060.060.850.000.000.000
APPLSYS.WF_DEFERRED_QUEUE_M_R 3470.003470.020.070.391.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.AQ$_FND_CP_GSM_OPP_AQTBL_E(423856) 00  0.000.00  
APPLSYS.FND_CP_GSM_IPC_AQ(425717) 00  0.000.00  
APPLSYS.FND_CP_GSM_OPP_AQ(423855) 140100.000.000.010.000.000.00
APPLSYS.WF_CONTROL(423650) 00  0.000.00  
APPLSYS.WF_DEFERRED(423674) 76600.000.000.730.240.0022.08
APPLSYS.WF_DEFERRED_QUEUE_M(423736) 34700.00100.000.220.000.0036.62
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.AQ$_FND_CP_GSM_OPP_AQTBL_E(423856) 0.000.00  
APPLSYS.FND_CP_GSM_IPC_AQ(425717) 0.000.00  
APPLSYS.FND_CP_GSM_OPP_AQ(423855) 0.020.000.00 
APPLSYS.WF_CONTROL(423650) 0.000.00  
APPLSYS.WF_DEFERRED(423674) 0.850.000.00 
APPLSYS.WF_DEFERRED_QUEUE_M(423736) 0.390.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_1596178(210)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_CARTRIDGE_1596179(212)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_CARTRIDGE_1596180(214)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_CARTRIDGE_1596181(216)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_CARTRIDGE_1596182(218)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_SERVICE_1596173(201)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596174(203)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596175(205)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596176(207)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596177(209)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596178(211)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596179(213)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596180(215)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596181(217)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596182(219)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596183(221)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596184(223)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1596185(225)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
WFBESCL_21130(17392)/APPLSYS.WF_CONTROL 0000.000.000.00
WFBESCL_21131(17394)/APPLSYS.WF_CONTROL 0000.000.000.00
WFBESCL_21132(17393)/APPLSYS.WF_CONTROL 0000.000.000.00
WF_DEFERRED(1)/APPLSYS.WF_DEFERRED 76672000.850.800.00
APPS(1)/APPLSYS.WF_DEFERRED_QUEUE_M 347000.390.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
760462,000452000

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)
4,5384,6169,1541,528.084,086,5674,157,0978,244,2081,376,211

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
1,801,0801.9298.080.000.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

Total QueuedTotal Queue Wait Time (s)Avg Queue Wait Time (ms)
4,086,5671190

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0294.139010.3199.6965,52020
D0224.139010.2799.7350,66820
D0094.079010.2799.7353,66420
D0564.279010.2499.7651,11920
D0236.009010.2399.7748,06220
D0213.679010.2399.7742,84520
D0334.479010.2399.7744,76710
D0305.609010.2299.7846,05010
D0934.609010.2299.7844,51110
D0834.079010.2299.7846,31120
D0873.009010.2199.7940,18910
D0183.479010.2199.7942,74820
D0994.009010.2099.8037,72210
D0005.009010.2099.8042,16210
D0394.009010.1999.8144,35520
D0444.409010.1999.8134,94310
D0284.339010.1899.8233,02510
D0634.139010.1899.8231,23810
D0084.479010.1799.8339,79810
D0584.339010.1799.8335,08410
D0192.739010.1799.8333,33910
D0274.479010.1799.8333,24010
D0202.339010.1699.8428,60310
D0734.139010.1699.8430,09010
D0474.009010.1699.8434,16910
D0593.539010.1599.8525,65910
D0124.009010.1599.8528,35310
D0434.009010.1599.8531,06210
D0644.809010.1599.8531,23410
D0535.009010.1599.8529,41110
D0463.009010.1499.8631,12010
D0964.809010.1499.8631,74010
D0313.539010.1499.8633,18110
D0754.339010.1399.8726,99910
D0654.279010.1399.8726,93110
D0843.339010.1399.8728,28310
D0746.009010.1399.8725,21210
D0603.339010.1399.8722,81710
D0382.539010.1299.8825,78510
D0853.209010.1299.8823,69210
D0104.539010.1199.8923,62710
D0715.009010.1199.8922,15810
D0673.479010.1199.8919,57710
D0071.809010.1199.8917,66600
D0923.679010.1199.8918,91110
D0894.079010.1099.9019,12110
D0265.009010.1099.9018,41110
D0865.139010.1099.9020,49810
D0544.539010.0999.9118,66610
D0914.409010.0999.9117,42010
D0113.009010.0999.9119,27710
D0135.009010.0999.9118,87510
D0354.279010.0999.9118,25310
D0904.009010.0999.9115,62210
D0374.009010.0999.9118,56210
D0775.009010.0999.9116,84200
D0884.279010.0999.9117,60710
D0763.879010.0999.9116,94010
D0682.009010.0899.9219,27410
D0322.539010.0899.9216,10110
D0482.339010.0899.9214,34800
D0363.609010.0799.9313,06700
D0244.009010.0799.9315,14300
D0813.539010.0799.9318,80010
D0053.479010.0799.9319,92010
D0944.139010.0799.9312,37400
D0973.679010.0799.9311,17410
D0153.009010.0699.948,90200
D0013.079010.0699.949,67800
D0033.479010.0699.9410,28200
D0792.739010.0699.9411,01600
D0423.939010.0599.956,85200
D0693.009010.0599.959,82500
D0802.279010.0599.958,22800
D0063.009010.0599.9513,83400
D0343.609010.0599.9510,45400
D0514.009010.0599.959,19400
D0725.009010.0599.958,95400
D0402.409010.0499.9611,64800
D0702.339010.0499.969,79200
D0492.609010.0499.9611,34400
D0553.079010.0499.968,63900
D0505.009010.0499.966,01100
D0613.009010.0499.966,74100
D0254.079010.0399.975,66000
D0144.009010.0399.975,68100
D0573.409010.0299.985,40600
D0624.009010.0299.984,89800
D0824.079010.0299.983,43100
D0413.679010.0299.983,80700
D0174.609010.0299.985,09400
D0663.339010.0299.986,58500
D0023.079010.0299.982,65000
D0453.009010.0299.982,62300
D0982.079010.0299.984,14000
D0785.009010.0199.993,19000
D0955.009010.0199.993,36300
D0162.009010.0199.991,34800
D0524.079010.0199.991,49800
D0043.009010.0199.992,13400
Sum381.53   2,156,83771 
Avg3.82 0.1199.8921,56810
Std0.89 0.070.0714,41500

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_sharingEXACT  
db_block_checkingFALSE  
db_block_checksumTRUE  
db_block_size8192  
db_cache_adviceOFF  
db_files512  
db_nameVIS  
diagnostic_dest/export/home/oracle/app/oracle/product/11.2.0/dbhome_1/admin/VIS_dbzone1  
dispatchers(PROTOCOL=TCP)(SERVICE=VIS)(DISPATCHERS=200)  
dml_locks10000  
filesystemio_optionssetall  
ifile/export/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/VIS_dbzone1_ifile.ora  
job_queue_processes2  
local_listenerVIS_LOCAL  
log_archive_dest_1LOCATION=/ebizdata/data/archive  
log_archive_format%t_%s_%r.dbf  
log_buffer104857600  
log_checkpoint_timeout1800  
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_target17179869184  
plsql_code_typeINTERPRETED  
plsql_optimize_level2  
processes8000  
recyclebinOFF  
sec_case_sensitive_logonFALSE  
session_cached_cursors1000  
sessions12080  
sga_target137438953472  
shared_pool_reserved_size4294967296  
shared_pool_size17179869184  
shared_servers2000  
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_dbzone1, /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_dbzone1  
/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