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
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
|
|
|