View: IC_LOCT_INV_RPTVW1

Product:	GMI - Process Manufacturing Inventory
Description:	Lot inventory report view.
Implementation/DBA Data:	APPS.IC_LOCT_INV_RPTVW1

View Text

SELECT INV.WHSE_CODE
, I.ITEM_NO
, L.LOT_NO
, L.SUBLOT_NO
, W.WHSE_NAME
, I.ITEM_DESC1
, I.ITEM_UM
, I.ITEM_UM2
, L.LOT_CREATED
, L.EXPIRE_DATE
, INV.LOCATION
, SUM( INV.LOCT_ONHAND)
, SUM(INV.LOCT_ONHAND2)
, I.DELETE_MARK
FROM IC_ITEM_MST I
, IC_LOTS_MST L
, IC_LOCT_INV INV
, IC_WHSE_MST W
WHERE I.ITEM_ID = L.ITEM_ID
AND L.ITEM_ID = INV.ITEM_ID
AND L.LOT_ID = INV.LOT_ID
AND INV.WHSE_CODE = W.WHSE_CODE GROUP BY INV.WHSE_CODE
, ITEM_NO
, LOT_NO
, SUBLOT_NO
, W.WHSE_NAME
, ITEM_DESC1
, ITEM_UM
, ITEM_UM2
, LOT_CREATED
, EXPIRE_DATE
, LOCATION
, I.DELETE_MARK HAVING SUM(INV.LOCT_ONHAND) <> 0 OR SUM(INV.LOCT_ONHAND2) <> 0

Columns