FND Design Data [Home] [Help]

View: MTL_VENDOR_LOT_VIEW

Product: INV - Inventory
Description: Supplier information
Implementation/DBA Data: ViewAPPS.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