开票纳税人未申报占比（负向）.docx

开票纳税人未申报占比(负向)一增值税专用发票开票未申报清册SE1.ECT+PARA1.1.E1.(4)*/NSR.NSRDZDAH,-1.VC_YF_DMZB.KPYF_DM,B.KPJEzNSR.NSRSBH,NSR.SHXYDMzNSR.NSRMC,NSR.SWJG_DM,NSR.SSG1.YSWRY_DM,-1.VC_BATCH_ID,SYSDAEFROM(SE1.ECTA.NSRDZDAHFROM(SE1.ECT/*+PARA1.1.E1.(4)*/T.NSRDZDAH,T.YF_DMKPYF_DM,SUM(NV1.(T.ZKYXZYFPJE,0)KPJEFROMSJCK_BZJCZT_FPKJ_NSRKJXXTWHERET.YF_DM>=TC1.CHAR(ADD_MONTHS(Tc1.DArE(TC1.CHAR(fxqjq,YYYYMM')zYYYYMM'),-3)z,YYYYMM,)-202206201.IJYANDT.YF_DM<TO_CHAR(fxqjq,YYYYMM,)-202206201.IJYGROUPBYT.NSRDZDAH,T.YF_DM)AINNERJOIN(SE1.ECT/*+PARA1.1.E1.(4)*/T.NSRDZDAHFROMSJCK_BZJCCT_FPG1._NSRFP1.YCQKTINNERJOINSJCK_BZ.WD_FPZ1.BONT.FPZ1._DM=B.FPZ1.DANDB.ZPPZJDIN('1,'9')WHERET.YF_DM=TO_CHAR(ADD_MONTHS(fxqjqz-3),'YYYYMM,)-202206201.IJYANDNV1.(T.JUFS,0)>0-202206201.IJYGROUPBYT.NSRDZDAH)BONA.NSRDZDAH=B.NSRDZDAH1.EFTJOIN(SE1.ECT/*+PARA1.1.E1.(8)*/T.NSRDZDAHFROMSJCK_BZ.SB_SBXXT-20220310WHERENV1.(T.ZFBZ,N,)='N'ANDT.GZ1.XJDIN(,z,5,)ANDT.ZSXMJD='10101,ANDT.ZSD1.FSJD='O'ANDT.SBQX>=ADD_MONTHS(fxqjq,-2)-202206201.IJYANDT.SBQX<ADD_MONTHS(fxqjq,1)GROUPBYT.NSRDZDAH)C-20220310ONA.NSRDZDAH=C.NSRDZDAHWHEREC.NSRDZDAHISNU1.1.-20220310GROUPBYA.NSRDZDAHHAVINGSUM(A-KPJE)>450000)AINNERJOIN(SE1.ECT/*+PARA1.1.E1.(4)*/T.NSRDZDAH,T.YF_DMKPYF_DM,SUM(NV1.(T.ZKYXZYFPJE,0)KPJEFROMSJCK_BZJCZT_FPKJ_NSRKJXXTWHERET.YF_DM>=TC1.CHAR(ADD_MONTHS(Tc1.DArE(TC1.CHAR(fxqjq,YYYYMM')z,YYYYMM,)z-3)z,YYYYMM,)-202206201.IJYANDT.YF_DM<TO_CHAR(fxqjq,YYYYMM,)-202206201.IJYGROUPBYT.NSRDZDAH,T.YF_DM)BONA.NSRDZDAH=B.NSRDZDAHInnerjoin(select/*+parallel(4)*/NSRDZDAH,NSRSBH,SHXYDM,NSRMCzSWJG_DM,DSSWJG_DM,SSG1.YSWRY_DMFROMSJCK_BZ.WD_NSRXXNSRWHERENSR.KQCCSZTDJBZ='N'ANDKZZTDJ1.X_ID<,1140,AndnsrztlxjdisnullANDNSR.YXBZ=,Y,ANDCASEWHENNSR.ZFJG1.XJDIN(,2,z'3')THEN0E1.SE1END=1-202208191.IJYANDNSRZT_DMIN(*'02*/,03'*z,04'z'05','06'13,*/)NSRONA.NSRDZDAH=NSR.NSRDZDAHandnsr.DSSWJG_DM=dsswjg_dm;