应收发票相关脚本

--组织表
select * from hr_organization_units_v
--AR 事物处理安全性限制
begin
mo_global.set_policy_context('S', '82');
end;

-- 备份事物处理
create table bak.RA_CUSTOMER_TRX_ALL20120619 as
select * from RA_CUSTOMER_TRX_ALL where TRX_NUMBER = '10102672'
-- 检测备份情况
select * from bak.RA_CUSTOMER_TRX_ALL20120619
-- 修改事物处理
select t.*,t.rowid from RA_CUSTOMER_TRX_ALL t where TRX_NUMBER = '10102672'

-- 备份事物处理行
create table bak.RA_CUSTOMER_TRX_LINES_all0619 as
SELECT *
FROM RA_CUSTOMER_TRX_LINES_all where CUSTOMER_TRX_ID = 978317 --CUSTOMER_TRX_LINE_ID
-- 检测备份数据
select * from bak.RA_CUSTOMER_TRX_LINES_all0619
-- 修改事物处理行
SELECT t.*,t.rowid
FROM RA_CUSTOMER_TRX_LINES_all t where CUSTOMER_TRX_ID = 978317 --CUSTOMER_TRX_LINE_ID

-- 备份应收事物处理分配行
create table bak.RA_CUST_TRX_LINE_GL_DIST0619 as
select *
from RA_CUST_TRX_LINE_GL_DIST where CUSTOMER_TRX_ID = 978317
-- 检测备份数据
select * from bak.RA_CUST_TRX_LINE_GL_DIST0619
-- 修改应收事物处理分配行
select t.*,t.rowid
from RA_CUST_TRX_LINE_GL_DIST t where CUSTOMER_TRX_ID = 978317

-- 备份应收事物处理-税行
create table bak.ZX_LINES20120619 as
select * from ZX_LINES where TRX_NUMBER = '10102672'
-- 检测备份数据
select * from bak.ZX_LINES20120619
-- 修改应收事物处理-税行
select t.*,t.rowid from ZX_LINES t where TRX_NUMBER = '10102672'