======================= Inventory Movement With Lot change, ====================
================================================================
 ~/eSmartFactory/InvMovWithLotRef/list/
 => **
 db.EvolveInventory.aggregate([
  {
    $match: {
      "$and": [
        {
          "$or": [
            {
              "EvolveInventory_QtyOnHand": { "$gt": 0 }
            }
          ]
        },
        {
          "$or": [
            {
              "EvolveInventory_Status": {
                "$regex": "^AVAILABLE$",
                "$options": "i"
              }
            }
          ]
        }
      ]
    }
  },
  {
    $lookup: {
      from: "EvolveItem",
      localField: "EvolveItem_ID",
      foreignField: "_id",
      as: "EvolveItem_ID"
    }
  },
  {
    $lookup: {
      from: "EvolveUom",
      localField: "EvolveUom_ID",
      foreignField: "_id",
      as: "EvolveUom_ID"
    }
  },
  {
    $lookup: {
      from: "EvolveLocation",
      localField: "EvolveLocation_ID",
      foreignField: "_id",
      as: "EvolveLocation_ID"
    }
  },
  {
    $match: {
      "$and": [
        {
          "$or": [
            {
              "EvolveLocation_IsVendor": { "$ne": true }
            }
          ]
        }
      ]
    }
  }
])
 
 -------------------- End ---------------------------------------