

public PXFilteredProcessingJoin<TSFixedDemand, TSProductionOrdersCreateFilter,
InnerJoin<InventoryItem,
On<InventoryItem.inventoryID, Equal<TSFixedDemand.inventoryID>>,
LeftJoin<SOOrder,
On<SOOrder.noteID, Equal<TSFixedDemand.refNoteID>>,
LeftJoin<SOLineSplit,
On<SOLineSplit.planID, Equal<TSFixedDemand.planID>>,
LeftJoin<SOLine,
On<SOLine.orderType, Equal<SOLineSplit.orderType>,
And<SOLine.orderNbr, Equal<SOLineSplit.orderNbr>,
And<SOLine.lineNbr, Equal<SOLineSplit.lineNbr>>>>,
LeftJoin<INItemClass,
On<INItemClass.itemClassID, Equal<InventoryItem.itemClassID>>,
LeftJoin<SOOrderType,
On<SOOrderType.orderType, Equal<SOOrder.orderType>>,
LeftJoin<TSProdFormulaMTranSplit, On<TSProdFormulaMTranSplit.planID, Equal<TSFixedDemand.planID>>
, LeftJoin<TSProdBOMMtranSplit, On<TSProdBOMMtranSplit.planID, Equal<TSFixedDemand.planID>>>
/* , LeftJoin<TSProdBOMMtranSplit, On<TSProdBOMMtranSplit.planID, Equal<TSFixedDemand.planID>>>*/>>>>>>>,
Where<
Where<TSFixedDemand.supplyPlanID, IsNull,
And2<Where<TSFixedDemand.inventoryID, Equal<Current<TSProductionOrdersCreateFilter.inventoryID>>,
Or<Current<TSProductionOrdersCreateFilter.inventoryID>, IsNull>>,
And2<Where<TSFixedDemand.siteID, Equal<Current<TSProductionOrdersCreateFilter.siteID>>,
Or<Current<TSProductionOrdersCreateFilter.siteID>, IsNull>>,
And2<Where<SOOrder.customerID, Equal<Current<TSProductionOrdersCreateFilter.customerID>>,
Or<Current<TSProductionOrdersCreateFilter.customerID>, IsNull>>,
And2<Where<TSFixedDemand.planDate, GreaterEqual<Current<TSProductionOrdersCreateFilter.requestedOnStartDate>>,
Or<Current<TSProductionOrdersCreateFilter.requestedOnStartDate>, IsNull>>,
And2<Where<TSFixedDemand.planDate, LessEqual<Current<TSProductionOrdersCreateFilter.requestedOnEndDate>>,
Or<Current<TSProductionOrdersCreateFilter.requestedOnEndDate>, IsNull>>,
And<Where<INItemClass.itemClassCD, Like<Current<TSProductionOrdersCreateFilter.itemClassCDWildcard>>,
Or<Current<TSProductionOrdersCreateFilter.itemClassCDWildcard>, IsNull>>>>>>>>>>> FixedDemand;