应收发票相关脚本代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】应收发票相关脚本

作者:dezai / 发布于2014/1/26/ 1274


--组织表
select * from hr_organization_units_v
--AR 事物处理安全性限制
begin
mo_global.set_policy_context('S','107');
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'

试试其它关键字

　应收发票脚本　

同语言下

可能有用的

dezai贡献的其它代码(1065)