No data exists for this section of the report.
| SQL Id | SQL 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 ** |
| 1z3dy7y7jg1gf | select * 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 |
| 62f98228n4yjp | update 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 |
No data exists for this section of the report.
No data exists for this section of the report.