/*
09.07.2018
1
Блокиране на партиди
*/
UPDATE PARCEL P1 SET P1.IS_BLOCKED = 'F'
WHERE EXISTS(
SELECT
P.ID
FROM ARTICLE_NZOK AN
INNER JOIN DELIVERY_ITEM DI ON (DI.ARTICLEID = AN.ID)
INNER JOIN PARCEL P ON (P.ID = DI.PARCEL_ID)
WHERE AN.NZOK_CODE IN
(
'CF585'
) AND (DI.QUANTITY_LEFT > 0)
AND (P.ID = P1.ID)
);
UPDATE PARCEL P1 SET P1.IS_BLOCKED = 'T'
WHERE EXISTS(
SELECT
P.ID
FROM ARTICLE_NZOK AN
INNER JOIN DELIVERY_ITEM DI ON (DI.ARTICLEID = AN.ID)
INNER JOIN PARCEL P ON (P.ID = DI.PARCEL_ID)
WHERE AN.NZOK_CODE IN
(
'CI370',
'CI371',
'CI372',
'CI377',
'CI385',
'CI386',
'CI387',
'CI388',
'CI436',
'CI448',
'CI453',
'CI454',
'CI470',
'CI471',
'CI472',
'CI473',
'CI474',
'CI476',
'CI477',
'CI478',
'CI479',
'CI480',
'CI481',
'CK370',
'CK371',
'CK372',
'CK377',
'CK385',
'CK386',
'CK387',
'CK388',
'CK436',
'CK448',
'CK453',
'CK454',
'CK470',
'CK471',
'CK472',
'CK473',
'CK474',
'CK476',
'CK477',
'CK478',
'CK479',
'CK480',
'CK481',
'CV146',
'CV147',
'CV148',
'CV398',
'CV399',
'CV400'
) AND (DI.QUANTITY_LEFT > 0)
AND (P.ID = P1.ID)
);