既有留抵也有增值税欠税纳税人占增值税欠税纳税人的比例（负向）.docx

《既有留抵也有增值税欠税纳税人占增值税欠税纳税人的比例（负向）.docx》由会员分享，可在线阅读，更多相关《既有留抵也有增值税欠税纳税人占增值税欠税纳税人的比例（负向）.docx（2页珍藏版）》请在优知文库上搜索。

1、既有留抵也有增值税欠税纳税人占增值税欠税纳税人的比例(负向)既有留抵也有增值税欠税纳税人占增值税欠税纳税人的比例(负向)SE1.ECTT1.SHXYDM社会信用代码，T1.NSRMC纳税人名称，T1.YBTSE欠税金额，T2.BC1.DBHS留抵金额，p.dsswjgmc地市税务机构，P-Qxswjgmc区县税务机构，p.KSSWJGMC科所税务机构，P-Ssglyswrymc税收管理员,to-char(SYSDATE,yyyymm,)数据加工月份FROM(SE1.ECTNSR.NSRDZDAH,NSR.NSRSBH,NSR.SHXYDM,NSR.NSRMC,NSR.SWJGJDzNSR.SS

2、G1.YSWRY_DM,MAX(JKQX)JKQX,SUM(YBTSE)ybtsezZSXMJDFROMSJCK_BZ.SSHS_NSRQS1.STlINNERJOIN(SE1.ECT/*+PARA1.1.E1.(4)*/NSRDZDAH,NSRSBHzNV1.(SHXYDM,NSRSBH)shxydm,NSRMC,SWJGJD,SSG1.YSWRY_DM,NSRZT_DM-XYIM/20220310FROMSJCK_BZ.WD_NSRXX_BQNSRwherensr.kqccsztdjbz=n,ANDKZZTDJ1.X_ID0AND1.SRQ=1.AST-DAY(fxqjq)ANDT1.ZS

3、XMJD1.IKE,101%,GROUPBYNSR.NSRDZDAH,NSR.NSRSBH,NSR.SHXYDM,NSR.NSRMC,NSR.SWJGJD,NSR.SSG1.YSWRY_DM,ZSXMJD)TlInnerjoin(selectti.nsrdzdahznsr.swjgjdzsm(bcldbhs)bcldbhsFROMSJCKBZ.SBZZS1.DSK1.SZTlInnerjoin(select/*+parallel(4)*/NSRDZDAH,NSRSBH,NV1.(SHXYDM,NSRSBH)zNSRMCzSWJGJD,SSG1.YSWRY_DM,NSRZT_DM-XYIM/20

4、220310FROMSJCK_BZ.WD_NSRXX_BQNSRwherensr.kqccsztdjbz=n,andkzztdjlxjd,i40,andnsrztlxjdisnullANDNSR.YXBZ=Y,ANDNSRZT_DMIN(02,03,z,04,05z,0613)NSRONNSR.NSRDZDAH=T1.NSRDZDAHANDNSR.NSRZT_DM=,03,-XYIM20220314INNERJOINSJCK_BZ.WD_NSRXX_BQBQONT1.NSRDZDAH=BQ.NSRDZDAHANDBQ.ZZSNSR1.XJD=,1,-20220303/XYIMWHERE1.DFSRQ0)T2ONT2.NSRDZDAH=T1.NSRDZDAHjoinwd_nsrxxponT2.NSRDZDAH=p.NSRDZDAHandp.dsswjgjd=dsswjg_dmANDT1.SWJGJD=T2.SWJGJDwhereti.zsxmid=,oo,;