SELECT
R.ITEMID,
INVENTDIM.CONFIGID,
INVENTDIM.INVENTSTYLEID,
INVENTDIM.INVENTSIZEID,
INVENTDIM.INVENTCOLORID,
INVENTDIM.INVENTSITEID,
INVENTDIM.INVENTLOCATIONID,
R.COVINVENTDIMID,
R.MININVENTONHAND,
R.MAXINVENTONHAND,
SUM(ISUM.AvailPhysical) AS TotalAvailPhysical,
SUM(ISUM.ORDERED) AS TotalAvailORDER
FROM
REQITEMTABLE R
JOIN
INVENTDIM ON R.COVINVENTDIMID = INVENTDIM.INVENTDIMID
JOIN
INVENTSUM ISUM ON R.ITEMID = ISUM.ITEMID
WHERE
R.COVRULE = 2
GROUP BY
R.ITEMID,
INVENTDIM.CONFIGID,
INVENTDIM.INVENTSTYLEID,
INVENTDIM.INVENTSIZEID,
INVENTDIM.INVENTCOLORID,
INVENTDIM.INVENTSITEID,
INVENTDIM.INVENTLOCATIONID,
R.COVINVENTDIMID,
R.MININVENTONHAND,
R.MAXINVENTONHAND
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156