View: MTL_LOT_DEMAND_VAL_V

Product:	INV - Inventory
Description:	The view shows the lot numbers which have corresponding demand.
Implementation/DBA Data:	APPS.MTL_LOT_DEMAND_VAL_V

View Text

SELECT MD.LOT_NUMBER LOT_NUMBER
, MLN.EXPIRATION_DATE
, MD.PRIMARY_UOM_QUANTITY
, MD.COMPLETED_QUANTITY
, MLN.INVENTORY_ITEM_ID
, MLN.ORGANIZATION_ID
, MD.REVISION
, MD.DEMAND_SOURCE_TYPE
, MD.SUPPLY_SOURCE_TYPE
, MD.RESERVATION_TYPE
, MD.ROW_STATUS_FLAG
, MD.SUPPLY_SOURCE_HEADER_ID
, MD.DEMAND_SOURCE_HEADER_ID
, MD.DEMAND_SOURCE_LINE
, MD.DEMAND_SOURCE_DELIVERY
, MD.SUBINVENTORY
, MD.LOCATOR_ID
, MLN.PARENT_LOT_NUMBER
, MLN.GRADE_CODE
FROM MTL_LOT_NUMBERS MLN
, MTL_DEMAND MD
WHERE MD.INVENTORY_ITEM_ID = MLN.INVENTORY_ITEM_ID
AND MD.ORGANIZATION_ID = MLN.ORGANIZATION_ID
AND MD.LOT_NUMBER = MLN.LOT_NUMBER
AND MD.LOT_NUMBER IS NOT NULL

Columns