Thursday 5 June 2014

GL Period Delete query

delete from gl_period_statuses where start_date >= '31-JAN-2014' and closing_status in ('F','N');

delete from gl_periods where period_set_name ='Global' and start_date >= '31-JAN-2014'
and period_type ='21' ;

delete from pa_periods_all where org_id in (111,222)
and start_date >= '31-JAN-2014' and status='N';

No comments:

Post a Comment