ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4B5DB43224F92FB9E0630100007F912EY update xxen_schub_plan_sup_dmd_gt xspsd set xspsd.filter_exclude_flag=null where rowid in (select chartorowid(xspav.row_id) from xxen_schub_plan_actions_v xspav where 1=1 ) S US XXEN_SCHUB_PLAN_ACTIONS_FILTER System report controlling the plan actions filter functionality on the Supply Chain Hub form Supply Chain Hub 1=1 1 10 1=1 xspav.organization_code = :org_code LOV custom Y select distinct xspav.organization_code value, null description from xxen_schub_plan_actions_v xspav order by value US Organization 2 15 1=1 xspav.item = :item LOV custom Y select distinct xspav.item value, null description from xxen_schub_plan_actions_v xspav order by value US Item 3 20 1=1 xspav.date_ >= trunc(:req_date_from) Date US Date From 4 30 1=1 xspav.date_ < trunc(:req_date_to)+1 Date US Date To 5 50 1=1 xspav.type = :order_type LOV custom Y select distinct xspav.type value, null description from xxen_schub_plan_actions_v xspav order by value US Type 6 70 1=1 xspav.identifier = :identifier LOV custom Y select distinct xspav.identifier value, null description from xxen_schub_plan_actions_v xspav order by value US Identifier 7 80 1=1 upper(xspav.identifier) like '%' || upper(:identifier_contains) || '%' Char US Identif. Contains 8 90 1=1 xspav.action = :action LOV custom Y select distinct xspav.action value, null description from xxen_schub_plan_actions_v xspav order by value US Action 9 140 1=1 xspav.reschedule_date >= trunc(:resch_date_from) Date US Resch Date From 10 150 1=1 xspav.reschedule_date < trunc(:resch_date_to)+1 Date US Resch Date To 11 160 1=1 xspav.start_date >= trunc(:start_date_from) Date US Start Date From 12 170 1=1 xspav.start_date < trunc(:start_date_to)+1 Date US Start Date To 13 180 1=1 xspav.project = :project LOV custom Y select distinct xspav.project value, null description from xxen_schub_plan_actions_v xspav order by value US Project 14 190 1=1 xspav.task = :task LOV custom Y select distinct xspav.task value, null description from xxen_schub_plan_actions_v xspav where (:$flex$.project is null or xspav.project = :$flex$.project) order by value US Task