View: CSP_GET_LOT_NUMBERS_V

Product:	CSP - Spares Management
Description:	Get the lot numbers associated with a part-in Item number
Implementation/DBA Data:	APPS.CSP_GET_LOT_NUMBERS_V

View Text

SELECT MOQ.ORGANIZATION_ID
, MOQ.INVENTORY_ITEM_ID
, MOQ.REVISION
, MLN.LOT_NUMBER
, MOQ.SUBINVENTORY_CODE
, MOQ.LOCATOR_ID FROM MTL_ONHAND_QUANTITIES MOQ
, MTL_LOT_NUMBERS MLN
WHERE MOQ.INVENTORY_ITEM_ID = MLN.INVENTORY_ITEM_ID
AND MOQ.ORGANIZATION_ID = MLN.ORGANIZATION_ID
AND MOQ.LOT_NUMBER = MLN.LOT_NUMBER GROUP BY MOQ.ORGANIZATION_ID
, MOQ.INVENTORY_ITEM_ID
, MOQ.REVISION
, MLN.LOT_NUMBER
, MOQ.SUBINVENTORY_CODE
, MOQ.LOCATOR_ID

Columns