XXEN_SCHUB_SUPPLY_DEMAND_FILTER

Description
Categories: Supply Chain Hub
System report controlling the supply/demand 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(xssdv.msdt_rowid)
 from xxen_schub_supply_demand_v xssdv
 where 1=1
 )
or rowid in
(select chartorowid(xssdv.mosv_rowid)
 from xxen_schub_supply_demand_v xssdv
 where 1=1
 )
Parameter Name SQL text Validation
Organization
xssdv.organization_code = :org_code
LOV
Date From
xssdv.date_ >= trunc(:req_date_from)
Date
Date To
xssdv.date_ < trunc(:req_date_to)+1
Date
Supply/Demand
xssdv.supply_or_demand_ = :supply_or_demand
LOV
Type
xssdv.type = :order_type
LOV
Exclude Type
xssdv.type != :order_type
LOV
Excl. Compl. WO
not exists
(select null
 from   wip_discrete_jobs wdj
 where  xssdv.disposition_type = 5
 and    wdj.wip_entity_id = xssdv.msdt_disposition_id
 and    wdj.organization_id = xssdv.organization_id
 and    nvl(wdj.status_type,-99) in (4,5)
 union
 select null
 from   wip_repetitive_schedules wrs
 where  xssdv.disposition_type = 4
 and    wrs.wip_entity_id = xssdv.msdt_disposition_id
 and    wrs.organization_id = xssdv.organization_id
 and    nvl(wrs.status_type,-99) in (4,5)
)
LOV
Identifier
xssdv.identifier = :identifier
LOV
Identif. Contains
upper(xssdv.identifier) like '%' || upper(:identifier_contains) || '%'
Char
Action
xssdv.action = :action
LOV
Exception
xssdv.exception_message = :exception_message
LOV
Exception exists
xssdv.exception_message is not null
LOV Oracle
Pegged Item
xssdv.pegged_item = :pegged_item
LOV
Pegging Info
xssdv.pegging_info = :pegged_item
LOV
Resch Date From
xssdv.reschedule_date >= trunc(:resch_date_from)
Date
Resch Date To
xssdv.reschedule_date < trunc(:resch_date_to)+1
Date
Start Date From
xssdv.start_date >= trunc(:start_date_from)
Date
Start Date To
xssdv.start_date < trunc(:start_date_to)+1
Date
Project
xssdv.project = :project
LOV
Task
xssdv.task = :task
LOV