删除 AP 发票相关脚本代码,OracleEBS代码库,德仔网

代码语言
代码分类
【OracleEBS】删除 AP 发票相关脚本
作者:dezai / 发布于2014/1/26/ 2017
--发票
create table bak.AP_INVOICES_ALL_110707 as
select * from AP_INVOICES_ALL aia
where aia.invoice_id in (90490,90333)
--发票行
create table bak.AP_INVOICE_LINES_110707 as
select * from AP_INVOICE_LINES_ALL ala
where ala.invoice_id in (90490,90333);
--分配
create table bak.Ap_Invoice_Dist_110707 as
select *
 from Ap_Invoice_Distributions_All aid
where aid.invoice_id = 90490;
--计划付款
create table bak.AP_PAYMENT_SCHEDULES_110707 as
select * from AP_PAYMENT_SCHEDULES_ALL p
where p.invoice_id in (90490,90333);
--暂挂
create table bak.AP_HOLDS_110707 as
select * from AP_HOLDS_ALL h
where h.invoice_id = 90490;
--付款行
create table bak.AP_INVOICE_PAYMENTS_110707 as
select * from AP_INVOICE_PAYMENTS_all aip
where aip.invoice_id = 90333;
--付款头
create table bak.AP_CHECKS_110707 as
select * from AP_CHECKS_ALL ac where ac.check_id = 64863;
--分录事件
create table bak.xla_trans_entities_110707 as
select *
 from xla.xla_transaction_entities xte
where xte.source_id_int_1 in (90490, 90333)
 and xte.security_id_int_1 = 81
 and application_id = 200;
insert into bak.xla_trans_entities_110707
select * from xla.xla_transaction_entities xte
where xte.source_id_int_1 in (64863)
 and xte.security_id_int_1 = 81
 and application_id = 200;
 
--分录头
create table bak.xla_ae_headers_110707 as
select *
 from xla.xla_ae_headers xah
where xah.entity_id in (9556541, 9554363);
insert into bak.xla_ae_headers_110707
select * from xla.xla_ae_headers xah where xah.entity_id in (9554366);

--会计事件
create table bak.xla_events_110707 as
select *
 from xla_events xe
where xe.event_id in
   (select event_id
     from xla.xla_ae_headers xah
    where xah.entity_id in (9556541, 9554363));
insert into bak.xla_events_110707
select * from xla_events xe
where xe.event_id in
   (select event_id
     from bak.xla_ae_headers_110707 xah
    where xah.entity_id in (9554366));
--分录行
create table bak.xla_ae_lines_110707 as
select *
 from xla.xla_ae_lines xal
where xal.ae_header_id in (14101317, 14103708, 14299824);

insert into bak.xla_ae_lines_110707
select *
 from xla.xla_ae_lines xal
where xal.ae_header_id=14101322;

--日记账导入参考
create table bak.gl_import_references_110707 as
select *
 from gl.gl_import_references gr
where gr.gl_sl_link_id in
   (select gl_sl_link_id
     from xla.xla_ae_lines xal
    where xal.ae_header_id in (14101317, 14103708, 14299824));
insert into bak.gl_import_references_110707
select *
 from gl.gl_import_references gr
where gr.gl_sl_link_id in (25174221,25174222); 
--日记账头
create table bak.gl_je_headers_110707 as
select *
 from gl_je_headers gjh
where gjh.je_header_id in
   (select je_header_id
     from gl.gl_import_references gr
    where gr.gl_sl_link_id in
       (select gl_sl_link_id
         from xla.xla_ae_lines xal
        where xal.ae_header_id in (14101317, 14103708, 14299824)));
insert into bak.gl_je_headers_110707
select * from gl_je_headers gjh
where gjh.je_header_id =5553330;

--日记账行
create table bak.gl_je_lines_110707 as
select *
 from gl_je_lines gjl
where gjl.je_header_id in
   (select je_header_id
     from gl.gl_import_references gr
    where gr.gl_sl_link_id in
       (select gl_sl_link_id
         from xla.xla_ae_lines xal
        where xal.ae_header_id in (14101317, 14103708, 14299824)));
insert into bak.gl_je_lines_110707
select *
 from gl_je_lines gjl
where gjl.je_header_id=5553330;
--日记帐批 
create table bak.gl_je_batches_110707 as
select *
 from gl_je_batches gjb
where gjb.je_batch_id in
   (select je_batch_id
     from gl.gl_import_references gr
    where gr.gl_sl_link_id in
       (select gl_sl_link_id
         from xla.xla_ae_lines xal
        where xal.ae_header_id in (14101317, 14103708, 14299824)));
        

--发票
delete from AP_INVOICES_ALL aia
where aia.invoice_id in (90490,90333)
--发票行
delete from AP_INVOICE_LINES_ALL ala
where ala.invoice_id in (90490,90333);
--分配
delete from Ap_Invoice_Distributions_All aid
where aid.invoice_id = 90490;
--计划付款
delete from AP_PAYMENT_SCHEDULES_ALL p
where p.invoice_id in (90490,90333);
--暂挂
delete from AP_HOLDS_ALL h
where h.invoice_id = 90490;
--付款行
delete from AP_INVOICE_PAYMENTS_all aip
where aip.invoice_id = 90333;
--付款头
delete from AP_CHECKS_ALL ac where ac.check_id = 64863;
--分录事件
delete from xla.xla_transaction_entities xte
where xte.source_id_int_1 in (90490, 90333)
 and xte.security_id_int_1 = 81
 and application_id = 200;
delete from xla.xla_transaction_entities xte
where xte.source_id_int_1 in (64863)
 and xte.security_id_int_1 = 81
 and application_id = 200;
 
--分录头
delete from xla.xla_ae_headers xah
where xah.entity_id in (9556541, 9554363);

delete from xla.xla_ae_headers xah where xah.entity_id in (9554366);
--会计事件
delete from xla_events xe
where xe.event_id in
   (select event_id
     from bak.xla_ae_headers_110707 xah
    where xah.entity_id in (9556541, 9554363));
delete from xla_events xe
where xe.event_id in
   (select event_id
     from bak.xla_ae_headers_110707 xah
    where xah.entity_id in (9554366));    
--分录行
delete from xla.xla_ae_lines xal
where xal.ae_header_id in (14101317, 14103708, 14299824);

delete from xla.xla_ae_lines xal
where xal.ae_header_id=14101322;
--日记账导入参考
delete from gl.gl_import_references gr
where gr.gl_sl_link_id in
   (select gl_sl_link_id
     from bak.xla_ae_lines_110707 xal
    where xal.ae_header_id in (14101317, 14103708, 14299824));
delete from gl.gl_import_references gr
where gr.gl_sl_link_id in (25174221,25174222); 
--日记账头
delete from gl_je_headers gjh
where gjh.je_header_id in
   (select je_header_id
     from bak.gl_import_references_110707 gr
    where gr.gl_sl_link_id in
       (select gl_sl_link_id
         from bak.xla_ae_lines_110707 xal
        where xal.ae_header_id in (14101317, 14103708, 14299824)));
delete from gl_je_headers gjh
where gjh.je_header_id =5553330;
--日记账行
delete from gl_je_lines gjl
where gjl.je_header_id in
   (select je_header_id
     from bak.gl_import_references_110707 gr
    where gr.gl_sl_link_id in
       (select gl_sl_link_id
         from bak.xla_ae_lines_110707 xal
        where xal.ae_header_id in (14101317, 14103708, 14299824)));
delete from gl_je_lines gjl
where gjl.je_header_id=5553330;

--日记帐批 
delete from gl_je_batches gjb where gjb.je_batch_id=5007897
select rowid,gjb.*
 from gl_je_batches gjb
where gjb.je_batch_id in
   (select je_batch_id
     from bak.gl_import_references_110707 gr
    where gr.gl_sl_link_id in
       (select gl_sl_link_id
         from bak.xla_ae_lines_110707 xal
        where xal.ae_header_id in (14101317, 14103708, 14299824)));
试试其它关键字
　删除　　 AP　　发票　
同语言下
可能有用的
dezai贡献的其它代码(1065)