SELECT ILI.WHSE_CODE , ITM.ITEM_ID , SUM(ILI.LOCT_ONHAND) , SUM(ILI.LOCT_ONHAND2) FROM IC_ITEM_MST ITM, IC_LOCT_INV ILI WHERE ITM.ITEM_ID = ILI.ITEM_ID AND ILI.DELETE_MARK = 0 AND ITM.DELETE_MARK = 0 GROUP BY ILI.WHSE_CODE, ITM.ITEM_ID
SELECT ILI.WHSE_CODE
, ITM.ITEM_ID
, SUM(ILI.LOCT_ONHAND)
, SUM(ILI.LOCT_ONHAND2)
FROM IC_ITEM_MST ITM
, IC_LOCT_INV ILI
WHERE ITM.ITEM_ID = ILI.ITEM_ID
AND ILI.DELETE_MARK = 0
AND ITM.DELETE_MARK = 0 GROUP BY ILI.WHSE_CODE
, ITM.ITEM_ID
|
|
|