select f_zzsdje_cb*F_CWZZHL-f_ytje as tzje,t.* from (

SELECT F_DJSJ,F_ZDID,F_DWMC,F_ZDLX,F_FSD,F_ZDZT,F_JH,F_HBH,F_HBXZ,F_FSRQ,F_HD,F_HX,F_JXID,F_FSSJ,F_ZDMXID,F_BZID,F_FYMXID,F_FYMC,F_ZDSL,F_BZ,F_JE,F_SSSL,F_SSBZ,F_SSJE,F_SSJG,F_ZZSDSL,F_ZZSDBZ,F_ZZSDJE,F_CYCL,F_SHYJ,F_ZZSDJE_CB,F_ZZSDJE_ZZS,F_CB_ZZSL,

(select nvl(max(f_sjje),0) from VIEW_YT_CBMXB_01  where f_zdmxid=v.f_zdmxid and f_zdid=v.f_zdid) as F_YTJE,

(select  F_VOUCHER_ID from ZW_PZZB   where f_zdid=v.f_zdid ) AS F_ZZPZ,

nvl(f_cwzzhl,0) as f_cwzzhl,F_SFTZ,F_FSRQ_RWS ,F_HBH_RWS, F_HD_RWS,F_JH_RWS from  VIEW_JSD v WHERE

F_DJSJ>=TO_DATE('2021-01-01','YYYY-MM-DD') 

AND  F_FYMC <> 'passenger service charge(代收代付)'  

AND  F_FYMC <> 'security screening for passenger and baggage(代收代付)' 

AND  F_FYMC <> 'International Tourist Tax(代收代付)' 

AND  F_FYMC <> '机组早餐费' 

AND  F_FYMC <> '机组正餐费' 

AND  F_FYMC <> '机组晚餐费' 

AND  F_FYMC <> '机组夜宵费' 

AND  F_FYMC <> '机组交通费' 

AND  F_FYMC <> '机组单间住宿费' 

AND  F_FYMC <> '机组标间住宿费' 

AND  F_FYMC <> '机组其它费用'

) t where  F_ZZPZ!='null'