- 论坛徽章:
- 0
|
sun和ibm为什么差这么多?
sSql = " select applicantid,ApplicantName,industryName,balance1,Badbalance1,Outerbalance1,deposit1,Recognizance1,"
+" balance2,Badbalance2,Outerbalance2,deposit2,Recognizance2,change,OrgName"
+" from"
+" ("
+" select t1.applicantid as applicantid,getCustomerName(t1.applicantid) as ApplicantName,"
+" getItemName('IndustryType',getIndustryType(t1.applicantid)) as industryName,"
+" balance1,Badbalance1,Outerbalance1,deposit1,Recognizance1,"
+" balance2,Badbalance2,Outerbalance2,deposit2,Recognizance2,"
+" (OuterBalance2-OuterBalance1) as change,"
+" getOrgName(getOrgIDByCustomerID(t1.ApplicantID)) as OrgName"
+" from"
+" ("
+" select applicantid,balance1,Badbalance1,OuterBalance1,deposit1,Recognizance1"
+" from"
+" ("
+" select applicantid,sum(balance*isEquals(LType,'INNER')) as balance1,"
+" sum(BadBalance*isEquals(LType,'INNER')) as Badbalance1,"
+" sum(balance*isEquals(LType,'OUTER')) as Outerbalance1"
+" from"
+" ("
+" select applicantid,bh.balance as balance,"
+" bh.overdueBalance+bh.dullBalance+bh.badBalance as BadBalance,"
+" Decode(substr(loanassetType,1,2),'1','INNER','01','INNER','03','OUTER','OUTER') as LType"
+" from business_putout bp,business_history bh"
+" where bp.applicantid is not null "
+ sCondition
+" and (substr(bp.loanAssetType,1,2)<>;'04' or bp.loanAssetType is null) "
+" and bp.loanaccount=bh.loanaccount"
+" and bh.inputdate='"+fromDate+"'"
+" )group by applicantid"
+" ) tl1," //期初的贷款
+" ("
+" select customerid,sum(a5ye) as deposit1,sum(a5ye*IsEquals(kmh,'251')) as Recognizance1"
+" from"
+" ("
+" select customerid,-1*a5ye as a5ye, substr(a5gskm,1,3) as kmh"
+" from deposit_account da,deposit_fullhistory df"
+" where da.sh=df.a5sh and da.account=df.a5zh and df.inputdate='"+fromDate+"'"
+" )"
+" group by customerid"
+" ) td1" //期初的存款
+" where Outerbalance1<>;0 and tl1.applicantid=td1.customerid(+)"
+" ) t1,"
+" ("
+" select applicantid,balance2,Badbalance2,Outerbalance2,deposit2,Recognizance2"
+" from"
+" ("
+" select applicantid,sum(balance*isEquals(LType,'INNER')) as balance2,"
+" sum(BadBalance*isEquals(LType,'INNER')) as Badbalance2,"
+" sum(balance*isEquals(LType,'OUTER')) as Outerbalance2"
+" from("
+" select applicantid,bh.balance as balance,"
+" bh.overdueBalance+bh.dullBalance+bh.badBalance as BadBalance,"
+" Decode(substr(loanassetType,1,2),'1','INNER','01','INNER','03','OUTER','OUTER') as LType"
+" from business_putout bp,business_history bh"
+" where bp.applicantid is not null "
+ sCondition
+" and (substr(bp.loanAssetType,1,2)<>;'04' or bp.loanAssetType is null) "
+" and bp.loanaccount=bh.loanaccount"
+" and bh.inputdate='"+toDate+"'"
+" )group by applicantid"
+" ) tl2," //期末的贷款
+" ("
+" select customerid,sum(a5ye) as deposit2,sum(a5ye*IsEquals(kmh,'251')) as Recognizance2"
+" from"
+" ("
+" select customerid,-1*a5ye as a5ye, substr(a5gskm,1,3) as kmh"
+" from deposit_account da,deposit_fullhistory df"
+" where da.sh=df.a5sh and da.account=df.a5zh and df.inputdate='"+toDate+"'"
+" )"
+" group by customerid"
+" ) td2" //期末的存款
+" where Outerbalance2<>;0 and tl2.applicantid=td2.customerid(+)"
+" ) t2"
+" where t1.applicantid=t2.applicantid"
+" ) "
+" where abs(change)>;="+sChange+" order by change desc"; |
|