XXEN_SCHUB_SUPPLY_DEMAND_FILTER
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 |
|
LOV | |
Date From |
|
Date | |
Date To |
|
Date | |
Supply/Demand |
|
LOV | |
Type |
|
LOV | |
Exclude Type |
|
LOV | |
Excl. Compl. WO |
|
LOV | |
Identifier |
|
LOV | |
Identif. Contains |
|
Char | |
Action |
|
LOV | |
Exception |
|
LOV | |
Exception exists |
|
LOV Oracle | |
Pegged Item |
|
LOV | |
Pegging Info |
|
LOV | |
Resch Date From |
|
Date | |
Resch Date To |
|
Date | |
Start Date From |
|
Date | |
Start Date To |
|
Date | |
Project |
|
LOV | |
Task |
|
LOV |