----查询内部对账结果---------
select * from vayw.T_ORDER_MAIN WHERE VER_NO IN (select id from vayw.T_INNER_CHK_RESULT where settle_date=trunc(sysdate,'dd')-1);
select * from vayw.T_INNER_CHK_ERR where settle_date=trunc(sysdate,'dd')-1;
select * from vayw.T_INNER_CHK_RESULT where settle_date=trunc(sysdate,'dd')-1;
select * from vayw.T_ORDER_MAIN WHERE VER_NO = '247';
select * from vayw.T_INNER_CHK_RESULT where settle_date=trunc(sysdate,'dd')-1 and id = '247';
select * from vayw.T_INNER_CHK_ERR where settle_date=trunc(sysdate,'dd')-1 and id = '247';