XXEN_SCHUB_PLAN_ACTIONS_FILTER

➜ Back to Library
Description
Categories: Supply Chain Hub
System report controlling the plan actions filter functionality on the Supply Chain Hub form
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
 )
Parameter NameSQL textValidation
Organization
xspav.organization_code = :org_code
LOV
Item
xspav.item = :item
LOV
Date From
xspav.date_ >= trunc(:req_date_from)
Date
Date To
xspav.date_ < trunc(:req_date_to)+1
Date
Type
xspav.type = :order_type
LOV
Identifier
xspav.identifier = :identifier
LOV
Identif. Contains
upper(xspav.identifier) like '%' || upper(:identifier_contains) || '%'
Char
Action
xspav.action = :action
LOV
Resch Date From
xspav.reschedule_date >= trunc(:resch_date_from)
Date
Resch Date To
xspav.reschedule_date < trunc(:resch_date_to)+1
Date
Start Date From
xspav.start_date >= trunc(:start_date_from)
Date
Start Date To
xspav.start_date < trunc(:start_date_to)+1
Date
Project
xspav.project = :project
LOV
Task
xspav.task = :task
LOV
Download
Related Blitz Reports
XXEN_SCHUB_SUPPLY_DEMAND_FILTER MSC Plan Order Upload Supply Chain Hub - MRP Release Diagnostics XXEN_SCHUB_FORECAST_FILTER QA Collection Plan Upload ECC Project Procurement, Procurement Plan MSC Pegging Hierarchy MRP Plan Orders XXEN_SCHUB_ITEM_SEARCH
Blitz Report™