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' |