cancel
Showing results for 
Search instead for 
Did you mean: 

SqlQuery to Check if batch is bloqued

Former Member
0 Kudos

Hi, now that I know how to block batch numbers of a specific item, how can check with an sql query if a particular batch is blocked. In the OIBT table there is a status column but it is set to zero. Iam not blocking the batch number for a specific warehouse, Im blocking it globally, maybe there is another table?

Thank you!

Jose.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Jose,

Yes,

IF Batch No. Status is 0, it means Batch No. is Realeased.


SELECT *  FROM OIBT T0 WHERE T0.Status='0'

IF Batch No. Status is 1, it means Batch No. is Not Accessible.


SELECT *  FROM OIBT T0 WHERE T0.Status='1'

IF Batch No. Status is 2, it means Batch No. is Locked.


SELECT *  FROM OIBT T0 WHERE T0.Status='2'

Regards,

Madhan.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Jose,

Based on the document, if status is 0, it means the batch is released. Status 2 means locked.

Thanks,

Gordon