Monday, 18 May 2015

Incentive Compensation rollback from calculate

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'

No comments:

Post a Comment