 |
There are currently no products in this category.
You may call 1.800.541.2905
to speak with a company representative.
SELECT i.INVID, i.Description AS iDescription, i.ICStatusID, i.InventoryItem, i.Part#, subB.InStock AS BucketStock, CASE WHEN (subB.InStock - subB.OnHold) > 0 THEN 1 ELSE 0 END AS InStock, pd.pricedec2 WebPrice, ix.WebPicFileName, ix.WebPicHeight, ix.WebPicWidth, q.duedate, ix.ICWebGroupID, wg.isCustom, wg.WebGroupOrder, wg.CategoryID, wg.FlagType, ISNULL(wg.Description,ix.WebName) AS GroupName, wg.WebPicFileName AS GroupFileName, wg.WebDescription AS GroupDescription, wg.FlagType & 1 AS WFO, (CASE WHEN LEFT(ISNULL(wg.WebPicFileName,ix.WebPicFileName), 1)='3' THEN 1 ELSE 0 END) AS WGO, ix.WebDescription, '' AS BlankFile FROM tblWSItems wi WITH( NOLOCK ) JOIN tblWSTypes wt WITH( NOLOCK ) ON wi.WSTypeID = wt.WSTypeID JOIN tblWebSites ws WITH( NOLOCK ) ON wt.WebSiteID = ws.WebSiteID JOIN tblICWebExt ix WITH( NOLOCK ) ON wi.INVID = ix.INVID JOIN tblInventory i WITH( NOLOCK ) ON wi.INVID = i.INVID JOIN tblICPriceStruDtl pd WITH( NOLOCK ) ON wi.INVID = pd.INVID AND pd.PriceLevelID = 49 LEFT JOIN tblICWebExc xc WITH( NOLOCK ) ON pd.INVID = xc.INVID AND pd.PriceLevelID = xc.PriceLevelID LEFT JOIN tblICWebGroups wg WITH( NOLOCK ) ON ix.ICWebGroupID = wg.ICWebGroupID LEFT JOIN ( SELECT INVID, SUM(InStock) AS InStock, SUM(OnHold) AS OnHold FROM tblICBucketDetails WITH(nolock) WHERE ICBucketID = 3 GROUP BY INVID ) subB ON i.INVID = subB.INVID LEFT JOIN (SELECT pod.INVID, MIN(po.duedate) AS duedate FROM tblPurchaseOrders po WITH( NOLOCK ) JOIN tblPurchaseOrderDetail pod WITH( NOLOCK ) ON po.POID = pod.POID WHERE po.Cleared=0 AND pod.AmountOut > 0 GROUP BY pod.INVID) q ON wi.INVID = q.INVID WHERE wi.WSTypeID = 23 AND wi.WSCategoryID = 53 AND ix.Active != 0 AND (i.ICStatusID = 1 OR ((i.ICStatusID = 50 OR i.ICStatusID = 75) AND subB.InStock > 0) or i.ICStatusID = 150) AND xc.WebExcID IS NULL AND (( (subB.InStock - subB.OnHold > 0) OR wg.isCustom > 0 OR wg.CustomDelay > 0 OR ix.Manual > 0 OR (q.duedate IS NOT NULL)) OR i.InventoryItem != 1) ORDER BY WGO DESC, WebGroupOrder DESC, WebItemOrder, wg.Description, ix.WebName DESC
|
|
|
