[Home] [Help]
View: MTL_VENDOR_LOT_VIEW
View Text
SELECT DISTINCT MMT.ORGANIZATION_ID
, MMT.INVENTORY_ITEM_ID
, MTLN.LOT_NUMBER
, MMT.VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER
FROM MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TRANSACTION_LOT_NUMBERS MTLN
WHERE MTLN.TRANSACTION_ID = MMT.TRANSACTION_ID
AND MTLN.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND MTLN.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID UNION ALL SELECT DISTINCT MMT.ORGANIZATION_ID
, MMT.INVENTORY_ITEM_ID
, MTLN.LOT_NUMBER
, MTLN.SUPPLIER_LOT_NUMBER VENDOR_LOT_NUMBER
FROM MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TRANSACTION_LOT_NUMBERS MTLN
WHERE MTLN.TRANSACTION_ID = MMT.TRANSACTION_ID
AND MTLN.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND MTLN.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID
Columns
Name |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
LOT_NUMBER |
VENDOR_LOT_NUMBER |