电子专票和纸质专票最高开票限额不一致的户数.docx

电子专票和纸质专票最高开票限额不一致的户数withhas(SE1.ECTHDQCXH,A.NSRDZDAH,SHXYDM,NSRSBHzNSRMC,B.FPZ1.mc,A.DFFPZGKPXEJDzA.DFFPZGKPXE,MyzggpslMczggpslYXQQ,YXQZ,NSR.SWJG_DM,nsr.swjgmc,nsr.SSG1.YSWRYMCswry,NSR.SSG1.YSWRY_DM,nsr.dsswjg-dmznsr.dsswjgmcznsr.qxswjgmc,A.1.RRQ,B.ZPPZ_IDFROMSJCK_BZ.FP_PZHDXXAINNERJOINSJCK_BZ.WD_FPZ1.BONA.FPZ1._ID=B.FPZ1._IDInnerjoin(selectnsr.nsrdzdahzNSR.SWJGJD,NSR.SWJG_DM,NSR.SSG1.YSWRY_DM,nsr.SSG1.YSWRYMCzNSR.swjgmc,nsr.dsswjg-dmznsr.dsswjgmc,nsr.qxswjgmcFROMSJCK_BZ.WD_NSRXXNSRWHERENSR.KQCCSZTDJBZ='N'ANDNSR.KZZTDJ1.XJD<'1140,ANDNSR.NSRZT1.XJDISNU1.1.ANDNSR.NSRZT_DM='03'ANDNSR.YXBZ='Y,ANDTRNC(NSR.SWHZDJRQ)>=(selectCASEWHENCOUNT(I)>=1THENDAE'2018-10-01,E1.SEDATE,2018-08-01'ENDDATE_1.RRQSWJGCC1.X_BJ=,fromWD_SWJGWherejGJCJD=lOl'ANDANDSWJGJDINa.nsrdzdaha.swjgmca.swrya.FPZ1.mca.DFFPZGKPXEA.YXQQA.YXQZa.dsswjgmca.q×swjgmcFROMhA(,16300000000,z,15400000000,16500000000')NSRONA.NSRDZDAH=NSR.NSRDZDAHWHEREB.ZPPZJDIN(','9,)ANDA.YXQQ<=trunc(sysdate)ANDA.YXQZ>=trunc(sysdate)ANDA.YXQZ>A.YXQQ)SE1.ECTA.NSRMCas纳税人名称,nvl(A.SHXYDM,a.NSRSBH)as社会信用代码,as纳税人电子档案号，as主管税务机关，as税收管理员，as发票种类，as单份发票最高开票限额,as有效期起，as有效期止，as地市级税务机关，as区县级税务机关Innerjoin(selectti.NsrdzdahfromhTlInnerjoinhT2ONT1.NSRDZDAH=T2.NSRDZDAHANDT2.ZPPZJD='9,WHERET1.ZPPZJD=,1,ANDT1.DFFPZGKPXE<>T2.DFFPZGKPXEGROUPBYT1.NSRDZDAH)BONA.NSRDZDAH=B.NSRDZDAHwherea.dsswjg_dm=dsswjg_dm