误关闭库存期间

SELECT acct_period_id period, open_flag, period_name name, 
period_start_date, schedule_close_date, period_close_date 
FROM org_acct_periods 
WHERE organization_id = &org_id 
order by 1,2;

UPDATE org_acct_periods 
SET open_flag = 'Y', 
period_close_date = NULL, 
summarized_flag = 'N' 
WHERE organization_id = &&org_id 
AND acct_period_id >= &&acct_period_id; 

DELETE mtl_period_summary 
WHERE organization_id = &org_id 
AND acct_period_id >= &acct_period_id; 

DELETE mtl_period_cg_summary 
WHERE organization_id = &org_id 
AND acct_period_id >= &acct_period_id; 

DELETE mtl_per_close_dtls 
WHERE organization_id = &org_id 
AND acct_period_id >= &acct_period_id; 

DELETE cst_period_close_summary 
WHERE organization_id = &org_id 
AND acct_period_id >= &acct_period_id;

posted @ 2013-06-13 20:16 郭振斌 阅读(...) 评论(...) 编辑 收藏