XXEN_SCHUB_FORECAST_FILTER

➜ Back to Library
Description
Categories: Supply Chain Hub
System report controlling the forecast filter functionality on the Supply Chain Hub form
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
 )
Parameter NameSQL textValidation
Forecast Set
xsfv.forecast_set = :fc_set
LOV
Forecast
xsfv.forecast_designator = :fc_designator
LOV
Organization
xsfv.organization_code = :org_code
LOV
Item
xsfv.item = :item
LOV
Date From
xsfv.forecast_date >= trunc(:fc_date_from)
Date
Date To
xsfv.forecast_date < trunc(:fc_date_to)+1
Date
Project
xsfv.project = :project
LOV
Task
xsfv.task = :task
LOV
Download
Related Blitz Reports
XXEN_SCHUB_PLAN_ACTIONS_FILTER XXEN_SCHUB_SUPPLY_DEMAND_FILTER Supply Chain Hub - MRP Release Diagnostics XXEN_SCHUB_ITEM_SEARCH MSC Plan Order Upload MRP Item Forecast Upload XXE4ARW Excel4apps Inventory Items (1) Item_Forecast PO Approved Supplier List
Blitz Report™