XXEN_SCHUB_SUPPLY_DEMAND_FILTER

➜ Back to Library
Description
Categories: Supply Chain Hub
System report controlling the supply/demand filter functionality on the Supply Chain Hub form
Run XXEN_SCHUB_SUPPLY_DEMAND_FILTER and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
Supply Chain Hub - MRP Release Diagnostics MSC Pegging Hierarchy MSC Plan Order Upload MSC Exceptions MSC Vertical Plan MSC Plan Orders ECC Project Procurement, Procurement Plan XXEN_SCHUB_ITEM_SEARCH MRP Pegging
Blitz Report™

Blitz Report™ provides multiple benefits: