Delete cn_trx_sales_lines_all
where processed_period_id = 2015001
Delete cn_trx_lines
where trx_id in (Select trx_id from cn_trx_all
where trunc(processed_date) between '01-APR-2015' and '30-APR-2015')
Delete cn_trx_all
where trunc(processed_date) between '01-APR-2015' and '30-APR-2015'
Delete cn_not_trx_all
where trunc(processed_date) between '01-APR-2015' and '30-APR-2015'
Delete cn_comm_lines_api_all
where trunc(processed_date) between '01-APR-2015' and '30-APR-2015'
DELETE FROM CN_COMMISSION_LINES_ALL
WHERE processed_date between '01-APR-2015' and '30-APR-2015'
DELETE FROM CN_COMMISSION_HEADERS_ALL
WHERE processed_date between '01-APR-2015' and '30-APR-2015'
Delete xx_jtf_rs_trxdata_stg
where trunc(invoice_processed_date) between '01-APR-2015' and '30-APR-2015'
delete xxatfl_jtf_rs_ar_trxdata_stg
where trunc(trx_date) between '01-APR-2015' and '30-APR-2015'
where processed_period_id = 2015001
Delete cn_trx_lines
where trx_id in (Select trx_id from cn_trx_all
where trunc(processed_date) between '01-APR-2015' and '30-APR-2015')
Delete cn_trx_all
where trunc(processed_date) between '01-APR-2015' and '30-APR-2015'
Delete cn_not_trx_all
where trunc(processed_date) between '01-APR-2015' and '30-APR-2015'
Delete cn_comm_lines_api_all
where trunc(processed_date) between '01-APR-2015' and '30-APR-2015'
DELETE FROM CN_COMMISSION_LINES_ALL
WHERE processed_date between '01-APR-2015' and '30-APR-2015'
DELETE FROM CN_COMMISSION_HEADERS_ALL
WHERE processed_date between '01-APR-2015' and '30-APR-2015'
Delete xx_jtf_rs_trxdata_stg
where trunc(invoice_processed_date) between '01-APR-2015' and '30-APR-2015'
delete xxatfl_jtf_rs_ar_trxdata_stg
where trunc(trx_date) between '01-APR-2015' and '30-APR-2015'
No comments:
Post a Comment