2021-03-09

SELECT

  paan.voucher_no,

  paan.created_date,

  paan.agency_code,

  NULL AS '支付摘要',

  paan.plan_amt,

  a.*

FROM

  pl_amt_arrive_notice paan,

  (SELECT

    ppv.bgt_id,

    ppv.ind_summary,

    NULL AS '结算方式编码',

    NULL AS '结算方式名称',

    ppv.pay_type_code,

    ppv.pay_type_name,

    NULL AS '收款人',

    bbi.pro_code,

    bbi.pro_name,

    bbi.pro_cate_code,

    bbi.pro_cate_name,

    ppv.fund_type_code,

    ppv.fund_type_name,

    ppv.pay_quota_bid

  FROM

    pay_plan_voucher ppv,

    bmp_quota.ba_bgt_info bbi

  WHERE ppv.bgt_id = bbi.bgt_id

    AND ppv.is_delete = 0

    AND bbi.is_deleted = 0) AS a

WHERE a.pay_quota_bid = paan.bid

  AND paan.is_delete = 0

  AND paan.bid IN

  (SELECT

    bid

  FROM

    pl_amt_arrive_notice

  WHERE JSON_EXTRACT (extend, '$."PlAmtStatus"') = '1'

    AND is_delete = 0)

  AND paan.tenant_id IN ('440000000')

  AND paan.fiscal_year IN ('2021')