SAP B1 Check batch or S/n status with TransacNotification on PickList

[Antony31]

Hello, 

I'm trying to block the creation of a picklist when a batch or a serial number has the status 'Locked' (it's a ZU). I've already done it for sales orders, delivery, but for picklists I can't make the link between OPKL and OBTN/OSRN. I try to use OITL and ITL1 like for sales orders or delivery but there is no docType 156 inside OITL and ITL1

SELECT count(*)
FROM OPKL t0
JOIN PKL1 t1 ON t1."AbsEntry"= t0."AbsEntry"
JOIN OITL ON oitl."DocType"=156 AND oitl."DocEntry" =t1."AbsEntry" AND oitl."DocLine"=t1."OrderLine"
JOIN ITL1 ON oitl."LogEntry" = itl1."LogEntry"
JOIN OSRN t3 ON t3."ItemCode"=itl1."ItemCode" AND t3."SysNumber" = itl1."SysNumber"
WHERE t1."AbsEntry"=list_of_cols_val_tab_del AND t3."U_QC_STATUS" = 'LOCKED' ;

Thank you for your help,

Regards,

Antony