检查数据

检查未上传编码券数据

with st as
 (select o.trade_time,
         o.id,
         o.order_no,
         o.cashier_no,
         o.cashier_name,
         o.pos_no,
         p.tender_type_id,
         p.tender_amount
    from bhg.h_t_order@erp100013new o, bhg.h_t_order_pay@erp100013new p
   where o.id = p.o_id
     and p.tender_type_id = 20493
     and o.belong_date = 20211006),
skp as
 (select *
    from skp_order@gccrm
   where trunc(create_time) = to_date(20211006, 'yyyymmdd'))
select *
  from st
 where not exists (select 'X'
          from skp
         where st.order_no = skp.recipe_no
           and st.pos_no = skp.pos_no);