VIEW: APPS.MTL_LOT_DEMAND_VAL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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