Nelson
9/6/2017 - 2:07 PM

OOS Report - Configuration

begin;

set local creativesystems.logged_user to 'system';
set search_path to master;

update config 
set config_value='00:00' 
where config_name in ('OOSReport:LocationRepSkuDayReportTime','OOSReport:LocationSkuDayReportTime');


commit;
select *
from master.config
where config_name in ('OOSReport:LocationRepSkuDayReportTime','OOSReport:LocationSkuDayReportTime');