APPS.WSH_DEL_OI_CORE dependencies on MTL_ONHAND_QUANTITIES

Line 335: from mtl_onhand_quantities

331: BEGIN
332: declare
333: cursor validate_lot is
334: select 'lot number valid'
335: from mtl_onhand_quantities
336: where inventory_item_id = X_item_id
337: and organization_id = X_warehouse_id
338: and nvl(subinventory_code,'X') = nvl(X_subinventory,'X')
339: and lot_number = X_lot_number;