Need help with First Row in Results Set of a SQL Server Query
If the AvailBinQty is >= PickQty then show the first row for the "Item No" "Lot Number" combination.
Else include the 1st and second line
and so on until it finds a "Item No" "Lot Number" combination where AvailBinQty is >= PickQty
Else include the 1st and second line
and so on until it finds a "Item No" "Lot Number" combination where AvailBinQty is >= PickQty
SELECT
TOP (100) PERCENT TRIM(
dbo.PK010033.MANUFACTUREORDER_I
) AS [MO No],
TRIM(dbo.PK010033.ITEMNMBR) AS [Item No],
TRIM(dbo.IV00101.ITEMDESC) AS [Desc],
CONVERT(
varchar, dbo.PK010033.REQDATE, 101
) AS Required,
CAST(
dbo.PK010033.QTY_ALLOWED_I AS INT
) AS PickQty,
SUM(
CAST(dbo.PK010033.QTY_ISSUED_I AS INT)
) AS Issued,
CAST(
dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT
) AS [Remaining Qty],
TRIM(dbo.IV00300.LOTNUMBR) AS [Lot Number],
TRIM(dbo.IV00300.BIN) AS BIN,
SUM(
CAST(
dbo.IV00300.QTYRECVD - dbo.IV00300.QTYSOLD AS INT
)
) AS AvailBinQty,
CONVERT(
varchar, dbo.IV00300.EXPNDATE, 101
) AS ExpireDate,
TRIM(dbo.PK010033.UOFM) AS PK_UoM,
TRIM(dbo.PK010033.LOCNCODE) AS Site,
TRIM(dbo.PK010033.RTSEQNUM_I) AS ROUTE_SEQ,
dbo.PK010033.BOMUSERDEF1_I AS [Offset Require Date],
dbo.PK010033.BOMUSERDEF2_I AS [Special Instructions],
CONVERT(
varchar, dbo.IV00300.EXPNDATE, 12
) AS [Expire No]
FROM
dbo.IV00101
RIGHT OUTER JOIN dbo.PK010033 ON dbo.IV00101.ITEMNMBR = dbo.PK010033.ITEMNMBR
LEFT OUTER JOIN dbo.IV00112
INNER JOIN dbo.IV00300 ON dbo.IV00112.ITEMNMBR = dbo.IV00300.ITEMNMBR
AND dbo.IV00112.BIN = dbo.IV00300.BIN ON dbo.PK010033.ITEMNMBR = dbo.IV00300.ITEMNMBR
AND dbo.PK010033.LOCNCODE = dbo.IV00300.LOCNCODE
GROUP BY
TRIM(
dbo.PK010033.MANUFACTUREORDER_I
),
TRIM(dbo.PK010033.ITEMNMBR),
TRIM(dbo.PK010033.UOFM),
TRIM(dbo.PK010033.RTSEQNUM_I),
TRIM(dbo.PK010033.LOCNCODE),
CONVERT(
varchar, dbo.PK010033.REQDATE, 101
),
dbo.PK010033.BOMUSERDEF1_I,
dbo.PK010033.BOMUSERDEF2_I,
dbo.PK010033.MANUFACTUREORDERST_I,
TRIM(dbo.IV00101.ITEMDESC),
CONVERT(
varchar, dbo.IV00300.EXPNDATE, 12
),
CONVERT(
varchar, dbo.IV00300.EXPNDATE, 101
),
TRIM(dbo.IV00300.BIN),
TRIM(dbo.IV00300.LOTNUMBR),
CAST(
dbo.PK010033.QTY_ALLOWED_I AS INT
),
CAST(
dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT
)
HAVING
(
dbo.PK010033.MANUFACTUREORDERST_I = 3
)
AND (
TRIM(dbo.PK010033.LOCNCODE) = 'EF-R'
)
AND (
CAST(
dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT
) > 0
)
AND (
SUM(
CAST(
dbo.IV00300.QTYRECVD - dbo.IV00300.QTYSOLD AS INT
)
) > 0
)
AND (
CONVERT(
varchar, dbo.IV00300.EXPNDATE, 101
) >= GETDATE()
)
ORDER BY
[MO No],
[Item No],
[Expire No]
Last Comment
Sharath S
Post sample result from your query and expected result.
ASKER
I filtered down the results set to just 2 items and removed a few columns for easy viewing. Note that the first line, Item No 30.1168, does not have enough "AvailBinQty" to fulfill the "PickQty" requested so the first 2 lines should show, but not the lines in the red box.
Item No 30.728 has enough qty to fill the order from the first line, so the rest of the lines in the red box should not show.
Item No 30.728 has enough qty to fill the order from the first line, so the rest of the lines in the red box should not show.
Hey Mike,
In order to get quality answers in here I'd suggest you trim your data down to just the columns/fields involved in the logic of the query you are trying to solve. Additional columns, although they might be needed in the final solution, will just add unnecessary complexity and can distract from the core issue. Also trim the rows to the minimum required to cover all of the possible cases.
If you can give a simplified set of data, and the result that you expect that is also helpful. The most useful format for this would be actual SQL Server table create and insert statements. Failing that a format that allows us to copy the data. Pictures of data are minimally useful.
When talking about first and second rows you are implying an ordering. From what I can see it looks like the relevant order is ExpireNo descending - is this right?
In order to get quality answers in here I'd suggest you trim your data down to just the columns/fields involved in the logic of the query you are trying to solve. Additional columns, although they might be needed in the final solution, will just add unnecessary complexity and can distract from the core issue. Also trim the rows to the minimum required to cover all of the possible cases.
If you can give a simplified set of data, and the result that you expect that is also helpful. The most useful format for this would be actual SQL Server table create and insert statements. Failing that a format that allows us to copy the data. Pictures of data are minimally useful.
When talking about first and second rows you are implying an ordering. From what I can see it looks like the relevant order is ExpireNo descending - is this right?
ASKER
Okay Matt, sounds like a plan, I will put something together and post
;WITH cte1
AS (SELECT TRIM(dbo.PK010033.MANUFACTUREORDER_I) AS [MO No],
TRIM(dbo.PK010033.ITEMNMBR) AS [Item No],
TRIM(dbo.IV00101.ITEMDESC) AS [Desc],
CONVERT(VARCHAR, dbo.PK010033.REQDATE, 101) AS Required,
Cast(dbo.PK010033.QTY_ALLOWED_I AS INT) AS PickQty,
Sum(Cast(dbo.PK010033.QTY_ISSUED_I AS INT)) AS Issued,
Cast(dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT) AS [Remaining Qty],
TRIM(dbo.IV00300.LOTNUMBR) AS [Lot Number],
TRIM(dbo.IV00300.BIN) AS BIN,
Sum(Cast(dbo.IV00300.QTYRECVD - dbo.IV00300.QTYSOLD AS INT)) AS AvailBinQty,
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 101) AS ExpireDate,
TRIM(dbo.PK010033.UOFM) AS PK_UoM,
TRIM(dbo.PK010033.LOCNCODE) AS Site,
TRIM(dbo.PK010033.RTSEQNUM_I) AS ROUTE_SEQ,
dbo.PK010033.BOMUSERDEF1_I AS [Offset Require Date],
dbo.PK010033.BOMUSERDEF2_I AS [Special Instructions],
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 12) AS [Expire No]
FROM dbo.IV00101
RIGHT OUTER JOIN dbo.PK010033
ON dbo.IV00101.ITEMNMBR = dbo.PK010033.ITEMNMBR
LEFT OUTER JOIN dbo.IV00112
INNER JOIN dbo.IV00300
ON dbo.IV00112.ITEMNMBR = dbo.IV00300.ITEMNMBR
AND dbo.IV00112.BIN = dbo.IV00300.BIN
ON dbo.PK010033.ITEMNMBR = dbo.IV00300.ITEMNMBR
AND dbo.PK010033.LOCNCODE = dbo.IV00300.LOCNCODE
GROUP BY TRIM(dbo.PK010033.MANUFACTUREORDER_I),
TRIM(dbo.PK010033.ITEMNMBR),
TRIM(dbo.PK010033.UOFM),
TRIM(dbo.PK010033.RTSEQNUM_I),
TRIM(dbo.PK010033.LOCNCODE),
CONVERT(VARCHAR, dbo.PK010033.REQDATE, 101),
dbo.PK010033.BOMUSERDEF1_I,
dbo.PK010033.BOMUSERDEF2_I,
dbo.PK010033.MANUFACTUREORDERST_I,
TRIM(dbo.IV00101.ITEMDESC),
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 12),
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 101),
TRIM(dbo.IV00300.BIN),
TRIM(dbo.IV00300.LOTNUMBR),
Cast(dbo.PK010033.QTY_ALLOWED_I AS INT),
Cast(dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT)
HAVING ( dbo.PK010033.MANUFACTUREORDERST_I = 3 )
AND ( TRIM(dbo.PK010033.LOCNCODE) = 'EF-R' )
AND ( Cast(dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT) > 0 )
AND ( Sum(Cast(dbo.IV00300.QTYRECVD - dbo.IV00300.QTYSOLD AS INT)) > 0 )
AND ( CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 101) >= Getdate() ))
SELECT c1.*
FROM cte1 c1
JOIN (SELECT [MO No],
[Item No],
Max(ExpireDate) AS ExpireDate
FROM cte1
WHERE AvailBinQty >= PickQty
GROUP BY [MO No],
[Item No]) c2
ON c1.[MO No] = c2.[MO No]
AND c1.[Item No] = c2.[Item No]
WHERE c1.ExpireDate >= c2.ExpireDate
ORDER BY c1.[MO No],
c1.[Item No],
c1.[Expire No]
ASKER
Hello Sharath. Thank you so much for your assistance.
This is very close to what I am looking for. We need to use all of the material before it expires so if there is not enough quantity on line 1 then I need to show line 1 and 2. If there is not enough available quantity on line 1 and line 2 then I need to show line 1, 2, and 3 and so on until there is enough to available bin quantity to cover the pick qty.
I hope this makes sense.
btw, I learned a lot from the way that you coded this so far.
Mike
This is very close to what I am looking for. We need to use all of the material before it expires so if there is not enough quantity on line 1 then I need to show line 1 and 2. If there is not enough available quantity on line 1 and line 2 then I need to show line 1, 2, and 3 and so on until there is enough to available bin quantity to cover the pick qty.
I hope this makes sense.
btw, I learned a lot from the way that you coded this so far.
Mike
Can you post the sample data where the suggested query is missing the expected result.
ASKER
Sharath
I have filtered for Manufacture Order "100047" and limited the columns for ease of explanation.
These are the results with your code.
You can see in the FULL results set for ItemNo "10.084B," the Pick Quantity is 1000 units. The first line only has 15 AvailableBinQty, which is not enough to fill the order. So we should keep/show this 1st line and then go the the 2nd line. We see here that there is enough to fill the PickQty so we should include this line as well, but none of the following lines for this ItemNo.
ItemNo "10.115A " is a similar situation except there is not enough AvailableBinQty until we get to the 3rd line, so all 3 lines should show.
Item No "10.121B" has enough AvailableBinQty to fill the PickQty on the 1st line so no following rows should show for this ItemNo.
I have filtered for Manufacture Order "100047" and limited the columns for ease of explanation.
These are the results with your code.
MO No Item No PickQty AvailBinQty ExpireDate Expire No
100047 10.084B 1000 1001 06/30/2022 220630
100047 10.115A 500 1000 03/25/2023 230325
100047 10.121B 3 1000 05/28/2023 230528
100047 10.264A 1 1000 04/09/2023 230409
100047 30.005 1 1000 06/17/2023 230617
100047 30.006 1 1000 05/31/2023 230531
100047 30.014 1 1000 06/01/2023 230601
100047 30.1167 1 44 07/31/2021 210731
100047 30.122 2 1000 06/20/2023 230620
100047 30.137 1 1000 06/19/2023 230619
100047 30.708 1 1000 06/15/2023 230615
100047 30.714 1 1000 06/21/2023 230621
100047 30.729 1 1000 04/03/2023 230403
100047 50.096 20 1000 04/05/2023 230405
100047 65.004 34 1000 06/16/2023 230616
You can see in the FULL results set for ItemNo "10.084B," the Pick Quantity is 1000 units. The first line only has 15 AvailableBinQty, which is not enough to fill the order. So we should keep/show this 1st line and then go the the 2nd line. We see here that there is enough to fill the PickQty so we should include this line as well, but none of the following lines for this ItemNo.
ItemNo "10.115A " is a similar situation except there is not enough AvailableBinQty until we get to the 3rd line, so all 3 lines should show.
Item No "10.121B" has enough AvailableBinQty to fill the PickQty on the 1st line so no following rows should show for this ItemNo.
MO No Item No PickQty AvailBinQty ExpireDate Expire No
100047 10.084B 1000 15 02/27/2022 220227
100047 10.084B 1000 1001 06/30/2022 220630
100047 10.084B 1000 1000 03/23/2023 230323
100047 10.115A 500 3 02/27/2022 220227
100047 10.115A 500 14 02/27/2022 220227
100047 10.115A 500 1000 03/25/2023 230325
100047 10.121B 3 11 02/27/2022 220227
100047 10.121B 3 14 02/27/2022 220227
100047 10.121B 3 1000 03/26/2023 230326
100047 10.121B 3 1000 04/10/2023 230410
100047 10.121B 3 1000 04/26/2023 230426
100047 10.121B 3 1000 05/12/2023 230512
100047 10.121B 3 1000 05/28/2023 230528
100047 10.264A 1 1 02/27/2022 220227
100047 10.264A 1 15 02/27/2022 220227
100047 10.264A 1 1000 04/09/2023 230409
100047 30.005 1 27 02/27/2022 220227
100047 30.005 1 15 02/27/2022 220227
100047 30.005 1 1000 01/05/2023 230105
100047 30.005 1 1000 01/30/2023 230130
100047 30.005 1 1000 02/20/2023 230220
100047 30.005 1 1000 03/09/2023 230309
100047 30.005 1 1000 03/27/2023 230327
100047 30.005 1 1000 04/12/2023 230412
100047 30.005 1 1000 04/27/2023 230427
100047 30.005 1 1000 05/14/2023 230514
100047 30.005 1 1000 05/30/2023 230530
100047 30.005 1 1000 06/17/2023 230617
100047 30.006 1 25 02/27/2022 220227
100047 30.006 1 15 02/27/2022 220227
100047 30.006 1 1000 01/08/2023 230108
100047 30.006 1 1000 01/31/2023 230131
100047 30.006 1 1000 02/21/2023 230221
100047 30.006 1 1000 03/10/2023 230310
100047 30.006 1 1000 03/28/2023 230328
100047 30.006 1 1000 04/13/2023 230413
100047 30.006 1 1000 04/28/2023 230428
100047 30.006 1 1000 05/15/2023 230515
100047 30.006 1 1000 05/31/2023 230531
100047 30.014 1 26 02/27/2022 220227
100047 30.014 1 14 02/27/2022 220227
100047 30.014 1 999 01/11/2023 230111
100047 30.014 1 1000 02/01/2023 230201
100047 30.014 1 1000 02/22/2023 230222
100047 30.014 1 1000 03/11/2023 230311
100047 30.014 1 1000 03/29/2023 230329
100047 30.014 1 1000 04/14/2023 230414
100047 30.014 1 1000 04/29/2023 230429
100047 30.014 1 1000 05/16/2023 230516
100047 30.014 1 1000 06/01/2023 230601
100047 30.1167 1 44 07/31/2021 210731
100047 30.1167 1 25 02/27/2022 220227
100047 30.1167 1 15 02/27/2022 220227
100047 30.1167 1 115 04/30/2022 220430
100047 30.1167 1 997 01/13/2023 230113
100047 30.1167 1 1000 02/03/2023 230203
100047 30.1167 1 1000 02/24/2023 230224
100047 30.1167 1 1000 03/12/2023 230312
100047 30.1167 1 1000 03/30/2023 230330
100047 30.1167 1 1000 04/15/2023 230415
100047 30.1167 1 1000 04/30/2023 230430
100047 30.1167 1 1000 05/17/2023 230517
100047 30.1167 1 1000 06/02/2023 230602
100047 30.122 2 8 02/27/2022 220227
100047 30.122 2 14 02/27/2022 220227
100047 30.122 2 1000 02/05/2023 230205
100047 30.122 2 1000 03/31/2023 230331
100047 30.122 2 1000 06/20/2023 230620
100047 30.137 1 13 02/27/2022 220227
100047 30.137 1 15 02/27/2022 220227
100047 30.137 1 1000 01/26/2023 230126
100047 30.137 1 1000 02/06/2023 230206
100047 30.137 1 1000 03/13/2023 230313
100047 30.137 1 1000 04/07/2023 230407
100047 30.137 1 1000 06/19/2023 230619
100047 30.708 1 27 02/27/2022 220227
100047 30.708 1 15 02/27/2022 220227
100047 30.708 1 1000 01/15/2023 230115
100047 30.708 1 1000 02/08/2023 230208
100047 30.708 1 1000 02/26/2023 230226
100047 30.708 1 1000 03/14/2023 230314
100047 30.708 1 52 03/31/2023 230331
100047 30.708 1 348 03/31/2023 230331
100047 30.708 1 1000 04/01/2023 230401
100047 30.708 1 1000 04/17/2023 230417
100047 30.708 1 134 04/30/2023 230430
100047 30.708 1 1000 05/02/2023 230502
100047 30.708 1 1000 05/19/2023 230519
100047 30.708 1 1000 06/04/2023 230604
100047 30.708 1 1000 06/15/2023 230615
100047 30.714 1 13 02/27/2022 220227
100047 30.714 1 15 02/27/2022 220227
100047 30.714 1 1000 03/15/2023 230315
100047 30.714 1 1000 04/02/2023 230402
100047 30.714 1 1000 04/18/2023 230418
100047 30.714 1 1000 05/03/2023 230503
100047 30.714 1 1000 06/21/2023 230621
100047 30.729 1 11 02/27/2022 220227
100047 30.729 1 15 02/27/2022 220227
100047 30.729 1 1000 01/18/2023 230118
100047 30.729 1 1000 02/11/2023 230211
100047 30.729 1 1000 03/01/2023 230301
100047 30.729 1 1000 04/03/2023 230403
100047 50.096 20 11 02/27/2022 220227
100047 50.096 20 15 02/27/2022 220227
100047 50.096 20 1000 01/23/2023 230123
100047 50.096 20 1000 02/18/2023 230218
100047 50.096 20 1000 03/06/2023 230306
100047 50.096 20 1000 04/05/2023 230405
100047 65.004 34 20 02/27/2022 220227
100047 65.004 34 15 02/27/2022 220227
100047 65.004 34 1000 01/24/2023 230124
100047 65.004 34 1000 03/21/2023 230321
100047 65.004 34 1000 04/06/2023 230406
100047 65.004 34 1000 04/24/2023 230424
100047 65.004 34 1000 05/11/2023 230511
100047 65.004 34 1000 05/27/2023 230527
100047 65.004 34 1000 06/10/2023 230610
100047 65.004 34 1000 06/16/2023 230616
ASKER
Matt, here is the code more simplified as you requested.
SELECT dbo.pk010033.manufactureorder_i AS [MO No],
dbo.pk010033.itemnmbr AS [Item No]
,
Cast(dbo.pk010033.qty_allowed_i AS INT) AS
PickQty,
Sum(Cast(dbo.iv00300.qtyrecvd - dbo.iv00300.qtysold AS INT)) AS
AvailBinQty,
dbo.iv00300.expndate AS
ExpireDate,
CONVERT(VARCHAR, dbo.iv00300.expndate, 12) AS
[Expire No]
FROM dbo.iv00101
RIGHT OUTER JOIN dbo.pk010033
ON dbo.iv00101.itemnmbr = dbo.pk010033.itemnmbr
LEFT OUTER JOIN dbo.iv00112
INNER JOIN dbo.iv00300
ON dbo.iv00112.itemnmbr = dbo.iv00300.itemnmbr
AND dbo.iv00112.bin = dbo.iv00300.bin
ON dbo.pk010033.itemnmbr = dbo.iv00300.itemnmbr
AND dbo.pk010033.locncode = dbo.iv00300.locncode
GROUP BY dbo.pk010033.manufactureorder_i,
dbo.pk010033.itemnmbr,
dbo.pk010033.manufactureorderst_i,
Cast(dbo.pk010033.qty_allowed_i AS INT),
Cast(dbo.iv00300.qtyrecvd - dbo.iv00300.qtysold AS INT),
dbo.iv00300.expndate,
dbo.iv00300.expndate,
Trim(dbo.pk010033.locncode)
HAVING Cast(dbo.iv00300.qtyrecvd - dbo.iv00300.qtysold AS INT) > 0
AND Trim(dbo.pk010033.locncode) = 'EF-R'
AND dbo.pk010033.manufactureorderst_i = 3
AND CONVERT(VARCHAR, dbo.iv00300.expndate, 101) >= Getdate()
AND Trim(dbo.pk010033.manufactureorder_i) = '100047'
MO No Item No PickQty AvailBinQty ExpireDate Expire No
100047 10.005Q 40 14 2022-02-27 00:00:00.000 220227
100047 10.005Q 40 960 2023-04-08 00:00:00.000 230408
100047 10.084B 1000 1 2022-02-27 00:00:00.000 220227
100047 10.084B 1000 14 2022-02-27 00:00:00.000 220227
100047 10.084B 1000 1000 2023-03-23 00:00:00.000 230323
100047 10.084B 1000 1001 2022-06-30 00:00:00.000 220630
100047 10.093 1 1 2022-02-27 00:00:00.000 220227
100047 10.093 1 15 2022-02-27 00:00:00.000 220227
100047 10.093 1 999 2023-03-24 00:00:00.000 230324
100047 10.115A 500 3 2022-02-27 00:00:00.000 220227
100047 10.115A 500 14 2022-02-27 00:00:00.000 220227
100047 10.115A 500 1000 2023-03-25 00:00:00.000 230325
100047 10.121B 3 11 2022-02-27 00:00:00.000 220227
100047 10.121B 3 14 2022-02-27 00:00:00.000 220227
100047 10.121B 3 1000 2023-03-26 00:00:00.000 230326
100047 10.121B 3 1000 2023-04-10 00:00:00.000 230410
100047 10.121B 3 1000 2023-04-26 00:00:00.000 230426
100047 10.121B 3 1000 2023-05-12 00:00:00.000 230512
100047 10.121B 3 1000 2023-05-28 00:00:00.000 230528
100047 10.264A 1 1 2022-02-27 00:00:00.000 220227
100047 10.264A 1 15 2022-02-27 00:00:00.000 220227
100047 10.264A 1 1000 2023-04-09 00:00:00.000 230409
100047 30.005 1 15 2022-02-27 00:00:00.000 220227
100047 30.005 1 27 2022-02-27 00:00:00.000 220227
100047 30.005 1 1000 2023-01-05 00:00:00.000 230105
100047 30.005 1 1000 2023-01-30 00:00:00.000 230130
100047 30.005 1 1000 2023-02-20 00:00:00.000 230220
100047 30.005 1 1000 2023-03-09 00:00:00.000 230309
100047 30.005 1 1000 2023-03-27 00:00:00.000 230327
100047 30.005 1 1000 2023-04-12 00:00:00.000 230412
100047 30.005 1 1000 2023-04-27 00:00:00.000 230427
100047 30.005 1 1000 2023-05-14 00:00:00.000 230514
100047 30.005 1 1000 2023-05-30 00:00:00.000 230530
100047 30.005 1 1000 2023-06-17 00:00:00.000 230617
100047 30.006 1 15 2022-02-27 00:00:00.000 220227
100047 30.006 1 25 2022-02-27 00:00:00.000 220227
100047 30.006 1 1000 2023-01-08 00:00:00.000 230108
100047 30.006 1 1000 2023-01-31 00:00:00.000 230131
100047 30.006 1 1000 2023-02-21 00:00:00.000 230221
100047 30.006 1 1000 2023-03-10 00:00:00.000 230310
100047 30.006 1 1000 2023-03-28 00:00:00.000 230328
100047 30.006 1 1000 2023-04-13 00:00:00.000 230413
100047 30.006 1 1000 2023-04-28 00:00:00.000 230428
100047 30.006 1 1000 2023-05-15 00:00:00.000 230515
100047 30.006 1 1000 2023-05-31 00:00:00.000 230531
100047 30.014 1 14 2022-02-27 00:00:00.000 220227
100047 30.014 1 26 2022-02-27 00:00:00.000 220227
100047 30.014 1 999 2023-01-11 00:00:00.000 230111
100047 30.014 1 1000 2023-02-01 00:00:00.000 230201
100047 30.014 1 1000 2023-02-22 00:00:00.000 230222
100047 30.014 1 1000 2023-03-11 00:00:00.000 230311
100047 30.014 1 1000 2023-03-29 00:00:00.000 230329
100047 30.014 1 1000 2023-04-14 00:00:00.000 230414
100047 30.014 1 1000 2023-04-29 00:00:00.000 230429
100047 30.014 1 1000 2023-05-16 00:00:00.000 230516
100047 30.014 1 1000 2023-06-01 00:00:00.000 230601
100047 30.1167 1 1 2022-04-30 00:00:00.000 220430
100047 30.1167 1 15 2022-02-27 00:00:00.000 220227
100047 30.1167 1 25 2022-02-27 00:00:00.000 220227
100047 30.1167 1 44 2021-07-31 00:00:00.000 210731
100047 30.1167 1 114 2022-04-30 00:00:00.000 220430
100047 30.1167 1 997 2023-01-13 00:00:00.000 230113
100047 30.1167 1 1000 2023-02-03 00:00:00.000 230203
100047 30.1167 1 1000 2023-02-24 00:00:00.000 230224
100047 30.1167 1 1000 2023-03-12 00:00:00.000 230312
100047 30.1167 1 1000 2023-03-30 00:00:00.000 230330
100047 30.1167 1 1000 2023-04-15 00:00:00.000 230415
100047 30.1167 1 1000 2023-04-30 00:00:00.000 230430
100047 30.1167 1 1000 2023-05-17 00:00:00.000 230517
100047 30.1167 1 1000 2023-06-02 00:00:00.000 230602
100047 30.122 2 8 2022-02-27 00:00:00.000 220227
100047 30.122 2 14 2022-02-27 00:00:00.000 220227
100047 30.122 2 1000 2023-02-05 00:00:00.000 230205
100047 30.122 2 1000 2023-03-31 00:00:00.000 230331
100047 30.122 2 1000 2023-06-20 00:00:00.000 230620
100047 30.137 1 13 2022-02-27 00:00:00.000 220227
100047 30.137 1 15 2022-02-27 00:00:00.000 220227
100047 30.137 1 1000 2023-01-26 00:00:00.000 230126
100047 30.137 1 1000 2023-02-06 00:00:00.000 230206
100047 30.137 1 1000 2023-03-13 00:00:00.000 230313
100047 30.137 1 1000 2023-04-07 00:00:00.000 230407
100047 30.137 1 1000 2023-06-19 00:00:00.000 230619
100047 30.708 1 2 2023-04-30 00:00:00.000 230430
100047 30.708 1 4 2023-03-31 00:00:00.000 230331
100047 30.708 1 15 2022-02-27 00:00:00.000 220227
100047 30.708 1 48 2023-03-31 00:00:00.000 230331
100047 30.708 1 27 2022-02-27 00:00:00.000 220227
100047 30.708 1 132 2023-04-30 00:00:00.000 230430
100047 30.708 1 348 2023-03-31 00:00:00.000 230331
100047 30.708 1 1000 2023-01-15 00:00:00.000 230115
100047 30.708 1 1000 2023-02-08 00:00:00.000 230208
100047 30.708 1 1000 2023-02-26 00:00:00.000 230226
100047 30.708 1 1000 2023-03-14 00:00:00.000 230314
100047 30.708 1 1000 2023-04-01 00:00:00.000 230401
100047 30.708 1 1000 2023-04-17 00:00:00.000 230417
100047 30.708 1 1000 2023-05-02 00:00:00.000 230502
100047 30.708 1 1000 2023-05-19 00:00:00.000 230519
100047 30.708 1 1000 2023-06-04 00:00:00.000 230604
100047 30.708 1 1000 2023-06-15 00:00:00.000 230615
100047 30.714 1 13 2022-02-27 00:00:00.000 220227
100047 30.714 1 15 2022-02-27 00:00:00.000 220227
100047 30.714 1 1000 2023-03-15 00:00:00.000 230315
100047 30.714 1 1000 2023-04-02 00:00:00.000 230402
100047 30.714 1 1000 2023-04-18 00:00:00.000 230418
100047 30.714 1 1000 2023-05-03 00:00:00.000 230503
100047 30.714 1 1000 2023-06-21 00:00:00.000 230621
100047 30.729 1 11 2022-02-27 00:00:00.000 220227
100047 30.729 1 15 2022-02-27 00:00:00.000 220227
100047 30.729 1 1000 2023-01-18 00:00:00.000 230118
100047 30.729 1 1000 2023-02-11 00:00:00.000 230211
100047 30.729 1 1000 2023-03-01 00:00:00.000 230301
100047 30.729 1 1000 2023-04-03 00:00:00.000 230403
100047 50.096 20 11 2022-02-27 00:00:00.000 220227
100047 50.096 20 15 2022-02-27 00:00:00.000 220227
100047 50.096 20 1000 2023-01-23 00:00:00.000 230123
100047 50.096 20 1000 2023-02-18 00:00:00.000 230218
100047 50.096 20 1000 2023-03-06 00:00:00.000 230306
100047 50.096 20 1000 2023-04-05 00:00:00.000 230405
100047 65.004 34 15 2022-02-27 00:00:00.000 220227
100047 65.004 34 20 2022-02-27 00:00:00.000 220227
100047 65.004 34 1000 2023-01-24 00:00:00.000 230124
100047 65.004 34 1000 2023-03-21 00:00:00.000 230321
100047 65.004 34 1000 2023-04-06 00:00:00.000 230406
100047 65.004 34 1000 2023-04-24 00:00:00.000 230424
100047 65.004 34 1000 2023-05-11 00:00:00.000 230511
100047 65.004 34 1000 2023-05-27 00:00:00.000 230527
100047 65.004 34 1000 2023-06-10 00:00:00.000 230610
100047 65.004 34 1000 2023-06-16 00:00:00.000 230616
In the initial post, the order of the records is based on ExpireDate DESC. In the last post, the order is on ExpireDate ASC.
Could you confirm what is the order of the records?
Matt already asked this question. Please clarify.
<< When talking about first and second rows you are implying an ordering. From what I can see it looks like the relevant order is ExpireNo descending - is this right?>>
Could you confirm what is the order of the records?
Matt already asked this question. Please clarify.
<< When talking about first and second rows you are implying an ordering. From what I can see it looks like the relevant order is ExpireNo descending - is this right?>>
ASKER
Ascending is correct, I am sorry for the confusion. We want to consume the items that expire first. That was a mistake on the first query, sorry for the confusion.
In that case, try this.
;WITH cte1
AS (SELECT TRIM(dbo.PK010033.MANUFACTUREORDER_I) AS [MO No],
TRIM(dbo.PK010033.ITEMNMBR) AS [Item No],
TRIM(dbo.IV00101.ITEMDESC) AS [Desc],
CONVERT(VARCHAR, dbo.PK010033.REQDATE, 101) AS Required,
Cast(dbo.PK010033.QTY_ALLOWED_I AS INT) AS PickQty,
Sum(Cast(dbo.PK010033.QTY_ISSUED_I AS INT)) AS Issued,
Cast(dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT) AS [Remaining Qty],
TRIM(dbo.IV00300.LOTNUMBR) AS [Lot Number],
TRIM(dbo.IV00300.BIN) AS BIN,
Sum(Cast(dbo.IV00300.QTYRECVD - dbo.IV00300.QTYSOLD AS INT)) AS AvailBinQty,
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 101) AS ExpireDate,
TRIM(dbo.PK010033.UOFM) AS PK_UoM,
TRIM(dbo.PK010033.LOCNCODE) AS Site,
TRIM(dbo.PK010033.RTSEQNUM_I) AS ROUTE_SEQ,
dbo.PK010033.BOMUSERDEF1_I AS [Offset Require Date],
dbo.PK010033.BOMUSERDEF2_I AS [Special Instructions],
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 12) AS [Expire No]
FROM dbo.IV00101
RIGHT OUTER JOIN dbo.PK010033
ON dbo.IV00101.ITEMNMBR = dbo.PK010033.ITEMNMBR
LEFT OUTER JOIN dbo.IV00112
INNER JOIN dbo.IV00300
ON dbo.IV00112.ITEMNMBR = dbo.IV00300.ITEMNMBR
AND dbo.IV00112.BIN = dbo.IV00300.BIN
ON dbo.PK010033.ITEMNMBR = dbo.IV00300.ITEMNMBR
AND dbo.PK010033.LOCNCODE = dbo.IV00300.LOCNCODE
GROUP BY TRIM(dbo.PK010033.MANUFACTUREORDER_I),
TRIM(dbo.PK010033.ITEMNMBR),
TRIM(dbo.PK010033.UOFM),
TRIM(dbo.PK010033.RTSEQNUM_I),
TRIM(dbo.PK010033.LOCNCODE),
CONVERT(VARCHAR, dbo.PK010033.REQDATE, 101),
dbo.PK010033.BOMUSERDEF1_I,
dbo.PK010033.BOMUSERDEF2_I,
dbo.PK010033.MANUFACTUREORDERST_I,
TRIM(dbo.IV00101.ITEMDESC),
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 12),
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 101),
TRIM(dbo.IV00300.BIN),
TRIM(dbo.IV00300.LOTNUMBR),
Cast(dbo.PK010033.QTY_ALLOWED_I AS INT),
Cast(dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT)
HAVING ( dbo.PK010033.MANUFACTUREORDERST_I = 3 )
AND ( TRIM(dbo.PK010033.LOCNCODE) = 'EF-R' )
AND ( Cast(dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT) > 0 )
AND ( Sum(Cast(dbo.IV00300.QTYRECVD - dbo.IV00300.QTYSOLD AS INT)) > 0 )
AND ( CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 101) >= Getdate() ))
SELECT c1.*
FROM cte1 c1
JOIN (SELECT [MO No],
[Item No],
Max(ExpireDate) AS ExpireDate
FROM cte1
WHERE AvailBinQty >= PickQty
GROUP BY [MO No],
[Item No]) c2
ON c1.[MO No] = c2.[MO No]
AND c1.[Item No] = c2.[Item No]
WHERE c1.ExpireDate <= c2.ExpireDate
ORDER BY c1.[MO No],
c1.[Item No],
c1.[Expire No]
ASKER
Thank you so much for your help Sharath. This is showing all 466 rows as if no filtering
MO No Item No Desc Required PickQty Issued Remaining Qty Lot Number BIN AvailBinQty ExpireDate PK_UoM Site ROUTE_SEQ Offset Require Date Special Instructions Expire No
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 2101.1041 BUF.R1S1 27 02/27/2022 50/BAG EF-R 10 220227
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 2101.1041 BUF.R2S2 15 02/27/2022 50/BAG EF-R 10 220227
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1237 PRTEST 1000 01/05/2023 50/BAG EF-R 10 230105
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1300 PRTEST 1000 01/30/2023 50/BAG EF-R 10 230130
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1363 PRTEST 1000 02/20/2023 50/BAG EF-R 10 230220
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1414 PRTEST 1000 03/09/2023 50/BAG EF-R 10 230309
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1468 PRTEST 1000 03/27/2023 50/BAG EF-R 10 230327
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1516 PRTEST 1000 04/12/2023 50/BAG EF-R 10 230412
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1561 PRTEST 1000 04/27/2023 50/BAG EF-R 10 230427
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1612 PRTEST 1000 05/14/2023 50/BAG EF-R 10 230514
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1660 PRTEST 1000 05/30/2023 50/BAG EF-R 10 230530
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1714 PRTEST 1000 06/17/2023 50/BAG EF-R 10 230617
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 2101.1043 BUF.R1S1 25 02/27/2022 25/BAG EF-R 10 220227
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 2101.1043 BUF.R2S2 15 02/27/2022 25/BAG EF-R 10 220227
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1240 PRTEST 1000 01/08/2023 25/BAG EF-R 10 230108
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1303 PRTEST 1000 01/31/2023 25/BAG EF-R 10 230131
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1366 PRTEST 1000 02/21/2023 25/BAG EF-R 10 230221
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1417 PRTEST 1000 03/10/2023 25/BAG EF-R 10 230310
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1471 PRTEST 1000 03/28/2023 25/BAG EF-R 10 230328
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1519 PRTEST 1000 04/13/2023 25/BAG EF-R 10 230413
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1564 PRTEST 1000 04/28/2023 25/BAG EF-R 10 230428
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1615 PRTEST 1000 05/15/2023 25/BAG EF-R 10 230515
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1663 PRTEST 1000 05/31/2023 25/BAG EF-R 10 230531
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 1907-084 16-03 96 07/31/2021 EACH EF-R 10 210731
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 2101.1057 BUF.R1S1 20 02/27/2022 EACH EF-R 10 220227
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 2101.1057 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 LOT#1252 PRTEST 1000 01/14/2023 EACH EF-R 10 230114
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 LOT#1315 PRTEST 1000 02/04/2023 EACH EF-R 10 230204
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 LOT#1378 PRTEST 1000 02/25/2023 EACH EF-R 10 230225
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 LOT#1528 PRTEST 1000 04/16/2023 EACH EF-R 10 230416
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 LOT#1573 PRTEST 1000 05/01/2023 EACH EF-R 10 230501
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 LOT#1624 PRTEST 1000 05/18/2023 EACH EF-R 10 230518
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 LOT#1672 PRTEST 1000 06/03/2023 EACH EF-R 10 230603
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 TEST03 VLM 3 02/24/2024 EACH EF-R 10 240224
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 TEST03 VLM 1 02/04/2026 EACH EF-R 10 260204
100044 30.122 Sterile Square Media Bottle (PETG), 1000mL 05/17/2021 2 0 2 2101.1059 BUF.R1S1 8 02/27/2022 12/PK EF-R 10 220227
100044 30.122 Sterile Square Media Bottle (PETG), 1000mL 05/17/2021 2 0 2 2101.1059 BUF.R2S2 14 02/27/2022 12/PK EF-R 10 220227
100044 30.122 Sterile Square Media Bottle (PETG), 1000mL 05/17/2021 2 0 2 LOT#1318 PRTEST 1000 02/05/2023 12/PK EF-R 10 230205
100044 30.122 Sterile Square Media Bottle (PETG), 1000mL 05/17/2021 2 0 2 LOT#1480 PRTEST 1000 03/31/2023 12/PK EF-R 10 230331
100044 30.122 Sterile Square Media Bottle (PETG), 1000mL 05/17/2021 2 0 2 LOT#1723 PRTEST 1000 06/20/2023 12/PK EF-R 10 230620
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 2101.1061 BUF.R1S1 13 02/27/2022 24/PK EF-R 10 220227
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 2101.1061 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 LOT#1288 PRTEST 1000 01/26/2023 24/PK EF-R 10 230126
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 LOT#1321 PRTEST 1000 02/06/2023 24/PK EF-R 10 230206
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 LOT#1426 PRTEST 1000 03/13/2023 24/PK EF-R 10 230313
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 LOT#1501 PRTEST 1000 04/07/2023 24/PK EF-R 10 230407
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 LOT#1720 PRTEST 1000 06/19/2023 24/PK EF-R 10 230619
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 2101.1073 BUF.R1S1 24 02/27/2022 24/PK EF-R 10 220227
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 2101.1073 BUF.R2S2 30 02/27/2022 24/PK EF-R 10 220227
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 LOT#1261 PRTEST 2000 01/17/2023 24/PK EF-R 10 230117
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 LOT#1333 PRTEST 2000 02/10/2023 24/PK EF-R 10 230210
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 LOT#1351 PRTEST 2000 02/16/2023 24/PK EF-R 10 230216
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 LOT#1387 PRTEST 2000 02/28/2023 24/PK EF-R 10 230228
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 TEST03 VLM 2 02/24/2024 24/PK EF-R 10 240224
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 2008-026 POG 44 04/26/2025 24/PK EF-R 10 250426
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 TEST03 VLM 2 02/04/2026 24/PK EF-R 10 260204
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 2101.1075 BUF.R1S1 11 02/27/2022 24/PK EF-R 10 220227
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 2101.1075 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 LOT#1264 PRTEST 1000 01/18/2023 24/PK EF-R 10 230118
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 LOT#1336 PRTEST 1000 02/11/2023 24/PK EF-R 10 230211
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 LOT#1390 PRTEST 1000 03/01/2023 24/PK EF-R 10 230301
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 LOT#1489 PRTEST 1000 04/03/2023 24/PK EF-R 10 230403
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 2101.1083 BUF.R1S1 6 02/27/2022 EACH EF-R 10 220227
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 2101.1083 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 LOT#1267 PRTEST 1000 01/19/2023 EACH EF-R 10 230119
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 LOT#1339 PRTEST 1000 02/12/2023 EACH EF-R 10 230212
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 2008-109 POG 266 08/31/2023 EACH EF-R 10 230831
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 2008-110 POG 398 08/31/2023 EACH EF-R 10 230831
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 2101.1091 BUF.R1S1 15 02/27/2022 500ML EF-R 10 220227
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 2101.1091 BUF.R2S2 15 02/27/2022 500ML EF-R 10 220227
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 LOT#1270 PRTEST 1000 01/20/2023 500ML EF-R 10 230120
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 LOT#1342 PRTEST 1000 02/13/2023 500ML EF-R 10 230213
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 LOT#1396 PRTEST 1000 03/03/2023 500ML EF-R 10 230303
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 LOT#1435 PRTEST 1000 03/16/2023 500ML EF-R 10 230316
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 LOT#1588 PRTEST 1000 05/06/2023 500ML EF-R 10 230506
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 2101.1093 BUF.R1S1 23 02/27/2022 500ML EF-R 10 220227
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 2101.1093 BUF.R2S2 15 02/27/2022 500ML EF-R 10 220227
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1273 PRTEST 1000 01/21/2023 500ML EF-R 10 230121
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1345 PRTEST 1000 02/14/2023 500ML EF-R 10 230214
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1399 PRTEST 1000 03/04/2023 500ML EF-R 10 230304
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1438 PRTEST 1000 03/17/2023 500ML EF-R 10 230317
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1540 PRTEST 1000 04/20/2023 500ML EF-R 10 230420
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1591 PRTEST 1000 05/07/2023 500ML EF-R 10 230507
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1639 PRTEST 1000 05/23/2023 500ML EF-R 10 230523
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1681 PRTEST 1000 06/06/2023 500ML EF-R 10 230606
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 2101.1095 BUF.R1S1 23 02/27/2022 500ML EF-R 10 220227
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 2101.1095 BUF.R2S2 15 02/27/2022 500ML EF-R 10 220227
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1276 PRTEST 1000 01/22/2023 500ML EF-R 10 230122
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1348 PRTEST 1000 02/15/2023 500ML EF-R 10 230215
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1402 PRTEST 1000 03/05/2023 500ML EF-R 10 230305
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1441 PRTEST 1000 03/18/2023 500ML EF-R 10 230318
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1543 PRTEST 1000 04/21/2023 500ML EF-R 10 230421
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1594 PRTEST 1000 05/08/2023 500ML EF-R 10 230508
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1642 PRTEST 1000 05/24/2023 500ML EF-R 10 230524
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1684 PRTEST 1000 06/07/2023 500ML EF-R 10 230607
100047 10.084B 0.5N NaOH, Sterile (1L) 06/08/2021 1000 0 1000 2101.1009 BUF.R2S2 15 02/27/2022 1L BTL EF-R 10 220227
100047 10.084B 0.5N NaOH, Sterile (1L) 06/08/2021 1000 0 1000 2101.4567 BUF.R1S1 1001 06/30/2022 1L BTL EF-R 10 220630
100047 10.084B 0.5N NaOH, Sterile (1L) 06/08/2021 1000 0 1000 LOT#1456 PRTEST 1000 03/23/2023 1L BTL EF-R 10 230323
100047 10.115A Sucrose Crystal NF, 500g 06/08/2021 500 0 500 2101.1013 BUF.R1S1 3 02/27/2022 500G EF-R 10 220227
100047 10.115A Sucrose Crystal NF, 500g 06/08/2021 500 0 500 2101.1013 BUF.R2S2 14 02/27/2022 500G EF-R 10 220227
100047 10.115A Sucrose Crystal NF, 500g 06/08/2021 500 0 500 LOT#1462 PRTEST 1000 03/25/2023 500G EF-R 10 230325
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 2101.1015 BUF.R1S1 11 02/27/2022 1L BTL EF-R 10 220227
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 2101.1015 BUF.R2S2 14 02/27/2022 1L BTL EF-R 10 220227
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 LOT#1465 PRTEST 1000 03/26/2023 1L BTL EF-R 10 230326
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 LOT#1510 PRTEST 1000 04/10/2023 1L BTL EF-R 10 230410
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 LOT#1558 PRTEST 1000 04/26/2023 1L BTL EF-R 10 230426
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 LOT#1606 PRTEST 1000 05/12/2023 1L BTL EF-R 10 230512
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 LOT#1654 PRTEST 1000 05/28/2023 1L BTL EF-R 10 230528
100047 10.264A Sodium Phosphate, Dibasic, Heptahydrate, USP (500G) 06/08/2021 1 0 1 2101.1021 BUF.R1S1 1 02/27/2022 500G EF-R 10 220227
100047 10.264A Sodium Phosphate, Dibasic, Heptahydrate, USP (500G) 06/08/2021 1 0 1 2101.1021 BUF.R2S2 15 02/27/2022 500G EF-R 10 220227
100047 10.264A Sodium Phosphate, Dibasic, Heptahydrate, USP (500G) 06/08/2021 1 0 1 LOT#1507 PRTEST 1000 04/09/2023 500G EF-R 10 230409
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 2101.1041 BUF.R1S1 27 02/27/2022 50/BAG EF-R 10 220227
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 2101.1041 BUF.R2S2 15 02/27/2022 50/BAG EF-R 10 220227
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1237 PRTEST 1000 01/05/2023 50/BAG EF-R 10 230105
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1300 PRTEST 1000 01/30/2023 50/BAG EF-R 10 230130
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1363 PRTEST 1000 02/20/2023 50/BAG EF-R 10 230220
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1414 PRTEST 1000 03/09/2023 50/BAG EF-R 10 230309
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1468 PRTEST 1000 03/27/2023 50/BAG EF-R 10 230327
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1516 PRTEST 1000 04/12/2023 50/BAG EF-R 10 230412
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1561 PRTEST 1000 04/27/2023 50/BAG EF-R 10 230427
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1612 PRTEST 1000 05/14/2023 50/BAG EF-R 10 230514
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1660 PRTEST 1000 05/30/2023 50/BAG EF-R 10 230530
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1714 PRTEST 1000 06/17/2023 50/BAG EF-R 10 230617
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 2101.1043 BUF.R1S1 25 02/27/2022 25/BAG EF-R 10 220227
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 2101.1043 BUF.R2S2 15 02/27/2022 25/BAG EF-R 10 220227
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1240 PRTEST 1000 01/08/2023 25/BAG EF-R 10 230108
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1303 PRTEST 1000 01/31/2023 25/BAG EF-R 10 230131
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1366 PRTEST 1000 02/21/2023 25/BAG EF-R 10 230221
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1417 PRTEST 1000 03/10/2023 25/BAG EF-R 10 230310
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1471 PRTEST 1000 03/28/2023 25/BAG EF-R 10 230328
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1519 PRTEST 1000 04/13/2023 25/BAG EF-R 10 230413
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1564 PRTEST 1000 04/28/2023 25/BAG EF-R 10 230428
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1615 PRTEST 1000 05/15/2023 25/BAG EF-R 10 230515
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1663 PRTEST 1000 05/31/2023 25/BAG EF-R 10 230531
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 2101.1045 BUF.R1S1 26 02/27/2022 25/PK EF-R 10 220227
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 2101.1045 BUF.R2S2 14 02/27/2022 25/PK EF-R 10 220227
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1243 PRTEST 999 01/11/2023 25/PK EF-R 10 230111
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1306 PRTEST 1000 02/01/2023 25/PK EF-R 10 230201
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1369 PRTEST 1000 02/22/2023 25/PK EF-R 10 230222
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1420 PRTEST 1000 03/11/2023 25/PK EF-R 10 230311
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1474 PRTEST 1000 03/29/2023 25/PK EF-R 10 230329
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1522 PRTEST 1000 04/14/2023 25/PK EF-R 10 230414
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1567 PRTEST 1000 04/29/2023 25/PK EF-R 10 230429
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1618 PRTEST 1000 05/16/2023 25/PK EF-R 10 230516
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1666 PRTEST 1000 06/01/2023 25/PK EF-R 10 230601
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 1907-083 15-01 44 07/31/2021 EACH EF-R 10 210731
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 2101.1055 BUF.R1S1 25 02/27/2022 EACH EF-R 10 220227
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 2101.1055 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 2004-073 13-01 115 04/30/2022 EACH EF-R 10 220430
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1249 PRTEST 997 01/13/2023 EACH EF-R 10 230113
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1312 PRTEST 1000 02/03/2023 EACH EF-R 10 230203
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1375 PRTEST 1000 02/24/2023 EACH EF-R 10 230224
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1423 PRTEST 1000 03/12/2023 EACH EF-R 10 230312
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1477 PRTEST 1000 03/30/2023 EACH EF-R 10 230330
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1525 PRTEST 1000 04/15/2023 EACH EF-R 10 230415
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1570 PRTEST 1000 04/30/2023 EACH EF-R 10 230430
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1621 PRTEST 1000 05/17/2023 EACH EF-R 10 230517
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1669 PRTEST 1000 06/02/2023 EACH EF-R 10 230602
100047 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/08/2021 2 0 2 2101.1059 BUF.R1S1 8 02/27/2022 12/PK EF-R 10 220227
100047 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/08/2021 2 0 2 2101.1059 BUF.R2S2 14 02/27/2022 12/PK EF-R 10 220227
100047 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/08/2021 2 0 2 LOT#1318 PRTEST 1000 02/05/2023 12/PK EF-R 10 230205
100047 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/08/2021 2 0 2 LOT#1480 PRTEST 1000 03/31/2023 12/PK EF-R 10 230331
100047 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/08/2021 2 0 2 LOT#1723 PRTEST 1000 06/20/2023 12/PK EF-R 10 230620
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 2101.1061 BUF.R1S1 13 02/27/2022 24/PK EF-R 10 220227
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 2101.1061 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 LOT#1288 PRTEST 1000 01/26/2023 24/PK EF-R 10 230126
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 LOT#1321 PRTEST 1000 02/06/2023 24/PK EF-R 10 230206
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 LOT#1426 PRTEST 1000 03/13/2023 24/PK EF-R 10 230313
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 LOT#1501 PRTEST 1000 04/07/2023 24/PK EF-R 10 230407
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 LOT#1720 PRTEST 1000 06/19/2023 24/PK EF-R 10 230619
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 2101.1067 BUF.R1S1 27 02/27/2022 EACH EF-R 10 220227
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 2101.1067 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1255 PRTEST 1000 01/15/2023 EACH EF-R 10 230115
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1327 PRTEST 1000 02/08/2023 EACH EF-R 10 230208
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1381 PRTEST 1000 02/26/2023 EACH EF-R 10 230226
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1429 PRTEST 1000 03/14/2023 EACH EF-R 10 230314
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 2007-057 VLM 52 03/31/2023 EACH EF-R 10 230331
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 2007-060 VLM 348 03/31/2023 EACH EF-R 10 230331
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1483 PRTEST 1000 04/01/2023 EACH EF-R 10 230401
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1531 PRTEST 1000 04/17/2023 EACH EF-R 10 230417
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 2006-123 VLM 134 04/30/2023 EACH EF-R 10 230430
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1576 PRTEST 1000 05/02/2023 EACH EF-R 10 230502
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1627 PRTEST 1000 05/19/2023 EACH EF-R 10 230519
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1675 PRTEST 1000 06/04/2023 EACH EF-R 10 230604
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1708 PRTEST 1000 06/15/2023 EACH EF-R 10 230615
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 2101.1069 BUF.R1S1 13 02/27/2022 EACH EF-R 10 220227
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 2101.1069 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 LOT#1432 PRTEST 1000 03/15/2023 EACH EF-R 10 230315
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 LOT#1486 PRTEST 1000 04/02/2023 EACH EF-R 10 230402
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 LOT#1534 PRTEST 1000 04/18/2023 EACH EF-R 10 230418
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 LOT#1579 PRTEST 1000 05/03/2023 EACH EF-R 10 230503
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 LOT#1726 PRTEST 1000 06/21/2023 EACH EF-R 10 230621
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 2101.1075 BUF.R1S1 11 02/27/2022 24/PK EF-R 10 220227
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 2101.1075 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 LOT#1264 PRTEST 1000 01/18/2023 24/PK EF-R 10 230118
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 LOT#1336 PRTEST 1000 02/11/2023 24/PK EF-R 10 230211
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 LOT#1390 PRTEST 1000 03/01/2023 24/PK EF-R 10 230301
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 LOT#1489 PRTEST 1000 04/03/2023 24/PK EF-R 10 230403
100047 50.096 QC Hold Label (Sheet) 06/08/2021 20 0 20 2101.1099 BUF.R1S1 11 02/27/2022 EACH EF-R 10 220227
100047 50.096 QC Hold Label (Sheet) 06/08/2021 20 0 20 2101.1099 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100047 50.096 QC Hold Label (Sheet) 06/08/2021 20 0 20 LOT#1279 PRTEST 1000 01/23/2023 EACH EF-R 10 230123
100047 50.096 QC Hold Label (Sheet) 06/08/2021 20 0 20 LOT#1357 PRTEST 1000 02/18/2023 EACH EF-R 10 230218
100047 50.096 QC Hold Label (Sheet) 06/08/2021 20 0 20 LOT#1405 PRTEST 1000 03/06/2023 EACH EF-R 10 230306
100047 50.096 QC Hold Label (Sheet) 06/08/2021 20 0 20 LOT#1495 PRTEST 1000 04/05/2023 EACH EF-R 10 230405
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 2101.1101 BUF.R1S1 20 02/27/2022 EACH EF-R 10 220227
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 2101.1101 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 LOT#1282 PRTEST 1000 01/24/2023 EACH EF-R 10 230124
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 LOT#1450 PRTEST 1000 03/21/2023 EACH EF-R 10 230321
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 LOT#1498 PRTEST 1000 04/06/2023 EACH EF-R 10 230406
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 LOT#1552 PRTEST 1000 04/24/2023 EACH EF-R 10 230424
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 LOT#1603 PRTEST 1000 05/11/2023 EACH EF-R 10 230511
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 LOT#1651 PRTEST 1000 05/27/2023 EACH EF-R 10 230527
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 LOT#1693 PRTEST 1000 06/10/2023 EACH EF-R 10 230610
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 LOT#1711 PRTEST 1000 06/16/2023 EACH EF-R 10 230616
100055 10.005Q HEPES Buffer Solution, 1 M (2 to 8 C) (100ml) 06/13/2021 40 3 37 2101.1005 BUF.R2S2 14 02/27/2022 100MLBTL EF-R 10 220227
100055 10.005Q HEPES Buffer Solution, 1 M (2 to 8 C) (100ml) 06/13/2021 40 3 37 LOT#1504 PRTEST 960 04/08/2023 100MLBTL EF-R 10 230408
100055 10.115A Sucrose Crystal NF, 500g 06/13/2021 500 0 500 2101.1013 BUF.R1S1 3 02/27/2022 500G EF-R 10 220227
100055 10.115A Sucrose Crystal NF, 500g 06/13/2021 500 0 500 2101.1013 BUF.R2S2 14 02/27/2022 500G EF-R 10 220227
100055 10.115A Sucrose Crystal NF, 500g 06/13/2021 500 0 500 LOT#1462 PRTEST 1000 03/25/2023 500G EF-R 10 230325
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 2101.1041 BUF.R1S1 27 02/27/2022 50/BAG EF-R 10 220227
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 2101.1041 BUF.R2S2 15 02/27/2022 50/BAG EF-R 10 220227
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1237 PRTEST 1000 01/05/2023 50/BAG EF-R 10 230105
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1300 PRTEST 1000 01/30/2023 50/BAG EF-R 10 230130
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1363 PRTEST 1000 02/20/2023 50/BAG EF-R 10 230220
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1414 PRTEST 1000 03/09/2023 50/BAG EF-R 10 230309
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1468 PRTEST 1000 03/27/2023 50/BAG EF-R 10 230327
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1516 PRTEST 1000 04/12/2023 50/BAG EF-R 10 230412
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1561 PRTEST 1000 04/27/2023 50/BAG EF-R 10 230427
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1612 PRTEST 1000 05/14/2023 50/BAG EF-R 10 230514
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1660 PRTEST 1000 05/30/2023 50/BAG EF-R 10 230530
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1714 PRTEST 1000 06/17/2023 50/BAG EF-R 10 230617
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 2101.1043 BUF.R1S1 25 02/27/2022 25/BAG EF-R 10 220227
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 2101.1043 BUF.R2S2 15 02/27/2022 25/BAG EF-R 10 220227
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1240 PRTEST 1000 01/08/2023 25/BAG EF-R 10 230108
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1303 PRTEST 1000 01/31/2023 25/BAG EF-R 10 230131
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1366 PRTEST 1000 02/21/2023 25/BAG EF-R 10 230221
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1417 PRTEST 1000 03/10/2023 25/BAG EF-R 10 230310
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1471 PRTEST 1000 03/28/2023 25/BAG EF-R 10 230328
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1519 PRTEST 1000 04/13/2023 25/BAG EF-R 10 230413
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1564 PRTEST 1000 04/28/2023 25/BAG EF-R 10 230428
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1615 PRTEST 1000 05/15/2023 25/BAG EF-R 10 230515
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1663 PRTEST 1000 05/31/2023 25/BAG EF-R 10 230531
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 2101.1045 BUF.R1S1 26 02/27/2022 25/PK EF-R 10 220227
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 2101.1045 BUF.R2S2 14 02/27/2022 25/PK EF-R 10 220227
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1243 PRTEST 999 01/11/2023 25/PK EF-R 10 230111
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1306 PRTEST 1000 02/01/2023 25/PK EF-R 10 230201
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1369 PRTEST 1000 02/22/2023 25/PK EF-R 10 230222
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1420 PRTEST 1000 03/11/2023 25/PK EF-R 10 230311
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1474 PRTEST 1000 03/29/2023 25/PK EF-R 10 230329
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1522 PRTEST 1000 04/14/2023 25/PK EF-R 10 230414
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1567 PRTEST 1000 04/29/2023 25/PK EF-R 10 230429
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1618 PRTEST 1000 05/16/2023 25/PK EF-R 10 230516
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1666 PRTEST 1000 06/01/2023 25/PK EF-R 10 230601
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 1907-083 15-01 44 07/31/2021 EACH EF-R 10 210731
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2101.1055 BUF.R1S1 25 02/27/2022 EACH EF-R 10 220227
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2101.1055 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2004-073 13-01 115 04/30/2022 EACH EF-R 10 220430
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1249 PRTEST 997 01/13/2023 EACH EF-R 10 230113
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1312 PRTEST 1000 02/03/2023 EACH EF-R 10 230203
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1375 PRTEST 1000 02/24/2023 EACH EF-R 10 230224
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1423 PRTEST 1000 03/12/2023 EACH EF-R 10 230312
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1477 PRTEST 1000 03/30/2023 EACH EF-R 10 230330
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1525 PRTEST 1000 04/15/2023 EACH EF-R 10 230415
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1570 PRTEST 1000 04/30/2023 EACH EF-R 10 230430
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1621 PRTEST 1000 05/17/2023 EACH EF-R 10 230517
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1669 PRTEST 1000 06/02/2023 EACH EF-R 10 230602
100055 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 2101.1059 BUF.R1S1 8 02/27/2022 12/PK EF-R 10 220227
100055 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 2101.1059 BUF.R2S2 14 02/27/2022 12/PK EF-R 10 220227
100055 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1318 PRTEST 1000 02/05/2023 12/PK EF-R 10 230205
100055 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1480 PRTEST 1000 03/31/2023 12/PK EF-R 10 230331
100055 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1723 PRTEST 1000 06/20/2023 12/PK EF-R 10 230620
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 2101.1061 BUF.R1S1 13 02/27/2022 24/PK EF-R 10 220227
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 2101.1061 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1288 PRTEST 1000 01/26/2023 24/PK EF-R 10 230126
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1321 PRTEST 1000 02/06/2023 24/PK EF-R 10 230206
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1426 PRTEST 1000 03/13/2023 24/PK EF-R 10 230313
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1501 PRTEST 1000 04/07/2023 24/PK EF-R 10 230407
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1720 PRTEST 1000 06/19/2023 24/PK EF-R 10 230619
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2101.1067 BUF.R1S1 27 02/27/2022 EACH EF-R 10 220227
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2101.1067 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1255 PRTEST 1000 01/15/2023 EACH EF-R 10 230115
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1327 PRTEST 1000 02/08/2023 EACH EF-R 10 230208
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1381 PRTEST 1000 02/26/2023 EACH EF-R 10 230226
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1429 PRTEST 1000 03/14/2023 EACH EF-R 10 230314
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2007-057 VLM 52 03/31/2023 EACH EF-R 10 230331
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2007-060 VLM 348 03/31/2023 EACH EF-R 10 230331
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1483 PRTEST 1000 04/01/2023 EACH EF-R 10 230401
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1531 PRTEST 1000 04/17/2023 EACH EF-R 10 230417
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2006-123 VLM 134 04/30/2023 EACH EF-R 10 230430
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1576 PRTEST 1000 05/02/2023 EACH EF-R 10 230502
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1627 PRTEST 1000 05/19/2023 EACH EF-R 10 230519
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1675 PRTEST 1000 06/04/2023 EACH EF-R 10 230604
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1708 PRTEST 1000 06/15/2023 EACH EF-R 10 230615
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 2101.1069 BUF.R1S1 13 02/27/2022 EACH EF-R 10 220227
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 2101.1069 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1432 PRTEST 1000 03/15/2023 EACH EF-R 10 230315
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1486 PRTEST 1000 04/02/2023 EACH EF-R 10 230402
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1534 PRTEST 1000 04/18/2023 EACH EF-R 10 230418
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1579 PRTEST 1000 05/03/2023 EACH EF-R 10 230503
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1726 PRTEST 1000 06/21/2023 EACH EF-R 10 230621
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 2101.1075 BUF.R1S1 11 02/27/2022 24/PK EF-R 10 220227
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 2101.1075 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1264 PRTEST 1000 01/18/2023 24/PK EF-R 10 230118
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1336 PRTEST 1000 02/11/2023 24/PK EF-R 10 230211
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1390 PRTEST 1000 03/01/2023 24/PK EF-R 10 230301
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1489 PRTEST 1000 04/03/2023 24/PK EF-R 10 230403
100055 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 2101.1099 BUF.R1S1 11 02/27/2022 EACH EF-R 10 220227
100055 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 2101.1099 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100055 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1279 PRTEST 1000 01/23/2023 EACH EF-R 10 230123
100055 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1357 PRTEST 1000 02/18/2023 EACH EF-R 10 230218
100055 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1405 PRTEST 1000 03/06/2023 EACH EF-R 10 230306
100055 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1495 PRTEST 1000 04/05/2023 EACH EF-R 10 230405
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 2101.1101 BUF.R1S1 20 02/27/2022 EACH EF-R 10 220227
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 2101.1101 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1282 PRTEST 1000 01/24/2023 EACH EF-R 10 230124
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1450 PRTEST 1000 03/21/2023 EACH EF-R 10 230321
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1498 PRTEST 1000 04/06/2023 EACH EF-R 10 230406
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1552 PRTEST 1000 04/24/2023 EACH EF-R 10 230424
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1603 PRTEST 1000 05/11/2023 EACH EF-R 10 230511
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1651 PRTEST 1000 05/27/2023 EACH EF-R 10 230527
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1693 PRTEST 1000 06/10/2023 EACH EF-R 10 230610
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1711 PRTEST 1000 06/16/2023 EACH EF-R 10 230616
100056 10.005Q HEPES Buffer Solution, 1 M (2 to 8 C) (100ml) 06/13/2021 40 0 40 2101.1005 BUF.R2S2 14 02/27/2022 100MLBTL EF-R 10 220227
100056 10.005Q HEPES Buffer Solution, 1 M (2 to 8 C) (100ml) 06/13/2021 40 0 40 LOT#1504 PRTEST 960 04/08/2023 100MLBTL EF-R 10 230408
100056 10.084B 0.5N NaOH, Sterile (1L) 06/13/2021 1000 2 999 2101.1009 BUF.R2S2 15 02/27/2022 ML EF-R 10 220227
100056 10.084B 0.5N NaOH, Sterile (1L) 06/13/2021 1000 1 999 2101.4567 BUF.R1S1 1001 06/30/2022 ML EF-R 10 220630
100056 10.084B 0.5N NaOH, Sterile (1L) 06/13/2021 1000 1 999 LOT#1456 PRTEST 1000 03/23/2023 ML EF-R 10 230323
100056 10.093 Potassium Chloride, USP, BP/EP, 250g 06/13/2021 1 0 1 2101.1011 BUF.R1S1 1 02/27/2022 250g EF-R 10 220227
100056 10.093 Potassium Chloride, USP, BP/EP, 250g 06/13/2021 1 0 1 2101.1011 BUF.R2S2 15 02/27/2022 250g EF-R 10 220227
100056 10.093 Potassium Chloride, USP, BP/EP, 250g 06/13/2021 1 0 1 LOT#1459 PRTEST 999 03/24/2023 250g EF-R 10 230324
100056 10.115A Sucrose Crystal NF, 500g 06/13/2021 500 0 500 2101.1013 BUF.R1S1 3 02/27/2022 500G EF-R 10 220227
100056 10.115A Sucrose Crystal NF, 500g 06/13/2021 500 0 500 2101.1013 BUF.R2S2 14 02/27/2022 500G EF-R 10 220227
100056 10.115A Sucrose Crystal NF, 500g 06/13/2021 500 0 500 LOT#1462 PRTEST 1000 03/25/2023 500G EF-R 10 230325
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 2101.1015 BUF.R1S1 11 02/27/2022 1L BTL EF-R 10 220227
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 2101.1015 BUF.R2S2 14 02/27/2022 1L BTL EF-R 10 220227
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 LOT#1465 PRTEST 1000 03/26/2023 1L BTL EF-R 10 230326
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 LOT#1510 PRTEST 1000 04/10/2023 1L BTL EF-R 10 230410
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 LOT#1558 PRTEST 1000 04/26/2023 1L BTL EF-R 10 230426
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 LOT#1606 PRTEST 1000 05/12/2023 1L BTL EF-R 10 230512
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 LOT#1654 PRTEST 1000 05/28/2023 1L BTL EF-R 10 230528
100056 10.264A Sodium Phosphate, Dibasic, Heptahydrate, USP (500G) 06/13/2021 1 0 1 2101.1021 BUF.R1S1 1 02/27/2022 500G EF-R 10 220227
100056 10.264A Sodium Phosphate, Dibasic, Heptahydrate, USP (500G) 06/13/2021 1 0 1 2101.1021 BUF.R2S2 15 02/27/2022 500G EF-R 10 220227
100056 10.264A Sodium Phosphate, Dibasic, Heptahydrate, USP (500G) 06/13/2021 1 0 1 LOT#1507 PRTEST 1000 04/09/2023 500G EF-R 10 230409
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 2101.1041 BUF.R1S1 27 02/27/2022 50/BAG EF-R 10 220227
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 2101.1041 BUF.R2S2 15 02/27/2022 50/BAG EF-R 10 220227
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1237 PRTEST 1000 01/05/2023 50/BAG EF-R 10 230105
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1300 PRTEST 1000 01/30/2023 50/BAG EF-R 10 230130
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1363 PRTEST 1000 02/20/2023 50/BAG EF-R 10 230220
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1414 PRTEST 1000 03/09/2023 50/BAG EF-R 10 230309
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1468 PRTEST 1000 03/27/2023 50/BAG EF-R 10 230327
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1516 PRTEST 1000 04/12/2023 50/BAG EF-R 10 230412
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1561 PRTEST 1000 04/27/2023 50/BAG EF-R 10 230427
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1612 PRTEST 1000 05/14/2023 50/BAG EF-R 10 230514
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1660 PRTEST 1000 05/30/2023 50/BAG EF-R 10 230530
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1714 PRTEST 1000 06/17/2023 50/BAG EF-R 10 230617
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 2101.1043 BUF.R1S1 25 02/27/2022 25/BAG EF-R 10 220227
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 2101.1043 BUF.R2S2 15 02/27/2022 25/BAG EF-R 10 220227
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1240 PRTEST 1000 01/08/2023 25/BAG EF-R 10 230108
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1303 PRTEST 1000 01/31/2023 25/BAG EF-R 10 230131
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1366 PRTEST 1000 02/21/2023 25/BAG EF-R 10 230221
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1417 PRTEST 1000 03/10/2023 25/BAG EF-R 10 230310
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1471 PRTEST 1000 03/28/2023 25/BAG EF-R 10 230328
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1519 PRTEST 1000 04/13/2023 25/BAG EF-R 10 230413
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1564 PRTEST 1000 04/28/2023 25/BAG EF-R 10 230428
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1615 PRTEST 1000 05/15/2023 25/BAG EF-R 10 230515
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1663 PRTEST 1000 05/31/2023 25/BAG EF-R 10 230531
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 2101.1045 BUF.R1S1 26 02/27/2022 25/PK EF-R 10 220227
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 2101.1045 BUF.R2S2 14 02/27/2022 25/PK EF-R 10 220227
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1243 PRTEST 999 01/11/2023 25/PK EF-R 10 230111
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1306 PRTEST 1000 02/01/2023 25/PK EF-R 10 230201
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1369 PRTEST 1000 02/22/2023 25/PK EF-R 10 230222
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1420 PRTEST 1000 03/11/2023 25/PK EF-R 10 230311
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1474 PRTEST 1000 03/29/2023 25/PK EF-R 10 230329
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1522 PRTEST 1000 04/14/2023 25/PK EF-R 10 230414
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1567 PRTEST 1000 04/29/2023 25/PK EF-R 10 230429
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1618 PRTEST 1000 05/16/2023 25/PK EF-R 10 230516
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1666 PRTEST 1000 06/01/2023 25/PK EF-R 10 230601
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 1907-083 15-01 44 07/31/2021 EACH EF-R 10 210731
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2101.1055 BUF.R1S1 25 02/27/2022 EACH EF-R 10 220227
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2101.1055 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2004-073 13-01 115 04/30/2022 EACH EF-R 10 220430
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1249 PRTEST 997 01/13/2023 EACH EF-R 10 230113
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1312 PRTEST 1000 02/03/2023 EACH EF-R 10 230203
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1375 PRTEST 1000 02/24/2023 EACH EF-R 10 230224
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1423 PRTEST 1000 03/12/2023 EACH EF-R 10 230312
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1477 PRTEST 1000 03/30/2023 EACH EF-R 10 230330
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1525 PRTEST 1000 04/15/2023 EACH EF-R 10 230415
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1570 PRTEST 1000 04/30/2023 EACH EF-R 10 230430
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1621 PRTEST 1000 05/17/2023 EACH EF-R 10 230517
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1669 PRTEST 1000 06/02/2023 EACH EF-R 10 230602
100056 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 2101.1059 BUF.R1S1 8 02/27/2022 12/PK EF-R 10 220227
100056 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 2101.1059 BUF.R2S2 14 02/27/2022 12/PK EF-R 10 220227
100056 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1318 PRTEST 1000 02/05/2023 12/PK EF-R 10 230205
100056 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1480 PRTEST 1000 03/31/2023 12/PK EF-R 10 230331
100056 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1723 PRTEST 1000 06/20/2023 12/PK EF-R 10 230620
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 2101.1061 BUF.R1S1 13 02/27/2022 24/PK EF-R 10 220227
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 2101.1061 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1288 PRTEST 1000 01/26/2023 24/PK EF-R 10 230126
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1321 PRTEST 1000 02/06/2023 24/PK EF-R 10 230206
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1426 PRTEST 1000 03/13/2023 24/PK EF-R 10 230313
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1501 PRTEST 1000 04/07/2023 24/PK EF-R 10 230407
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1720 PRTEST 1000 06/19/2023 24/PK EF-R 10 230619
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2101.1067 BUF.R1S1 27 02/27/2022 EACH EF-R 10 220227
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2101.1067 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1255 PRTEST 1000 01/15/2023 EACH EF-R 10 230115
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1327 PRTEST 1000 02/08/2023 EACH EF-R 10 230208
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1381 PRTEST 1000 02/26/2023 EACH EF-R 10 230226
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1429 PRTEST 1000 03/14/2023 EACH EF-R 10 230314
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2007-057 VLM 52 03/31/2023 EACH EF-R 10 230331
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2007-060 VLM 348 03/31/2023 EACH EF-R 10 230331
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1483 PRTEST 1000 04/01/2023 EACH EF-R 10 230401
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1531 PRTEST 1000 04/17/2023 EACH EF-R 10 230417
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2006-123 VLM 134 04/30/2023 EACH EF-R 10 230430
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1576 PRTEST 1000 05/02/2023 EACH EF-R 10 230502
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1627 PRTEST 1000 05/19/2023 EACH EF-R 10 230519
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1675 PRTEST 1000 06/04/2023 EACH EF-R 10 230604
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1708 PRTEST 1000 06/15/2023 EACH EF-R 10 230615
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 2101.1069 BUF.R1S1 13 02/27/2022 EACH EF-R 10 220227
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 2101.1069 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1432 PRTEST 1000 03/15/2023 EACH EF-R 10 230315
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1486 PRTEST 1000 04/02/2023 EACH EF-R 10 230402
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1534 PRTEST 1000 04/18/2023 EACH EF-R 10 230418
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1579 PRTEST 1000 05/03/2023 EACH EF-R 10 230503
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1726 PRTEST 1000 06/21/2023 EACH EF-R 10 230621
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 2101.1075 BUF.R1S1 11 02/27/2022 24/PK EF-R 10 220227
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 2101.1075 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1264 PRTEST 1000 01/18/2023 24/PK EF-R 10 230118
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1336 PRTEST 1000 02/11/2023 24/PK EF-R 10 230211
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1390 PRTEST 1000 03/01/2023 24/PK EF-R 10 230301
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1489 PRTEST 1000 04/03/2023 24/PK EF-R 10 230403
100056 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 2101.1099 BUF.R1S1 11 02/27/2022 EACH EF-R 10 220227
100056 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 2101.1099 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100056 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1279 PRTEST 1000 01/23/2023 EACH EF-R 10 230123
100056 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1357 PRTEST 1000 02/18/2023 EACH EF-R 10 230218
100056 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1405 PRTEST 1000 03/06/2023 EACH EF-R 10 230306
100056 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1495 PRTEST 1000 04/05/2023 EACH EF-R 10 230405
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 2101.1101 BUF.R1S1 20 02/27/2022 EACH EF-R 10 220227
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 2101.1101 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1282 PRTEST 1000 01/24/2023 EACH EF-R 10 230124
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1450 PRTEST 1000 03/21/2023 EACH EF-R 10 230321
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1498 PRTEST 1000 04/06/2023 EACH EF-R 10 230406
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1552 PRTEST 1000 04/24/2023 EACH EF-R 10 230424
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1603 PRTEST 1000 05/11/2023 EACH EF-R 10 230511
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1651 PRTEST 1000 05/27/2023 EACH EF-R 10 230527
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1693 PRTEST 1000 06/10/2023 EACH EF-R 10 230610
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1711 PRTEST 1000 06/16/2023 EACH EF-R 10 230616
can you try this?
;WITH cte1
AS (SELECT TRIM(dbo.PK010033.MANUFACTUREORDER_I) AS [MO No],
TRIM(dbo.PK010033.ITEMNMBR) AS [Item No],
TRIM(dbo.IV00101.ITEMDESC) AS [Desc],
CONVERT(VARCHAR, dbo.PK010033.REQDATE, 101) AS Required,
Cast(dbo.PK010033.QTY_ALLOWED_I AS INT) AS PickQty,
Sum(Cast(dbo.PK010033.QTY_ISSUED_I AS INT)) AS Issued,
Cast(dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT) AS [Remaining Qty],
TRIM(dbo.IV00300.LOTNUMBR) AS [Lot Number],
TRIM(dbo.IV00300.BIN) AS BIN,
Sum(Cast(dbo.IV00300.QTYRECVD - dbo.IV00300.QTYSOLD AS INT)) AS AvailBinQty,
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 101) AS ExpireDate,
TRIM(dbo.PK010033.UOFM) AS PK_UoM,
TRIM(dbo.PK010033.LOCNCODE) AS Site,
TRIM(dbo.PK010033.RTSEQNUM_I) AS ROUTE_SEQ,
dbo.PK010033.BOMUSERDEF1_I AS [Offset Require Date],
dbo.PK010033.BOMUSERDEF2_I AS [Special Instructions],
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 12) AS [Expire No]
FROM dbo.IV00101
RIGHT OUTER JOIN dbo.PK010033
ON dbo.IV00101.ITEMNMBR = dbo.PK010033.ITEMNMBR
LEFT OUTER JOIN dbo.IV00112
INNER JOIN dbo.IV00300
ON dbo.IV00112.ITEMNMBR = dbo.IV00300.ITEMNMBR
AND dbo.IV00112.BIN = dbo.IV00300.BIN
ON dbo.PK010033.ITEMNMBR = dbo.IV00300.ITEMNMBR
AND dbo.PK010033.LOCNCODE = dbo.IV00300.LOCNCODE
GROUP BY TRIM(dbo.PK010033.MANUFACTUREORDER_I),
TRIM(dbo.PK010033.ITEMNMBR),
TRIM(dbo.PK010033.UOFM),
TRIM(dbo.PK010033.RTSEQNUM_I),
TRIM(dbo.PK010033.LOCNCODE),
CONVERT(VARCHAR, dbo.PK010033.REQDATE, 101),
dbo.PK010033.BOMUSERDEF1_I,
dbo.PK010033.BOMUSERDEF2_I,
dbo.PK010033.MANUFACTUREORDERST_I,
TRIM(dbo.IV00101.ITEMDESC),
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 12),
CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 101),
TRIM(dbo.IV00300.BIN),
TRIM(dbo.IV00300.LOTNUMBR),
Cast(dbo.PK010033.QTY_ALLOWED_I AS INT),
Cast(dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT)
HAVING ( dbo.PK010033.MANUFACTUREORDERST_I = 3 )
AND ( TRIM(dbo.PK010033.LOCNCODE) = 'EF-R' )
AND ( Cast(dbo.PK010033.QTY_ALLOWED_I - dbo.PK010033.QTY_ISSUED_I AS INT) > 0 )
AND ( Sum(Cast(dbo.IV00300.QTYRECVD - dbo.IV00300.QTYSOLD AS INT)) > 0 )
AND ( CONVERT(VARCHAR, dbo.IV00300.EXPNDATE, 101) >= Getdate() )),
cte2
AS (SELECT *,
ROW_NUMBER()
OVER (
partition BY [MO No], [Item No]
ORDER BY ExpireDate, BIN) AS rn
FROM cte1),
cte3
AS (SELECT *,
Min(CASE
WHEN AvailBinQty <= PickQty THEN rn
END)
OVER (
partition BY [MO No], [Item No]) min_rn
FROM cte2)
SELECT *
FROM cte3
WHERE rn <= min_rn
OR min_rn IS NULL
ASKER
Hello and thank you Sharath.
The original query produced 466 rows and when I run this New query, the result set is 386. That is an 80 row difference. It almost Seems that if the 80 rows were to display instead of the 386, your query would be working. I am not saying this is the case, but 80 rows seems like a number that would make more sense.
The original query produced 466 rows and when I run this New query, the result set is 386. That is an 80 row difference. It almost Seems that if the 80 rows were to display instead of the 386, your query would be working. I am not saying this is the case, but 80 rows seems like a number that would make more sense.
MO No Item No Desc Required PickQty Issued Remaining Qty Lot Number BIN AvailBinQty ExpireDate PK_UoM Site ROUTE_SEQ Offset Require Date Special Instructions Expire No rn min_rn
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1237 PRTEST 1000 01/05/2023 50/BAG EF-R 10 230105 1 NULL
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1300 PRTEST 1000 01/30/2023 50/BAG EF-R 10 230130 2 NULL
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1363 PRTEST 1000 02/20/2023 50/BAG EF-R 10 230220 3 NULL
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 2101.1041 BUF.R1S1 27 02/27/2022 50/BAG EF-R 10 220227 4 NULL
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 2101.1041 BUF.R2S2 15 02/27/2022 50/BAG EF-R 10 220227 5 NULL
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1414 PRTEST 1000 03/09/2023 50/BAG EF-R 10 230309 6 NULL
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1468 PRTEST 1000 03/27/2023 50/BAG EF-R 10 230327 7 NULL
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1516 PRTEST 1000 04/12/2023 50/BAG EF-R 10 230412 8 NULL
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1561 PRTEST 1000 04/27/2023 50/BAG EF-R 10 230427 9 NULL
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1612 PRTEST 1000 05/14/2023 50/BAG EF-R 10 230514 10 NULL
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1660 PRTEST 1000 05/30/2023 50/BAG EF-R 10 230530 11 NULL
100044 30.005 Serological Pipet, 25 mL 05/17/2021 1 0 1 LOT#1714 PRTEST 1000 06/17/2023 50/BAG EF-R 10 230617 12 NULL
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1240 PRTEST 1000 01/08/2023 25/BAG EF-R 10 230108 1 NULL
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1303 PRTEST 1000 01/31/2023 25/BAG EF-R 10 230131 2 NULL
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1366 PRTEST 1000 02/21/2023 25/BAG EF-R 10 230221 3 NULL
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 2101.1043 BUF.R1S1 25 02/27/2022 25/BAG EF-R 10 220227 4 NULL
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 2101.1043 BUF.R2S2 15 02/27/2022 25/BAG EF-R 10 220227 5 NULL
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1417 PRTEST 1000 03/10/2023 25/BAG EF-R 10 230310 6 NULL
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1471 PRTEST 1000 03/28/2023 25/BAG EF-R 10 230328 7 NULL
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1519 PRTEST 1000 04/13/2023 25/BAG EF-R 10 230413 8 NULL
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1564 PRTEST 1000 04/28/2023 25/BAG EF-R 10 230428 9 NULL
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1615 PRTEST 1000 05/15/2023 25/BAG EF-R 10 230515 10 NULL
100044 30.006 Serological Pipet, 50 mL 05/17/2021 1 0 1 LOT#1663 PRTEST 1000 05/31/2023 25/BAG EF-R 10 230531 11 NULL
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 LOT#1252 PRTEST 1000 01/14/2023 EACH EF-R 10 230114 1 3
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 LOT#1315 PRTEST 1000 02/04/2023 EACH EF-R 10 230204 2 3
100044 30.1168 Buffer/Media Prep Outlet (30 cm) 05/17/2021 3 0 3 TEST03 VLM 1 02/04/2026 EACH EF-R 10 260204 3 3
100044 30.122 Sterile Square Media Bottle (PETG), 1000mL 05/17/2021 2 0 2 LOT#1318 PRTEST 1000 02/05/2023 12/PK EF-R 10 230205 1 NULL
100044 30.122 Sterile Square Media Bottle (PETG), 1000mL 05/17/2021 2 0 2 2101.1059 BUF.R1S1 8 02/27/2022 12/PK EF-R 10 220227 2 NULL
100044 30.122 Sterile Square Media Bottle (PETG), 1000mL 05/17/2021 2 0 2 2101.1059 BUF.R2S2 14 02/27/2022 12/PK EF-R 10 220227 3 NULL
100044 30.122 Sterile Square Media Bottle (PETG), 1000mL 05/17/2021 2 0 2 LOT#1480 PRTEST 1000 03/31/2023 12/PK EF-R 10 230331 4 NULL
100044 30.122 Sterile Square Media Bottle (PETG), 1000mL 05/17/2021 2 0 2 LOT#1723 PRTEST 1000 06/20/2023 12/PK EF-R 10 230620 5 NULL
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 LOT#1288 PRTEST 1000 01/26/2023 24/PK EF-R 10 230126 1 NULL
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 LOT#1321 PRTEST 1000 02/06/2023 24/PK EF-R 10 230206 2 NULL
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 2101.1061 BUF.R1S1 13 02/27/2022 24/PK EF-R 10 220227 3 NULL
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 2101.1061 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227 4 NULL
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 LOT#1426 PRTEST 1000 03/13/2023 24/PK EF-R 10 230313 5 NULL
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 LOT#1501 PRTEST 1000 04/07/2023 24/PK EF-R 10 230407 6 NULL
100044 30.137 Sterile Square Media Bottle (PETG), 250mL 05/17/2021 1 0 1 LOT#1720 PRTEST 1000 06/19/2023 24/PK EF-R 10 230619 7 NULL
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 LOT#1261 PRTEST 2000 01/17/2023 24/PK EF-R 10 230117 1 NULL
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 TEST03 VLM 2 02/04/2026 24/PK EF-R 10 260204 2 NULL
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 LOT#1333 PRTEST 2000 02/10/2023 24/PK EF-R 10 230210 3 NULL
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 LOT#1351 PRTEST 2000 02/16/2023 24/PK EF-R 10 230216 4 NULL
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 TEST03 VLM 2 02/24/2024 24/PK EF-R 10 240224 5 NULL
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 2101.1073 BUF.R1S1 24 02/27/2022 24/PK EF-R 10 220227 6 NULL
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 2101.1073 BUF.R2S2 30 02/27/2022 24/PK EF-R 10 220227 7 NULL
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 LOT#1387 PRTEST 2000 02/28/2023 24/PK EF-R 10 230228 8 NULL
100044 30.728 Media Bottle 125mL, Sterile, Square 05/17/2021 1 0 1 2008-026 POG 44 04/26/2025 24/PK EF-R 10 250426 9 NULL
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 LOT#1264 PRTEST 1000 01/18/2023 24/PK EF-R 10 230118 1 NULL
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 LOT#1336 PRTEST 1000 02/11/2023 24/PK EF-R 10 230211 2 NULL
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 2101.1075 BUF.R1S1 11 02/27/2022 24/PK EF-R 10 220227 3 NULL
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 2101.1075 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227 4 NULL
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 LOT#1390 PRTEST 1000 03/01/2023 24/PK EF-R 10 230301 5 NULL
100044 30.729 Sterile Square Media Bottle (PETG), 60mL 05/17/2021 1 0 1 LOT#1489 PRTEST 1000 04/03/2023 24/PK EF-R 10 230403 6 NULL
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 LOT#1267 PRTEST 1000 01/19/2023 EACH EF-R 10 230119 1 NULL
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 LOT#1339 PRTEST 1000 02/12/2023 EACH EF-R 10 230212 2 NULL
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 2101.1083 BUF.R1S1 6 02/27/2022 EACH EF-R 10 220227 3 NULL
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 2101.1083 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227 4 NULL
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 2008-109 POG 266 08/31/2023 EACH EF-R 10 230831 5 NULL
100044 30.844 Labtainer BPC, 50L with 3 Ports, MPC Insert, MPC Body, and Luer Lock 05/17/2021 2 0 2 2008-110 POG 398 08/31/2023 EACH EF-R 10 230831 6 NULL
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 LOT#1270 PRTEST 1000 01/20/2023 500ML EF-R 10 230120 1 NULL
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 LOT#1342 PRTEST 1000 02/13/2023 500ML EF-R 10 230213 2 NULL
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 2101.1091 BUF.R1S1 15 02/27/2022 500ML EF-R 10 220227 3 NULL
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 2101.1091 BUF.R2S2 15 02/27/2022 500ML EF-R 10 220227 4 NULL
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 LOT#1396 PRTEST 1000 03/03/2023 500ML EF-R 10 230303 5 NULL
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 LOT#1435 PRTEST 1000 03/16/2023 500ML EF-R 10 230316 6 NULL
100044 45.011 pH 4.0 Buffer 05/17/2021 1 0 1 LOT#1588 PRTEST 1000 05/06/2023 500ML EF-R 10 230506 7 NULL
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1273 PRTEST 1000 01/21/2023 500ML EF-R 10 230121 1 NULL
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1345 PRTEST 1000 02/14/2023 500ML EF-R 10 230214 2 NULL
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 2101.1093 BUF.R1S1 23 02/27/2022 500ML EF-R 10 220227 3 NULL
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 2101.1093 BUF.R2S2 15 02/27/2022 500ML EF-R 10 220227 4 NULL
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1399 PRTEST 1000 03/04/2023 500ML EF-R 10 230304 5 NULL
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1438 PRTEST 1000 03/17/2023 500ML EF-R 10 230317 6 NULL
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1540 PRTEST 1000 04/20/2023 500ML EF-R 10 230420 7 NULL
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1591 PRTEST 1000 05/07/2023 500ML EF-R 10 230507 8 NULL
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1639 PRTEST 1000 05/23/2023 500ML EF-R 10 230523 9 NULL
100044 45.012 pH 7.0 Buffer 05/17/2021 1 0 1 LOT#1681 PRTEST 1000 06/06/2023 500ML EF-R 10 230606 10 NULL
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1276 PRTEST 1000 01/22/2023 500ML EF-R 10 230122 1 NULL
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1348 PRTEST 1000 02/15/2023 500ML EF-R 10 230215 2 NULL
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 2101.1095 BUF.R1S1 23 02/27/2022 500ML EF-R 10 220227 3 NULL
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 2101.1095 BUF.R2S2 15 02/27/2022 500ML EF-R 10 220227 4 NULL
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1402 PRTEST 1000 03/05/2023 500ML EF-R 10 230305 5 NULL
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1441 PRTEST 1000 03/18/2023 500ML EF-R 10 230318 6 NULL
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1543 PRTEST 1000 04/21/2023 500ML EF-R 10 230421 7 NULL
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1594 PRTEST 1000 05/08/2023 500ML EF-R 10 230508 8 NULL
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1642 PRTEST 1000 05/24/2023 500ML EF-R 10 230524 9 NULL
100044 45.013 pH 10.0 Buffer 05/17/2021 1 0 1 LOT#1684 PRTEST 1000 06/07/2023 500ML EF-R 10 230607 10 NULL
100047 10.084B 0.5N NaOH, Sterile (1L) 06/08/2021 1000 0 1000 2101.1009 BUF.R2S2 15 02/27/2022 1L BTL EF-R 10 220227 1 1
100047 10.115A Sucrose Crystal NF, 500g 06/08/2021 500 0 500 2101.1013 BUF.R1S1 3 02/27/2022 500G EF-R 10 220227 1 1
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 2101.1015 BUF.R1S1 11 02/27/2022 1L BTL EF-R 10 220227 1 NULL
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 2101.1015 BUF.R2S2 14 02/27/2022 1L BTL EF-R 10 220227 2 NULL
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 LOT#1465 PRTEST 1000 03/26/2023 1L BTL EF-R 10 230326 3 NULL
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 LOT#1510 PRTEST 1000 04/10/2023 1L BTL EF-R 10 230410 4 NULL
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 LOT#1558 PRTEST 1000 04/26/2023 1L BTL EF-R 10 230426 5 NULL
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 LOT#1606 PRTEST 1000 05/12/2023 1L BTL EF-R 10 230512 6 NULL
100047 10.121B 5 M NaCl, Sterile (1L) 06/08/2021 3 0 3 LOT#1654 PRTEST 1000 05/28/2023 1L BTL EF-R 10 230528 7 NULL
100047 10.264A Sodium Phosphate, Dibasic, Heptahydrate, USP (500G) 06/08/2021 1 0 1 2101.1021 BUF.R1S1 1 02/27/2022 500G EF-R 10 220227 1 1
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1237 PRTEST 1000 01/05/2023 50/BAG EF-R 10 230105 1 NULL
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1300 PRTEST 1000 01/30/2023 50/BAG EF-R 10 230130 2 NULL
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1363 PRTEST 1000 02/20/2023 50/BAG EF-R 10 230220 3 NULL
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 2101.1041 BUF.R1S1 27 02/27/2022 50/BAG EF-R 10 220227 4 NULL
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 2101.1041 BUF.R2S2 15 02/27/2022 50/BAG EF-R 10 220227 5 NULL
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1414 PRTEST 1000 03/09/2023 50/BAG EF-R 10 230309 6 NULL
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1468 PRTEST 1000 03/27/2023 50/BAG EF-R 10 230327 7 NULL
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1516 PRTEST 1000 04/12/2023 50/BAG EF-R 10 230412 8 NULL
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1561 PRTEST 1000 04/27/2023 50/BAG EF-R 10 230427 9 NULL
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1612 PRTEST 1000 05/14/2023 50/BAG EF-R 10 230514 10 NULL
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1660 PRTEST 1000 05/30/2023 50/BAG EF-R 10 230530 11 NULL
100047 30.005 Serological Pipet, 25 mL 06/08/2021 1 0 1 LOT#1714 PRTEST 1000 06/17/2023 50/BAG EF-R 10 230617 12 NULL
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1240 PRTEST 1000 01/08/2023 25/BAG EF-R 10 230108 1 NULL
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1303 PRTEST 1000 01/31/2023 25/BAG EF-R 10 230131 2 NULL
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1366 PRTEST 1000 02/21/2023 25/BAG EF-R 10 230221 3 NULL
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 2101.1043 BUF.R1S1 25 02/27/2022 25/BAG EF-R 10 220227 4 NULL
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 2101.1043 BUF.R2S2 15 02/27/2022 25/BAG EF-R 10 220227 5 NULL
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1417 PRTEST 1000 03/10/2023 25/BAG EF-R 10 230310 6 NULL
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1471 PRTEST 1000 03/28/2023 25/BAG EF-R 10 230328 7 NULL
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1519 PRTEST 1000 04/13/2023 25/BAG EF-R 10 230413 8 NULL
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1564 PRTEST 1000 04/28/2023 25/BAG EF-R 10 230428 9 NULL
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1615 PRTEST 1000 05/15/2023 25/BAG EF-R 10 230515 10 NULL
100047 30.006 Serological Pipet, 50 mL 06/08/2021 1 0 1 LOT#1663 PRTEST 1000 05/31/2023 25/BAG EF-R 10 230531 11 NULL
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1243 PRTEST 999 01/11/2023 25/PK EF-R 10 230111 1 NULL
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1306 PRTEST 1000 02/01/2023 25/PK EF-R 10 230201 2 NULL
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1369 PRTEST 1000 02/22/2023 25/PK EF-R 10 230222 3 NULL
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 2101.1045 BUF.R1S1 26 02/27/2022 25/PK EF-R 10 220227 4 NULL
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 2101.1045 BUF.R2S2 14 02/27/2022 25/PK EF-R 10 220227 5 NULL
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1420 PRTEST 1000 03/11/2023 25/PK EF-R 10 230311 6 NULL
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1474 PRTEST 1000 03/29/2023 25/PK EF-R 10 230329 7 NULL
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1522 PRTEST 1000 04/14/2023 25/PK EF-R 10 230414 8 NULL
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1567 PRTEST 1000 04/29/2023 25/PK EF-R 10 230429 9 NULL
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1618 PRTEST 1000 05/16/2023 25/PK EF-R 10 230516 10 NULL
100047 30.014 Centrifuge Tube, 50 mL 06/08/2021 1 0 1 LOT#1666 PRTEST 1000 06/01/2023 25/PK EF-R 10 230601 11 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1249 PRTEST 997 01/13/2023 EACH EF-R 10 230113 1 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1312 PRTEST 1000 02/03/2023 EACH EF-R 10 230203 2 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1375 PRTEST 1000 02/24/2023 EACH EF-R 10 230224 3 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 2101.1055 BUF.R1S1 25 02/27/2022 EACH EF-R 10 220227 4 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 2101.1055 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227 5 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1423 PRTEST 1000 03/12/2023 EACH EF-R 10 230312 6 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1477 PRTEST 1000 03/30/2023 EACH EF-R 10 230330 7 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1525 PRTEST 1000 04/15/2023 EACH EF-R 10 230415 8 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 2004-073 13-01 115 04/30/2022 EACH EF-R 10 220430 9 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1570 PRTEST 1000 04/30/2023 EACH EF-R 10 230430 10 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1621 PRTEST 1000 05/17/2023 EACH EF-R 10 230517 11 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 LOT#1669 PRTEST 1000 06/02/2023 EACH EF-R 10 230602 12 NULL
100047 30.1167 Buffer / Media Prep Inlet Large 06/08/2021 1 0 1 1907-083 15-01 44 07/31/2021 EACH EF-R 10 210731 13 NULL
100047 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/08/2021 2 0 2 LOT#1318 PRTEST 1000 02/05/2023 12/PK EF-R 10 230205 1 NULL
100047 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/08/2021 2 0 2 2101.1059 BUF.R1S1 8 02/27/2022 12/PK EF-R 10 220227 2 NULL
100047 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/08/2021 2 0 2 2101.1059 BUF.R2S2 14 02/27/2022 12/PK EF-R 10 220227 3 NULL
100047 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/08/2021 2 0 2 LOT#1480 PRTEST 1000 03/31/2023 12/PK EF-R 10 230331 4 NULL
100047 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/08/2021 2 0 2 LOT#1723 PRTEST 1000 06/20/2023 12/PK EF-R 10 230620 5 NULL
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 LOT#1288 PRTEST 1000 01/26/2023 24/PK EF-R 10 230126 1 NULL
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 LOT#1321 PRTEST 1000 02/06/2023 24/PK EF-R 10 230206 2 NULL
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 2101.1061 BUF.R1S1 13 02/27/2022 24/PK EF-R 10 220227 3 NULL
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 2101.1061 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227 4 NULL
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 LOT#1426 PRTEST 1000 03/13/2023 24/PK EF-R 10 230313 5 NULL
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 LOT#1501 PRTEST 1000 04/07/2023 24/PK EF-R 10 230407 6 NULL
100047 30.137 Sterile Square Media Bottle (PETG), 250mL 06/08/2021 1 0 1 LOT#1720 PRTEST 1000 06/19/2023 24/PK EF-R 10 230619 7 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1255 PRTEST 1000 01/15/2023 EACH EF-R 10 230115 1 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1327 PRTEST 1000 02/08/2023 EACH EF-R 10 230208 2 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1381 PRTEST 1000 02/26/2023 EACH EF-R 10 230226 3 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 2101.1067 BUF.R1S1 27 02/27/2022 EACH EF-R 10 220227 4 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 2101.1067 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227 5 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1429 PRTEST 1000 03/14/2023 EACH EF-R 10 230314 6 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 2007-057 VLM 52 03/31/2023 EACH EF-R 10 230331 7 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 2007-060 VLM 348 03/31/2023 EACH EF-R 10 230331 8 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1483 PRTEST 1000 04/01/2023 EACH EF-R 10 230401 9 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1531 PRTEST 1000 04/17/2023 EACH EF-R 10 230417 10 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 2006-123 VLM 134 04/30/2023 EACH EF-R 10 230430 11 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1576 PRTEST 1000 05/02/2023 EACH EF-R 10 230502 12 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1627 PRTEST 1000 05/19/2023 EACH EF-R 10 230519 13 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1675 PRTEST 1000 06/04/2023 EACH EF-R 10 230604 14 NULL
100047 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/08/2021 1 0 1 LOT#1708 PRTEST 1000 06/15/2023 EACH EF-R 10 230615 15 NULL
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 2101.1069 BUF.R1S1 13 02/27/2022 EACH EF-R 10 220227 1 NULL
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 2101.1069 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227 2 NULL
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 LOT#1432 PRTEST 1000 03/15/2023 EACH EF-R 10 230315 3 NULL
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 LOT#1486 PRTEST 1000 04/02/2023 EACH EF-R 10 230402 4 NULL
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 LOT#1534 PRTEST 1000 04/18/2023 EACH EF-R 10 230418 5 NULL
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 LOT#1579 PRTEST 1000 05/03/2023 EACH EF-R 10 230503 6 NULL
100047 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/08/2021 1 0 1 LOT#1726 PRTEST 1000 06/21/2023 EACH EF-R 10 230621 7 NULL
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 LOT#1264 PRTEST 1000 01/18/2023 24/PK EF-R 10 230118 1 NULL
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 LOT#1336 PRTEST 1000 02/11/2023 24/PK EF-R 10 230211 2 NULL
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 2101.1075 BUF.R1S1 11 02/27/2022 24/PK EF-R 10 220227 3 NULL
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 2101.1075 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227 4 NULL
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 LOT#1390 PRTEST 1000 03/01/2023 24/PK EF-R 10 230301 5 NULL
100047 30.729 Sterile Square Media Bottle (PETG), 60mL 06/08/2021 1 0 1 LOT#1489 PRTEST 1000 04/03/2023 24/PK EF-R 10 230403 6 NULL
100047 50.096 QC Hold Label (Sheet) 06/08/2021 20 0 20 LOT#1279 PRTEST 1000 01/23/2023 EACH EF-R 10 230123 1 3
100047 50.096 QC Hold Label (Sheet) 06/08/2021 20 0 20 LOT#1357 PRTEST 1000 02/18/2023 EACH EF-R 10 230218 2 3
100047 50.096 QC Hold Label (Sheet) 06/08/2021 20 0 20 2101.1099 BUF.R1S1 11 02/27/2022 EACH EF-R 10 220227 3 3
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 LOT#1282 PRTEST 1000 01/24/2023 EACH EF-R 10 230124 1 2
100047 65.004 Water for Injection USP 06/08/2021 34 0 34 2101.1101 BUF.R1S1 20 02/27/2022 EACH EF-R 10 220227 2 2
100055 10.005Q HEPES Buffer Solution, 1 M (2 to 8 C) (100ml) 06/13/2021 40 3 37 2101.1005 BUF.R2S2 14 02/27/2022 100MLBTL EF-R 10 220227 1 1
100055 10.115A Sucrose Crystal NF, 500g 06/13/2021 500 0 500 2101.1013 BUF.R1S1 3 02/27/2022 500G EF-R 10 220227 1 1
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1237 PRTEST 1000 01/05/2023 50/BAG EF-R 10 230105 1 NULL
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1300 PRTEST 1000 01/30/2023 50/BAG EF-R 10 230130 2 NULL
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1363 PRTEST 1000 02/20/2023 50/BAG EF-R 10 230220 3 NULL
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 2101.1041 BUF.R1S1 27 02/27/2022 50/BAG EF-R 10 220227 4 NULL
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 2101.1041 BUF.R2S2 15 02/27/2022 50/BAG EF-R 10 220227 5 NULL
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1414 PRTEST 1000 03/09/2023 50/BAG EF-R 10 230309 6 NULL
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1468 PRTEST 1000 03/27/2023 50/BAG EF-R 10 230327 7 NULL
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1516 PRTEST 1000 04/12/2023 50/BAG EF-R 10 230412 8 NULL
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1561 PRTEST 1000 04/27/2023 50/BAG EF-R 10 230427 9 NULL
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1612 PRTEST 1000 05/14/2023 50/BAG EF-R 10 230514 10 NULL
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1660 PRTEST 1000 05/30/2023 50/BAG EF-R 10 230530 11 NULL
100055 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1714 PRTEST 1000 06/17/2023 50/BAG EF-R 10 230617 12 NULL
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1240 PRTEST 1000 01/08/2023 25/BAG EF-R 10 230108 1 NULL
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1303 PRTEST 1000 01/31/2023 25/BAG EF-R 10 230131 2 NULL
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1366 PRTEST 1000 02/21/2023 25/BAG EF-R 10 230221 3 NULL
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 2101.1043 BUF.R1S1 25 02/27/2022 25/BAG EF-R 10 220227 4 NULL
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 2101.1043 BUF.R2S2 15 02/27/2022 25/BAG EF-R 10 220227 5 NULL
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1417 PRTEST 1000 03/10/2023 25/BAG EF-R 10 230310 6 NULL
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1471 PRTEST 1000 03/28/2023 25/BAG EF-R 10 230328 7 NULL
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1519 PRTEST 1000 04/13/2023 25/BAG EF-R 10 230413 8 NULL
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1564 PRTEST 1000 04/28/2023 25/BAG EF-R 10 230428 9 NULL
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1615 PRTEST 1000 05/15/2023 25/BAG EF-R 10 230515 10 NULL
100055 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1663 PRTEST 1000 05/31/2023 25/BAG EF-R 10 230531 11 NULL
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1243 PRTEST 999 01/11/2023 25/PK EF-R 10 230111 1 NULL
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1306 PRTEST 1000 02/01/2023 25/PK EF-R 10 230201 2 NULL
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1369 PRTEST 1000 02/22/2023 25/PK EF-R 10 230222 3 NULL
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 2101.1045 BUF.R1S1 26 02/27/2022 25/PK EF-R 10 220227 4 NULL
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 2101.1045 BUF.R2S2 14 02/27/2022 25/PK EF-R 10 220227 5 NULL
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1420 PRTEST 1000 03/11/2023 25/PK EF-R 10 230311 6 NULL
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1474 PRTEST 1000 03/29/2023 25/PK EF-R 10 230329 7 NULL
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1522 PRTEST 1000 04/14/2023 25/PK EF-R 10 230414 8 NULL
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1567 PRTEST 1000 04/29/2023 25/PK EF-R 10 230429 9 NULL
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1618 PRTEST 1000 05/16/2023 25/PK EF-R 10 230516 10 NULL
100055 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1666 PRTEST 1000 06/01/2023 25/PK EF-R 10 230601 11 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1249 PRTEST 997 01/13/2023 EACH EF-R 10 230113 1 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1312 PRTEST 1000 02/03/2023 EACH EF-R 10 230203 2 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1375 PRTEST 1000 02/24/2023 EACH EF-R 10 230224 3 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2101.1055 BUF.R1S1 25 02/27/2022 EACH EF-R 10 220227 4 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2101.1055 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227 5 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1423 PRTEST 1000 03/12/2023 EACH EF-R 10 230312 6 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1477 PRTEST 1000 03/30/2023 EACH EF-R 10 230330 7 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1525 PRTEST 1000 04/15/2023 EACH EF-R 10 230415 8 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2004-073 13-01 115 04/30/2022 EACH EF-R 10 220430 9 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1570 PRTEST 1000 04/30/2023 EACH EF-R 10 230430 10 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1621 PRTEST 1000 05/17/2023 EACH EF-R 10 230517 11 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1669 PRTEST 1000 06/02/2023 EACH EF-R 10 230602 12 NULL
100055 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 1907-083 15-01 44 07/31/2021 EACH EF-R 10 210731 13 NULL
100055 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1318 PRTEST 1000 02/05/2023 12/PK EF-R 10 230205 1 NULL
100055 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 2101.1059 BUF.R1S1 8 02/27/2022 12/PK EF-R 10 220227 2 NULL
100055 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 2101.1059 BUF.R2S2 14 02/27/2022 12/PK EF-R 10 220227 3 NULL
100055 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1480 PRTEST 1000 03/31/2023 12/PK EF-R 10 230331 4 NULL
100055 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1723 PRTEST 1000 06/20/2023 12/PK EF-R 10 230620 5 NULL
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1288 PRTEST 1000 01/26/2023 24/PK EF-R 10 230126 1 NULL
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1321 PRTEST 1000 02/06/2023 24/PK EF-R 10 230206 2 NULL
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 2101.1061 BUF.R1S1 13 02/27/2022 24/PK EF-R 10 220227 3 NULL
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 2101.1061 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227 4 NULL
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1426 PRTEST 1000 03/13/2023 24/PK EF-R 10 230313 5 NULL
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1501 PRTEST 1000 04/07/2023 24/PK EF-R 10 230407 6 NULL
100055 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1720 PRTEST 1000 06/19/2023 24/PK EF-R 10 230619 7 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1255 PRTEST 1000 01/15/2023 EACH EF-R 10 230115 1 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1327 PRTEST 1000 02/08/2023 EACH EF-R 10 230208 2 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1381 PRTEST 1000 02/26/2023 EACH EF-R 10 230226 3 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2101.1067 BUF.R1S1 27 02/27/2022 EACH EF-R 10 220227 4 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2101.1067 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227 5 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1429 PRTEST 1000 03/14/2023 EACH EF-R 10 230314 6 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2007-057 VLM 52 03/31/2023 EACH EF-R 10 230331 7 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2007-060 VLM 348 03/31/2023 EACH EF-R 10 230331 8 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1483 PRTEST 1000 04/01/2023 EACH EF-R 10 230401 9 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1531 PRTEST 1000 04/17/2023 EACH EF-R 10 230417 10 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2006-123 VLM 134 04/30/2023 EACH EF-R 10 230430 11 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1576 PRTEST 1000 05/02/2023 EACH EF-R 10 230502 12 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1627 PRTEST 1000 05/19/2023 EACH EF-R 10 230519 13 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1675 PRTEST 1000 06/04/2023 EACH EF-R 10 230604 14 NULL
100055 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1708 PRTEST 1000 06/15/2023 EACH EF-R 10 230615 15 NULL
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 2101.1069 BUF.R1S1 13 02/27/2022 EACH EF-R 10 220227 1 NULL
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 2101.1069 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227 2 NULL
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1432 PRTEST 1000 03/15/2023 EACH EF-R 10 230315 3 NULL
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1486 PRTEST 1000 04/02/2023 EACH EF-R 10 230402 4 NULL
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1534 PRTEST 1000 04/18/2023 EACH EF-R 10 230418 5 NULL
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1579 PRTEST 1000 05/03/2023 EACH EF-R 10 230503 6 NULL
100055 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1726 PRTEST 1000 06/21/2023 EACH EF-R 10 230621 7 NULL
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1264 PRTEST 1000 01/18/2023 24/PK EF-R 10 230118 1 NULL
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1336 PRTEST 1000 02/11/2023 24/PK EF-R 10 230211 2 NULL
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 2101.1075 BUF.R1S1 11 02/27/2022 24/PK EF-R 10 220227 3 NULL
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 2101.1075 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227 4 NULL
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1390 PRTEST 1000 03/01/2023 24/PK EF-R 10 230301 5 NULL
100055 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1489 PRTEST 1000 04/03/2023 24/PK EF-R 10 230403 6 NULL
100055 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1279 PRTEST 1000 01/23/2023 EACH EF-R 10 230123 1 3
100055 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1357 PRTEST 1000 02/18/2023 EACH EF-R 10 230218 2 3
100055 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 2101.1099 BUF.R1S1 11 02/27/2022 EACH EF-R 10 220227 3 3
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1282 PRTEST 1000 01/24/2023 EACH EF-R 10 230124 1 2
100055 65.004 Water for Injection USP 06/13/2021 34 0 34 2101.1101 BUF.R1S1 20 02/27/2022 EACH EF-R 10 220227 2 2
100056 10.005Q HEPES Buffer Solution, 1 M (2 to 8 C) (100ml) 06/13/2021 40 0 40 2101.1005 BUF.R2S2 14 02/27/2022 100MLBTL EF-R 10 220227 1 1
100056 10.084B 0.5N NaOH, Sterile (1L) 06/13/2021 1000 2 999 2101.1009 BUF.R2S2 15 02/27/2022 ML EF-R 10 220227 1 1
100056 10.093 Potassium Chloride, USP, BP/EP, 250g 06/13/2021 1 0 1 2101.1011 BUF.R1S1 1 02/27/2022 250g EF-R 10 220227 1 1
100056 10.115A Sucrose Crystal NF, 500g 06/13/2021 500 0 500 2101.1013 BUF.R1S1 3 02/27/2022 500G EF-R 10 220227 1 1
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 2101.1015 BUF.R1S1 11 02/27/2022 1L BTL EF-R 10 220227 1 NULL
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 2101.1015 BUF.R2S2 14 02/27/2022 1L BTL EF-R 10 220227 2 NULL
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 LOT#1465 PRTEST 1000 03/26/2023 1L BTL EF-R 10 230326 3 NULL
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 LOT#1510 PRTEST 1000 04/10/2023 1L BTL EF-R 10 230410 4 NULL
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 LOT#1558 PRTEST 1000 04/26/2023 1L BTL EF-R 10 230426 5 NULL
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 LOT#1606 PRTEST 1000 05/12/2023 1L BTL EF-R 10 230512 6 NULL
100056 10.121B 5 M NaCl, Sterile (1L) 06/13/2021 3 0 3 LOT#1654 PRTEST 1000 05/28/2023 1L BTL EF-R 10 230528 7 NULL
100056 10.264A Sodium Phosphate, Dibasic, Heptahydrate, USP (500G) 06/13/2021 1 0 1 2101.1021 BUF.R1S1 1 02/27/2022 500G EF-R 10 220227 1 1
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1237 PRTEST 1000 01/05/2023 50/BAG EF-R 10 230105 1 NULL
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1300 PRTEST 1000 01/30/2023 50/BAG EF-R 10 230130 2 NULL
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1363 PRTEST 1000 02/20/2023 50/BAG EF-R 10 230220 3 NULL
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 2101.1041 BUF.R1S1 27 02/27/2022 50/BAG EF-R 10 220227 4 NULL
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 2101.1041 BUF.R2S2 15 02/27/2022 50/BAG EF-R 10 220227 5 NULL
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1414 PRTEST 1000 03/09/2023 50/BAG EF-R 10 230309 6 NULL
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1468 PRTEST 1000 03/27/2023 50/BAG EF-R 10 230327 7 NULL
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1516 PRTEST 1000 04/12/2023 50/BAG EF-R 10 230412 8 NULL
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1561 PRTEST 1000 04/27/2023 50/BAG EF-R 10 230427 9 NULL
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1612 PRTEST 1000 05/14/2023 50/BAG EF-R 10 230514 10 NULL
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1660 PRTEST 1000 05/30/2023 50/BAG EF-R 10 230530 11 NULL
100056 30.005 Serological Pipet, 25 mL 06/13/2021 1 0 1 LOT#1714 PRTEST 1000 06/17/2023 50/BAG EF-R 10 230617 12 NULL
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1240 PRTEST 1000 01/08/2023 25/BAG EF-R 10 230108 1 NULL
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1303 PRTEST 1000 01/31/2023 25/BAG EF-R 10 230131 2 NULL
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1366 PRTEST 1000 02/21/2023 25/BAG EF-R 10 230221 3 NULL
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 2101.1043 BUF.R1S1 25 02/27/2022 25/BAG EF-R 10 220227 4 NULL
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 2101.1043 BUF.R2S2 15 02/27/2022 25/BAG EF-R 10 220227 5 NULL
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1417 PRTEST 1000 03/10/2023 25/BAG EF-R 10 230310 6 NULL
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1471 PRTEST 1000 03/28/2023 25/BAG EF-R 10 230328 7 NULL
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1519 PRTEST 1000 04/13/2023 25/BAG EF-R 10 230413 8 NULL
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1564 PRTEST 1000 04/28/2023 25/BAG EF-R 10 230428 9 NULL
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1615 PRTEST 1000 05/15/2023 25/BAG EF-R 10 230515 10 NULL
100056 30.006 Serological Pipet, 50 mL 06/13/2021 1 0 1 LOT#1663 PRTEST 1000 05/31/2023 25/BAG EF-R 10 230531 11 NULL
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1243 PRTEST 999 01/11/2023 25/PK EF-R 10 230111 1 NULL
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1306 PRTEST 1000 02/01/2023 25/PK EF-R 10 230201 2 NULL
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1369 PRTEST 1000 02/22/2023 25/PK EF-R 10 230222 3 NULL
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 2101.1045 BUF.R1S1 26 02/27/2022 25/PK EF-R 10 220227 4 NULL
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 2101.1045 BUF.R2S2 14 02/27/2022 25/PK EF-R 10 220227 5 NULL
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1420 PRTEST 1000 03/11/2023 25/PK EF-R 10 230311 6 NULL
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1474 PRTEST 1000 03/29/2023 25/PK EF-R 10 230329 7 NULL
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1522 PRTEST 1000 04/14/2023 25/PK EF-R 10 230414 8 NULL
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1567 PRTEST 1000 04/29/2023 25/PK EF-R 10 230429 9 NULL
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1618 PRTEST 1000 05/16/2023 25/PK EF-R 10 230516 10 NULL
100056 30.014 Centrifuge Tube, 50 mL 06/13/2021 1 0 1 LOT#1666 PRTEST 1000 06/01/2023 25/PK EF-R 10 230601 11 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1249 PRTEST 997 01/13/2023 EACH EF-R 10 230113 1 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1312 PRTEST 1000 02/03/2023 EACH EF-R 10 230203 2 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1375 PRTEST 1000 02/24/2023 EACH EF-R 10 230224 3 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2101.1055 BUF.R1S1 25 02/27/2022 EACH EF-R 10 220227 4 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2101.1055 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227 5 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1423 PRTEST 1000 03/12/2023 EACH EF-R 10 230312 6 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1477 PRTEST 1000 03/30/2023 EACH EF-R 10 230330 7 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1525 PRTEST 1000 04/15/2023 EACH EF-R 10 230415 8 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 2004-073 13-01 115 04/30/2022 EACH EF-R 10 220430 9 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1570 PRTEST 1000 04/30/2023 EACH EF-R 10 230430 10 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1621 PRTEST 1000 05/17/2023 EACH EF-R 10 230517 11 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 LOT#1669 PRTEST 1000 06/02/2023 EACH EF-R 10 230602 12 NULL
100056 30.1167 Buffer / Media Prep Inlet Large 06/13/2021 1 0 1 1907-083 15-01 44 07/31/2021 EACH EF-R 10 210731 13 NULL
100056 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1318 PRTEST 1000 02/05/2023 12/PK EF-R 10 230205 1 NULL
100056 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 2101.1059 BUF.R1S1 8 02/27/2022 12/PK EF-R 10 220227 2 NULL
100056 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 2101.1059 BUF.R2S2 14 02/27/2022 12/PK EF-R 10 220227 3 NULL
100056 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1480 PRTEST 1000 03/31/2023 12/PK EF-R 10 230331 4 NULL
100056 30.122 Sterile Square Media Bottle (PETG), 1000mL 06/13/2021 2 0 2 LOT#1723 PRTEST 1000 06/20/2023 12/PK EF-R 10 230620 5 NULL
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1288 PRTEST 1000 01/26/2023 24/PK EF-R 10 230126 1 NULL
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1321 PRTEST 1000 02/06/2023 24/PK EF-R 10 230206 2 NULL
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 2101.1061 BUF.R1S1 13 02/27/2022 24/PK EF-R 10 220227 3 NULL
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 2101.1061 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227 4 NULL
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1426 PRTEST 1000 03/13/2023 24/PK EF-R 10 230313 5 NULL
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1501 PRTEST 1000 04/07/2023 24/PK EF-R 10 230407 6 NULL
100056 30.137 Sterile Square Media Bottle (PETG), 250mL 06/13/2021 1 0 1 LOT#1720 PRTEST 1000 06/19/2023 24/PK EF-R 10 230619 7 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1255 PRTEST 1000 01/15/2023 EACH EF-R 10 230115 1 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1327 PRTEST 1000 02/08/2023 EACH EF-R 10 230208 2 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1381 PRTEST 1000 02/26/2023 EACH EF-R 10 230226 3 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2101.1067 BUF.R1S1 27 02/27/2022 EACH EF-R 10 220227 4 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2101.1067 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227 5 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1429 PRTEST 1000 03/14/2023 EACH EF-R 10 230314 6 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2007-057 VLM 52 03/31/2023 EACH EF-R 10 230331 7 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2007-060 VLM 348 03/31/2023 EACH EF-R 10 230331 8 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1483 PRTEST 1000 04/01/2023 EACH EF-R 10 230401 9 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1531 PRTEST 1000 04/17/2023 EACH EF-R 10 230417 10 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 2006-123 VLM 134 04/30/2023 EACH EF-R 10 230430 11 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1576 PRTEST 1000 05/02/2023 EACH EF-R 10 230502 12 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1627 PRTEST 1000 05/19/2023 EACH EF-R 10 230519 13 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1675 PRTEST 1000 06/04/2023 EACH EF-R 10 230604 14 NULL
100056 30.708 Sartobran P Sterile Midicap, 0.2 µm, 0.2 m² 06/13/2021 1 0 1 LOT#1708 PRTEST 1000 06/15/2023 EACH EF-R 10 230615 15 NULL
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 2101.1069 BUF.R1S1 13 02/27/2022 EACH EF-R 10 220227 1 NULL
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 2101.1069 BUF.R2S2 15 02/27/2022 EACH EF-R 10 220227 2 NULL
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1432 PRTEST 1000 03/15/2023 EACH EF-R 10 230315 3 NULL
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1486 PRTEST 1000 04/02/2023 EACH EF-R 10 230402 4 NULL
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1534 PRTEST 1000 04/18/2023 EACH EF-R 10 230418 5 NULL
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1579 PRTEST 1000 05/03/2023 EACH EF-R 10 230503 6 NULL
100056 30.714 HyQtainer BioProcess Container, Mixtainer, with Powder Port, 50L 06/13/2021 1 0 1 LOT#1726 PRTEST 1000 06/21/2023 EACH EF-R 10 230621 7 NULL
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1264 PRTEST 1000 01/18/2023 24/PK EF-R 10 230118 1 NULL
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1336 PRTEST 1000 02/11/2023 24/PK EF-R 10 230211 2 NULL
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 2101.1075 BUF.R1S1 11 02/27/2022 24/PK EF-R 10 220227 3 NULL
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 2101.1075 BUF.R2S2 15 02/27/2022 24/PK EF-R 10 220227 4 NULL
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1390 PRTEST 1000 03/01/2023 24/PK EF-R 10 230301 5 NULL
100056 30.729 Sterile Square Media Bottle (PETG), 60mL 06/13/2021 1 0 1 LOT#1489 PRTEST 1000 04/03/2023 24/PK EF-R 10 230403 6 NULL
100056 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1279 PRTEST 1000 01/23/2023 EACH EF-R 10 230123 1 3
100056 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 LOT#1357 PRTEST 1000 02/18/2023 EACH EF-R 10 230218 2 3
100056 50.096 QC Hold Label (Sheet) 06/13/2021 20 0 20 2101.1099 BUF.R1S1 11 02/27/2022 EACH EF-R 10 220227 3 3
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 LOT#1282 PRTEST 1000 01/24/2023 EACH EF-R 10 230124 1 2
100056 65.004 Water for Injection USP 06/13/2021 34 0 34 2101.1101 BUF.R1S1 20 02/27/2022 EACH EF-R 10 220227 2 2
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hello Sharath. YES!!!!!!! you got it. It looks like it is working perfectly. I learned so much from the way you worked through this problem. I cannot thank you enough.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
