ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4CF21A89C59D4451E0630100007F8989Y update xxen_schub_forecast_gt xsfg set xsfg.filter_exclude_flag=null where rowid in (select chartorowid(xsfv.row_id) from xxen_schub_forecast_v xsfv where 1=1 ) S US XXEN_SCHUB_FORECAST_FILTER System report controlling the forecast filter functionality on the Supply Chain Hub form Supply Chain Hub 1=1 1 10 1=1 xsfv.forecast_set = :fc_set LOV custom Y select distinct xsfv.forecast_set value, null description from xxen_schub_forecast_v xsfv order by value US Forecast Set 2 20 1=1 xsfv.forecast_designator = :fc_designator LOV custom Y select distinct xsfv.forecast_designator value, null description from xxen_schub_forecast_v xsfv where xsfv.forecast_set = nvl(:$flex$.forecast_set,xsfv.forecast_set) order by value US Forecast 3 30 1=1 xsfv.organization_code = :org_code LOV custom Y select distinct xsfv.organization_code value, null description from xxen_schub_forecast_v xsfv order by value US Organization 4 40 1=1 xsfv.item = :item LOV custom Y select distinct xsfv.item value, null description from xxen_schub_forecast_v xsfv order by value US Item 5 50 1=1 xsfv.forecast_date >= trunc(:fc_date_from) Date US Date From 6 60 1=1 xsfv.forecast_date < trunc(:fc_date_to)+1 Date :$flex$.Date_From US Date To 7 70 1=1 xsfv.project = :project LOV custom Y select distinct xsfv.project value, null description from xxen_schub_forecast_v xsfv order by value US Project 8 80 1=1 xsfv.task = :task LOV custom Y select distinct xsfv.task value, null description from xxen_schub_forecast_v xsfv where (:$flex$.project is null or xsfv.project = :$flex$.project) order by value US Task