select *
from all_source
where OWNER = 'ESP'
--and TYPE = 'PROCEDURE'
and TEXT like '%update%oms_forecast_data%sixvalidater%'
select *
from all_source
where OWNER = 'ESP'
--and TYPE = 'PROCEDURE'
and TEXT like '%update%oms_forecast_data%sixvalidater%'