为应付发票批添加ORG_ID

 

--1、备份
create table cux_ab20180330 as select * from ap_batches_all;
--2、更新
update ap_batches_all ab
set ab.org_id=(select aia.org_id from ap_invoices_all aia where aia.batch_id=ab.batch_id and rownum<=1);
--3、删除空批
delete ap_batches_all ab where not exists (select 1 from ap_invoices_all aia where aia.batch_id=ab.batch_id);
--4、查询空ORG_ID
select ab.org_id,ab.batch_id from ap_batches_all ab where ab.org_id is null;
--5、查询空批
select * from ap_batches_all ab where not exists (select 1 from ap_invoices_all aia where aia.batch_id=ab.batch_id);