ASH Report For CAPGENT/capgent1

DB NameDB IdInstanceInst numReleaseRACHost
CAPGENT4127787440capgent1110.2.0.4.0YESrac1.capgent.com

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
43,072M (100%)1,760M (57.3%)1,148M (37.4%)M (%)

Sample TimeData Source
Analysis Begin Time:18-Jan-11 13:09:07DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 18037
Analysis End Time:21-Jan-11 13:14:07DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 18107
+ V$ACTIVE_SESSION_HISTORY
Elapsed Time: 4,325.0 (mins) Missing 38.0 mins (1%) of activity
Sample Count: 70,450 
Average Active Sessions: 2.71 
Avg. Active Session per CPU: 0.68 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% ActivityAvg Active Sessions
library cache lock Concurrency 22.68 0.62
CPU + Wait for CPU CPU 20.33 0.55
enq: TX - row lock contention Application 14.52 0.39
db file sequential read User I/O 9.79 0.27
cursor: pin S wait on X Concurrency 7.68 0.21

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
control file sequential read System I/O 1.42 0.04

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
library cache lock 22.68 "5333883256","5397712384","501" 4.03 handle address lock address 100*mode+namespace
    "5074462640","5398560776","501" 2.72      
    "5074462640","5396485792","501" 2.00      
enq: TX - row lock contention 14.52 "1415053318","786458","140281" 8.20 name|mode usn<<16 | slot sequence
    "1415053318","917518","141219" 2.00      
    "1415053318","524292","135790" 1.63      
db file sequential read 10.07 "6","288037","1" 0.01 file# block# blocks
cursor: pin S wait on X 7.68 "2400683502","1065151889408","21477461193" 0.00 idn value where|sleeps
gc cr multi block request 5.80 "6","959394","1" 0.02 file# block# class#

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
capgent JDBC Thin Client 57.99 UNNAMED 57.99
  SQL Developer 23.57 UNNAMED 23.57
SYS$USERS sqlplus@rac1.capgent.com (TNS V1-V3) 8.06 UNNAMED 8.06
SYS$BACKGROUND UNNAMED 4.56 UNNAMED 4.56
SYS$USERS SQL*Plus 1.96 UNNAMED 1.96

Back to Load Profile
Back to Top

Top Client IDs

No data exists for this section of the report.

Back to Load Profile
Back to Top

Top SQL Command Types

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT 1,375 50.68 1.38
UPDATE 31 13.83 0.38
CREATE INDEX 10 9.29 0.25
CALL METHOD 3 3.88 0.11
DELETE 10 2.11 0.06

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL IDPlanhash% ActivityEvent% EventSQL Text
4fx1nsvwwbgm8 3177380161 12.74 gc buffer busy 3.68 select invtxn0_.IV_ID as IV1_3...
      gc cr multi block request 2.57
      db file sequential read 2.46
1z3dy7y7jg1gf   6.90 cursor: pin S wait on X 5.43 select * from ( select csthdr0...
    6.90 library cache lock 1.47 select * from ( select csthdr0...
dcnp1pu6hd5fs 3177380161 6.23 gc cr multi block request 1.97 select invtxn0_.IV_ID as IV1_3...
      db file sequential read 1.26
1kpq3fwmjk57a   4.89 CPU + Wait for CPU 4.89 ** SQL Text Not Available **
62f98228n4yjp 3024242220 4.41 enq: TX - row lock contention 4.41 update sts_log set st_iscurr=0...

Back to Top SQL
Back to Top

Top SQL using literals

Plan Hash% Activity# of Sampled SQL VersionsExample SQL 1Example SQL TEXT 1Example SQL 2Example SQL TEXT 2
3177380161 20.65 14547 0g9nbqjhmzy02 select invtxn0_.IV_ID as IV1_3... gx025t6sx0fbh select invtxn0_.IV_ID as IV1_3...

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0g9nbqjhmzy02 select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, invtxn0_.IV _STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as CS59_22_1_, csth dr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as CS103_22_1_, csthdr1_.A ID as AID22_1_, csthdr1_.CS_IND as CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as AR32_1_2_, accrtxn2_.AR _INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as AR76_1_2_, accrtxn2_.AR_NUM8 as AR7 7_1_2_, accrtxn2_.AR_NUM9 as AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where invtxn0_.CS_ID=csthdr1_.CS_ID(+) and invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :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)) and invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and invtxn0_.IV_CLOSED=0
1kpq3fwmjk57a** SQL Text Not Available **
1z3dy7y7jg1gfselect * from ( select csthdr0_.CS_ID as col_0_0_, csthdr0_.CS_NAME as col_1_0_, csthdr0_.CS_ALIAS as col_2_0_, sum(accrtxn2_.AR_OUTAMT) as col_3_0_ from CST_HDR csthdr0_, INV_TXN invtxns1_, ACCR_TXN accrtxn2_ where csthdr0_.CS_ID=invtxns1_.CS_ID(+) and invtxns1_.IV_ID=accrtxn2_.IV_ID(+) and invtxns1_.IV_DATE=accrtxn2_.IV_DATE(+) and (csthdr0_.EN_ID in (100)) and invtxns1_.IV_CLOSED=0 group by csthdr0_.CS_ID , csthdr0_.CS_NAME , csthdr0_.CS_ALIAS order by csthdr0_.CS_ID ASC ) where rownum <= :1
4fx1nsvwwbgm8 select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, invtxn0_.IV _STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as CS59_22_1_, csth dr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as CS103_22_1_, csthdr1_.A ID as AID22_1_, csthdr1_.CS_IND as CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as AR32_1_2_, accrtxn2_.AR _INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as AR76_1_2_, accrtxn2_.AR_NUM8 as AR7 7_1_2_, accrtxn2_.AR_NUM9 as AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where invtxn0_.CS_ID=csthdr1_.CS_ID(+) and invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :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)) and invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and invtxn0_.IV_CLOSED=0
62f98228n4yjpupdate sts_log set st_iscurr=0 where iv_id in(select doc_id from pyttxn_det where py_id ='bf0302272d8980a3012d9fa6dae3001d') and st_iscurr=1
dcnp1pu6hd5fs select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, invtxn0_.IV _STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as CS59_22_1_, csth dr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as CS103_22_1_, csthdr1_.A ID as AID22_1_, csthdr1_.CS_IND as CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as AR32_1_2_, accrtxn2_.AR _INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as AR76_1_2_, accrtxn2_.AR_NUM8 as AR7 7_1_2_, accrtxn2_.AR_NUM9 as AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where invtxn0_.CS_ID=csthdr1_.CS_ID(+) and invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :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) ) and invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and invtxn0_.IV_CLOSED=0
gx025t6sx0fbh select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, invtxn0_.IV _STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as CS59_22_1_, csth dr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as CS103_22_1_, csthdr1_.A ID as AID22_1_, csthdr1_.CS_IND as CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as AR32_1_2_, accrtxn2_.AR _INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as AR76_1_2_, accrtxn2_.AR_NUM8 as AR7 7_1_2_, accrtxn2_.AR_NUM9 as AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where invtxn0_.CS_ID=csthdr1_.CS_ID(+) and invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :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)) and invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and invtxn0_.IV_CLOSED=0

Back to Top SQL
Back to Top

Top PL/SQL Procedures

PLSQL Entry Subprogram% ActivityPLSQL Current Subprogram% Current
DNBI.MODIFIED_ACCOUNT_AGE_CALC 3.87 SQL 3.87
SYS.DBMS_STATS.GATHER_SCHEMA_STATS#2 3.33 UNKNOWN_PLSQL_ID <4354,103> 1.88
    SQL 1.42


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
285, 6148 4.89 CPU + Wait for CPU 4.89 NCO SQL Developer 3,446/26K [ 13%] 0
271, 4990 4.72 library cache lock 4.71 SYS sqlplus@rac1.c...m (TNS V1-V3) 3,320/26K [ 13%] 2
263, 1942 4.03 library cache lock 4.03 NCO SQL Developer 2,836/26K [ 11%] 1
273, 3967 2.98 db file sequential read 0.81 DNBI JDBC Thin Client 573/26K [ 2%] 26
281, 3507 2.97 CPU + Wait for CPU 2.97 CPOINT JDBC Thin Client 2,093/26K [ 8%] 1

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
285, 6148 4.03 library cache lock 4.03 NCO SQL Developer 3,446/26K [ 13%] 0
269, 5612 3.17 library cache lock 3.17 SYS sqlplus@rac1.c...m (TNS V1-V3) 1,707/26K [ 7%] 28
284, 196 1.63 enq: TX - row lock contention 1.63 DNBI JDBC Thin Client 1,177/26K [ 5%] 2
275, 1598 1.62 enq: TX - row lock contention 1.62 DNBI JDBC Thin Client 1,181/26K [ 5%] 1
281, 3507 1.43 library cache lock 1.43 CPOINT JDBC Thin Client 2,094/26K [ 8%] 1

Back to Top Sessions
Back to Top

Top Sessions running PQs

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Objects/Files/Latches

Back to Top

Top DB Objects

Object ID% ActivityEvent% EventObject Name (Type)Tablespace
56469 19.86 db file sequential read 4.99 DNBI.INV_TXN (TABLE) CAPGENT_DATA
    gc cr multi block request 4.98    
    gc buffer busy 4.66    
113262 9.24 enq: TX - row lock contention 9.22 NCO.STS_LOG (TABLE) USERS
56452 3.82 enq: TX - row lock contention 3.26 DNBI.CST_HDR (TABLE) CAPGENT_DATA
99805 3.33 enq: TX - row lock contention 2.03 DNBI.CST_AGEHDR (TABLE) CAPGENT_DATA

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
6 25.43 db file sequential read 7.92 +DATA/capgent/capgent_data.dbf CAPGENT_DATA
    gc cr multi block request 5.74    
    gc buffer busy 4.77    
7 1.49 db file sequential read 1.18 +DATA/capgent/capgent_index.dbf CAPGENT_INDEX

Back to Top Objects/Files/Latches
Back to Top

Top Latches

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Activity Over Time

Slot Time (Duration)Slot CountEventEvent Count% Event
13:09:07 (215.9 min) 805 CPU + Wait for CPU 588 0.83
    db file sequential read 135 0.19
    control file sequential read 9 0.01
16:45:00 (435.0 min) 3,240 CPU + Wait for CPU 820 1.16
    gc cr multi block request 809 1.15
    db file sequential read 594 0.84
00:00:00 (435.0 min) 1,449 CPU + Wait for CPU 322 0.46
    db file sequential read 216 0.31
    gc cr multi block request 212 0.30
07:15:00 (435.0 min) 2,105 db file sequential read 596 0.85
    CPU + Wait for CPU 453 0.64
    gc cr multi block request 275 0.39
14:30:00 (435.0 min) 2,478 enq: TX - row lock contention 526 0.75
    CPU + Wait for CPU 441 0.63
    gc cr multi block request 409 0.58
21:45:00 (435.0 min) 1,956 db file sequential read 582 0.83
    CPU + Wait for CPU 564 0.80
    gc cr multi block request 172 0.24
05:00:00 (435.0 min) 14,145 enq: TX - row lock contention 5,776 8.20
    CPU + Wait for CPU 2,944 4.18
    library cache lock 1,212 1.72
12:15:00 (435.0 min) 1,244 CPU + Wait for CPU 1,051 1.49
    db file sequential read 56 0.08
    db file scattered read 31 0.04
19:30:00 (435.0 min) 5,198 enq: TX - row lock contention 2,294 3.26
    CPU + Wait for CPU 1,668 2.37
    db file sequential read 521 0.74
02:45:00 (435.0 min) 26,523 library cache lock 8,902 12.64
    CPU + Wait for CPU 5,251 7.45
    db file sequential read 2,572 3.65
10:00:00 (194.1 min) 11,266 library cache lock 5,846 8.30
    cursor: pin S wait on X 3,338 4.74
    CPU + Wait for CPU 735 1.04


Back to Top

End of Report