/* userid = 26200000000 , sqlXh = 300052 */ SELECT , SUM(JKS_JE) JKS_JE, SUM(JKS_HJ) JKE_HJ, SUM(JKS_NBH) JKS_NBM, SUM(JE_2) GRSDS, SUM(JE_B) QYSDS, SUM(JE_3) TDZZS, SUM(JE_5) CCS, SUM(JE_6) FCS, SUM(JE_7) TZS, SUM(JE_8) ZYS,
SUM(JE_9) CZTUSYS, SUM(JE_A) SWBMFMSR, SUM(JE_1) YYS, SUM(JE_C) JYFJ, SUM(JE_0) YHS,
SUM(JE_D) WHSYJSF, SUM(JE_E) XZXSFSR, SUM(JE_4) CSJSWH, SUM(JE_F) GJFJ, SUM(JE_G) GDZYS, SUM(JE_H) QF, SUM(JE_L) JGTJ FROM (
SELECT DECODE(DJ.DJLX_DM,NULL,'汇总缴款','0122','内部户缴款',DJ.NSR_MC) NSR_MC,
DJ.NSRBM, ZS.ZSJG_DM,
ZS.GLJG_DM YWGLJG_DM, DJ.GLJG_DM NSRGLJG_DM, ZS.HSJG_DM, ZS.HY_DM,
SUBSTR(ZS.HY_DM,1,2) AS HYDL,
SUBSTR(ZS.HY_DM,1,4) AS HYZL, ZS.SKSX1_DM, ZS.SKSX2_DM, ZS.ZSDLFS_DM, DJ.ZCLX_DM, DJ.DJLX_DM, ZS.LRRY_DM, ZS.ZSXM_DM,
ZS.ZSXM_DM||ZS.ZSPM_DM ZSPM_DM, ZS.YSKM_DM,
ZS.YSFPBL_DM, ZS.SKYYZHID,
SWJG1.SWJG_DM AS FJBM, SWJG2.SWJG_DM AS QXJBM, SWJG2.SJSWJG_DM AS SJBM, DJ.ZGY_DM, ZS.SJ_JE JKS_JE,
DECODE(ZS.HZ_BJ,0,SJ_JE,0) JKS_HJ,
DECODE(DJ.DJLX_DM,'0122',SJ_JE,0) JKS_NBH, DECODE(ZS.ZSXM_DM, '02', SJ_JE, 0) JE_1, DECODE(ZS.ZSXM_DM, '06', SJ_JE, 0) JE_2, DECODE(ZS.ZSXM_DM, '15', SJ_JE, 0) JE_3, DECODE(ZS.ZSXM_DM, '16', SJ_JE, 0) JE_4, DECODE(ZS.ZSXM_DM, '08', SJ_JE, 0) JE_5, DECODE(ZS.ZSXM_DM, '07', SJ_JE, 0) JE_6, DECODE(ZS.ZSXM_DM, '10', SJ_JE, 0) JE_7, DECODE(ZS.ZSXM_DM, '13', SJ_JE, 0) JE_8, DECODE(ZS.ZSXM_DM, '14', SJ_JE, 0) JE_9, DECODE(ZS.ZSXM_DM, '09', SJ_JE, 0) JE_0, DECODE(ZS.ZSXM_DM, '69', SJ_JE, 0) JE_A, DECODE(ZS.ZSXM_DM, '04', SJ_JE, 0) JE_B, DECODE(ZS.ZSXM_DM, '61', SJ_JE, 0) JE_C, DECODE(ZS.ZSXM_DM, '65', SJ_JE, 0) JE_D, DECODE(ZS.ZSXM_DM, '67', SJ_JE, 0) JE_E,
DECODE(ZS.ZSXM_DM, '62', SJ_JE,'90',SJ_JE, 0) JE_F, DECODE(ZS.ZSXM_DM, '74', SJ_JE, 0) JE_G, DECODE(ZS.ZSXM_DM, '75', SJ_JE, 0) JE_H, DECODE(ZS.ZSXM_DM, '92', SJ_JE, 0) JE_L FROM (
SELECT
A.NSRNBM NSRNBM, A.ZSXM_DM ZSXM_DM, A.ZSPM_DM ZSPM_DM, A.YSKM_DM YSKM_DM, A.YSFPBL_DM YSFPBL_DM, A.SKYYZHID SKYYZHID, A.SJ_JE SJ_JE, A.KJ_RQ KJ_RQ, B.RK_RQ RK_RQ, B.RKXH_XH RKXH_XH, B.RKXHXT_SJ RKXHXT_SJ, A.HSJG_DM HSJG_DM, A.ZSJG_DM ZSJG_DM, A.GLJG_DM GLJG_DM,
A.LRRY_DM LRRY_DM, A.LR_SJ LR_SJ,
A.XGRY_DM XGRY_DM, A.XG_SJ XG_SJ, A.ZF_BJ ZF_BJ, 1 HZ_BJ, YZ.HY_DM, YZ.LSGX_DM, YZ.ZCLX_DM, YZ.SKSX1_DM, YZ.SKSX2_DM, YZ.ZSDLFS_DM FROM T_ZS_XJJKMX A, (SELECT *
FROM T_ZS_ZJJKMX WHERE NSRNBM IS NULL AND ZF_BJ = '0') B, T_ZS_YZPZ YZ WHERE A.HZJK_XH = B.JK_XH(+)
AND A.HZJKMX_XH = B.JKMX_XH(+) AND A.PZ_XH=YZ.PZ_XH
AND A.YZMX_XH=YZ.YZMX_XH AND A.ZF_BJ = '0' AND (1=1) AND (1=1) AND
B.RK_RQ>=CAST(TRUNC(TO_DATE('2016-04-01','YYYY-MM-DD'))-1/86400 AS TIMESTAMP) AND B.RK_RQ <=CAST(TRUNC(TO_DATE('2016-04-30','YYYY-MM-DD'))-1/86400+1 AS TIMESTAMP) AND (1=1) AND (1=1)
AND (1=1) AND (1=1) AND (1=1) AND (1=1) AND (1=1)
UNION ALL
SELECT C.NSRNBM NSRNBM, C.ZSXM_DM ZSXM_DM, C.ZSPM_DM ZSPM_DM, C.YSKM_DM YSKM_DM, C.YSFPBL_DM YSFPBL_DM,
C.SKYYZHID SKYYZHID, C.SJ_JE SJ_JE, C.KJ_RQ KJ_RQ, C.RK_RQ RK_RQ, C.RKXH_XH RKXH_XH, C.RKXHXT_SJ RKXHXT_SJ, C.HSJG_DM HSJG_DM, C.ZSJG_DM ZSJG_DM, C.GLJG_DM GLJG_DM, C.LRRY_DM LRRY_DM, C.LR_SJ LR_SJ,
C.XGRY_DM XGRY_DM, C.XG_SJ XG_SJ, C.ZF_BJ ZF_BJ, 0 HZ_BJ, YZ.HY_DM, YZ.LSGX_DM, YZ.ZCLX_DM, YZ.SKSX1_DM, YZ.SKSX2_DM, YZ.ZSDLFS_DM
FROM T_ZS_ZJJKMX C,T_ZS_YZPZ YZ WHERE C.PZ_XH=YZ.PZ_XH
AND C.YZMX_XH=YZ.YZMX_XH AND C.NSRNBM IS NOT NULL AND C.ZF_BJ = '0' AND (1=1) AND (1=1) AND
C.RK_RQ>=CAST(TRUNC(TO_DATE('2016-04-01','YYYY-MM-DD'))-1/86400 AS TIMESTAMP) AND C.RK_RQ <=CAST(TRUNC(TO_DATE('2016-04-30','YYYY-MM-DD'))-1/86400+1 AS TIMESTAMP) AND (1=1)
AND (1=1)
AND (1=1) AND (1=1) AND (1=1) AND (1=1) AND (1=1) UNION ALL SELECT
T.NSRNBM NSRNBM,
T.ZSXM_DM ZSXM_DM, T.ZSPM_DM ZSPM_DM, T.YSKM_DM YSKM_DM, T.YSFPBL_DM YSFPBL_DM, T.GKZHID SKYYZHID, -T.ST_JE SJ_JE, T.TF_SJ KJ_RQ, T.TS_RQ RK_RQ, T.XH_XH RKXH_XH, T.TSXH_RQ RKXHXT_SJ, T.HSJG_DM HSJG_DM, T.ZSJG_DM ZSJG_DM, T.GLJG_DM GLJG_DM, T.LRRY_DM LRRY_DM, T.LR_SJ LR_SJ,
T.XGRY_DM XGRY_DM, T.XG_SJ XG_SJ, T.ZF_BJ ZF_BJ, 0 HZ_BJ, T.HY_DM, T.LSGX_DM, T.ZCLX_DM, T.SKSX1_DM, T.SKSX2_DM, T.ZSDLFS_DM FROM T_QS_TSPZ T WHERE T.ZF_BJ = '0' AND (1=1) AND (1=1) AND
T.TS_RQ>=CAST(TRUNC(TO_DATE('2016-04-01','YYYY-MM-DD'))-1/86400 AS TIMESTAMP) AND T.TS_RQ <=CAST(TRUNC(TO_DATE('2016-04-30','YYYY-MM-DD'))-1/86400+1 AS TIMESTAMP) AND (1=1) AND (1=1)
AND (1=1) AND (1=1) AND (1=1) AND (1=1)
AND (1=1) ) ZS,
T_DJ_NSRXX DJ,T_DM_GY_SWJG SWJG1,T_DM_GY_SWJG SWJG2,T_DM_GY_SWRY SWRY