VIEW: APPS.MTL_VENDOR_LOT_VIEW

Source

View Text - Preformatted

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 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 UNION SELECT distinct mln.organization_id , mln.inventory_item_id , mln.lot_number , mln.supplier_lot_number vendor_lot_number FROM MTL_LOT_NUMBERS MLN

View Text - HTML Formatted

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 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 UNION SELECT DISTINCT MLN.ORGANIZATION_ID
, MLN.INVENTORY_ITEM_ID
, MLN.LOT_NUMBER
, MLN.SUPPLIER_LOT_NUMBER VENDOR_LOT_NUMBER
FROM MTL_LOT_NUMBERS MLN